PREVIEW / etf_1hour / 2000-07-07
file: by_date/etf_1hour/2000/2000-07-07.parquet size: 9 KB rows: 161
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-07-07 09:00:00 | SPY | ETF | 146.6875 | 147.375 | 146.25 | 147.25 | 641300.0 |
| 2000-07-07 10:00:00 | SPY | ETF | 147.1562 | 147.7812 | 147.125 | 147.75 | 389900.0 |
| 2000-07-07 11:00:00 | SPY | ETF | 147.75 | 148.4688 | 147.75 | 148.0 | 418300.0 |
| 2000-07-07 12:00:00 | SPY | ETF | 148.0625 | 148.3438 | 147.9688 | 148.0625 | 182200.0 |
| 2000-07-07 13:00:00 | SPY | ETF | 148.1875 | 148.3125 | 147.875 | 148.0 | 259600.0 |
| 2000-07-07 14:00:00 | SPY | ETF | 148.0 | 148.5 | 148.0 | 148.375 | 120600.0 |
| 2000-07-07 15:00:00 | SPY | ETF | 148.5 | 148.7812 | 148.0312 | 148.0938 | 659500.0 |
| 2000-07-07 16:00:00 | SPY | ETF | 148.25 | 148.25 | 147.9062 | 148.0938 | 263000.0 |
| 2000-07-07 09:00:00 | QQQ | ETF | 95.0 | 95.875 | 94.4375 | 95.625 | 3149800.0 |
| 2000-07-07 10:00:00 | QQQ | ETF | 95.6562 | 96.5 | 95.4062 | 96.4062 | 2442400.0 |
| 2000-07-07 11:00:00 | QQQ | ETF | 96.4688 | 96.875 | 96.4375 | 96.5938 | 1751100.0 |
| 2000-07-07 12:00:00 | QQQ | ETF | 96.5625 | 96.7812 | 96.25 | 96.4375 | 2073700.0 |
| 2000-07-07 13:00:00 | QQQ | ETF | 96.4375 | 96.5625 | 95.9375 | 96.3125 | 1360600.0 |
| 2000-07-07 14:00:00 | QQQ | ETF | 96.3125 | 96.875 | 96.1875 | 96.75 | 1813400.0 |
| 2000-07-07 15:00:00 | QQQ | ETF | 96.8125 | 97.0 | 95.75 | 95.875 | 3273000.0 |
| 2000-07-07 16:00:00 | QQQ | ETF | 95.75 | 96.25 | 95.375 | 95.625 | 611100.0 |
| 2000-07-07 17:00:00 | QQQ | ETF | 95.9375 | 95.9375 | 95.9375 | 95.9375 | 600.0 |
| 2000-07-07 09:00:00 | IWM | ETF | 52.4219 | 52.6094 | 52.4219 | 52.5938 | 7200.0 |
| 2000-07-07 10:00:00 | IWM | ETF | 52.5938 | 52.7344 | 52.5312 | 52.625 | 9600.0 |
| 2000-07-07 11:00:00 | IWM | ETF | 52.6562 | 52.7969 | 52.625 | 52.7969 | 5400.0 |
| 2000-07-07 12:00:00 | IWM | ETF | 52.7812 | 52.7812 | 52.6875 | 52.6875 | 13000.0 |
| 2000-07-07 13:00:00 | IWM | ETF | 52.7812 | 52.8438 | 52.7812 | 52.7969 | 10400.0 |
| 2000-07-07 14:00:00 | IWM | ETF | 52.8125 | 52.875 | 52.8125 | 52.875 | 1200.0 |
| 2000-07-07 15:00:00 | IWM | ETF | 52.9531 | 52.9531 | 52.8125 | 52.8438 | 24600.0 |
| 2000-07-07 16:00:00 | IWM | ETF | 52.75 | 52.75 | 52.75 | 52.75 | 400.0 |
| 2000-07-07 09:00:00 | DIA | ETF | 105.5625 | 105.9375 | 105.1562 | 105.6875 | 106100.0 |
| 2000-07-07 10:00:00 | DIA | ETF | 105.75 | 106.1875 | 105.625 | 106.0625 | 89600.0 |
| 2000-07-07 11:00:00 | DIA | ETF | 106.1562 | 106.5 | 106.0 | 106.25 | 79900.0 |
| 2000-07-07 12:00:00 | DIA | ETF | 106.125 | 106.4688 | 106.125 | 106.3438 | 32700.0 |
| 2000-07-07 13:00:00 | DIA | ETF | 106.1875 | 106.4062 | 106.0938 | 106.1562 | 62100.0 |
| 2000-07-07 14:00:00 | DIA | ETF | 106.0625 | 106.5938 | 106.0625 | 106.375 | 75100.0 |
| 2000-07-07 15:00:00 | DIA | ETF | 106.5 | 106.75 | 106.4062 | 106.5625 | 138300.0 |
| 2000-07-07 16:00:00 | DIA | ETF | 106.4375 | 106.625 | 106.3125 | 106.3125 | 20700.0 |
> showing 33 of 161 rows — these rows as CSV