PREVIEW / etf_daily / 2015-11-20
file: by_date/etf_daily/2015/2015-11-20.parquet size: 49 KB rows: 1,215
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-20 | SPY | ETF | 209.45 | 210.12 | 208.86 | 209.31 | 94011500.0 |
| 2015-11-20 | QQQ | ETF | 114.24 | 114.57 | 114.14 | 114.48 | 22727591.0 |
| 2015-11-20 | IWM | ETF | 116.48 | 117.36 | 116.38 | 116.81 | 31697700.0 |
| 2015-11-20 | DIA | ETF | 178.17 | 178.97 | 177.66 | 178.06 | 7730000.0 |
| 2015-11-20 | GLD | ETF | 103.58 | 103.66 | 102.97 | 103.09 | 5971600.0 |
| 2015-11-20 | TLT | ETF | 120.93 | 121.04 | 120.28 | 120.45 | 5971000.0 |
| 2015-11-20 | AADR | ETF | 39.38 | 39.49 | 38.98 | 39.49 | 3900.0 |
| 2015-11-20 | AAXJ | ETF | 56.44 | 56.69 | 56.34 | 56.45 | 740200.0 |
| 2015-11-20 | ACTX | ETF | 4.72 | 5.9001 | 4.72 | 4.72 | 4658.0 |
| 2015-11-20 | ACWF | ETF | 23.9199 | 23.9199 | 23.9199 | 23.9199 | 401.0 |
| 2015-11-20 | ACWI | ETF | 58.32 | 58.41 | 58.07 | 58.14 | 4173100.0 |
| 2015-11-20 | ACWV | ETF | 70.51 | 70.73 | 70.33 | 70.44 | 77700.0 |
| 2015-11-20 | ACWX | ETF | 41.74 | 41.74 | 41.44 | 41.46 | 1152647.0 |
| 2015-11-20 | ADRE | ETF | 30.97 | 31.12 | 30.9201 | 31.12 | 6994.0 |
| 2015-11-20 | AFK | ETF | 19.21 | 19.23 | 18.98 | 19.09 | 20072.0 |
| 2015-11-20 | AFTY | ETF | 17.16 | 17.17 | 17.12 | 17.14 | 8200.0 |
| 2015-11-20 | AGG | ETF | 108.77 | 108.82 | 108.6 | 108.62 | 2034400.0 |
| 2015-11-20 | AGQ | ETF | 29.02 | 29.08 | 28.35 | 28.61 | 138700.0 |
| 2015-11-20 | AGZ | ETF | 113.3199 | 113.34 | 113.15 | 113.21 | 8654.0 |
| 2015-11-20 | AGZD | ETF | 24.08 | 24.11 | 24.015 | 24.015 | 20600.0 |
| 2015-11-20 | AIA | ETF | 45.4 | 45.47 | 45.2748 | 45.34 | 21407.0 |
| 2015-11-20 | AIQ | ETF | 7.83 | 9.15 | 7.8 | 8.49 | 78979.0 |
| 2015-11-20 | AIRR | ETF | 17.45 | 17.465 | 17.39 | 17.39 | 5900.0 |
| 2015-11-20 | AIVI | ETF | 39.93 | 40.01 | 39.62 | 39.63 | 45900.0 |
| 2015-11-20 | ALTY | ETF | 14.36 | 14.36 | 14.36 | 14.36 | 100.0 |
| 2015-11-20 | AMJ | ETF | 31.38 | 31.5599 | 30.48 | 30.63 | 4265882.0 |
| 2015-11-20 | AMLP | ETF | 62.75 | 63.1 | 60.85 | 61.35 | 2243680.0 |
| 2015-11-20 | AMZA | ETF | 132.66 | 132.66 | 123.9 | 126.0 | 4230.0 |
| 2015-11-20 | ANGL | ETF | 25.6 | 25.6 | 25.57 | 25.58 | 15200.0 |
| 2015-11-20 | AOA | ETF | 46.26 | 46.28 | 46.09 | 46.13 | 144900.0 |
| 2015-11-20 | AOK | ETF | 32.03 | 32.1494 | 32.03 | 32.05 | 43481.0 |
| 2015-11-20 | AOM | ETF | 34.73 | 34.7599 | 34.63 | 34.67 | 154738.0 |
| 2015-11-20 | AOR | ETF | 39.68 | 39.805 | 39.663 | 39.663 | 113151.0 |
| 2015-11-20 | ARGT | ETF | 19.55 | 19.86 | 19.47 | 19.73 | 86100.0 |
| 2015-11-20 | ARKG | ETF | 20.11 | 20.14 | 20.11 | 20.14 | 500.0 |
| 2015-11-20 | ARKK | ETF | 20.65 | 20.65 | 20.65 | 20.65 | 300.0 |
| 2015-11-20 | ARKQ | ETF | 19.24 | 19.24 | 19.24 | 19.24 | 400.0 |
| 2015-11-20 | ARKW | ETF | 23.73 | 23.73 | 23.6 | 23.6 | 700.0 |
| 2015-11-20 | ASEA | ETF | 13.01 | 13.04 | 12.97 | 12.97 | 4900.0 |
| 2015-11-20 | ASHR | ETF | 38.06 | 38.08 | 37.84 | 37.86 | 1892000.0 |
| 2015-11-20 | ASHS | ETF | 47.82 | 47.91 | 47.49 | 47.65 | 42900.0 |
| 2015-11-20 | ASHX | ETF | 26.736 | 26.74 | 26.7296 | 26.7296 | 1884.0 |
| 2015-11-20 | ATMP | ETF | 20.4 | 20.91 | 20.17 | 20.41 | 286900.0 |
| 2015-11-20 | AWAY | ETF | 36.17 | 36.46 | 35.87 | 36.01 | 1718338.0 |
| 2015-11-20 | BAB | ETF | 29.09 | 29.1935 | 28.97 | 29.04 | 136253.0 |
| 2015-11-20 | BAL | ETF | 41.96 | 42.14 | 41.827 | 41.827 | 9252.0 |
| 2015-11-20 | BBC | ETF | 29.25 | 29.778 | 29.25 | 29.778 | 4461.0 |
| 2015-11-20 | BBH | ETF | 125.57 | 126.23 | 124.55 | 124.66 | 104800.0 |
| 2015-11-20 | BBP | ETF | 31.16 | 31.45 | 31.09 | 31.09 | 6700.0 |
| 2015-11-20 | BCM | ETF | 24.96 | 24.96 | 24.85 | 24.85 | 863.0 |
> showing 50 of 1,215 rows — these rows as CSV