PREVIEW / etf_daily / 2001-11-08
file: by_date/etf_daily/2001/2001-11-08.parquet size: 9 KB rows: 111
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-08 | SPY | ETF | 112.87 | 114.08 | 111.9 | 112.6 | 22563500.0 |
| 2001-11-08 | QQQ | ETF | 38.551 | 39.4 | 37.25 | 37.75 | 105916300.0 |
| 2001-11-08 | IWM | ETF | 44.175 | 44.45 | 43.475 | 43.85 | 483200.0 |
| 2001-11-08 | DIA | ETF | 96.3 | 97.4 | 95.66 | 96.23 | 3953300.0 |
| 2001-11-08 | ARB | ETF | 28.3 | 28.7 | 28.25 | 28.25 | 41900.0 |
| 2001-11-08 | BBH | ETF | 44.6467 | 44.8167 | 42.8333 | 42.9333 | 5017500.0 |
| 2001-11-08 | BITS | ETF | 16.4 | 16.96 | 16.198 | 16.8 | 4050.0 |
| 2001-11-08 | CEF | ETF | 3.36 | 3.36 | 3.31 | 3.31 | 8000.0 |
| 2001-11-08 | CHB | ETF | 10.0 | 10.23 | 9.9 | 10.0 | 201200.0 |
| 2001-11-08 | CNXT | ETF | 13.54 | 14.6 | 13.11 | 13.15 | 9135290.0 |
| 2001-11-08 | DGT | ETF | 67.27 | 67.4 | 67.03 | 67.03 | 2400.0 |
| 2001-11-08 | EFA | ETF | 39.7667 | 40.1567 | 39.7667 | 39.8 | 989400.0 |
| 2001-11-08 | ELV | ETF | 21.5 | 21.55 | 21.0 | 21.35 | 1702000.0 |
| 2001-11-08 | EWA | ETF | 9.01 | 9.1 | 9.01 | 9.04 | 18800.0 |
| 2001-11-08 | EWC | ETF | 10.1 | 10.35 | 10.1 | 10.1 | 42800.0 |
| 2001-11-08 | EWD | ETF | 12.65 | 12.79 | 12.55 | 12.66 | 9700.0 |
| 2001-11-08 | EWG | ETF | 14.16 | 14.23 | 14.0 | 14.05 | 41500.0 |
| 2001-11-08 | EWH | ETF | 8.29 | 8.4 | 8.22 | 8.25 | 24200.0 |
| 2001-11-08 | EWI | ETF | 31.78 | 31.98 | 31.78 | 31.8 | 5450.0 |
| 2001-11-08 | EWJ | ETF | 34.12 | 34.32 | 33.8 | 33.88 | 93975.0 |
| 2001-11-08 | EWK | ETF | 10.84 | 10.84 | 10.84 | 10.84 | 300.0 |
| 2001-11-08 | EWL | ETF | 12.56 | 12.75 | 12.55 | 12.55 | 16200.0 |
| 2001-11-08 | EWM | ETF | 17.4 | 17.72 | 17.24 | 17.4 | 105750.0 |
| 2001-11-08 | EWN | ETF | 17.15 | 17.24 | 16.95 | 16.95 | 16000.0 |
| 2001-11-08 | EWO | ETF | 6.98 | 6.98 | 6.91 | 6.91 | 1100.0 |
| 2001-11-08 | EWP | ETF | 20.65 | 20.69 | 20.47 | 20.69 | 9100.0 |
| 2001-11-08 | EWQ | ETF | 18.43 | 18.49 | 18.3 | 18.3 | 17700.0 |
| 2001-11-08 | EWS | ETF | 8.52 | 8.62 | 8.38 | 8.4 | 51000.0 |
| 2001-11-08 | EWT | ETF | 16.6 | 16.78 | 16.42 | 16.52 | 34000.0 |
| 2001-11-08 | EWU | ETF | 29.74 | 30.08 | 29.64 | 29.66 | 17250.0 |
| 2001-11-08 | EWW | ETF | 13.41 | 13.74 | 13.41 | 13.59 | 149500.0 |
| 2001-11-08 | EWY | ETF | 13.9 | 14.17 | 13.9 | 14.05 | 53700.0 |
| 2001-11-08 | EWZ | ETF | 11.19 | 11.35 | 11.0 | 11.0 | 19000.0 |
| 2001-11-08 | EZU | ETF | 27.1 | 27.4 | 26.955 | 27.005 | 54800.0 |
| 2001-11-08 | FCTR | ETF | 17.28 | 17.65 | 16.34 | 16.8 | 64000.0 |
| 2001-11-08 | FMAR | ETF | 8.1 | 8.4 | 8.1 | 8.2 | 7200.0 |
| 2001-11-08 | GLDB | ETF | 7.55 | 7.6 | 7.41 | 7.6 | 37400.0 |
| 2001-11-08 | GSIG | ETF | 8.76 | 8.83 | 8.55 | 8.65 | 98100.0 |
| 2001-11-08 | IBB | ETF | 30.1167 | 30.13 | 29.1133 | 29.1633 | 1012500.0 |
| 2001-11-08 | ICF | ETF | 20.3425 | 20.425 | 20.325 | 20.42 | 7600.0 |
| 2001-11-08 | IDU | ETF | 32.5 | 32.845 | 32.5 | 32.805 | 24200.0 |
| 2001-11-08 | IEV | ETF | 29.5 | 29.535 | 29.205 | 29.205 | 196400.0 |
| 2001-11-08 | IGLD | ETF | 100.0 | 100.0 | 89.0 | 93.0 | 1537.0 |
| 2001-11-08 | IGM | ETF | 8.2917 | 8.4233 | 8.1167 | 8.15 | 6438000.0 |
| 2001-11-08 | IGN | ETF | 31.8 | 32.1 | 30.65 | 30.65 | 2300.0 |
| 2001-11-08 | IGV | ETF | 8.444 | 8.5 | 8.05 | 8.05 | 26000.0 |
| 2001-11-08 | IJH | ETF | 9.475 | 9.537 | 9.356 | 9.383 | 152000.0 |
| 2001-11-08 | IJJ | ETF | 20.9875 | 21.1125 | 20.855 | 20.855 | 90000.0 |
| 2001-11-08 | IJK | ETF | 13.2938 | 13.3812 | 13.0738 | 13.15 | 176000.0 |
| 2001-11-08 | IJR | ETF | 17.3633 | 17.4833 | 17.17 | 17.1917 | 260400.0 |
> showing 50 of 111 rows — these rows as CSV