PREVIEW / etf_daily / 2015-06-10
file: by_date/etf_daily/2015/2015-06-10.parquet size: 48 KB rows: 1,191
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-10 | SPY | ETF | 209.37 | 211.41 | 209.3 | 210.95 | 134551300.0 |
| 2015-06-10 | QQQ | ETF | 108.38 | 109.81 | 108.26 | 109.49 | 30297862.0 |
| 2015-06-10 | IWM | ETF | 124.93 | 126.48 | 124.85 | 125.99 | 42563500.0 |
| 2015-06-10 | DIA | ETF | 178.38 | 180.54 | 178.38 | 180.06 | 5480900.0 |
| 2015-06-10 | GLD | ETF | 114.14 | 114.14 | 113.69 | 113.78 | 5452900.0 |
| 2015-06-10 | TLT | ETF | 115.92 | 116.13 | 115.26 | 115.52 | 12183600.0 |
| 2015-06-10 | AADR | ETF | 39.89 | 39.95 | 39.89 | 39.95 | 2200.0 |
| 2015-06-10 | AAXJ | ETF | 63.99 | 64.62 | 63.99 | 64.5 | 693800.0 |
| 2015-06-10 | ACTX | ETF | 3.245 | 3.54 | 2.95 | 3.54 | 290.0 |
| 2015-06-10 | ACWF | ETF | 24.85 | 24.85 | 24.85 | 24.85 | 100.0 |
| 2015-06-10 | ACWI | ETF | 61.14 | 61.69 | 61.11 | 61.56 | 1440900.0 |
| 2015-06-10 | ACWV | ETF | 70.97 | 71.29 | 70.89 | 71.15 | 128800.0 |
| 2015-06-10 | ACWX | ETF | 45.91 | 46.2 | 45.8598 | 46.06 | 110698.0 |
| 2015-06-10 | ADRE | ETF | 35.46 | 35.815 | 35.46 | 35.61 | 4717.0 |
| 2015-06-10 | AFK | ETF | 25.04 | 25.23 | 25.02 | 25.04 | 59678.0 |
| 2015-06-10 | AFTY | ETF | 23.92 | 23.92 | 23.66 | 23.76 | 84800.0 |
| 2015-06-10 | AGG | ETF | 108.24 | 108.3 | 108.04 | 108.13 | 1491200.0 |
| 2015-06-10 | AGQ | ETF | 38.69 | 38.69 | 37.91 | 38.15 | 134900.0 |
| 2015-06-10 | AGZ | ETF | 112.6 | 112.7 | 112.55 | 112.57 | 12994.0 |
| 2015-06-10 | AGZD | ETF | 24.45 | 24.46 | 24.36 | 24.45 | 4200.0 |
| 2015-06-10 | AIA | ETF | 51.04 | 51.34 | 51.02 | 51.31 | 16967.0 |
| 2015-06-10 | AIQ | ETF | 18.4 | 18.99 | 18.37 | 18.92 | 17210.0 |
| 2015-06-10 | AIRR | ETF | 18.49 | 18.79 | 18.49 | 18.66 | 3800.0 |
| 2015-06-10 | AIVI | ETF | 44.8 | 45.2 | 44.8 | 45.06 | 18700.0 |
| 2015-06-10 | AMJ | ETF | 42.0 | 42.091 | 41.705 | 41.72 | 1130410.0 |
| 2015-06-10 | AMLP | ETF | 80.9 | 81.3 | 80.65 | 80.7 | 1085420.0 |
| 2015-06-10 | AMZA | ETF | 209.2 | 209.2 | 205.8 | 206.3 | 1580.0 |
| 2015-06-10 | ANGL | ETF | 27.37 | 27.5 | 27.33 | 27.38 | 11200.0 |
| 2015-06-10 | AOA | ETF | 47.66 | 48.18 | 47.66 | 48.14 | 15800.0 |
| 2015-06-10 | AOK | ETF | 32.53 | 32.6899 | 32.42 | 32.5503 | 30102.0 |
| 2015-06-10 | AOM | ETF | 35.34 | 35.45 | 35.3396 | 35.44 | 38590.0 |
| 2015-06-10 | AOR | ETF | 40.87 | 41.0399 | 40.7181 | 40.97 | 93682.0 |
| 2015-06-10 | ARGT | ETF | 21.59 | 21.69 | 21.55 | 21.57 | 5300.0 |
| 2015-06-10 | ARKG | ETF | 23.33 | 23.595 | 23.33 | 23.595 | 400.0 |
| 2015-06-10 | ARKK | ETF | 21.544 | 21.85 | 21.544 | 21.85 | 300.0 |
| 2015-06-10 | ARKQ | ETF | 20.2 | 20.22 | 20.16 | 20.22 | 500.0 |
| 2015-06-10 | ARKW | ETF | 23.54 | 23.54 | 23.51 | 23.51 | 1600.0 |
| 2015-06-10 | ASEA | ETF | 15.12 | 15.22 | 15.06 | 15.16 | 2500.0 |
| 2015-06-10 | ASHR | ETF | 54.0 | 54.48 | 53.8 | 54.12 | 3435500.0 |
| 2015-06-10 | ASHS | ETF | 71.74 | 73.49 | 71.74 | 73.4 | 167400.0 |
| 2015-06-10 | ATMP | ETF | 28.66 | 28.66 | 28.35 | 28.39 | 17800.0 |
| 2015-06-10 | AWAY | ETF | 30.0 | 30.92 | 29.842 | 30.62 | 806125.0 |
| 2015-06-10 | BAB | ETF | 28.71 | 28.77 | 28.5601 | 28.6 | 103972.0 |
| 2015-06-10 | BAL | ETF | 44.092 | 44.092 | 43.98 | 44.09 | 3114.0 |
| 2015-06-10 | BALT | ETF | 1.52 | 1.52 | 1.47 | 1.5 | 352087.0 |
| 2015-06-10 | BAR | ETF | 2.645 | 2.645 | 2.62 | 2.62 | 35820.0 |
| 2015-06-10 | BBC | ETF | 35.9 | 36.0703 | 35.26 | 35.95 | 26473.0 |
| 2015-06-10 | BBH | ETF | 131.7 | 134.03 | 130.6 | 133.91 | 154800.0 |
| 2015-06-10 | BBP | ETF | 33.39 | 33.94 | 33.28 | 33.94 | 17800.0 |
| 2015-06-10 | BCHP | ETF | 20.38 | 20.38 | 20.38 | 20.38 | 151.0 |
> showing 50 of 1,191 rows — these rows as CSV