PREVIEW / etf_1hour / 2000-07-19
file: by_date/etf_1hour/2000/2000-07-19.parquet size: 9 KB rows: 169
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-07-19 09:00:00 | SPY | ETF | 149.4688 | 149.9062 | 149.1875 | 149.1875 | 1122300.0 |
| 2000-07-19 10:00:00 | SPY | ETF | 149.3125 | 149.8125 | 149.125 | 149.375 | 393400.0 |
| 2000-07-19 11:00:00 | SPY | ETF | 149.375 | 149.4688 | 148.3438 | 148.375 | 1087000.0 |
| 2000-07-19 12:00:00 | SPY | ETF | 148.375 | 148.6875 | 148.25 | 148.5625 | 334500.0 |
| 2000-07-19 13:00:00 | SPY | ETF | 148.5 | 149.125 | 148.5 | 148.9375 | 1842400.0 |
| 2000-07-19 14:00:00 | SPY | ETF | 149.0 | 149.25 | 148.4375 | 148.5312 | 775100.0 |
| 2000-07-19 15:00:00 | SPY | ETF | 148.5625 | 149.0625 | 148.25 | 148.4375 | 1338400.0 |
| 2000-07-19 16:00:00 | SPY | ETF | 148.4062 | 148.875 | 148.4062 | 148.6875 | 747600.0 |
| 2000-07-19 17:00:00 | SPY | ETF | 148.5625 | 148.5625 | 148.5625 | 148.5625 | 1000.0 |
| 2000-07-19 09:00:00 | QQQ | ETF | 98.3125 | 98.9375 | 97.375 | 97.4375 | 3583800.0 |
| 2000-07-19 10:00:00 | QQQ | ETF | 97.5 | 98.3125 | 97.375 | 97.6562 | 2822100.0 |
| 2000-07-19 11:00:00 | QQQ | ETF | 97.6562 | 98.0 | 96.625 | 96.625 | 3415400.0 |
| 2000-07-19 12:00:00 | QQQ | ETF | 96.6875 | 97.0 | 96.4062 | 96.5 | 2317800.0 |
| 2000-07-19 13:00:00 | QQQ | ETF | 96.5625 | 97.3438 | 96.5625 | 97.0625 | 1820900.0 |
| 2000-07-19 14:00:00 | QQQ | ETF | 97.125 | 97.3438 | 96.125 | 96.375 | 1822900.0 |
| 2000-07-19 15:00:00 | QQQ | ETF | 96.25 | 96.6875 | 95.6562 | 96.0625 | 5133500.0 |
| 2000-07-19 16:00:00 | QQQ | ETF | 96.0312 | 97.0 | 96.0 | 96.6562 | 457400.0 |
| 2000-07-19 17:00:00 | QQQ | ETF | 96.75 | 97.3125 | 96.125 | 97.3125 | 10700.0 |
| 2000-07-19 18:00:00 | QQQ | ETF | 97.3125 | 97.625 | 96.875 | 97.25 | 405400.0 |
| 2000-07-19 09:00:00 | IWM | ETF | 53.3906 | 53.3906 | 53.1875 | 53.1875 | 1400.0 |
| 2000-07-19 10:00:00 | IWM | ETF | 53.2188 | 53.2188 | 53.2188 | 53.2188 | 7400.0 |
| 2000-07-19 11:00:00 | IWM | ETF | 53.2188 | 53.2188 | 52.8594 | 52.9531 | 5200.0 |
| 2000-07-19 12:00:00 | IWM | ETF | 52.9375 | 52.9375 | 52.875 | 52.9219 | 4200.0 |
| 2000-07-19 14:00:00 | IWM | ETF | 53.1094 | 53.1094 | 53.1094 | 53.1094 | 800.0 |
| 2000-07-19 15:00:00 | IWM | ETF | 52.9062 | 53.0 | 52.625 | 52.625 | 16400.0 |
| 2000-07-19 09:00:00 | DIA | ETF | 107.5625 | 108.0 | 107.5625 | 107.7812 | 195800.0 |
| 2000-07-19 10:00:00 | DIA | ETF | 107.7812 | 108.1562 | 107.625 | 107.8125 | 121600.0 |
| 2000-07-19 11:00:00 | DIA | ETF | 107.8125 | 107.9688 | 107.0938 | 107.1875 | 78400.0 |
| 2000-07-19 12:00:00 | DIA | ETF | 107.3125 | 107.3125 | 106.9375 | 107.0625 | 35800.0 |
| 2000-07-19 13:00:00 | DIA | ETF | 107.0625 | 107.4688 | 107.0312 | 107.4688 | 14100.0 |
| 2000-07-19 14:00:00 | DIA | ETF | 107.5 | 107.6875 | 107.1562 | 107.4062 | 170200.0 |
| 2000-07-19 15:00:00 | DIA | ETF | 107.0625 | 107.5625 | 107.0625 | 107.3125 | 146000.0 |
| 2000-07-19 16:00:00 | DIA | ETF | 107.2812 | 107.2812 | 107.1875 | 107.1875 | 1300.0 |
> showing 33 of 169 rows — these rows as CSV