PREVIEW / etf_daily / 2015-08-26
file: by_date/etf_daily/2015/2015-08-26.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-08-26 | SPY | ETF | 192.08 | 194.79 | 188.37 | 194.46 | 339257000.0 |
| 2015-08-26 | QQQ | ETF | 100.96 | 103.23 | 98.93 | 103.03 | 104103817.0 |
| 2015-08-26 | IWM | ETF | 111.83 | 112.69 | 109.42 | 112.48 | 51605300.0 |
| 2015-08-26 | DIA | ETF | 160.39 | 162.9 | 157.67 | 162.66 | 19884300.0 |
| 2015-08-26 | GLD | ETF | 107.72 | 108.06 | 107.08 | 107.67 | 10856600.0 |
| 2015-08-26 | TLT | ETF | 123.0 | 123.51 | 121.36 | 121.93 | 16429900.0 |
| 2015-08-26 | AADR | ETF | 36.75 | 37.12 | 36.42 | 37.04 | 19100.0 |
| 2015-08-26 | AAXJ | ETF | 51.87 | 52.37 | 50.97 | 52.31 | 4026900.0 |
| 2015-08-26 | ACTX | ETF | 1.77 | 1.77 | 1.18 | 1.18 | 619.0 |
| 2015-08-26 | ACWI | ETF | 54.77 | 55.18 | 53.64 | 55.17 | 6846300.0 |
| 2015-08-26 | ACWV | ETF | 65.82 | 66.95 | 65.48 | 66.76 | 217700.0 |
| 2015-08-26 | ACWX | ETF | 40.32 | 40.38 | 39.4509 | 40.33 | 2120874.0 |
| 2015-08-26 | ADRE | ETF | 28.95 | 29.04 | 28.27 | 29.04 | 26702.0 |
| 2015-08-26 | AFK | ETF | 19.71 | 19.71 | 19.15 | 19.5 | 69580.0 |
| 2015-08-26 | AFTY | ETF | 13.5 | 14.1 | 13.42 | 14.1 | 67200.0 |
| 2015-08-26 | AGG | ETF | 109.08 | 109.41 | 108.88 | 108.95 | 3994200.0 |
| 2015-08-26 | AGQ | ETF | 29.42 | 29.42 | 28.4 | 29.32 | 460200.0 |
| 2015-08-26 | AGZ | ETF | 113.31 | 113.6196 | 113.22 | 113.25 | 21108.0 |
| 2015-08-26 | AGZD | ETF | 24.025 | 24.025 | 23.905 | 23.905 | 22200.0 |
| 2015-08-26 | AIA | ETF | 41.24 | 41.66 | 40.595 | 41.66 | 85006.0 |
| 2015-08-26 | AIQ | ETF | 13.52 | 13.63 | 12.72 | 13.61 | 28662.0 |
| 2015-08-26 | AIRR | ETF | 16.53 | 16.53 | 15.6 | 15.71 | 5200.0 |
| 2015-08-26 | AIVI | ETF | 39.95 | 39.95 | 39.0 | 39.8 | 29900.0 |
| 2015-08-26 | ALTY | ETF | 14.218 | 14.218 | 14.218 | 14.218 | 200.0 |
| 2015-08-26 | AMJ | ETF | 33.85 | 34.04 | 33.12 | 34.02 | 4922044.0 |
| 2015-08-26 | AMLP | ETF | 69.3 | 70.15 | 68.2 | 70.15 | 2829180.0 |
| 2015-08-26 | AMZA | ETF | 159.4 | 164.52 | 154.5 | 161.8 | 3170.0 |
| 2015-08-26 | ANGL | ETF | 26.43 | 26.43 | 26.09 | 26.41 | 15700.0 |
| 2015-08-26 | AOA | ETF | 44.36 | 44.36 | 43.36 | 44.2 | 56000.0 |
| 2015-08-26 | AOK | ETF | 31.74 | 31.74 | 31.41 | 31.63 | 34467.0 |
| 2015-08-26 | AOM | ETF | 33.94 | 34.07 | 33.64 | 34.07 | 83125.0 |
| 2015-08-26 | AOR | ETF | 38.37 | 38.51 | 37.9626 | 38.48 | 194675.0 |
| 2015-08-26 | ARGT | ETF | 16.66 | 16.67 | 16.59 | 16.59 | 700.0 |
| 2015-08-26 | ARKG | ETF | 20.39 | 20.39 | 19.845 | 20.38 | 1700.0 |
| 2015-08-26 | ARKK | ETF | 19.12 | 19.445 | 19.0 | 19.445 | 500.0 |
| 2015-08-26 | ARKQ | ETF | 17.59 | 17.59 | 17.46 | 17.46 | 700.0 |
| 2015-08-26 | ARKW | ETF | 21.115 | 21.315 | 20.84 | 21.3 | 1800.0 |
| 2015-08-26 | ASEA | ETF | 12.58 | 12.6 | 12.34 | 12.6 | 15100.0 |
| 2015-08-26 | ASHR | ETF | 29.48 | 30.4 | 28.84 | 30.34 | 10994400.0 |
| 2015-08-26 | ASHS | ETF | 35.95 | 36.16 | 34.0 | 36.06 | 267900.0 |
| 2015-08-26 | ATMP | ETF | 22.7 | 23.06 | 22.57 | 23.04 | 70400.0 |
| 2015-08-26 | AWAY | ETF | 27.97 | 28.08 | 26.77 | 28.05 | 1395016.0 |
| 2015-08-26 | BAB | ETF | 29.12 | 29.32 | 28.89 | 28.98 | 117042.0 |
| 2015-08-26 | BAL | ETF | 41.8068 | 41.8311 | 41.58 | 41.66 | 2799.0 |
| 2015-08-26 | BBC | ETF | 29.97 | 30.36 | 28.8 | 30.36 | 23680.0 |
| 2015-08-26 | BBH | ETF | 124.04 | 126.8 | 120.65 | 126.68 | 200100.0 |
| 2015-08-26 | BBP | ETF | 31.01 | 31.946 | 30.14 | 31.93 | 18200.0 |
| 2015-08-26 | BCHP | ETF | 17.34 | 17.41 | 17.1 | 17.41 | 4008.0 |
| 2015-08-26 | BCM | ETF | 25.67 | 25.67 | 25.6699 | 25.6699 | 916.0 |
| 2015-08-26 | BFOR | ETF | 7.4975 | 7.565 | 7.3775 | 7.56 | 43200.0 |
> showing 50 of 1,221 rows — these rows as CSV