PREVIEW / etf_daily / 2015-06-08
file: by_date/etf_daily/2015/2015-06-08.parquet size: 48 KB rows: 1,185
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-08 | SPY | ETF | 209.64 | 209.82 | 208.39 | 208.48 | 89063300.0 |
| 2015-06-08 | QQQ | ETF | 109.25 | 109.33 | 107.97 | 108.19 | 24549204.0 |
| 2015-06-08 | IWM | ETF | 125.28 | 125.62 | 124.57 | 124.82 | 18798700.0 |
| 2015-06-08 | DIA | ETF | 178.51 | 178.6 | 177.68 | 177.81 | 4380500.0 |
| 2015-06-08 | GLD | ETF | 112.39 | 112.66 | 112.13 | 112.57 | 3122100.0 |
| 2015-06-08 | TLT | ETF | 117.96 | 118.16 | 117.37 | 117.47 | 5334000.0 |
| 2015-06-08 | AADR | ETF | 39.4 | 39.4 | 39.4 | 39.4 | 100.0 |
| 2015-06-08 | AAXJ | ETF | 64.84 | 64.88 | 64.65 | 64.72 | 532800.0 |
| 2015-06-08 | ACTX | ETF | 4.13 | 4.13 | 4.13 | 4.13 | 230.0 |
| 2015-06-08 | ACWI | ETF | 61.03 | 61.03 | 60.72 | 60.81 | 1050400.0 |
| 2015-06-08 | ACWV | ETF | 70.85 | 70.89 | 70.63 | 70.72 | 53700.0 |
| 2015-06-08 | ACWX | ETF | 45.44 | 45.51 | 45.3355 | 45.47 | 103399.0 |
| 2015-06-08 | ADRE | ETF | 35.45 | 35.5 | 35.2984 | 35.32 | 4298.0 |
| 2015-06-08 | AFK | ETF | 25.21 | 25.39 | 25.04 | 25.17 | 8225.0 |
| 2015-06-08 | AFTY | ETF | 24.22 | 24.75 | 24.22 | 24.63 | 92600.0 |
| 2015-06-08 | AGG | ETF | 108.76 | 108.8 | 108.66 | 108.71 | 1289700.0 |
| 2015-06-08 | AGQ | ETF | 38.29 | 38.33 | 37.68 | 38.1 | 228700.0 |
| 2015-06-08 | AGZ | ETF | 112.83 | 112.946 | 112.68 | 112.85 | 17242.0 |
| 2015-06-08 | AGZD | ETF | 24.355 | 24.38 | 24.35 | 24.375 | 2400.0 |
| 2015-06-08 | AIA | ETF | 51.61 | 51.61 | 51.47 | 51.5238 | 10553.0 |
| 2015-06-08 | AIQ | ETF | 18.41 | 18.41 | 18.15 | 18.21 | 10139.0 |
| 2015-06-08 | AIRR | ETF | 18.54 | 18.54 | 18.46 | 18.46 | 3300.0 |
| 2015-06-08 | AIVI | ETF | 44.43 | 44.53 | 44.28 | 44.53 | 21200.0 |
| 2015-06-08 | AMJ | ETF | 42.23 | 42.31 | 41.7029 | 41.82 | 919792.0 |
| 2015-06-08 | AMLP | ETF | 81.4 | 81.5 | 80.75 | 80.95 | 716520.0 |
| 2015-06-08 | AMZA | ETF | 210.5 | 210.5 | 206.5 | 207.2 | 2850.0 |
| 2015-06-08 | ANGL | ETF | 27.63 | 27.63 | 27.42 | 27.43 | 14100.0 |
| 2015-06-08 | AOA | ETF | 47.88 | 47.88 | 47.6 | 47.71 | 31800.0 |
| 2015-06-08 | AOK | ETF | 32.6 | 32.6 | 32.49 | 32.56 | 28555.0 |
| 2015-06-08 | AOM | ETF | 35.34 | 35.45 | 35.2601 | 35.37 | 38466.0 |
| 2015-06-08 | AOR | ETF | 40.88 | 40.88 | 40.7101 | 40.78 | 39117.0 |
| 2015-06-08 | ARGT | ETF | 21.5 | 21.52 | 21.32 | 21.32 | 2700.0 |
| 2015-06-08 | ARKG | ETF | 23.71 | 23.71 | 23.39 | 23.54 | 4100.0 |
| 2015-06-08 | ARKK | ETF | 21.82 | 21.84 | 21.6 | 21.6 | 1000.0 |
| 2015-06-08 | ARKQ | ETF | 20.11 | 20.132 | 20.051 | 20.055 | 1400.0 |
| 2015-06-08 | ARKW | ETF | 23.4 | 23.42 | 23.167 | 23.23 | 2400.0 |
| 2015-06-08 | ASEA | ETF | 14.93 | 14.96 | 14.93 | 14.94 | 5300.0 |
| 2015-06-08 | ASHR | ETF | 54.57 | 54.88 | 54.43 | 54.72 | 2908300.0 |
| 2015-06-08 | ASHS | ETF | 71.42 | 71.75 | 71.13 | 71.33 | 155200.0 |
| 2015-06-08 | ATMP | ETF | 28.85 | 28.85 | 28.36 | 28.47 | 12000.0 |
| 2015-06-08 | AWAY | ETF | 31.0 | 31.44 | 30.61 | 30.78 | 1206197.0 |
| 2015-06-08 | BAB | ETF | 28.92 | 28.92 | 28.8 | 28.84 | 68966.0 |
| 2015-06-08 | BAL | ETF | 43.85 | 44.0131 | 43.85 | 44.0131 | 5004.0 |
| 2015-06-08 | BALT | ETF | 1.5 | 1.53 | 1.46 | 1.49 | 115105.0 |
| 2015-06-08 | BAR | ETF | 2.511 | 2.527 | 2.511 | 2.527 | 2660.0 |
| 2015-06-08 | BBC | ETF | 37.16 | 37.16 | 36.01 | 36.3 | 33246.0 |
| 2015-06-08 | BBH | ETF | 133.83 | 134.12 | 132.4 | 132.87 | 188400.0 |
| 2015-06-08 | BBP | ETF | 34.0 | 34.36 | 33.97 | 34.19 | 25100.0 |
| 2015-06-08 | BCHP | ETF | 19.9801 | 20.12 | 19.9801 | 20.12 | 1340.0 |
| 2015-06-08 | BCM | ETF | 31.22 | 31.249 | 31.209 | 31.249 | 3606.0 |
> showing 50 of 1,185 rows — these rows as CSV