PREVIEW / etf_daily / 2015-11-16
file: by_date/etf_daily/2015/2015-11-16.parquet size: 49 KB rows: 1,210
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-16 | SPY | ETF | 202.32 | 205.69 | 202.18 | 205.62 | 117645200.0 |
| 2015-11-16 | QQQ | ETF | 109.74 | 111.44 | 109.48 | 111.42 | 33980633.0 |
| 2015-11-16 | IWM | ETF | 113.96 | 115.09 | 113.36 | 115.05 | 28979100.0 |
| 2015-11-16 | DIA | ETF | 172.5 | 175.06 | 172.15 | 175.02 | 5012900.0 |
| 2015-11-16 | GLD | ETF | 103.98 | 104.03 | 103.52 | 103.71 | 2951200.0 |
| 2015-11-16 | TLT | ETF | 119.79 | 120.0 | 119.13 | 119.57 | 5485300.0 |
| 2015-11-16 | AADR | ETF | 37.97 | 37.97 | 37.97 | 37.97 | 300.0 |
| 2015-11-16 | AAXJ | ETF | 54.48 | 55.37 | 54.48 | 55.34 | 794800.0 |
| 2015-11-16 | ACTX | ETF | 4.72 | 4.779 | 3.54 | 3.54 | 3872.0 |
| 2015-11-16 | ACWF | ETF | 23.2447 | 23.2447 | 23.2447 | 23.2447 | 100.0 |
| 2015-11-16 | ACWI | ETF | 56.41 | 57.18 | 56.33 | 57.17 | 2262800.0 |
| 2015-11-16 | ACWV | ETF | 68.58 | 69.51 | 68.58 | 69.47 | 169400.0 |
| 2015-11-16 | ACWX | ETF | 40.24 | 40.79 | 40.24 | 40.78 | 665275.0 |
| 2015-11-16 | ADRE | ETF | 29.67 | 30.15 | 29.6401 | 30.1164 | 4512.0 |
| 2015-11-16 | AFK | ETF | 18.93 | 19.14 | 18.9 | 19.1 | 13143.0 |
| 2015-11-16 | AFTY | ETF | 17.16 | 17.37 | 17.06 | 17.22 | 64400.0 |
| 2015-11-16 | AGG | ETF | 108.63 | 108.7 | 108.56 | 108.64 | 3326000.0 |
| 2015-11-16 | AGGY | ETF | 49.379 | 49.38 | 49.37 | 49.37 | 1400.0 |
| 2015-11-16 | AGQ | ETF | 29.13 | 29.22 | 28.84 | 29.13 | 115000.0 |
| 2015-11-16 | AGZ | ETF | 113.51 | 113.5399 | 113.27 | 113.33 | 28533.0 |
| 2015-11-16 | AGZD | ETF | 24.08 | 24.08 | 24.025 | 24.025 | 800.0 |
| 2015-11-16 | AIA | ETF | 44.04 | 44.59 | 44.04 | 44.58 | 21971.0 |
| 2015-11-16 | AIQ | ETF | 9.1 | 9.1 | 7.81 | 7.88 | 352619.0 |
| 2015-11-16 | AIRR | ETF | 16.9 | 17.03 | 16.9 | 17.01 | 15600.0 |
| 2015-11-16 | AIVI | ETF | 38.57 | 39.12 | 38.57 | 39.06 | 20300.0 |
| 2015-11-16 | ALTY | ETF | 14.11 | 14.2 | 14.11 | 14.2 | 500.0 |
| 2015-11-16 | AMJ | ETF | 31.14 | 32.16 | 31.12 | 32.11 | 2181785.0 |
| 2015-11-16 | AMLP | ETF | 62.15 | 64.55 | 61.9 | 64.5 | 2854740.0 |
| 2015-11-16 | AMZA | ETF | 133.56 | 134.18 | 131.6 | 133.25 | 690.0 |
| 2015-11-16 | ANGL | ETF | 25.66 | 25.66 | 25.5 | 25.61 | 5600.0 |
| 2015-11-16 | AOA | ETF | 45.1 | 45.49 | 45.01 | 45.49 | 97400.0 |
| 2015-11-16 | AOK | ETF | 31.69 | 31.9 | 31.69 | 31.87 | 46408.0 |
| 2015-11-16 | AOM | ETF | 34.26 | 34.41 | 34.22 | 34.41 | 258459.0 |
| 2015-11-16 | AOR | ETF | 39.0 | 39.3 | 38.99 | 39.28 | 225034.0 |
| 2015-11-16 | ARGT | ETF | 19.24 | 19.48 | 19.18 | 19.45 | 10400.0 |
| 2015-11-16 | ARKG | ETF | 19.57 | 19.57 | 19.52 | 19.52 | 400.0 |
| 2015-11-16 | ARKK | ETF | 19.92 | 19.92 | 19.92 | 19.92 | 200.0 |
| 2015-11-16 | ARKQ | ETF | 18.53 | 18.53 | 18.53 | 18.53 | 200.0 |
| 2015-11-16 | ARKW | ETF | 22.69 | 22.69 | 22.69 | 22.69 | 200.0 |
| 2015-11-16 | ASEA | ETF | 12.64 | 12.79 | 12.64 | 12.79 | 4400.0 |
| 2015-11-16 | ASHR | ETF | 37.43 | 38.0 | 37.28 | 37.95 | 3357500.0 |
| 2015-11-16 | ASHS | ETF | 46.33 | 47.28 | 46.33 | 47.2 | 154300.0 |
| 2015-11-16 | ASHX | ETF | 26.55 | 26.55 | 26.51 | 26.5283 | 388.0 |
| 2015-11-16 | ATMP | ETF | 20.72 | 21.32 | 20.72 | 21.32 | 49300.0 |
| 2015-11-16 | AWAY | ETF | 35.43 | 35.49 | 34.83 | 35.18 | 4918604.0 |
| 2015-11-16 | BAB | ETF | 28.8 | 28.84 | 28.77 | 28.789 | 72364.0 |
| 2015-11-16 | BAL | ETF | 41.03 | 42.15 | 41.03 | 41.531 | 6957.0 |
| 2015-11-16 | BBC | ETF | 29.35 | 29.35 | 28.4 | 29.02 | 4854.0 |
| 2015-11-16 | BBH | ETF | 120.27 | 122.02 | 119.21 | 121.97 | 59100.0 |
| 2015-11-16 | BBP | ETF | 30.28 | 30.37 | 29.68 | 30.35 | 11900.0 |
> showing 50 of 1,210 rows — these rows as CSV