PREVIEW / etf_daily / 2015-04-24
file: by_date/etf_daily/2015/2015-04-24.parquet size: 47 KB rows: 1,172
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-24 | SPY | ETF | 211.66 | 211.97 | 211.11 | 211.65 | 61327400.0 |
| 2015-04-24 | QQQ | ETF | 110.21 | 110.69 | 110.03 | 110.54 | 32508127.0 |
| 2015-04-24 | IWM | ETF | 126.33 | 126.46 | 125.69 | 125.86 | 14992500.0 |
| 2015-04-24 | DIA | ETF | 180.5 | 180.82 | 179.79 | 180.54 | 4010000.0 |
| 2015-04-24 | GLD | ETF | 113.96 | 114.07 | 112.77 | 113.05 | 7152900.0 |
| 2015-04-24 | TLT | ETF | 128.64 | 129.43 | 128.59 | 129.07 | 4773000.0 |
| 2015-04-24 | AAXJ | ETF | 69.7 | 69.7 | 69.45 | 69.51 | 779200.0 |
| 2015-04-24 | ACWI | ETF | 62.6 | 62.73 | 62.43 | 62.65 | 884100.0 |
| 2015-04-24 | ACWV | ETF | 74.1 | 74.29 | 73.97 | 74.03 | 379100.0 |
| 2015-04-24 | ACWX | ETF | 47.37 | 47.53 | 47.2451 | 47.47 | 175447.0 |
| 2015-04-24 | ADRE | ETF | 38.25 | 38.5 | 38.2452 | 38.35 | 5945.0 |
| 2015-04-24 | AFK | ETF | 26.65 | 26.71 | 26.49 | 26.52 | 24661.0 |
| 2015-04-24 | AFTY | ETF | 22.67 | 22.773 | 22.67 | 22.68 | 36200.0 |
| 2015-04-24 | AGG | ETF | 111.48 | 111.57 | 111.41 | 111.5 | 837700.0 |
| 2015-04-24 | AGQ | ETF | 37.49 | 37.53 | 36.5 | 37.13 | 184000.0 |
| 2015-04-24 | AGZ | ETF | 114.35 | 114.51 | 114.1512 | 114.299 | 7971.0 |
| 2015-04-24 | AGZD | ETF | 24.515 | 24.55 | 24.47 | 24.49 | 11800.0 |
| 2015-04-24 | AIA | ETF | 54.8 | 54.8 | 54.56 | 54.64 | 26188.0 |
| 2015-04-24 | AIQ | ETF | 22.7 | 23.26 | 22.55 | 23.09 | 20021.0 |
| 2015-04-24 | AIRR | ETF | 18.75 | 18.764 | 18.69 | 18.721 | 214200.0 |
| 2015-04-24 | AIVI | ETF | 45.96 | 46.2 | 45.88 | 46.09 | 46700.0 |
| 2015-04-24 | ALTL | ETF | 37.65 | 37.65 | 37.65 | 37.65 | 202.0 |
| 2015-04-24 | AMJ | ETF | 44.4 | 44.81 | 44.23 | 44.72 | 583661.0 |
| 2015-04-24 | AMLP | ETF | 85.15 | 85.45 | 85.05 | 85.4 | 520720.0 |
| 2015-04-24 | AMZA | ETF | 221.55 | 222.7 | 221.4 | 222.5 | 530.0 |
| 2015-04-24 | ANGL | ETF | 27.72 | 27.72 | 27.65 | 27.71 | 5800.0 |
| 2015-04-24 | AOA | ETF | 48.89 | 48.9 | 48.75 | 48.79 | 21200.0 |
| 2015-04-24 | AOK | ETF | 33.32 | 33.3995 | 33.2845 | 33.39 | 28508.0 |
| 2015-04-24 | AOM | ETF | 36.13 | 36.2093 | 36.0501 | 36.15 | 36101.0 |
| 2015-04-24 | AOR | ETF | 41.73 | 41.7899 | 41.54 | 41.67 | 51211.0 |
| 2015-04-24 | ARGT | ETF | 22.39 | 22.4 | 22.1 | 22.1 | 12800.0 |
| 2015-04-24 | ARKG | ETF | 23.85 | 23.96 | 23.85 | 23.95 | 1000.0 |
| 2015-04-24 | ARKK | ETF | 22.059 | 22.08 | 21.987 | 21.987 | 6100.0 |
| 2015-04-24 | ARKQ | ETF | 20.549 | 20.549 | 20.549 | 20.549 | 200.0 |
| 2015-04-24 | ARKW | ETF | 23.42 | 23.42 | 23.135 | 23.135 | 7300.0 |
| 2015-04-24 | ASEA | ETF | 16.4 | 16.46 | 16.37 | 16.39 | 2100.0 |
| 2015-04-24 | ASHR | ETF | 48.74 | 48.77 | 48.51 | 48.63 | 1301800.0 |
| 2015-04-24 | ASHS | ETF | 55.41 | 55.96 | 55.41 | 55.52 | 46300.0 |
| 2015-04-24 | ATMP | ETF | 30.37 | 30.52 | 30.36 | 30.5 | 28200.0 |
| 2015-04-24 | AWAY | ETF | 28.6 | 29.02 | 27.11 | 27.18 | 10175601.0 |
| 2015-04-24 | BAB | ETF | 30.39 | 30.413 | 30.236 | 30.39 | 90200.0 |
| 2015-04-24 | BAL | ETF | 44.68 | 45.2 | 44.67 | 45.14 | 6258.0 |
| 2015-04-24 | BALT | ETF | 1.64 | 1.68 | 1.57 | 1.61 | 430782.0 |
| 2015-04-24 | BAR | ETF | 2.611 | 2.613 | 2.611 | 2.613 | 13300.0 |
| 2015-04-24 | BBC | ETF | 35.4 | 35.4 | 34.8672 | 34.8672 | 36838.0 |
| 2015-04-24 | BBH | ETF | 135.0 | 135.73 | 134.24 | 134.28 | 53000.0 |
| 2015-04-24 | BBP | ETF | 33.73 | 33.73 | 33.077 | 33.1 | 20200.0 |
| 2015-04-24 | BCHP | ETF | 20.29 | 20.29 | 20.29 | 20.29 | 488.0 |
| 2015-04-24 | BCM | ETF | 31.829 | 31.84 | 31.79 | 31.84 | 3038.0 |
| 2015-04-24 | BFOR | ETF | 8.495 | 8.51 | 8.475 | 8.475 | 43600.0 |
> showing 50 of 1,172 rows — these rows as CSV