PREVIEW / etf_1hour / 2000-08-09
file: by_date/etf_1hour/2000/2000-08-09.parquet size: 9 KB rows: 172
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-08-09 09:00:00 | SPY | ETF | 149.125 | 149.2188 | 148.6875 | 148.9688 | 634600.0 |
| 2000-08-09 10:00:00 | SPY | ETF | 148.875 | 149.0625 | 148.125 | 148.3125 | 604600.0 |
| 2000-08-09 11:00:00 | SPY | ETF | 148.375 | 148.4062 | 147.875 | 148.2188 | 859600.0 |
| 2000-08-09 12:00:00 | SPY | ETF | 148.2188 | 148.5 | 148.0938 | 148.3125 | 507700.0 |
| 2000-08-09 13:00:00 | SPY | ETF | 148.4375 | 148.75 | 148.125 | 148.1875 | 378700.0 |
| 2000-08-09 14:00:00 | SPY | ETF | 148.2188 | 148.875 | 148.125 | 148.6562 | 389300.0 |
| 2000-08-09 15:00:00 | SPY | ETF | 148.6875 | 148.75 | 147.375 | 147.6875 | 1735400.0 |
| 2000-08-09 16:00:00 | SPY | ETF | 147.625 | 147.7812 | 147.4062 | 147.4375 | 209000.0 |
| 2000-08-09 09:00:00 | QQQ | ETF | 93.6875 | 94.0 | 93.125 | 93.875 | 3379200.0 |
| 2000-08-09 10:00:00 | QQQ | ETF | 93.75 | 94.4375 | 93.0625 | 93.3125 | 4059900.0 |
| 2000-08-09 11:00:00 | QQQ | ETF | 93.3125 | 93.5 | 92.5625 | 93.0625 | 2449300.0 |
| 2000-08-09 12:00:00 | QQQ | ETF | 93.0625 | 93.6562 | 92.9375 | 93.25 | 1145300.0 |
| 2000-08-09 13:00:00 | QQQ | ETF | 93.2812 | 93.625 | 92.75 | 92.875 | 1241800.0 |
| 2000-08-09 14:00:00 | QQQ | ETF | 92.875 | 93.5 | 92.6875 | 93.25 | 1908900.0 |
| 2000-08-09 15:00:00 | QQQ | ETF | 93.25 | 93.4375 | 92.0 | 92.4688 | 3011200.0 |
| 2000-08-09 16:00:00 | QQQ | ETF | 92.1562 | 92.25 | 91.375 | 91.6875 | 1370100.0 |
| 2000-08-09 17:00:00 | QQQ | ETF | 91.5 | 91.9375 | 91.5 | 91.625 | 12200.0 |
| 2000-08-09 18:00:00 | QQQ | ETF | 91.625 | 91.625 | 91.625 | 91.625 | 200.0 |
| 2000-08-09 09:00:00 | IWM | ETF | 51.2812 | 51.2812 | 51.1562 | 51.1562 | 2400.0 |
| 2000-08-09 10:00:00 | IWM | ETF | 51.2188 | 51.2188 | 50.875 | 50.875 | 2800.0 |
| 2000-08-09 11:00:00 | IWM | ETF | 50.7812 | 50.8281 | 50.6875 | 50.6875 | 7200.0 |
| 2000-08-09 13:00:00 | IWM | ETF | 50.8438 | 51.0156 | 50.8438 | 51.0156 | 2400.0 |
| 2000-08-09 14:00:00 | IWM | ETF | 50.75 | 50.9219 | 50.75 | 50.75 | 4200.0 |
| 2000-08-09 15:00:00 | IWM | ETF | 50.9219 | 50.9219 | 50.5312 | 50.5312 | 4000.0 |
| 2000-08-09 09:00:00 | DIA | ETF | 109.4062 | 109.6562 | 109.1875 | 109.4375 | 205500.0 |
| 2000-08-09 10:00:00 | DIA | ETF | 109.2812 | 109.4375 | 108.9062 | 109.0 | 457200.0 |
| 2000-08-09 11:00:00 | DIA | ETF | 109.125 | 109.2812 | 108.9375 | 109.2188 | 56000.0 |
| 2000-08-09 12:00:00 | DIA | ETF | 109.25 | 109.3125 | 109.0312 | 109.0625 | 43600.0 |
| 2000-08-09 13:00:00 | DIA | ETF | 109.0625 | 109.6562 | 109.0625 | 109.4375 | 76100.0 |
| 2000-08-09 14:00:00 | DIA | ETF | 109.3125 | 109.7812 | 109.3125 | 109.6875 | 123600.0 |
| 2000-08-09 15:00:00 | DIA | ETF | 109.6875 | 109.75 | 108.9375 | 109.125 | 250800.0 |
| 2000-08-09 16:00:00 | DIA | ETF | 109.125 | 109.125 | 109.0 | 109.125 | 14200.0 |
> showing 32 of 172 rows — these rows as CSV