PREVIEW / etf_daily / 2001-06-26
file: by_date/etf_daily/2001/2001-06-26.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-26 | SPY | ETF | 120.9 | 122.39 | 120.57 | 121.55 | 8005800.0 |
| 2001-06-26 | QQQ | ETF | 42.54 | 43.89 | 42.481 | 43.51 | 55155100.0 |
| 2001-06-26 | IWM | ETF | 48.0 | 49.05 | 47.925 | 49.0 | 1007600.0 |
| 2001-06-26 | DIA | ETF | 104.6 | 105.5 | 104.01 | 104.62 | 2550400.0 |
| 2001-06-26 | BBH | ETF | 42.7833 | 44.0667 | 42.7367 | 43.02 | 5533500.0 |
| 2001-06-26 | BITS | ETF | 12.48 | 13.04 | 12.28 | 12.88 | 2675.0 |
| 2001-06-26 | BOSS | ETF | 29.5 | 29.5 | 28.5 | 28.7 | 2000.0 |
| 2001-06-26 | CEF | ETF | 3.26 | 3.29 | 3.26 | 3.26 | 5800.0 |
| 2001-06-26 | CHB | ETF | 11.1 | 11.12 | 10.95 | 11.0 | 290400.0 |
| 2001-06-26 | CNXT | ETF | 7.425 | 7.645 | 7.175 | 7.645 | 1544540.0 |
| 2001-06-26 | CSB | ETF | 2.09999990463257 | 2.09999990463257 | 2.09999990463257 | 2.09999990463257 | 18200.0 |
| 2001-06-26 | DGT | ETF | 69.95 | 70.15 | 69.95 | 70.15 | 1200.0 |
| 2001-06-26 | EWA | ETF | 9.7 | 9.95 | 9.7 | 9.95 | 3700.0 |
| 2001-06-26 | EWC | ETF | 11.5 | 11.5 | 11.15 | 11.15 | 2200.0 |
| 2001-06-26 | EWD | ETF | 13.35 | 13.35 | 13.2 | 13.2 | 2200.0 |
| 2001-06-26 | EWG | ETF | 16.15 | 16.35 | 16.1 | 16.35 | 14100.0 |
| 2001-06-26 | EWH | ETF | 9.99 | 10.02 | 9.88 | 10.02 | 112200.0 |
| 2001-06-26 | EWI | ETF | 35.8 | 36.2 | 35.8 | 36.2 | 3250.0 |
| 2001-06-26 | EWJ | ETF | 40.64 | 41.0 | 40.64 | 40.84 | 41150.0 |
| 2001-06-26 | EWL | ETF | 13.23 | 13.49 | 13.23 | 13.49 | 3700.0 |
| 2001-06-26 | EWM | ETF | 16.72 | 16.72 | 16.68 | 16.68 | 75.0 |
| 2001-06-26 | EWN | ETF | 19.2 | 19.6 | 19.2 | 19.6 | 1800.0 |
| 2001-06-26 | EWO | ETF | 8.05 | 8.05 | 8.0 | 8.0 | 400.0 |
| 2001-06-26 | EWP | ETF | 21.5 | 21.56 | 21.4 | 21.56 | 6300.0 |
| 2001-06-26 | EWQ | ETF | 20.0 | 20.05 | 20.0 | 20.05 | 7400.0 |
| 2001-06-26 | EWS | ETF | 10.76 | 10.8 | 10.76 | 10.76 | 5500.0 |
| 2001-06-26 | EWT | ETF | 18.58 | 19.54 | 18.58 | 19.4 | 107950.0 |
| 2001-06-26 | EWU | ETF | 31.04 | 31.44 | 31.04 | 31.1 | 14000.0 |
| 2001-06-26 | EWW | ETF | 16.45 | 16.65 | 16.2 | 16.5 | 7400.0 |
| 2001-06-26 | EWY | ETF | 14.08 | 14.08 | 13.95 | 13.95 | 67900.0 |
| 2001-06-26 | EWZ | ETF | 14.29 | 14.51 | 14.29 | 14.5 | 900.0 |
| 2001-06-26 | EZU | ETF | 29.4 | 30.1 | 29.4 | 30.1 | 31800.0 |
| 2001-06-26 | FCTR | ETF | 16.65 | 16.9 | 16.5 | 16.86 | 53200.0 |
| 2001-06-26 | FMAR | ETF | 6.7 | 6.7 | 6.7 | 6.7 | 300.0 |
| 2001-06-26 | GLDB | ETF | 7.1 | 7.6 | 7.1 | 7.46 | 121500.0 |
| 2001-06-26 | GSIG | ETF | 8.6 | 8.97 | 8.58 | 8.77 | 29700.0 |
| 2001-06-26 | IBB | ETF | 31.6667 | 32.5333 | 31.6667 | 32.0667 | 259200.0 |
| 2001-06-26 | ICF | ETF | 21.0475 | 21.125 | 21.01 | 21.125 | 11600.0 |
| 2001-06-26 | IDU | ETF | 38.15 | 38.41 | 37.875 | 38.41 | 23400.0 |
| 2001-06-26 | IEV | ETF | 31.095 | 31.45 | 30.9 | 31.24 | 13400.0 |
| 2001-06-26 | IGLD | ETF | 69.0 | 70.0 | 62.0 | 66.0 | 111.0 |
| 2001-06-26 | IGM | ETF | 9.405 | 9.4083 | 9.405 | 9.4083 | 11400.0 |
| 2001-06-26 | IJH | ETF | 9.967 | 10.123 | 9.967 | 10.099 | 177000.0 |
| 2001-06-26 | IJJ | ETF | 22.005 | 22.2875 | 21.975 | 22.245 | 53200.0 |
| 2001-06-26 | IJK | ETF | 14.055 | 14.2688 | 14.0488 | 14.2475 | 34400.0 |
| 2001-06-26 | IJR | ETF | 17.945 | 18.29 | 17.9167 | 18.2333 | 976800.0 |
| 2001-06-26 | IJS | ETF | 20.025 | 20.3975 | 19.975 | 20.37 | 78000.0 |
| 2001-06-26 | IJT | ETF | 18.0875 | 18.4625 | 18.05 | 18.4625 | 34800.0 |
| 2001-06-26 | IOO | ETF | 31.1 | 31.405 | 31.1 | 31.35 | 9000.0 |
| 2001-06-26 | IUSG | ETF | 21.66 | 21.945 | 21.6 | 21.8 | 8600.0 |
> showing 50 of 98 rows — these rows as CSV