PREVIEW / etf_1hour / 2000-10-23
file: by_date/etf_1hour/2000/2000-10-23.parquet size: 9 KB rows: 180
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-10-23 09:00:00 | SPY | ETF | 139.9375 | 140.3438 | 139.5625 | 140.1562 | 611000.0 |
| 2000-10-23 10:00:00 | SPY | ETF | 140.2188 | 141.0312 | 139.75 | 140.6875 | 975800.0 |
| 2000-10-23 11:00:00 | SPY | ETF | 140.8125 | 140.875 | 140.0625 | 140.25 | 582000.0 |
| 2000-10-23 12:00:00 | SPY | ETF | 140.1875 | 140.3438 | 139.625 | 139.9062 | 391000.0 |
| 2000-10-23 13:00:00 | SPY | ETF | 139.9375 | 140.1875 | 139.5 | 140.1875 | 663900.0 |
| 2000-10-23 14:00:00 | SPY | ETF | 140.2188 | 140.3125 | 139.0938 | 139.25 | 834300.0 |
| 2000-10-23 15:00:00 | SPY | ETF | 139.125 | 140.0 | 138.9375 | 140.0 | 810600.0 |
| 2000-10-23 16:00:00 | SPY | ETF | 140.0938 | 140.625 | 139.9688 | 140.5312 | 252200.0 |
| 2000-10-23 17:00:00 | SPY | ETF | 140.0312 | 140.0312 | 140.0312 | 140.0312 | 300.0 |
| 2000-10-23 09:00:00 | QQQ | ETF | 86.1875 | 86.8125 | 85.5625 | 86.5 | 5298400.0 |
| 2000-10-23 10:00:00 | QQQ | ETF | 86.5 | 87.5 | 85.875 | 86.875 | 5283900.0 |
| 2000-10-23 11:00:00 | QQQ | ETF | 86.9375 | 86.9688 | 85.875 | 86.25 | 3127600.0 |
| 2000-10-23 12:00:00 | QQQ | ETF | 86.1875 | 86.3125 | 85.1875 | 85.5 | 3362000.0 |
| 2000-10-23 13:00:00 | QQQ | ETF | 85.5 | 85.625 | 84.6875 | 85.5 | 2833500.0 |
| 2000-10-23 14:00:00 | QQQ | ETF | 85.75 | 86.0 | 84.375 | 84.5938 | 3393900.0 |
| 2000-10-23 15:00:00 | QQQ | ETF | 84.5 | 85.8438 | 84.125 | 85.5 | 4292100.0 |
| 2000-10-23 16:00:00 | QQQ | ETF | 85.5 | 86.375 | 85.5 | 85.625 | 704100.0 |
| 2000-10-23 17:00:00 | QQQ | ETF | 85.875 | 85.875 | 85.5 | 85.75 | 26700.0 |
| 2000-10-23 18:00:00 | QQQ | ETF | 85.625 | 85.625 | 85.5312 | 85.5312 | 1000.0 |
| 2000-10-23 09:00:00 | IWM | ETF | 48.8438 | 48.875 | 48.6875 | 48.6875 | 14400.0 |
| 2000-10-23 10:00:00 | IWM | ETF | 48.9375 | 49.1094 | 48.8125 | 49.1094 | 3800.0 |
| 2000-10-23 11:00:00 | IWM | ETF | 48.9375 | 48.9375 | 48.9375 | 48.9375 | 1400.0 |
| 2000-10-23 12:00:00 | IWM | ETF | 48.8281 | 48.8438 | 48.6875 | 48.8438 | 6200.0 |
| 2000-10-23 13:00:00 | IWM | ETF | 48.8438 | 48.8438 | 48.6562 | 48.6562 | 400.0 |
| 2000-10-23 14:00:00 | IWM | ETF | 48.8906 | 49.0938 | 48.8125 | 48.8125 | 104400.0 |
| 2000-10-23 15:00:00 | IWM | ETF | 48.9688 | 49.125 | 48.9688 | 49.1094 | 6600.0 |
| 2000-10-23 16:00:00 | IWM | ETF | 49.0 | 49.125 | 49.0 | 49.0625 | 1400.0 |
| 2000-10-23 09:00:00 | DIA | ETF | 102.625 | 102.875 | 102.2812 | 102.6875 | 74700.0 |
| 2000-10-23 10:00:00 | DIA | ETF | 102.6875 | 103.5938 | 102.6562 | 103.375 | 291200.0 |
| 2000-10-23 11:00:00 | DIA | ETF | 103.4375 | 103.4688 | 102.875 | 103.125 | 70400.0 |
| 2000-10-23 12:00:00 | DIA | ETF | 103.125 | 103.25 | 102.8125 | 103.1562 | 112900.0 |
| 2000-10-23 13:00:00 | DIA | ETF | 103.125 | 103.25 | 102.8438 | 103.0625 | 80000.0 |
| 2000-10-23 14:00:00 | DIA | ETF | 103.1562 | 103.2188 | 102.375 | 102.5625 | 64700.0 |
| 2000-10-23 15:00:00 | DIA | ETF | 102.375 | 102.8438 | 102.2812 | 102.5625 | 130300.0 |
| 2000-10-23 16:00:00 | DIA | ETF | 102.625 | 103.2188 | 102.625 | 103.125 | 29600.0 |
> showing 35 of 180 rows — these rows as CSV