PREVIEW / etf_1hour / 2000-09-22
file: by_date/etf_1hour/2000/2000-09-22.parquet size: 9 KB rows: 176
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:00:00 | SPY | ETF | 142.625 | 143.3125 | 142.4062 | 142.875 | 1136500.0 |
| 2000-09-22 10:00:00 | SPY | ETF | 142.75 | 143.75 | 142.625 | 143.5 | 1802100.0 |
| 2000-09-22 11:00:00 | SPY | ETF | 143.4375 | 143.5 | 142.875 | 143.0 | 266500.0 |
| 2000-09-22 12:00:00 | SPY | ETF | 143.0 | 143.2812 | 142.75 | 142.875 | 424400.0 |
| 2000-09-22 13:00:00 | SPY | ETF | 142.9375 | 143.625 | 142.8125 | 143.625 | 442900.0 |
| 2000-09-22 14:00:00 | SPY | ETF | 143.5625 | 144.0312 | 143.25 | 144.0 | 1147500.0 |
| 2000-09-22 15:00:00 | SPY | ETF | 144.0625 | 145.1562 | 143.8438 | 145.1562 | 1852900.0 |
| 2000-09-22 16:00:00 | SPY | ETF | 145.1562 | 145.3125 | 145.0312 | 145.2812 | 706400.0 |
| 2000-09-22 09:00:00 | QQQ | ETF | 87.625 | 90.25 | 87.5 | 89.5312 | 9629700.0 |
| 2000-09-22 10:00:00 | QQQ | ETF | 89.5 | 90.75 | 88.875 | 90.3125 | 7319300.0 |
| 2000-09-22 11:00:00 | QQQ | ETF | 90.3125 | 90.5938 | 89.8125 | 90.0625 | 2861700.0 |
| 2000-09-22 12:00:00 | QQQ | ETF | 90.0938 | 90.5 | 89.375 | 89.6875 | 1422600.0 |
| 2000-09-22 13:00:00 | QQQ | ETF | 89.7188 | 90.75 | 89.625 | 90.7188 | 3002400.0 |
| 2000-09-22 14:00:00 | QQQ | ETF | 90.75 | 91.1875 | 90.3125 | 91.0938 | 3010200.0 |
| 2000-09-22 15:00:00 | QQQ | ETF | 91.0938 | 92.4688 | 91.0 | 92.1875 | 5485000.0 |
| 2000-09-22 16:00:00 | QQQ | ETF | 92.3438 | 93.25 | 92.1875 | 93.25 | 826500.0 |
| 2000-09-22 17:00:00 | QQQ | ETF | 93.0 | 93.25 | 92.9688 | 92.9688 | 2600.0 |
| 2000-09-22 18:00:00 | QQQ | ETF | 92.9375 | 92.9375 | 92.9375 | 92.9375 | 100.0 |
| 2000-09-22 09:00:00 | IWM | ETF | 50.0 | 50.5 | 50.0 | 50.5 | 44600.0 |
| 2000-09-22 10:00:00 | IWM | ETF | 50.375 | 50.875 | 50.2812 | 50.75 | 10200.0 |
| 2000-09-22 11:00:00 | IWM | ETF | 50.7344 | 51.0312 | 50.7344 | 50.7344 | 63200.0 |
| 2000-09-22 12:00:00 | IWM | ETF | 50.9688 | 50.9688 | 50.9375 | 50.9375 | 1600.0 |
| 2000-09-22 13:00:00 | IWM | ETF | 50.9688 | 51.0625 | 50.8906 | 51.0625 | 2200.0 |
| 2000-09-22 14:00:00 | IWM | ETF | 51.0 | 51.2344 | 51.0 | 51.0 | 2200.0 |
| 2000-09-22 15:00:00 | IWM | ETF | 51.3125 | 51.5938 | 51.3125 | 51.5938 | 3600.0 |
| 2000-09-22 09:00:00 | DIA | ETF | 106.1875 | 106.7188 | 106.0 | 106.0625 | 483200.0 |
| 2000-09-22 10:00:00 | DIA | ETF | 106.25 | 107.0625 | 106.125 | 106.7188 | 306100.0 |
| 2000-09-22 11:00:00 | DIA | ETF | 106.8438 | 106.9688 | 106.375 | 106.5625 | 199100.0 |
| 2000-09-22 12:00:00 | DIA | ETF | 106.625 | 106.875 | 106.5 | 106.625 | 16500.0 |
| 2000-09-22 13:00:00 | DIA | ETF | 106.6562 | 107.5625 | 106.6562 | 107.5625 | 105400.0 |
| 2000-09-22 14:00:00 | DIA | ETF | 107.5938 | 108.0625 | 107.3125 | 108.0625 | 158400.0 |
| 2000-09-22 15:00:00 | DIA | ETF | 108.0938 | 108.7188 | 107.9062 | 108.5938 | 181100.0 |
| 2000-09-22 16:00:00 | DIA | ETF | 108.5 | 108.875 | 108.5 | 108.75 | 89200.0 |
> showing 33 of 176 rows — these rows as CSV