PREVIEW / etf_1hour / 2000-12-22
file: by_date/etf_1hour/2000/2000-12-22.parquet size: 10 KB rows: 207
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-12-22 09:00:00 | SPY | ETF | 129.0 | 129.8438 | 128.8438 | 129.8125 | 1301800.0 |
| 2000-12-22 10:00:00 | SPY | ETF | 129.75 | 130.4688 | 129.5625 | 130.2812 | 2174900.0 |
| 2000-12-22 11:00:00 | SPY | ETF | 130.3125 | 130.5938 | 129.75 | 129.75 | 1709300.0 |
| 2000-12-22 12:00:00 | SPY | ETF | 129.875 | 130.1562 | 129.7188 | 129.9688 | 716800.0 |
| 2000-12-22 13:00:00 | SPY | ETF | 130.0 | 130.2812 | 129.5 | 129.6875 | 505700.0 |
| 2000-12-22 14:00:00 | SPY | ETF | 129.625 | 130.0 | 129.0 | 129.7188 | 934700.0 |
| 2000-12-22 15:00:00 | SPY | ETF | 129.9375 | 130.8438 | 129.8125 | 130.8438 | 1232200.0 |
| 2000-12-22 16:00:00 | SPY | ETF | 130.75 | 131.0938 | 130.6562 | 130.9375 | 1317300.0 |
| 2000-12-22 17:00:00 | SPY | ETF | 131.5 | 131.5 | 131.5 | 131.5 | 1000.0 |
| 2000-12-22 09:00:00 | QQQ | ETF | 57.625 | 59.3125 | 57.625 | 58.9688 | 10143600.0 |
| 2000-12-22 10:00:00 | QQQ | ETF | 58.9688 | 59.9688 | 58.625 | 59.8125 | 11381000.0 |
| 2000-12-22 11:00:00 | QQQ | ETF | 59.75 | 60.375 | 59.25 | 59.25 | 7727400.0 |
| 2000-12-22 12:00:00 | QQQ | ETF | 59.3438 | 59.875 | 59.25 | 59.5625 | 3945400.0 |
| 2000-12-22 13:00:00 | QQQ | ETF | 59.5625 | 59.9375 | 58.6875 | 58.6875 | 5654600.0 |
| 2000-12-22 14:00:00 | QQQ | ETF | 58.7188 | 59.3125 | 57.75 | 58.9062 | 6319000.0 |
| 2000-12-22 15:00:00 | QQQ | ETF | 58.8438 | 60.75 | 58.8438 | 60.625 | 8498600.0 |
| 2000-12-22 16:00:00 | QQQ | ETF | 60.5625 | 61.0 | 60.0 | 60.625 | 1000800.0 |
| 2000-12-22 17:00:00 | QQQ | ETF | 60.75 | 61.0 | 60.5 | 60.75 | 17500.0 |
| 2000-12-22 18:00:00 | QQQ | ETF | 60.75 | 61.3125 | 60.5 | 60.625 | 19700.0 |
| 2000-12-22 09:00:00 | IWM | ETF | 45.125 | 45.2188 | 45.0625 | 45.2188 | 137000.0 |
| 2000-12-22 10:00:00 | IWM | ETF | 45.2812 | 45.7812 | 45.25 | 45.625 | 394200.0 |
| 2000-12-22 11:00:00 | IWM | ETF | 45.8125 | 46.0 | 45.625 | 45.75 | 106400.0 |
| 2000-12-22 12:00:00 | IWM | ETF | 45.875 | 45.875 | 45.6875 | 45.7188 | 45400.0 |
| 2000-12-22 13:00:00 | IWM | ETF | 45.6875 | 45.9375 | 45.625 | 45.75 | 60200.0 |
| 2000-12-22 14:00:00 | IWM | ETF | 45.5938 | 45.7656 | 45.4688 | 45.7656 | 22600.0 |
| 2000-12-22 15:00:00 | IWM | ETF | 45.8125 | 46.2188 | 45.7188 | 46.1875 | 61200.0 |
| 2000-12-22 16:00:00 | IWM | ETF | 46.3438 | 46.3438 | 46.25 | 46.25 | 21800.0 |
| 2000-12-22 09:00:00 | DIA | ETF | 105.5 | 105.8125 | 105.2188 | 105.8125 | 404800.0 |
| 2000-12-22 10:00:00 | DIA | ETF | 105.7188 | 106.1875 | 105.5 | 106.125 | 289500.0 |
| 2000-12-22 11:00:00 | DIA | ETF | 106.1562 | 106.3125 | 105.8125 | 105.8125 | 281300.0 |
| 2000-12-22 12:00:00 | DIA | ETF | 105.75 | 105.9375 | 105.4375 | 105.8438 | 193600.0 |
| 2000-12-22 13:00:00 | DIA | ETF | 105.875 | 106.125 | 105.75 | 105.9688 | 189400.0 |
| 2000-12-22 14:00:00 | DIA | ETF | 105.9062 | 106.125 | 105.5 | 106.0 | 174500.0 |
| 2000-12-22 15:00:00 | DIA | ETF | 106.0 | 106.5 | 105.9375 | 106.5 | 290700.0 |
| 2000-12-22 16:00:00 | DIA | ETF | 106.625 | 106.9688 | 106.5625 | 106.9688 | 8200.0 |
> showing 35 of 207 rows — these rows as CSV