PREVIEW / etf_daily / 2015-11-10
file: by_date/etf_daily/2015/2015-11-10.parquet size: 49 KB rows: 1,216
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-10 | SPY | ETF | 207.51 | 208.6 | 207.19 | 208.56 | 75874600.0 |
| 2015-11-10 | QQQ | ETF | 112.97 | 113.39 | 112.63 | 113.28 | 35452127.0 |
| 2015-11-10 | IWM | ETF | 117.32 | 118.17 | 116.96 | 118.17 | 21892200.0 |
| 2015-11-10 | DIA | ETF | 176.98 | 177.86 | 176.73 | 177.78 | 4837700.0 |
| 2015-11-10 | GLD | ETF | 104.09 | 104.65 | 103.87 | 104.18 | 4450800.0 |
| 2015-11-10 | TLT | ETF | 118.5 | 119.21 | 118.38 | 118.68 | 6712500.0 |
| 2015-11-10 | AADR | ETF | 37.99 | 38.27 | 37.99 | 38.27 | 1700.0 |
| 2015-11-10 | AAXJ | ETF | 55.61 | 55.62 | 55.34 | 55.47 | 820700.0 |
| 2015-11-10 | ACTX | ETF | 6.4901 | 7.0801 | 4.72 | 5.31 | 3969.0 |
| 2015-11-10 | ACWF | ETF | 23.6488 | 23.72 | 23.6488 | 23.71 | 842.0 |
| 2015-11-10 | ACWI | ETF | 57.6 | 57.8 | 57.44 | 57.8 | 913300.0 |
| 2015-11-10 | ACWV | ETF | 69.4 | 69.71 | 69.39 | 69.58 | 123600.0 |
| 2015-11-10 | ACWX | ETF | 40.84 | 41.01 | 40.7705 | 40.99 | 537186.0 |
| 2015-11-10 | ADRE | ETF | 30.42 | 30.61 | 30.18 | 30.5983 | 33192.0 |
| 2015-11-10 | AFK | ETF | 19.67 | 19.67 | 19.44 | 19.55 | 30901.0 |
| 2015-11-10 | AFTY | ETF | 17.23 | 17.26 | 17.2 | 17.22 | 4700.0 |
| 2015-11-10 | AGG | ETF | 108.29 | 108.48 | 108.2 | 108.38 | 5233200.0 |
| 2015-11-10 | AGQ | ETF | 29.45 | 29.88 | 29.29 | 29.7 | 418100.0 |
| 2015-11-10 | AGZ | ETF | 112.99 | 113.29 | 112.976 | 113.06 | 15601.0 |
| 2015-11-10 | AGZD | ETF | 24.04 | 24.11 | 24.04 | 24.11 | 2600.0 |
| 2015-11-10 | AIA | ETF | 44.83 | 44.89 | 44.7001 | 44.85 | 15268.0 |
| 2015-11-10 | AIQ | ETF | 9.6 | 9.675 | 9.36 | 9.57 | 62003.0 |
| 2015-11-10 | AIRR | ETF | 17.049 | 17.128 | 17.049 | 17.095 | 2500.0 |
| 2015-11-10 | AIVI | ETF | 39.11 | 39.31 | 39.04 | 39.27 | 31100.0 |
| 2015-11-10 | AMJ | ETF | 32.26 | 32.66 | 32.2 | 32.48 | 2181084.0 |
| 2015-11-10 | AMLP | ETF | 65.2 | 65.75 | 64.8 | 65.2 | 2006080.0 |
| 2015-11-10 | AMZA | ETF | 139.5 | 139.5 | 135.61 | 138.32 | 490.0 |
| 2015-11-10 | ANGL | ETF | 25.83 | 25.9 | 25.8 | 25.9 | 47900.0 |
| 2015-11-10 | AOA | ETF | 45.65 | 45.79 | 45.58 | 45.72 | 46100.0 |
| 2015-11-10 | AOK | ETF | 31.88 | 31.95 | 31.84 | 31.91 | 61132.0 |
| 2015-11-10 | AOM | ETF | 34.44 | 34.49 | 34.3601 | 34.46 | 116560.0 |
| 2015-11-10 | AOR | ETF | 39.28 | 39.45 | 39.26 | 39.42 | 306480.0 |
| 2015-11-10 | ARGT | ETF | 19.26 | 19.29 | 19.15 | 19.26 | 2500.0 |
| 2015-11-10 | ARKG | ETF | 20.13 | 20.13 | 20.13 | 20.13 | 200.0 |
| 2015-11-10 | ARKK | ETF | 20.44 | 20.44 | 20.433 | 20.433 | 200.0 |
| 2015-11-10 | ARKQ | ETF | 19.14 | 19.16 | 19.14 | 19.16 | 300.0 |
| 2015-11-10 | ARKW | ETF | 23.54 | 23.54 | 23.23 | 23.23 | 4100.0 |
| 2015-11-10 | ASEA | ETF | 12.79 | 12.79 | 12.73 | 12.73 | 800.0 |
| 2015-11-10 | ASHR | ETF | 38.07 | 38.27 | 37.99 | 38.17 | 843200.0 |
| 2015-11-10 | ASHS | ETF | 46.0 | 46.01 | 45.69 | 45.81 | 44100.0 |
| 2015-11-10 | ASHX | ETF | 26.76 | 26.83 | 26.76 | 26.83 | 1359.0 |
| 2015-11-10 | ATMP | ETF | 21.63 | 21.63 | 21.44 | 21.51 | 195600.0 |
| 2015-11-10 | AWAY | ETF | 36.52 | 36.74 | 36.27 | 36.39 | 2409139.0 |
| 2015-11-10 | BAB | ETF | 28.71 | 28.835 | 28.6701 | 28.74 | 81742.0 |
| 2015-11-10 | BAL | ETF | 41.18 | 41.82 | 41.128 | 41.25 | 9142.0 |
| 2015-11-10 | BBC | ETF | 30.8 | 30.8 | 30.03 | 30.57 | 7838.0 |
| 2015-11-10 | BBH | ETF | 124.44 | 125.0 | 123.76 | 124.79 | 84600.0 |
| 2015-11-10 | BBP | ETF | 31.35 | 31.407 | 30.69 | 31.37 | 16900.0 |
| 2015-11-10 | BCM | ETF | 25.907 | 25.907 | 25.801 | 25.8336 | 3003.0 |
| 2015-11-10 | BFOR | ETF | 7.905 | 7.95 | 7.88 | 7.93 | 48400.0 |
> showing 50 of 1,216 rows — these rows as CSV