PREVIEW / etf_30min / 2000-10-26
file: by_date/etf_30min/2000/2000-10-26.parquet size: 12 KB rows: 297
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-10-26 09:30:00 | SPY | ETF | 137.125 | 137.4688 | 136.5 | 137.0625 | 1027100.0 |
| 2000-10-26 10:00:00 | SPY | ETF | 136.9688 | 137.6562 | 136.4688 | 136.4688 | 398400.0 |
| 2000-10-26 10:30:00 | SPY | ETF | 136.3438 | 136.5 | 135.4062 | 135.5625 | 705700.0 |
| 2000-10-26 11:00:00 | SPY | ETF | 135.625 | 135.75 | 134.5625 | 135.4375 | 721300.0 |
| 2000-10-26 11:30:00 | SPY | ETF | 135.375 | 135.625 | 134.875 | 135.5312 | 314900.0 |
| 2000-10-26 12:00:00 | SPY | ETF | 135.4375 | 136.0938 | 135.25 | 135.3125 | 604500.0 |
| 2000-10-26 12:30:00 | SPY | ETF | 135.3125 | 135.5312 | 135.0625 | 135.375 | 182500.0 |
| 2000-10-26 13:00:00 | SPY | ETF | 135.4062 | 135.4688 | 134.4062 | 134.4375 | 291600.0 |
| 2000-10-26 13:30:00 | SPY | ETF | 134.5 | 135.0 | 134.3125 | 134.6562 | 426500.0 |
| 2000-10-26 14:00:00 | SPY | ETF | 134.5 | 134.8125 | 134.0312 | 134.375 | 270500.0 |
| 2000-10-26 14:30:00 | SPY | ETF | 134.4688 | 135.8438 | 134.0312 | 135.3125 | 673400.0 |
| 2000-10-26 15:00:00 | SPY | ETF | 135.5938 | 137.3438 | 135.3125 | 137.0 | 1075300.0 |
| 2000-10-26 15:30:00 | SPY | ETF | 136.9375 | 137.6562 | 136.5312 | 136.625 | 1188200.0 |
| 2000-10-26 16:00:00 | SPY | ETF | 136.5625 | 136.8125 | 136.0938 | 136.125 | 567500.0 |
| 2000-10-26 16:30:00 | SPY | ETF | 136.6875 | 136.6875 | 136.0 | 136.6875 | 233600.0 |
| 2000-10-26 17:00:00 | SPY | ETF | 135.75 | 136.6875 | 135.75 | 136.6875 | 50800.0 |
| 2000-10-26 09:30:00 | QQQ | ETF | 78.1875 | 78.5 | 76.7812 | 78.25 | 6199800.0 |
| 2000-10-26 10:00:00 | QQQ | ETF | 78.25 | 79.25 | 77.5 | 77.7188 | 4052700.0 |
| 2000-10-26 10:30:00 | QQQ | ETF | 77.6875 | 77.75 | 75.625 | 76.0 | 5035700.0 |
| 2000-10-26 11:00:00 | QQQ | ETF | 76.125 | 76.2812 | 74.625 | 75.5625 | 6593500.0 |
| 2000-10-26 11:30:00 | QQQ | ETF | 75.7188 | 76.125 | 74.7812 | 75.875 | 5208500.0 |
| 2000-10-26 12:00:00 | QQQ | ETF | 75.75 | 77.0938 | 75.5312 | 76.0 | 4754700.0 |
| 2000-10-26 12:30:00 | QQQ | ETF | 75.9688 | 76.25 | 75.25 | 75.8125 | 3202700.0 |
| 2000-10-26 13:00:00 | QQQ | ETF | 75.8125 | 75.875 | 74.25 | 74.4688 | 3746700.0 |
| 2000-10-26 13:30:00 | QQQ | ETF | 74.3438 | 75.0 | 73.75 | 74.5 | 5175700.0 |
| 2000-10-26 14:00:00 | QQQ | ETF | 74.375 | 75.25 | 73.625 | 74.1875 | 3106100.0 |
| 2000-10-26 14:30:00 | QQQ | ETF | 74.125 | 76.9375 | 73.875 | 76.3125 | 6622300.0 |
| 2000-10-26 15:00:00 | QQQ | ETF | 76.3125 | 78.5 | 75.8125 | 78.125 | 5188300.0 |
| 2000-10-26 15:30:00 | QQQ | ETF | 77.875 | 80.0 | 77.625 | 79.0625 | 5980800.0 |
| 2000-10-26 16:00:00 | QQQ | ETF | 79.0625 | 80.25 | 78.9375 | 79.625 | 2517300.0 |
| 2000-10-26 16:30:00 | QQQ | ETF | 79.4375 | 79.625 | 78.0 | 78.625 | 75100.0 |
| 2000-10-26 17:00:00 | QQQ | ETF | 79.0 | 81.0 | 78.75 | 80.5625 | 118100.0 |
| 2000-10-26 17:30:00 | QQQ | ETF | 80.5625 | 81.3125 | 80.25 | 80.875 | 155800.0 |
| 2000-10-26 18:00:00 | QQQ | ETF | 81.0 | 81.1875 | 80.5 | 80.9688 | 22300.0 |
| 2000-10-26 09:30:00 | IWM | ETF | 47.7031 | 47.75 | 47.7031 | 47.75 | 1400.0 |
| 2000-10-26 10:00:00 | IWM | ETF | 47.7812 | 47.8281 | 47.7812 | 47.8281 | 10200.0 |
| 2000-10-26 10:30:00 | IWM | ETF | 47.625 | 47.625 | 47.625 | 47.625 | 200.0 |
| 2000-10-26 11:00:00 | IWM | ETF | 47.3438 | 47.3438 | 46.9688 | 47.25 | 11200.0 |
| 2000-10-26 11:30:00 | IWM | ETF | 47.0 | 47.0 | 47.0 | 47.0 | 200.0 |
| 2000-10-26 12:00:00 | IWM | ETF | 47.1562 | 47.25 | 47.1094 | 47.1094 | 3800.0 |
| 2000-10-26 12:30:00 | IWM | ETF | 46.9375 | 46.9375 | 46.9375 | 46.9375 | 2400.0 |
| 2000-10-26 13:00:00 | IWM | ETF | 47.125 | 47.125 | 46.8906 | 46.9375 | 32000.0 |
| 2000-10-26 13:30:00 | IWM | ETF | 46.9375 | 46.9375 | 46.9375 | 46.9375 | 200.0 |
| 2000-10-26 14:00:00 | IWM | ETF | 46.8438 | 46.8438 | 46.8438 | 46.8438 | 200.0 |
| 2000-10-26 14:30:00 | IWM | ETF | 46.9688 | 47.0938 | 46.9688 | 47.0938 | 12800.0 |
| 2000-10-26 15:00:00 | IWM | ETF | 47.3438 | 47.5938 | 47.3438 | 47.5938 | 4400.0 |
| 2000-10-26 15:30:00 | IWM | ETF | 47.625 | 48.0 | 47.5625 | 48.0 | 17800.0 |
| 2000-10-26 09:30:00 | DIA | ETF | 103.0938 | 103.8125 | 103.0312 | 103.4375 | 135300.0 |
| 2000-10-26 10:00:00 | DIA | ETF | 103.4375 | 103.9688 | 103.1875 | 103.1875 | 153800.0 |
| 2000-10-26 10:30:00 | DIA | ETF | 103.1875 | 103.4688 | 102.75 | 103.0312 | 456300.0 |
> showing 50 of 297 rows — these rows as CSV