PREVIEW / etf_1hour / 2000-11-29
file: by_date/etf_1hour/2000/2000-11-29.parquet size: 10 KB rows: 192
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-11-29 09:00:00 | SPY | ETF | 134.375 | 134.8438 | 133.8438 | 134.0 | 888400.0 |
| 2000-11-29 10:00:00 | SPY | ETF | 133.875 | 135.4062 | 133.25 | 135.25 | 2504900.0 |
| 2000-11-29 11:00:00 | SPY | ETF | 135.25 | 135.9062 | 134.5938 | 134.7188 | 497900.0 |
| 2000-11-29 12:00:00 | SPY | ETF | 134.7188 | 135.0625 | 134.125 | 134.7188 | 183600.0 |
| 2000-11-29 13:00:00 | SPY | ETF | 134.625 | 134.6875 | 133.6562 | 134.1562 | 330700.0 |
| 2000-11-29 14:00:00 | SPY | ETF | 134.0625 | 134.7188 | 133.3438 | 134.0625 | 798500.0 |
| 2000-11-29 15:00:00 | SPY | ETF | 134.1562 | 135.0 | 133.5938 | 134.625 | 970200.0 |
| 2000-11-29 16:00:00 | SPY | ETF | 134.625 | 134.8438 | 131.25 | 131.25 | 397200.0 |
| 2000-11-29 17:00:00 | SPY | ETF | 132.4375 | 132.4375 | 132.375 | 132.375 | 200.0 |
| 2000-11-29 09:00:00 | QQQ | ETF | 65.8125 | 65.9688 | 64.5 | 64.5 | 8573200.0 |
| 2000-11-29 10:00:00 | QQQ | ETF | 64.6562 | 66.125 | 63.5312 | 65.9375 | 12053100.0 |
| 2000-11-29 11:00:00 | QQQ | ETF | 66.0 | 66.75 | 64.875 | 65.1875 | 7066000.0 |
| 2000-11-29 12:00:00 | QQQ | ETF | 65.1875 | 65.375 | 64.25 | 64.625 | 5063800.0 |
| 2000-11-29 13:00:00 | QQQ | ETF | 64.6875 | 64.75 | 63.375 | 63.625 | 7928100.0 |
| 2000-11-29 14:00:00 | QQQ | ETF | 63.75 | 64.2188 | 62.875 | 63.75 | 7743700.0 |
| 2000-11-29 15:00:00 | QQQ | ETF | 63.8125 | 65.25 | 63.3125 | 65.0 | 9486500.0 |
| 2000-11-29 16:00:00 | QQQ | ETF | 65.0 | 65.9375 | 61.25 | 61.625 | 4717800.0 |
| 2000-11-29 17:00:00 | QQQ | ETF | 61.625 | 62.25 | 61.3125 | 61.5625 | 280900.0 |
| 2000-11-29 18:00:00 | QQQ | ETF | 61.5312 | 62.0 | 61.375 | 61.5625 | 49700.0 |
| 2000-11-29 09:00:00 | IWM | ETF | 46.0 | 46.0 | 45.75 | 45.875 | 5200.0 |
| 2000-11-29 10:00:00 | IWM | ETF | 45.4688 | 45.8125 | 45.375 | 45.8125 | 31600.0 |
| 2000-11-29 11:00:00 | IWM | ETF | 45.875 | 45.9688 | 45.6562 | 45.6562 | 5400.0 |
| 2000-11-29 12:00:00 | IWM | ETF | 45.7812 | 45.7812 | 45.7188 | 45.7188 | 1000.0 |
| 2000-11-29 13:00:00 | IWM | ETF | 45.4375 | 45.5 | 45.4062 | 45.4062 | 3000.0 |
| 2000-11-29 14:00:00 | IWM | ETF | 45.375 | 45.375 | 45.0625 | 45.0625 | 56800.0 |
| 2000-11-29 15:00:00 | IWM | ETF | 45.2812 | 45.5312 | 45.25 | 45.5312 | 363400.0 |
| 2000-11-29 16:00:00 | IWM | ETF | 45.375 | 45.5312 | 45.375 | 45.5312 | 59800.0 |
| 2000-11-29 09:00:00 | DIA | ETF | 105.5312 | 105.8438 | 105.125 | 105.3125 | 331700.0 |
| 2000-11-29 10:00:00 | DIA | ETF | 105.3125 | 106.25 | 105.0625 | 106.25 | 381500.0 |
| 2000-11-29 11:00:00 | DIA | ETF | 106.3438 | 106.6562 | 106.0 | 106.0625 | 106800.0 |
| 2000-11-29 12:00:00 | DIA | ETF | 106.0938 | 106.4062 | 105.875 | 106.25 | 75200.0 |
| 2000-11-29 13:00:00 | DIA | ETF | 106.0625 | 106.2188 | 105.6562 | 105.9062 | 68100.0 |
| 2000-11-29 14:00:00 | DIA | ETF | 105.9375 | 106.375 | 105.75 | 106.125 | 155500.0 |
| 2000-11-29 15:00:00 | DIA | ETF | 106.1562 | 106.6875 | 105.7812 | 106.25 | 202600.0 |
| 2000-11-29 16:00:00 | DIA | ETF | 106.375 | 106.5 | 105.9688 | 105.9688 | 12500.0 |
> showing 35 of 192 rows — these rows as CSV