PREVIEW / etf_daily / 2015-11-19
file: by_date/etf_daily/2015/2015-11-19.parquet size: 49 KB rows: 1,221
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-19 | SPY | ETF | 208.59 | 209.05 | 208.2 | 208.55 | 88220500.0 |
| 2015-11-19 | QQQ | ETF | 113.68 | 114.23 | 113.49 | 113.71 | 26188119.0 |
| 2015-11-19 | IWM | ETF | 116.44 | 116.65 | 115.74 | 116.06 | 25512500.0 |
| 2015-11-19 | DIA | ETF | 177.18 | 178.05 | 177.15 | 177.66 | 5457300.0 |
| 2015-11-19 | GLD | ETF | 103.07 | 104.09 | 103.07 | 103.56 | 5087600.0 |
| 2015-11-19 | TLT | ETF | 120.88 | 121.15 | 120.68 | 120.82 | 6643000.0 |
| 2015-11-19 | AADR | ETF | 39.33 | 39.33 | 39.33 | 39.33 | 1000.0 |
| 2015-11-19 | AAXJ | ETF | 55.77 | 56.09 | 55.73 | 55.86 | 696700.0 |
| 2015-11-19 | ACTX | ETF | 4.72 | 4.72 | 4.72 | 4.72 | 1592.0 |
| 2015-11-19 | ACWI | ETF | 58.01 | 58.15 | 57.96 | 58.01 | 3249400.0 |
| 2015-11-19 | ACWV | ETF | 70.11 | 70.41 | 70.11 | 70.28 | 225600.0 |
| 2015-11-19 | ACWX | ETF | 41.45 | 41.62 | 41.44 | 41.49 | 1255127.0 |
| 2015-11-19 | ADRE | ETF | 30.53 | 30.857 | 30.53 | 30.857 | 9594.0 |
| 2015-11-19 | AFK | ETF | 19.15 | 19.25 | 19.09 | 19.18 | 215667.0 |
| 2015-11-19 | AFTY | ETF | 17.13 | 17.16 | 17.06 | 17.06 | 79000.0 |
| 2015-11-19 | AGG | ETF | 108.9 | 108.9 | 108.68 | 108.69 | 4232700.0 |
| 2015-11-19 | AGQ | ETF | 29.05 | 29.69 | 29.05 | 29.09 | 295600.0 |
| 2015-11-19 | AGZ | ETF | 113.21 | 113.4797 | 113.19 | 113.26 | 17157.0 |
| 2015-11-19 | AGZD | ETF | 24.075 | 24.095 | 24.055 | 24.09 | 4800.0 |
| 2015-11-19 | AIA | ETF | 44.93 | 45.1095 | 44.9295 | 44.96 | 32401.0 |
| 2015-11-19 | AIQ | ETF | 7.21 | 7.89 | 7.1 | 7.77 | 67969.0 |
| 2015-11-19 | AIRR | ETF | 17.3 | 17.3 | 17.26 | 17.26 | 2300.0 |
| 2015-11-19 | AIVI | ETF | 39.82 | 39.94 | 39.8 | 39.87 | 27900.0 |
| 2015-11-19 | AMJ | ETF | 31.72 | 31.8 | 31.17 | 31.38 | 2766822.0 |
| 2015-11-19 | AMLP | ETF | 63.7 | 63.85 | 62.45 | 62.9 | 2954840.0 |
| 2015-11-19 | AMZA | ETF | 131.5 | 133.2 | 128.9 | 131.9 | 1860.0 |
| 2015-11-19 | ANGL | ETF | 25.64 | 25.64 | 25.53 | 25.54 | 27100.0 |
| 2015-11-19 | AOA | ETF | 45.99 | 46.16 | 45.99 | 46.09 | 128100.0 |
| 2015-11-19 | AOK | ETF | 32.0937 | 32.1099 | 32.05 | 32.07 | 106095.0 |
| 2015-11-19 | AOM | ETF | 34.6 | 34.7 | 34.6 | 34.62 | 283266.0 |
| 2015-11-19 | AOR | ETF | 39.54 | 39.72 | 39.54 | 39.69 | 331814.0 |
| 2015-11-19 | ARGT | ETF | 19.57 | 19.57 | 19.18 | 19.36 | 35700.0 |
| 2015-11-19 | ARKG | ETF | 20.19 | 20.19 | 20.09 | 20.17 | 3700.0 |
| 2015-11-19 | ARKK | ETF | 20.25 | 20.52 | 20.25 | 20.51 | 1300.0 |
| 2015-11-19 | ARKQ | ETF | 19.05 | 19.05 | 19.02 | 19.02 | 400.0 |
| 2015-11-19 | ARKW | ETF | 23.25 | 23.56 | 23.25 | 23.56 | 600.0 |
| 2015-11-19 | ASEA | ETF | 12.81 | 12.93 | 12.81 | 12.89 | 3700.0 |
| 2015-11-19 | ASHR | ETF | 37.95 | 38.06 | 37.8 | 37.98 | 1315200.0 |
| 2015-11-19 | ASHS | ETF | 46.62 | 47.43 | 46.62 | 47.08 | 153800.0 |
| 2015-11-19 | ASHX | ETF | 26.63 | 26.63 | 26.51 | 26.51 | 2033.0 |
| 2015-11-19 | ATMP | ETF | 20.76 | 21.13 | 20.28 | 20.28 | 1093600.0 |
| 2015-11-19 | AWAY | ETF | 35.79 | 36.61 | 35.43 | 36.22 | 3427927.0 |
| 2015-11-19 | BAB | ETF | 29.04 | 29.09 | 29.01 | 29.02 | 65935.0 |
| 2015-11-19 | BAL | ETF | 42.13 | 42.13 | 41.9789 | 42.1 | 8889.0 |
| 2015-11-19 | BBC | ETF | 30.19 | 30.19 | 29.234 | 29.29 | 5471.0 |
| 2015-11-19 | BBH | ETF | 126.84 | 126.89 | 124.82 | 125.24 | 67900.0 |
| 2015-11-19 | BBP | ETF | 31.331 | 31.4 | 30.96 | 31.03 | 3300.0 |
| 2015-11-19 | BCM | ETF | 24.9395 | 24.982 | 24.9395 | 24.982 | 7324.0 |
| 2015-11-19 | BFOR | ETF | 7.825 | 7.845 | 7.7875 | 7.8025 | 44000.0 |
| 2015-11-19 | BIB | ETF | 72.2 | 72.5 | 69.6 | 69.99 | 679343.0 |
> showing 50 of 1,221 rows — these rows as CSV