PREVIEW / etf_daily / 2001-10-16
file: by_date/etf_daily/2001/2001-10-16.parquet size: 9 KB rows: 108
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-16 | SPY | ETF | 109.8 | 110.61 | 108.95 | 109.99 | 15877100.0 |
| 2001-10-16 | QQQ | ETF | 34.669 | 35.1 | 34.07 | 34.96 | 81346800.0 |
| 2001-10-16 | IWM | ETF | 42.95 | 43.4 | 42.865 | 43.275 | 966400.0 |
| 2001-10-16 | DIA | ETF | 93.9 | 94.3 | 93.03 | 93.95 | 4445000.0 |
| 2001-10-16 | ARB | ETF | 28.0 | 28.2 | 27.55 | 27.8 | 44400.0 |
| 2001-10-16 | BBH | ETF | 41.2 | 41.6133 | 40.18 | 40.6833 | 3077100.0 |
| 2001-10-16 | BITS | ETF | 13.24 | 14.56 | 13.24 | 14.56 | 3650.0 |
| 2001-10-16 | CEF | ETF | 3.49 | 3.5 | 3.42 | 3.47 | 37300.0 |
| 2001-10-16 | CHB | ETF | 8.62 | 8.62 | 8.38 | 8.6 | 183600.0 |
| 2001-10-16 | CNXT | ETF | 10.17 | 10.38 | 9.841 | 10.28 | 2676440.0 |
| 2001-10-16 | DGT | ETF | 64.6 | 64.6 | 64.6 | 64.6 | 100.0 |
| 2001-10-16 | EFA | ETF | 38.7667 | 38.9333 | 38.6 | 38.9333 | 361800.0 |
| 2001-10-16 | EWA | ETF | 8.8 | 8.9 | 8.8 | 8.9 | 20200.0 |
| 2001-10-16 | EWC | ETF | 9.99 | 9.99 | 9.8 | 9.9 | 7500.0 |
| 2001-10-16 | EWD | ETF | 11.92 | 11.92 | 11.76 | 11.76 | 300.0 |
| 2001-10-16 | EWG | ETF | 13.41 | 13.49 | 13.36 | 13.41 | 12900.0 |
| 2001-10-16 | EWH | ETF | 7.95 | 8.07 | 7.95 | 8.0 | 28600.0 |
| 2001-10-16 | EWI | ETF | 31.1 | 31.48 | 31.1 | 31.3 | 7250.0 |
| 2001-10-16 | EWJ | ETF | 34.44 | 35.0 | 34.4 | 34.56 | 160825.0 |
| 2001-10-16 | EWK | ETF | 10.52 | 10.71 | 10.51 | 10.71 | 12700.0 |
| 2001-10-16 | EWL | ETF | 12.27 | 12.27 | 12.06 | 12.14 | 6000.0 |
| 2001-10-16 | EWM | ETF | 17.8 | 17.84 | 17.8 | 17.8 | 3875.0 |
| 2001-10-16 | EWN | ETF | 16.1 | 16.14 | 16.1 | 16.14 | 700.0 |
| 2001-10-16 | EWO | ETF | 7.16 | 7.25 | 7.16 | 7.25 | 13100.0 |
| 2001-10-16 | EWP | ETF | 19.25 | 19.39 | 19.15 | 19.39 | 5500.0 |
| 2001-10-16 | EWQ | ETF | 17.7 | 17.94 | 17.7 | 17.89 | 27200.0 |
| 2001-10-16 | EWS | ETF | 9.02 | 9.3 | 9.0 | 9.2 | 19750.0 |
| 2001-10-16 | EWT | ETF | 14.92 | 15.18 | 14.74 | 15.18 | 3100.0 |
| 2001-10-16 | EWU | ETF | 28.86 | 28.86 | 28.54 | 28.78 | 7700.0 |
| 2001-10-16 | EWW | ETF | 13.25 | 13.26 | 13.15 | 13.25 | 134700.0 |
| 2001-10-16 | EWY | ETF | 12.39 | 12.42 | 12.39 | 12.42 | 1100.0 |
| 2001-10-16 | EWZ | ETF | 9.37 | 9.56 | 9.37 | 9.55 | 115900.0 |
| 2001-10-16 | EZU | ETF | 25.71 | 26.21 | 25.71 | 26.035 | 6200.0 |
| 2001-10-16 | FCTR | ETF | 16.12 | 16.6 | 16.12 | 16.55 | 25200.0 |
| 2001-10-16 | FMAR | ETF | 7.95 | 8.22 | 7.95 | 8.05 | 63400.0 |
| 2001-10-16 | GLDB | ETF | 7.5 | 7.69 | 7.39 | 7.6 | 87100.0 |
| 2001-10-16 | GSIG | ETF | 7.1 | 7.35 | 7.1 | 7.3 | 82500.0 |
| 2001-10-16 | IBB | ETF | 28.5 | 28.7167 | 27.95 | 28.4467 | 846000.0 |
| 2001-10-16 | ICF | ETF | 20.4625 | 20.55 | 20.4625 | 20.55 | 34800.0 |
| 2001-10-16 | IDU | ETF | 34.675 | 34.875 | 34.625 | 34.875 | 2200.0 |
| 2001-10-16 | IEV | ETF | 27.975 | 28.25 | 27.975 | 28.125 | 32600.0 |
| 2001-10-16 | IGLD | ETF | 69.0 | 73.0 | 68.0 | 72.0 | 173.0 |
| 2001-10-16 | IGM | ETF | 7.525 | 7.5583 | 7.4083 | 7.5583 | 58200.0 |
| 2001-10-16 | IGN | ETF | 29.6 | 30.15 | 28.96 | 30.15 | 4600.0 |
| 2001-10-16 | IGV | ETF | 7.43 | 7.57 | 7.392 | 7.442 | 28000.0 |
| 2001-10-16 | IJH | ETF | 9.207 | 9.207 | 9.095 | 9.172 | 776000.0 |
| 2001-10-16 | IJJ | ETF | 20.6 | 20.8075 | 20.6 | 20.7325 | 40000.0 |
| 2001-10-16 | IJK | ETF | 12.5562 | 12.6488 | 12.4975 | 12.6075 | 65600.0 |
| 2001-10-16 | IJR | ETF | 16.9167 | 17.02 | 16.8833 | 17.02 | 277200.0 |
| 2001-10-16 | IJS | ETF | 18.6925 | 18.8125 | 18.625 | 18.7975 | 229600.0 |
> showing 50 of 108 rows — these rows as CSV