PREVIEW / etf_daily / 2015-06-26
file: by_date/etf_daily/2015/2015-06-26.parquet size: 48 KB rows: 1,192
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-06-26 | SPY | ETF | 210.29 | 210.58 | 209.16 | 209.82 | 104174800.0 |
| 2015-06-26 | QQQ | ETF | 109.98 | 110.23 | 108.86 | 109.27 | 32311679.0 |
| 2015-06-26 | IWM | ETF | 128.1 | 128.34 | 126.82 | 127.5 | 38219900.0 |
| 2015-06-26 | DIA | ETF | 179.21 | 179.83 | 178.68 | 179.13 | 4855500.0 |
| 2015-06-26 | GLD | ETF | 112.2 | 112.68 | 112.13 | 112.56 | 4392600.0 |
| 2015-06-26 | TLT | ETF | 115.67 | 115.87 | 114.88 | 115.23 | 11673000.0 |
| 2015-06-26 | AADR | ETF | 39.82 | 39.86 | 39.73 | 39.73 | 1500.0 |
| 2015-06-26 | AAXJ | ETF | 63.97 | 64.07 | 63.69 | 63.73 | 401600.0 |
| 2015-06-26 | ACWF | ETF | 24.99 | 24.99 | 24.99 | 24.99 | 1900.0 |
| 2015-06-26 | ACWI | ETF | 61.04 | 61.12 | 60.72 | 60.9 | 1064800.0 |
| 2015-06-26 | ACWV | ETF | 70.65 | 70.82 | 70.5 | 70.55 | 285900.0 |
| 2015-06-26 | ACWX | ETF | 45.47 | 45.63 | 45.37 | 45.47 | 132509.0 |
| 2015-06-26 | ADRE | ETF | 35.63 | 35.6431 | 35.37 | 35.4409 | 7625.0 |
| 2015-06-26 | AFK | ETF | 24.76 | 24.87 | 24.61 | 24.61 | 13068.0 |
| 2015-06-26 | AFTY | ETF | 19.99 | 19.99 | 19.15 | 19.2 | 61400.0 |
| 2015-06-26 | AGG | ETF | 108.29 | 108.31 | 108.11 | 108.21 | 1054900.0 |
| 2015-06-26 | AGQ | ETF | 36.7 | 37.09 | 36.51 | 36.93 | 227200.0 |
| 2015-06-26 | AGZ | ETF | 112.82 | 112.89 | 112.697 | 112.83 | 15004.0 |
| 2015-06-26 | AGZD | ETF | 24.33 | 24.385 | 24.3 | 24.3 | 20800.0 |
| 2015-06-26 | AIA | ETF | 50.97 | 51.1349 | 50.758 | 50.8 | 27290.0 |
| 2015-06-26 | AIQ | ETF | 19.92 | 20.06 | 19.57 | 19.62 | 47106.0 |
| 2015-06-26 | AIRR | ETF | 18.578 | 18.629 | 18.55 | 18.6 | 6000.0 |
| 2015-06-26 | AIVI | ETF | 44.18 | 44.19 | 43.9 | 44.04 | 24000.0 |
| 2015-06-26 | AMJ | ETF | 40.64 | 41.17 | 40.54 | 40.58 | 1805099.0 |
| 2015-06-26 | AMLP | ETF | 79.65 | 79.75 | 79.1 | 79.25 | 862540.0 |
| 2015-06-26 | AMZA | ETF | 204.5 | 204.5 | 202.1 | 203.6 | 1200.0 |
| 2015-06-26 | ANGL | ETF | 27.25 | 27.27 | 27.25 | 27.26 | 21800.0 |
| 2015-06-26 | AOA | ETF | 48.27 | 48.35 | 48.12 | 48.24 | 21800.0 |
| 2015-06-26 | AOK | ETF | 32.66 | 32.66 | 32.5301 | 32.586 | 21842.0 |
| 2015-06-26 | AOM | ETF | 35.48 | 35.51 | 35.36 | 35.47 | 34405.0 |
| 2015-06-26 | AOR | ETF | 41.12 | 41.1564 | 40.9775 | 41.06 | 72235.0 |
| 2015-06-26 | ARGT | ETF | 20.71 | 20.71 | 20.52 | 20.53 | 14300.0 |
| 2015-06-26 | ARKG | ETF | 23.67 | 23.67 | 23.27 | 23.27 | 500.0 |
| 2015-06-26 | ARKK | ETF | 21.8 | 21.8 | 21.712 | 21.74 | 3300.0 |
| 2015-06-26 | ARKQ | ETF | 20.33 | 20.35 | 20.21 | 20.27 | 800.0 |
| 2015-06-26 | ARKW | ETF | 23.51 | 23.51 | 23.27 | 23.34 | 2500.0 |
| 2015-06-26 | ASEA | ETF | 14.97 | 15.07 | 14.97 | 15.06 | 12800.0 |
| 2015-06-26 | ASHR | ETF | 43.7 | 43.97 | 42.82 | 43.0 | 9800900.0 |
| 2015-06-26 | ASHS | ETF | 56.63 | 56.72 | 54.07 | 54.6 | 725100.0 |
| 2015-06-26 | ATMP | ETF | 28.1 | 28.1 | 27.89 | 27.99 | 25000.0 |
| 2015-06-26 | AWAY | ETF | 31.27 | 31.31 | 30.59 | 30.62 | 2048621.0 |
| 2015-06-26 | BAB | ETF | 28.66 | 28.78 | 28.6 | 28.7 | 53849.0 |
| 2015-06-26 | BAL | ETF | 44.26 | 45.413 | 44.25 | 45.2 | 7888.0 |
| 2015-06-26 | BALT | ETF | 1.64 | 1.64 | 1.51 | 1.57 | 4116208.0 |
| 2015-06-26 | BBC | ETF | 36.25 | 36.5423 | 35.445 | 35.8201 | 22448.0 |
| 2015-06-26 | BBH | ETF | 137.91 | 138.11 | 135.57 | 136.65 | 115200.0 |
| 2015-06-26 | BBP | ETF | 36.1 | 36.1 | 34.67 | 35.1 | 36200.0 |
| 2015-06-26 | BCHP | ETF | 20.078 | 20.078 | 20.077 | 20.077 | 200.0 |
| 2015-06-26 | BCM | ETF | 31.2699 | 31.2701 | 31.2699 | 31.2701 | 1657.0 |
| 2015-06-26 | BFOR | ETF | 8.485 | 8.5 | 8.4425 | 8.47 | 31600.0 |
> showing 50 of 1,192 rows — these rows as CSV