PREVIEW / etf_30min / 2000-09-22
file: by_date/etf_30min/2000/2000-09-22.parquet size: 11 KB rows: 282
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-22 09:30:00 | SPY | ETF | 142.625 | 143.3125 | 142.4062 | 142.875 | 1136500.0 |
| 2000-09-22 10:00:00 | SPY | ETF | 142.75 | 143.5 | 142.625 | 142.9688 | 989100.0 |
| 2000-09-22 10:30:00 | SPY | ETF | 142.8125 | 143.75 | 142.7812 | 143.5 | 813000.0 |
| 2000-09-22 11:00:00 | SPY | ETF | 143.4375 | 143.5 | 143.0 | 143.4688 | 127600.0 |
| 2000-09-22 11:30:00 | SPY | ETF | 143.375 | 143.4688 | 142.875 | 143.0 | 138900.0 |
| 2000-09-22 12:00:00 | SPY | ETF | 143.0 | 143.2812 | 142.875 | 143.1875 | 111300.0 |
| 2000-09-22 12:30:00 | SPY | ETF | 143.125 | 143.125 | 142.75 | 142.875 | 313100.0 |
| 2000-09-22 13:00:00 | SPY | ETF | 142.9375 | 143.375 | 142.8125 | 143.25 | 135800.0 |
| 2000-09-22 13:30:00 | SPY | ETF | 143.2188 | 143.625 | 143.125 | 143.625 | 307100.0 |
| 2000-09-22 14:00:00 | SPY | ETF | 143.5625 | 143.9688 | 143.5625 | 143.625 | 539200.0 |
| 2000-09-22 14:30:00 | SPY | ETF | 143.5625 | 144.0312 | 143.25 | 144.0 | 608300.0 |
| 2000-09-22 15:00:00 | SPY | ETF | 144.0625 | 144.875 | 143.8438 | 144.875 | 815200.0 |
| 2000-09-22 15:30:00 | SPY | ETF | 144.8438 | 145.1562 | 144.6875 | 145.1562 | 1037700.0 |
| 2000-09-22 16:00:00 | SPY | ETF | 145.1562 | 145.3125 | 145.0312 | 145.2812 | 706400.0 |
| 2000-09-22 09:30:00 | QQQ | ETF | 87.625 | 90.25 | 87.5 | 89.5312 | 9629700.0 |
| 2000-09-22 10:00:00 | QQQ | ETF | 89.5 | 90.5 | 88.875 | 89.1875 | 4714600.0 |
| 2000-09-22 10:30:00 | QQQ | ETF | 89.125 | 90.75 | 89.125 | 90.3125 | 2604700.0 |
| 2000-09-22 11:00:00 | QQQ | ETF | 90.3125 | 90.5938 | 89.875 | 90.3125 | 1673900.0 |
| 2000-09-22 11:30:00 | QQQ | ETF | 90.3125 | 90.4062 | 89.8125 | 90.0625 | 1187800.0 |
| 2000-09-22 12:00:00 | QQQ | ETF | 90.0938 | 90.5 | 89.75 | 90.2188 | 479900.0 |
| 2000-09-22 12:30:00 | QQQ | ETF | 90.2188 | 90.2188 | 89.375 | 89.6875 | 942700.0 |
| 2000-09-22 13:00:00 | QQQ | ETF | 89.7188 | 90.4375 | 89.625 | 90.1875 | 2169800.0 |
| 2000-09-22 13:30:00 | QQQ | ETF | 90.1875 | 90.75 | 90.0625 | 90.7188 | 832600.0 |
| 2000-09-22 14:00:00 | QQQ | ETF | 90.75 | 91.1875 | 90.625 | 90.8438 | 1551100.0 |
| 2000-09-22 14:30:00 | QQQ | ETF | 90.875 | 91.125 | 90.3125 | 91.0938 | 1459100.0 |
| 2000-09-22 15:00:00 | QQQ | ETF | 91.0938 | 91.875 | 91.0 | 91.6875 | 2532700.0 |
| 2000-09-22 15:30:00 | QQQ | ETF | 91.75 | 92.4688 | 91.625 | 92.1875 | 2952300.0 |
| 2000-09-22 16:00:00 | QQQ | ETF | 92.3438 | 93.25 | 92.1875 | 93.25 | 770200.0 |
| 2000-09-22 16:30:00 | QQQ | ETF | 93.0 | 93.25 | 92.9375 | 93.25 | 56300.0 |
| 2000-09-22 17:00:00 | QQQ | ETF | 93.0 | 93.125 | 93.0 | 93.0625 | 1900.0 |
| 2000-09-22 17:30:00 | QQQ | ETF | 93.25 | 93.25 | 92.9688 | 92.9688 | 700.0 |
| 2000-09-22 18:00:00 | QQQ | ETF | 92.9375 | 92.9375 | 92.9375 | 92.9375 | 100.0 |
| 2000-09-22 09:30:00 | IWM | ETF | 50.0 | 50.5 | 50.0 | 50.5 | 44600.0 |
| 2000-09-22 10:00:00 | IWM | ETF | 50.375 | 50.625 | 50.2812 | 50.3438 | 9000.0 |
| 2000-09-22 10:30:00 | IWM | ETF | 50.3438 | 50.875 | 50.3281 | 50.75 | 1200.0 |
| 2000-09-22 11:00:00 | IWM | ETF | 50.7344 | 51.0156 | 50.7344 | 51.0156 | 2400.0 |
| 2000-09-22 11:30:00 | IWM | ETF | 51.0312 | 51.0312 | 50.7344 | 50.7344 | 60800.0 |
| 2000-09-22 12:00:00 | IWM | ETF | 50.9688 | 50.9688 | 50.9688 | 50.9688 | 400.0 |
| 2000-09-22 12:30:00 | IWM | ETF | 50.9375 | 50.9375 | 50.9375 | 50.9375 | 1200.0 |
| 2000-09-22 13:30:00 | IWM | ETF | 50.9688 | 51.0625 | 50.8906 | 51.0625 | 2200.0 |
| 2000-09-22 14:00:00 | IWM | ETF | 51.0 | 51.2031 | 51.0 | 51.0938 | 1600.0 |
| 2000-09-22 14:30:00 | IWM | ETF | 51.2344 | 51.2344 | 51.0 | 51.0 | 600.0 |
| 2000-09-22 15:00:00 | IWM | ETF | 51.3125 | 51.3125 | 51.3125 | 51.3125 | 600.0 |
| 2000-09-22 15:30:00 | IWM | ETF | 51.5312 | 51.5938 | 51.5312 | 51.5938 | 3000.0 |
| 2000-09-22 09:30:00 | DIA | ETF | 106.1875 | 106.7188 | 106.0 | 106.0625 | 483200.0 |
| 2000-09-22 10:00:00 | DIA | ETF | 106.25 | 106.75 | 106.125 | 106.3125 | 242100.0 |
| 2000-09-22 10:30:00 | DIA | ETF | 106.3125 | 107.0625 | 106.3125 | 106.7188 | 64000.0 |
| 2000-09-22 11:00:00 | DIA | ETF | 106.8438 | 106.9688 | 106.4688 | 106.7812 | 142900.0 |
| 2000-09-22 11:30:00 | DIA | ETF | 106.9062 | 106.9062 | 106.375 | 106.5625 | 56200.0 |
| 2000-09-22 12:00:00 | DIA | ETF | 106.625 | 106.8125 | 106.5 | 106.75 | 7600.0 |
> showing 50 of 282 rows — these rows as CSV