PREVIEW / etf_1hour / 2001-01-10
file: by_date/etf_1hour/2001/2001-01-10.parquet size: 10 KB rows: 204
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-10 09:00:00 | SPY | ETF | 129.0 | 129.4688 | 128.8125 | 129.4688 | 650500.0 |
| 2001-01-10 10:00:00 | SPY | ETF | 129.4688 | 130.7188 | 129.0938 | 130.0312 | 1249300.0 |
| 2001-01-10 11:00:00 | SPY | ETF | 130.125 | 131.4688 | 130.0 | 131.4688 | 1066500.0 |
| 2001-01-10 12:00:00 | SPY | ETF | 131.4688 | 131.5938 | 130.2188 | 130.5 | 1572500.0 |
| 2001-01-10 13:00:00 | SPY | ETF | 130.5 | 130.7188 | 129.5 | 130.25 | 1653300.0 |
| 2001-01-10 14:00:00 | SPY | ETF | 130.25 | 130.8125 | 130.0312 | 130.5 | 408900.0 |
| 2001-01-10 15:00:00 | SPY | ETF | 130.4688 | 131.8125 | 130.4688 | 131.6562 | 1164900.0 |
| 2001-01-10 16:00:00 | SPY | ETF | 131.625 | 132.125 | 131.5938 | 131.7812 | 320000.0 |
| 2001-01-10 17:00:00 | SPY | ETF | 131.5 | 131.7812 | 131.375 | 131.375 | 2200.0 |
| 2001-01-10 09:00:00 | QQQ | ETF | 56.125 | 56.875 | 55.75 | 56.7188 | 5691800.0 |
| 2001-01-10 10:00:00 | QQQ | ETF | 56.7812 | 58.9375 | 56.5 | 58.3125 | 9456800.0 |
| 2001-01-10 11:00:00 | QQQ | ETF | 58.3125 | 59.8125 | 58.1875 | 59.75 | 9748600.0 |
| 2001-01-10 12:00:00 | QQQ | ETF | 59.6875 | 60.0 | 57.4375 | 57.75 | 13237200.0 |
| 2001-01-10 13:00:00 | QQQ | ETF | 57.75 | 58.625 | 56.75 | 58.0938 | 8766800.0 |
| 2001-01-10 14:00:00 | QQQ | ETF | 58.25 | 59.2188 | 57.875 | 58.5 | 6795300.0 |
| 2001-01-10 15:00:00 | QQQ | ETF | 58.5938 | 60.375 | 58.5 | 60.125 | 13571500.0 |
| 2001-01-10 16:00:00 | QQQ | ETF | 60.1875 | 60.5 | 58.25 | 59.8125 | 1971300.0 |
| 2001-01-10 17:00:00 | QQQ | ETF | 59.75 | 60.25 | 59.0 | 59.875 | 396000.0 |
| 2001-01-10 18:00:00 | QQQ | ETF | 60.0 | 60.0 | 59.5 | 59.5 | 67800.0 |
| 2001-01-10 09:00:00 | IWM | ETF | 45.6875 | 46.1719 | 45.6875 | 46.0625 | 49800.0 |
| 2001-01-10 10:00:00 | IWM | ETF | 46.1094 | 46.6719 | 46.1094 | 46.6719 | 25200.0 |
| 2001-01-10 11:00:00 | IWM | ETF | 46.7031 | 47.0156 | 46.6875 | 46.8281 | 491400.0 |
| 2001-01-10 12:00:00 | IWM | ETF | 46.8438 | 46.875 | 46.5938 | 46.7656 | 74800.0 |
| 2001-01-10 13:00:00 | IWM | ETF | 46.75 | 46.8906 | 46.6562 | 46.8594 | 115600.0 |
| 2001-01-10 14:00:00 | IWM | ETF | 46.8125 | 47.0 | 46.7812 | 47.0 | 45800.0 |
| 2001-01-10 15:00:00 | IWM | ETF | 47.0312 | 47.5625 | 47.0 | 47.375 | 193800.0 |
| 2001-01-10 16:00:00 | IWM | ETF | 47.4688 | 47.5938 | 47.4688 | 47.5938 | 10400.0 |
| 2001-01-10 09:00:00 | DIA | ETF | 105.125 | 105.2812 | 104.5938 | 105.0 | 193200.0 |
| 2001-01-10 10:00:00 | DIA | ETF | 105.0938 | 105.5938 | 104.9375 | 104.9375 | 315000.0 |
| 2001-01-10 11:00:00 | DIA | ETF | 105.0 | 105.75 | 104.9062 | 105.75 | 310300.0 |
| 2001-01-10 12:00:00 | DIA | ETF | 105.75 | 105.7812 | 105.25 | 105.4688 | 156500.0 |
| 2001-01-10 13:00:00 | DIA | ETF | 105.5625 | 105.625 | 104.8125 | 105.3125 | 85300.0 |
| 2001-01-10 14:00:00 | DIA | ETF | 105.25 | 105.5625 | 105.1875 | 105.4375 | 62000.0 |
| 2001-01-10 15:00:00 | DIA | ETF | 105.375 | 106.25 | 105.3125 | 106.0625 | 405100.0 |
| 2001-01-10 16:00:00 | DIA | ETF | 106.0625 | 106.5938 | 106.0625 | 106.5938 | 111700.0 |
> showing 35 of 204 rows — these rows as CSV