PREVIEW / etf_daily / 2001-10-09
file: by_date/etf_daily/2001/2001-10-09.parquet size: 9 KB rows: 105
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-09 | SPY | ETF | 106.61 | 106.75 | 105.6 | 105.96 | 15976300.0 |
| 2001-10-09 | QQQ | ETF | 31.86 | 32.02 | 30.87 | 31.09 | 57565800.0 |
| 2001-10-09 | IWM | ETF | 40.825 | 40.975 | 40.5 | 40.585 | 1017200.0 |
| 2001-10-09 | DIA | ETF | 90.99 | 91.1 | 90.15 | 90.63 | 2580500.0 |
| 2001-10-09 | BBH | ETF | 37.3333 | 37.8333 | 36.9567 | 37.3333 | 3580200.0 |
| 2001-10-09 | BITS | ETF | 14.4 | 14.6 | 14.0 | 14.2 | 5025.0 |
| 2001-10-09 | CEF | ETF | 3.6 | 3.6 | 3.48 | 3.48 | 4700.0 |
| 2001-10-09 | CHB | ETF | 8.05 | 8.3 | 8.05 | 8.25 | 91900.0 |
| 2001-10-09 | CNXT | ETF | 8.59 | 8.92 | 8.35 | 8.41 | 4163000.0 |
| 2001-10-09 | CSB | ETF | 3.40000009536743 | 3.70000004768372 | 3.40000009536743 | 3.70000004768372 | 4000.0 |
| 2001-10-09 | DGT | ETF | 63.14 | 63.14 | 62.95 | 62.95 | 1400.0 |
| 2001-10-09 | EFA | ETF | 38.3167 | 38.45 | 37.9833 | 38.0333 | 2442600.0 |
| 2001-10-09 | EWA | ETF | 8.45 | 8.54 | 8.36 | 8.54 | 13000.0 |
| 2001-10-09 | EWC | ETF | 9.9 | 10.0 | 9.76 | 9.76 | 3100.0 |
| 2001-10-09 | EWD | ETF | 11.5 | 11.5 | 11.06 | 11.06 | 2700.0 |
| 2001-10-09 | EWG | ETF | 13.1 | 13.24 | 13.0 | 13.03 | 49700.0 |
| 2001-10-09 | EWH | ETF | 8.25 | 8.25 | 8.01 | 8.01 | 20100.0 |
| 2001-10-09 | EWI | ETF | 30.98 | 31.0 | 30.6 | 30.98 | 23050.0 |
| 2001-10-09 | EWJ | ETF | 33.6 | 33.6 | 33.24 | 33.48 | 48925.0 |
| 2001-10-09 | EWK | ETF | 11.05 | 11.05 | 10.85 | 11.04 | 900.0 |
| 2001-10-09 | EWL | ETF | 12.05 | 12.05 | 12.04 | 12.04 | 400.0 |
| 2001-10-09 | EWM | ETF | 17.52 | 17.56 | 17.32 | 17.32 | 144000.0 |
| 2001-10-09 | EWN | ETF | 16.31 | 16.31 | 16.29 | 16.29 | 600.0 |
| 2001-10-09 | EWP | ETF | 18.3 | 18.44 | 18.3 | 18.39 | 21700.0 |
| 2001-10-09 | EWQ | ETF | 17.49 | 17.51 | 17.36 | 17.36 | 13000.0 |
| 2001-10-09 | EWS | ETF | 8.94 | 8.94 | 8.62 | 8.76 | 19600.0 |
| 2001-10-09 | EWT | ETF | 14.1 | 14.16 | 13.82 | 13.82 | 4050.0 |
| 2001-10-09 | EWU | ETF | 29.1 | 29.1 | 28.26 | 28.7 | 5400.0 |
| 2001-10-09 | EWW | ETF | 12.9 | 13.09 | 12.9 | 12.95 | 6400.0 |
| 2001-10-09 | EWY | ETF | 11.7 | 11.79 | 11.61 | 11.61 | 43400.0 |
| 2001-10-09 | EWZ | ETF | 8.85 | 8.86 | 8.64 | 8.86 | 2500.0 |
| 2001-10-09 | EZU | ETF | 25.695 | 25.695 | 25.215 | 25.34 | 23600.0 |
| 2001-10-09 | FCTR | ETF | 16.25 | 16.26 | 15.75 | 15.85 | 29800.0 |
| 2001-10-09 | FMAR | ETF | 7.45 | 7.85 | 7.45 | 7.5 | 23600.0 |
| 2001-10-09 | GLDB | ETF | 7.31 | 7.64 | 7.31 | 7.46 | 112400.0 |
| 2001-10-09 | GSIG | ETF | 6.94 | 7.35 | 6.8 | 7.19 | 79500.0 |
| 2001-10-09 | IBB | ETF | 25.3333 | 25.6167 | 25.1333 | 25.3967 | 68100.0 |
| 2001-10-09 | ICF | ETF | 20.285 | 20.3125 | 20.255 | 20.3075 | 10400.0 |
| 2001-10-09 | IDU | ETF | 34.925 | 34.925 | 34.22 | 34.355 | 3800.0 |
| 2001-10-09 | IEV | ETF | 27.8 | 27.87 | 27.365 | 27.595 | 44400.0 |
| 2001-10-09 | IGLD | ETF | 74.8 | 75.0 | 70.0 | 73.0 | 158.0 |
| 2001-10-09 | IGM | ETF | 6.9583 | 6.9583 | 6.8083 | 6.825 | 15000.0 |
| 2001-10-09 | IGN | ETF | 26.5 | 26.5 | 25.56 | 25.6 | 5400.0 |
| 2001-10-09 | IGV | ETF | 6.76 | 6.83 | 6.76 | 6.82 | 7000.0 |
| 2001-10-09 | IJH | ETF | 8.73 | 8.768 | 8.689 | 8.749 | 695000.0 |
| 2001-10-09 | IJJ | ETF | 19.795 | 19.965 | 19.765 | 19.955 | 148400.0 |
| 2001-10-09 | IJK | ETF | 11.8462 | 11.9175 | 11.8462 | 11.8588 | 28000.0 |
| 2001-10-09 | IJR | ETF | 16.2 | 16.2083 | 16.0383 | 16.0917 | 808200.0 |
| 2001-10-09 | IJS | ETF | 17.9025 | 17.9025 | 17.715 | 17.75 | 45600.0 |
| 2001-10-09 | IJT | ETF | 16.3725 | 16.45 | 16.3375 | 16.385 | 8000.0 |
> showing 50 of 105 rows — these rows as CSV