PREVIEW / etf_1hour / 2000-06-29
file: by_date/etf_1hour/2000/2000-06-29.parquet size: 9 KB rows: 150
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-06-29 09:00:00 | SPY | ETF | 144.75 | 144.875 | 144.0625 | 144.8438 | 438500.0 |
| 2000-06-29 10:00:00 | SPY | ETF | 144.6562 | 144.875 | 143.75 | 144.1562 | 1079700.0 |
| 2000-06-29 11:00:00 | SPY | ETF | 144.1875 | 144.2188 | 143.5 | 144.125 | 291400.0 |
| 2000-06-29 12:00:00 | SPY | ETF | 144.2188 | 144.625 | 143.875 | 144.5625 | 418200.0 |
| 2000-06-29 13:00:00 | SPY | ETF | 144.4375 | 144.9688 | 144.1875 | 144.8125 | 564500.0 |
| 2000-06-29 14:00:00 | SPY | ETF | 144.75 | 145.75 | 144.5938 | 144.5938 | 1393300.0 |
| 2000-06-29 15:00:00 | SPY | ETF | 144.6875 | 145.375 | 144.3125 | 144.4375 | 622900.0 |
| 2000-06-29 16:00:00 | SPY | ETF | 144.25 | 144.4688 | 144.125 | 144.125 | 480400.0 |
| 2000-06-29 17:00:00 | SPY | ETF | 144.1875 | 144.1875 | 144.1875 | 144.1875 | 300.0 |
| 2000-06-29 09:00:00 | QQQ | ETF | 92.9375 | 92.9375 | 91.875 | 92.5938 | 4726700.0 |
| 2000-06-29 10:00:00 | QQQ | ETF | 92.5625 | 92.75 | 91.0625 | 91.5625 | 3831000.0 |
| 2000-06-29 11:00:00 | QQQ | ETF | 91.5312 | 91.625 | 90.625 | 91.625 | 2371200.0 |
| 2000-06-29 12:00:00 | QQQ | ETF | 91.5938 | 92.3438 | 90.625 | 92.0625 | 1472700.0 |
| 2000-06-29 13:00:00 | QQQ | ETF | 92.125 | 92.4375 | 91.625 | 92.375 | 1245600.0 |
| 2000-06-29 14:00:00 | QQQ | ETF | 92.3125 | 93.375 | 92.125 | 92.25 | 3596200.0 |
| 2000-06-29 15:00:00 | QQQ | ETF | 92.25 | 93.1562 | 91.5 | 91.625 | 3588800.0 |
| 2000-06-29 16:00:00 | QQQ | ETF | 91.8125 | 92.0 | 91.5 | 91.625 | 464900.0 |
| 2000-06-29 09:00:00 | IWM | ETF | 51.75 | 51.8438 | 51.5 | 51.5938 | 6800.0 |
| 2000-06-29 10:00:00 | IWM | ETF | 51.75 | 51.75 | 51.2188 | 51.2812 | 23000.0 |
| 2000-06-29 11:00:00 | IWM | ETF | 51.4219 | 51.4219 | 51.0312 | 51.2344 | 6400.0 |
| 2000-06-29 12:00:00 | IWM | ETF | 51.25 | 51.375 | 51.25 | 51.375 | 10800.0 |
| 2000-06-29 13:00:00 | IWM | ETF | 51.4688 | 51.5 | 51.3438 | 51.4688 | 18600.0 |
| 2000-06-29 14:00:00 | IWM | ETF | 51.625 | 51.7188 | 51.3438 | 51.3438 | 9000.0 |
| 2000-06-29 15:00:00 | IWM | ETF | 51.4219 | 51.5312 | 51.2969 | 51.3438 | 120000.0 |
| 2000-06-29 16:00:00 | IWM | ETF | 51.1875 | 51.1875 | 51.1875 | 51.1875 | 17200.0 |
| 2000-06-29 09:00:00 | DIA | ETF | 104.5938 | 104.5938 | 103.9062 | 104.375 | 71000.0 |
| 2000-06-29 10:00:00 | DIA | ETF | 104.3438 | 104.4375 | 103.6562 | 104.125 | 74100.0 |
| 2000-06-29 11:00:00 | DIA | ETF | 104.0 | 104.3438 | 103.625 | 104.3438 | 72700.0 |
| 2000-06-29 12:00:00 | DIA | ETF | 104.25 | 104.5312 | 104.0 | 104.5 | 31200.0 |
| 2000-06-29 13:00:00 | DIA | ETF | 104.4688 | 104.7188 | 104.1875 | 104.6875 | 59200.0 |
| 2000-06-29 14:00:00 | DIA | ETF | 104.75 | 105.3125 | 104.3125 | 104.4062 | 74400.0 |
| 2000-06-29 15:00:00 | DIA | ETF | 104.25 | 104.625 | 103.9375 | 104.125 | 50400.0 |
| 2000-06-29 16:00:00 | DIA | ETF | 104.125 | 104.25 | 104.0 | 104.25 | 10700.0 |
> showing 33 of 150 rows — these rows as CSV