PREVIEW / etf_1hour / 2000-11-01
file: by_date/etf_1hour/2000/2000-11-01.parquet size: 10 KB rows: 190
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-11-01 09:00:00 | SPY | ETF | 142.25 | 143.125 | 142.2188 | 142.7188 | 1025700.0 |
| 2000-11-01 10:00:00 | SPY | ETF | 142.75 | 143.25 | 142.2188 | 143.2188 | 1545800.0 |
| 2000-11-01 11:00:00 | SPY | ETF | 143.0625 | 143.25 | 142.625 | 142.75 | 695800.0 |
| 2000-11-01 12:00:00 | SPY | ETF | 142.6875 | 142.9062 | 142.125 | 142.1562 | 498200.0 |
| 2000-11-01 13:00:00 | SPY | ETF | 142.25 | 142.5 | 141.625 | 141.75 | 582900.0 |
| 2000-11-01 14:00:00 | SPY | ETF | 141.8438 | 142.0625 | 141.5 | 141.75 | 497000.0 |
| 2000-11-01 15:00:00 | SPY | ETF | 141.5625 | 142.6875 | 141.2188 | 142.4062 | 1299900.0 |
| 2000-11-01 16:00:00 | SPY | ETF | 142.4688 | 143.1562 | 142.3125 | 142.4688 | 402700.0 |
| 2000-11-01 09:00:00 | QQQ | ETF | 80.3125 | 81.1875 | 80.0 | 80.5312 | 5844700.0 |
| 2000-11-01 10:00:00 | QQQ | ETF | 80.4375 | 82.375 | 79.1875 | 82.25 | 10432900.0 |
| 2000-11-01 11:00:00 | QQQ | ETF | 82.1875 | 82.8125 | 81.25 | 81.375 | 6836200.0 |
| 2000-11-01 12:00:00 | QQQ | ETF | 81.375 | 81.8125 | 80.25 | 80.5312 | 4320200.0 |
| 2000-11-01 13:00:00 | QQQ | ETF | 80.5625 | 81.375 | 80.0625 | 80.25 | 4403700.0 |
| 2000-11-01 14:00:00 | QQQ | ETF | 80.25 | 80.9062 | 79.8438 | 80.0312 | 4542600.0 |
| 2000-11-01 15:00:00 | QQQ | ETF | 80.0 | 80.875 | 79.5 | 80.625 | 6040200.0 |
| 2000-11-01 16:00:00 | QQQ | ETF | 80.625 | 81.625 | 80.5 | 80.875 | 883000.0 |
| 2000-11-01 17:00:00 | QQQ | ETF | 81.0 | 81.5625 | 81.0 | 81.375 | 7600.0 |
| 2000-11-01 18:00:00 | QQQ | ETF | 81.3125 | 81.5625 | 80.75 | 81.5 | 3300.0 |
| 2000-11-01 09:00:00 | IWM | ETF | 49.3438 | 49.5312 | 49.3438 | 49.4375 | 32800.0 |
| 2000-11-01 10:00:00 | IWM | ETF | 49.4375 | 49.625 | 49.2812 | 49.625 | 157800.0 |
| 2000-11-01 11:00:00 | IWM | ETF | 49.6875 | 49.7188 | 49.5312 | 49.6875 | 154000.0 |
| 2000-11-01 12:00:00 | IWM | ETF | 49.6875 | 49.6875 | 49.4688 | 49.5 | 66800.0 |
| 2000-11-01 13:00:00 | IWM | ETF | 49.5 | 49.5 | 49.3438 | 49.3438 | 19800.0 |
| 2000-11-01 14:00:00 | IWM | ETF | 49.3438 | 49.5625 | 49.3438 | 49.3438 | 55200.0 |
| 2000-11-01 15:00:00 | IWM | ETF | 49.5312 | 49.6562 | 49.3594 | 49.5312 | 41600.0 |
| 2000-11-01 09:00:00 | DIA | ETF | 109.1562 | 109.9062 | 109.1562 | 109.4375 | 377000.0 |
| 2000-11-01 10:00:00 | DIA | ETF | 109.5 | 109.9062 | 109.1875 | 109.25 | 531700.0 |
| 2000-11-01 11:00:00 | DIA | ETF | 109.2188 | 109.4375 | 108.9375 | 109.2188 | 462900.0 |
| 2000-11-01 12:00:00 | DIA | ETF | 109.1562 | 109.2812 | 108.7812 | 108.8438 | 225900.0 |
| 2000-11-01 13:00:00 | DIA | ETF | 109.0 | 109.125 | 108.5625 | 108.75 | 379300.0 |
| 2000-11-01 14:00:00 | DIA | ETF | 108.8125 | 109.1562 | 108.5 | 108.625 | 838800.0 |
| 2000-11-01 15:00:00 | DIA | ETF | 108.5625 | 109.2188 | 108.4375 | 109.125 | 466900.0 |
| 2000-11-01 16:00:00 | DIA | ETF | 109.0 | 109.25 | 109.0 | 109.1562 | 17800.0 |
> showing 33 of 190 rows — these rows as CSV