PREVIEW / etf_daily / 2015-05-11
file: by_date/etf_daily/2015/2015-05-11.parquet size: 47 KB rows: 1,181
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-05-11 | SPY | ETF | 211.57 | 211.89 | 210.52 | 210.61 | 75708100.0 |
| 2015-05-11 | QQQ | ETF | 108.76 | 108.98 | 108.19 | 108.27 | 19679255.0 |
| 2015-05-11 | IWM | ETF | 122.6 | 123.66 | 122.44 | 122.71 | 28406700.0 |
| 2015-05-11 | DIA | ETF | 181.77 | 182.0 | 180.88 | 181.08 | 3753600.0 |
| 2015-05-11 | GLD | ETF | 114.09 | 114.31 | 113.08 | 113.53 | 2916700.0 |
| 2015-05-11 | TLT | ETF | 121.62 | 121.65 | 119.5 | 119.53 | 13738600.0 |
| 2015-05-11 | AADR | ETF | 40.5 | 40.51 | 40.36 | 40.36 | 1500.0 |
| 2015-05-11 | AAXJ | ETF | 67.42 | 67.69 | 67.04 | 67.06 | 793900.0 |
| 2015-05-11 | ACTX | ETF | 3.835 | 3.835 | 2.95 | 3.54 | 1197.0 |
| 2015-05-11 | ACWF | ETF | 25.2 | 25.2 | 25.17 | 25.18 | 2473.0 |
| 2015-05-11 | ACWI | ETF | 62.27 | 62.41 | 62.06 | 62.1 | 665900.0 |
| 2015-05-11 | ACWV | ETF | 73.37 | 73.45 | 73.01 | 73.04 | 118400.0 |
| 2015-05-11 | ACWX | ETF | 47.08 | 47.17 | 46.89 | 46.925 | 324544.0 |
| 2015-05-11 | ADRE | ETF | 37.53 | 37.53 | 37.132 | 37.18 | 3875.0 |
| 2015-05-11 | AFK | ETF | 26.65 | 26.79 | 26.42 | 26.42 | 18511.0 |
| 2015-05-11 | AFTY | ETF | 22.398 | 22.419 | 22.22 | 22.22 | 50200.0 |
| 2015-05-11 | AGG | ETF | 110.02 | 110.06 | 109.57 | 109.59 | 2984900.0 |
| 2015-05-11 | AGQ | ETF | 40.54 | 40.91 | 39.27 | 39.55 | 147500.0 |
| 2015-05-11 | AGZ | ETF | 113.34 | 113.34 | 113.04 | 113.08 | 19394.0 |
| 2015-05-11 | AGZD | ETF | 24.515 | 24.525 | 24.5 | 24.51 | 12800.0 |
| 2015-05-11 | AIA | ETF | 53.17 | 53.17 | 52.83 | 52.83 | 49133.0 |
| 2015-05-11 | AIQ | ETF | 20.69 | 21.17 | 20.66 | 20.77 | 11613.0 |
| 2015-05-11 | AIRR | ETF | 18.22 | 18.38 | 18.22 | 18.27 | 18600.0 |
| 2015-05-11 | AIVI | ETF | 46.19 | 46.36 | 46.14 | 46.26 | 19500.0 |
| 2015-05-11 | AMJ | ETF | 44.4 | 44.46 | 44.095 | 44.15 | 634396.0 |
| 2015-05-11 | AMLP | ETF | 84.75 | 84.9 | 84.3 | 84.4 | 591460.0 |
| 2015-05-11 | AMZA | ETF | 222.6 | 222.6 | 218.3 | 218.8 | 570.0 |
| 2015-05-11 | ANGL | ETF | 27.7 | 27.74 | 27.59 | 27.59 | 25400.0 |
| 2015-05-11 | AOA | ETF | 48.72 | 48.72 | 48.39 | 48.46 | 29600.0 |
| 2015-05-11 | AOK | ETF | 33.1 | 33.1 | 32.831 | 32.92 | 47570.0 |
| 2015-05-11 | AOM | ETF | 35.92 | 35.92 | 35.65 | 35.74 | 44318.0 |
| 2015-05-11 | AOR | ETF | 41.56 | 41.56 | 41.2601 | 41.33 | 70993.0 |
| 2015-05-11 | ARGT | ETF | 22.01 | 22.01 | 21.85 | 21.88 | 4600.0 |
| 2015-05-11 | ARKG | ETF | 23.47 | 23.47 | 23.0 | 23.08 | 4600.0 |
| 2015-05-11 | ARKK | ETF | 20.91 | 21.0 | 20.91 | 21.0 | 1300.0 |
| 2015-05-11 | ARKQ | ETF | 19.74 | 19.76 | 19.71 | 19.75 | 900.0 |
| 2015-05-11 | ARKW | ETF | 22.65 | 22.65 | 22.56 | 22.61 | 1400.0 |
| 2015-05-11 | ASEA | ETF | 16.0 | 16.0 | 15.83 | 15.83 | 16000.0 |
| 2015-05-11 | ASHR | ETF | 48.18 | 48.38 | 48.05 | 48.08 | 2133300.0 |
| 2015-05-11 | ASHS | ETF | 54.4 | 56.64 | 54.4 | 55.75 | 55400.0 |
| 2015-05-11 | ATMP | ETF | 30.06 | 30.06 | 29.78 | 29.86 | 15400.0 |
| 2015-05-11 | AWAY | ETF | 27.51 | 27.7799 | 27.17 | 27.24 | 574531.0 |
| 2015-05-11 | BAB | ETF | 29.4 | 29.4 | 29.11 | 29.11 | 217139.0 |
| 2015-05-11 | BAL | ETF | 44.1999 | 44.398 | 43.84 | 44.398 | 4201.0 |
| 2015-05-11 | BALT | ETF | 1.42 | 1.43 | 1.4 | 1.42 | 163029.0 |
| 2015-05-11 | BAR | ETF | 2.679 | 2.683 | 2.613 | 2.64 | 32370.0 |
| 2015-05-11 | BBC | ETF | 33.13 | 33.5 | 33.13 | 33.35 | 24895.0 |
| 2015-05-11 | BBH | ETF | 131.22 | 131.44 | 130.19 | 130.57 | 74100.0 |
| 2015-05-11 | BBP | ETF | 31.67 | 31.67 | 31.45 | 31.45 | 18000.0 |
| 2015-05-11 | BCHP | ETF | 20.59 | 20.59 | 20.48 | 20.48 | 500.0 |
> showing 50 of 1,181 rows — these rows as CSV