PREVIEW / etf_1hour / 2000-08-25
file: by_date/etf_1hour/2000/2000-08-25.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-08-25 09:00:00 | SPY | ETF | 151.1562 | 151.625 | 151.1562 | 151.375 | 773600.0 |
| 2000-08-25 10:00:00 | SPY | ETF | 151.375 | 151.625 | 150.9375 | 151.125 | 412600.0 |
| 2000-08-25 11:00:00 | SPY | ETF | 151.0312 | 151.4375 | 151.0312 | 151.4375 | 558200.0 |
| 2000-08-25 12:00:00 | SPY | ETF | 151.375 | 151.5938 | 151.25 | 151.4688 | 227400.0 |
| 2000-08-25 13:00:00 | SPY | ETF | 151.5625 | 151.5938 | 151.125 | 151.2188 | 247800.0 |
| 2000-08-25 14:00:00 | SPY | ETF | 151.125 | 151.5 | 151.125 | 151.3125 | 227400.0 |
| 2000-08-25 15:00:00 | SPY | ETF | 151.25 | 151.375 | 151.0 | 151.0938 | 247300.0 |
| 2000-08-25 16:00:00 | SPY | ETF | 151.1562 | 151.3125 | 151.0938 | 151.25 | 125300.0 |
| 2000-08-25 09:00:00 | QQQ | ETF | 98.4688 | 99.4688 | 98.1875 | 99.0312 | 2877800.0 |
| 2000-08-25 10:00:00 | QQQ | ETF | 99.0312 | 99.375 | 97.625 | 98.0625 | 2952200.0 |
| 2000-08-25 11:00:00 | QQQ | ETF | 98.0938 | 98.5938 | 97.875 | 98.5938 | 1607700.0 |
| 2000-08-25 12:00:00 | QQQ | ETF | 98.5 | 98.8438 | 98.2812 | 98.625 | 1056200.0 |
| 2000-08-25 13:00:00 | QQQ | ETF | 98.6562 | 98.9062 | 97.875 | 98.0312 | 1054100.0 |
| 2000-08-25 14:00:00 | QQQ | ETF | 98.0 | 98.5 | 97.9375 | 98.2812 | 581600.0 |
| 2000-08-25 15:00:00 | QQQ | ETF | 98.25 | 98.3438 | 97.8125 | 98.125 | 1304600.0 |
| 2000-08-25 16:00:00 | QQQ | ETF | 98.0625 | 98.4375 | 98.0625 | 98.3125 | 282300.0 |
| 2000-08-25 17:00:00 | QQQ | ETF | 98.1875 | 98.1875 | 98.0312 | 98.0312 | 500.0 |
| 2000-08-25 09:00:00 | IWM | ETF | 52.375 | 52.6875 | 52.375 | 52.6875 | 76400.0 |
| 2000-08-25 10:00:00 | IWM | ETF | 52.375 | 52.3906 | 52.2188 | 52.2656 | 57000.0 |
| 2000-08-25 11:00:00 | IWM | ETF | 52.5 | 52.5156 | 52.3125 | 52.3281 | 54000.0 |
| 2000-08-25 12:00:00 | IWM | ETF | 52.375 | 52.5938 | 52.375 | 52.5 | 7400.0 |
| 2000-08-25 13:00:00 | IWM | ETF | 52.5781 | 52.5938 | 52.4375 | 52.4844 | 3800.0 |
| 2000-08-25 14:00:00 | IWM | ETF | 52.4844 | 52.4844 | 52.4844 | 52.4844 | 400.0 |
| 2000-08-25 16:00:00 | IWM | ETF | 52.5625 | 52.5625 | 52.5625 | 52.5625 | 9600.0 |
| 2000-08-25 09:00:00 | DIA | ETF | 111.875 | 112.1875 | 111.6875 | 111.75 | 40200.0 |
| 2000-08-25 10:00:00 | DIA | ETF | 111.7188 | 111.9375 | 111.5312 | 111.625 | 26000.0 |
| 2000-08-25 11:00:00 | DIA | ETF | 111.625 | 111.9688 | 111.625 | 111.9062 | 18200.0 |
| 2000-08-25 12:00:00 | DIA | ETF | 111.9688 | 112.25 | 111.8125 | 112.25 | 19700.0 |
| 2000-08-25 13:00:00 | DIA | ETF | 112.2188 | 112.2188 | 111.8438 | 112.0 | 9000.0 |
| 2000-08-25 14:00:00 | DIA | ETF | 111.875 | 112.125 | 111.8438 | 112.125 | 6400.0 |
| 2000-08-25 15:00:00 | DIA | ETF | 112.0938 | 112.125 | 111.8125 | 112.0 | 6600.0 |
| 2000-08-25 16:00:00 | DIA | ETF | 112.0 | 112.2188 | 112.0 | 112.2188 | 8700.0 |
> showing 32 of 158 rows — these rows as CSV