PREVIEW / etf_daily / 2015-04-15
file: by_date/etf_daily/2015/2015-04-15.parquet size: 48 KB rows: 1,178
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-15 | SPY | ETF | 210.05 | 211.04 | 209.95 | 210.43 | 99529300.0 |
| 2015-04-15 | QQQ | ETF | 107.45 | 108.07 | 107.321 | 107.84 | 21128576.0 |
| 2015-04-15 | IWM | ETF | 126.16 | 127.13 | 125.92 | 126.55 | 37282300.0 |
| 2015-04-15 | DIA | ETF | 180.83 | 181.38 | 180.45 | 180.88 | 4377800.0 |
| 2015-04-15 | GLD | ETF | 114.8 | 115.6 | 114.47 | 115.43 | 3656000.0 |
| 2015-04-15 | TLT | ETF | 131.05 | 131.27 | 130.32 | 130.61 | 4425200.0 |
| 2015-04-15 | AADR | ETF | 40.33 | 40.33 | 40.33 | 40.33 | 300.0 |
| 2015-04-15 | AAXJ | ETF | 68.12 | 68.48 | 68.09 | 68.45 | 1273200.0 |
| 2015-04-15 | ACWI | ETF | 61.88 | 62.22 | 61.87 | 62.1 | 1974100.0 |
| 2015-04-15 | ACWV | ETF | 73.18 | 73.48 | 73.12 | 73.25 | 208400.0 |
| 2015-04-15 | ACWX | ETF | 46.64 | 46.8924 | 46.54 | 46.83 | 235791.0 |
| 2015-04-15 | ADRE | ETF | 36.9 | 37.2 | 36.87 | 37.2 | 8470.0 |
| 2015-04-15 | AFK | ETF | 26.32 | 26.5599 | 26.21 | 26.51 | 35682.0 |
| 2015-04-15 | AFTY | ETF | 21.2 | 21.529 | 21.2 | 21.43 | 1179600.0 |
| 2015-04-15 | AGG | ETF | 111.66 | 111.71 | 111.55 | 111.64 | 1296800.0 |
| 2015-04-15 | AGQ | ETF | 39.38 | 40.39 | 39.26 | 39.99 | 107800.0 |
| 2015-04-15 | AGZ | ETF | 114.2753 | 114.4799 | 114.17 | 114.32 | 12538.0 |
| 2015-04-15 | AGZD | ETF | 24.465 | 24.565 | 24.465 | 24.525 | 3800.0 |
| 2015-04-15 | AIA | ETF | 53.32 | 53.64 | 53.25 | 53.63 | 35899.0 |
| 2015-04-15 | AIQ | ETF | 23.73 | 23.95 | 23.29 | 23.89 | 16010.0 |
| 2015-04-15 | AIRR | ETF | 19.276 | 19.52 | 19.276 | 19.47 | 7000.0 |
| 2015-04-15 | AIVI | ETF | 45.42 | 45.58 | 45.2 | 45.51 | 86500.0 |
| 2015-04-15 | ALTL | ETF | 37.69 | 37.69 | 37.69 | 37.69 | 172.0 |
| 2015-04-15 | AMJ | ETF | 44.41 | 44.61 | 44.065 | 44.48 | 1568434.0 |
| 2015-04-15 | AMLP | ETF | 84.75 | 85.05 | 84.3 | 84.9 | 892560.0 |
| 2015-04-15 | AMZA | ETF | 216.6 | 221.3 | 216.6 | 220.76 | 840.0 |
| 2015-04-15 | ANGL | ETF | 27.57 | 27.63 | 27.57 | 27.62 | 42800.0 |
| 2015-04-15 | AOA | ETF | 48.56 | 48.65 | 48.41 | 48.48 | 60300.0 |
| 2015-04-15 | AOK | ETF | 33.36 | 33.38 | 33.25 | 33.29 | 63078.0 |
| 2015-04-15 | AOM | ETF | 36.1 | 36.12 | 36.0001 | 36.07 | 59341.0 |
| 2015-04-15 | AOR | ETF | 41.39 | 41.62 | 41.39 | 41.5 | 76547.0 |
| 2015-04-15 | ARGT | ETF | 22.1 | 22.19 | 21.86 | 22.15 | 39200.0 |
| 2015-04-15 | ARKG | ETF | 23.46 | 23.638 | 23.46 | 23.638 | 1800.0 |
| 2015-04-15 | ARKK | ETF | 21.6 | 21.6 | 21.6 | 21.6 | 400.0 |
| 2015-04-15 | ARKQ | ETF | 20.76 | 20.78 | 20.76 | 20.77 | 1200.0 |
| 2015-04-15 | ARKW | ETF | 22.52 | 22.52 | 22.46 | 22.51 | 700.0 |
| 2015-04-15 | ASEA | ETF | 16.06 | 16.15 | 16.02 | 16.13 | 6800.0 |
| 2015-04-15 | ASHR | ETF | 44.72 | 44.82 | 44.49 | 44.79 | 2370000.0 |
| 2015-04-15 | ASHS | ETF | 53.42 | 53.42 | 51.01 | 51.11 | 196900.0 |
| 2015-04-15 | ATMP | ETF | 29.98 | 30.33 | 29.98 | 30.29 | 62500.0 |
| 2015-04-15 | AWAY | ETF | 32.23 | 32.54 | 31.96 | 32.4 | 1090509.0 |
| 2015-04-15 | BAB | ETF | 30.39 | 30.5317 | 30.39 | 30.46 | 61765.0 |
| 2015-04-15 | BAL | ETF | 43.97 | 44.2012 | 43.9541 | 44.19 | 3263.0 |
| 2015-04-15 | BALT | ETF | 1.36 | 1.4 | 1.34 | 1.39 | 779511.0 |
| 2015-04-15 | BAR | ETF | 2.7352 | 2.7739 | 2.6838 | 2.7739 | 25220.0 |
| 2015-04-15 | BBC | ETF | 34.88 | 34.95 | 34.25 | 34.75 | 18253.0 |
| 2015-04-15 | BBH | ETF | 133.7 | 134.65 | 132.78 | 134.33 | 178100.0 |
| 2015-04-15 | BBP | ETF | 33.47 | 33.5 | 32.91 | 33.5 | 23600.0 |
| 2015-04-15 | BCHP | ETF | 19.96 | 19.96 | 19.95 | 19.95 | 1840.0 |
| 2015-04-15 | BCM | ETF | 31.23 | 31.65 | 31.1607 | 31.65 | 8354.0 |
> showing 50 of 1,178 rows — these rows as CSV