PREVIEW / etf_daily / 2000-05-17
file: by_date/etf_daily/2000/2000-05-17.parquet size: 6 KB rows: 47
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2000-05-17 | SPY | ETF | 145.6875 | 146.1875 | 144.4688 | 145.1562 | 5907200.0 |
| 2000-05-17 | QQQ | ETF | 89.25 | 90.5 | 87.75 | 88.9375 | 20339400.0 |
| 2000-05-17 | DIA | ETF | 108.3125 | 108.6875 | 107.5625 | 107.75 | 896000.0 |
| 2000-05-17 | BBH | ETF | 48.6667 | 49.3125 | 48.1875 | 48.375 | 1434600.0 |
| 2000-05-17 | BITS | ETF | 25.75 | 26.0 | 24.25 | 25.25 | 9350.0 |
| 2000-05-17 | CEF | ETF | 3.4375 | 3.5 | 3.4375 | 3.4375 | 33600.0 |
| 2000-05-17 | CHB | ETF | 6.5 | 6.56 | 6.31 | 6.38 | 58200.0 |
| 2000-05-17 | CNXT | ETF | 47.06 | 47.63 | 45.75 | 46.25 | 3614300.0 |
| 2000-05-17 | EWA | ETF | 9.375 | 9.5 | 9.3125 | 9.3125 | 21300.0 |
| 2000-05-17 | EWC | ETF | 18.3125 | 18.5 | 18.125 | 18.4375 | 4500.0 |
| 2000-05-17 | EWD | ETF | 32.0 | 32.25 | 32.0 | 32.0625 | 1200.0 |
| 2000-05-17 | EWG | ETF | 23.8125 | 23.9375 | 23.5625 | 23.75 | 90200.0 |
| 2000-05-17 | EWH | ETF | 11.875 | 11.9375 | 11.8125 | 11.875 | 47800.0 |
| 2000-05-17 | EWI | ETF | 46.75 | 46.75 | 46.25 | 46.625 | 8100.0 |
| 2000-05-17 | EWJ | ETF | 58.75 | 59.0 | 58.5 | 58.5 | 49900.0 |
| 2000-05-17 | EWK | ETF | 12.5 | 12.625 | 12.5 | 12.625 | 2200.0 |
| 2000-05-17 | EWL | ETF | 15.0625 | 15.125 | 14.9375 | 15.0 | 23700.0 |
| 2000-05-17 | EWM | ETF | 27.75 | 27.75 | 27.5 | 27.75 | 24650.0 |
| 2000-05-17 | EWN | ETF | 22.875 | 23.0625 | 22.875 | 23.0 | 26800.0 |
| 2000-05-17 | EWO | ETF | 7.3125 | 7.3125 | 7.3125 | 7.3125 | 500.0 |
| 2000-05-17 | EWP | ETF | 25.4375 | 25.4375 | 25.125 | 25.1875 | 7900.0 |
| 2000-05-17 | EWQ | ETF | 26.6875 | 26.875 | 26.6875 | 26.8125 | 24100.0 |
| 2000-05-17 | EWS | ETF | 13.875 | 14.5 | 13.875 | 14.0 | 34400.0 |
| 2000-05-17 | EWU | ETF | 37.75 | 37.75 | 36.875 | 37.125 | 5450.0 |
| 2000-05-17 | EWW | ETF | 15.6875 | 15.6875 | 15.3125 | 15.3125 | 8300.0 |
| 2000-05-17 | EWY | ETF | 19.4375 | 19.4375 | 19.4375 | 19.4375 | 400.0 |
| 2000-05-17 | FCTR | ETF | 15.375 | 16.0 | 15.125 | 15.4375 | 15100.0 |
| 2000-05-17 | FMAR | ETF | 6.03 | 6.5 | 6.03 | 6.5 | 3200.0 |
| 2000-05-17 | GLDB | ETF | 6.0313 | 6.25 | 6.0 | 6.25 | 33700.0 |
| 2000-05-17 | GSIG | ETF | 22.37 | 23.44 | 22.31 | 23.25 | 521100.0 |
| 2000-05-17 | IGLD | ETF | 1012.5 | 1031.25 | 1000.0 | 1006.25 | 852.0 |
| 2000-05-17 | KTEC | ETF | 8.125 | 8.1875 | 8.125 | 8.1875 | 9000.0 |
| 2000-05-17 | MDY | ETF | 88.5 | 89.6875 | 88.25 | 89.2812 | 289200.0 |
| 2000-05-17 | MIG | ETF | 5.5 | 5.5 | 5.5 | 5.5 | 400.0 |
| 2000-05-17 | PPH | ETF | 48.8125 | 49.2188 | 48.7188 | 48.8438 | 87800.0 |
| 2000-05-17 | SFY | ETF | 23.6875 | 25.0 | 23.625 | 24.5 | 126600.0 |
| 2000-05-17 | TDSC | ETF | 4.94 | 4.94 | 4.67 | 4.94 | 18800.0 |
| 2000-05-17 | TINY | ETF | 8.06 | 8.12 | 7.88 | 8.0 | 31600.0 |
| 2000-05-17 | XLB | ETF | 11.6094 | 11.7969 | 11.5625 | 11.6875 | 28000.0 |
| 2000-05-17 | XLE | ETF | 15.9062 | 15.9062 | 15.6797 | 15.8984 | 91200.0 |
| 2000-05-17 | XLF | ETF | 19.7121 | 20.0295 | 19.6994 | 19.7502 | 118053.0 |
| 2000-05-17 | XLI | ETF | 30.7188 | 30.7188 | 30.4375 | 30.6719 | 4900.0 |
| 2000-05-17 | XLK | ETF | 26.0312 | 26.1719 | 25.5625 | 25.9219 | 737200.0 |
| 2000-05-17 | XLP | ETF | 23.625 | 23.9375 | 23.625 | 23.8594 | 19000.0 |
| 2000-05-17 | XLU | ETF | 14.1719 | 14.1719 | 14.0078 | 14.0703 | 13200.0 |
| 2000-05-17 | XLV | ETF | 29.6562 | 29.9062 | 29.5938 | 29.6562 | 6600.0 |
| 2000-05-17 | XLY | ETF | 14.2188 | 14.2422 | 14.125 | 14.1562 | 19000.0 |
> showing 47 of 47 rows — these rows as CSV