PREVIEW / etf_1hour / 2000-05-26
file: by_date/etf_1hour/2000/2000-05-26.parquet size: 8 KB rows: 137
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-05-26 09:00:00 | SPY | ETF | 138.8125 | 139.6875 | 138.25 | 138.375 | 1175200.0 |
| 2000-05-26 10:00:00 | SPY | ETF | 138.375 | 139.25 | 137.5312 | 138.7188 | 1101200.0 |
| 2000-05-26 11:00:00 | SPY | ETF | 138.75 | 139.4375 | 138.1875 | 139.25 | 481100.0 |
| 2000-05-26 12:00:00 | SPY | ETF | 139.1875 | 139.3125 | 138.4062 | 138.5 | 691800.0 |
| 2000-05-26 13:00:00 | SPY | ETF | 138.5 | 138.625 | 138.0 | 138.25 | 186700.0 |
| 2000-05-26 14:00:00 | SPY | ETF | 138.3125 | 138.3438 | 137.5 | 138.1562 | 329900.0 |
| 2000-05-26 15:00:00 | SPY | ETF | 138.0 | 138.4375 | 137.3125 | 138.3125 | 585300.0 |
| 2000-05-26 16:00:00 | SPY | ETF | 138.3438 | 138.6875 | 138.0 | 138.0 | 255500.0 |
| 2000-05-26 09:00:00 | QQQ | ETF | 77.75 | 79.25 | 76.75 | 77.0 | 3057900.0 |
| 2000-05-26 10:00:00 | QQQ | ETF | 77.25 | 78.0 | 75.75 | 77.0 | 5402700.0 |
| 2000-05-26 11:00:00 | QQQ | ETF | 77.0625 | 78.4688 | 76.875 | 78.0625 | 2295400.0 |
| 2000-05-26 12:00:00 | QQQ | ETF | 78.0 | 78.0625 | 76.5625 | 76.875 | 1686400.0 |
| 2000-05-26 13:00:00 | QQQ | ETF | 76.75 | 77.1875 | 76.25 | 76.75 | 1223200.0 |
| 2000-05-26 14:00:00 | QQQ | ETF | 76.75 | 77.3125 | 76.0 | 77.25 | 1844100.0 |
| 2000-05-26 15:00:00 | QQQ | ETF | 77.25 | 77.75 | 76.0 | 77.5 | 2187700.0 |
| 2000-05-26 16:00:00 | QQQ | ETF | 77.5 | 78.125 | 77.3125 | 77.6875 | 414800.0 |
| 2000-05-26 17:00:00 | QQQ | ETF | 77.6875 | 77.6875 | 77.6875 | 77.6875 | 1100.0 |
| 2000-05-26 18:00:00 | QQQ | ETF | 77.6875 | 77.75 | 77.6875 | 77.75 | 2600.0 |
| 2000-05-26 09:00:00 | IWM | ETF | 45.5312 | 45.5312 | 45.5312 | 45.5312 | 2000.0 |
| 2000-05-26 10:00:00 | IWM | ETF | 45.2812 | 45.5 | 45.2812 | 45.5 | 14000.0 |
| 2000-05-26 12:00:00 | IWM | ETF | 45.6719 | 45.6719 | 45.6719 | 45.6719 | 200.0 |
| 2000-05-26 13:00:00 | IWM | ETF | 45.5625 | 45.5625 | 45.5625 | 45.5625 | 10000.0 |
| 2000-05-26 14:00:00 | IWM | ETF | 45.3594 | 45.375 | 45.3594 | 45.375 | 44600.0 |
| 2000-05-26 15:00:00 | IWM | ETF | 45.7188 | 45.7188 | 45.7188 | 45.7188 | 6000.0 |
| 2000-05-26 09:00:00 | DIA | ETF | 103.4688 | 103.9688 | 102.9375 | 103.0625 | 272500.0 |
| 2000-05-26 10:00:00 | DIA | ETF | 103.125 | 103.8125 | 102.5312 | 103.25 | 194700.0 |
| 2000-05-26 11:00:00 | DIA | ETF | 103.125 | 103.875 | 103.0312 | 103.6875 | 93500.0 |
| 2000-05-26 12:00:00 | DIA | ETF | 103.5 | 103.7812 | 103.1875 | 103.375 | 23300.0 |
| 2000-05-26 13:00:00 | DIA | ETF | 103.4375 | 103.5312 | 103.0938 | 103.2188 | 122600.0 |
| 2000-05-26 14:00:00 | DIA | ETF | 103.2188 | 103.2188 | 102.75 | 103.125 | 113300.0 |
| 2000-05-26 15:00:00 | DIA | ETF | 102.9062 | 103.375 | 102.5625 | 103.25 | 97200.0 |
| 2000-05-26 16:00:00 | DIA | ETF | 103.1875 | 103.3438 | 103.125 | 103.125 | 1500.0 |
> showing 32 of 137 rows — these rows as CSV