PREVIEW / etf_daily / 2015-06-11
file: by_date/etf_daily/2015/2015-06-11.parquet size: 48 KB rows: 1,183
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-11 | SPY | ETF | 211.48 | 212.09 | 211.2 | 211.63 | 73876400.0 |
| 2015-06-11 | QQQ | ETF | 109.86 | 110.15 | 109.46 | 109.65 | 17593463.0 |
| 2015-06-11 | IWM | ETF | 126.17 | 126.54 | 125.91 | 126.31 | 17489400.0 |
| 2015-06-11 | DIA | ETF | 180.69 | 181.26 | 180.39 | 180.64 | 3714800.0 |
| 2015-06-11 | GLD | ETF | 113.27 | 113.41 | 112.92 | 113.26 | 4434700.0 |
| 2015-06-11 | TLT | ETF | 116.56 | 117.97 | 116.24 | 117.95 | 13849300.0 |
| 2015-06-11 | AADR | ETF | 40.28 | 40.28 | 39.87 | 39.87 | 1600.0 |
| 2015-06-11 | AAXJ | ETF | 64.73 | 64.73 | 64.34 | 64.46 | 627600.0 |
| 2015-06-11 | ACTX | ETF | 3.54 | 4.13 | 2.95 | 2.95 | 1317.0 |
| 2015-06-11 | ACWF | ETF | 25.06 | 25.06 | 25.018 | 25.018 | 800.0 |
| 2015-06-11 | ACWI | ETF | 61.77 | 61.85 | 61.54 | 61.74 | 490700.0 |
| 2015-06-11 | ACWV | ETF | 71.11 | 71.46 | 71.11 | 71.37 | 258200.0 |
| 2015-06-11 | ACWX | ETF | 46.21 | 46.2632 | 45.97 | 46.15 | 854840.0 |
| 2015-06-11 | ADRE | ETF | 35.7675 | 35.7675 | 35.64 | 35.7347 | 4736.0 |
| 2015-06-11 | AFK | ETF | 25.0 | 25.03 | 24.92 | 24.93 | 12518.0 |
| 2015-06-11 | AFTY | ETF | 23.51 | 23.63 | 23.4 | 23.52 | 157700.0 |
| 2015-06-11 | AGG | ETF | 108.33 | 108.71 | 108.28 | 108.71 | 1539600.0 |
| 2015-06-11 | AGQ | ETF | 37.98 | 38.29 | 37.38 | 38.17 | 140300.0 |
| 2015-06-11 | AGZ | ETF | 112.63 | 112.8899 | 112.63 | 112.761 | 9499.0 |
| 2015-06-11 | AGZD | ETF | 24.465 | 24.465 | 24.365 | 24.395 | 8800.0 |
| 2015-06-11 | AIA | ETF | 51.61 | 51.625 | 51.445 | 51.54 | 42966.0 |
| 2015-06-11 | AIQ | ETF | 19.33 | 19.33 | 18.4 | 18.62 | 14291.0 |
| 2015-06-11 | AIRR | ETF | 18.73 | 18.73 | 18.69 | 18.71 | 3200.0 |
| 2015-06-11 | AIVI | ETF | 45.11 | 45.2 | 44.92 | 45.09 | 10900.0 |
| 2015-06-11 | AMJ | ETF | 41.9 | 42.0 | 41.53 | 41.66 | 1075869.0 |
| 2015-06-11 | AMLP | ETF | 80.75 | 81.0 | 80.6 | 80.75 | 643460.0 |
| 2015-06-11 | AMZA | ETF | 206.7 | 206.7 | 205.4 | 205.96 | 2170.0 |
| 2015-06-11 | ANGL | ETF | 27.28 | 27.36 | 27.28 | 27.31 | 16000.0 |
| 2015-06-11 | AOA | ETF | 48.32 | 48.32 | 48.1 | 48.28 | 35300.0 |
| 2015-06-11 | AOK | ETF | 32.54 | 32.74 | 32.54 | 32.73 | 20671.0 |
| 2015-06-11 | AOM | ETF | 35.56 | 35.59 | 35.4584 | 35.52 | 34853.0 |
| 2015-06-11 | AOR | ETF | 41.03 | 41.2299 | 40.98 | 41.1086 | 39635.0 |
| 2015-06-11 | ARGT | ETF | 21.5 | 21.5 | 21.17 | 21.17 | 2800.0 |
| 2015-06-11 | ARKG | ETF | 23.61 | 23.665 | 23.61 | 23.665 | 2100.0 |
| 2015-06-11 | ARKK | ETF | 21.79 | 21.8 | 21.755 | 21.78 | 2600.0 |
| 2015-06-11 | ARKQ | ETF | 20.24 | 20.24 | 20.218 | 20.218 | 400.0 |
| 2015-06-11 | ARKW | ETF | 23.5 | 23.5 | 23.5 | 23.5 | 300.0 |
| 2015-06-11 | ASEA | ETF | 15.1 | 15.2 | 15.08 | 15.19 | 35600.0 |
| 2015-06-11 | ASHR | ETF | 54.35 | 54.6 | 54.29 | 54.51 | 1750300.0 |
| 2015-06-11 | ASHS | ETF | 74.13 | 75.23 | 74.13 | 75.0 | 176500.0 |
| 2015-06-11 | ATMP | ETF | 28.3 | 28.43 | 28.28 | 28.35 | 22700.0 |
| 2015-06-11 | AWAY | ETF | 31.17 | 31.52 | 30.71 | 30.775 | 873271.0 |
| 2015-06-11 | BAB | ETF | 28.71 | 28.9199 | 28.49 | 28.83 | 143946.0 |
| 2015-06-11 | BAL | ETF | 43.45 | 43.45 | 43.0983 | 43.285 | 7618.0 |
| 2015-06-11 | BALT | ETF | 1.49 | 1.53 | 1.45 | 1.5 | 200770.0 |
| 2015-06-11 | BAR | ETF | 2.56 | 2.572 | 2.56 | 2.572 | 33020.0 |
| 2015-06-11 | BBC | ETF | 35.95 | 36.25 | 35.8 | 36.192 | 18747.0 |
| 2015-06-11 | BBH | ETF | 134.66 | 135.44 | 134.1 | 135.22 | 127100.0 |
| 2015-06-11 | BBP | ETF | 34.19 | 34.26 | 33.8 | 34.07 | 14700.0 |
| 2015-06-11 | BCHP | ETF | 20.34 | 20.34 | 20.34 | 20.34 | 725.0 |
> showing 50 of 1,183 rows — these rows as CSV