PREVIEW / etf_daily / 2015-11-09
file: by_date/etf_daily/2015/2015-11-09.parquet size: 49 KB rows: 1,227
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-09 | SPY | ETF | 209.31 | 209.49 | 206.95 | 208.08 | 131008700.0 |
| 2015-11-09 | QQQ | ETF | 114.36 | 114.51 | 112.865 | 113.57 | 33479755.0 |
| 2015-11-09 | IWM | ETF | 119.07 | 119.29 | 117.27 | 117.82 | 32983100.0 |
| 2015-11-09 | DIA | ETF | 178.5 | 178.6 | 176.73 | 177.42 | 7962300.0 |
| 2015-11-09 | GLD | ETF | 104.29 | 104.58 | 104.19 | 104.4 | 4129200.0 |
| 2015-11-09 | TLT | ETF | 118.1 | 118.9 | 118.0 | 118.33 | 9159500.0 |
| 2015-11-09 | AADR | ETF | 38.66 | 38.66 | 38.48 | 38.48 | 1600.0 |
| 2015-11-09 | AAXJ | ETF | 56.55 | 56.55 | 55.76 | 55.91 | 1257200.0 |
| 2015-11-09 | ACTX | ETF | 7.0801 | 8.8501 | 6.4901 | 6.4901 | 1632.0 |
| 2015-11-09 | ACWF | ETF | 23.73 | 23.8 | 23.55 | 23.6 | 5753.0 |
| 2015-11-09 | ACWI | ETF | 58.12 | 58.13 | 57.48 | 57.75 | 2945000.0 |
| 2015-11-09 | ACWV | ETF | 69.81 | 69.89 | 69.24 | 69.52 | 63100.0 |
| 2015-11-09 | ACWX | ETF | 41.31 | 41.31 | 40.9 | 41.03 | 650453.0 |
| 2015-11-09 | ADRE | ETF | 31.14 | 31.14 | 30.5901 | 30.73 | 4883.0 |
| 2015-11-09 | AFK | ETF | 19.99 | 19.99 | 19.6301 | 19.81 | 139337.0 |
| 2015-11-09 | AFTY | ETF | 17.48 | 17.48 | 17.18 | 17.18 | 16600.0 |
| 2015-11-09 | AGG | ETF | 108.06 | 108.36 | 108.04 | 108.18 | 12843200.0 |
| 2015-11-09 | AGQ | ETF | 30.6 | 30.67 | 29.81 | 30.28 | 220400.0 |
| 2015-11-09 | AGZ | ETF | 112.8 | 113.1349 | 112.77 | 112.95 | 600491.0 |
| 2015-11-09 | AGZD | ETF | 24.095 | 24.095 | 24.095 | 24.095 | 800.0 |
| 2015-11-09 | AIA | ETF | 45.5 | 45.5 | 45.0 | 45.0 | 23206.0 |
| 2015-11-09 | AIQ | ETF | 9.94 | 10.05 | 9.56 | 9.65 | 71549.0 |
| 2015-11-09 | AIRR | ETF | 17.0 | 17.0 | 16.932 | 16.98 | 2000.0 |
| 2015-11-09 | AIVI | ETF | 39.54 | 39.54 | 39.17 | 39.33 | 31200.0 |
| 2015-11-09 | AMJ | ETF | 32.89 | 33.24 | 32.29 | 32.5 | 2815742.0 |
| 2015-11-09 | AMLP | ETF | 67.35 | 68.15 | 66.35 | 66.65 | 1988560.0 |
| 2015-11-09 | AMZA | ETF | 140.0 | 140.0 | 137.6 | 138.7 | 1190.0 |
| 2015-11-09 | ANGL | ETF | 25.84 | 25.91 | 25.8 | 25.91 | 12300.0 |
| 2015-11-09 | AOA | ETF | 46.0 | 46.0 | 45.57 | 45.76 | 100400.0 |
| 2015-11-09 | AOK | ETF | 31.98 | 31.98 | 31.82 | 31.8932 | 56931.0 |
| 2015-11-09 | AOM | ETF | 34.52 | 34.55 | 34.34 | 34.45 | 170965.0 |
| 2015-11-09 | AOR | ETF | 39.46 | 39.5 | 39.27 | 39.43 | 228884.0 |
| 2015-11-09 | ARGT | ETF | 19.45 | 19.45 | 19.19 | 19.25 | 4200.0 |
| 2015-11-09 | ARKG | ETF | 20.1 | 20.145 | 20.1 | 20.145 | 300.0 |
| 2015-11-09 | ARKK | ETF | 20.59 | 20.685 | 20.58 | 20.685 | 500.0 |
| 2015-11-09 | ARKQ | ETF | 19.35 | 19.39 | 19.32 | 19.32 | 600.0 |
| 2015-11-09 | ARKW | ETF | 23.6 | 23.6 | 23.41 | 23.45 | 1700.0 |
| 2015-11-09 | ASEA | ETF | 12.88 | 12.88 | 12.74 | 12.75 | 13900.0 |
| 2015-11-09 | ASHR | ETF | 38.21 | 38.37 | 37.74 | 37.87 | 1988700.0 |
| 2015-11-09 | ASHS | ETF | 45.2 | 45.79 | 44.95 | 45.02 | 161200.0 |
| 2015-11-09 | ASHX | ETF | 26.86 | 26.91 | 26.66 | 26.66 | 4675.0 |
| 2015-11-09 | ATMP | ETF | 21.75 | 22.08 | 21.57 | 21.65 | 95000.0 |
| 2015-11-09 | AWAY | ETF | 37.0 | 37.39 | 36.49 | 36.56 | 4047289.0 |
| 2015-11-09 | BAB | ETF | 28.71 | 28.78 | 28.64 | 28.7 | 74297.0 |
| 2015-11-09 | BAL | ETF | 41.084 | 41.263 | 41.0501 | 41.263 | 856.0 |
| 2015-11-09 | BBC | ETF | 30.326 | 30.86 | 30.25 | 30.8001 | 10207.0 |
| 2015-11-09 | BBH | ETF | 123.56 | 124.81 | 122.8 | 124.51 | 234400.0 |
| 2015-11-09 | BBP | ETF | 31.422 | 31.764 | 31.3 | 31.51 | 12000.0 |
| 2015-11-09 | BCM | ETF | 26.104 | 26.104 | 25.85 | 25.85 | 4392.0 |
| 2015-11-09 | BFOR | ETF | 8.0 | 8.0 | 7.885 | 7.935 | 49600.0 |
> showing 50 of 1,227 rows — these rows as CSV