PREVIEW / etf_daily / 2015-04-28
file: by_date/etf_daily/2015/2015-04-28.parquet size: 48 KB rows: 1,176
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-04-28 | SPY | ETF | 210.74 | 211.5 | 209.33 | 211.44 | 86863500.0 |
| 2015-04-28 | QQQ | ETF | 110.34 | 110.55 | 109.11 | 110.04 | 36849221.0 |
| 2015-04-28 | IWM | ETF | 124.54 | 125.37 | 123.25 | 125.16 | 35654900.0 |
| 2015-04-28 | DIA | ETF | 180.36 | 180.94 | 178.88 | 180.84 | 4534200.0 |
| 2015-04-28 | GLD | ETF | 115.36 | 116.62 | 115.34 | 116.33 | 8054400.0 |
| 2015-04-28 | TLT | ETF | 128.17 | 128.74 | 127.26 | 127.29 | 7464300.0 |
| 2015-04-28 | AAXJ | ETF | 69.82 | 69.91 | 69.5 | 69.83 | 1445500.0 |
| 2015-04-28 | ACWI | ETF | 62.61 | 62.77 | 62.28 | 62.75 | 613500.0 |
| 2015-04-28 | ACWV | ETF | 73.96 | 74.17 | 73.64 | 74.11 | 71400.0 |
| 2015-04-28 | ACWX | ETF | 47.59 | 47.745 | 47.51 | 47.71 | 263650.0 |
| 2015-04-28 | ADRE | ETF | 38.65 | 38.65 | 38.42 | 38.46 | 8837.0 |
| 2015-04-28 | AFK | ETF | 26.79 | 26.91 | 26.67 | 26.77 | 15795.0 |
| 2015-04-28 | AFTY | ETF | 23.43 | 23.47 | 23.33 | 23.37 | 233200.0 |
| 2015-04-28 | AGG | ETF | 111.34 | 111.44 | 111.11 | 111.11 | 1602000.0 |
| 2015-04-28 | AGQ | ETF | 40.43 | 41.65 | 40.3 | 41.37 | 235500.0 |
| 2015-04-28 | AGZ | ETF | 114.11 | 114.202 | 113.85 | 113.94 | 20390.0 |
| 2015-04-28 | AGZD | ETF | 24.5 | 24.535 | 24.45 | 24.45 | 3600.0 |
| 2015-04-28 | AIA | ETF | 54.9 | 54.9345 | 54.69 | 54.9 | 10159.0 |
| 2015-04-28 | AIQ | ETF | 22.69 | 23.3 | 22.5 | 22.8 | 17195.0 |
| 2015-04-28 | AIRR | ETF | 18.72 | 18.79 | 18.64 | 18.739 | 10400.0 |
| 2015-04-28 | AIVI | ETF | 46.21 | 46.48 | 46.21 | 46.48 | 23100.0 |
| 2015-04-28 | ALTL | ETF | 37.5 | 37.585 | 37.5 | 37.585 | 494.0 |
| 2015-04-28 | AMJ | ETF | 44.55 | 44.66 | 44.38 | 44.66 | 407124.0 |
| 2015-04-28 | AMLP | ETF | 85.35 | 85.4 | 85.0 | 85.25 | 656100.0 |
| 2015-04-28 | AMZA | ETF | 221.5 | 221.8 | 220.8 | 221.72 | 570.0 |
| 2015-04-28 | ANGL | ETF | 28.05 | 28.05 | 27.74 | 27.83 | 17300.0 |
| 2015-04-28 | AOA | ETF | 48.94 | 48.96 | 48.66 | 48.87 | 53200.0 |
| 2015-04-28 | AOK | ETF | 33.38 | 33.386 | 33.241 | 33.32 | 99491.0 |
| 2015-04-28 | AOM | ETF | 36.13 | 36.16 | 36.04 | 36.15 | 62584.0 |
| 2015-04-28 | AOR | ETF | 41.72 | 41.78 | 41.6088 | 41.74 | 63067.0 |
| 2015-04-28 | ARGT | ETF | 22.5 | 22.5 | 22.26 | 22.44 | 7800.0 |
| 2015-04-28 | ARKG | ETF | 23.34 | 23.34 | 22.7 | 23.04 | 3000.0 |
| 2015-04-28 | ARKK | ETF | 21.93 | 21.93 | 21.73 | 21.73 | 600.0 |
| 2015-04-28 | ARKQ | ETF | 20.53 | 20.564 | 20.484 | 20.55 | 1300.0 |
| 2015-04-28 | ARKW | ETF | 23.25 | 23.25 | 23.135 | 23.135 | 1900.0 |
| 2015-04-28 | ASEA | ETF | 16.42 | 16.45 | 16.27 | 16.44 | 121900.0 |
| 2015-04-28 | ASHR | ETF | 49.11 | 49.11 | 48.6 | 48.85 | 1257500.0 |
| 2015-04-28 | ASHS | ETF | 55.41 | 55.41 | 54.02 | 54.4 | 71400.0 |
| 2015-04-28 | ATMP | ETF | 30.44 | 30.48 | 30.41 | 30.47 | 21400.0 |
| 2015-04-28 | AWAY | ETF | 27.91 | 28.44 | 27.09 | 27.12 | 2054976.0 |
| 2015-04-28 | BAB | ETF | 30.21 | 30.31 | 30.18 | 30.19 | 86968.0 |
| 2015-04-28 | BAL | ETF | 45.23 | 45.465 | 44.93 | 44.93 | 2444.0 |
| 2015-04-28 | BALT | ETF | 1.62 | 1.64 | 1.49 | 1.5 | 765003.0 |
| 2015-04-28 | BAR | ETF | 2.791 | 2.8424 | 2.791 | 2.8276 | 31370.0 |
| 2015-04-28 | BBC | ETF | 32.74 | 33.1 | 31.15 | 32.05 | 39018.0 |
| 2015-04-28 | BBH | ETF | 130.3 | 131.0 | 126.52 | 128.39 | 125200.0 |
| 2015-04-28 | BBP | ETF | 31.67 | 31.804 | 30.37 | 30.93 | 22200.0 |
| 2015-04-28 | BCHP | ETF | 20.49 | 20.49 | 20.41 | 20.41 | 3761.0 |
| 2015-04-28 | BCM | ETF | 32.01 | 32.04 | 32.0098 | 32.035 | 2345.0 |
| 2015-04-28 | BFOR | ETF | 8.395 | 8.445 | 8.365 | 8.43 | 77600.0 |
> showing 50 of 1,176 rows — these rows as CSV