PREVIEW / etf_daily / 2001-10-02
file: by_date/etf_daily/2001/2001-10-02.parquet size: 9 KB rows: 106
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-10-02 | SPY | ETF | 104.0 | 105.58 | 103.65 | 105.58 | 19833100.0 |
| 2001-10-02 | QQQ | ETF | 28.65 | 29.41 | 28.4 | 28.82 | 74183400.0 |
| 2001-10-02 | IWM | ETF | 39.5 | 40.185 | 39.5 | 40.185 | 1107200.0 |
| 2001-10-02 | DIA | ETF | 88.32 | 89.7 | 88.04 | 89.7 | 4845300.0 |
| 2001-10-02 | BBH | ETF | 37.6333 | 38.4333 | 37.5033 | 38.1833 | 4290000.0 |
| 2001-10-02 | BITS | ETF | 10.96 | 12.2 | 10.24 | 11.6 | 8325.0 |
| 2001-10-02 | CEF | ETF | 3.56 | 3.58 | 3.56 | 3.58 | 5700.0 |
| 2001-10-02 | CHB | ETF | 7.12 | 8.25 | 7.0 | 8.25 | 347400.0 |
| 2001-10-02 | CNXT | ETF | 7.45 | 7.88 | 7.26 | 7.33 | 4091190.0 |
| 2001-10-02 | CSB | ETF | 3.09999990463257 | 3.09999990463257 | 3.09999990463257 | 3.09999990463257 | 3000.0 |
| 2001-10-02 | DGT | ETF | 61.33 | 61.71 | 61.29 | 61.29 | 2600.0 |
| 2001-10-02 | EFA | ETF | 37.0 | 37.5167 | 37.0 | 37.5167 | 309900.0 |
| 2001-10-02 | EWA | ETF | 8.3 | 8.39 | 8.23 | 8.39 | 39000.0 |
| 2001-10-02 | EWC | ETF | 9.9 | 9.9 | 9.7 | 9.7 | 2900.0 |
| 2001-10-02 | EWD | ETF | 10.34 | 10.56 | 10.34 | 10.5 | 1700.0 |
| 2001-10-02 | EWG | ETF | 12.36 | 12.66 | 12.36 | 12.56 | 28000.0 |
| 2001-10-02 | EWH | ETF | 7.74 | 7.85 | 7.65 | 7.74 | 60000.0 |
| 2001-10-02 | EWI | ETF | 29.42 | 29.92 | 29.42 | 29.92 | 3400.0 |
| 2001-10-02 | EWJ | ETF | 33.76 | 34.2 | 33.72 | 34.2 | 96650.0 |
| 2001-10-02 | EWL | ETF | 11.9 | 11.99 | 11.8 | 11.99 | 7900.0 |
| 2001-10-02 | EWM | ETF | 17.6 | 17.6 | 17.6 | 17.6 | 125.0 |
| 2001-10-02 | EWN | ETF | 15.7 | 15.71 | 15.69 | 15.71 | 2200.0 |
| 2001-10-02 | EWP | ETF | 18.45 | 18.58 | 18.4 | 18.4 | 800.0 |
| 2001-10-02 | EWQ | ETF | 16.7 | 17.04 | 16.7 | 17.03 | 18200.0 |
| 2001-10-02 | EWS | ETF | 8.72 | 8.84 | 8.62 | 8.76 | 8950.0 |
| 2001-10-02 | EWT | ETF | 13.7 | 13.7 | 13.52 | 13.52 | 20600.0 |
| 2001-10-02 | EWU | ETF | 27.26 | 27.72 | 27.26 | 27.62 | 16700.0 |
| 2001-10-02 | EWW | ETF | 12.4 | 12.7 | 12.35 | 12.5 | 68800.0 |
| 2001-10-02 | EWY | ETF | 11.12 | 11.24 | 11.01 | 11.13 | 6100.0 |
| 2001-10-02 | EWZ | ETF | 9.0 | 9.0 | 9.0 | 9.0 | 1000.0 |
| 2001-10-02 | EZU | ETF | 24.025 | 24.925 | 24.025 | 24.7 | 13400.0 |
| 2001-10-02 | FCTR | ETF | 16.57 | 16.6 | 15.1 | 16.0 | 165200.0 |
| 2001-10-02 | FMAR | ETF | 7.3 | 7.65 | 7.27 | 7.65 | 1200.0 |
| 2001-10-02 | GLDB | ETF | 7.365 | 7.75 | 7.35 | 7.55 | 118100.0 |
| 2001-10-02 | GSIG | ETF | 6.62 | 6.92 | 6.51 | 6.78 | 147900.0 |
| 2001-10-02 | IBB | ETF | 24.8167 | 25.6 | 24.8167 | 25.6 | 120900.0 |
| 2001-10-02 | ICF | ETF | 20.6375 | 20.775 | 20.2625 | 20.415 | 102800.0 |
| 2001-10-02 | IDU | ETF | 33.215 | 33.725 | 33.215 | 33.725 | 5000.0 |
| 2001-10-02 | IEV | ETF | 26.15 | 27.075 | 26.15 | 27.075 | 29000.0 |
| 2001-10-02 | IGLD | ETF | 68.0 | 72.0 | 68.0 | 72.0 | 2.0 |
| 2001-10-02 | IGM | ETF | 6.2833 | 6.2967 | 6.1667 | 6.215 | 37200.0 |
| 2001-10-02 | IGN | ETF | 23.49 | 23.49 | 23.3 | 23.3 | 200.0 |
| 2001-10-02 | IGV | ETF | 6.07 | 6.07 | 6.07 | 6.07 | 3500.0 |
| 2001-10-02 | IJH | ETF | 8.5 | 8.569 | 8.485 | 8.569 | 565000.0 |
| 2001-10-02 | IJJ | ETF | 19.5625 | 19.8175 | 19.525 | 19.8175 | 115200.0 |
| 2001-10-02 | IJK | ETF | 11.4 | 11.545 | 11.4 | 11.5188 | 83200.0 |
| 2001-10-02 | IJR | ETF | 15.5617 | 15.8083 | 15.5617 | 15.7967 | 741600.0 |
| 2001-10-02 | IJS | ETF | 17.3875 | 17.5525 | 17.32 | 17.5525 | 43600.0 |
| 2001-10-02 | IJT | ETF | 15.835 | 16.0675 | 15.835 | 16.035 | 42800.0 |
| 2001-10-02 | IOO | ETF | 26.71 | 27.015 | 26.71 | 27.01 | 35600.0 |
> showing 50 of 106 rows — these rows as CSV