PREVIEW / etf_daily / 2002-11-19
file: by_date/etf_daily/2002/2002-11-19.parquet size: 10 KB rows: 126
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 |
|---|---|---|---|---|---|---|---|
| 2002-11-19 | SPY | ETF | 90.02 | 91.1 | 89.76 | 90.36 | 32806600.0 |
| 2002-11-19 | QQQ | ETF | 25.8 | 26.05 | 25.3 | 25.65 | 88217900.0 |
| 2002-11-19 | IWM | ETF | 38.015 | 38.35 | 37.775 | 37.97 | 2249400.0 |
| 2002-11-19 | DIA | ETF | 84.45 | 85.59 | 84.15 | 85.06 | 6069700.0 |
| 2002-11-19 | TLT | ETF | 87.95 | 88.23 | 87.51 | 87.82 | 51800.0 |
| 2002-11-19 | AAA | ETF | 47.7 | 47.71 | 47.7 | 47.7 | 700.0 |
| 2002-11-19 | ADRE | ETF | 50.73 | 50.73 | 50.05 | 50.05 | 600.0 |
| 2002-11-19 | ARB | ETF | 32.9 | 33.23 | 31.97 | 32.24 | 58700.0 |
| 2002-11-19 | BBH | ETF | 29.1 | 29.42 | 28.67 | 28.8267 | 1857900.0 |
| 2002-11-19 | BITS | ETF | 7.48 | 7.6 | 7.4 | 7.4 | 762.0 |
| 2002-11-19 | CEF | ETF | 4.35 | 4.37 | 4.26 | 4.3 | 57000.0 |
| 2002-11-19 | CHB | ETF | 3.86 | 4.25 | 3.3 | 3.41 | 447500.0 |
| 2002-11-19 | CNXT | ETF | 1.87 | 1.92 | 1.74 | 1.81 | 3763500.0 |
| 2002-11-19 | CSB | ETF | 8.39999961853027 | 8.4399995803833 | 8.39999961853027 | 8.39999961853027 | 25700.0 |
| 2002-11-19 | EFA | ETF | 33.8933 | 33.9667 | 33.6167 | 33.6333 | 434100.0 |
| 2002-11-19 | ELV | ETF | 32.215 | 32.255 | 31.09 | 31.25 | 1043000.0 |
| 2002-11-19 | EPP | ETF | 17.4367 | 17.48 | 17.4333 | 17.4333 | 6600.0 |
| 2002-11-19 | EWA | ETF | 9.31 | 9.4 | 9.2 | 9.3 | 8000.0 |
| 2002-11-19 | EWC | ETF | 9.24 | 9.24 | 9.1 | 9.14 | 49600.0 |
| 2002-11-19 | EWD | ETF | 10.4 | 10.4 | 10.4 | 10.4 | 4700.0 |
| 2002-11-19 | EWG | ETF | 10.57 | 10.81 | 10.53 | 10.63 | 26100.0 |
| 2002-11-19 | EWH | ETF | 8.1 | 8.1 | 7.91 | 7.94 | 23400.0 |
| 2002-11-19 | EWJ | ETF | 26.64 | 26.76 | 26.52 | 26.56 | 96750.0 |
| 2002-11-19 | EWL | ETF | 11.36 | 11.53 | 11.26 | 11.26 | 5700.0 |
| 2002-11-19 | EWM | ETF | 20.72 | 20.76 | 20.52 | 20.52 | 41625.0 |
| 2002-11-19 | EWN | ETF | 13.89 | 13.89 | 13.76 | 13.8 | 12200.0 |
| 2002-11-19 | EWO | ETF | 8.1 | 8.13 | 8.1 | 8.12 | 4500.0 |
| 2002-11-19 | EWP | ETF | 18.01 | 18.2 | 18.01 | 18.15 | 20400.0 |
| 2002-11-19 | EWQ | ETF | 15.25 | 15.29 | 15.05 | 15.05 | 12600.0 |
| 2002-11-19 | EWS | ETF | 8.98 | 9.1 | 8.92 | 9.1 | 4750.0 |
| 2002-11-19 | EWT | ETF | 18.26 | 18.26 | 17.54 | 17.54 | 92850.0 |
| 2002-11-19 | EWU | ETF | 25.52 | 25.76 | 25.08 | 25.46 | 42800.0 |
| 2002-11-19 | EWW | ETF | 12.3 | 12.49 | 12.15 | 12.16 | 27700.0 |
| 2002-11-19 | EWY | ETF | 19.8 | 19.8 | 19.46 | 19.53 | 28600.0 |
| 2002-11-19 | EWZ | ETF | 7.31 | 7.47 | 7.31 | 7.44 | 48600.0 |
| 2002-11-19 | EZU | ETF | 22.225 | 22.425 | 22.175 | 22.25 | 167200.0 |
| 2002-11-19 | FCTR | ETF | 16.98 | 17.79 | 16.98 | 17.12 | 34755.0 |
| 2002-11-19 | FEZ | ETF | 25.68 | 25.88 | 25.52 | 25.53 | 39000.0 |
| 2002-11-19 | FMAR | ETF | 10.97 | 10.97 | 10.65 | 10.65 | 2900.0 |
| 2002-11-19 | GLDB | ETF | 9.85 | 9.85 | 9.58 | 9.58 | 78500.0 |
| 2002-11-19 | GRNB | ETF | 17.6698 | 17.6698 | 17.6698 | 17.6698 | 5349.0 |
| 2002-11-19 | GSIG | ETF | 6.0 | 6.0 | 5.77 | 5.9 | 177000.0 |
| 2002-11-19 | IBB | ETF | 17.4233 | 17.6767 | 17.3 | 17.3767 | 395100.0 |
| 2002-11-19 | ICF | ETF | 20.35 | 20.4125 | 20.25 | 20.32 | 340000.0 |
| 2002-11-19 | IDU | ETF | 22.8 | 22.865 | 22.595 | 22.705 | 163400.0 |
| 2002-11-19 | IEF | ETF | 85.62 | 85.67 | 85.32 | 85.4 | 11000.0 |
| 2002-11-19 | IEV | ETF | 24.65 | 24.845 | 24.45 | 24.64 | 290800.0 |
| 2002-11-19 | IGE | ETF | 13.1667 | 13.2083 | 13.1333 | 13.1333 | 3600.0 |
| 2002-11-19 | IGLD | ETF | 115.0 | 115.0 | 105.0 | 107.0 | 466.0 |
| 2002-11-19 | IGM | ETF | 5.2667 | 5.3117 | 5.2183 | 5.2433 | 114600.0 |
> showing 50 of 126 rows — these rows as CSV