PREVIEW / etf_1hour / 2000-10-11
file: by_date/etf_1hour/2000/2000-10-11.parquet size: 10 KB rows: 187
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-10-11 09:00:00 | SPY | ETF | 137.625 | 138.3125 | 137.0 | 138.3125 | 1027200.0 |
| 2000-10-11 10:00:00 | SPY | ETF | 138.2188 | 138.25 | 136.0312 | 136.125 | 1781100.0 |
| 2000-10-11 11:00:00 | SPY | ETF | 136.0938 | 136.9062 | 135.125 | 136.625 | 1610900.0 |
| 2000-10-11 12:00:00 | SPY | ETF | 136.4375 | 138.5625 | 136.3125 | 137.7812 | 1468600.0 |
| 2000-10-11 13:00:00 | SPY | ETF | 137.8438 | 138.1875 | 137.2812 | 138.0625 | 704900.0 |
| 2000-10-11 14:00:00 | SPY | ETF | 138.1875 | 138.3125 | 136.9062 | 137.4375 | 1289800.0 |
| 2000-10-11 15:00:00 | SPY | ETF | 137.4062 | 137.625 | 135.9375 | 136.5625 | 2010100.0 |
| 2000-10-11 16:00:00 | SPY | ETF | 136.5 | 136.7812 | 136.4062 | 136.5312 | 229200.0 |
| 2000-10-11 09:00:00 | QQQ | ETF | 76.875 | 79.0 | 76.8125 | 78.6875 | 5738500.0 |
| 2000-10-11 10:00:00 | QQQ | ETF | 78.8125 | 79.0 | 76.625 | 76.75 | 7202800.0 |
| 2000-10-11 11:00:00 | QQQ | ETF | 76.7812 | 78.25 | 76.0625 | 77.9062 | 7747400.0 |
| 2000-10-11 12:00:00 | QQQ | ETF | 77.9062 | 80.4375 | 77.75 | 79.1875 | 8200400.0 |
| 2000-10-11 13:00:00 | QQQ | ETF | 79.1875 | 80.0 | 78.7812 | 79.9375 | 4248100.0 |
| 2000-10-11 14:00:00 | QQQ | ETF | 79.9375 | 80.125 | 78.4688 | 79.25 | 5113600.0 |
| 2000-10-11 15:00:00 | QQQ | ETF | 79.25 | 79.4688 | 77.0 | 77.4688 | 9071600.0 |
| 2000-10-11 16:00:00 | QQQ | ETF | 77.4688 | 79.5938 | 76.25 | 77.375 | 855300.0 |
| 2000-10-11 17:00:00 | QQQ | ETF | 77.375 | 78.0 | 77.25 | 77.5 | 12800.0 |
| 2000-10-11 18:00:00 | QQQ | ETF | 77.9688 | 78.0625 | 77.5 | 77.75 | 2700.0 |
| 2000-10-11 09:00:00 | IWM | ETF | 47.7188 | 47.7188 | 47.5625 | 47.5781 | 5000.0 |
| 2000-10-11 10:00:00 | IWM | ETF | 47.5625 | 47.6875 | 47.1562 | 47.1562 | 22000.0 |
| 2000-10-11 11:00:00 | IWM | ETF | 47.1875 | 47.1875 | 47.0 | 47.1562 | 45600.0 |
| 2000-10-11 12:00:00 | IWM | ETF | 47.0625 | 47.6875 | 47.0625 | 47.4688 | 28800.0 |
| 2000-10-11 13:00:00 | IWM | ETF | 47.4375 | 47.6562 | 47.4375 | 47.6562 | 16200.0 |
| 2000-10-11 14:00:00 | IWM | ETF | 47.8125 | 47.8125 | 47.5625 | 47.5938 | 31200.0 |
| 2000-10-11 15:00:00 | IWM | ETF | 47.2812 | 47.5625 | 47.2812 | 47.4062 | 19400.0 |
| 2000-10-11 09:00:00 | DIA | ETF | 104.7812 | 105.8125 | 104.7188 | 105.8125 | 127900.0 |
| 2000-10-11 10:00:00 | DIA | ETF | 105.625 | 105.6562 | 104.25 | 104.25 | 294600.0 |
| 2000-10-11 11:00:00 | DIA | ETF | 104.3125 | 104.6562 | 103.5625 | 104.3125 | 239000.0 |
| 2000-10-11 12:00:00 | DIA | ETF | 104.3438 | 105.4062 | 104.0938 | 105.0 | 202600.0 |
| 2000-10-11 13:00:00 | DIA | ETF | 104.9375 | 105.0938 | 104.625 | 104.9375 | 22100.0 |
| 2000-10-11 14:00:00 | DIA | ETF | 105.0 | 105.2188 | 104.25 | 104.5 | 165600.0 |
| 2000-10-11 15:00:00 | DIA | ETF | 104.5 | 104.8438 | 103.6875 | 104.25 | 160400.0 |
| 2000-10-11 16:00:00 | DIA | ETF | 104.125 | 104.4062 | 104.0312 | 104.4062 | 29000.0 |
> showing 33 of 187 rows — these rows as CSV