PREVIEW / etf_daily / 2001-06-28
file: by_date/etf_daily/2001/2001-06-28.parquet size: 8 KB rows: 98
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 |
|---|---|---|---|---|---|---|---|
| 2001-06-28 | SPY | ETF | 122.0 | 123.94 | 121.93 | 122.15 | 10269300.0 |
| 2001-06-28 | QQQ | ETF | 44.402 | 46.36 | 44.35 | 44.35 | 89985900.0 |
| 2001-06-28 | IWM | ETF | 49.75 | 50.375 | 49.75 | 50.1 | 922600.0 |
| 2001-06-28 | DIA | ETF | 105.07 | 106.83 | 105.0 | 105.69 | 2888600.0 |
| 2001-06-28 | BBH | ETF | 43.68 | 45.1167 | 43.68 | 44.17 | 3754800.0 |
| 2001-06-28 | BITS | ETF | 12.36 | 12.64 | 12.2 | 12.4 | 3825.0 |
| 2001-06-28 | CEF | ETF | 3.26 | 3.26 | 3.22 | 3.25 | 5300.0 |
| 2001-06-28 | CHB | ETF | 11.0 | 11.07 | 10.9 | 11.0 | 186800.0 |
| 2001-06-28 | CNXT | ETF | 7.92 | 8.67 | 7.92 | 8.4 | 1572250.0 |
| 2001-06-28 | DGT | ETF | 70.8 | 70.8 | 70.8 | 70.8 | 5000.0 |
| 2001-06-28 | EWA | ETF | 9.55 | 9.7 | 9.55 | 9.61 | 126000.0 |
| 2001-06-28 | EWC | ETF | 11.4 | 11.4 | 11.15 | 11.2 | 6700.0 |
| 2001-06-28 | EWD | ETF | 13.6 | 13.6 | 13.5 | 13.5 | 600.0 |
| 2001-06-28 | EWG | ETF | 16.25 | 16.3 | 16.2 | 16.21 | 56200.0 |
| 2001-06-28 | EWH | ETF | 9.95 | 10.04 | 9.9 | 9.96 | 151500.0 |
| 2001-06-28 | EWI | ETF | 35.56 | 35.6 | 35.5 | 35.6 | 900.0 |
| 2001-06-28 | EWJ | ETF | 40.52 | 40.92 | 40.52 | 40.8 | 189125.0 |
| 2001-06-28 | EWK | ETF | 11.05 | 11.05 | 11.05 | 11.05 | 400.0 |
| 2001-06-28 | EWL | ETF | 13.22 | 13.4 | 13.2 | 13.35 | 5700.0 |
| 2001-06-28 | EWM | ETF | 17.4 | 17.48 | 17.24 | 17.48 | 5675.0 |
| 2001-06-28 | EWN | ETF | 18.99 | 19.15 | 18.96 | 19.1 | 2400.0 |
| 2001-06-28 | EWO | ETF | 8.0 | 8.0 | 7.8 | 7.8 | 10100.0 |
| 2001-06-28 | EWP | ETF | 21.29 | 21.29 | 21.25 | 21.25 | 600.0 |
| 2001-06-28 | EWQ | ETF | 19.7 | 19.7 | 19.56 | 19.6 | 7900.0 |
| 2001-06-28 | EWS | ETF | 10.72 | 10.84 | 10.7 | 10.84 | 8300.0 |
| 2001-06-28 | EWT | ETF | 19.5 | 20.2 | 19.5 | 20.04 | 16200.0 |
| 2001-06-28 | EWU | ETF | 31.54 | 31.66 | 31.34 | 31.34 | 7650.0 |
| 2001-06-28 | EWW | ETF | 16.45 | 16.8 | 16.45 | 16.5 | 45500.0 |
| 2001-06-28 | EWY | ETF | 13.95 | 14.65 | 13.95 | 14.65 | 24400.0 |
| 2001-06-28 | EWZ | ETF | 14.38 | 14.53 | 14.38 | 14.53 | 8500.0 |
| 2001-06-28 | EZU | ETF | 29.34 | 29.825 | 29.34 | 29.58 | 450200.0 |
| 2001-06-28 | FCTR | ETF | 17.08 | 17.37 | 17.08 | 17.25 | 43700.0 |
| 2001-06-28 | FMAR | ETF | 6.5 | 6.5 | 6.2 | 6.45 | 1000.0 |
| 2001-06-28 | GLDB | ETF | 7.32 | 7.45 | 7.2 | 7.41 | 108800.0 |
| 2001-06-28 | GSIG | ETF | 9.36 | 9.52 | 8.8 | 9.07 | 170700.0 |
| 2001-06-28 | IBB | ETF | 32.6333 | 33.3167 | 32.5833 | 32.8167 | 391800.0 |
| 2001-06-28 | ICF | ETF | 21.1925 | 21.1925 | 21.19 | 21.19 | 1600.0 |
| 2001-06-28 | IDU | ETF | 39.35 | 39.5 | 39.25 | 39.25 | 1800.0 |
| 2001-06-28 | IEV | ETF | 31.35 | 31.505 | 30.95 | 31.25 | 113200.0 |
| 2001-06-28 | IGLD | ETF | 67.0 | 67.0 | 67.0 | 67.0 | 8.0 |
| 2001-06-28 | IGM | ETF | 9.6917 | 9.8017 | 9.6733 | 9.6733 | 31800.0 |
| 2001-06-28 | IJH | ETF | 10.205 | 10.315 | 10.205 | 10.246 | 2150000.0 |
| 2001-06-28 | IJJ | ETF | 22.385 | 22.675 | 22.385 | 22.5375 | 72800.0 |
| 2001-06-28 | IJK | ETF | 14.3375 | 14.5675 | 14.3375 | 14.3912 | 38400.0 |
| 2001-06-28 | IJR | ETF | 18.5667 | 18.7733 | 18.5667 | 18.75 | 651600.0 |
| 2001-06-28 | IJS | ETF | 20.6375 | 20.85 | 20.6375 | 20.7725 | 103600.0 |
| 2001-06-28 | IJT | ETF | 18.795 | 19.015 | 18.79 | 18.9375 | 30400.0 |
| 2001-06-28 | IOO | ETF | 31.17 | 31.395 | 31.17 | 31.33 | 10600.0 |
| 2001-06-28 | IUSG | ETF | 22.305 | 22.375 | 22.05 | 22.05 | 2200.0 |
| 2001-06-28 | IUSV | ETF | 25.0533 | 25.12 | 25.0533 | 25.12 | 6600.0 |
> showing 50 of 98 rows — these rows as CSV