PREVIEW / etf_1hour / 2000-02-01
file: by_date/etf_1hour/2000/2000-02-01.parquet size: 8 KB rows: 133
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-02-01 09:00:00 | SPY | ETF | 139.75 | 139.75 | 139.0312 | 139.4688 | 1106900.0 |
| 2000-02-01 10:00:00 | SPY | ETF | 139.25 | 139.8125 | 138.5312 | 139.5 | 1296600.0 |
| 2000-02-01 11:00:00 | SPY | ETF | 139.5 | 139.9688 | 139.2188 | 139.3438 | 840400.0 |
| 2000-02-01 12:00:00 | SPY | ETF | 139.2812 | 140.3438 | 139.125 | 140.3438 | 1150600.0 |
| 2000-02-01 13:00:00 | SPY | ETF | 140.25 | 140.5938 | 139.9062 | 140.0938 | 1030300.0 |
| 2000-02-01 14:00:00 | SPY | ETF | 139.875 | 140.625 | 139.8438 | 140.125 | 928700.0 |
| 2000-02-01 15:00:00 | SPY | ETF | 140.2812 | 141.6875 | 140.0312 | 140.9062 | 1328400.0 |
| 2000-02-01 16:00:00 | SPY | ETF | 140.9062 | 141.2812 | 140.9062 | 140.9375 | 367800.0 |
| 2000-02-01 18:00:00 | SPY | ETF | 140.9375 | 140.9375 | 140.9375 | 140.9375 | 100.0 |
| 2000-02-01 09:00:00 | QQQ | ETF | 89.5312 | 90.4375 | 89.2188 | 89.4062 | 3428400.0 |
| 2000-02-01 10:00:00 | QQQ | ETF | 89.4062 | 90.1562 | 88.4375 | 89.8125 | 5128800.0 |
| 2000-02-01 11:00:00 | QQQ | ETF | 89.8594 | 90.75 | 89.5938 | 90.4375 | 2355600.0 |
| 2000-02-01 12:00:00 | QQQ | ETF | 90.4375 | 91.25 | 90.2188 | 90.9375 | 4069000.0 |
| 2000-02-01 13:00:00 | QQQ | ETF | 90.9688 | 91.4688 | 90.6562 | 90.9219 | 2616800.0 |
| 2000-02-01 14:00:00 | QQQ | ETF | 90.9219 | 91.4062 | 90.4062 | 90.6719 | 2368000.0 |
| 2000-02-01 15:00:00 | QQQ | ETF | 90.6719 | 92.5 | 90.625 | 92.1562 | 5539400.0 |
| 2000-02-01 16:00:00 | QQQ | ETF | 92.3125 | 92.5 | 92.0938 | 92.5 | 479800.0 |
| 2000-02-01 17:00:00 | QQQ | ETF | 92.0938 | 92.0938 | 92.0938 | 92.0938 | 1000.0 |
| 2000-02-01 09:00:00 | DIA | ETF | 109.5625 | 109.7812 | 109.3125 | 109.375 | 212000.0 |
| 2000-02-01 10:00:00 | DIA | ETF | 109.625 | 109.9375 | 109.0312 | 109.75 | 215700.0 |
| 2000-02-01 11:00:00 | DIA | ETF | 109.625 | 109.9688 | 109.375 | 109.375 | 43800.0 |
| 2000-02-01 12:00:00 | DIA | ETF | 109.5 | 110.0 | 109.4375 | 109.9688 | 70400.0 |
| 2000-02-01 13:00:00 | DIA | ETF | 110.0 | 110.2812 | 109.6875 | 109.8438 | 54100.0 |
| 2000-02-01 14:00:00 | DIA | ETF | 109.8125 | 110.375 | 109.5938 | 109.9688 | 62400.0 |
| 2000-02-01 15:00:00 | DIA | ETF | 110.0 | 110.7188 | 109.875 | 110.2812 | 107300.0 |
| 2000-02-01 16:00:00 | DIA | ETF | 110.375 | 110.5 | 110.2812 | 110.2812 | 20800.0 |
> showing 26 of 133 rows — these rows as CSV