PREVIEW / etf_30min / 2002-01-10
file: by_date/etf_30min/2002/2002-01-10.parquet size: 17 KB rows: 467
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-01-10 09:30:00 | SPY | ETF | 115.69 | 115.95 | 115.38 | 115.7 | 1902900.0 |
| 2002-01-10 10:00:00 | SPY | ETF | 115.66 | 116.02 | 115.53 | 115.63 | 1093300.0 |
| 2002-01-10 10:30:00 | SPY | ETF | 115.65 | 115.78 | 115.3 | 115.73 | 1861800.0 |
| 2002-01-10 11:00:00 | SPY | ETF | 115.7 | 115.93 | 115.62 | 115.73 | 683800.0 |
| 2002-01-10 11:30:00 | SPY | ETF | 115.75 | 115.91 | 115.59 | 115.85 | 464800.0 |
| 2002-01-10 12:00:00 | SPY | ETF | 115.84 | 115.98 | 115.64 | 115.73 | 474600.0 |
| 2002-01-10 12:30:00 | SPY | ETF | 115.72 | 115.73 | 115.53 | 115.7 | 428800.0 |
| 2002-01-10 13:00:00 | SPY | ETF | 115.7 | 115.85 | 115.57 | 115.82 | 577000.0 |
| 2002-01-10 13:30:00 | SPY | ETF | 115.81 | 116.1 | 115.76 | 116.06 | 925000.0 |
| 2002-01-10 14:00:00 | SPY | ETF | 116.06 | 116.16 | 115.87 | 115.98 | 1139900.0 |
| 2002-01-10 14:30:00 | SPY | ETF | 115.94 | 116.35 | 115.81 | 116.3 | 592500.0 |
| 2002-01-10 15:00:00 | SPY | ETF | 116.29 | 116.32 | 115.85 | 115.93 | 1023900.0 |
| 2002-01-10 15:30:00 | SPY | ETF | 115.93 | 115.97 | 115.71 | 115.97 | 763300.0 |
| 2002-01-10 16:00:00 | SPY | ETF | 115.96 | 116.14 | 115.83 | 116.08 | 736500.0 |
| 2002-01-10 16:30:00 | SPY | ETF | 116.05 | 116.11 | 116.04 | 116.11 | 5400.0 |
| 2002-01-10 17:00:00 | SPY | ETF | 116.18 | 116.18 | 116.18 | 116.18 | 3000.0 |
| 2002-01-10 17:30:00 | SPY | ETF | 116.11 | 116.11 | 116.11 | 116.11 | 200.0 |
| 2002-01-10 09:30:00 | QQQ | ETF | 41.17 | 41.25 | 40.68 | 41.09 | 14011500.0 |
| 2002-01-10 10:00:00 | QQQ | ETF | 41.08 | 41.35 | 40.94 | 40.99 | 8596500.0 |
| 2002-01-10 10:30:00 | QQQ | ETF | 40.99 | 41.07 | 40.73 | 41.02 | 8163700.0 |
| 2002-01-10 11:00:00 | QQQ | ETF | 41.03 | 41.22 | 40.93 | 41.04 | 5286300.0 |
| 2002-01-10 11:30:00 | QQQ | ETF | 41.06 | 41.2 | 40.97 | 41.14 | 2290900.0 |
| 2002-01-10 12:00:00 | QQQ | ETF | 41.15 | 41.3 | 41.06 | 41.08 | 3134900.0 |
| 2002-01-10 12:30:00 | QQQ | ETF | 41.09 | 41.11 | 40.93 | 41.06 | 4106400.0 |
| 2002-01-10 13:00:00 | QQQ | ETF | 41.05 | 41.2 | 40.94 | 41.15 | 1457200.0 |
| 2002-01-10 13:30:00 | QQQ | ETF | 41.18 | 41.47 | 41.11 | 41.42 | 5078300.0 |
| 2002-01-10 14:00:00 | QQQ | ETF | 41.4 | 41.53 | 41.31 | 41.35 | 4723300.0 |
| 2002-01-10 14:30:00 | QQQ | ETF | 41.31 | 41.54 | 41.19 | 41.51 | 4395200.0 |
| 2002-01-10 15:00:00 | QQQ | ETF | 41.49 | 41.53 | 41.16 | 41.26 | 4802700.0 |
| 2002-01-10 15:30:00 | QQQ | ETF | 41.27 | 41.28 | 41.08 | 41.24 | 5769000.0 |
| 2002-01-10 16:00:00 | QQQ | ETF | 41.25 | 41.4 | 41.22 | 41.36 | 2225400.0 |
| 2002-01-10 16:30:00 | QQQ | ETF | 41.32 | 41.4 | 41.32 | 41.35 | 31600.0 |
| 2002-01-10 17:00:00 | QQQ | ETF | 41.35 | 41.38 | 41.35 | 41.35 | 5100.0 |
| 2002-01-10 17:30:00 | QQQ | ETF | 41.38 | 41.4 | 41.38 | 41.4 | 5700.0 |
| 2002-01-10 18:00:00 | QQQ | ETF | 41.38 | 41.44 | 41.31 | 41.42 | 33400.0 |
| 2002-01-10 09:30:00 | IWM | ETF | 49.075 | 49.215 | 48.98 | 49.175 | 38000.0 |
| 2002-01-10 10:00:00 | IWM | ETF | 49.245 | 49.245 | 49.135 | 49.205 | 14800.0 |
| 2002-01-10 10:30:00 | IWM | ETF | 49.185 | 49.185 | 49.005 | 49.125 | 29600.0 |
| 2002-01-10 11:00:00 | IWM | ETF | 49.125 | 49.18 | 49.125 | 49.13 | 17000.0 |
| 2002-01-10 11:30:00 | IWM | ETF | 49.165 | 49.165 | 49.1 | 49.1 | 17200.0 |
| 2002-01-10 12:00:00 | IWM | ETF | 49.145 | 49.165 | 49.09 | 49.145 | 7400.0 |
| 2002-01-10 12:30:00 | IWM | ETF | 49.14 | 49.14 | 49.0 | 49.01 | 8800.0 |
| 2002-01-10 13:00:00 | IWM | ETF | 49.07 | 49.11 | 49.07 | 49.11 | 2800.0 |
| 2002-01-10 13:30:00 | IWM | ETF | 49.125 | 49.195 | 49.045 | 49.195 | 51600.0 |
| 2002-01-10 14:00:00 | IWM | ETF | 49.195 | 49.225 | 49.125 | 49.125 | 38800.0 |
| 2002-01-10 14:30:00 | IWM | ETF | 49.185 | 49.25 | 49.13 | 49.25 | 30800.0 |
| 2002-01-10 15:00:00 | IWM | ETF | 49.26 | 49.275 | 49.15 | 49.2 | 56600.0 |
| 2002-01-10 15:30:00 | IWM | ETF | 49.175 | 49.18 | 49.05 | 49.125 | 44200.0 |
| 2002-01-10 16:00:00 | IWM | ETF | 49.3 | 49.3 | 49.145 | 49.145 | 3200.0 |
| 2002-01-10 09:30:00 | DIA | ETF | 100.95 | 101.12 | 100.66 | 100.8 | 534900.0 |
> showing 50 of 467 rows — these rows as CSV