PREVIEW / etf_30min / 2000-12-15
file: by_date/etf_30min/2000/2000-12-15.parquet size: 13 KB rows: 326
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 |
|---|---|---|---|---|---|---|---|
| 2000-12-15 09:30:00 | SPY | ETF | 133.125 | 133.125 | 131.9375 | 132.1875 | 1544900.0 |
| 2000-12-15 10:00:00 | SPY | ETF | 132.3438 | 132.3438 | 131.5 | 131.6875 | 692800.0 |
| 2000-12-15 10:30:00 | SPY | ETF | 131.75 | 131.875 | 131.125 | 131.7812 | 404300.0 |
| 2000-12-15 11:00:00 | SPY | ETF | 131.875 | 131.9375 | 131.0938 | 131.6875 | 403100.0 |
| 2000-12-15 11:30:00 | SPY | ETF | 131.6875 | 131.9062 | 131.0938 | 131.0938 | 683800.0 |
| 2000-12-15 12:00:00 | SPY | ETF | 131.1875 | 131.25 | 130.5625 | 131.0 | 467500.0 |
| 2000-12-15 12:30:00 | SPY | ETF | 131.0 | 131.0938 | 130.5625 | 131.0938 | 229200.0 |
| 2000-12-15 13:00:00 | SPY | ETF | 131.0938 | 131.4062 | 130.7812 | 131.25 | 350000.0 |
| 2000-12-15 13:30:00 | SPY | ETF | 131.3125 | 131.375 | 130.8125 | 130.8125 | 480500.0 |
| 2000-12-15 14:00:00 | SPY | ETF | 130.8438 | 131.6875 | 130.8125 | 131.6875 | 272700.0 |
| 2000-12-15 14:30:00 | SPY | ETF | 131.5938 | 132.2188 | 131.375 | 131.875 | 767900.0 |
| 2000-12-15 15:00:00 | SPY | ETF | 131.9375 | 133.125 | 131.7812 | 133.0 | 976600.0 |
| 2000-12-15 15:30:00 | SPY | ETF | 132.9688 | 132.9688 | 131.0625 | 131.4375 | 751100.0 |
| 2000-12-15 16:00:00 | SPY | ETF | 131.3125 | 131.4688 | 130.875 | 130.875 | 590600.0 |
| 2000-12-15 16:30:00 | SPY | ETF | 130.75 | 131.0 | 130.75 | 131.0 | 1300.0 |
| 2000-12-15 09:30:00 | QQQ | ETF | 64.25 | 64.875 | 63.375 | 63.7188 | 7274700.0 |
| 2000-12-15 10:00:00 | QQQ | ETF | 63.75 | 63.8125 | 62.9375 | 63.25 | 5387500.0 |
| 2000-12-15 10:30:00 | QQQ | ETF | 63.125 | 64.0 | 63.0 | 63.9375 | 4462100.0 |
| 2000-12-15 11:00:00 | QQQ | ETF | 63.9375 | 64.3125 | 63.25 | 63.75 | 2817300.0 |
| 2000-12-15 11:30:00 | QQQ | ETF | 63.75 | 64.125 | 63.0 | 63.1875 | 2729000.0 |
| 2000-12-15 12:00:00 | QQQ | ETF | 63.25 | 63.375 | 62.875 | 63.375 | 3337100.0 |
| 2000-12-15 12:30:00 | QQQ | ETF | 63.375 | 63.375 | 62.625 | 63.125 | 2435200.0 |
| 2000-12-15 13:00:00 | QQQ | ETF | 63.125 | 63.5 | 62.8125 | 63.1875 | 2878900.0 |
| 2000-12-15 13:30:00 | QQQ | ETF | 63.125 | 63.3438 | 62.625 | 62.75 | 2164100.0 |
| 2000-12-15 14:00:00 | QQQ | ETF | 62.75 | 63.625 | 62.5625 | 63.5625 | 2673300.0 |
| 2000-12-15 14:30:00 | QQQ | ETF | 63.5625 | 64.2188 | 63.3125 | 63.7812 | 4361800.0 |
| 2000-12-15 15:00:00 | QQQ | ETF | 63.625 | 65.625 | 63.625 | 65.4062 | 6146600.0 |
| 2000-12-15 15:30:00 | QQQ | ETF | 65.25 | 65.5 | 63.375 | 63.8125 | 7651500.0 |
| 2000-12-15 16:00:00 | QQQ | ETF | 63.6875 | 64.375 | 63.625 | 64.0625 | 2094900.0 |
| 2000-12-15 16:30:00 | QQQ | ETF | 64.0 | 64.0625 | 63.6875 | 64.0625 | 225000.0 |
| 2000-12-15 17:00:00 | QQQ | ETF | 64.0625 | 64.1562 | 63.9375 | 64.0 | 19000.0 |
| 2000-12-15 17:30:00 | QQQ | ETF | 64.0 | 64.375 | 64.0 | 64.375 | 3700.0 |
| 2000-12-15 18:00:00 | QQQ | ETF | 64.375 | 64.5 | 64.3125 | 64.375 | 7300.0 |
| 2000-12-15 09:30:00 | IWM | ETF | 45.3438 | 45.6562 | 45.3281 | 45.3281 | 12000.0 |
| 2000-12-15 10:00:00 | IWM | ETF | 45.3438 | 45.5156 | 45.3281 | 45.5 | 2000.0 |
| 2000-12-15 10:30:00 | IWM | ETF | 45.3125 | 45.3125 | 45.125 | 45.125 | 46200.0 |
| 2000-12-15 11:00:00 | IWM | ETF | 45.25 | 45.2812 | 45.1094 | 45.1875 | 9200.0 |
| 2000-12-15 11:30:00 | IWM | ETF | 45.3438 | 45.375 | 45.0 | 45.0 | 52800.0 |
| 2000-12-15 12:00:00 | IWM | ETF | 45.0625 | 45.1406 | 45.0625 | 45.1406 | 21000.0 |
| 2000-12-15 12:30:00 | IWM | ETF | 45.1406 | 45.1562 | 45.0312 | 45.1562 | 12800.0 |
| 2000-12-15 13:00:00 | IWM | ETF | 45.125 | 45.125 | 45.0938 | 45.0938 | 20200.0 |
| 2000-12-15 13:30:00 | IWM | ETF | 45.2812 | 45.2812 | 45.0312 | 45.0312 | 8800.0 |
| 2000-12-15 14:00:00 | IWM | ETF | 45.1719 | 45.3438 | 45.1719 | 45.3125 | 24000.0 |
| 2000-12-15 14:30:00 | IWM | ETF | 45.3438 | 45.5312 | 45.3438 | 45.5 | 48600.0 |
| 2000-12-15 15:00:00 | IWM | ETF | 45.5 | 45.7031 | 45.5 | 45.6719 | 38200.0 |
| 2000-12-15 15:30:00 | IWM | ETF | 45.625 | 45.625 | 45.4375 | 45.4375 | 20200.0 |
| 2000-12-15 16:00:00 | IWM | ETF | 45.625 | 45.625 | 45.625 | 45.625 | 10000.0 |
| 2000-12-15 09:30:00 | DIA | ETF | 105.75 | 106.25 | 105.25 | 105.4375 | 175300.0 |
| 2000-12-15 10:00:00 | DIA | ETF | 105.4375 | 105.75 | 105.0938 | 105.1562 | 114500.0 |
| 2000-12-15 10:30:00 | DIA | ETF | 105.375 | 105.4062 | 104.7812 | 105.1875 | 202000.0 |
> showing 50 of 326 rows — these rows as CSV