PREVIEW / etf_1hour / 2000-09-26
file: by_date/etf_1hour/2000/2000-09-26.parquet size: 9 KB rows: 174
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:00: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 | 143.75 | 143.8438 | 854500.0 |
| 2000-09-26 11:00:00 | SPY | ETF | 143.8125 | 143.9375 | 143.375 | 143.75 | 487300.0 |
| 2000-09-26 12:00:00 | SPY | ETF | 143.7188 | 143.8125 | 143.0312 | 143.1875 | 916700.0 |
| 2000-09-26 13:00:00 | SPY | ETF | 143.1875 | 144.25 | 143.1875 | 143.75 | 271400.0 |
| 2000-09-26 14:00:00 | SPY | ETF | 143.6875 | 143.9062 | 142.7188 | 142.875 | 712700.0 |
| 2000-09-26 15:00:00 | SPY | ETF | 142.8438 | 143.4688 | 142.625 | 142.875 | 1118800.0 |
| 2000-09-26 16:00:00 | SPY | ETF | 143.0 | 143.0 | 142.4062 | 142.4062 | 422400.0 |
| 2000-09-26 09:00: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 | 90.7812 | 6162300.0 |
| 2000-09-26 11:00:00 | QQQ | ETF | 90.6875 | 90.8438 | 90.0 | 90.8438 | 2970800.0 |
| 2000-09-26 12:00:00 | QQQ | ETF | 90.8438 | 90.9062 | 89.5 | 89.875 | 2516000.0 |
| 2000-09-26 13:00:00 | QQQ | ETF | 89.875 | 91.3438 | 89.875 | 90.5625 | 2410500.0 |
| 2000-09-26 14:00:00 | QQQ | ETF | 90.5 | 91.0312 | 89.1875 | 89.5 | 2660200.0 |
| 2000-09-26 15:00:00 | QQQ | ETF | 89.5 | 90.25 | 88.9688 | 89.375 | 4765200.0 |
| 2000-09-26 16:00:00 | QQQ | ETF | 89.5 | 89.5 | 88.9062 | 89.25 | 990100.0 |
| 2000-09-26 17:00:00 | QQQ | ETF | 89.1875 | 89.375 | 89.0 | 89.25 | 4800.0 |
| 2000-09-26 18:00:00 | QQQ | ETF | 89.3125 | 89.4375 | 89.3125 | 89.4375 | 300.0 |
| 2000-09-26 09:00: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.25 | 51.2812 | 5600.0 |
| 2000-09-26 12:00:00 | IWM | ETF | 51.2344 | 51.2344 | 50.9688 | 51.0156 | 7200.0 |
| 2000-09-26 13:00:00 | IWM | ETF | 51.125 | 51.125 | 51.125 | 51.125 | 20000.0 |
| 2000-09-26 14:00: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.6562 | 50.6875 | 15400.0 |
| 2000-09-26 16:00:00 | IWM | ETF | 50.9219 | 50.9219 | 50.9219 | 50.9219 | 1000.0 |
| 2000-09-26 09:00: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.0 | 107.1875 | 123400.0 |
| 2000-09-26 11:00:00 | DIA | ETF | 107.1875 | 107.2188 | 106.6875 | 106.875 | 50800.0 |
| 2000-09-26 12:00:00 | DIA | ETF | 107.0 | 107.0625 | 106.5 | 106.75 | 82200.0 |
| 2000-09-26 13:00:00 | DIA | ETF | 106.75 | 107.4062 | 106.75 | 107.0 | 85200.0 |
| 2000-09-26 14:00:00 | DIA | ETF | 106.9062 | 107.2812 | 106.25 | 106.5938 | 61200.0 |
| 2000-09-26 15:00:00 | DIA | ETF | 106.5938 | 106.875 | 106.25 | 106.5312 | 145200.0 |
| 2000-09-26 16:00:00 | DIA | ETF | 106.5312 | 106.5312 | 106.1562 | 106.1562 | 29500.0 |
> showing 34 of 174 rows — these rows as CSV