PREVIEW / etf_daily / 2000-11-20
file: by_date/etf_daily/2000/2000-11-20.parquet size: 8 KB rows: 87
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-11-20 | SPY | ETF | 135.75 | 136.375 | 134.3125 | 134.6875 | 5458500.0 |
| 2000-11-20 | QQQ | ETF | 70.9375 | 72.0625 | 69.25 | 69.8594 | 46862300.0 |
| 2000-11-20 | IWM | ETF | 47.6875 | 47.8438 | 46.875 | 46.9062 | 79800.0 |
| 2000-11-20 | DIA | ETF | 105.8125 | 106.0 | 104.5 | 104.6875 | 1087400.0 |
| 2000-11-20 | BBH | ETF | 53.4167 | 53.5417 | 50.1458 | 50.4375 | 5133300.0 |
| 2000-11-20 | BITS | ETF | 11.0 | 11.25 | 10.0 | 10.0 | 3375.0 |
| 2000-11-20 | BOSS | ETF | 26.3 | 26.7 | 26.3 | 26.4 | 300.0 |
| 2000-11-20 | CEF | ETF | 3.0 | 3.0 | 3.0 | 3.0 | 5000.0 |
| 2000-11-20 | CHB | ETF | 3.38 | 3.44 | 3.13 | 3.19 | 81700.0 |
| 2000-11-20 | CNXT | ETF | 28.56 | 29.25 | 27.12 | 27.87 | 3032060.0 |
| 2000-11-20 | DGT | ETF | 81.25 | 81.25 | 80.375 | 80.5 | 1000.0 |
| 2000-11-20 | EWA | ETF | 9.125 | 9.125 | 9.0625 | 9.0625 | 17500.0 |
| 2000-11-20 | EWC | ETF | 13.4375 | 13.5625 | 13.4375 | 13.4375 | 50600.0 |
| 2000-11-20 | EWD | ETF | 18.125 | 18.3125 | 18.0625 | 18.125 | 2600.0 |
| 2000-11-20 | EWG | ETF | 18.4375 | 18.5 | 18.1875 | 18.25 | 69500.0 |
| 2000-11-20 | EWH | ETF | 11.3125 | 11.3125 | 11.125 | 11.125 | 55400.0 |
| 2000-11-20 | EWI | ETF | 43.875 | 43.875 | 43.5 | 43.5 | 9250.0 |
| 2000-11-20 | EWJ | ETF | 48.75 | 49.0 | 47.75 | 48.0 | 124450.0 |
| 2000-11-20 | EWK | ETF | 12.1875 | 12.25 | 12.1875 | 12.25 | 3100.0 |
| 2000-11-20 | EWL | ETF | 15.125 | 15.25 | 15.125 | 15.125 | 5100.0 |
| 2000-11-20 | EWM | ETF | 21.75 | 22.25 | 21.75 | 21.75 | 23100.0 |
| 2000-11-20 | EWN | ETF | 22.0 | 22.0625 | 21.8125 | 21.875 | 5200.0 |
| 2000-11-20 | EWP | ETF | 21.75 | 21.875 | 21.5625 | 21.75 | 8000.0 |
| 2000-11-20 | EWQ | ETF | 23.1875 | 23.1875 | 22.75 | 22.875 | 16000.0 |
| 2000-11-20 | EWS | ETF | 12.75 | 13.0 | 12.75 | 13.0 | 12950.0 |
| 2000-11-20 | EWT | ETF | 22.625 | 22.625 | 21.75 | 21.875 | 28300.0 |
| 2000-11-20 | EWU | ETF | 35.125 | 35.25 | 34.625 | 34.875 | 10950.0 |
| 2000-11-20 | EWW | ETF | 15.3125 | 15.4375 | 15.125 | 15.1875 | 38700.0 |
| 2000-11-20 | EWY | ETF | 14.25 | 14.25 | 14.0 | 14.125 | 4800.0 |
| 2000-11-20 | EZU | ETF | 34.375 | 34.375 | 34.0 | 34.0 | 4400.0 |
| 2000-11-20 | FCTR | ETF | 14.5156 | 15.0 | 14.25 | 14.5625 | 24900.0 |
| 2000-11-20 | FMAR | ETF | 4.3125 | 4.9375 | 4.25 | 4.5 | 9200.0 |
| 2000-11-20 | GLDB | ETF | 4.5313 | 4.5313 | 4.375 | 4.5 | 193900.0 |
| 2000-11-20 | GSIG | ETF | 10.37 | 11.37 | 10.25 | 11.19 | 334400.0 |
| 2000-11-20 | IDU | ETF | 42.6562 | 42.6562 | 42.25 | 42.3594 | 12200.0 |
| 2000-11-20 | IEV | ETF | 36.9688 | 37.0 | 36.375 | 36.375 | 22200.0 |
| 2000-11-20 | IGLD | ETF | 281.25 | 284.375 | 268.75 | 268.75 | 275.0 |
| 2000-11-20 | IJH | ETF | 10.0203 | 10.0203 | 9.8563 | 9.9172 | 962000.0 |
| 2000-11-20 | IJJ | ETF | 19.4961 | 19.4961 | 19.2812 | 19.3242 | 5200.0 |
| 2000-11-20 | IJK | ETF | 16.0156 | 16.0156 | 15.5684 | 15.7129 | 77600.0 |
| 2000-11-20 | IJR | ETF | 17.5781 | 17.5781 | 17.3021 | 17.3021 | 109800.0 |
| 2000-11-20 | IJS | ETF | 17.8555 | 17.8555 | 17.6484 | 17.6484 | 3200.0 |
| 2000-11-20 | IJT | ETF | 19.8867 | 19.8867 | 19.586 | 19.6406 | 3200.0 |
| 2000-11-20 | IUSG | ETF | 28.1719 | 28.4844 | 28.1719 | 28.4844 | 1000.0 |
| 2000-11-20 | IUSV | ETF | 24.1875 | 24.1875 | 24.1094 | 24.1094 | 3000.0 |
| 2000-11-20 | IVE | ETF | 61.875 | 61.875 | 61.0 | 61.0 | 58100.0 |
| 2000-11-20 | IVV | ETF | 135.7969 | 136.1719 | 134.5 | 134.6094 | 152700.0 |
| 2000-11-20 | IVW | ETF | 18.8125 | 18.9141 | 18.6484 | 18.6562 | 227200.0 |
| 2000-11-20 | IWB | ETF | 71.48 | 72.02 | 71.3 | 71.66 | 10800.0 |
| 2000-11-20 | IWD | ETF | 57.625 | 57.625 | 57.0 | 57.0 | 33200.0 |
> showing 50 of 87 rows — these rows as CSV