PREVIEW / etf_1hour / 2000-12-05
file: by_date/etf_1hour/2000/2000-12-05.parquet size: 10 KB rows: 201
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-12-05 09:00:00 | SPY | ETF | 134.875 | 134.9062 | 134.4062 | 134.7188 | 1515000.0 |
| 2000-12-05 10:00:00 | SPY | ETF | 134.6562 | 136.625 | 134.4688 | 136.375 | 1811600.0 |
| 2000-12-05 11:00:00 | SPY | ETF | 136.4688 | 137.375 | 136.1875 | 137.2812 | 1226800.0 |
| 2000-12-05 12:00:00 | SPY | ETF | 137.125 | 137.6875 | 136.3438 | 136.75 | 839400.0 |
| 2000-12-05 13:00:00 | SPY | ETF | 136.75 | 137.1875 | 136.625 | 136.8125 | 343900.0 |
| 2000-12-05 14:00:00 | SPY | ETF | 136.8125 | 137.4062 | 136.8125 | 137.0625 | 760700.0 |
| 2000-12-05 15:00:00 | SPY | ETF | 137.2188 | 138.1875 | 137.0 | 138.125 | 1305100.0 |
| 2000-12-05 16:00:00 | SPY | ETF | 138.1875 | 138.25 | 137.3125 | 137.3125 | 716800.0 |
| 2000-12-05 09:00:00 | QQQ | ETF | 66.0625 | 66.625 | 65.5 | 65.8125 | 10141300.0 |
| 2000-12-05 10:00:00 | QQQ | ETF | 65.8125 | 68.8125 | 65.7812 | 68.125 | 17039000.0 |
| 2000-12-05 11:00:00 | QQQ | ETF | 68.125 | 69.5625 | 67.875 | 69.375 | 11844400.0 |
| 2000-12-05 12:00:00 | QQQ | ETF | 69.4688 | 69.75 | 68.0312 | 68.7188 | 9886000.0 |
| 2000-12-05 13:00:00 | QQQ | ETF | 68.7188 | 69.3125 | 68.375 | 68.875 | 4786200.0 |
| 2000-12-05 14:00:00 | QQQ | ETF | 69.0 | 69.75 | 68.875 | 69.5312 | 6329000.0 |
| 2000-12-05 15:00:00 | QQQ | ETF | 69.5625 | 71.0 | 69.4375 | 71.0 | 11649000.0 |
| 2000-12-05 16:00:00 | QQQ | ETF | 70.9688 | 71.0 | 70.0 | 70.5 | 1992800.0 |
| 2000-12-05 17:00:00 | QQQ | ETF | 70.5 | 71.0 | 70.25 | 70.9375 | 63000.0 |
| 2000-12-05 18:00:00 | QQQ | ETF | 70.8438 | 71.0 | 70.75 | 71.0 | 26400.0 |
| 2000-12-05 09:00:00 | IWM | ETF | 45.75 | 45.9062 | 45.75 | 45.9062 | 21600.0 |
| 2000-12-05 10:00:00 | IWM | ETF | 45.75 | 46.6094 | 45.75 | 46.5 | 102600.0 |
| 2000-12-05 11:00:00 | IWM | ETF | 46.625 | 46.9375 | 46.625 | 46.8906 | 64800.0 |
| 2000-12-05 12:00:00 | IWM | ETF | 46.8906 | 46.8906 | 46.5156 | 46.6562 | 29600.0 |
| 2000-12-05 13:00:00 | IWM | ETF | 46.7188 | 46.7188 | 46.5156 | 46.6562 | 21200.0 |
| 2000-12-05 14:00:00 | IWM | ETF | 46.6875 | 46.8125 | 46.6562 | 46.6875 | 13800.0 |
| 2000-12-05 15:00:00 | IWM | ETF | 46.7188 | 47.1875 | 46.7188 | 47.1875 | 124400.0 |
| 2000-12-05 16:00:00 | IWM | ETF | 47.1562 | 47.25 | 47.0625 | 47.25 | 12800.0 |
| 2000-12-05 09:00:00 | DIA | ETF | 107.0 | 107.1875 | 106.625 | 106.9688 | 510700.0 |
| 2000-12-05 10:00:00 | DIA | ETF | 106.875 | 108.6875 | 106.875 | 108.1875 | 676000.0 |
| 2000-12-05 11:00:00 | DIA | ETF | 108.3125 | 109.0938 | 108.0625 | 108.75 | 247200.0 |
| 2000-12-05 12:00:00 | DIA | ETF | 108.8125 | 108.9688 | 108.125 | 108.5 | 174400.0 |
| 2000-12-05 13:00:00 | DIA | ETF | 108.5 | 108.625 | 108.2188 | 108.3125 | 47100.0 |
| 2000-12-05 14:00:00 | DIA | ETF | 108.4688 | 108.9062 | 108.4375 | 108.4375 | 99400.0 |
| 2000-12-05 15:00:00 | DIA | ETF | 108.4375 | 109.3438 | 108.4375 | 108.9688 | 212600.0 |
| 2000-12-05 16:00:00 | DIA | ETF | 109.0312 | 109.125 | 108.75 | 108.9375 | 10300.0 |
> showing 34 of 201 rows — these rows as CSV