PREVIEW / etf_1hour / 2000-12-29
file: by_date/etf_1hour/2000/2000-12-29.parquet size: 10 KB rows: 213
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-29 09:00:00 | SPY | ETF | 134.0625 | 134.2812 | 133.7188 | 133.8125 | 571500.0 |
| 2000-12-29 10:00:00 | SPY | ETF | 133.75 | 133.875 | 133.25 | 133.5 | 997800.0 |
| 2000-12-29 11:00:00 | SPY | ETF | 133.4062 | 133.5312 | 132.875 | 133.3438 | 737900.0 |
| 2000-12-29 12:00:00 | SPY | ETF | 133.3438 | 133.5938 | 133.1875 | 133.375 | 501000.0 |
| 2000-12-29 13:00:00 | SPY | ETF | 133.375 | 133.5 | 132.625 | 133.1875 | 999000.0 |
| 2000-12-29 14:00:00 | SPY | ETF | 133.2188 | 133.4375 | 132.8125 | 133.3125 | 794700.0 |
| 2000-12-29 15:00:00 | SPY | ETF | 133.375 | 133.4062 | 131.875 | 132.25 | 2769000.0 |
| 2000-12-29 16:00:00 | SPY | ETF | 132.25 | 134.2812 | 131.1875 | 131.5 | 1362400.0 |
| 2000-12-29 17:00:00 | SPY | ETF | 131.5 | 131.5 | 131.5 | 131.5 | 3000.0 |
| 2000-12-29 09:00:00 | QQQ | ETF | 61.5625 | 62.2188 | 61.25 | 61.2812 | 4490400.0 |
| 2000-12-29 10:00:00 | QQQ | ETF | 61.25 | 61.4375 | 59.9375 | 60.375 | 8197800.0 |
| 2000-12-29 11:00:00 | QQQ | ETF | 60.375 | 60.5 | 59.4688 | 60.2812 | 6049600.0 |
| 2000-12-29 12:00:00 | QQQ | ETF | 60.25 | 60.3125 | 59.8125 | 60.125 | 2468400.0 |
| 2000-12-29 13:00:00 | QQQ | ETF | 60.125 | 60.125 | 59.0625 | 59.8438 | 5641000.0 |
| 2000-12-29 14:00:00 | QQQ | ETF | 59.8125 | 59.9688 | 59.125 | 59.4688 | 4416300.0 |
| 2000-12-29 15:00:00 | QQQ | ETF | 59.4375 | 59.5625 | 58.0 | 58.4375 | 15000600.0 |
| 2000-12-29 16:00:00 | QQQ | ETF | 58.4375 | 58.75 | 58.25 | 58.625 | 2567700.0 |
| 2000-12-29 17:00:00 | QQQ | ETF | 58.625 | 58.9375 | 58.5 | 58.625 | 14900.0 |
| 2000-12-29 18:00:00 | QQQ | ETF | 58.625 | 58.625 | 58.5 | 58.5 | 8700.0 |
| 2000-12-29 09:00:00 | IWM | ETF | 49.4688 | 49.6094 | 49.4219 | 49.5312 | 234400.0 |
| 2000-12-29 10:00:00 | IWM | ETF | 49.5312 | 49.5625 | 49.0312 | 49.2031 | 125000.0 |
| 2000-12-29 11:00:00 | IWM | ETF | 49.1875 | 49.2344 | 48.8125 | 48.9375 | 158600.0 |
| 2000-12-29 12:00:00 | IWM | ETF | 49.0 | 49.1406 | 48.9062 | 49.0625 | 122800.0 |
| 2000-12-29 13:00:00 | IWM | ETF | 49.0 | 49.0 | 48.7812 | 48.9844 | 187000.0 |
| 2000-12-29 14:00:00 | IWM | ETF | 49.0 | 49.0312 | 48.875 | 49.0312 | 52200.0 |
| 2000-12-29 15:00:00 | IWM | ETF | 48.875 | 49.0 | 47.8125 | 48.0156 | 855800.0 |
| 2000-12-29 16:00:00 | IWM | ETF | 48.0625 | 48.0625 | 47.875 | 47.875 | 68000.0 |
| 2000-12-29 09:00:00 | DIA | ETF | 109.1562 | 109.1562 | 108.5 | 108.5 | 277100.0 |
| 2000-12-29 10:00:00 | DIA | ETF | 108.75 | 108.9688 | 108.4375 | 108.7812 | 126600.0 |
| 2000-12-29 11:00:00 | DIA | ETF | 108.5625 | 108.75 | 108.375 | 108.75 | 83700.0 |
| 2000-12-29 12:00:00 | DIA | ETF | 108.75 | 108.9375 | 108.5 | 108.6875 | 185800.0 |
| 2000-12-29 13:00:00 | DIA | ETF | 108.625 | 108.9375 | 108.3438 | 108.875 | 160700.0 |
| 2000-12-29 14:00:00 | DIA | ETF | 108.9688 | 108.9688 | 108.5 | 108.6875 | 122600.0 |
| 2000-12-29 15:00:00 | DIA | ETF | 108.8125 | 108.8125 | 107.4062 | 107.6562 | 496500.0 |
| 2000-12-29 16:00:00 | DIA | ETF | 107.5 | 107.625 | 106.7812 | 106.7812 | 99800.0 |
> showing 35 of 213 rows — these rows as CSV