PREVIEW / etf_daily / 2015-11-05
file: by_date/etf_daily/2015/2015-11-05.parquet size: 49 KB rows: 1,211
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-05 | SPY | ETF | 210.43 | 210.98 | 209.09 | 210.15 | 78408700.0 |
| 2015-11-05 | QQQ | ETF | 115.12 | 115.395 | 114.11 | 114.71 | 25004080.0 |
| 2015-11-05 | IWM | ETF | 118.24 | 118.6 | 117.09 | 118.38 | 27141300.0 |
| 2015-11-05 | DIA | ETF | 178.75 | 179.25 | 177.73 | 178.64 | 5008100.0 |
| 2015-11-05 | GLD | ETF | 106.01 | 106.1 | 105.58 | 105.64 | 5931100.0 |
| 2015-11-05 | TLT | ETF | 121.05 | 121.06 | 120.3 | 120.77 | 7268400.0 |
| 2015-11-05 | AADR | ETF | 40.0 | 40.0 | 38.87 | 38.92 | 3400.0 |
| 2015-11-05 | AAXJ | ETF | 57.76 | 58.0 | 57.48 | 57.78 | 1784700.0 |
| 2015-11-05 | ACTX | ETF | 8.2601 | 10.6201 | 7.6701 | 8.2601 | 5238.0 |
| 2015-11-05 | ACWI | ETF | 58.77 | 58.83 | 58.36 | 58.57 | 2031500.0 |
| 2015-11-05 | ACWV | ETF | 70.89 | 70.97 | 70.6 | 70.88 | 41600.0 |
| 2015-11-05 | ACWX | ETF | 42.0 | 42.05 | 41.76 | 41.88 | 2817704.0 |
| 2015-11-05 | ADRE | ETF | 31.77 | 31.83 | 31.5588 | 31.71 | 8705.0 |
| 2015-11-05 | AFK | ETF | 20.52 | 20.53 | 20.261 | 20.48 | 66032.0 |
| 2015-11-05 | AFTY | ETF | 17.05 | 17.05 | 16.825 | 16.91 | 46000.0 |
| 2015-11-05 | AGG | ETF | 108.87 | 108.89 | 108.6 | 108.77 | 2185900.0 |
| 2015-11-05 | AGQ | ETF | 32.21 | 32.46 | 31.91 | 32.14 | 140700.0 |
| 2015-11-05 | AGZ | ETF | 113.42 | 113.426 | 113.18 | 113.33 | 30470.0 |
| 2015-11-05 | AGZD | ETF | 24.065 | 24.09 | 24.05 | 24.05 | 10800.0 |
| 2015-11-05 | AIA | ETF | 46.34 | 46.52 | 46.2 | 46.4 | 13786.0 |
| 2015-11-05 | AIQ | ETF | 9.26 | 9.54 | 8.99 | 9.33 | 64119.0 |
| 2015-11-05 | AIRR | ETF | 17.101 | 17.272 | 17.101 | 17.24 | 4000.0 |
| 2015-11-05 | AIVI | ETF | 40.57 | 40.57 | 40.3 | 40.38 | 17800.0 |
| 2015-11-05 | ALTY | ETF | 14.549 | 14.549 | 14.549 | 14.549 | 100.0 |
| 2015-11-05 | AMJ | ETF | 33.48 | 34.06 | 32.95 | 33.34 | 3138953.0 |
| 2015-11-05 | AMLP | ETF | 68.7 | 69.75 | 67.6 | 68.6 | 1292420.0 |
| 2015-11-05 | AMZA | ETF | 144.5 | 146.0 | 141.3 | 142.1 | 1690.0 |
| 2015-11-05 | ANGL | ETF | 26.07 | 26.07 | 26.0 | 26.04 | 7500.0 |
| 2015-11-05 | AOA | ETF | 46.45 | 46.45 | 46.19 | 46.29 | 51200.0 |
| 2015-11-05 | AOK | ETF | 32.11 | 32.195 | 32.0907 | 32.11 | 91707.0 |
| 2015-11-05 | AOM | ETF | 34.85 | 34.85 | 34.6601 | 34.76 | 115415.0 |
| 2015-11-05 | AOR | ETF | 39.77 | 39.93 | 39.72 | 39.82 | 90810.0 |
| 2015-11-05 | ARGT | ETF | 19.5 | 19.63 | 19.45 | 19.48 | 8000.0 |
| 2015-11-05 | ARKG | ETF | 20.3 | 20.3 | 20.219 | 20.219 | 400.0 |
| 2015-11-05 | ARKK | ETF | 20.66 | 20.66 | 20.66 | 20.66 | 100.0 |
| 2015-11-05 | ARKQ | ETF | 19.29 | 19.29 | 19.29 | 19.29 | 100.0 |
| 2015-11-05 | ARKW | ETF | 23.3 | 23.42 | 23.285 | 23.42 | 500.0 |
| 2015-11-05 | ASEA | ETF | 13.19 | 13.23 | 13.19 | 13.22 | 3700.0 |
| 2015-11-05 | ASHR | ETF | 37.13 | 37.3 | 36.98 | 37.1 | 2081000.0 |
| 2015-11-05 | ASHS | ETF | 44.93 | 44.93 | 44.22 | 44.24 | 46800.0 |
| 2015-11-05 | ASHX | ETF | 25.97 | 26.0899 | 25.97 | 26.0899 | 1590.0 |
| 2015-11-05 | ATMP | ETF | 22.57 | 22.71 | 21.92 | 22.13 | 157000.0 |
| 2015-11-05 | AWAY | ETF | 39.55 | 40.76 | 39.17 | 40.15 | 24671418.0 |
| 2015-11-05 | BAB | ETF | 29.06 | 29.08 | 28.97 | 29.05 | 58583.0 |
| 2015-11-05 | BAL | ETF | 41.29 | 41.52 | 41.22 | 41.52 | 16535.0 |
| 2015-11-05 | BBC | ETF | 30.24 | 30.24 | 29.27 | 29.7 | 3317.0 |
| 2015-11-05 | BBH | ETF | 126.21 | 126.21 | 123.79 | 125.11 | 141000.0 |
| 2015-11-05 | BBP | ETF | 31.61 | 31.83 | 31.232 | 31.661 | 10000.0 |
| 2015-11-05 | BCM | ETF | 26.32 | 26.32 | 26.313 | 26.3199 | 4558.0 |
| 2015-11-05 | BDCZ | ETF | 20.62 | 20.62 | 20.62 | 20.62 | 200.0 |
> showing 50 of 1,211 rows — these rows as CSV