PREVIEW / etf_daily / 2001-07-18
file: by_date/etf_daily/2001/2001-07-18.parquet size: 9 KB rows: 101
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-07-18 | SPY | ETF | 120.56 | 121.64 | 120.06 | 121.01 | 7709300.0 |
| 2001-07-18 | QQQ | ETF | 42.279 | 42.85 | 41.14 | 41.65 | 64797200.0 |
| 2001-07-18 | IWM | ETF | 48.35 | 48.945 | 48.075 | 48.1 | 877800.0 |
| 2001-07-18 | DIA | ETF | 105.35 | 106.08 | 104.9 | 105.6 | 2256500.0 |
| 2001-07-18 | BBH | ETF | 38.0667 | 39.1833 | 37.9167 | 38.8333 | 4922700.0 |
| 2001-07-18 | BITS | ETF | 13.84 | 14.4 | 13.84 | 14.2 | 5450.0 |
| 2001-07-18 | CEF | ETF | 3.11 | 3.12 | 3.06 | 3.12 | 7300.0 |
| 2001-07-18 | CHB | ETF | 11.1 | 11.43 | 10.59 | 10.76 | 461100.0 |
| 2001-07-18 | CNXT | ETF | 8.29 | 8.6 | 7.89 | 8.09 | 1789340.0 |
| 2001-07-18 | CSB | ETF | 2.59999990463257 | 2.59999990463257 | 2.59999990463257 | 2.59999990463257 | 18000.0 |
| 2001-07-18 | DGT | ETF | 68.58 | 68.73 | 68.58 | 68.67 | 8000.0 |
| 2001-07-18 | EWA | ETF | 9.53 | 9.64 | 9.53 | 9.6 | 18600.0 |
| 2001-07-18 | EWC | ETF | 11.3 | 11.3 | 11.05 | 11.3 | 15800.0 |
| 2001-07-18 | EWD | ETF | 12.8 | 12.85 | 12.65 | 12.75 | 2600.0 |
| 2001-07-18 | EWG | ETF | 15.89 | 16.01 | 15.89 | 16.0 | 13300.0 |
| 2001-07-18 | EWH | ETF | 9.75 | 9.77 | 9.74 | 9.75 | 14800.0 |
| 2001-07-18 | EWI | ETF | 34.78 | 35.08 | 34.62 | 35.08 | 1200.0 |
| 2001-07-18 | EWJ | ETF | 37.92 | 38.04 | 37.72 | 37.84 | 48850.0 |
| 2001-07-18 | EWK | ETF | 11.55 | 11.55 | 11.55 | 11.55 | 500.0 |
| 2001-07-18 | EWL | ETF | 13.1 | 13.25 | 13.01 | 13.25 | 7100.0 |
| 2001-07-18 | EWM | ETF | 18.6 | 18.96 | 18.4 | 18.4 | 18250.0 |
| 2001-07-18 | EWN | ETF | 18.45 | 18.65 | 18.45 | 18.65 | 2100.0 |
| 2001-07-18 | EWO | ETF | 8.0 | 8.0 | 8.0 | 8.0 | 1600.0 |
| 2001-07-18 | EWP | ETF | 20.15 | 20.24 | 20.1 | 20.1 | 6000.0 |
| 2001-07-18 | EWQ | ETF | 19.18 | 19.29 | 19.16 | 19.16 | 10700.0 |
| 2001-07-18 | EWS | ETF | 10.0 | 10.0 | 9.72 | 9.74 | 25000.0 |
| 2001-07-18 | EWT | ETF | 17.1 | 17.44 | 17.0 | 17.0 | 30250.0 |
| 2001-07-18 | EWU | ETF | 30.06 | 30.3 | 29.72 | 30.3 | 18150.0 |
| 2001-07-18 | EWW | ETF | 15.55 | 15.6 | 15.25 | 15.26 | 15100.0 |
| 2001-07-18 | EWY | ETF | 12.51 | 12.72 | 12.51 | 12.72 | 2000.0 |
| 2001-07-18 | EWZ | ETF | 12.97 | 12.97 | 12.69 | 12.7 | 3000.0 |
| 2001-07-18 | EZU | ETF | 28.565 | 28.925 | 28.525 | 28.7 | 13800.0 |
| 2001-07-18 | FCTR | ETF | 17.49 | 17.86 | 17.05 | 17.82 | 94900.0 |
| 2001-07-18 | FMAR | ETF | 8.5 | 8.69 | 8.05 | 8.45 | 43800.0 |
| 2001-07-18 | GLDB | ETF | 7.76 | 7.78 | 7.46 | 7.67 | 14700.0 |
| 2001-07-18 | GSIG | ETF | 7.89 | 8.0 | 7.8 | 7.9 | 100800.0 |
| 2001-07-18 | IBB | ETF | 28.7 | 29.3833 | 28.7 | 29.1667 | 966000.0 |
| 2001-07-18 | ICF | ETF | 21.1425 | 21.18 | 21.1425 | 21.175 | 12800.0 |
| 2001-07-18 | IDU | ETF | 39.045 | 39.1 | 38.955 | 39.1 | 600.0 |
| 2001-07-18 | IEV | ETF | 29.995 | 30.325 | 29.875 | 30.32 | 35800.0 |
| 2001-07-18 | IGLD | ETF | 68.0 | 68.0 | 68.0 | 68.0 | 22.0 |
| 2001-07-18 | IGM | ETF | 9.15 | 9.175 | 8.8667 | 8.8667 | 756000.0 |
| 2001-07-18 | IGV | ETF | 9.746 | 9.746 | 9.686 | 9.686 | 1000.0 |
| 2001-07-18 | IJH | ETF | 10.13 | 10.174 | 10.09 | 10.107 | 131000.0 |
| 2001-07-18 | IJJ | ETF | 22.625 | 22.67 | 22.525 | 22.5625 | 79600.0 |
| 2001-07-18 | IJK | ETF | 14.0375 | 14.1188 | 14.0275 | 14.06 | 52000.0 |
| 2001-07-18 | IJR | ETF | 18.6333 | 18.7867 | 18.585 | 18.625 | 369600.0 |
| 2001-07-18 | IJS | ETF | 20.9125 | 20.9725 | 20.815 | 20.815 | 107200.0 |
| 2001-07-18 | IJT | ETF | 18.725 | 18.8325 | 18.67 | 18.735 | 42800.0 |
| 2001-07-18 | IOO | ETF | 30.33 | 30.35 | 30.25 | 30.25 | 17000.0 |
> showing 50 of 101 rows — these rows as CSV