PREVIEW / etf_1hour / 2000-06-21
file: by_date/etf_1hour/2000/2000-06-21.parquet size: 9 KB rows: 158
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-21 09:00:00 | SPY | ETF | 146.9375 | 147.5625 | 146.9375 | 147.3438 | 232100.0 |
| 2000-06-21 10:00:00 | SPY | ETF | 147.4062 | 147.9062 | 147.25 | 147.2812 | 493900.0 |
| 2000-06-21 11:00:00 | SPY | ETF | 147.375 | 147.4375 | 146.875 | 147.2188 | 132300.0 |
| 2000-06-21 12:00:00 | SPY | ETF | 147.375 | 147.5938 | 147.2188 | 147.375 | 159900.0 |
| 2000-06-21 13:00:00 | SPY | ETF | 147.125 | 147.8125 | 147.0312 | 147.7812 | 90800.0 |
| 2000-06-21 14:00:00 | SPY | ETF | 147.625 | 147.9688 | 147.125 | 147.7812 | 1301200.0 |
| 2000-06-21 15:00:00 | SPY | ETF | 147.75 | 148.4375 | 147.5625 | 147.9375 | 536200.0 |
| 2000-06-21 16:00:00 | SPY | ETF | 147.9688 | 148.125 | 147.8125 | 147.8438 | 162600.0 |
| 2000-06-21 18:00:00 | SPY | ETF | 147.875 | 147.875 | 147.875 | 147.875 | 100.0 |
| 2000-06-21 09:00:00 | QQQ | ETF | 96.8125 | 97.9375 | 96.6875 | 97.875 | 2890900.0 |
| 2000-06-21 10:00:00 | QQQ | ETF | 97.75 | 99.0 | 97.625 | 97.875 | 4738200.0 |
| 2000-06-21 11:00:00 | QQQ | ETF | 97.875 | 98.3125 | 97.3125 | 97.875 | 2288400.0 |
| 2000-06-21 12:00:00 | QQQ | ETF | 97.8125 | 98.25 | 97.625 | 97.7188 | 1595900.0 |
| 2000-06-21 13:00:00 | QQQ | ETF | 97.7188 | 98.625 | 97.4062 | 98.375 | 3118400.0 |
| 2000-06-21 14:00:00 | QQQ | ETF | 98.5 | 99.125 | 98.0 | 98.75 | 2842000.0 |
| 2000-06-21 15:00:00 | QQQ | ETF | 99.0 | 99.7188 | 98.625 | 98.9375 | 2972700.0 |
| 2000-06-21 16:00:00 | QQQ | ETF | 98.9375 | 98.9375 | 98.5 | 98.875 | 310200.0 |
| 2000-06-21 17:00:00 | QQQ | ETF | 98.875 | 98.875 | 98.875 | 98.875 | 400.0 |
| 2000-06-21 09:00:00 | IWM | ETF | 52.125 | 52.125 | 52.125 | 52.125 | 6600.0 |
| 2000-06-21 10:00:00 | IWM | ETF | 52.5938 | 52.75 | 52.5938 | 52.6094 | 5800.0 |
| 2000-06-21 11:00:00 | IWM | ETF | 52.6094 | 52.6094 | 52.5312 | 52.5312 | 3800.0 |
| 2000-06-21 12:00:00 | IWM | ETF | 52.5312 | 52.5312 | 52.5312 | 52.5312 | 1000.0 |
| 2000-06-21 13:00:00 | IWM | ETF | 52.5156 | 52.625 | 52.5156 | 52.625 | 3000.0 |
| 2000-06-21 14:00:00 | IWM | ETF | 52.625 | 52.8594 | 52.625 | 52.8594 | 22000.0 |
| 2000-06-21 15:00:00 | IWM | ETF | 52.7812 | 52.9375 | 52.75 | 52.8438 | 24600.0 |
| 2000-06-21 09:00:00 | DIA | ETF | 104.3125 | 104.625 | 104.2188 | 104.5 | 129500.0 |
| 2000-06-21 10:00:00 | DIA | ETF | 104.5 | 104.75 | 104.1875 | 104.4688 | 111100.0 |
| 2000-06-21 11:00:00 | DIA | ETF | 104.2812 | 104.5 | 104.125 | 104.375 | 35600.0 |
| 2000-06-21 12:00:00 | DIA | ETF | 104.625 | 104.8438 | 104.5 | 104.5 | 30700.0 |
| 2000-06-21 13:00:00 | DIA | ETF | 104.5625 | 105.0625 | 104.4062 | 104.9375 | 113400.0 |
| 2000-06-21 14:00:00 | DIA | ETF | 104.8125 | 104.9688 | 104.4062 | 104.9688 | 55700.0 |
| 2000-06-21 15:00:00 | DIA | ETF | 104.6875 | 105.25 | 104.625 | 104.875 | 91400.0 |
| 2000-06-21 16:00:00 | DIA | ETF | 104.9375 | 105.0938 | 104.9062 | 104.9375 | 32300.0 |
> showing 33 of 158 rows — these rows as CSV