PREVIEW / etf_daily / 2015-06-18
file: by_date/etf_daily/2015/2015-06-18.parquet size: 48 KB rows: 1,186
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 |
|---|---|---|---|---|---|---|---|
| 2015-06-18 | SPY | ETF | 211.31 | 213.34 | 210.63 | 212.78 | 165867900.0 |
| 2015-06-18 | QQQ | ETF | 109.5 | 110.88 | 109.44 | 110.69 | 43032384.0 |
| 2015-06-18 | IWM | ETF | 126.82 | 128.24 | 126.74 | 127.92 | 39642100.0 |
| 2015-06-18 | DIA | ETF | 180.21 | 181.94 | 180.14 | 181.33 | 6542800.0 |
| 2015-06-18 | GLD | ETF | 115.19 | 115.61 | 114.89 | 115.32 | 8041300.0 |
| 2015-06-18 | TLT | ETF | 117.37 | 117.74 | 116.75 | 117.57 | 10123300.0 |
| 2015-06-18 | AAXJ | ETF | 64.28 | 64.62 | 64.04 | 64.46 | 789700.0 |
| 2015-06-18 | ACTX | ETF | 3.54 | 4.13 | 2.655 | 2.95 | 1066.0 |
| 2015-06-18 | ACWF | ETF | 25.1099 | 25.17 | 25.05 | 25.17 | 515.0 |
| 2015-06-18 | ACWI | ETF | 61.26 | 62.06 | 61.25 | 61.79 | 1182600.0 |
| 2015-06-18 | ACWV | ETF | 71.42 | 72.02 | 71.42 | 71.79 | 35900.0 |
| 2015-06-18 | ACWX | ETF | 45.65 | 46.17 | 45.65 | 45.88 | 108657.0 |
| 2015-06-18 | ADRE | ETF | 35.7 | 35.94 | 35.619 | 35.835 | 7340.0 |
| 2015-06-18 | AFK | ETF | 24.87 | 25.0276 | 24.805 | 24.846 | 5838.0 |
| 2015-06-18 | AFTY | ETF | 21.87 | 21.89 | 21.61 | 21.84 | 42500.0 |
| 2015-06-18 | AGG | ETF | 108.81 | 108.87 | 108.62 | 108.87 | 2917400.0 |
| 2015-06-18 | AGQ | ETF | 39.87 | 39.94 | 38.6 | 38.8 | 289800.0 |
| 2015-06-18 | AGZ | ETF | 112.81 | 113.3 | 112.73 | 113.2999 | 536477.0 |
| 2015-06-18 | AGZD | ETF | 24.415 | 24.455 | 24.315 | 24.385 | 15600.0 |
| 2015-06-18 | AIA | ETF | 51.08 | 51.31 | 51.06 | 51.28 | 34236.0 |
| 2015-06-18 | AIQ | ETF | 19.57 | 20.352 | 19.57 | 20.25 | 17293.0 |
| 2015-06-18 | AIRR | ETF | 18.652 | 18.699 | 18.64 | 18.67 | 10500.0 |
| 2015-06-18 | AIVI | ETF | 44.58 | 45.14 | 44.58 | 44.99 | 17500.0 |
| 2015-06-18 | AMJ | ETF | 42.02 | 42.27 | 41.9 | 42.03 | 732375.0 |
| 2015-06-18 | AMLP | ETF | 81.15 | 81.4 | 81.0 | 81.15 | 675320.0 |
| 2015-06-18 | AMZA | ETF | 211.0 | 215.8 | 207.4 | 208.46 | 2110.0 |
| 2015-06-18 | ANGL | ETF | 27.3 | 27.3 | 27.25 | 27.3 | 6900.0 |
| 2015-06-18 | AOA | ETF | 48.17 | 48.4 | 48.07 | 48.28 | 69200.0 |
| 2015-06-18 | AOK | ETF | 32.74 | 32.74 | 32.6 | 32.72 | 36237.0 |
| 2015-06-18 | AOM | ETF | 35.53 | 35.628 | 35.51 | 35.6 | 28022.0 |
| 2015-06-18 | AOR | ETF | 41.07 | 41.21 | 41.01 | 41.17 | 121721.0 |
| 2015-06-18 | ARGT | ETF | 20.35 | 20.45 | 20.31 | 20.38 | 34600.0 |
| 2015-06-18 | ARKG | ETF | 23.77 | 23.818 | 23.73 | 23.75 | 2900.0 |
| 2015-06-18 | ARKK | ETF | 22.05 | 22.05 | 22.05 | 22.05 | 200.0 |
| 2015-06-18 | ARKQ | ETF | 20.37 | 20.415 | 20.37 | 20.415 | 2200.0 |
| 2015-06-18 | ARKW | ETF | 23.6 | 23.886 | 23.6 | 23.886 | 900.0 |
| 2015-06-18 | ASEA | ETF | 15.29 | 15.36 | 15.29 | 15.33 | 3600.0 |
| 2015-06-18 | ASHR | ETF | 50.76 | 51.26 | 50.6 | 51.1 | 2419600.0 |
| 2015-06-18 | ASHS | ETF | 70.01 | 70.48 | 70.01 | 70.38 | 261500.0 |
| 2015-06-18 | ATMP | ETF | 28.54 | 28.6 | 28.46 | 28.54 | 64300.0 |
| 2015-06-18 | AWAY | ETF | 31.43 | 31.8 | 31.325 | 31.69 | 607531.0 |
| 2015-06-18 | BAB | ETF | 28.85 | 28.87 | 28.77 | 28.85 | 36035.0 |
| 2015-06-18 | BAL | ETF | 43.37 | 43.5 | 43.29 | 43.29 | 2198.0 |
| 2015-06-18 | BALT | ETF | 1.52 | 1.58 | 1.5 | 1.56 | 233027.0 |
| 2015-06-18 | BAR | ETF | 2.672 | 2.71 | 2.66 | 2.71 | 15140.0 |
| 2015-06-18 | BBC | ETF | 35.98 | 36.79 | 35.98 | 36.26 | 51664.0 |
| 2015-06-18 | BBH | ETF | 135.39 | 139.19 | 135.02 | 138.65 | 157700.0 |
| 2015-06-18 | BBP | ETF | 34.44 | 35.61 | 34.44 | 35.5 | 56800.0 |
| 2015-06-18 | BCHP | ETF | 20.2401 | 20.34 | 20.2401 | 20.2401 | 3120.0 |
| 2015-06-18 | BCM | ETF | 31.475 | 31.478 | 31.43 | 31.43 | 734.0 |
> showing 50 of 1,186 rows — these rows as CSV