PREVIEW / etf_daily / 2015-08-25
file: by_date/etf_daily/2015/2015-08-25.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-08-25 | SPY | ETF | 195.43 | 195.45 | 186.92 | 187.27 | 369833100.0 |
| 2015-08-25 | QQQ | ETF | 102.07 | 102.74 | 98.01 | 98.09 | 75088278.0 |
| 2015-08-25 | IWM | ETF | 114.05 | 114.1 | 109.56 | 109.69 | 59240200.0 |
| 2015-08-25 | DIA | ETF | 163.33 | 163.68 | 156.29 | 156.49 | 19357000.0 |
| 2015-08-25 | GLD | ETF | 110.01 | 110.05 | 108.72 | 109.16 | 9974200.0 |
| 2015-08-25 | TLT | ETF | 124.55 | 124.79 | 123.56 | 124.33 | 15354800.0 |
| 2015-08-25 | AADR | ETF | 37.72 | 37.72 | 36.16 | 36.82 | 1000.0 |
| 2015-08-25 | AAXJ | ETF | 52.76 | 53.11 | 50.81 | 50.81 | 3614100.0 |
| 2015-08-25 | ACTX | ETF | 1.711 | 1.77 | 1.18 | 1.77 | 1493.0 |
| 2015-08-25 | ACWF | ETF | 22.86 | 22.86 | 22.655 | 22.66 | 928.0 |
| 2015-08-25 | ACWI | ETF | 55.49 | 55.62 | 53.36 | 53.36 | 6928800.0 |
| 2015-08-25 | ACWV | ETF | 68.71 | 68.76 | 65.04 | 65.17 | 201000.0 |
| 2015-08-25 | ACWX | ETF | 40.74 | 41.02 | 39.4 | 39.4 | 916825.0 |
| 2015-08-25 | ADRE | ETF | 29.42 | 29.9899 | 28.5601 | 28.5601 | 17347.0 |
| 2015-08-25 | AFK | ETF | 19.96 | 20.2399 | 19.26 | 19.26 | 138766.0 |
| 2015-08-25 | AFTY | ETF | 14.26 | 14.606 | 13.72 | 13.72 | 71800.0 |
| 2015-08-25 | AGG | ETF | 109.7 | 109.7 | 109.13 | 109.46 | 4070000.0 |
| 2015-08-25 | AGQ | ETF | 31.87 | 32.0 | 30.9 | 31.21 | 207500.0 |
| 2015-08-25 | AGZ | ETF | 113.51 | 113.81 | 113.4301 | 113.46 | 14262.0 |
| 2015-08-25 | AGZD | ETF | 24.08 | 24.08 | 23.9 | 23.945 | 35800.0 |
| 2015-08-25 | AIA | ETF | 41.73 | 43.23 | 40.74 | 40.74 | 149996.0 |
| 2015-08-25 | AIQ | ETF | 14.23 | 14.23 | 13.185 | 13.3 | 25168.0 |
| 2015-08-25 | AIRR | ETF | 16.53 | 16.53 | 15.48 | 15.519 | 10600.0 |
| 2015-08-25 | AIVI | ETF | 39.97 | 40.23 | 39.02 | 39.02 | 60100.0 |
| 2015-08-25 | ALTY | ETF | 14.17 | 14.17 | 14.17 | 14.17 | 100.0 |
| 2015-08-25 | AMJ | ETF | 34.36 | 35.05 | 33.77 | 33.79 | 4485773.0 |
| 2015-08-25 | AMLP | ETF | 70.75 | 71.85 | 68.95 | 68.95 | 1771420.0 |
| 2015-08-25 | AMZA | ETF | 153.1 | 157.15 | 150.1 | 150.1 | 2560.0 |
| 2015-08-25 | ANGL | ETF | 26.45 | 26.48 | 26.21 | 26.23 | 19500.0 |
| 2015-08-25 | AOA | ETF | 44.33 | 45.46 | 43.15 | 43.15 | 55600.0 |
| 2015-08-25 | AOK | ETF | 31.66 | 31.69 | 31.33 | 31.38 | 170968.0 |
| 2015-08-25 | AOM | ETF | 34.26 | 34.3 | 33.54 | 33.54 | 130499.0 |
| 2015-08-25 | AOR | ETF | 38.72 | 38.9999 | 37.79 | 37.93 | 107719.0 |
| 2015-08-25 | ARGT | ETF | 16.74 | 16.75 | 16.2 | 16.2 | 6200.0 |
| 2015-08-25 | ARKG | ETF | 20.0 | 20.2 | 19.93 | 19.93 | 4500.0 |
| 2015-08-25 | ARKK | ETF | 19.3 | 19.38 | 19.3 | 19.38 | 300.0 |
| 2015-08-25 | ARKQ | ETF | 18.02 | 18.02 | 17.25 | 17.25 | 4400.0 |
| 2015-08-25 | ARKW | ETF | 21.559 | 21.584 | 21.0 | 21.0 | 2000.0 |
| 2015-08-25 | ASEA | ETF | 12.65 | 12.65 | 12.3 | 12.3 | 8500.0 |
| 2015-08-25 | ASHR | ETF | 31.66 | 31.66 | 30.0 | 30.13 | 9649100.0 |
| 2015-08-25 | ASHS | ETF | 38.5 | 39.0 | 36.68 | 36.91 | 220700.0 |
| 2015-08-25 | ATMP | ETF | 23.42 | 23.55 | 22.8 | 22.84 | 110800.0 |
| 2015-08-25 | AWAY | ETF | 28.3 | 28.81 | 27.09 | 27.18 | 1700177.0 |
| 2015-08-25 | BAB | ETF | 29.27 | 29.27 | 28.96 | 28.9601 | 80415.0 |
| 2015-08-25 | BAL | ETF | 42.98 | 43.04 | 41.99 | 42.36 | 8228.0 |
| 2015-08-25 | BBC | ETF | 31.33 | 31.33 | 29.5 | 29.5 | 24266.0 |
| 2015-08-25 | BBH | ETF | 120.94 | 128.25 | 120.59 | 120.59 | 274400.0 |
| 2015-08-25 | BBP | ETF | 32.56 | 32.56 | 30.441 | 30.51 | 46400.0 |
| 2015-08-25 | BCM | ETF | 26.16 | 26.16 | 25.8604 | 25.8604 | 3035.0 |
| 2015-08-25 | BFOR | ETF | 7.59 | 7.6175 | 7.3625 | 7.365 | 78000.0 |
> showing 50 of 1,227 rows — these rows as CSV