PREVIEW / etf_daily / 2015-11-06
file: by_date/etf_daily/2015/2015-11-06.parquet size: 49 KB rows: 1,208
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-11-06 | SPY | ETF | 209.74 | 210.32 | 208.46 | 210.04 | 110471500.0 |
| 2015-11-06 | QQQ | ETF | 114.49 | 114.92 | 113.76 | 114.79 | 29924901.0 |
| 2015-11-06 | IWM | ETF | 118.01 | 119.36 | 117.29 | 119.22 | 35141300.0 |
| 2015-11-06 | DIA | ETF | 178.49 | 179.17 | 177.71 | 179.14 | 7642800.0 |
| 2015-11-06 | GLD | ETF | 104.17 | 104.42 | 104.02 | 104.1 | 8831900.0 |
| 2015-11-06 | TLT | ETF | 119.49 | 119.53 | 118.74 | 119.0 | 10604700.0 |
| 2015-11-06 | AADR | ETF | 38.99 | 38.99 | 38.81 | 38.82 | 1400.0 |
| 2015-11-06 | AAXJ | ETF | 56.7 | 57.22 | 56.44 | 57.18 | 1059600.0 |
| 2015-11-06 | ACTX | ETF | 8.2601 | 8.8501 | 6.4901 | 7.0801 | 4308.0 |
| 2015-11-06 | ACWF | ETF | 24.05 | 24.05 | 23.99 | 23.99 | 202.0 |
| 2015-11-06 | ACWI | ETF | 58.24 | 58.4 | 57.94 | 58.38 | 1268200.0 |
| 2015-11-06 | ACWV | ETF | 70.36 | 70.36 | 69.76 | 70.09 | 63400.0 |
| 2015-11-06 | ACWX | ETF | 41.47 | 41.58 | 41.2658 | 41.55 | 628431.0 |
| 2015-11-06 | ADRE | ETF | 31.43 | 31.43 | 30.9435 | 31.2978 | 3233.0 |
| 2015-11-06 | AFK | ETF | 20.33 | 20.33 | 20.01 | 20.04 | 29072.0 |
| 2015-11-06 | AFTY | ETF | 16.91 | 17.2 | 16.91 | 17.2 | 17900.0 |
| 2015-11-06 | AGG | ETF | 108.36 | 108.39 | 108.19 | 108.25 | 1829500.0 |
| 2015-11-06 | AGQ | ETF | 31.32 | 31.39 | 31.01 | 31.13 | 231600.0 |
| 2015-11-06 | AGZ | ETF | 113.1 | 113.32 | 112.9801 | 113.21 | 38581.0 |
| 2015-11-06 | AGZD | ETF | 24.1 | 24.1 | 24.085 | 24.085 | 400.0 |
| 2015-11-06 | AIA | ETF | 45.66 | 45.87 | 45.38 | 45.87 | 23380.0 |
| 2015-11-06 | AIQ | ETF | 9.49 | 10.09 | 9.13 | 9.87 | 87778.0 |
| 2015-11-06 | AIRR | ETF | 16.995 | 17.24 | 16.991 | 17.24 | 4400.0 |
| 2015-11-06 | AIVI | ETF | 39.91 | 40.01 | 39.66 | 39.89 | 32800.0 |
| 2015-11-06 | ALTY | ETF | 14.45 | 14.45 | 14.325 | 14.325 | 200.0 |
| 2015-11-06 | AMJ | ETF | 33.11 | 33.45 | 32.65 | 32.87 | 2126027.0 |
| 2015-11-06 | AMLP | ETF | 67.95 | 68.75 | 66.95 | 67.45 | 1426760.0 |
| 2015-11-06 | AMUB | ETF | 20.98 | 20.98 | 20.98 | 20.98 | 300.0 |
| 2015-11-06 | AMZA | ETF | 143.1 | 143.6 | 140.3 | 141.1 | 1860.0 |
| 2015-11-06 | ANGL | ETF | 26.04 | 26.04 | 25.91 | 25.93 | 44900.0 |
| 2015-11-06 | AOA | ETF | 46.13 | 46.19 | 45.91 | 46.11 | 80600.0 |
| 2015-11-06 | AOK | ETF | 32.08 | 32.08 | 31.92 | 32.01 | 121447.0 |
| 2015-11-06 | AOM | ETF | 34.69 | 34.69 | 34.5 | 34.62 | 173338.0 |
| 2015-11-06 | AOR | ETF | 39.76 | 39.76 | 39.51 | 39.652 | 151992.0 |
| 2015-11-06 | ARGT | ETF | 19.17 | 19.47 | 19.17 | 19.4 | 4900.0 |
| 2015-11-06 | ARKG | ETF | 20.03 | 20.03 | 19.99 | 19.999 | 1300.0 |
| 2015-11-06 | ARKK | ETF | 20.84 | 20.89 | 20.838 | 20.848 | 500.0 |
| 2015-11-06 | ARKQ | ETF | 19.51 | 19.51 | 19.48 | 19.48 | 1200.0 |
| 2015-11-06 | ARKW | ETF | 23.5 | 23.75 | 23.45 | 23.75 | 2400.0 |
| 2015-11-06 | ASEA | ETF | 13.09 | 13.09 | 12.97 | 12.97 | 2000.0 |
| 2015-11-06 | ASHR | ETF | 37.58 | 38.06 | 37.38 | 38.01 | 1967300.0 |
| 2015-11-06 | ASHS | ETF | 45.45 | 45.45 | 44.72 | 45.32 | 93700.0 |
| 2015-11-06 | ASHX | ETF | 26.3209 | 26.7499 | 26.3209 | 26.7499 | 3481.0 |
| 2015-11-06 | ATMP | ETF | 22.2 | 22.32 | 21.8 | 21.95 | 81800.0 |
| 2015-11-06 | AWAY | ETF | 39.22 | 39.31 | 37.21 | 37.3 | 11447854.0 |
| 2015-11-06 | BAB | ETF | 28.92 | 28.92 | 28.72 | 28.77 | 489473.0 |
| 2015-11-06 | BAL | ETF | 41.06 | 41.33 | 41.06 | 41.33 | 4396.0 |
| 2015-11-06 | BBC | ETF | 29.741 | 30.38 | 29.52 | 30.2 | 3886.0 |
| 2015-11-06 | BBH | ETF | 124.41 | 124.68 | 122.1 | 123.96 | 156200.0 |
| 2015-11-06 | BBP | ETF | 31.53 | 31.73 | 30.86 | 31.51 | 12100.0 |
> showing 50 of 1,208 rows — these rows as CSV