PREVIEW / etf_daily / 2015-04-16
file: by_date/etf_daily/2015/2015-04-16.parquet size: 47 KB rows: 1,167
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-04-16 | SPY | ETF | 210.03 | 210.98 | 209.79 | 210.37 | 68934900.0 |
| 2015-04-16 | QQQ | ETF | 107.55 | 107.88 | 107.4 | 107.69 | 16195279.0 |
| 2015-04-16 | IWM | ETF | 126.47 | 126.75 | 126.16 | 126.48 | 24439900.0 |
| 2015-04-16 | DIA | ETF | 180.67 | 181.51 | 180.43 | 180.91 | 3873900.0 |
| 2015-04-16 | GLD | ETF | 115.55 | 115.66 | 114.64 | 115.03 | 3132300.0 |
| 2015-04-16 | TLT | ETF | 130.83 | 130.86 | 129.41 | 129.96 | 7085500.0 |
| 2015-04-16 | AADR | ETF | 40.31 | 40.35 | 40.11 | 40.23 | 5600.0 |
| 2015-04-16 | AAXJ | ETF | 68.67 | 69.28 | 68.54 | 69.03 | 1985100.0 |
| 2015-04-16 | ACWI | ETF | 62.02 | 62.36 | 61.93 | 62.19 | 483200.0 |
| 2015-04-16 | ACWV | ETF | 73.38 | 73.56 | 73.17 | 73.42 | 144900.0 |
| 2015-04-16 | ACWX | ETF | 46.87 | 47.1599 | 46.78 | 47.05 | 174142.0 |
| 2015-04-16 | ADRE | ETF | 37.18 | 37.41 | 37.11 | 37.3113 | 5189.0 |
| 2015-04-16 | AFK | ETF | 26.49 | 26.7 | 26.41 | 26.54 | 18636.0 |
| 2015-04-16 | AFTY | ETF | 22.19 | 22.78 | 22.19 | 22.7 | 47700.0 |
| 2015-04-16 | AGG | ETF | 111.7 | 111.7 | 111.4 | 111.58 | 1000800.0 |
| 2015-04-16 | AGQ | ETF | 40.45 | 40.54 | 39.07 | 39.75 | 127900.0 |
| 2015-04-16 | AGZ | ETF | 114.46 | 114.47 | 114.23 | 114.27 | 19011.0 |
| 2015-04-16 | AGZD | ETF | 24.54 | 24.55 | 24.495 | 24.5 | 2800.0 |
| 2015-04-16 | AIA | ETF | 53.79 | 54.1499 | 53.55 | 54.07 | 29097.0 |
| 2015-04-16 | AIQ | ETF | 23.96 | 24.05 | 23.775 | 24.04 | 11059.0 |
| 2015-04-16 | AIRR | ETF | 19.299 | 19.299 | 19.183 | 19.183 | 1100.0 |
| 2015-04-16 | AIVI | ETF | 45.53 | 45.71 | 45.36 | 45.58 | 73700.0 |
| 2015-04-16 | AMJ | ETF | 44.5 | 44.705 | 44.26 | 44.59 | 795161.0 |
| 2015-04-16 | AMLP | ETF | 84.9 | 85.2 | 84.5 | 85.1 | 1058580.0 |
| 2015-04-16 | AMZA | ETF | 223.1 | 223.1 | 218.7 | 220.72 | 950.0 |
| 2015-04-16 | ANGL | ETF | 27.55 | 27.65 | 27.55 | 27.65 | 18000.0 |
| 2015-04-16 | AOA | ETF | 48.54 | 48.71 | 48.42 | 48.61 | 29700.0 |
| 2015-04-16 | AOK | ETF | 33.3 | 33.36 | 33.26 | 33.32 | 15062.0 |
| 2015-04-16 | AOM | ETF | 36.02 | 36.12 | 35.97 | 36.12 | 43555.0 |
| 2015-04-16 | AOR | ETF | 41.41 | 41.6599 | 41.41 | 41.54 | 63807.0 |
| 2015-04-16 | ARGT | ETF | 22.26 | 22.26 | 21.82 | 22.0 | 7000.0 |
| 2015-04-16 | ARKG | ETF | 23.725 | 23.81 | 23.725 | 23.789 | 3900.0 |
| 2015-04-16 | ARKK | ETF | 21.82 | 21.86 | 21.82 | 21.84 | 1700.0 |
| 2015-04-16 | ARKQ | ETF | 20.651 | 20.674 | 20.59 | 20.63 | 2300.0 |
| 2015-04-16 | ARKW | ETF | 22.098 | 22.94 | 22.098 | 22.88 | 3300.0 |
| 2015-04-16 | ASEA | ETF | 16.16 | 16.26 | 16.16 | 16.26 | 3500.0 |
| 2015-04-16 | ASHR | ETF | 46.59 | 46.92 | 46.56 | 46.8 | 2300400.0 |
| 2015-04-16 | ASHS | ETF | 51.62 | 52.54 | 51.62 | 52.08 | 162900.0 |
| 2015-04-16 | ATMP | ETF | 30.2 | 30.47 | 29.48 | 30.39 | 28000.0 |
| 2015-04-16 | AWAY | ETF | 32.42 | 32.79 | 31.96 | 32.78 | 1435056.0 |
| 2015-04-16 | BAB | ETF | 30.49 | 30.49 | 30.26 | 30.4 | 75508.0 |
| 2015-04-16 | BAL | ETF | 43.54 | 44.11 | 43.35 | 44.109 | 43264.0 |
| 2015-04-16 | BALT | ETF | 1.38 | 1.44 | 1.3601 | 1.43 | 516381.0 |
| 2015-04-16 | BAR | ETF | 2.773 | 2.773 | 2.759 | 2.759 | 10200.0 |
| 2015-04-16 | BBC | ETF | 34.87 | 35.3495 | 34.71 | 35.12 | 17144.0 |
| 2015-04-16 | BBH | ETF | 134.21 | 135.16 | 133.69 | 134.43 | 54800.0 |
| 2015-04-16 | BBP | ETF | 33.76 | 33.76 | 33.114 | 33.32 | 26300.0 |
| 2015-04-16 | BCHP | ETF | 19.99 | 20.02 | 19.99 | 20.02 | 460.0 |
| 2015-04-16 | BCM | ETF | 31.71 | 31.9099 | 31.71 | 31.869 | 1205.0 |
| 2015-04-16 | BFOR | ETF | 8.5 | 8.535 | 8.495 | 8.5125 | 54400.0 |
> showing 50 of 1,167 rows — these rows as CSV