PREVIEW / etf_daily / 2001-06-19
file: by_date/etf_daily/2001/2001-06-19.parquet size: 9 KB rows: 102
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-06-19 | SPY | ETF | 122.38 | 122.89 | 120.89 | 121.79 | 7732300.0 |
| 2001-06-19 | QQQ | ETF | 43.32 | 43.56 | 41.26 | 41.82 | 73386900.0 |
| 2001-06-19 | IWM | ETF | 49.5 | 49.55 | 48.59 | 48.85 | 763600.0 |
| 2001-06-19 | DIA | ETF | 107.25 | 107.56 | 105.65 | 106.18 | 4168800.0 |
| 2001-06-19 | BBH | ETF | 44.55 | 44.7533 | 43.35 | 43.5333 | 4170000.0 |
| 2001-06-19 | BITS | ETF | 12.72 | 13.96 | 12.2 | 13.0 | 7250.0 |
| 2001-06-19 | BOSS | ETF | 31.7 | 31.7 | 31.2 | 31.3 | 100.0 |
| 2001-06-19 | CEF | ETF | 3.29 | 3.29 | 3.29 | 3.29 | 4000.0 |
| 2001-06-19 | CHB | ETF | 9.4 | 9.7 | 9.37 | 9.57 | 567600.0 |
| 2001-06-19 | CNXT | ETF | 7.99 | 8.25 | 7.5 | 7.6 | 2540700.0 |
| 2001-06-19 | CSB | ETF | 2.0 | 2.0 | 2.0 | 2.0 | 6600.0 |
| 2001-06-19 | DGT | ETF | 70.15 | 70.15 | 70.15 | 70.15 | 100.0 |
| 2001-06-19 | EWA | ETF | 9.79 | 9.8 | 9.7 | 9.7 | 3300.0 |
| 2001-06-19 | EWC | ETF | 11.55 | 11.6 | 11.3 | 11.3 | 3600.0 |
| 2001-06-19 | EWD | ETF | 13.7 | 13.7 | 13.2 | 13.2 | 2100.0 |
| 2001-06-19 | EWG | ETF | 16.47 | 16.47 | 16.25 | 16.27 | 30400.0 |
| 2001-06-19 | EWH | ETF | 10.26 | 10.4 | 10.23 | 10.38 | 12700.0 |
| 2001-06-19 | EWI | ETF | 36.4 | 36.4 | 35.8 | 35.8 | 10350.0 |
| 2001-06-19 | EWJ | ETF | 40.6 | 40.88 | 40.28 | 40.28 | 62775.0 |
| 2001-06-19 | EWK | ETF | 11.15 | 11.15 | 11.06 | 11.1 | 700.0 |
| 2001-06-19 | EWL | ETF | 13.7 | 13.75 | 13.5 | 13.7 | 8200.0 |
| 2001-06-19 | EWM | ETF | 16.64 | 16.8 | 16.64 | 16.72 | 1400.0 |
| 2001-06-19 | EWN | ETF | 19.6 | 19.6 | 19.15 | 19.15 | 10700.0 |
| 2001-06-19 | EWO | ETF | 8.15 | 8.15 | 8.06 | 8.06 | 900.0 |
| 2001-06-19 | EWP | ETF | 22.05 | 22.05 | 21.8 | 21.8 | 9900.0 |
| 2001-06-19 | EWQ | ETF | 20.4 | 20.4 | 20.05 | 20.06 | 24200.0 |
| 2001-06-19 | EWS | ETF | 10.88 | 10.98 | 10.86 | 10.88 | 8500.0 |
| 2001-06-19 | EWT | ETF | 20.68 | 20.68 | 20.56 | 20.56 | 5700.0 |
| 2001-06-19 | EWU | ETF | 31.54 | 31.86 | 31.3 | 31.64 | 11050.0 |
| 2001-06-19 | EWW | ETF | 16.24 | 16.25 | 15.7 | 15.75 | 22100.0 |
| 2001-06-19 | EWY | ETF | 14.52 | 14.68 | 14.15 | 14.15 | 11700.0 |
| 2001-06-19 | EWZ | ETF | 13.75 | 13.75 | 13.47 | 13.47 | 7400.0 |
| 2001-06-19 | EZU | ETF | 30.775 | 30.775 | 29.985 | 29.985 | 62200.0 |
| 2001-06-19 | FCTR | ETF | 16.1 | 16.5 | 16.1 | 16.2 | 22800.0 |
| 2001-06-19 | FMAR | ETF | 6.9 | 6.9 | 6.9 | 6.9 | 100.0 |
| 2001-06-19 | GLDB | ETF | 7.07 | 7.1 | 6.97 | 7.05 | 14000.0 |
| 2001-06-19 | GRNB | ETF | 26.3869 | 26.3869 | 26.2593 | 26.3869 | 1110.0 |
| 2001-06-19 | GSIG | ETF | 9.08 | 9.3 | 9.07 | 9.17 | 128400.0 |
| 2001-06-19 | IBB | ETF | 33.3333 | 33.4467 | 32.2667 | 32.3167 | 102000.0 |
| 2001-06-19 | ICF | ETF | 20.95 | 20.9725 | 20.94 | 20.9725 | 20000.0 |
| 2001-06-19 | IDU | ETF | 39.725 | 39.725 | 39.1 | 39.215 | 2600.0 |
| 2001-06-19 | IEV | ETF | 31.925 | 31.925 | 31.16 | 31.62 | 32000.0 |
| 2001-06-19 | IGLD | ETF | 71.0 | 71.0 | 70.0 | 70.0 | 26.0 |
| 2001-06-19 | IGM | ETF | 9.3667 | 9.3667 | 9.2083 | 9.2333 | 28200.0 |
| 2001-06-19 | IJH | ETF | 10.17 | 10.195 | 10.049 | 10.072 | 157000.0 |
| 2001-06-19 | IJJ | ETF | 22.22 | 22.25 | 22.0025 | 22.0725 | 125600.0 |
| 2001-06-19 | IJK | ETF | 14.5312 | 14.5312 | 14.2612 | 14.2688 | 121600.0 |
| 2001-06-19 | IJR | ETF | 18.3833 | 18.4033 | 18.1283 | 18.1583 | 105600.0 |
| 2001-06-19 | IJS | ETF | 20.6375 | 20.6725 | 20.39 | 20.39 | 110000.0 |
| 2001-06-19 | IJT | ETF | 18.4125 | 18.4125 | 18.0925 | 18.17 | 76000.0 |
> showing 50 of 102 rows — these rows as CSV