PREVIEW / etf_1hour / 2000-06-26
file: by_date/etf_1hour/2000/2000-06-26.parquet size: 9 KB rows: 152
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-06-26 09:00:00 | SPY | ETF | 145.375 | 145.6875 | 144.875 | 145.6875 | 1809400.0 |
| 2000-06-26 10:00:00 | SPY | ETF | 145.5938 | 146.125 | 145.25 | 145.9062 | 531600.0 |
| 2000-06-26 11:00:00 | SPY | ETF | 145.875 | 146.25 | 145.625 | 145.7812 | 172200.0 |
| 2000-06-26 12:00:00 | SPY | ETF | 145.6875 | 145.7812 | 145.3125 | 145.3438 | 470300.0 |
| 2000-06-26 13:00:00 | SPY | ETF | 145.375 | 145.75 | 145.0625 | 145.375 | 160600.0 |
| 2000-06-26 14:00:00 | SPY | ETF | 145.25 | 145.5625 | 144.9062 | 145.4062 | 374600.0 |
| 2000-06-26 15:00:00 | SPY | ETF | 145.5 | 145.8125 | 145.0312 | 145.75 | 1151500.0 |
| 2000-06-26 16:00:00 | SPY | ETF | 145.625 | 146.2188 | 145.4375 | 146.2188 | 416900.0 |
| 2000-06-26 17:00:00 | SPY | ETF | 146.2188 | 146.2188 | 146.2188 | 146.2188 | 39700.0 |
| 2000-06-26 09:00:00 | QQQ | ETF | 93.0625 | 93.4375 | 92.0 | 93.1875 | 5936900.0 |
| 2000-06-26 10:00:00 | QQQ | ETF | 93.0 | 93.9375 | 92.25 | 93.5 | 4052400.0 |
| 2000-06-26 11:00:00 | QQQ | ETF | 93.5625 | 94.4062 | 93.375 | 93.5312 | 2883200.0 |
| 2000-06-26 12:00:00 | QQQ | ETF | 93.5 | 93.5938 | 92.5 | 92.8125 | 1584200.0 |
| 2000-06-26 13:00:00 | QQQ | ETF | 92.9688 | 93.4062 | 92.4688 | 92.6875 | 1173200.0 |
| 2000-06-26 14:00:00 | QQQ | ETF | 92.6875 | 93.5 | 92.25 | 93.25 | 2625200.0 |
| 2000-06-26 15:00:00 | QQQ | ETF | 93.25 | 94.0625 | 92.875 | 93.9375 | 3061500.0 |
| 2000-06-26 16:00:00 | QQQ | ETF | 93.9375 | 94.375 | 93.0 | 94.375 | 826200.0 |
| 2000-06-26 17:00:00 | QQQ | ETF | 94.0 | 94.0 | 94.0 | 94.0 | 100.0 |
| 2000-06-26 18:00:00 | QQQ | ETF | 94.0 | 94.0 | 94.0 | 94.0 | 500.0 |
| 2000-06-26 09:00:00 | IWM | ETF | 51.1094 | 51.2188 | 51.1094 | 51.2031 | 13200.0 |
| 2000-06-26 10:00:00 | IWM | ETF | 51.25 | 51.2969 | 51.1406 | 51.25 | 14800.0 |
| 2000-06-26 11:00:00 | IWM | ETF | 51.125 | 51.125 | 51.0625 | 51.0625 | 6000.0 |
| 2000-06-26 12:00:00 | IWM | ETF | 50.9375 | 50.9375 | 50.9375 | 50.9375 | 3200.0 |
| 2000-06-26 13:00:00 | IWM | ETF | 50.9844 | 51.0781 | 50.9844 | 51.0781 | 2000.0 |
| 2000-06-26 14:00:00 | IWM | ETF | 50.875 | 50.875 | 50.875 | 50.875 | 8000.0 |
| 2000-06-26 15:00:00 | IWM | ETF | 51.0469 | 51.3125 | 51.0469 | 51.3125 | 31400.0 |
| 2000-06-26 16:00:00 | IWM | ETF | 51.5312 | 51.5312 | 51.5312 | 51.5312 | 15000.0 |
| 2000-06-26 09:00:00 | DIA | ETF | 104.9375 | 105.5938 | 104.7188 | 105.5 | 82700.0 |
| 2000-06-26 10:00:00 | DIA | ETF | 105.5938 | 105.8438 | 105.3125 | 105.5 | 375200.0 |
| 2000-06-26 11:00:00 | DIA | ETF | 105.5938 | 105.8125 | 105.375 | 105.4688 | 117000.0 |
| 2000-06-26 12:00:00 | DIA | ETF | 105.4375 | 105.5938 | 105.1875 | 105.4688 | 70700.0 |
| 2000-06-26 13:00:00 | DIA | ETF | 105.4688 | 105.5938 | 105.125 | 105.5 | 132700.0 |
| 2000-06-26 14:00:00 | DIA | ETF | 105.5625 | 105.5625 | 105.25 | 105.5625 | 36600.0 |
| 2000-06-26 15:00:00 | DIA | ETF | 105.5938 | 105.75 | 105.25 | 105.6875 | 174300.0 |
| 2000-06-26 16:00:00 | DIA | ETF | 105.6875 | 105.9688 | 105.4375 | 105.9688 | 25600.0 |
> showing 35 of 152 rows — these rows as CSV