PREVIEW / etf_1hour / 2001-01-23
file: by_date/etf_1hour/2001/2001-01-23.parquet size: 10 KB rows: 206
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 |
|---|---|---|---|---|---|---|---|
| 2001-01-23 09:00:00 | SPY | ETF | 134.4688 | 135.125 | 134.3438 | 134.5 | 684400.0 |
| 2001-01-23 10:00:00 | SPY | ETF | 134.5625 | 135.1562 | 134.1562 | 135.0312 | 1016500.0 |
| 2001-01-23 11:00:00 | SPY | ETF | 135.125 | 135.3438 | 134.75 | 134.9688 | 1286400.0 |
| 2001-01-23 12:00:00 | SPY | ETF | 134.9062 | 135.5312 | 134.9062 | 135.2812 | 990800.0 |
| 2001-01-23 13:00:00 | SPY | ETF | 135.25 | 135.7812 | 135.1875 | 135.5938 | 694100.0 |
| 2001-01-23 14:00:00 | SPY | ETF | 135.5938 | 136.375 | 135.5 | 136.25 | 1356600.0 |
| 2001-01-23 15:00:00 | SPY | ETF | 136.125 | 136.6562 | 135.875 | 136.125 | 1592500.0 |
| 2001-01-23 16:00:00 | SPY | ETF | 136.125 | 136.125 | 135.5 | 136.125 | 294000.0 |
| 2001-01-23 09:00:00 | QQQ | ETF | 65.9062 | 66.5 | 65.375 | 65.6875 | 6205400.0 |
| 2001-01-23 10:00:00 | QQQ | ETF | 65.625 | 66.625 | 65.3125 | 66.5312 | 7421800.0 |
| 2001-01-23 11:00:00 | QQQ | ETF | 66.5312 | 66.7188 | 66.0312 | 66.1562 | 4861100.0 |
| 2001-01-23 12:00:00 | QQQ | ETF | 66.1562 | 66.875 | 66.125 | 66.7188 | 3458400.0 |
| 2001-01-23 13:00:00 | QQQ | ETF | 66.6875 | 67.3438 | 66.5 | 67.1875 | 5059600.0 |
| 2001-01-23 14:00:00 | QQQ | ETF | 67.2188 | 67.9375 | 67.125 | 67.8125 | 7945400.0 |
| 2001-01-23 15:00:00 | QQQ | ETF | 67.8125 | 68.4062 | 67.625 | 67.875 | 10774600.0 |
| 2001-01-23 16:00:00 | QQQ | ETF | 67.8125 | 68.5 | 67.625 | 68.375 | 1641300.0 |
| 2001-01-23 17:00:00 | QQQ | ETF | 68.25 | 68.875 | 68.0625 | 68.625 | 163900.0 |
| 2001-01-23 18:00:00 | QQQ | ETF | 68.6875 | 68.875 | 68.5 | 68.8125 | 35200.0 |
| 2001-01-23 09:00:00 | IWM | ETF | 49.0 | 49.1094 | 48.875 | 48.875 | 12000.0 |
| 2001-01-23 10:00:00 | IWM | ETF | 48.9688 | 49.5625 | 48.9688 | 49.5 | 195600.0 |
| 2001-01-23 11:00:00 | IWM | ETF | 49.5 | 49.5 | 49.25 | 49.2812 | 120200.0 |
| 2001-01-23 12:00:00 | IWM | ETF | 49.375 | 49.5 | 49.375 | 49.4062 | 58800.0 |
| 2001-01-23 13:00:00 | IWM | ETF | 49.4844 | 49.6875 | 49.4062 | 49.5 | 154800.0 |
| 2001-01-23 14:00:00 | IWM | ETF | 49.6875 | 49.6875 | 49.5 | 49.6875 | 117400.0 |
| 2001-01-23 15:00:00 | IWM | ETF | 49.8125 | 50.125 | 49.7188 | 50.0312 | 173800.0 |
| 2001-01-23 16:00:00 | IWM | ETF | 50.0625 | 50.1875 | 49.4844 | 49.4844 | 2244200.0 |
| 2001-01-23 09:00:00 | DIA | ETF | 105.625 | 106.125 | 105.625 | 105.75 | 48300.0 |
| 2001-01-23 10:00:00 | DIA | ETF | 105.8125 | 106.4688 | 105.5312 | 106.25 | 120300.0 |
| 2001-01-23 11:00:00 | DIA | ETF | 106.3125 | 106.4062 | 106.0625 | 106.0625 | 69900.0 |
| 2001-01-23 12:00:00 | DIA | ETF | 106.25 | 106.7188 | 106.25 | 106.3438 | 100800.0 |
| 2001-01-23 13:00:00 | DIA | ETF | 106.4375 | 106.6562 | 106.2812 | 106.5 | 206200.0 |
| 2001-01-23 14:00:00 | DIA | ETF | 106.375 | 106.7812 | 106.375 | 106.7812 | 152900.0 |
| 2001-01-23 15:00:00 | DIA | ETF | 106.7812 | 106.9062 | 106.25 | 106.5 | 591100.0 |
| 2001-01-23 16:00:00 | DIA | ETF | 106.375 | 106.5 | 106.375 | 106.5 | 36000.0 |
> showing 34 of 206 rows — these rows as CSV