PREVIEW / etf_1hour / 2000-01-20
file: by_date/etf_1hour/2000/2000-01-20.parquet size: 8 KB rows: 134
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-20 09:00:00 | SPY | ETF | 146.9688 | 146.9688 | 146.25 | 146.3438 | 451700.0 |
| 2000-01-20 10:00:00 | SPY | ETF | 146.375 | 146.75 | 145.9375 | 146.2188 | 416800.0 |
| 2000-01-20 11:00:00 | SPY | ETF | 146.3125 | 146.5 | 145.1875 | 145.375 | 510800.0 |
| 2000-01-20 12:00:00 | SPY | ETF | 145.3125 | 145.3438 | 144.125 | 144.5 | 843100.0 |
| 2000-01-20 13:00:00 | SPY | ETF | 144.4375 | 144.9375 | 143.8125 | 144.8438 | 1100400.0 |
| 2000-01-20 14:00:00 | SPY | ETF | 144.875 | 145.4375 | 144.5625 | 144.6875 | 1245900.0 |
| 2000-01-20 15:00:00 | SPY | ETF | 144.75 | 145.375 | 144.5 | 144.5 | 749800.0 |
| 2000-01-20 16:00:00 | SPY | ETF | 144.5 | 144.9375 | 144.4062 | 144.75 | 459500.0 |
| 2000-01-20 09:00:00 | QQQ | ETF | 95.5 | 96.25 | 95.5 | 95.9844 | 2918400.0 |
| 2000-01-20 10:00:00 | QQQ | ETF | 95.9844 | 96.875 | 95.875 | 96.5625 | 3591200.0 |
| 2000-01-20 11:00:00 | QQQ | ETF | 96.5938 | 96.6875 | 95.5 | 95.6719 | 2728400.0 |
| 2000-01-20 12:00:00 | QQQ | ETF | 95.625 | 95.7344 | 94.25 | 94.8438 | 4639000.0 |
| 2000-01-20 13:00:00 | QQQ | ETF | 94.8438 | 95.5625 | 94.25 | 95.4062 | 3298400.0 |
| 2000-01-20 14:00:00 | QQQ | ETF | 95.3125 | 96.5312 | 95.1875 | 95.6875 | 4267000.0 |
| 2000-01-20 15:00:00 | QQQ | ETF | 95.75 | 96.4375 | 95.3125 | 95.7969 | 3443400.0 |
| 2000-01-20 16:00:00 | QQQ | ETF | 95.8125 | 95.8438 | 95.375 | 95.5 | 781200.0 |
| 2000-01-20 17:00:00 | QQQ | ETF | 95.5 | 95.5 | 95.5 | 95.5 | 2000.0 |
| 2000-01-20 18:00:00 | QQQ | ETF | 95.0625 | 95.0625 | 95.0625 | 95.0625 | 400.0 |
| 2000-01-20 09:00:00 | DIA | ETF | 115.9375 | 115.9688 | 115.0 | 115.4062 | 119400.0 |
| 2000-01-20 10:00:00 | DIA | ETF | 115.3438 | 115.4688 | 114.8125 | 114.9062 | 137700.0 |
| 2000-01-20 11:00:00 | DIA | ETF | 114.9062 | 115.125 | 113.875 | 114.0938 | 180400.0 |
| 2000-01-20 12:00:00 | DIA | ETF | 114.0 | 114.0 | 113.25 | 113.5625 | 140400.0 |
| 2000-01-20 13:00:00 | DIA | ETF | 113.375 | 113.7188 | 112.6562 | 113.625 | 154900.0 |
| 2000-01-20 14:00:00 | DIA | ETF | 113.5 | 114.0938 | 113.4375 | 113.875 | 56900.0 |
| 2000-01-20 15:00:00 | DIA | ETF | 113.5 | 114.25 | 113.5 | 113.5 | 84000.0 |
| 2000-01-20 16:00:00 | DIA | ETF | 113.4688 | 113.7188 | 113.375 | 113.7188 | 11500.0 |
> showing 26 of 134 rows — these rows as CSV