PREVIEW / etf_1hour / 2000-04-20
file: by_date/etf_1hour/2000/2000-04-20.parquet size: 8 KB rows: 114
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-04-20 09:00:00 | SPY | ETF | 143.5625 | 143.9375 | 142.875 | 143.0625 | 1066000.0 |
| 2000-04-20 10:00:00 | SPY | ETF | 143.125 | 143.9062 | 142.7812 | 143.2812 | 1130100.0 |
| 2000-04-20 11:00:00 | SPY | ETF | 143.5 | 143.9375 | 143.125 | 143.125 | 1583200.0 |
| 2000-04-20 12:00:00 | SPY | ETF | 143.25 | 143.25 | 142.375 | 142.6875 | 1158900.0 |
| 2000-04-20 13:00:00 | SPY | ETF | 142.875 | 143.375 | 142.6562 | 143.125 | 616000.0 |
| 2000-04-20 14:00:00 | SPY | ETF | 143.1562 | 143.375 | 142.4375 | 143.375 | 711600.0 |
| 2000-04-20 15:00:00 | SPY | ETF | 143.1875 | 143.875 | 143.125 | 143.375 | 1782800.0 |
| 2000-04-20 16:00:00 | SPY | ETF | 143.5 | 143.8125 | 143.4062 | 143.8125 | 354600.0 |
| 2000-04-20 09:00:00 | QQQ | ETF | 90.375 | 90.9688 | 89.0 | 89.0 | 3104100.0 |
| 2000-04-20 10:00:00 | QQQ | ETF | 89.0 | 89.5 | 88.0625 | 88.5625 | 3978700.0 |
| 2000-04-20 11:00:00 | QQQ | ETF | 88.75 | 89.25 | 87.1875 | 87.1875 | 1940200.0 |
| 2000-04-20 12:00:00 | QQQ | ETF | 87.1875 | 87.5625 | 86.1875 | 86.625 | 3611800.0 |
| 2000-04-20 13:00:00 | QQQ | ETF | 86.75 | 87.875 | 86.375 | 87.8125 | 2267300.0 |
| 2000-04-20 14:00:00 | QQQ | ETF | 87.625 | 88.2188 | 86.375 | 88.0 | 2545900.0 |
| 2000-04-20 15:00:00 | QQQ | ETF | 88.0 | 88.9375 | 87.3125 | 87.3125 | 3198900.0 |
| 2000-04-20 16:00:00 | QQQ | ETF | 87.5 | 87.625 | 86.8125 | 86.875 | 502000.0 |
| 2000-04-20 17:00:00 | QQQ | ETF | 86.75 | 86.75 | 86.0625 | 86.0625 | 3000.0 |
| 2000-04-20 18:00:00 | QQQ | ETF | 86.375 | 87.25 | 86.375 | 87.25 | 500.0 |
| 2000-04-20 09:00:00 | DIA | ETF | 107.0625 | 107.375 | 106.8438 | 107.125 | 47900.0 |
| 2000-04-20 10:00:00 | DIA | ETF | 107.0 | 107.8438 | 106.8438 | 107.5938 | 527500.0 |
| 2000-04-20 11:00:00 | DIA | ETF | 107.5625 | 108.2812 | 107.5625 | 107.75 | 268200.0 |
| 2000-04-20 12:00:00 | DIA | ETF | 107.6875 | 108.0312 | 107.3438 | 107.875 | 306900.0 |
| 2000-04-20 13:00:00 | DIA | ETF | 107.7188 | 108.2188 | 107.6875 | 108.0312 | 144900.0 |
| 2000-04-20 14:00:00 | DIA | ETF | 107.875 | 108.25 | 107.5 | 108.2188 | 167100.0 |
| 2000-04-20 15:00:00 | DIA | ETF | 108.0 | 108.5625 | 108.0 | 108.4062 | 260200.0 |
| 2000-04-20 16:00:00 | DIA | ETF | 108.25 | 108.7812 | 108.25 | 108.7812 | 38600.0 |
> showing 26 of 114 rows — these rows as CSV