PREVIEW / etf_1hour / 2000-11-28
file: by_date/etf_1hour/2000/2000-11-28.parquet size: 10 KB rows: 187
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-28 09:00:00 | SPY | ETF | 135.125 | 136.0625 | 135.0312 | 136.0 | 494000.0 |
| 2000-11-28 10:00:00 | SPY | ETF | 135.9062 | 136.5938 | 134.7188 | 135.25 | 1003400.0 |
| 2000-11-28 11:00:00 | SPY | ETF | 135.0938 | 135.375 | 134.2188 | 134.9375 | 492400.0 |
| 2000-11-28 12:00:00 | SPY | ETF | 134.7812 | 135.3438 | 134.3438 | 135.125 | 241600.0 |
| 2000-11-28 13:00:00 | SPY | ETF | 135.25 | 135.75 | 134.6875 | 135.75 | 394500.0 |
| 2000-11-28 14:00:00 | SPY | ETF | 135.8438 | 135.875 | 134.5625 | 134.6875 | 658400.0 |
| 2000-11-28 15:00:00 | SPY | ETF | 134.8125 | 134.8125 | 133.8125 | 133.8125 | 756500.0 |
| 2000-11-28 16:00:00 | SPY | ETF | 133.8125 | 134.0 | 133.625 | 133.6875 | 1162100.0 |
| 2000-11-28 17:00:00 | SPY | ETF | 133.75 | 133.75 | 133.75 | 133.75 | 200.0 |
| 2000-11-28 09:00:00 | QQQ | ETF | 68.9375 | 69.5 | 68.5 | 69.25 | 4398200.0 |
| 2000-11-28 10:00:00 | QQQ | ETF | 69.25 | 69.875 | 67.375 | 67.75 | 6646000.0 |
| 2000-11-28 11:00:00 | QQQ | ETF | 67.75 | 67.9375 | 66.875 | 67.625 | 6498900.0 |
| 2000-11-28 12:00:00 | QQQ | ETF | 67.625 | 67.6875 | 66.5312 | 67.1875 | 5151600.0 |
| 2000-11-28 13:00:00 | QQQ | ETF | 67.1875 | 68.1562 | 66.625 | 68.0625 | 4724000.0 |
| 2000-11-28 14:00:00 | QQQ | ETF | 68.125 | 68.125 | 65.7812 | 66.1875 | 8780800.0 |
| 2000-11-28 15:00:00 | QQQ | ETF | 66.2812 | 66.375 | 65.3125 | 65.4688 | 9144400.0 |
| 2000-11-28 16:00:00 | QQQ | ETF | 65.4688 | 65.9375 | 65.3125 | 65.625 | 1095200.0 |
| 2000-11-28 17:00:00 | QQQ | ETF | 65.625 | 66.0 | 65.5 | 65.75 | 35100.0 |
| 2000-11-28 18:00:00 | QQQ | ETF | 65.75 | 66.0 | 65.5312 | 65.6875 | 7500.0 |
| 2000-11-28 09:00:00 | IWM | ETF | 46.875 | 47.0156 | 46.75 | 46.75 | 33600.0 |
| 2000-11-28 10:00:00 | IWM | ETF | 47.0 | 47.2188 | 46.5625 | 46.5938 | 51400.0 |
| 2000-11-28 11:00:00 | IWM | ETF | 46.5 | 46.5 | 46.1562 | 46.1562 | 5200.0 |
| 2000-11-28 12:00:00 | IWM | ETF | 46.375 | 46.375 | 46.0938 | 46.3438 | 16000.0 |
| 2000-11-28 13:00:00 | IWM | ETF | 46.375 | 46.4375 | 46.1875 | 46.4375 | 9600.0 |
| 2000-11-28 14:00:00 | IWM | ETF | 46.3125 | 46.3438 | 46.2812 | 46.2812 | 5600.0 |
| 2000-11-28 15:00:00 | IWM | ETF | 46.125 | 46.125 | 45.5 | 45.8438 | 15200.0 |
| 2000-11-28 16:00:00 | IWM | ETF | 45.6875 | 45.6875 | 45.6562 | 45.6562 | 400.0 |
| 2000-11-28 09:00:00 | DIA | ETF | 105.5 | 105.9688 | 105.0625 | 105.8438 | 134100.0 |
| 2000-11-28 10:00:00 | DIA | ETF | 105.9688 | 106.375 | 105.5 | 105.875 | 163700.0 |
| 2000-11-28 11:00:00 | DIA | ETF | 105.8438 | 105.8438 | 105.125 | 105.4375 | 145300.0 |
| 2000-11-28 12:00:00 | DIA | ETF | 105.4688 | 106.0 | 105.3125 | 105.8438 | 106100.0 |
| 2000-11-28 13:00:00 | DIA | ETF | 105.8438 | 106.0312 | 105.4688 | 106.0312 | 70700.0 |
| 2000-11-28 14:00:00 | DIA | ETF | 106.0625 | 106.0625 | 105.375 | 105.5625 | 112400.0 |
| 2000-11-28 15:00:00 | DIA | ETF | 105.4062 | 105.4688 | 104.9375 | 105.0 | 210800.0 |
| 2000-11-28 16:00:00 | DIA | ETF | 104.9375 | 105.2812 | 104.9375 | 105.2812 | 62000.0 |
> showing 35 of 187 rows — these rows as CSV