PREVIEW / etf_1hour / 2000-12-20
file: by_date/etf_1hour/2000/2000-12-20.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 |
|---|---|---|---|---|---|---|---|
| 2000-12-20 09:00:00 | SPY | ETF | 128.625 | 128.7188 | 127.125 | 128.0 | 2134400.0 |
| 2000-12-20 10:00:00 | SPY | ETF | 128.0312 | 128.75 | 127.5625 | 128.5625 | 1771300.0 |
| 2000-12-20 11:00:00 | SPY | ETF | 128.625 | 128.9375 | 127.8438 | 128.625 | 904400.0 |
| 2000-12-20 12:00:00 | SPY | ETF | 128.6562 | 128.75 | 127.4375 | 127.75 | 873400.0 |
| 2000-12-20 13:00:00 | SPY | ETF | 127.625 | 127.8438 | 127.0938 | 127.4688 | 595500.0 |
| 2000-12-20 14:00:00 | SPY | ETF | 127.4375 | 128.0 | 126.6875 | 126.9375 | 1256800.0 |
| 2000-12-20 15:00:00 | SPY | ETF | 126.875 | 127.7188 | 126.0938 | 126.6875 | 1540700.0 |
| 2000-12-20 16:00:00 | SPY | ETF | 126.6875 | 126.9062 | 126.1562 | 126.625 | 534400.0 |
| 2000-12-20 17:00:00 | SPY | ETF | 126.4375 | 126.5 | 126.4375 | 126.5 | 100200.0 |
| 2000-12-20 18:00:00 | SPY | ETF | 126.75 | 126.75 | 126.75 | 126.75 | 100.0 |
| 2000-12-20 09:00:00 | QQQ | ETF | 57.3125 | 58.3125 | 56.1875 | 57.5 | 14072600.0 |
| 2000-12-20 10:00:00 | QQQ | ETF | 57.5 | 58.375 | 56.5625 | 57.625 | 12445400.0 |
| 2000-12-20 11:00:00 | QQQ | ETF | 57.75 | 58.125 | 56.6875 | 57.4375 | 6896800.0 |
| 2000-12-20 12:00:00 | QQQ | ETF | 57.4688 | 57.7188 | 56.25 | 56.375 | 6130300.0 |
| 2000-12-20 13:00:00 | QQQ | ETF | 56.4062 | 56.75 | 55.75 | 56.0625 | 7622000.0 |
| 2000-12-20 14:00:00 | QQQ | ETF | 56.2188 | 56.9375 | 55.5 | 55.625 | 8196100.0 |
| 2000-12-20 15:00:00 | QQQ | ETF | 55.6562 | 56.5312 | 54.75 | 55.4375 | 15575500.0 |
| 2000-12-20 16:00:00 | QQQ | ETF | 55.4062 | 56.375 | 55.0 | 55.8125 | 2662600.0 |
| 2000-12-20 17:00:00 | QQQ | ETF | 55.875 | 56.25 | 55.7188 | 55.875 | 191800.0 |
| 2000-12-20 18:00:00 | QQQ | ETF | 55.8125 | 55.875 | 55.625 | 55.7188 | 41700.0 |
| 2000-12-20 09:00:00 | IWM | ETF | 44.7344 | 45.0 | 44.5625 | 44.875 | 48600.0 |
| 2000-12-20 10:00:00 | IWM | ETF | 44.9062 | 44.9062 | 44.5156 | 44.6562 | 18200.0 |
| 2000-12-20 11:00:00 | IWM | ETF | 44.6875 | 44.7188 | 44.3438 | 44.4062 | 20800.0 |
| 2000-12-20 12:00:00 | IWM | ETF | 44.5312 | 44.5625 | 44.3125 | 44.375 | 58000.0 |
| 2000-12-20 13:00:00 | IWM | ETF | 44.4219 | 44.4219 | 44.2188 | 44.3125 | 16200.0 |
| 2000-12-20 14:00:00 | IWM | ETF | 44.3125 | 44.375 | 44.125 | 44.125 | 51200.0 |
| 2000-12-20 15:00:00 | IWM | ETF | 44.0625 | 44.3438 | 43.9062 | 44.2188 | 40000.0 |
| 2000-12-20 16:00:00 | IWM | ETF | 44.0625 | 44.0625 | 44.0625 | 44.0625 | 3600.0 |
| 2000-12-20 09:00:00 | DIA | ETF | 104.0938 | 104.5 | 103.5 | 104.2188 | 447300.0 |
| 2000-12-20 10:00:00 | DIA | ETF | 104.0312 | 104.5938 | 103.8438 | 104.375 | 393700.0 |
| 2000-12-20 11:00:00 | DIA | ETF | 104.3125 | 104.9062 | 104.25 | 104.7188 | 138200.0 |
| 2000-12-20 12:00:00 | DIA | ETF | 104.5938 | 104.75 | 104.0312 | 104.2188 | 266500.0 |
| 2000-12-20 13:00:00 | DIA | ETF | 104.0625 | 104.25 | 103.75 | 103.7812 | 77500.0 |
| 2000-12-20 14:00:00 | DIA | ETF | 103.875 | 104.1875 | 103.2812 | 103.625 | 367900.0 |
| 2000-12-20 15:00:00 | DIA | ETF | 103.625 | 104.0625 | 103.0625 | 103.2188 | 565000.0 |
| 2000-12-20 16:00:00 | DIA | ETF | 103.0625 | 103.25 | 102.9375 | 102.9375 | 126700.0 |
> showing 36 of 202 rows — these rows as CSV