PREVIEW / etf_30min / 2000-09-26
file: by_date/etf_30min/2000/2000-09-26.parquet size: 11 KB rows: 272
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-09-26 09:30:00 | SPY | ETF | 144.375 | 144.5 | 143.9688 | 144.1562 | 444300.0 |
| 2000-09-26 10:00:00 | SPY | ETF | 144.1875 | 145.0 | 144.0 | 144.625 | 458300.0 |
| 2000-09-26 10:30:00 | SPY | ETF | 144.625 | 144.8125 | 143.75 | 143.8438 | 396200.0 |
| 2000-09-26 11:00:00 | SPY | ETF | 143.8125 | 143.9375 | 143.375 | 143.6562 | 330600.0 |
| 2000-09-26 11:30:00 | SPY | ETF | 143.625 | 143.7812 | 143.375 | 143.75 | 156700.0 |
| 2000-09-26 12:00:00 | SPY | ETF | 143.7188 | 143.8125 | 143.2812 | 143.2812 | 385400.0 |
| 2000-09-26 12:30:00 | SPY | ETF | 143.25 | 143.375 | 143.0312 | 143.1875 | 531300.0 |
| 2000-09-26 13:00:00 | SPY | ETF | 143.1875 | 143.75 | 143.1875 | 143.625 | 148500.0 |
| 2000-09-26 13:30:00 | SPY | ETF | 143.7812 | 144.25 | 143.625 | 143.75 | 122900.0 |
| 2000-09-26 14:00:00 | SPY | ETF | 143.6875 | 143.9062 | 143.5312 | 143.5938 | 102000.0 |
| 2000-09-26 14:30:00 | SPY | ETF | 143.5312 | 143.6562 | 142.7188 | 142.875 | 610700.0 |
| 2000-09-26 15:00:00 | SPY | ETF | 142.8438 | 143.1562 | 142.625 | 142.8125 | 539400.0 |
| 2000-09-26 15:30:00 | SPY | ETF | 142.9375 | 143.4688 | 142.7188 | 142.875 | 579400.0 |
| 2000-09-26 16:00:00 | SPY | ETF | 143.0 | 143.0 | 142.4062 | 142.4062 | 422400.0 |
| 2000-09-26 09:30:00 | QQQ | ETF | 90.75 | 91.125 | 89.8125 | 90.8125 | 3455400.0 |
| 2000-09-26 10:00:00 | QQQ | ETF | 91.0 | 92.5 | 90.5 | 92.0 | 3813900.0 |
| 2000-09-26 10:30:00 | QQQ | ETF | 92.0 | 92.25 | 90.625 | 90.7812 | 2348400.0 |
| 2000-09-26 11:00:00 | QQQ | ETF | 90.6875 | 90.8438 | 90.0 | 90.7188 | 2007000.0 |
| 2000-09-26 11:30:00 | QQQ | ETF | 90.7188 | 90.8438 | 90.1875 | 90.8438 | 963800.0 |
| 2000-09-26 12:00:00 | QQQ | ETF | 90.8438 | 90.9062 | 89.875 | 90.0 | 922000.0 |
| 2000-09-26 12:30:00 | QQQ | ETF | 89.875 | 90.25 | 89.5 | 89.875 | 1594000.0 |
| 2000-09-26 13:00:00 | QQQ | ETF | 89.875 | 90.5938 | 89.875 | 90.5312 | 876900.0 |
| 2000-09-26 13:30:00 | QQQ | ETF | 90.5625 | 91.3438 | 90.3125 | 90.5625 | 1533600.0 |
| 2000-09-26 14:00:00 | QQQ | ETF | 90.5 | 91.0312 | 90.125 | 90.3125 | 947300.0 |
| 2000-09-26 14:30:00 | QQQ | ETF | 90.3125 | 90.4375 | 89.1875 | 89.5 | 1712900.0 |
| 2000-09-26 15:00:00 | QQQ | ETF | 89.5 | 90.0 | 88.9688 | 89.4688 | 2284000.0 |
| 2000-09-26 15:30:00 | QQQ | ETF | 89.5 | 90.25 | 89.0625 | 89.375 | 2481200.0 |
| 2000-09-26 16:00:00 | QQQ | ETF | 89.5 | 89.5 | 88.9375 | 89.125 | 575900.0 |
| 2000-09-26 16:30:00 | QQQ | ETF | 89.125 | 89.25 | 88.9062 | 89.25 | 414200.0 |
| 2000-09-26 17:00:00 | QQQ | ETF | 89.1875 | 89.25 | 89.0 | 89.25 | 2800.0 |
| 2000-09-26 17:30:00 | QQQ | ETF | 89.375 | 89.375 | 89.25 | 89.25 | 2000.0 |
| 2000-09-26 18:00:00 | QQQ | ETF | 89.3125 | 89.4375 | 89.3125 | 89.4375 | 300.0 |
| 2000-09-26 09:30:00 | IWM | ETF | 51.625 | 51.625 | 51.5625 | 51.5625 | 1400.0 |
| 2000-09-26 10:00:00 | IWM | ETF | 51.5938 | 51.625 | 51.5938 | 51.625 | 1600.0 |
| 2000-09-26 11:00:00 | IWM | ETF | 51.4375 | 51.4375 | 51.3281 | 51.3281 | 400.0 |
| 2000-09-26 11:30:00 | IWM | ETF | 51.25 | 51.2812 | 51.25 | 51.2812 | 5200.0 |
| 2000-09-26 12:00:00 | IWM | ETF | 51.2344 | 51.2344 | 51.0312 | 51.0312 | 1400.0 |
| 2000-09-26 12:30:00 | IWM | ETF | 50.9688 | 51.0625 | 50.9688 | 51.0156 | 5800.0 |
| 2000-09-26 13:00:00 | IWM | ETF | 51.125 | 51.125 | 51.125 | 51.125 | 20000.0 |
| 2000-09-26 14:30:00 | IWM | ETF | 50.9688 | 50.9688 | 50.9062 | 50.9688 | 13000.0 |
| 2000-09-26 15:00:00 | IWM | ETF | 51.0 | 51.0 | 50.7812 | 50.9375 | 8600.0 |
| 2000-09-26 15:30:00 | IWM | ETF | 50.9375 | 50.9688 | 50.6562 | 50.6875 | 6800.0 |
| 2000-09-26 16:00:00 | IWM | ETF | 50.9219 | 50.9219 | 50.9219 | 50.9219 | 1000.0 |
| 2000-09-26 09:30:00 | DIA | ETF | 107.75 | 107.75 | 107.1562 | 107.375 | 133800.0 |
| 2000-09-26 10:00:00 | DIA | ETF | 107.375 | 107.9062 | 107.3125 | 107.4375 | 95300.0 |
| 2000-09-26 10:30:00 | DIA | ETF | 107.625 | 107.625 | 107.0 | 107.1875 | 28100.0 |
| 2000-09-26 11:00:00 | DIA | ETF | 107.1875 | 107.2188 | 106.75 | 107.0 | 31100.0 |
| 2000-09-26 11:30:00 | DIA | ETF | 106.9688 | 107.0312 | 106.6875 | 106.875 | 19700.0 |
| 2000-09-26 12:00:00 | DIA | ETF | 107.0 | 107.0625 | 106.5625 | 106.75 | 31800.0 |
| 2000-09-26 12:30:00 | DIA | ETF | 106.625 | 106.8125 | 106.5 | 106.75 | 50400.0 |
> showing 50 of 272 rows — these rows as CSV