PREVIEW / etf_1hour / 2001-01-17
file: by_date/etf_1hour/2001/2001-01-17.parquet size: 10 KB rows: 202
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-17 09:00:00 | SPY | ETF | 134.8438 | 134.8438 | 134.0312 | 134.25 | 2065200.0 |
| 2001-01-17 10:00:00 | SPY | ETF | 134.2812 | 135.0312 | 134.0625 | 134.8125 | 1094200.0 |
| 2001-01-17 11:00:00 | SPY | ETF | 134.6875 | 135.0312 | 134.375 | 134.5938 | 428600.0 |
| 2001-01-17 12:00:00 | SPY | ETF | 134.5 | 134.9688 | 134.375 | 134.5 | 199100.0 |
| 2001-01-17 13:00:00 | SPY | ETF | 134.5 | 134.5625 | 133.875 | 134.3438 | 400800.0 |
| 2001-01-17 14:00:00 | SPY | ETF | 134.375 | 134.375 | 133.0625 | 133.0938 | 1130700.0 |
| 2001-01-17 15:00:00 | SPY | ETF | 133.0938 | 133.4688 | 132.625 | 132.9375 | 1895700.0 |
| 2001-01-17 16:00:00 | SPY | ETF | 133.0625 | 133.875 | 132.9062 | 133.625 | 361200.0 |
| 2001-01-17 17:00:00 | SPY | ETF | 134.0 | 134.0 | 134.0 | 134.0 | 100.0 |
| 2001-01-17 09:00:00 | QQQ | ETF | 64.5 | 65.0 | 64.3125 | 64.875 | 13470400.0 |
| 2001-01-17 10:00:00 | QQQ | ETF | 64.75 | 65.5938 | 64.6875 | 65.3125 | 11155700.0 |
| 2001-01-17 11:00:00 | QQQ | ETF | 65.25 | 65.5625 | 64.875 | 65.25 | 5676000.0 |
| 2001-01-17 12:00:00 | QQQ | ETF | 65.3125 | 65.5625 | 65.0 | 65.1875 | 3496100.0 |
| 2001-01-17 13:00:00 | QQQ | ETF | 65.0625 | 65.1875 | 64.5 | 65.0 | 5047600.0 |
| 2001-01-17 14:00:00 | QQQ | ETF | 65.0312 | 65.0938 | 63.75 | 64.0 | 7047100.0 |
| 2001-01-17 15:00:00 | QQQ | ETF | 64.0 | 64.1875 | 63.125 | 63.6875 | 9956000.0 |
| 2001-01-17 16:00:00 | QQQ | ETF | 63.5938 | 64.875 | 63.3125 | 64.75 | 1427500.0 |
| 2001-01-17 17:00:00 | QQQ | ETF | 64.7812 | 65.0 | 63.9375 | 64.0 | 559500.0 |
| 2001-01-17 18:00:00 | QQQ | ETF | 64.0 | 64.25 | 63.9375 | 64.25 | 26000.0 |
| 2001-01-17 09:00:00 | IWM | ETF | 50.0938 | 50.0938 | 49.7188 | 49.7188 | 50600.0 |
| 2001-01-17 10:00:00 | IWM | ETF | 49.7656 | 50.0 | 49.75 | 50.0 | 169400.0 |
| 2001-01-17 11:00:00 | IWM | ETF | 50.1875 | 50.1875 | 49.75 | 49.8125 | 102200.0 |
| 2001-01-17 12:00:00 | IWM | ETF | 49.9375 | 49.9375 | 49.7812 | 49.8125 | 18600.0 |
| 2001-01-17 13:00:00 | IWM | ETF | 49.8125 | 49.8125 | 49.5 | 49.75 | 216800.0 |
| 2001-01-17 14:00:00 | IWM | ETF | 49.7344 | 49.75 | 49.25 | 49.4375 | 102200.0 |
| 2001-01-17 15:00:00 | IWM | ETF | 49.3438 | 49.375 | 48.9688 | 49.3125 | 360600.0 |
| 2001-01-17 16:00:00 | IWM | ETF | 49.2344 | 49.3125 | 49.2344 | 49.3125 | 53000.0 |
| 2001-01-17 09:00:00 | DIA | ETF | 107.2188 | 107.375 | 106.0 | 106.2812 | 398200.0 |
| 2001-01-17 10:00:00 | DIA | ETF | 106.3125 | 107.0 | 106.125 | 106.875 | 430600.0 |
| 2001-01-17 11:00:00 | DIA | ETF | 106.9375 | 107.125 | 106.6562 | 106.75 | 192400.0 |
| 2001-01-17 12:00:00 | DIA | ETF | 106.75 | 106.9375 | 106.5 | 106.5 | 187700.0 |
| 2001-01-17 13:00:00 | DIA | ETF | 106.7188 | 106.7188 | 106.0 | 106.4688 | 202900.0 |
| 2001-01-17 14:00:00 | DIA | ETF | 106.4375 | 106.5938 | 105.6562 | 105.75 | 374600.0 |
| 2001-01-17 15:00:00 | DIA | ETF | 105.75 | 105.9688 | 105.4375 | 105.7812 | 118600.0 |
| 2001-01-17 16:00:00 | DIA | ETF | 105.8125 | 106.125 | 105.6562 | 105.9688 | 113400.0 |
| 2001-01-17 17:00:00 | DIA | ETF | 106.875 | 107.0 | 106.875 | 107.0 | 900.0 |
> showing 36 of 202 rows — these rows as CSV