PREVIEW / etf_daily / 2015-07-13
file: by_date/etf_daily/2015/2015-07-13.parquet size: 48 KB rows: 1,189
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-07-13 | SPY | ETF | 208.99 | 209.9 | 208.94 | 209.77 | 106069400.0 |
| 2015-07-13 | QQQ | ETF | 108.58 | 109.63 | 108.57 | 109.54 | 25780733.0 |
| 2015-07-13 | IWM | ETF | 124.77 | 125.64 | 124.75 | 125.53 | 21349900.0 |
| 2015-07-13 | DIA | ETF | 178.83 | 179.7 | 178.8 | 179.6 | 3873800.0 |
| 2015-07-13 | GLD | ETF | 110.43 | 111.14 | 110.36 | 110.99 | 4279300.0 |
| 2015-07-13 | TLT | ETF | 115.39 | 116.46 | 115.39 | 115.69 | 8006700.0 |
| 2015-07-13 | AADR | ETF | 39.42 | 39.42 | 39.16 | 39.16 | 600.0 |
| 2015-07-13 | AAXJ | ETF | 62.0 | 62.13 | 61.41 | 61.55 | 2693500.0 |
| 2015-07-13 | ACTX | ETF | 1.77 | 1.77 | 1.18 | 1.77 | 351.0 |
| 2015-07-13 | ACWI | ETF | 60.0 | 60.23 | 60.0 | 60.18 | 973300.0 |
| 2015-07-13 | ACWV | ETF | 70.8 | 71.15 | 70.65 | 70.93 | 111300.0 |
| 2015-07-13 | ACWX | ETF | 44.41 | 44.71 | 44.39 | 44.45 | 237308.0 |
| 2015-07-13 | ADRE | ETF | 34.23 | 34.46 | 34.23 | 34.46 | 6840.0 |
| 2015-07-13 | AFK | ETF | 23.25 | 23.51 | 23.01 | 23.26 | 8647.0 |
| 2015-07-13 | AFTY | ETF | 20.6 | 20.73 | 20.45 | 20.68 | 508800.0 |
| 2015-07-13 | AGG | ETF | 108.24 | 108.37 | 108.14 | 108.22 | 1938300.0 |
| 2015-07-13 | AGQ | ETF | 34.81 | 35.6 | 34.68 | 35.43 | 126200.0 |
| 2015-07-13 | AGZ | ETF | 112.8 | 113.1065 | 112.8 | 113.05 | 15463.0 |
| 2015-07-13 | AGZD | ETF | 24.32 | 24.46 | 24.32 | 24.46 | 16600.0 |
| 2015-07-13 | AIA | ETF | 48.8 | 48.97 | 48.75 | 48.81 | 43207.0 |
| 2015-07-13 | AIQ | ETF | 17.0 | 17.46 | 16.98 | 17.23 | 25044.0 |
| 2015-07-13 | AIRR | ETF | 18.08 | 18.23 | 18.08 | 18.2 | 14100.0 |
| 2015-07-13 | AIVI | ETF | 43.06 | 43.13 | 42.99 | 43.06 | 11900.0 |
| 2015-07-13 | AMJ | ETF | 40.16 | 40.5 | 40.04 | 40.34 | 2398170.0 |
| 2015-07-13 | AMLP | ETF | 79.25 | 79.8 | 78.75 | 79.25 | 866520.0 |
| 2015-07-13 | AMZA | ETF | 195.3 | 201.0 | 192.5 | 196.1 | 1090.0 |
| 2015-07-13 | ANGL | ETF | 27.08 | 27.09 | 26.92 | 27.01 | 69400.0 |
| 2015-07-13 | AOA | ETF | 48.04 | 48.04 | 47.24 | 47.43 | 45700.0 |
| 2015-07-13 | AOK | ETF | 32.49 | 32.49 | 32.28 | 32.3745 | 97076.0 |
| 2015-07-13 | AOM | ETF | 35.21 | 35.21 | 34.9917 | 35.1 | 49376.0 |
| 2015-07-13 | AOR | ETF | 41.09 | 41.19 | 40.4 | 40.51 | 58283.0 |
| 2015-07-13 | ARGT | ETF | 19.65 | 19.76 | 19.58 | 19.59 | 10100.0 |
| 2015-07-13 | ARKG | ETF | 22.91 | 23.25 | 22.91 | 23.22 | 2700.0 |
| 2015-07-13 | ARKK | ETF | 21.31 | 21.44 | 21.31 | 21.44 | 3200.0 |
| 2015-07-13 | ARKQ | ETF | 19.68 | 19.79 | 19.66 | 19.79 | 1800.0 |
| 2015-07-13 | ARKW | ETF | 23.15 | 23.24 | 23.15 | 23.215 | 2000.0 |
| 2015-07-13 | ASEA | ETF | 14.93 | 14.97 | 14.93 | 14.95 | 3200.0 |
| 2015-07-13 | ASHR | ETF | 43.27 | 43.38 | 42.48 | 42.86 | 5634200.0 |
| 2015-07-13 | ASHS | ETF | 56.6 | 56.6 | 50.55 | 50.75 | 257300.0 |
| 2015-07-13 | ATMP | ETF | 27.26 | 27.5 | 27.26 | 27.37 | 27100.0 |
| 2015-07-13 | AWAY | ETF | 30.92 | 31.41 | 30.77 | 31.34 | 970064.0 |
| 2015-07-13 | BAB | ETF | 28.52 | 28.72 | 28.52 | 28.56 | 124753.0 |
| 2015-07-13 | BAL | ETF | 43.89 | 44.02 | 43.657 | 44.02 | 18132.0 |
| 2015-07-13 | BALT | ETF | 1.52 | 1.58 | 1.5 | 1.53 | 222437.0 |
| 2015-07-13 | BBC | ETF | 37.25 | 37.812 | 37.25 | 37.67 | 46566.0 |
| 2015-07-13 | BBH | ETF | 136.34 | 137.22 | 136.23 | 136.97 | 158900.0 |
| 2015-07-13 | BBP | ETF | 35.25 | 36.126 | 35.166 | 35.94 | 46400.0 |
| 2015-07-13 | BCHP | ETF | 13.27 | 19.52 | 13.27 | 19.52 | 1426.0 |
| 2015-07-13 | BCM | ETF | 30.325 | 30.33 | 30.325 | 30.33 | 2388.0 |
| 2015-07-13 | BFOR | ETF | 8.345 | 8.375 | 8.3375 | 8.375 | 36800.0 |
> showing 50 of 1,189 rows — these rows as CSV