PREVIEW / etf_1hour / 2000-02-11
file: by_date/etf_1hour/2000/2000-02-11.parquet size: 8 KB rows: 132
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-11 09:00:00 | SPY | ETF | 141.8438 | 141.9375 | 140.9375 | 141.2188 | 844900.0 |
| 2000-02-11 10:00:00 | SPY | ETF | 141.3125 | 141.4688 | 140.25 | 140.625 | 1551900.0 |
| 2000-02-11 11:00:00 | SPY | ETF | 140.7188 | 141.4375 | 140.3125 | 140.9062 | 689200.0 |
| 2000-02-11 12:00:00 | SPY | ETF | 140.9688 | 141.1562 | 140.5 | 140.7188 | 466700.0 |
| 2000-02-11 13:00:00 | SPY | ETF | 140.75 | 140.8438 | 140.25 | 140.4375 | 226400.0 |
| 2000-02-11 14:00:00 | SPY | ETF | 140.25 | 140.3125 | 139.0625 | 139.4062 | 1979600.0 |
| 2000-02-11 15:00:00 | SPY | ETF | 139.4375 | 139.5 | 138.0312 | 139.1875 | 2313800.0 |
| 2000-02-11 16:00:00 | SPY | ETF | 139.125 | 139.5 | 139.0 | 139.1875 | 1517000.0 |
| 2000-02-11 17:00:00 | SPY | ETF | 139.1875 | 139.1875 | 138.6875 | 138.6875 | 1000.0 |
| 2000-02-11 09:00:00 | QQQ | ETF | 102.0625 | 102.0625 | 101.1562 | 101.3125 | 1942200.0 |
| 2000-02-11 10:00:00 | QQQ | ETF | 101.25 | 101.625 | 100.0625 | 100.5625 | 3672400.0 |
| 2000-02-11 11:00:00 | QQQ | ETF | 100.7188 | 101.1562 | 99.6875 | 100.625 | 4026400.0 |
| 2000-02-11 12:00:00 | QQQ | ETF | 100.75 | 101.125 | 100.4062 | 100.8125 | 1849000.0 |
| 2000-02-11 13:00:00 | QQQ | ETF | 100.9375 | 101.0625 | 100.25 | 100.4375 | 1938600.0 |
| 2000-02-11 14:00:00 | QQQ | ETF | 100.4062 | 100.4375 | 99.375 | 99.7188 | 3456200.0 |
| 2000-02-11 15:00:00 | QQQ | ETF | 99.7344 | 99.8906 | 98.0 | 99.2188 | 6480200.0 |
| 2000-02-11 16:00:00 | QQQ | ETF | 99.3438 | 99.4375 | 98.875 | 99.1875 | 1307200.0 |
| 2000-02-11 17:00:00 | QQQ | ETF | 99.0 | 99.1875 | 99.0 | 99.1875 | 600.0 |
| 2000-02-11 18:00:00 | QQQ | ETF | 99.875 | 99.875 | 99.875 | 99.875 | 200.0 |
| 2000-02-11 09:00:00 | DIA | ETF | 106.5625 | 106.5625 | 106.125 | 106.3125 | 469200.0 |
| 2000-02-11 10:00:00 | DIA | ETF | 106.1875 | 106.4375 | 105.6562 | 106.0 | 240000.0 |
| 2000-02-11 11:00:00 | DIA | ETF | 106.0312 | 106.375 | 105.625 | 105.9375 | 266800.0 |
| 2000-02-11 12:00:00 | DIA | ETF | 106.0938 | 106.1562 | 105.75 | 105.9375 | 44600.0 |
| 2000-02-11 13:00:00 | DIA | ETF | 105.875 | 105.9375 | 105.375 | 105.5 | 111700.0 |
| 2000-02-11 14:00:00 | DIA | ETF | 105.7188 | 105.7188 | 104.375 | 104.7812 | 358000.0 |
| 2000-02-11 15:00:00 | DIA | ETF | 104.6562 | 104.8125 | 103.625 | 104.375 | 606800.0 |
| 2000-02-11 16:00:00 | DIA | ETF | 104.375 | 104.5938 | 104.25 | 104.5 | 43900.0 |
> showing 27 of 132 rows — these rows as CSV