PREVIEW / etf_1hour / 2000-10-05
file: by_date/etf_1hour/2000/2000-10-05.parquet size: 9 KB rows: 171
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-05 09:00:00 | SPY | ETF | 143.4062 | 144.625 | 143.4062 | 144.375 | 479400.0 |
| 2000-10-05 10:00:00 | SPY | ETF | 144.3125 | 144.625 | 143.6562 | 143.9062 | 904200.0 |
| 2000-10-05 11:00:00 | SPY | ETF | 143.875 | 144.3125 | 143.3125 | 143.375 | 498300.0 |
| 2000-10-05 12:00:00 | SPY | ETF | 143.3125 | 144.1562 | 143.3125 | 144.1562 | 622800.0 |
| 2000-10-05 13:00:00 | SPY | ETF | 144.125 | 144.5 | 143.7812 | 144.3125 | 165000.0 |
| 2000-10-05 14:00:00 | SPY | ETF | 144.2812 | 144.8438 | 143.6562 | 143.6562 | 708000.0 |
| 2000-10-05 15:00:00 | SPY | ETF | 143.6875 | 144.4062 | 143.6875 | 143.875 | 527700.0 |
| 2000-10-05 16:00:00 | SPY | ETF | 143.875 | 144.1875 | 143.8438 | 144.1875 | 630600.0 |
| 2000-10-05 09:00:00 | QQQ | ETF | 85.25 | 86.7188 | 84.6875 | 86.7188 | 4626300.0 |
| 2000-10-05 10:00:00 | QQQ | ETF | 86.5625 | 87.1875 | 85.375 | 85.5938 | 4750400.0 |
| 2000-10-05 11:00:00 | QQQ | ETF | 85.625 | 86.125 | 84.875 | 84.875 | 2994200.0 |
| 2000-10-05 12:00:00 | QQQ | ETF | 84.875 | 86.0625 | 84.75 | 85.875 | 2231300.0 |
| 2000-10-05 13:00:00 | QQQ | ETF | 85.9688 | 86.25 | 85.25 | 86.1875 | 2143500.0 |
| 2000-10-05 14:00:00 | QQQ | ETF | 86.0625 | 86.5 | 84.5625 | 84.5625 | 3158100.0 |
| 2000-10-05 15:00:00 | QQQ | ETF | 84.7188 | 86.0 | 84.625 | 85.5 | 2874700.0 |
| 2000-10-05 16:00:00 | QQQ | ETF | 85.5 | 85.9375 | 85.4062 | 85.9375 | 531900.0 |
| 2000-10-05 17:00:00 | QQQ | ETF | 85.875 | 86.0 | 85.875 | 86.0 | 7900.0 |
| 2000-10-05 18:00:00 | QQQ | ETF | 86.0 | 86.0 | 86.0 | 86.0 | 700.0 |
| 2000-10-05 09:00:00 | IWM | ETF | 50.625 | 50.625 | 50.5938 | 50.5938 | 4000.0 |
| 2000-10-05 10:00:00 | IWM | ETF | 50.8125 | 50.8125 | 50.75 | 50.75 | 84000.0 |
| 2000-10-05 11:00:00 | IWM | ETF | 50.6875 | 50.6875 | 50.4375 | 50.4375 | 2600.0 |
| 2000-10-05 12:00:00 | IWM | ETF | 50.3125 | 50.5625 | 50.3125 | 50.5 | 3800.0 |
| 2000-10-05 14:00:00 | IWM | ETF | 50.375 | 50.4688 | 50.375 | 50.4688 | 2000.0 |
| 2000-10-05 15:00:00 | IWM | ETF | 50.4375 | 50.5312 | 50.25 | 50.25 | 203000.0 |
| 2000-10-05 16:00:00 | IWM | ETF | 50.0938 | 50.2188 | 50.0312 | 50.0625 | 109400.0 |
| 2000-10-05 09:00:00 | DIA | ETF | 107.9375 | 108.5625 | 107.875 | 108.0625 | 85900.0 |
| 2000-10-05 10:00:00 | DIA | ETF | 108.0312 | 108.3125 | 107.5625 | 107.625 | 228900.0 |
| 2000-10-05 11:00:00 | DIA | ETF | 107.625 | 107.9375 | 107.4375 | 107.5 | 72800.0 |
| 2000-10-05 12:00:00 | DIA | ETF | 107.4375 | 107.7812 | 107.3125 | 107.7812 | 62700.0 |
| 2000-10-05 13:00:00 | DIA | ETF | 107.75 | 107.75 | 107.5 | 107.625 | 6500.0 |
| 2000-10-05 14:00:00 | DIA | ETF | 107.5938 | 107.7812 | 107.4062 | 107.4062 | 63800.0 |
| 2000-10-05 15:00:00 | DIA | ETF | 107.5 | 107.7812 | 107.1875 | 107.375 | 92500.0 |
| 2000-10-05 16:00:00 | DIA | ETF | 107.3438 | 107.4688 | 107.3125 | 107.4688 | 39000.0 |
> showing 33 of 171 rows — these rows as CSV