PREVIEW / etf_1hour / 2000-01-24
file: by_date/etf_1hour/2000/2000-01-24.parquet size: 9 KB rows: 135
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-01-24 09:00:00 | SPY | ETF | 145.6562 | 145.8438 | 144.9062 | 145.0 | 706100.0 |
| 2000-01-24 10:00:00 | SPY | ETF | 145.0938 | 145.25 | 143.5938 | 143.5938 | 610900.0 |
| 2000-01-24 11:00:00 | SPY | ETF | 143.5938 | 144.0625 | 143.2812 | 143.875 | 741600.0 |
| 2000-01-24 12:00:00 | SPY | ETF | 143.7188 | 144.125 | 143.5625 | 143.7812 | 459200.0 |
| 2000-01-24 13:00:00 | SPY | ETF | 143.6875 | 143.9062 | 142.375 | 142.6562 | 1047400.0 |
| 2000-01-24 14:00:00 | SPY | ETF | 142.6875 | 142.8125 | 141.0 | 141.0312 | 1144600.0 |
| 2000-01-24 15:00:00 | SPY | ETF | 140.9375 | 141.375 | 139.4062 | 140.0625 | 2707900.0 |
| 2000-01-24 16:00:00 | SPY | ETF | 140.0 | 140.5 | 140.0 | 140.3438 | 400500.0 |
| 2000-01-24 09:00:00 | QQQ | ETF | 97.4375 | 97.625 | 96.75 | 96.75 | 2649600.0 |
| 2000-01-24 10:00:00 | QQQ | ETF | 96.8438 | 97.3125 | 95.9219 | 95.9375 | 4353400.0 |
| 2000-01-24 11:00:00 | QQQ | ETF | 95.9375 | 96.1875 | 95.3906 | 96.0 | 3874600.0 |
| 2000-01-24 12:00:00 | QQQ | ETF | 96.0 | 96.5 | 95.875 | 96.1562 | 1798000.0 |
| 2000-01-24 13:00:00 | QQQ | ETF | 96.1406 | 96.2188 | 95.0469 | 95.375 | 2104400.0 |
| 2000-01-24 14:00:00 | QQQ | ETF | 95.25 | 95.4375 | 93.0 | 93.2812 | 5534200.0 |
| 2000-01-24 15:00:00 | QQQ | ETF | 93.125 | 93.1875 | 91.375 | 91.5625 | 7089400.0 |
| 2000-01-24 16:00:00 | QQQ | ETF | 91.5 | 91.625 | 90.9688 | 91.5 | 790400.0 |
| 2000-01-24 17:00:00 | QQQ | ETF | 91.1875 | 92.0 | 91.1875 | 92.0 | 4200.0 |
| 2000-01-24 18:00:00 | QQQ | ETF | 92.0 | 92.0 | 91.625 | 91.625 | 400.0 |
| 2000-01-24 09:00:00 | DIA | ETF | 113.25 | 113.625 | 113.0625 | 113.3438 | 165800.0 |
| 2000-01-24 10:00:00 | DIA | ETF | 113.4688 | 113.4688 | 112.0312 | 112.25 | 322800.0 |
| 2000-01-24 11:00:00 | DIA | ETF | 112.125 | 112.5 | 112.0 | 112.3438 | 162500.0 |
| 2000-01-24 12:00:00 | DIA | ETF | 112.3438 | 112.875 | 112.25 | 112.4375 | 448200.0 |
| 2000-01-24 13:00:00 | DIA | ETF | 112.5625 | 112.5938 | 111.5 | 111.75 | 96500.0 |
| 2000-01-24 14:00:00 | DIA | ETF | 111.75 | 111.8438 | 110.25 | 110.25 | 387400.0 |
| 2000-01-24 15:00:00 | DIA | ETF | 110.375 | 110.6875 | 109.0625 | 110.0312 | 470500.0 |
| 2000-01-24 16:00:00 | DIA | ETF | 110.0 | 110.0312 | 109.8125 | 110.0 | 12400.0 |
> showing 26 of 135 rows — these rows as CSV