PREVIEW / etf_1hour / 2000-08-24
file: by_date/etf_1hour/2000/2000-08-24.parquet size: 9 KB rows: 168
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-24 09:00:00 | SPY | ETF | 151.1562 | 151.1875 | 150.6875 | 151.125 | 1003200.0 |
| 2000-08-24 10:00:00 | SPY | ETF | 151.1875 | 151.4062 | 150.5 | 150.8125 | 1405200.0 |
| 2000-08-24 11:00:00 | SPY | ETF | 150.8438 | 151.0 | 150.5625 | 150.8438 | 297900.0 |
| 2000-08-24 12:00:00 | SPY | ETF | 150.8438 | 151.1562 | 150.75 | 151.0 | 311900.0 |
| 2000-08-24 13:00:00 | SPY | ETF | 151.0625 | 151.3125 | 150.875 | 150.9688 | 252700.0 |
| 2000-08-24 14:00:00 | SPY | ETF | 150.9062 | 151.2812 | 150.75 | 151.1875 | 237200.0 |
| 2000-08-24 15:00:00 | SPY | ETF | 151.1875 | 151.5312 | 151.125 | 151.4375 | 783100.0 |
| 2000-08-24 16:00:00 | SPY | ETF | 151.375 | 151.4062 | 151.0938 | 151.3125 | 212900.0 |
| 2000-08-24 09:00:00 | QQQ | ETF | 97.4375 | 97.8125 | 96.8125 | 97.6875 | 2957200.0 |
| 2000-08-24 10:00:00 | QQQ | ETF | 97.6875 | 98.2812 | 97.0 | 97.5312 | 3157700.0 |
| 2000-08-24 11:00:00 | QQQ | ETF | 97.5 | 97.875 | 97.3125 | 97.5625 | 825400.0 |
| 2000-08-24 12:00:00 | QQQ | ETF | 97.5625 | 98.125 | 97.5312 | 97.75 | 808400.0 |
| 2000-08-24 13:00:00 | QQQ | ETF | 97.75 | 98.1875 | 97.5 | 97.5625 | 1011100.0 |
| 2000-08-24 14:00:00 | QQQ | ETF | 97.625 | 98.0938 | 97.2812 | 97.9375 | 1121500.0 |
| 2000-08-24 15:00:00 | QQQ | ETF | 97.9375 | 98.6875 | 97.875 | 98.5938 | 3320100.0 |
| 2000-08-24 16:00:00 | QQQ | ETF | 98.5938 | 98.6875 | 98.375 | 98.5 | 331100.0 |
| 2000-08-24 17:00:00 | QQQ | ETF | 98.625 | 98.625 | 98.5625 | 98.5625 | 900.0 |
| 2000-08-24 09:00:00 | IWM | ETF | 51.8594 | 51.8594 | 51.8594 | 51.8594 | 600.0 |
| 2000-08-24 10:00:00 | IWM | ETF | 52.1094 | 52.1875 | 52.0 | 52.0 | 7000.0 |
| 2000-08-24 11:00:00 | IWM | ETF | 52.1562 | 52.25 | 52.1562 | 52.1875 | 3600.0 |
| 2000-08-24 12:00:00 | IWM | ETF | 52.1875 | 52.375 | 52.1875 | 52.1875 | 4000.0 |
| 2000-08-24 13:00:00 | IWM | ETF | 52.4062 | 52.4375 | 52.3906 | 52.4375 | 2200.0 |
| 2000-08-24 14:00:00 | IWM | ETF | 52.3438 | 52.3438 | 52.1562 | 52.1562 | 600.0 |
| 2000-08-24 15:00:00 | IWM | ETF | 52.4688 | 52.625 | 52.4219 | 52.4688 | 8800.0 |
| 2000-08-24 16:00:00 | IWM | ETF | 52.5938 | 52.5938 | 52.3438 | 52.3438 | 249400.0 |
| 2000-08-24 09:00:00 | DIA | ETF | 111.4062 | 111.5938 | 111.1562 | 111.5938 | 21000.0 |
| 2000-08-24 10:00:00 | DIA | ETF | 111.5 | 111.7188 | 111.3125 | 111.5938 | 47100.0 |
| 2000-08-24 11:00:00 | DIA | ETF | 111.375 | 111.7188 | 111.375 | 111.5 | 28900.0 |
| 2000-08-24 12:00:00 | DIA | ETF | 111.5 | 111.8125 | 111.5 | 111.7188 | 60300.0 |
| 2000-08-24 13:00:00 | DIA | ETF | 111.8125 | 111.9375 | 111.5938 | 111.75 | 19500.0 |
| 2000-08-24 14:00:00 | DIA | ETF | 111.7812 | 111.8125 | 111.5625 | 111.8125 | 22000.0 |
| 2000-08-24 15:00:00 | DIA | ETF | 111.75 | 112.125 | 111.6562 | 112.0312 | 185700.0 |
| 2000-08-24 16:00:00 | DIA | ETF | 112.0 | 112.0312 | 111.875 | 112.0312 | 23900.0 |
> showing 33 of 168 rows — these rows as CSV