PREVIEW / etf_30min / 2002-03-27
file: by_date/etf_30min/2002/2002-03-27.parquet size: 18 KB rows: 473
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2002-03-27 09:30:00 | SPY | ETF | 114.03 | 114.2 | 113.76 | 114.1 | 1275100.0 |
| 2002-03-27 10:00:00 | SPY | ETF | 114.1 | 114.49 | 113.92 | 114.4 | 1823600.0 |
| 2002-03-27 10:30:00 | SPY | ETF | 114.4 | 114.6 | 114.18 | 114.45 | 926100.0 |
| 2002-03-27 11:00:00 | SPY | ETF | 114.45 | 114.62 | 114.29 | 114.48 | 866500.0 |
| 2002-03-27 11:30:00 | SPY | ETF | 114.49 | 114.96 | 114.48 | 114.93 | 1592800.0 |
| 2002-03-27 12:00:00 | SPY | ETF | 114.95 | 114.98 | 114.78 | 114.92 | 679600.0 |
| 2002-03-27 12:30:00 | SPY | ETF | 114.92 | 114.96 | 114.73 | 114.9 | 795000.0 |
| 2002-03-27 13:00:00 | SPY | ETF | 114.9 | 115.01 | 114.64 | 114.69 | 733800.0 |
| 2002-03-27 13:30:00 | SPY | ETF | 114.69 | 114.87 | 114.65 | 114.79 | 502100.0 |
| 2002-03-27 14:00:00 | SPY | ETF | 114.78 | 114.8 | 114.19 | 114.33 | 4223500.0 |
| 2002-03-27 14:30:00 | SPY | ETF | 114.33 | 114.7 | 114.25 | 114.65 | 1433600.0 |
| 2002-03-27 15:00:00 | SPY | ETF | 114.69 | 114.96 | 114.45 | 114.66 | 1941700.0 |
| 2002-03-27 15:30:00 | SPY | ETF | 114.69 | 114.86 | 114.51 | 114.67 | 748300.0 |
| 2002-03-27 16:00:00 | SPY | ETF | 114.71 | 114.8 | 114.5 | 114.5 | 905800.0 |
| 2002-03-27 16:30:00 | SPY | ETF | 114.6 | 114.6 | 114.52 | 114.52 | 200.0 |
| 2002-03-27 17:30:00 | SPY | ETF | 114.47 | 114.47 | 114.47 | 114.47 | 200.0 |
| 2002-03-27 18:00:00 | SPY | ETF | 114.52 | 114.52 | 114.52 | 114.52 | 900.0 |
| 2002-03-27 09:30:00 | QQQ | ETF | 35.63 | 35.8 | 35.46 | 35.63 | 8454600.0 |
| 2002-03-27 10:00:00 | QQQ | ETF | 35.65 | 35.85 | 35.52 | 35.62 | 9552300.0 |
| 2002-03-27 10:30:00 | QQQ | ETF | 35.62 | 35.78 | 35.56 | 35.65 | 4596000.0 |
| 2002-03-27 11:00:00 | QQQ | ETF | 35.65 | 35.8 | 35.6 | 35.71 | 3852600.0 |
| 2002-03-27 11:30:00 | QQQ | ETF | 35.7 | 36.0 | 35.7 | 35.98 | 6535900.0 |
| 2002-03-27 12:00:00 | QQQ | ETF | 35.98 | 36.0 | 35.82 | 35.88 | 2452900.0 |
| 2002-03-27 12:30:00 | QQQ | ETF | 35.87 | 35.93 | 35.71 | 35.88 | 1930800.0 |
| 2002-03-27 13:00:00 | QQQ | ETF | 35.88 | 35.91 | 35.65 | 35.66 | 2294800.0 |
| 2002-03-27 13:30:00 | QQQ | ETF | 35.66 | 35.77 | 35.65 | 35.7 | 2501400.0 |
| 2002-03-27 14:00:00 | QQQ | ETF | 35.7 | 35.74 | 35.42 | 35.53 | 6363900.0 |
| 2002-03-27 14:30:00 | QQQ | ETF | 35.53 | 35.68 | 35.47 | 35.66 | 3035700.0 |
| 2002-03-27 15:00:00 | QQQ | ETF | 35.64 | 35.79 | 35.56 | 35.65 | 4362000.0 |
| 2002-03-27 15:30:00 | QQQ | ETF | 35.67 | 35.83 | 35.62 | 35.76 | 6458700.0 |
| 2002-03-27 16:00:00 | QQQ | ETF | 35.75 | 35.81 | 35.5 | 35.56 | 1193100.0 |
| 2002-03-27 16:30:00 | QQQ | ETF | 35.55 | 35.75 | 35.55 | 35.59 | 95900.0 |
| 2002-03-27 17:00:00 | QQQ | ETF | 35.6 | 35.64 | 35.59 | 35.61 | 27900.0 |
| 2002-03-27 17:30:00 | QQQ | ETF | 35.6 | 35.61 | 35.56 | 35.6 | 22400.0 |
| 2002-03-27 18:00:00 | QQQ | ETF | 35.58 | 35.61 | 35.56 | 35.57 | 12300.0 |
| 2002-03-27 09:30:00 | IWM | ETF | 49.85 | 49.96 | 49.735 | 49.885 | 29600.0 |
| 2002-03-27 10:00:00 | IWM | ETF | 49.95 | 50.125 | 49.95 | 50.075 | 100400.0 |
| 2002-03-27 10:30:00 | IWM | ETF | 50.15 | 50.175 | 50.05 | 50.05 | 86400.0 |
| 2002-03-27 11:00:00 | IWM | ETF | 50.155 | 50.195 | 50.05 | 50.195 | 74000.0 |
| 2002-03-27 11:30:00 | IWM | ETF | 50.115 | 50.295 | 50.11 | 50.25 | 90600.0 |
| 2002-03-27 12:00:00 | IWM | ETF | 50.285 | 50.29 | 50.2 | 50.28 | 3400.0 |
| 2002-03-27 12:30:00 | IWM | ETF | 50.27 | 50.315 | 50.2 | 50.25 | 35200.0 |
| 2002-03-27 13:00:00 | IWM | ETF | 50.27 | 50.27 | 50.18 | 50.18 | 9200.0 |
| 2002-03-27 13:30:00 | IWM | ETF | 50.255 | 50.255 | 50.225 | 50.225 | 2200.0 |
| 2002-03-27 14:00:00 | IWM | ETF | 50.155 | 50.155 | 50.04 | 50.09 | 34200.0 |
| 2002-03-27 14:30:00 | IWM | ETF | 50.115 | 50.165 | 50.06 | 50.165 | 7600.0 |
| 2002-03-27 15:00:00 | IWM | ETF | 50.175 | 50.255 | 50.145 | 50.205 | 69400.0 |
| 2002-03-27 15:30:00 | IWM | ETF | 50.215 | 50.295 | 50.175 | 50.295 | 23600.0 |
| 2002-03-27 16:00:00 | IWM | ETF | 50.295 | 50.32 | 50.295 | 50.32 | 102000.0 |
| 2002-03-27 09:30:00 | DIA | ETF | 103.55 | 103.84 | 103.4 | 103.77 | 630500.0 |
> showing 50 of 473 rows — these rows as CSV