PREVIEW / etf_1hour / 2000-05-08
file: by_date/etf_1hour/2000/2000-05-08.parquet size: 8 KB rows: 123
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-05-08 09:00:00 | SPY | ETF | 142.75 | 142.9375 | 142.0312 | 142.875 | 1077100.0 |
| 2000-05-08 10:00:00 | SPY | ETF | 142.9375 | 143.3438 | 142.25 | 143.1875 | 1012100.0 |
| 2000-05-08 11:00:00 | SPY | ETF | 143.3125 | 143.375 | 142.7188 | 142.875 | 240700.0 |
| 2000-05-08 12:00:00 | SPY | ETF | 142.7188 | 143.0 | 142.5625 | 142.8438 | 320100.0 |
| 2000-05-08 13:00:00 | SPY | ETF | 142.875 | 142.875 | 142.0938 | 142.7188 | 383000.0 |
| 2000-05-08 14:00:00 | SPY | ETF | 142.75 | 142.75 | 141.8438 | 142.1875 | 802500.0 |
| 2000-05-08 15:00:00 | SPY | ETF | 142.0 | 143.2188 | 142.0 | 142.5312 | 661200.0 |
| 2000-05-08 16:00:00 | SPY | ETF | 142.5312 | 142.625 | 142.25 | 142.4375 | 534100.0 |
| 2000-05-08 09:00:00 | QQQ | ETF | 90.5 | 90.75 | 89.0625 | 90.0625 | 2041900.0 |
| 2000-05-08 10:00:00 | QQQ | ETF | 90.0 | 90.125 | 88.875 | 90.0625 | 2622900.0 |
| 2000-05-08 11:00:00 | QQQ | ETF | 90.0 | 90.4375 | 89.4375 | 89.5 | 1192900.0 |
| 2000-05-08 12:00:00 | QQQ | ETF | 89.5 | 89.625 | 89.125 | 89.4375 | 744300.0 |
| 2000-05-08 13:00:00 | QQQ | ETF | 89.4375 | 89.75 | 88.6875 | 89.25 | 1374300.0 |
| 2000-05-08 14:00:00 | QQQ | ETF | 89.25 | 89.375 | 88.125 | 88.1875 | 1554500.0 |
| 2000-05-08 15:00:00 | QQQ | ETF | 88.125 | 89.625 | 88.0625 | 88.0625 | 3424600.0 |
| 2000-05-08 16:00:00 | QQQ | ETF | 88.0625 | 88.25 | 87.75 | 88.25 | 833200.0 |
| 2000-05-08 17:00:00 | QQQ | ETF | 88.0 | 88.0 | 87.75 | 87.75 | 1500.0 |
| 2000-05-08 18:00:00 | QQQ | ETF | 87.875 | 87.875 | 87.875 | 87.875 | 400.0 |
| 2000-05-08 09:00:00 | DIA | ETF | 105.25 | 105.875 | 105.0 | 105.7188 | 109300.0 |
| 2000-05-08 10:00:00 | DIA | ETF | 105.5312 | 106.375 | 105.2188 | 106.1562 | 107000.0 |
| 2000-05-08 11:00:00 | DIA | ETF | 106.3125 | 106.3125 | 105.75 | 105.9375 | 56900.0 |
| 2000-05-08 12:00:00 | DIA | ETF | 105.6562 | 105.7812 | 105.5 | 105.7812 | 10500.0 |
| 2000-05-08 13:00:00 | DIA | ETF | 105.75 | 105.75 | 105.0625 | 105.6875 | 226300.0 |
| 2000-05-08 14:00:00 | DIA | ETF | 105.875 | 105.875 | 105.2812 | 105.5312 | 23300.0 |
| 2000-05-08 15:00:00 | DIA | ETF | 105.5 | 106.125 | 105.375 | 105.875 | 116000.0 |
| 2000-05-08 16:00:00 | DIA | ETF | 105.9688 | 105.9688 | 105.7812 | 105.9375 | 16100.0 |
> showing 26 of 123 rows — these rows as CSV