PREVIEW / etf_daily / 2015-05-15
file: by_date/etf_daily/2015/2015-05-15.parquet size: 48 KB rows: 1,173
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-15 | SPY | ETF | 212.44 | 212.61 | 211.86 | 212.44 | 76510100.0 |
| 2015-05-15 | QQQ | ETF | 109.86 | 110.01 | 109.31 | 109.58 | 23937442.0 |
| 2015-05-15 | IWM | ETF | 123.56 | 123.72 | 122.94 | 123.65 | 22055600.0 |
| 2015-05-15 | DIA | ETF | 182.24 | 182.51 | 181.89 | 182.48 | 4522200.0 |
| 2015-05-15 | GLD | ETF | 116.8 | 117.63 | 116.68 | 117.53 | 4447300.0 |
| 2015-05-15 | TLT | ETF | 120.38 | 121.91 | 120.29 | 121.59 | 12630600.0 |
| 2015-05-15 | AADR | ETF | 40.75 | 40.75 | 40.7 | 40.7 | 900.0 |
| 2015-05-15 | AAXJ | ETF | 67.52 | 68.0 | 67.44 | 68.0 | 1150000.0 |
| 2015-05-15 | ACTX | ETF | 2.36 | 3.54 | 2.36 | 3.54 | 1056.0 |
| 2015-05-15 | ACWF | ETF | 25.39 | 25.46 | 25.381 | 25.46 | 767.0 |
| 2015-05-15 | ACWI | ETF | 62.73 | 62.93 | 62.62 | 62.91 | 595000.0 |
| 2015-05-15 | ACWV | ETF | 73.58 | 73.97 | 73.58 | 73.94 | 121400.0 |
| 2015-05-15 | ACWX | ETF | 47.46 | 47.76 | 47.43 | 47.76 | 245067.0 |
| 2015-05-15 | ADRE | ETF | 37.3 | 37.68 | 37.2894 | 37.65 | 7779.0 |
| 2015-05-15 | AFK | ETF | 26.89 | 26.89 | 26.65 | 26.8 | 12915.0 |
| 2015-05-15 | AFTY | ETF | 21.59 | 21.7 | 21.53 | 21.7 | 135100.0 |
| 2015-05-15 | AGG | ETF | 109.96 | 110.22 | 109.88 | 110.2 | 1047500.0 |
| 2015-05-15 | AGQ | ETF | 45.46 | 45.97 | 45.17 | 45.72 | 181700.0 |
| 2015-05-15 | AGZ | ETF | 113.31 | 113.52 | 113.31 | 113.42 | 8543.0 |
| 2015-05-15 | AGZD | ETF | 24.46 | 24.53 | 24.27 | 24.395 | 15200.0 |
| 2015-05-15 | AIA | ETF | 53.15 | 53.5 | 53.15 | 53.46 | 26681.0 |
| 2015-05-15 | AIQ | ETF | 20.96 | 21.7792 | 20.96 | 21.2 | 10150.0 |
| 2015-05-15 | AIRR | ETF | 18.32 | 18.4 | 18.24 | 18.381 | 13100.0 |
| 2015-05-15 | AIVI | ETF | 46.95 | 47.18 | 46.91 | 47.18 | 11700.0 |
| 2015-05-15 | AMJ | ETF | 45.06 | 45.36 | 44.9 | 45.06 | 1715042.0 |
| 2015-05-15 | AMLP | ETF | 84.45 | 84.65 | 84.1 | 84.4 | 854840.0 |
| 2015-05-15 | AMZA | ETF | 225.4 | 226.8 | 222.3 | 225.0 | 4740.0 |
| 2015-05-15 | ANGL | ETF | 27.61 | 27.61 | 27.59 | 27.61 | 12600.0 |
| 2015-05-15 | AOA | ETF | 49.0 | 49.05 | 48.83 | 49.0 | 16100.0 |
| 2015-05-15 | AOK | ETF | 33.01 | 33.18 | 33.01 | 33.12 | 64721.0 |
| 2015-05-15 | AOM | ETF | 36.02 | 36.07 | 35.89 | 36.07 | 81475.0 |
| 2015-05-15 | AOR | ETF | 41.77 | 41.77 | 41.58 | 41.69 | 64747.0 |
| 2015-05-15 | ARGT | ETF | 22.15 | 22.35 | 22.15 | 22.21 | 21800.0 |
| 2015-05-15 | ARKG | ETF | 22.82 | 22.9 | 22.814 | 22.9 | 1800.0 |
| 2015-05-15 | ARKK | ETF | 21.13 | 21.132 | 21.13 | 21.132 | 400.0 |
| 2015-05-15 | ARKQ | ETF | 19.91 | 19.925 | 19.91 | 19.925 | 1000.0 |
| 2015-05-15 | ARKW | ETF | 22.9 | 22.95 | 22.9 | 22.95 | 500.0 |
| 2015-05-15 | ASEA | ETF | 16.02 | 16.1 | 16.0 | 16.1 | 7300.0 |
| 2015-05-15 | ASHR | ETF | 47.51 | 47.84 | 47.51 | 47.72 | 1906000.0 |
| 2015-05-15 | ASHS | ETF | 57.47 | 57.62 | 57.09 | 57.45 | 31900.0 |
| 2015-05-15 | ATMP | ETF | 30.44 | 30.69 | 30.43 | 30.66 | 27700.0 |
| 2015-05-15 | AWAY | ETF | 27.91 | 28.32 | 27.86 | 28.145 | 1018812.0 |
| 2015-05-15 | BAB | ETF | 29.08 | 29.25 | 29.0248 | 29.19 | 76713.0 |
| 2015-05-15 | BAL | ETF | 45.32 | 45.429 | 45.17 | 45.28 | 5535.0 |
| 2015-05-15 | BALT | ETF | 1.52 | 1.52 | 1.47 | 1.5 | 179205.0 |
| 2015-05-15 | BAR | ETF | 2.825 | 2.895 | 2.825 | 2.8937 | 8090.0 |
| 2015-05-15 | BBC | ETF | 32.76 | 33.229 | 32.76 | 33.19 | 8621.0 |
| 2015-05-15 | BBH | ETF | 132.0 | 132.69 | 131.49 | 132.28 | 93900.0 |
| 2015-05-15 | BBP | ETF | 31.49 | 31.649 | 31.46 | 31.64 | 5500.0 |
| 2015-05-15 | BCM | ETF | 32.55 | 32.73 | 32.55 | 32.72 | 3542.0 |
> showing 50 of 1,173 rows — these rows as CSV