PREVIEW / etf_daily / 2015-11-11
file: by_date/etf_daily/2015/2015-11-11.parquet size: 48 KB rows: 1,193
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-11 | SPY | ETF | 208.88 | 208.94 | 207.66 | 207.74 | 67846000.0 |
| 2015-11-11 | QQQ | ETF | 113.59 | 114.14 | 112.95 | 113.14 | 22748808.0 |
| 2015-11-11 | IWM | ETF | 118.31 | 118.34 | 117.08 | 117.14 | 22037600.0 |
| 2015-11-11 | DIA | ETF | 178.17 | 178.24 | 177.11 | 177.21 | 2860300.0 |
| 2015-11-11 | GLD | ETF | 104.09 | 104.23 | 103.78 | 103.83 | 3527600.0 |
| 2015-11-11 | TLT | ETF | 118.35 | 118.58 | 118.27 | 118.43 | 2857900.0 |
| 2015-11-11 | AADR | ETF | 36.88 | 38.4 | 36.88 | 38.4 | 1100.0 |
| 2015-11-11 | AAXJ | ETF | 55.78 | 55.82 | 55.52 | 55.56 | 708700.0 |
| 2015-11-11 | ACTX | ETF | 5.31 | 6.4901 | 4.72 | 5.9001 | 6484.0 |
| 2015-11-11 | ACWI | ETF | 58.09 | 58.09 | 57.7 | 57.7 | 1803300.0 |
| 2015-11-11 | ACWV | ETF | 69.99 | 70.03 | 69.75 | 69.77 | 319500.0 |
| 2015-11-11 | ACWX | ETF | 41.31 | 41.31 | 41.0799 | 41.13 | 307569.0 |
| 2015-11-11 | ADRE | ETF | 30.73 | 30.73 | 30.45 | 30.48 | 5179.0 |
| 2015-11-11 | AFK | ETF | 19.5497 | 19.66 | 19.5497 | 19.56 | 5558.0 |
| 2015-11-11 | AFTY | ETF | 17.379 | 17.45 | 17.29 | 17.36 | 147700.0 |
| 2015-11-11 | AGG | ETF | 108.32 | 108.37 | 108.24 | 108.24 | 1603400.0 |
| 2015-11-11 | AGQ | ETF | 29.59 | 29.59 | 29.11 | 29.22 | 313500.0 |
| 2015-11-11 | AGZ | ETF | 113.0 | 113.24 | 113.0 | 113.19 | 11167.0 |
| 2015-11-11 | AGZD | ETF | 24.01 | 24.04 | 24.01 | 24.04 | 1200.0 |
| 2015-11-11 | AIA | ETF | 45.18 | 45.38 | 44.94 | 44.95 | 12348.0 |
| 2015-11-11 | AIQ | ETF | 9.6 | 9.6 | 9.18 | 9.25 | 53168.0 |
| 2015-11-11 | AIRR | ETF | 17.139 | 17.2 | 17.015 | 17.15 | 8100.0 |
| 2015-11-11 | AIVI | ETF | 39.5 | 39.5 | 39.2 | 39.26 | 32300.0 |
| 2015-11-11 | ALTY | ETF | 14.282 | 14.282 | 14.282 | 14.282 | 300.0 |
| 2015-11-11 | AMJ | ETF | 32.38 | 32.65 | 31.63 | 31.91 | 1611583.0 |
| 2015-11-11 | AMLP | ETF | 65.25 | 65.55 | 63.4 | 64.1 | 2010260.0 |
| 2015-11-11 | AMZA | ETF | 137.7 | 137.7 | 132.2 | 134.5 | 1830.0 |
| 2015-11-11 | ANGL | ETF | 25.88 | 25.88 | 25.8 | 25.81 | 25800.0 |
| 2015-11-11 | AOA | ETF | 45.92 | 45.95 | 45.79 | 45.79 | 153000.0 |
| 2015-11-11 | AOK | ETF | 32.0 | 32.0 | 31.8931 | 31.9 | 58360.0 |
| 2015-11-11 | AOM | ETF | 34.6 | 34.6 | 34.4597 | 34.47 | 88812.0 |
| 2015-11-11 | AOR | ETF | 39.64 | 39.64 | 39.43 | 39.45 | 179413.0 |
| 2015-11-11 | ARGT | ETF | 19.3 | 19.38 | 19.25 | 19.38 | 5100.0 |
| 2015-11-11 | ARKG | ETF | 20.06 | 20.06 | 20.0 | 20.0 | 200.0 |
| 2015-11-11 | ARKK | ETF | 20.33 | 20.39 | 20.31 | 20.39 | 700.0 |
| 2015-11-11 | ARKQ | ETF | 19.146 | 19.146 | 19.146 | 19.146 | 500.0 |
| 2015-11-11 | ARKW | ETF | 23.88 | 23.88 | 23.37 | 23.44 | 1300.0 |
| 2015-11-11 | ASEA | ETF | 12.79 | 12.85 | 12.79 | 12.85 | 1300.0 |
| 2015-11-11 | ASHR | ETF | 38.48 | 38.6 | 38.23 | 38.3 | 3087500.0 |
| 2015-11-11 | ASHS | ETF | 47.2 | 47.27 | 46.52 | 47.0 | 86600.0 |
| 2015-11-11 | ASHX | ETF | 27.12 | 27.12 | 27.0101 | 27.0101 | 1080.0 |
| 2015-11-11 | ATMP | ETF | 20.96 | 21.11 | 20.85 | 21.09 | 138200.0 |
| 2015-11-11 | AWAY | ETF | 36.4 | 36.74 | 36.4 | 36.49 | 1619160.0 |
| 2015-11-11 | BAB | ETF | 28.74 | 28.76 | 28.705 | 28.76 | 49426.0 |
| 2015-11-11 | BAL | ETF | 41.41 | 41.41 | 41.4 | 41.41 | 691.0 |
| 2015-11-11 | BBC | ETF | 30.97 | 30.97 | 30.25 | 30.25 | 3634.0 |
| 2015-11-11 | BBH | ETF | 125.08 | 125.23 | 123.05 | 123.05 | 107500.0 |
| 2015-11-11 | BBP | ETF | 31.2 | 31.4 | 30.69 | 30.69 | 11800.0 |
| 2015-11-11 | BCM | ETF | 25.716 | 25.72 | 25.57 | 25.575 | 7244.0 |
| 2015-11-11 | BFOR | ETF | 7.9625 | 7.9625 | 7.8825 | 7.8875 | 44000.0 |
> showing 50 of 1,193 rows — these rows as CSV