PREVIEW / etf_1hour / 2000-08-08
file: by_date/etf_1hour/2000/2000-08-08.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-08 09:00:00 | SPY | ETF | 147.5 | 147.9375 | 147.5 | 147.9375 | 717200.0 |
| 2000-08-08 10:00:00 | SPY | ETF | 147.9688 | 148.4062 | 147.7188 | 148.0 | 783200.0 |
| 2000-08-08 11:00:00 | SPY | ETF | 148.0625 | 148.4688 | 147.75 | 148.3125 | 272500.0 |
| 2000-08-08 12:00:00 | SPY | ETF | 148.3125 | 148.4688 | 148.1562 | 148.3438 | 195100.0 |
| 2000-08-08 13:00:00 | SPY | ETF | 148.3125 | 148.375 | 147.9375 | 148.375 | 215800.0 |
| 2000-08-08 14:00:00 | SPY | ETF | 148.375 | 148.6562 | 148.1875 | 148.5 | 530500.0 |
| 2000-08-08 15:00:00 | SPY | ETF | 148.5625 | 148.8125 | 148.375 | 148.5625 | 432700.0 |
| 2000-08-08 16:00:00 | SPY | ETF | 148.5625 | 148.7188 | 148.5312 | 148.6875 | 506500.0 |
| 2000-08-08 09:00:00 | QQQ | ETF | 92.0625 | 92.8125 | 91.8125 | 92.6562 | 2478900.0 |
| 2000-08-08 10:00:00 | QQQ | ETF | 92.6875 | 93.4375 | 92.25 | 92.25 | 2750400.0 |
| 2000-08-08 11:00:00 | QQQ | ETF | 92.2812 | 92.6875 | 91.75 | 92.4375 | 2068900.0 |
| 2000-08-08 12:00:00 | QQQ | ETF | 92.4375 | 92.7812 | 92.0 | 92.125 | 1014300.0 |
| 2000-08-08 13:00:00 | QQQ | ETF | 92.125 | 92.2812 | 91.5 | 92.0312 | 1746900.0 |
| 2000-08-08 14:00:00 | QQQ | ETF | 92.0312 | 92.25 | 91.625 | 92.1875 | 1317500.0 |
| 2000-08-08 15:00:00 | QQQ | ETF | 92.1562 | 92.6562 | 91.5 | 92.0625 | 2423600.0 |
| 2000-08-08 16:00:00 | QQQ | ETF | 92.0938 | 93.375 | 91.9062 | 93.0 | 826900.0 |
| 2000-08-08 17:00:00 | QQQ | ETF | 93.0625 | 93.625 | 92.875 | 93.625 | 39600.0 |
| 2000-08-08 18:00:00 | QQQ | ETF | 93.75 | 94.125 | 93.5625 | 94.125 | 22900.0 |
| 2000-08-08 09:00:00 | IWM | ETF | 51.0 | 51.0 | 50.9062 | 50.9062 | 5000.0 |
| 2000-08-08 10:00:00 | IWM | ETF | 51.0312 | 51.1562 | 51.0312 | 51.0938 | 15400.0 |
| 2000-08-08 11:00:00 | IWM | ETF | 51.125 | 51.125 | 51.125 | 51.125 | 20000.0 |
| 2000-08-08 12:00:00 | IWM | ETF | 51.0 | 51.1094 | 51.0 | 51.1094 | 1800.0 |
| 2000-08-08 13:00:00 | IWM | ETF | 51.0312 | 51.0938 | 51.0312 | 51.0938 | 1800.0 |
| 2000-08-08 14:00:00 | IWM | ETF | 51.1094 | 51.1094 | 51.0 | 51.0 | 1800.0 |
| 2000-08-08 15:00:00 | IWM | ETF | 51.1094 | 51.1094 | 50.9375 | 50.9375 | 3200.0 |
| 2000-08-08 16:00:00 | IWM | ETF | 50.9062 | 50.9062 | 50.9062 | 50.9062 | 600.0 |
| 2000-08-08 09:00:00 | DIA | ETF | 108.5625 | 108.9375 | 108.3438 | 108.9062 | 154700.0 |
| 2000-08-08 10:00:00 | DIA | ETF | 109.0 | 109.1562 | 108.8125 | 108.8438 | 69900.0 |
| 2000-08-08 11:00:00 | DIA | ETF | 108.9375 | 109.3125 | 108.8125 | 109.3125 | 83300.0 |
| 2000-08-08 12:00:00 | DIA | ETF | 109.1875 | 109.3438 | 108.9688 | 109.0938 | 15000.0 |
| 2000-08-08 13:00:00 | DIA | ETF | 109.0625 | 109.3125 | 108.9375 | 109.3125 | 71200.0 |
| 2000-08-08 14:00:00 | DIA | ETF | 109.3125 | 109.75 | 109.125 | 109.6875 | 124200.0 |
| 2000-08-08 15:00:00 | DIA | ETF | 109.7188 | 109.9688 | 109.5 | 109.75 | 281700.0 |
| 2000-08-08 16:00:00 | DIA | ETF | 109.8438 | 109.8438 | 109.5938 | 109.6562 | 7200.0 |
> showing 34 of 168 rows — these rows as CSV