PREVIEW / etf_daily / 2001-08-06
file: by_date/etf_daily/2001/2001-08-06.parquet size: 8 KB rows: 97
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-08-06 | SPY | ETF | 121.35 | 121.51 | 120.1 | 120.3 | 8550100.0 |
| 2001-08-06 | QQQ | ETF | 42.539 | 42.85 | 42.35 | 42.5 | 31105700.0 |
| 2001-08-06 | IWM | ETF | 48.5 | 48.5 | 47.8 | 47.9 | 236800.0 |
| 2001-08-06 | DIA | ETF | 105.0 | 105.08 | 103.85 | 103.94 | 1552700.0 |
| 2001-08-06 | BBH | ETF | 39.8167 | 40.2167 | 39.5067 | 39.65 | 1389000.0 |
| 2001-08-06 | BITS | ETF | 15.28 | 15.48 | 14.8 | 14.8 | 1200.0 |
| 2001-08-06 | CEF | ETF | 3.1 | 3.13 | 3.1 | 3.11 | 15500.0 |
| 2001-08-06 | CHB | ETF | 11.47 | 11.47 | 10.55 | 10.55 | 136100.0 |
| 2001-08-06 | CNXT | ETF | 9.49 | 10.31 | 9.45 | 9.97 | 2927210.0 |
| 2001-08-06 | EWA | ETF | 9.65 | 9.66 | 9.57 | 9.61 | 2400.0 |
| 2001-08-06 | EWC | ETF | 11.3 | 11.54 | 11.3 | 11.54 | 9300.0 |
| 2001-08-06 | EWD | ETF | 13.85 | 13.93 | 13.72 | 13.93 | 1100.0 |
| 2001-08-06 | EWG | ETF | 16.22 | 16.39 | 16.21 | 16.26 | 40100.0 |
| 2001-08-06 | EWH | ETF | 9.45 | 9.54 | 9.45 | 9.46 | 24200.0 |
| 2001-08-06 | EWJ | ETF | 38.52 | 38.52 | 38.24 | 38.36 | 43225.0 |
| 2001-08-06 | EWK | ETF | 11.79 | 11.8 | 11.79 | 11.8 | 200.0 |
| 2001-08-06 | EWL | ETF | 13.1 | 13.39 | 13.1 | 13.39 | 5300.0 |
| 2001-08-06 | EWM | ETF | 18.88 | 18.88 | 18.8 | 18.88 | 2900.0 |
| 2001-08-06 | EWN | ETF | 19.1 | 19.1 | 19.1 | 19.1 | 600.0 |
| 2001-08-06 | EWP | ETF | 21.4 | 21.51 | 21.4 | 21.51 | 1000.0 |
| 2001-08-06 | EWQ | ETF | 20.0 | 20.24 | 20.0 | 20.11 | 2800.0 |
| 2001-08-06 | EWS | ETF | 10.64 | 10.7 | 10.58 | 10.58 | 61900.0 |
| 2001-08-06 | EWT | ETF | 18.38 | 18.38 | 18.02 | 18.08 | 13450.0 |
| 2001-08-06 | EWU | ETF | 30.86 | 31.02 | 30.82 | 31.02 | 5500.0 |
| 2001-08-06 | EWW | ETF | 16.3 | 16.45 | 16.1 | 16.1 | 14900.0 |
| 2001-08-06 | EWY | ETF | 13.86 | 13.88 | 13.67 | 13.71 | 9500.0 |
| 2001-08-06 | EWZ | ETF | 13.06 | 13.26 | 12.98 | 13.26 | 3200.0 |
| 2001-08-06 | EZU | ETF | 29.995 | 30.0 | 29.855 | 30.0 | 4000.0 |
| 2001-08-06 | FCTR | ETF | 17.78 | 18.25 | 17.78 | 18.01 | 26900.0 |
| 2001-08-06 | FMAR | ETF | 10.2 | 10.2 | 9.52 | 9.8 | 6200.0 |
| 2001-08-06 | GLDB | ETF | 7.8 | 7.95 | 7.7 | 7.77 | 69200.0 |
| 2001-08-06 | GSIG | ETF | 8.47 | 8.58 | 8.35 | 8.56 | 36000.0 |
| 2001-08-06 | IBB | ETF | 28.7 | 28.85 | 28.5833 | 28.65 | 47400.0 |
| 2001-08-06 | ICF | ETF | 21.2075 | 21.315 | 21.2075 | 21.315 | 10400.0 |
| 2001-08-06 | IDU | ETF | 37.525 | 37.525 | 37.2 | 37.2 | 6200.0 |
| 2001-08-06 | IEV | ETF | 30.975 | 31.295 | 30.905 | 31.295 | 17800.0 |
| 2001-08-06 | IGLD | ETF | 63.0 | 66.0 | 58.0 | 66.0 | 25.0 |
| 2001-08-06 | IGV | ETF | 9.7 | 9.71 | 9.68 | 9.68 | 5500.0 |
| 2001-08-06 | IJH | ETF | 10.212 | 10.22 | 10.1 | 10.1 | 54000.0 |
| 2001-08-06 | IJJ | ETF | 22.905 | 22.9425 | 22.695 | 22.7225 | 126800.0 |
| 2001-08-06 | IJK | ETF | 14.1025 | 14.1025 | 13.9438 | 13.955 | 93600.0 |
| 2001-08-06 | IJR | ETF | 18.895 | 18.895 | 18.6333 | 18.6583 | 553800.0 |
| 2001-08-06 | IJS | ETF | 21.25 | 21.26 | 21.025 | 21.025 | 97200.0 |
| 2001-08-06 | IJT | ETF | 18.775 | 18.8275 | 18.5875 | 18.6325 | 37600.0 |
| 2001-08-06 | IOO | ETF | 30.62 | 30.62 | 30.38 | 30.39 | 77200.0 |
| 2001-08-06 | IUSG | ETF | 21.5 | 21.5 | 21.275 | 21.35 | 65000.0 |
| 2001-08-06 | IUSV | ETF | 24.88 | 24.88 | 24.7733 | 24.7733 | 28500.0 |
| 2001-08-06 | IVE | ETF | 60.8 | 60.87 | 60.09 | 60.1 | 21700.0 |
| 2001-08-06 | IVV | ETF | 121.47 | 121.47 | 120.1 | 120.34 | 57900.0 |
| 2001-08-06 | IVW | ETF | 15.15 | 15.15 | 14.99 | 15.0075 | 26800.0 |
> showing 50 of 97 rows — these rows as CSV