PREVIEW / etf_daily / 2000-07-28
file: by_date/etf_daily/2000/2000-07-28.parquet size: 8 KB rows: 80
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-07-28 | SPY | ETF | 145.7188 | 145.9062 | 141.5156 | 142.0938 | 6229500.0 |
| 2000-07-28 | QQQ | ETF | 92.1875 | 92.875 | 86.0 | 86.875 | 36486200.0 |
| 2000-07-28 | IWM | ETF | 50.1641 | 50.1641 | 48.875 | 49.0 | 171600.0 |
| 2000-07-28 | DIA | ETF | 106.2656 | 106.5 | 104.5312 | 105.0 | 523100.0 |
| 2000-07-28 | BBH | ETF | 58.5417 | 59.0833 | 56.0208 | 56.1042 | 1676400.0 |
| 2000-07-28 | BITS | ETF | 15.0 | 16.25 | 14.5 | 14.75 | 13750.0 |
| 2000-07-28 | CEF | ETF | 3.375 | 3.4375 | 3.3125 | 3.4375 | 71200.0 |
| 2000-07-28 | CHB | ETF | 5.44 | 5.5 | 5.38 | 5.5 | 25300.0 |
| 2000-07-28 | CNXT | ETF | 32.75 | 33.94 | 30.62 | 32.38 | 4878620.0 |
| 2000-07-28 | EWA | ETF | 10.3125 | 10.3125 | 10.25 | 10.25 | 900.0 |
| 2000-07-28 | EWC | ETF | 21.0625 | 21.0625 | 20.0625 | 20.3125 | 142000.0 |
| 2000-07-28 | EWD | ETF | 29.75 | 29.9375 | 29.6875 | 29.6875 | 5000.0 |
| 2000-07-28 | EWG | ETF | 24.125 | 24.1875 | 23.5625 | 23.875 | 137800.0 |
| 2000-07-28 | EWH | ETF | 13.4375 | 13.4375 | 12.9375 | 12.9375 | 57700.0 |
| 2000-07-28 | EWI | ETF | 49.5 | 49.625 | 49.125 | 49.375 | 7750.0 |
| 2000-07-28 | EWJ | ETF | 53.5 | 54.0 | 52.0 | 52.75 | 129250.0 |
| 2000-07-28 | EWK | ETF | 14.0 | 14.0 | 13.6875 | 13.6875 | 2200.0 |
| 2000-07-28 | EWL | ETF | 15.9375 | 16.1875 | 15.875 | 16.0 | 7100.0 |
| 2000-07-28 | EWM | ETF | 24.25 | 24.5 | 24.0 | 24.5 | 13525.0 |
| 2000-07-28 | EWN | ETF | 23.75 | 23.75 | 23.5 | 23.5 | 3000.0 |
| 2000-07-28 | EWO | ETF | 8.0625 | 8.0625 | 8.0 | 8.0 | 1700.0 |
| 2000-07-28 | EWP | ETF | 25.75 | 25.75 | 25.3125 | 25.3125 | 5900.0 |
| 2000-07-28 | EWQ | ETF | 28.0 | 28.125 | 27.75 | 27.75 | 6400.0 |
| 2000-07-28 | EWS | ETF | 14.625 | 14.75 | 14.375 | 14.5 | 24050.0 |
| 2000-07-28 | EWT | ETF | 36.125 | 36.125 | 36.125 | 36.125 | 250.0 |
| 2000-07-28 | EWU | ETF | 38.5 | 38.625 | 38.25 | 38.5 | 7750.0 |
| 2000-07-28 | EWW | ETF | 16.5625 | 16.625 | 16.125 | 16.25 | 22300.0 |
| 2000-07-28 | EWY | ETF | 18.0 | 18.25 | 17.9375 | 17.9375 | 18200.0 |
| 2000-07-28 | EWZ | ETF | 20.0 | 20.0 | 19.375 | 19.375 | 21300.0 |
| 2000-07-28 | FCTR | ETF | 14.125 | 15.25 | 14.125 | 14.375 | 28900.0 |
| 2000-07-28 | FMAR | ETF | 5.06 | 5.25 | 4.88 | 5.0 | 27090.0 |
| 2000-07-28 | GLDB | ETF | 5.0625 | 5.125 | 4.5625 | 4.5938 | 256900.0 |
| 2000-07-28 | GSIG | ETF | 26.31 | 27.12 | 20.12 | 24.06 | 2367000.0 |
| 2000-07-28 | IDU | ETF | 35.5 | 35.5 | 35.1562 | 35.1562 | 1800.0 |
| 2000-07-28 | IEV | ETF | 38.735 | 38.765 | 38.25 | 38.31 | 48800.0 |
| 2000-07-28 | IGLD | ETF | 743.75 | 768.75 | 700.0 | 737.5 | 305.0 |
| 2000-07-28 | IJH | ETF | 9.8141 | 9.8141 | 9.6281 | 9.6906 | 305000.0 |
| 2000-07-28 | IJJ | ETF | 17.965 | 17.965 | 17.965 | 17.965 | 2400.0 |
| 2000-07-28 | IJK | ETF | 16.4138 | 16.4138 | 15.975 | 15.975 | 16000.0 |
| 2000-07-28 | IJR | ETF | 17.1354 | 17.1354 | 16.7787 | 16.8255 | 14400.0 |
| 2000-07-28 | IJS | ETF | 16.7725 | 16.8175 | 16.7575 | 16.765 | 12800.0 |
| 2000-07-28 | IJT | ETF | 19.555 | 19.71 | 19.4225 | 19.4225 | 7200.0 |
| 2000-07-28 | IUSG | ETF | 16.0859 | 16.0859 | 16.0859 | 16.0859 | 2000.0 |
| 2000-07-28 | IVE | ETF | 59.7031 | 59.7031 | 58.7188 | 58.7188 | 7800.0 |
| 2000-07-28 | IVV | ETF | 145.5 | 145.5 | 141.5 | 142.2188 | 1147800.0 |
| 2000-07-28 | IVW | ETF | 22.1719 | 22.1836 | 21.3906 | 21.4805 | 101200.0 |
| 2000-07-28 | IWB | ETF | 76.4844 | 76.4844 | 75.4688 | 75.5156 | 1200.0 |
| 2000-07-28 | IWD | ETF | 55.125 | 55.125 | 54.25 | 54.25 | 4500.0 |
| 2000-07-28 | IWF | ETF | 21.296875 | 21.296875 | 20.41405 | 20.5039 | 82800.0 |
| 2000-07-28 | IWN | ETF | 34.125 | 34.2083 | 34.1042 | 34.1458 | 4200.0 |
> showing 50 of 80 rows — these rows as CSV