PREVIEW / etf_1hour / 2000-10-24
file: by_date/etf_1hour/2000/2000-10-24.parquet size: 9 KB rows: 170
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-10-24 09:00:00 | SPY | ETF | 140.9688 | 141.375 | 140.6875 | 141.0 | 854200.0 |
| 2000-10-24 10:00:00 | SPY | ETF | 140.875 | 141.75 | 140.5312 | 141.3438 | 553400.0 |
| 2000-10-24 11:00:00 | SPY | ETF | 141.4688 | 141.9375 | 141.1562 | 141.5625 | 281200.0 |
| 2000-10-24 12:00:00 | SPY | ETF | 141.625 | 141.6562 | 140.5625 | 140.5625 | 773200.0 |
| 2000-10-24 13:00:00 | SPY | ETF | 140.75 | 140.9062 | 140.0625 | 140.1875 | 719100.0 |
| 2000-10-24 14:00:00 | SPY | ETF | 140.1875 | 140.5 | 139.0 | 139.125 | 664700.0 |
| 2000-10-24 15:00:00 | SPY | ETF | 139.2188 | 140.375 | 139.0625 | 140.125 | 986400.0 |
| 2000-10-24 16:00:00 | SPY | ETF | 140.0312 | 140.4062 | 138.8125 | 138.8125 | 672000.0 |
| 2000-10-24 17:00:00 | SPY | ETF | 138.9375 | 138.9375 | 138.875 | 138.875 | 200.0 |
| 2000-10-24 09:00:00 | QQQ | ETF | 86.4375 | 86.5 | 85.75 | 85.8125 | 3385000.0 |
| 2000-10-24 10:00:00 | QQQ | ETF | 85.9375 | 86.75 | 85.2812 | 86.2812 | 3673200.0 |
| 2000-10-24 11:00:00 | QQQ | ETF | 86.2812 | 87.0 | 85.875 | 86.625 | 3174500.0 |
| 2000-10-24 12:00:00 | QQQ | ETF | 86.625 | 86.8125 | 85.375 | 85.4375 | 2322800.0 |
| 2000-10-24 13:00:00 | QQQ | ETF | 85.4375 | 85.5625 | 84.25 | 84.5625 | 4181200.0 |
| 2000-10-24 14:00:00 | QQQ | ETF | 84.625 | 85.0 | 83.1875 | 83.5 | 4612000.0 |
| 2000-10-24 15:00:00 | QQQ | ETF | 83.4375 | 84.0 | 82.875 | 83.8125 | 5838800.0 |
| 2000-10-24 16:00:00 | QQQ | ETF | 83.8125 | 83.9375 | 81.5625 | 81.75 | 3746300.0 |
| 2000-10-24 17:00:00 | QQQ | ETF | 81.75 | 83.5312 | 81.0 | 81.0 | 76900.0 |
| 2000-10-24 18:00:00 | QQQ | ETF | 81.125 | 82.0 | 80.5 | 80.5 | 15500.0 |
| 2000-10-24 09:00:00 | IWM | ETF | 49.2188 | 49.25 | 49.1562 | 49.25 | 12000.0 |
| 2000-10-24 10:00:00 | IWM | ETF | 49.1875 | 49.4062 | 49.0625 | 49.4062 | 4200.0 |
| 2000-10-24 11:00:00 | IWM | ETF | 49.3906 | 49.5156 | 49.3906 | 49.5156 | 3000.0 |
| 2000-10-24 12:00:00 | IWM | ETF | 49.5156 | 49.5312 | 49.5156 | 49.5312 | 800.0 |
| 2000-10-24 13:00:00 | IWM | ETF | 49.2812 | 49.2812 | 49.1562 | 49.1562 | 1000.0 |
| 2000-10-24 14:00:00 | IWM | ETF | 49.0 | 49.0 | 48.9062 | 48.9375 | 5200.0 |
| 2000-10-24 15:00:00 | IWM | ETF | 48.625 | 48.6562 | 48.625 | 48.625 | 46000.0 |
| 2000-10-24 16:00:00 | IWM | ETF | 48.5312 | 48.5625 | 48.3438 | 48.3438 | 1600.0 |
| 2000-10-24 09:00:00 | DIA | ETF | 103.25 | 103.9062 | 103.0938 | 103.5625 | 266900.0 |
| 2000-10-24 10:00:00 | DIA | ETF | 103.5 | 104.1562 | 103.375 | 103.9688 | 320800.0 |
| 2000-10-24 11:00:00 | DIA | ETF | 103.875 | 104.3438 | 103.875 | 104.0625 | 283300.0 |
| 2000-10-24 12:00:00 | DIA | ETF | 104.125 | 104.25 | 103.8125 | 103.9688 | 64100.0 |
| 2000-10-24 13:00:00 | DIA | ETF | 103.875 | 104.0 | 103.5625 | 103.6875 | 76600.0 |
| 2000-10-24 14:00:00 | DIA | ETF | 103.6875 | 103.875 | 102.8438 | 103.0625 | 128900.0 |
| 2000-10-24 15:00:00 | DIA | ETF | 103.0312 | 104.1562 | 103.0312 | 103.9375 | 210300.0 |
| 2000-10-24 16:00:00 | DIA | ETF | 103.875 | 104.0 | 103.375 | 103.4375 | 149400.0 |
> showing 35 of 170 rows — these rows as CSV