PREVIEW / etf_daily / 2015-04-30
file: by_date/etf_daily/2015/2015-04-30.parquet size: 48 KB rows: 1,182
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-30 | SPY | ETF | 209.88 | 210.35 | 207.62 | 208.46 | 161304900.0 |
| 2015-04-30 | QQQ | ETF | 108.73 | 109.17 | 107.06 | 107.63 | 44080546.0 |
| 2015-04-30 | IWM | ETF | 123.06 | 123.44 | 120.66 | 121.18 | 72393800.0 |
| 2015-04-30 | DIA | ETF | 179.7 | 180.02 | 177.45 | 178.18 | 8564600.0 |
| 2015-04-30 | GLD | ETF | 113.88 | 113.88 | 112.96 | 113.47 | 9440300.0 |
| 2015-04-30 | TLT | ETF | 125.04 | 126.17 | 124.51 | 125.95 | 12876000.0 |
| 2015-04-30 | AAXJ | ETF | 68.43 | 68.58 | 68.07 | 68.11 | 871400.0 |
| 2015-04-30 | ACTX | ETF | 7.0801 | 7.0801 | 2.95 | 5.31 | 10489.0 |
| 2015-04-30 | ACWI | ETF | 62.0 | 62.14 | 61.58 | 61.74 | 767700.0 |
| 2015-04-30 | ACWV | ETF | 73.33 | 73.35 | 72.66 | 72.85 | 123800.0 |
| 2015-04-30 | ACWX | ETF | 47.02 | 47.05 | 46.77 | 46.84 | 160698.0 |
| 2015-04-30 | ADRE | ETF | 37.89 | 37.89 | 37.37 | 37.59 | 12374.0 |
| 2015-04-30 | AFK | ETF | 26.81 | 26.81 | 26.51 | 26.68 | 16724.0 |
| 2015-04-30 | AFTY | ETF | 23.01 | 23.05 | 22.82 | 22.82 | 29900.0 |
| 2015-04-30 | AGG | ETF | 110.69 | 110.92 | 110.51 | 110.86 | 3328600.0 |
| 2015-04-30 | AGQ | ETF | 38.25 | 39.22 | 37.36 | 38.87 | 438600.0 |
| 2015-04-30 | AGZ | ETF | 113.63 | 113.8799 | 113.602 | 113.81 | 13589.0 |
| 2015-04-30 | AGZD | ETF | 24.495 | 24.515 | 24.45 | 24.485 | 13400.0 |
| 2015-04-30 | AIA | ETF | 54.0 | 54.0423 | 53.68 | 53.69 | 41912.0 |
| 2015-04-30 | AIQ | ETF | 22.23 | 22.23 | 21.24 | 21.27 | 16820.0 |
| 2015-04-30 | AIRR | ETF | 18.28 | 18.37 | 18.077 | 18.13 | 27100.0 |
| 2015-04-30 | AIVI | ETF | 45.86 | 46.08 | 45.82 | 45.9 | 29100.0 |
| 2015-04-30 | AMJ | ETF | 45.08 | 45.68 | 44.9832 | 45.4 | 1255772.0 |
| 2015-04-30 | AMLP | ETF | 85.85 | 86.4 | 85.55 | 86.0 | 887740.0 |
| 2015-04-30 | AMZA | ETF | 222.8 | 226.0 | 222.4 | 223.7 | 620.0 |
| 2015-04-30 | ANGL | ETF | 27.78 | 27.78 | 27.75 | 27.76 | 15100.0 |
| 2015-04-30 | AOA | ETF | 48.6 | 48.6 | 48.12 | 48.16 | 52800.0 |
| 2015-04-30 | AOK | ETF | 33.16 | 33.16 | 33.0301 | 33.07 | 18630.0 |
| 2015-04-30 | AOM | ETF | 35.93 | 35.93 | 35.7542 | 35.83 | 48375.0 |
| 2015-04-30 | AOR | ETF | 41.44 | 41.45 | 41.19 | 41.21 | 45721.0 |
| 2015-04-30 | ARGT | ETF | 22.01 | 22.24 | 22.01 | 22.02 | 75300.0 |
| 2015-04-30 | ARKG | ETF | 22.66 | 22.779 | 22.4 | 22.48 | 5400.0 |
| 2015-04-30 | ARKK | ETF | 21.165 | 21.165 | 20.955 | 20.955 | 3300.0 |
| 2015-04-30 | ARKQ | ETF | 20.01 | 20.01 | 19.7 | 19.7 | 104500.0 |
| 2015-04-30 | ARKW | ETF | 22.79 | 22.79 | 22.38 | 22.44 | 3100.0 |
| 2015-04-30 | ASEA | ETF | 16.13 | 16.13 | 16.0 | 16.05 | 3600.0 |
| 2015-04-30 | ASHR | ETF | 48.8 | 48.91 | 48.54 | 48.76 | 1202100.0 |
| 2015-04-30 | ASHS | ETF | 55.35 | 55.49 | 55.0 | 55.07 | 59100.0 |
| 2015-04-30 | ATMP | ETF | 30.75 | 30.84 | 30.57 | 30.69 | 19700.0 |
| 2015-04-30 | AWAY | ETF | 27.14 | 28.05 | 26.98 | 27.95 | 1915597.0 |
| 2015-04-30 | BAB | ETF | 30.02 | 30.19 | 29.95 | 30.11 | 89206.0 |
| 2015-04-30 | BAL | ETF | 46.14 | 46.301 | 45.95 | 45.95 | 7054.0 |
| 2015-04-30 | BALT | ETF | 1.42 | 1.44 | 1.36 | 1.42 | 646990.0 |
| 2015-04-30 | BAR | ETF | 2.676 | 2.676 | 2.6 | 2.625 | 31000.0 |
| 2015-04-30 | BBC | ETF | 31.6 | 31.62 | 29.73 | 30.0072 | 33035.0 |
| 2015-04-30 | BBH | ETF | 127.44 | 128.59 | 123.77 | 124.99 | 203200.0 |
| 2015-04-30 | BBP | ETF | 30.57 | 30.666 | 29.5 | 29.68 | 25900.0 |
| 2015-04-30 | BCHP | ETF | 20.1916 | 20.259 | 20.1916 | 20.259 | 535.0 |
| 2015-04-30 | BCM | ETF | 32.29 | 32.39 | 32.28 | 32.38 | 23306.0 |
| 2015-04-30 | BFOR | ETF | 8.3525 | 8.3625 | 8.26 | 8.28 | 122400.0 |
> showing 50 of 1,182 rows — these rows as CSV