PREVIEW / etf_30min / 2002-03-11
file: by_date/etf_30min/2002/2002-03-11.parquet size: 18 KB rows: 506
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-11 09:30:00 | SPY | ETF | 116.89 | 116.92 | 116.45 | 116.71 | 2667800.0 |
| 2002-03-11 10:00:00 | SPY | ETF | 116.7 | 116.95 | 116.51 | 116.76 | 860100.0 |
| 2002-03-11 10:30:00 | SPY | ETF | 116.78 | 117.04 | 116.57 | 117.04 | 1034400.0 |
| 2002-03-11 11:00:00 | SPY | ETF | 117.02 | 117.09 | 116.83 | 116.86 | 415300.0 |
| 2002-03-11 11:30:00 | SPY | ETF | 116.86 | 116.96 | 116.62 | 116.68 | 660400.0 |
| 2002-03-11 12:00:00 | SPY | ETF | 116.65 | 116.85 | 116.62 | 116.76 | 348600.0 |
| 2002-03-11 12:30:00 | SPY | ETF | 116.77 | 116.92 | 116.72 | 116.85 | 589300.0 |
| 2002-03-11 13:00:00 | SPY | ETF | 116.86 | 116.91 | 116.7 | 116.88 | 777300.0 |
| 2002-03-11 13:30:00 | SPY | ETF | 116.91 | 117.07 | 116.79 | 117.06 | 610700.0 |
| 2002-03-11 14:00:00 | SPY | ETF | 117.07 | 117.51 | 117.06 | 117.42 | 2122800.0 |
| 2002-03-11 14:30:00 | SPY | ETF | 117.46 | 117.8 | 117.38 | 117.74 | 969100.0 |
| 2002-03-11 15:00:00 | SPY | ETF | 117.72 | 117.9 | 117.53 | 117.62 | 868600.0 |
| 2002-03-11 15:30:00 | SPY | ETF | 117.64 | 117.64 | 117.3 | 117.34 | 1199000.0 |
| 2002-03-11 16:00:00 | SPY | ETF | 117.3 | 117.39 | 117.06 | 117.06 | 1763800.0 |
| 2002-03-11 16:30:00 | SPY | ETF | 117.18 | 117.18 | 117.18 | 117.18 | 300.0 |
| 2002-03-11 17:00:00 | SPY | ETF | 117.1 | 117.1 | 117.1 | 117.1 | 10000.0 |
| 2002-03-11 18:00:00 | SPY | ETF | 117.18 | 117.18 | 117.15 | 117.15 | 300.0 |
| 2002-03-11 09:30:00 | QQQ | ETF | 38.35 | 38.43 | 38.17 | 38.26 | 8887300.0 |
| 2002-03-11 10:00:00 | QQQ | ETF | 38.25 | 38.54 | 38.06 | 38.44 | 7034800.0 |
| 2002-03-11 10:30:00 | QQQ | ETF | 38.45 | 38.51 | 38.22 | 38.45 | 4615900.0 |
| 2002-03-11 11:00:00 | QQQ | ETF | 38.46 | 38.52 | 38.28 | 38.28 | 2790300.0 |
| 2002-03-11 11:30:00 | QQQ | ETF | 38.28 | 38.36 | 38.13 | 38.16 | 4132500.0 |
| 2002-03-11 12:00:00 | QQQ | ETF | 38.16 | 38.3 | 38.13 | 38.3 | 1743500.0 |
| 2002-03-11 12:30:00 | QQQ | ETF | 38.28 | 38.38 | 38.24 | 38.33 | 1642100.0 |
| 2002-03-11 13:00:00 | QQQ | ETF | 38.33 | 38.45 | 38.25 | 38.44 | 1706800.0 |
| 2002-03-11 13:30:00 | QQQ | ETF | 38.41 | 38.58 | 38.32 | 38.58 | 2422800.0 |
| 2002-03-11 14:00:00 | QQQ | ETF | 38.55 | 38.85 | 38.5 | 38.75 | 8412400.0 |
| 2002-03-11 14:30:00 | QQQ | ETF | 38.75 | 39.06 | 38.73 | 38.97 | 5534600.0 |
| 2002-03-11 15:00:00 | QQQ | ETF | 39.0 | 39.19 | 38.8 | 38.9 | 11311500.0 |
| 2002-03-11 15:30:00 | QQQ | ETF | 38.9 | 38.91 | 38.61 | 38.66 | 6819400.0 |
| 2002-03-11 16:00:00 | QQQ | ETF | 38.65 | 38.73 | 38.51 | 38.56 | 1326300.0 |
| 2002-03-11 16:30:00 | QQQ | ETF | 38.6 | 38.64 | 38.53 | 38.56 | 34300.0 |
| 2002-03-11 17:00:00 | QQQ | ETF | 38.56 | 38.57 | 38.52 | 38.52 | 26800.0 |
| 2002-03-11 17:30:00 | QQQ | ETF | 38.52 | 38.54 | 38.5 | 38.53 | 11200.0 |
| 2002-03-11 18:00:00 | QQQ | ETF | 38.53 | 38.54 | 38.48 | 38.53 | 32700.0 |
| 2002-03-11 09:30:00 | IWM | ETF | 49.69 | 49.69 | 49.375 | 49.47 | 85200.0 |
| 2002-03-11 10:00:00 | IWM | ETF | 49.45 | 49.47 | 49.27 | 49.44 | 111000.0 |
| 2002-03-11 10:30:00 | IWM | ETF | 49.43 | 49.45 | 49.285 | 49.45 | 94400.0 |
| 2002-03-11 11:00:00 | IWM | ETF | 49.475 | 49.5 | 49.425 | 49.45 | 16600.0 |
| 2002-03-11 11:30:00 | IWM | ETF | 49.47 | 49.47 | 49.415 | 49.43 | 34800.0 |
| 2002-03-11 12:00:00 | IWM | ETF | 49.42 | 49.43 | 49.345 | 49.385 | 48400.0 |
| 2002-03-11 12:30:00 | IWM | ETF | 49.405 | 49.42 | 49.315 | 49.34 | 77800.0 |
| 2002-03-11 13:00:00 | IWM | ETF | 49.4 | 49.42 | 49.38 | 49.415 | 24400.0 |
| 2002-03-11 13:30:00 | IWM | ETF | 49.4 | 49.41 | 49.4 | 49.41 | 3600.0 |
| 2002-03-11 14:00:00 | IWM | ETF | 49.435 | 49.78 | 49.435 | 49.77 | 140200.0 |
| 2002-03-11 14:30:00 | IWM | ETF | 49.76 | 49.875 | 49.76 | 49.875 | 33000.0 |
| 2002-03-11 15:00:00 | IWM | ETF | 49.94 | 49.99 | 49.82 | 49.82 | 55600.0 |
| 2002-03-11 15:30:00 | IWM | ETF | 49.87 | 49.87 | 49.735 | 49.815 | 109800.0 |
| 2002-03-11 16:00:00 | IWM | ETF | 49.78 | 49.8 | 49.7 | 49.775 | 264800.0 |
| 2002-03-11 09:30:00 | DIA | ETF | 105.75 | 105.87 | 105.39 | 105.54 | 1195300.0 |
> showing 50 of 506 rows — these rows as CSV