PREVIEW / etf_daily / 2001-11-02
file: by_date/etf_daily/2001/2001-11-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-11-02 | SPY | ETF | 108.44 | 109.38 | 107.87 | 109.25 | 17575900.0 |
| 2001-11-02 | QQQ | ETF | 35.271 | 35.85 | 34.89 | 35.6 | 64917700.0 |
| 2001-11-02 | IWM | ETF | 43.225 | 43.35 | 42.925 | 43.0 | 369600.0 |
| 2001-11-02 | DIA | ETF | 92.5 | 93.57 | 92.12 | 93.41 | 2647400.0 |
| 2001-11-02 | ARB | ETF | 27.85 | 28.65 | 27.7 | 28.43 | 51300.0 |
| 2001-11-02 | BBH | ETF | 42.6633 | 43.3333 | 42.4167 | 42.4333 | 3451500.0 |
| 2001-11-02 | BITS | ETF | 15.96 | 16.36 | 15.56 | 15.6056 | 3450.0 |
| 2001-11-02 | CEF | ETF | 3.4 | 3.4 | 3.35 | 3.36 | 8000.0 |
| 2001-11-02 | CHB | ETF | 9.0 | 9.1 | 8.92 | 8.98 | 58100.0 |
| 2001-11-02 | CNXT | ETF | 11.13 | 11.62 | 11.0 | 11.19 | 5066300.0 |
| 2001-11-02 | CSB | ETF | 3.84999990463257 | 3.84999990463257 | 3.84999990463257 | 3.84999990463257 | 1000.0 |
| 2001-11-02 | EFA | ETF | 38.9933 | 39.0933 | 38.78 | 39.0767 | 908700.0 |
| 2001-11-02 | ELV | ETF | 21.025 | 21.55 | 21.01 | 21.45 | 2037500.0 |
| 2001-11-02 | EWA | ETF | 8.8 | 8.9 | 8.8 | 8.89 | 8100.0 |
| 2001-11-02 | EWD | ETF | 11.7 | 11.8 | 11.6 | 11.8 | 500.0 |
| 2001-11-02 | EWG | ETF | 13.41 | 13.41 | 13.28 | 13.3 | 14200.0 |
| 2001-11-02 | EWH | ETF | 8.06 | 8.15 | 8.0 | 8.1 | 17800.0 |
| 2001-11-02 | EWI | ETF | 31.3 | 31.3 | 31.0 | 31.0 | 5250.0 |
| 2001-11-02 | EWJ | ETF | 33.64 | 33.96 | 33.6 | 33.88 | 24675.0 |
| 2001-11-02 | EWK | ETF | 10.47 | 10.47 | 10.47 | 10.47 | 200.0 |
| 2001-11-02 | EWL | ETF | 12.4 | 12.4 | 12.2 | 12.2 | 1300.0 |
| 2001-11-02 | EWM | ETF | 17.52 | 17.8 | 17.52 | 17.52 | 6725.0 |
| 2001-11-02 | EWN | ETF | 16.44 | 16.44 | 16.44 | 16.44 | 400.0 |
| 2001-11-02 | EWO | ETF | 6.77 | 6.84 | 6.77 | 6.84 | 2300.0 |
| 2001-11-02 | EWQ | ETF | 18.0 | 18.0 | 17.86 | 17.86 | 1200.0 |
| 2001-11-02 | EWS | ETF | 8.56 | 8.68 | 8.44 | 8.5 | 8900.0 |
| 2001-11-02 | EWT | ETF | 15.38 | 16.0 | 15.38 | 16.0 | 2800.0 |
| 2001-11-02 | EWU | ETF | 29.2 | 29.2 | 28.94 | 29.16 | 4300.0 |
| 2001-11-02 | EWW | ETF | 13.17 | 13.45 | 13.15 | 13.21 | 14700.0 |
| 2001-11-02 | EWY | ETF | 13.4 | 13.49 | 13.4 | 13.49 | 3300.0 |
| 2001-11-02 | EWZ | ETF | 9.35 | 9.67 | 9.35 | 9.66 | 1200.0 |
| 2001-11-02 | EZU | ETF | 26.45 | 26.45 | 25.875 | 26.01 | 12200.0 |
| 2001-11-02 | FCTR | ETF | 17.3 | 17.3 | 16.3 | 16.41 | 25400.0 |
| 2001-11-02 | FMAR | ETF | 7.9 | 8.05 | 7.9 | 7.9 | 62800.0 |
| 2001-11-02 | GLDB | ETF | 7.53 | 7.53 | 7.3 | 7.46 | 19600.0 |
| 2001-11-02 | GSIG | ETF | 7.26 | 7.7 | 7.26 | 7.7 | 30600.0 |
| 2001-11-02 | IBB | ETF | 28.9333 | 29.28 | 28.4167 | 28.4167 | 292500.0 |
| 2001-11-02 | ICF | ETF | 20.1875 | 20.1875 | 20.055 | 20.075 | 12400.0 |
| 2001-11-02 | IDU | ETF | 32.1 | 32.1 | 31.615 | 31.75 | 2600.0 |
| 2001-11-02 | IEV | ETF | 28.4 | 28.465 | 28.205 | 28.465 | 28000.0 |
| 2001-11-02 | IGLD | ETF | 73.0 | 77.0 | 73.0 | 73.0 | 66.0 |
| 2001-11-02 | IGM | ETF | 7.625 | 7.6833 | 7.55 | 7.6583 | 11401800.0 |
| 2001-11-02 | IGN | ETF | 29.1 | 29.1 | 29.1 | 29.1 | 1400.0 |
| 2001-11-02 | IGV | ETF | 7.53 | 7.67 | 7.53 | 7.67 | 12500.0 |
| 2001-11-02 | IJH | ETF | 9.155 | 9.236 | 9.12 | 9.221 | 148000.0 |
| 2001-11-02 | IJJ | ETF | 20.3075 | 20.53 | 20.3075 | 20.41 | 234800.0 |
| 2001-11-02 | IJK | ETF | 12.7125 | 12.9025 | 12.7125 | 12.865 | 1804000.0 |
| 2001-11-02 | IJR | ETF | 16.9833 | 17.1117 | 16.9817 | 16.9817 | 188400.0 |
| 2001-11-02 | IJS | ETF | 18.715 | 18.8725 | 18.715 | 18.8625 | 20400.0 |
| 2001-11-02 | IJT | ETF | 17.3375 | 17.465 | 17.2875 | 17.3725 | 67200.0 |
> showing 50 of 106 rows — these rows as CSV