PREVIEW / etf_1hour / 2000-02-14
file: by_date/etf_1hour/2000/2000-02-14.parquet size: 8 KB rows: 131
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-14 09:00:00 | SPY | ETF | 139.7812 | 139.7812 | 138.9375 | 139.0625 | 1389400.0 |
| 2000-02-14 10:00:00 | SPY | ETF | 138.9062 | 139.5312 | 138.5 | 139.125 | 1687800.0 |
| 2000-02-14 11:00:00 | SPY | ETF | 139.125 | 139.75 | 139.0312 | 139.625 | 1045400.0 |
| 2000-02-14 12:00:00 | SPY | ETF | 139.6875 | 139.6875 | 138.7812 | 138.875 | 550000.0 |
| 2000-02-14 13:00:00 | SPY | ETF | 139.0 | 139.0938 | 138.3125 | 138.7812 | 867400.0 |
| 2000-02-14 14:00:00 | SPY | ETF | 138.875 | 139.2188 | 138.4375 | 138.625 | 1078400.0 |
| 2000-02-14 15:00:00 | SPY | ETF | 138.6875 | 139.4688 | 138.5312 | 139.25 | 1250400.0 |
| 2000-02-14 16:00:00 | SPY | ETF | 139.25 | 139.5625 | 139.1875 | 139.5 | 597900.0 |
| 2000-02-14 09:00:00 | QQQ | ETF | 99.9844 | 100.0 | 99.0 | 99.0 | 2612200.0 |
| 2000-02-14 10:00:00 | QQQ | ETF | 99.375 | 99.6719 | 97.75 | 98.625 | 5284000.0 |
| 2000-02-14 11:00:00 | QQQ | ETF | 98.5938 | 99.5312 | 98.5 | 99.4062 | 3534800.0 |
| 2000-02-14 12:00:00 | QQQ | ETF | 99.4375 | 99.4844 | 98.5156 | 98.8594 | 1786800.0 |
| 2000-02-14 13:00:00 | QQQ | ETF | 98.8438 | 99.0625 | 97.75 | 98.3125 | 2698000.0 |
| 2000-02-14 14:00:00 | QQQ | ETF | 98.3125 | 99.0 | 97.9062 | 98.125 | 2477400.0 |
| 2000-02-14 15:00:00 | QQQ | ETF | 98.0625 | 99.7344 | 98.0 | 99.5 | 3971800.0 |
| 2000-02-14 16:00:00 | QQQ | ETF | 99.5 | 99.5312 | 99.25 | 99.3594 | 302000.0 |
| 2000-02-14 17:00:00 | QQQ | ETF | 99.75 | 99.75 | 99.75 | 99.75 | 800.0 |
| 2000-02-14 09:00:00 | DIA | ETF | 105.0 | 105.0625 | 104.6562 | 104.6875 | 246900.0 |
| 2000-02-14 10:00:00 | DIA | ETF | 104.75 | 105.4062 | 104.5625 | 105.1562 | 204100.0 |
| 2000-02-14 11:00:00 | DIA | ETF | 105.1875 | 105.5938 | 105.0938 | 105.5625 | 204300.0 |
| 2000-02-14 12:00:00 | DIA | ETF | 105.5 | 105.5625 | 105.0 | 105.1875 | 305400.0 |
| 2000-02-14 13:00:00 | DIA | ETF | 105.0312 | 105.3125 | 104.75 | 105.25 | 83100.0 |
| 2000-02-14 14:00:00 | DIA | ETF | 105.125 | 105.1562 | 104.5625 | 104.8438 | 35200.0 |
| 2000-02-14 15:00:00 | DIA | ETF | 104.6875 | 105.375 | 104.6875 | 105.3438 | 163300.0 |
| 2000-02-14 16:00:00 | DIA | ETF | 105.375 | 105.5625 | 105.25 | 105.5 | 24300.0 |
> showing 25 of 131 rows — these rows as CSV