PREVIEW / etf_daily / 2015-11-30
file: by_date/etf_daily/2015/2015-11-30.parquet size: 49 KB rows: 1,213
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-30 | SPY | ETF | 209.75 | 209.89 | 208.56 | 208.69 | 112822700.0 |
| 2015-11-30 | QQQ | ETF | 114.6 | 114.65 | 113.65 | 114.02 | 25041649.0 |
| 2015-11-30 | IWM | ETF | 120.02 | 120.07 | 119.05 | 119.1 | 30165400.0 |
| 2015-11-30 | DIA | ETF | 178.13 | 178.33 | 177.13 | 177.23 | 3578500.0 |
| 2015-11-30 | GLD | ETF | 101.53 | 102.38 | 101.52 | 101.92 | 6773000.0 |
| 2015-11-30 | TLT | ETF | 121.1 | 121.53 | 121.06 | 121.45 | 5179800.0 |
| 2015-11-30 | AADR | ETF | 39.0 | 39.13 | 39.0 | 39.11 | 700.0 |
| 2015-11-30 | AAXJ | ETF | 54.97 | 55.49 | 54.95 | 55.48 | 1327400.0 |
| 2015-11-30 | ACTX | ETF | 5.31 | 7.0801 | 4.72 | 6.4901 | 4358.0 |
| 2015-11-30 | ACWF | ETF | 23.89 | 23.89 | 23.8899 | 23.89 | 701.0 |
| 2015-11-30 | ACWI | ETF | 58.0 | 58.02 | 57.69 | 57.76 | 4750000.0 |
| 2015-11-30 | ACWV | ETF | 70.17 | 70.19 | 69.79 | 69.98 | 283000.0 |
| 2015-11-30 | ACWX | ETF | 41.15 | 41.18 | 41.03 | 41.07 | 1571898.0 |
| 2015-11-30 | ADRE | ETF | 30.22 | 30.49 | 30.22 | 30.49 | 16435.0 |
| 2015-11-30 | AFK | ETF | 18.63 | 18.7699 | 18.61 | 18.69 | 29567.0 |
| 2015-11-30 | AFTY | ETF | 16.1 | 16.35 | 16.1 | 16.34 | 45300.0 |
| 2015-11-30 | AGG | ETF | 108.83 | 108.87 | 108.77 | 108.81 | 2397000.0 |
| 2015-11-30 | AGGY | ETF | 49.54 | 49.54 | 49.4 | 49.51 | 82100.0 |
| 2015-11-30 | AGQ | ETF | 28.48 | 28.63 | 28.23 | 28.33 | 230300.0 |
| 2015-11-30 | AGZ | ETF | 113.41 | 113.47 | 113.052 | 113.4 | 88732.0 |
| 2015-11-30 | AGZD | ETF | 24.045 | 24.045 | 24.03 | 24.03 | 800.0 |
| 2015-11-30 | AIA | ETF | 44.04 | 44.4 | 43.87 | 44.4 | 71157.0 |
| 2015-11-30 | AIQ | ETF | 9.0 | 9.42 | 8.87 | 9.01 | 40841.0 |
| 2015-11-30 | AIRR | ETF | 17.97 | 18.02 | 17.97 | 17.974 | 3500.0 |
| 2015-11-30 | AIVI | ETF | 39.53 | 39.54 | 39.34 | 39.42 | 23200.0 |
| 2015-11-30 | AMJ | ETF | 30.1 | 30.43 | 29.94 | 30.0208 | 3566569.0 |
| 2015-11-30 | AMLP | ETF | 61.6 | 61.95 | 60.85 | 61.3 | 1796440.0 |
| 2015-11-30 | AMZA | ETF | 127.0 | 129.5 | 124.96 | 126.0 | 1240.0 |
| 2015-11-30 | ANGL | ETF | 25.34 | 25.45 | 25.34 | 25.39 | 27600.0 |
| 2015-11-30 | AOA | ETF | 46.05 | 46.07 | 45.91 | 45.97 | 154100.0 |
| 2015-11-30 | AOK | ETF | 32.14 | 32.14 | 32.03 | 32.07 | 255858.0 |
| 2015-11-30 | AOM | ETF | 34.68 | 34.68 | 34.59 | 34.64 | 196509.0 |
| 2015-11-30 | AOR | ETF | 39.74 | 39.74 | 39.58 | 39.64 | 389580.0 |
| 2015-11-30 | ARGT | ETF | 18.8 | 18.95 | 18.72 | 18.89 | 11600.0 |
| 2015-11-30 | ARKG | ETF | 20.675 | 20.675 | 20.675 | 20.675 | 100.0 |
| 2015-11-30 | ARKK | ETF | 21.2 | 21.2 | 21.2 | 21.2 | 600.0 |
| 2015-11-30 | ARKQ | ETF | 19.71 | 19.71 | 19.71 | 19.71 | 200.0 |
| 2015-11-30 | ARKW | ETF | 24.1 | 24.1 | 23.889 | 23.93 | 2200.0 |
| 2015-11-30 | ASEA | ETF | 12.75 | 12.75 | 12.66 | 12.7 | 8300.0 |
| 2015-11-30 | ASET | ETF | 25.05 | 25.05 | 25.05 | 25.05 | 500.0 |
| 2015-11-30 | ASHR | ETF | 35.34 | 35.92 | 35.23 | 35.92 | 2054200.0 |
| 2015-11-30 | ASHS | ETF | 45.07 | 45.35 | 44.81 | 45.0 | 96000.0 |
| 2015-11-30 | ASHX | ETF | 25.0632 | 25.29 | 25.0632 | 25.29 | 1629.0 |
| 2015-11-30 | ATMP | ETF | 19.85 | 20.07 | 19.73 | 19.9 | 225500.0 |
| 2015-11-30 | AWAY | ETF | 35.56 | 35.67 | 35.16 | 35.36 | 2181937.0 |
| 2015-11-30 | BAB | ETF | 29.13 | 29.2099 | 29.12 | 29.2 | 50202.0 |
| 2015-11-30 | BAL | ETF | 42.27 | 42.34 | 41.59 | 41.59 | 10481.0 |
| 2015-11-30 | BBC | ETF | 32.24 | 32.24 | 31.2101 | 31.68 | 15472.0 |
| 2015-11-30 | BBH | ETF | 127.3 | 127.3 | 123.93 | 124.46 | 61100.0 |
| 2015-11-30 | BBP | ETF | 32.0 | 32.0 | 31.43 | 31.61 | 6200.0 |
> showing 50 of 1,213 rows — these rows as CSV