PREVIEW / etf_1hour / 2000-12-13
file: by_date/etf_1hour/2000/2000-12-13.parquet size: 10 KB rows: 191
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-13 09:00:00 | SPY | ETF | 139.25 | 139.4062 | 138.1875 | 138.1875 | 1128200.0 |
| 2000-12-13 10:00:00 | SPY | ETF | 138.1562 | 139.125 | 137.1562 | 137.25 | 1486600.0 |
| 2000-12-13 11:00:00 | SPY | ETF | 137.3438 | 138.1875 | 137.0 | 138.1562 | 601700.0 |
| 2000-12-13 12:00:00 | SPY | ETF | 138.1562 | 138.1562 | 137.0625 | 137.1562 | 652000.0 |
| 2000-12-13 13:00:00 | SPY | ETF | 137.1562 | 137.8438 | 137.0625 | 137.6875 | 356100.0 |
| 2000-12-13 14:00:00 | SPY | ETF | 137.6875 | 137.7812 | 137.0312 | 137.4375 | 315800.0 |
| 2000-12-13 15:00:00 | SPY | ETF | 137.4062 | 137.5312 | 136.2812 | 136.5312 | 798700.0 |
| 2000-12-13 16:00:00 | SPY | ETF | 136.6562 | 136.7188 | 136.0312 | 136.125 | 528800.0 |
| 2000-12-13 17:00:00 | SPY | ETF | 136.125 | 136.125 | 136.125 | 136.125 | 7500.0 |
| 2000-12-13 09:00:00 | QQQ | ETF | 73.4375 | 73.5 | 71.125 | 71.1562 | 9119500.0 |
| 2000-12-13 10:00:00 | QQQ | ETF | 71.125 | 72.5625 | 70.0625 | 70.25 | 14640300.0 |
| 2000-12-13 11:00:00 | QQQ | ETF | 70.25 | 70.9688 | 69.6875 | 70.9375 | 7486200.0 |
| 2000-12-13 12:00:00 | QQQ | ETF | 70.9375 | 70.9375 | 69.5312 | 69.625 | 2879400.0 |
| 2000-12-13 13:00:00 | QQQ | ETF | 69.625 | 70.5 | 69.5625 | 70.5 | 3052900.0 |
| 2000-12-13 14:00:00 | QQQ | ETF | 70.5 | 70.5625 | 69.625 | 70.0 | 3200000.0 |
| 2000-12-13 15:00:00 | QQQ | ETF | 69.9375 | 70.25 | 68.3125 | 68.5 | 7945900.0 |
| 2000-12-13 16:00:00 | QQQ | ETF | 68.5312 | 68.875 | 68.375 | 68.75 | 806000.0 |
| 2000-12-13 17:00:00 | QQQ | ETF | 68.75 | 69.2188 | 68.6875 | 69.0 | 19600.0 |
| 2000-12-13 18:00:00 | QQQ | ETF | 68.8125 | 68.9375 | 68.75 | 68.75 | 3800.0 |
| 2000-12-13 09:00:00 | IWM | ETF | 47.8906 | 47.8906 | 47.7188 | 47.8125 | 28000.0 |
| 2000-12-13 10:00:00 | IWM | ETF | 47.5 | 47.6562 | 47.1562 | 47.1562 | 110400.0 |
| 2000-12-13 11:00:00 | IWM | ETF | 47.0625 | 47.2812 | 46.9375 | 47.25 | 96600.0 |
| 2000-12-13 12:00:00 | IWM | ETF | 47.0938 | 47.2812 | 47.0 | 47.0 | 110400.0 |
| 2000-12-13 13:00:00 | IWM | ETF | 47.125 | 47.1562 | 46.9375 | 47.1562 | 27200.0 |
| 2000-12-13 14:00:00 | IWM | ETF | 47.0938 | 47.0938 | 46.8438 | 46.9375 | 41000.0 |
| 2000-12-13 15:00:00 | IWM | ETF | 46.8125 | 46.9375 | 46.5938 | 46.625 | 106200.0 |
| 2000-12-13 16:00:00 | IWM | ETF | 46.6094 | 46.6094 | 46.6094 | 46.6094 | 200.0 |
| 2000-12-13 09:00:00 | DIA | ETF | 108.9062 | 109.4375 | 108.5625 | 108.75 | 163200.0 |
| 2000-12-13 10:00:00 | DIA | ETF | 108.625 | 109.375 | 108.0312 | 108.3125 | 227000.0 |
| 2000-12-13 11:00:00 | DIA | ETF | 108.375 | 108.8125 | 108.0625 | 108.8125 | 62200.0 |
| 2000-12-13 12:00:00 | DIA | ETF | 108.8438 | 108.8438 | 108.25 | 108.3125 | 61400.0 |
| 2000-12-13 13:00:00 | DIA | ETF | 108.25 | 108.6562 | 108.25 | 108.5 | 43000.0 |
| 2000-12-13 14:00:00 | DIA | ETF | 108.4688 | 108.5938 | 108.0938 | 108.4375 | 24200.0 |
| 2000-12-13 15:00:00 | DIA | ETF | 108.5 | 108.5938 | 107.8125 | 108.0 | 194800.0 |
| 2000-12-13 16:00:00 | DIA | ETF | 108.0 | 108.125 | 108.0 | 108.0625 | 5300.0 |
> showing 35 of 191 rows — these rows as CSV