PREVIEW / etf_1hour / 2000-10-16
file: by_date/etf_1hour/2000/2000-10-16.parquet size: 9 KB rows: 191
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-16 09:00:00 | SPY | ETF | 137.4062 | 138.0938 | 137.1562 | 137.9375 | 1207300.0 |
| 2000-10-16 10:00:00 | SPY | ETF | 137.8438 | 138.2188 | 137.125 | 137.3125 | 562600.0 |
| 2000-10-16 11:00:00 | SPY | ETF | 137.375 | 137.5625 | 136.6875 | 136.8125 | 986900.0 |
| 2000-10-16 12:00:00 | SPY | ETF | 136.875 | 137.5312 | 136.6875 | 137.5 | 319300.0 |
| 2000-10-16 13:00:00 | SPY | ETF | 137.5 | 137.7188 | 136.9688 | 137.375 | 390300.0 |
| 2000-10-16 14:00:00 | SPY | ETF | 137.375 | 138.2188 | 137.375 | 138.0625 | 937300.0 |
| 2000-10-16 15:00:00 | SPY | ETF | 138.0 | 138.0938 | 137.2812 | 137.4688 | 620900.0 |
| 2000-10-16 16:00:00 | SPY | ETF | 137.4688 | 138.1875 | 137.4375 | 138.1875 | 456700.0 |
| 2000-10-16 09:00:00 | QQQ | ETF | 81.125 | 82.3125 | 80.375 | 81.8125 | 4751900.0 |
| 2000-10-16 10:00:00 | QQQ | ETF | 81.875 | 82.0 | 80.4375 | 80.75 | 5033200.0 |
| 2000-10-16 11:00:00 | QQQ | ETF | 80.7188 | 80.8125 | 79.75 | 80.0625 | 4500900.0 |
| 2000-10-16 12:00:00 | QQQ | ETF | 80.125 | 80.9375 | 79.875 | 80.9375 | 2122300.0 |
| 2000-10-16 13:00:00 | QQQ | ETF | 80.9375 | 81.0 | 80.2812 | 80.5312 | 1696600.0 |
| 2000-10-16 14:00:00 | QQQ | ETF | 80.4688 | 82.25 | 80.4062 | 81.5625 | 3988800.0 |
| 2000-10-16 15:00:00 | QQQ | ETF | 81.5625 | 81.6875 | 80.5625 | 80.875 | 4249400.0 |
| 2000-10-16 16:00:00 | QQQ | ETF | 81.0 | 82.0 | 80.875 | 81.5625 | 579300.0 |
| 2000-10-16 17:00:00 | QQQ | ETF | 81.5625 | 82.25 | 81.5625 | 82.0 | 27900.0 |
| 2000-10-16 18:00:00 | QQQ | ETF | 82.0 | 82.25 | 82.0 | 82.25 | 15300.0 |
| 2000-10-16 09:00:00 | IWM | ETF | 48.0 | 48.0312 | 47.7188 | 48.0312 | 22600.0 |
| 2000-10-16 10:00:00 | IWM | ETF | 48.2188 | 48.5156 | 48.0625 | 48.4375 | 615400.0 |
| 2000-10-16 11:00:00 | IWM | ETF | 48.0938 | 48.25 | 48.0938 | 48.1875 | 18400.0 |
| 2000-10-16 12:00:00 | IWM | ETF | 48.0938 | 48.3438 | 48.0625 | 48.3438 | 21000.0 |
| 2000-10-16 13:00:00 | IWM | ETF | 48.2812 | 48.4375 | 48.2812 | 48.4062 | 29400.0 |
| 2000-10-16 14:00:00 | IWM | ETF | 48.3438 | 48.5312 | 48.3438 | 48.4688 | 184000.0 |
| 2000-10-16 15:00:00 | IWM | ETF | 48.4375 | 48.5156 | 48.1875 | 48.1875 | 206800.0 |
| 2000-10-16 16:00:00 | IWM | ETF | 48.125 | 48.125 | 48.125 | 48.125 | 400.0 |
| 2000-10-16 09:00:00 | DIA | ETF | 102.2188 | 102.75 | 102.0625 | 102.5625 | 87300.0 |
| 2000-10-16 10:00:00 | DIA | ETF | 102.5312 | 102.75 | 102.125 | 102.25 | 111500.0 |
| 2000-10-16 11:00:00 | DIA | ETF | 102.25 | 102.4062 | 102.0312 | 102.125 | 45400.0 |
| 2000-10-16 12:00:00 | DIA | ETF | 102.125 | 102.5938 | 102.0625 | 102.5312 | 23900.0 |
| 2000-10-16 13:00:00 | DIA | ETF | 102.5312 | 102.7188 | 102.1875 | 102.4375 | 47600.0 |
| 2000-10-16 14:00:00 | DIA | ETF | 102.4375 | 102.7812 | 102.3438 | 102.625 | 66200.0 |
| 2000-10-16 15:00:00 | DIA | ETF | 102.5312 | 102.9375 | 102.3438 | 102.5 | 172100.0 |
| 2000-10-16 16:00:00 | DIA | ETF | 102.4688 | 102.8125 | 102.4688 | 102.6875 | 2500.0 |
> showing 34 of 191 rows — these rows as CSV