PREVIEW / etf_daily / 2000-10-23
file: by_date/etf_daily/2000/2000-10-23.parquet size: 8 KB rows: 86
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-10-23 | SPY | ETF | 139.9375 | 141.0312 | 138.9375 | 140.5312 | 5290000.0 |
| 2000-10-23 | QQQ | ETF | 86.1875 | 87.5 | 84.125 | 86.1875 | 28989200.0 |
| 2000-10-23 | IWM | ETF | 48.8438 | 49.125 | 48.6641 | 49.0625 | 143200.0 |
| 2000-10-23 | DIA | ETF | 102.625 | 103.6094 | 102.2812 | 103.1406 | 866900.0 |
| 2000-10-23 | BBH | ETF | 59.6667 | 62.2292 | 59.1875 | 61.6875 | 1538100.0 |
| 2000-10-23 | BITS | ETF | 10.0 | 11.0 | 9.5 | 9.75 | 5700.0 |
| 2000-10-23 | BOSS | ETF | 22.7 | 23.8 | 22.7 | 23.5 | 1000.0 |
| 2000-10-23 | CEF | ETF | 3.0625 | 3.0625 | 3.0 | 3.0625 | 14600.0 |
| 2000-10-23 | CHB | ETF | 3.31 | 3.44 | 3.0 | 3.25 | 799800.0 |
| 2000-10-23 | CNXT | ETF | 28.31 | 28.81 | 25.62 | 26.5 | 6211270.0 |
| 2000-10-23 | DGT | ETF | 82.6562 | 82.6562 | 82.2812 | 82.2812 | 600.0 |
| 2000-10-23 | EWA | ETF | 9.25 | 9.25 | 9.0625 | 9.1875 | 23200.0 |
| 2000-10-23 | EWC | ETF | 15.875 | 16.25 | 15.875 | 16.0 | 55000.0 |
| 2000-10-23 | EWD | ETF | 18.9375 | 19.3125 | 18.9375 | 19.25 | 4200.0 |
| 2000-10-23 | EWG | ETF | 17.8125 | 18.0625 | 17.8125 | 17.9375 | 44800.0 |
| 2000-10-23 | EWH | ETF | 11.0625 | 11.25 | 11.0625 | 11.125 | 38800.0 |
| 2000-10-23 | EWI | ETF | 40.75 | 41.375 | 40.75 | 40.75 | 11600.0 |
| 2000-10-23 | EWJ | ETF | 50.5 | 51.0 | 50.25 | 51.0 | 48300.0 |
| 2000-10-23 | EWK | ETF | 11.8125 | 12.0625 | 11.8125 | 12.0625 | 700.0 |
| 2000-10-23 | EWL | ETF | 14.3125 | 14.5625 | 14.3125 | 14.3125 | 7400.0 |
| 2000-10-23 | EWM | ETF | 22.5 | 23.5 | 22.5 | 23.5 | 34500.0 |
| 2000-10-23 | EWN | ETF | 21.4375 | 21.625 | 21.4375 | 21.5625 | 4100.0 |
| 2000-10-23 | EWO | ETF | 6.8125 | 6.875 | 6.8125 | 6.875 | 1900.0 |
| 2000-10-23 | EWP | ETF | 22.4375 | 22.5625 | 22.4375 | 22.5625 | 3800.0 |
| 2000-10-23 | EWQ | ETF | 22.8125 | 23.125 | 22.75 | 23.125 | 25000.0 |
| 2000-10-23 | EWS | ETF | 13.125 | 13.125 | 12.75 | 12.875 | 26250.0 |
| 2000-10-23 | EWT | ETF | 24.375 | 25.125 | 24.375 | 25.125 | 7150.0 |
| 2000-10-23 | EWU | ETF | 34.875 | 35.375 | 34.875 | 35.25 | 19800.0 |
| 2000-10-23 | EWW | ETF | 14.5 | 14.5 | 14.0625 | 14.25 | 32300.0 |
| 2000-10-23 | EWY | ETF | 14.4375 | 14.5 | 14.0 | 14.4375 | 6900.0 |
| 2000-10-23 | EWZ | ETF | 16.6875 | 16.6875 | 16.125 | 16.125 | 300.0 |
| 2000-10-23 | EZU | ETF | 33.75 | 33.75 | 33.75 | 33.75 | 2000.0 |
| 2000-10-23 | FCTR | ETF | 15.1875 | 15.375 | 15.1875 | 15.2188 | 18000.0 |
| 2000-10-23 | FMAR | ETF | 5.19 | 5.2525 | 5.0 | 5.0 | 1700.0 |
| 2000-10-23 | GLDB | ETF | 4.0156 | 4.0625 | 3.9375 | 3.9375 | 27700.0 |
| 2000-10-23 | GSIG | ETF | 13.0 | 13.0 | 12.44 | 12.56 | 244300.0 |
| 2000-10-23 | IDU | ETF | 40.9688 | 41.625 | 40.9688 | 41.2734 | 4400.0 |
| 2000-10-23 | IEV | ETF | 36.125 | 36.2812 | 36.125 | 36.2812 | 6000.0 |
| 2000-10-23 | IGLD | ETF | 300.0 | 318.75 | 287.5 | 318.75 | 949.0 |
| 2000-10-23 | IJH | ETF | 10.3281 | 10.4156 | 10.3062 | 10.35 | 102000.0 |
| 2000-10-23 | IJJ | ETF | 18.9062 | 18.9258 | 18.8906 | 18.8906 | 10000.0 |
| 2000-10-23 | IJK | ETF | 17.3281 | 17.5234 | 17.3281 | 17.3672 | 108000.0 |
| 2000-10-23 | IJR | ETF | 17.4375 | 17.5729 | 17.4193 | 17.5729 | 66600.0 |
| 2000-10-23 | IJS | ETF | 17.1172 | 17.2188 | 17.1172 | 17.2031 | 7600.0 |
| 2000-10-23 | IJT | ETF | 20.5664 | 20.7305 | 20.5312 | 20.6328 | 18800.0 |
| 2000-10-23 | IUSG | ETF | 31.5 | 31.5 | 31.125 | 31.125 | 2000.0 |
| 2000-10-23 | IUSV | ETF | 23.8333 | 23.8333 | 23.8021 | 23.8021 | 3300.0 |
| 2000-10-23 | IVE | ETF | 61.0 | 61.4375 | 60.8438 | 61.4375 | 23000.0 |
| 2000-10-23 | IVV | ETF | 139.6875 | 140.9062 | 139.125 | 140.6719 | 30300.0 |
| 2000-10-23 | IVW | ETF | 20.2188 | 20.4062 | 20.0312 | 20.2812 | 72400.0 |
> showing 50 of 86 rows — these rows as CSV