PREVIEW / etf_1hour / 2000-08-29
file: by_date/etf_1hour/2000/2000-08-29.parquet size: 9 KB rows: 178
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-29 09:00:00 | SPY | ETF | 151.4375 | 151.6875 | 151.3438 | 151.625 | 534000.0 |
| 2000-08-29 10:00:00 | SPY | ETF | 151.5625 | 151.75 | 150.9062 | 151.0 | 632300.0 |
| 2000-08-29 11:00:00 | SPY | ETF | 151.0 | 151.375 | 150.9375 | 151.25 | 296100.0 |
| 2000-08-29 12:00:00 | SPY | ETF | 151.3438 | 151.7812 | 151.25 | 151.7188 | 139400.0 |
| 2000-08-29 13:00:00 | SPY | ETF | 151.6562 | 151.875 | 151.4688 | 151.5625 | 379900.0 |
| 2000-08-29 14:00:00 | SPY | ETF | 151.5 | 151.625 | 151.125 | 151.2812 | 446700.0 |
| 2000-08-29 15:00:00 | SPY | ETF | 151.375 | 151.6875 | 151.2812 | 151.5 | 760800.0 |
| 2000-08-29 16:00:00 | SPY | ETF | 151.5625 | 151.8438 | 151.3125 | 151.7812 | 271300.0 |
| 2000-08-29 09:00:00 | QQQ | ETF | 98.625 | 98.9688 | 98.125 | 98.7188 | 1836600.0 |
| 2000-08-29 10:00:00 | QQQ | ETF | 98.75 | 98.9688 | 97.8438 | 97.875 | 2245000.0 |
| 2000-08-29 11:00:00 | QQQ | ETF | 97.9062 | 98.625 | 97.875 | 98.4375 | 1230800.0 |
| 2000-08-29 12:00:00 | QQQ | ETF | 98.4375 | 98.9375 | 98.375 | 98.875 | 1563500.0 |
| 2000-08-29 13:00:00 | QQQ | ETF | 98.875 | 99.125 | 98.625 | 98.75 | 1594700.0 |
| 2000-08-29 14:00:00 | QQQ | ETF | 98.6875 | 98.75 | 98.3125 | 98.4688 | 815400.0 |
| 2000-08-29 15:00:00 | QQQ | ETF | 98.4375 | 99.1562 | 98.4062 | 98.625 | 1656500.0 |
| 2000-08-29 16:00:00 | QQQ | ETF | 98.6562 | 99.125 | 98.5 | 98.5 | 185500.0 |
| 2000-08-29 17:00:00 | QQQ | ETF | 99.125 | 99.125 | 99.0 | 99.0 | 300.0 |
| 2000-08-29 09:00:00 | IWM | ETF | 52.7812 | 52.7812 | 52.7812 | 52.7812 | 1800.0 |
| 2000-08-29 10:00:00 | IWM | ETF | 52.9219 | 53.0 | 52.6562 | 52.6562 | 9200.0 |
| 2000-08-29 11:00:00 | IWM | ETF | 52.625 | 52.8125 | 52.625 | 52.8125 | 15200.0 |
| 2000-08-29 13:00:00 | IWM | ETF | 52.8438 | 53.0938 | 52.8438 | 53.0 | 21600.0 |
| 2000-08-29 14:00:00 | IWM | ETF | 52.9375 | 52.9844 | 52.8438 | 52.9844 | 34800.0 |
| 2000-08-29 15:00:00 | IWM | ETF | 53.0 | 53.125 | 53.0 | 53.125 | 7600.0 |
| 2000-08-29 16:00:00 | IWM | ETF | 53.1562 | 53.1562 | 53.1562 | 53.1562 | 50000.0 |
| 2000-08-29 09:00:00 | DIA | ETF | 112.4375 | 112.5 | 112.125 | 112.25 | 67800.0 |
| 2000-08-29 10:00:00 | DIA | ETF | 112.2812 | 112.4062 | 112.0 | 112.125 | 79300.0 |
| 2000-08-29 11:00:00 | DIA | ETF | 112.125 | 112.2812 | 112.0 | 112.2188 | 54900.0 |
| 2000-08-29 12:00:00 | DIA | ETF | 112.1875 | 112.5 | 112.1875 | 112.3438 | 34800.0 |
| 2000-08-29 13:00:00 | DIA | ETF | 112.5 | 112.625 | 112.2812 | 112.5625 | 30100.0 |
| 2000-08-29 14:00:00 | DIA | ETF | 112.3125 | 112.4688 | 112.1875 | 112.4062 | 26300.0 |
| 2000-08-29 15:00:00 | DIA | ETF | 112.375 | 112.5 | 112.125 | 112.25 | 25700.0 |
| 2000-08-29 16:00:00 | DIA | ETF | 112.25 | 112.5312 | 112.2188 | 112.5312 | 8200.0 |
> showing 32 of 178 rows — these rows as CSV