PREVIEW / etf_daily / 2015-04-22
file: by_date/etf_daily/2015/2015-04-22.parquet size: 47 KB rows: 1,169
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-22 | SPY | ETF | 210.01 | 210.85 | 208.9 | 210.63 | 78264600.0 |
| 2015-04-22 | QQQ | ETF | 108.34 | 108.83 | 107.64 | 108.65 | 21429190.0 |
| 2015-04-22 | IWM | ETF | 125.52 | 125.88 | 124.47 | 125.71 | 21991300.0 |
| 2015-04-22 | DIA | ETF | 179.65 | 180.25 | 178.55 | 180.06 | 5575200.0 |
| 2015-04-22 | GLD | ETF | 114.83 | 114.96 | 113.77 | 113.83 | 5696000.0 |
| 2015-04-22 | TLT | ETF | 129.5 | 129.55 | 127.54 | 127.72 | 9707600.0 |
| 2015-04-22 | AAXJ | ETF | 69.07 | 69.17 | 68.8 | 69.13 | 973300.0 |
| 2015-04-22 | ACWI | ETF | 62.02 | 62.23 | 61.76 | 62.2 | 510700.0 |
| 2015-04-22 | ACWV | ETF | 73.62 | 73.73 | 73.32 | 73.63 | 104400.0 |
| 2015-04-22 | ACWX | ETF | 46.92 | 47.01 | 46.69 | 47.0 | 162048.0 |
| 2015-04-22 | ADRE | ETF | 37.29 | 37.54 | 37.161 | 37.5 | 4260.0 |
| 2015-04-22 | AFK | ETF | 26.28 | 26.366 | 26.14 | 26.33 | 41990.0 |
| 2015-04-22 | AFTY | ETF | 23.16 | 23.34 | 23.16 | 23.31 | 79800.0 |
| 2015-04-22 | AGG | ETF | 111.44 | 111.44 | 111.1 | 111.14 | 916400.0 |
| 2015-04-22 | AGQ | ETF | 38.11 | 38.2 | 36.92 | 37.38 | 219800.0 |
| 2015-04-22 | AGZ | ETF | 114.21 | 114.28 | 113.9914 | 114.1301 | 8971.0 |
| 2015-04-22 | AGZD | ETF | 24.55 | 24.555 | 24.46 | 24.535 | 5200.0 |
| 2015-04-22 | AIA | ETF | 54.13 | 54.26 | 53.84 | 54.23 | 41455.0 |
| 2015-04-22 | AIQ | ETF | 24.09 | 24.09 | 23.46 | 23.75 | 13725.0 |
| 2015-04-22 | AIRR | ETF | 18.711 | 18.87 | 18.7 | 18.79 | 2900.0 |
| 2015-04-22 | AIVI | ETF | 45.36 | 45.44 | 45.2 | 45.38 | 28100.0 |
| 2015-04-22 | ALTL | ETF | 37.45 | 37.45 | 37.45 | 37.45 | 482.0 |
| 2015-04-22 | AMJ | ETF | 44.32 | 44.53 | 44.0 | 44.13 | 1219273.0 |
| 2015-04-22 | AMLP | ETF | 84.7 | 85.0 | 84.3 | 84.45 | 655180.0 |
| 2015-04-22 | AMZA | ETF | 223.5 | 223.5 | 218.3 | 219.3 | 900.0 |
| 2015-04-22 | ANGL | ETF | 27.72 | 27.72 | 27.65 | 27.7 | 4700.0 |
| 2015-04-22 | AOA | ETF | 48.44 | 48.58 | 48.3 | 48.46 | 26400.0 |
| 2015-04-22 | AOK | ETF | 33.22 | 33.2499 | 33.16 | 33.16 | 21696.0 |
| 2015-04-22 | AOM | ETF | 36.01 | 36.03 | 35.91 | 35.92 | 39004.0 |
| 2015-04-22 | AOR | ETF | 41.59 | 41.59 | 41.4 | 41.47 | 87553.0 |
| 2015-04-22 | ARGT | ETF | 21.56 | 21.89 | 21.53 | 21.85 | 7300.0 |
| 2015-04-22 | ARKG | ETF | 23.73 | 23.73 | 23.47 | 23.47 | 1500.0 |
| 2015-04-22 | ARKK | ETF | 21.74 | 21.76 | 21.74 | 21.76 | 500.0 |
| 2015-04-22 | ARKQ | ETF | 20.28 | 20.51 | 20.28 | 20.5 | 35200.0 |
| 2015-04-22 | ARKW | ETF | 22.95 | 22.95 | 22.92 | 22.92 | 2200.0 |
| 2015-04-22 | ASEA | ETF | 16.26 | 16.28 | 16.23 | 16.23 | 2100.0 |
| 2015-04-22 | ASHR | ETF | 48.87 | 49.36 | 48.55 | 49.24 | 2267600.0 |
| 2015-04-22 | ASHS | ETF | 54.11 | 55.18 | 54.11 | 55.18 | 105400.0 |
| 2015-04-22 | ATMP | ETF | 30.0 | 30.28 | 30.0 | 30.18 | 7300.0 |
| 2015-04-22 | AWAY | ETF | 31.64 | 32.57 | 31.64 | 32.27 | 2356665.0 |
| 2015-04-22 | BAB | ETF | 30.33 | 30.33 | 30.18 | 30.19 | 78736.0 |
| 2015-04-22 | BAL | ETF | 42.701 | 42.84 | 42.3 | 42.78 | 10949.0 |
| 2015-04-22 | BALT | ETF | 1.58 | 1.645 | 1.52 | 1.61 | 1655588.0 |
| 2015-04-22 | BAR | ETF | 2.747 | 2.747 | 2.7 | 2.7 | 8200.0 |
| 2015-04-22 | BBC | ETF | 34.76 | 34.95 | 34.35 | 34.6472 | 20026.0 |
| 2015-04-22 | BBH | ETF | 135.98 | 136.19 | 134.15 | 134.69 | 116300.0 |
| 2015-04-22 | BBP | ETF | 33.42 | 33.431 | 32.96 | 33.14 | 13700.0 |
| 2015-04-22 | BCHP | ETF | 20.08 | 20.08 | 20.08 | 20.08 | 800.0 |
| 2015-04-22 | BCM | ETF | 31.54 | 31.55 | 31.43 | 31.5099 | 6440.0 |
| 2015-04-22 | BFOR | ETF | 8.46 | 8.4825 | 8.405 | 8.4775 | 64000.0 |
> showing 50 of 1,169 rows — these rows as CSV