PREVIEW / etf_daily / 2015-11-27
file: by_date/etf_daily/2015/2015-11-27.parquet size: 46 KB rows: 1,159
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-27 | SPY | ETF | 209.43 | 209.8 | 208.86 | 209.56 | 37317800.0 |
| 2015-11-27 | QQQ | ETF | 114.395 | 114.541 | 113.92 | 114.31 | 8827991.0 |
| 2015-11-27 | IWM | ETF | 119.27 | 119.9 | 118.88 | 119.62 | 14129300.0 |
| 2015-11-27 | DIA | ETF | 177.8 | 178.18 | 177.36 | 177.9 | 2878200.0 |
| 2015-11-27 | GLD | ETF | 101.01 | 101.62 | 100.99 | 101.25 | 4993600.0 |
| 2015-11-27 | TLT | ETF | 121.25 | 121.32 | 120.96 | 120.97 | 2570600.0 |
| 2015-11-27 | AADR | ETF | 39.45 | 39.45 | 38.84 | 38.84 | 4400.0 |
| 2015-11-27 | AAXJ | ETF | 55.29 | 55.34 | 55.11 | 55.17 | 371700.0 |
| 2015-11-27 | ACTX | ETF | 4.72 | 5.31 | 4.13 | 5.31 | 1110.0 |
| 2015-11-27 | ACWI | ETF | 57.92 | 58.01 | 57.84 | 57.93 | 448000.0 |
| 2015-11-27 | ACWV | ETF | 70.2 | 70.28 | 70.02 | 70.22 | 81700.0 |
| 2015-11-27 | ACWX | ETF | 41.29 | 41.3 | 41.11 | 41.14 | 377358.0 |
| 2015-11-27 | ADRE | ETF | 30.41 | 30.4393 | 30.376 | 30.4368 | 1892.0 |
| 2015-11-27 | AFK | ETF | 18.69 | 18.84 | 18.69 | 18.75 | 8653.0 |
| 2015-11-27 | AFTY | ETF | 16.009 | 16.04 | 15.966 | 16.02 | 9900.0 |
| 2015-11-27 | AGG | ETF | 108.85 | 108.87 | 108.77 | 108.77 | 946100.0 |
| 2015-11-27 | AGQ | ETF | 28.13 | 28.6 | 28.05 | 28.43 | 32400.0 |
| 2015-11-27 | AGZ | ETF | 113.32 | 113.433 | 113.0147 | 113.2 | 2659.0 |
| 2015-11-27 | AGZD | ETF | 24.015 | 24.06 | 24.015 | 24.06 | 2400.0 |
| 2015-11-27 | AIA | ETF | 44.34 | 44.37 | 44.29 | 44.31 | 3060.0 |
| 2015-11-27 | AIQ | ETF | 9.21 | 9.29 | 8.99 | 9.13 | 12020.0 |
| 2015-11-27 | AIRR | ETF | 17.77 | 17.77 | 17.77 | 17.77 | 200.0 |
| 2015-11-27 | AIVI | ETF | 39.53 | 39.54 | 39.45 | 39.46 | 3300.0 |
| 2015-11-27 | AMJ | ETF | 30.17 | 30.23 | 29.84 | 30.12 | 783738.0 |
| 2015-11-27 | AMLP | ETF | 61.15 | 62.3 | 60.65 | 61.3 | 638700.0 |
| 2015-11-27 | AMZA | ETF | 128.25 | 128.25 | 124.8 | 124.8 | 1050.0 |
| 2015-11-27 | ANGL | ETF | 25.4 | 25.43 | 25.39 | 25.42 | 3500.0 |
| 2015-11-27 | AOA | ETF | 46.13 | 46.13 | 46.0 | 46.05 | 10700.0 |
| 2015-11-27 | AOK | ETF | 32.1099 | 32.12 | 32.08 | 32.08 | 18621.0 |
| 2015-11-27 | AOM | ETF | 34.73 | 34.73 | 34.63 | 34.67 | 117579.0 |
| 2015-11-27 | AOR | ETF | 39.63 | 39.71 | 39.59 | 39.66 | 414806.0 |
| 2015-11-27 | ARGT | ETF | 18.88 | 19.16 | 18.68 | 18.68 | 18200.0 |
| 2015-11-27 | ARKG | ETF | 20.85 | 20.87 | 20.85 | 20.87 | 700.0 |
| 2015-11-27 | ARKK | ETF | 21.27 | 21.27 | 21.27 | 21.27 | 200.0 |
| 2015-11-27 | ARKQ | ETF | 19.57 | 19.57 | 19.57 | 19.57 | 100.0 |
| 2015-11-27 | ARKW | ETF | 24.07 | 24.07 | 23.87 | 23.87 | 500.0 |
| 2015-11-27 | ASEA | ETF | 12.78 | 12.78 | 12.73 | 12.74 | 3000.0 |
| 2015-11-27 | ASET | ETF | 24.97 | 24.98 | 24.97 | 24.98 | 2000.0 |
| 2015-11-27 | ASHR | ETF | 35.41 | 35.5 | 35.1 | 35.1 | 2940400.0 |
| 2015-11-27 | ASHS | ETF | 45.82 | 45.82 | 44.34 | 44.76 | 81800.0 |
| 2015-11-27 | ASHX | ETF | 25.47 | 25.78 | 24.89 | 25.0168 | 10889.0 |
| 2015-11-27 | ATMP | ETF | 19.97 | 20.01 | 19.81 | 19.83 | 45000.0 |
| 2015-11-27 | AWAY | ETF | 35.58 | 35.63 | 35.09 | 35.5 | 616171.0 |
| 2015-11-27 | BAB | ETF | 29.14 | 29.18 | 29.07 | 29.0706 | 18597.0 |
| 2015-11-27 | BAL | ETF | 42.42 | 42.69 | 42.41 | 42.57 | 4144.0 |
| 2015-11-27 | BBC | ETF | 31.37 | 31.9799 | 31.37 | 31.92 | 7660.0 |
| 2015-11-27 | BBH | ETF | 126.9 | 127.25 | 126.63 | 127.05 | 21800.0 |
| 2015-11-27 | BBP | ETF | 31.9 | 32.08 | 31.67 | 31.81 | 4300.0 |
| 2015-11-27 | BFOR | ETF | 7.97 | 7.985 | 7.9625 | 7.98 | 16800.0 |
| 2015-11-27 | BIB | ETF | 72.5 | 73.25 | 72.295 | 72.99 | 261947.0 |
> showing 50 of 1,159 rows — these rows as CSV