PREVIEW / etf_daily / 2015-05-28
file: by_date/etf_daily/2015/2015-05-28.parquet size: 47 KB rows: 1,171
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-05-28 | SPY | ETF | 212.33 | 212.59 | 211.63 | 212.46 | 74974600.0 |
| 2015-05-28 | QQQ | ETF | 110.75 | 111.01 | 110.37 | 110.71 | 17302408.0 |
| 2015-05-28 | IWM | ETF | 124.45 | 124.71 | 123.77 | 124.64 | 18631900.0 |
| 2015-05-28 | DIA | ETF | 181.11 | 181.33 | 180.65 | 181.29 | 3660900.0 |
| 2015-05-28 | GLD | ETF | 113.85 | 114.16 | 113.21 | 114.02 | 5266000.0 |
| 2015-05-28 | TLT | ETF | 122.5 | 123.03 | 122.22 | 122.44 | 6237600.0 |
| 2015-05-28 | AAXJ | ETF | 66.31 | 66.83 | 66.31 | 66.61 | 3485700.0 |
| 2015-05-28 | ACTX | ETF | 2.95 | 3.009 | 2.36 | 2.36 | 1659.0 |
| 2015-05-28 | ACWF | ETF | 25.7 | 25.7 | 25.19 | 25.19 | 600.0 |
| 2015-05-28 | ACWI | ETF | 62.12 | 62.27 | 61.87 | 62.23 | 1529900.0 |
| 2015-05-28 | ACWV | ETF | 72.55 | 72.67 | 72.28 | 72.66 | 5104500.0 |
| 2015-05-28 | ACWX | ETF | 46.6 | 46.7574 | 46.41 | 46.74 | 146346.0 |
| 2015-05-28 | ADRE | ETF | 36.23 | 36.3 | 36.0 | 36.278 | 14770.0 |
| 2015-05-28 | AFK | ETF | 25.82 | 25.86 | 25.5701 | 25.76 | 6252.0 |
| 2015-05-28 | AFTY | ETF | 22.39 | 22.39 | 22.0 | 22.29 | 111100.0 |
| 2015-05-28 | AGG | ETF | 110.14 | 110.22 | 110.05 | 110.13 | 1298900.0 |
| 2015-05-28 | AGQ | ETF | 41.3 | 41.51 | 40.68 | 41.4 | 98400.0 |
| 2015-05-28 | AGZ | ETF | 113.69 | 113.72 | 113.55 | 113.64 | 8831.0 |
| 2015-05-28 | AGZD | ETF | 24.425 | 24.425 | 24.4 | 24.425 | 2400.0 |
| 2015-05-28 | AIA | ETF | 52.95 | 52.95 | 52.456 | 52.66 | 37737.0 |
| 2015-05-28 | AIQ | ETF | 19.5 | 19.51 | 19.04 | 19.14 | 12672.0 |
| 2015-05-28 | AIRR | ETF | 18.258 | 18.261 | 18.14 | 18.21 | 17700.0 |
| 2015-05-28 | AIVI | ETF | 45.43 | 45.79 | 45.31 | 45.75 | 32300.0 |
| 2015-05-28 | AMJ | ETF | 43.59 | 43.8 | 43.32 | 43.41 | 985894.0 |
| 2015-05-28 | AMLP | ETF | 83.6 | 83.65 | 82.95 | 83.1 | 467460.0 |
| 2015-05-28 | AMZA | ETF | 222.9 | 222.9 | 216.3 | 216.4 | 3600.0 |
| 2015-05-28 | ANGL | ETF | 27.69 | 27.69 | 27.65 | 27.69 | 11100.0 |
| 2015-05-28 | AOA | ETF | 49.65 | 49.94 | 48.39 | 48.67 | 46100.0 |
| 2015-05-28 | AOK | ETF | 33.75 | 33.84 | 32.9401 | 33.06 | 43317.0 |
| 2015-05-28 | AOM | ETF | 36.13 | 36.13 | 35.786 | 35.9 | 34196.0 |
| 2015-05-28 | AOR | ETF | 41.51 | 41.52 | 41.3108 | 41.52 | 77252.0 |
| 2015-05-28 | ARGT | ETF | 21.06 | 21.08 | 21.0 | 21.05 | 5300.0 |
| 2015-05-28 | ARKG | ETF | 23.218 | 23.218 | 23.218 | 23.218 | 400.0 |
| 2015-05-28 | ARKK | ETF | 21.58 | 21.58 | 21.58 | 21.58 | 100.0 |
| 2015-05-28 | ARKQ | ETF | 20.092 | 20.16 | 20.088 | 20.16 | 1000.0 |
| 2015-05-28 | ARKW | ETF | 23.4 | 23.46 | 23.38 | 23.46 | 2600.0 |
| 2015-05-28 | ASEA | ETF | 15.5 | 15.5 | 15.36 | 15.4 | 19200.0 |
| 2015-05-28 | ASHR | ETF | 49.94 | 50.36 | 49.37 | 50.17 | 4362500.0 |
| 2015-05-28 | ASHS | ETF | 64.06 | 65.33 | 64.06 | 65.25 | 292600.0 |
| 2015-05-28 | ATMP | ETF | 30.21 | 30.21 | 29.47 | 29.54 | 13600.0 |
| 2015-05-28 | AWAY | ETF | 28.35 | 28.67 | 27.95 | 28.61 | 759249.0 |
| 2015-05-28 | BAB | ETF | 29.17 | 29.25 | 29.1 | 29.12 | 72169.0 |
| 2015-05-28 | BAL | ETF | 42.8 | 43.79 | 42.8 | 43.6601 | 3079.0 |
| 2015-05-28 | BALT | ETF | 1.56 | 1.56 | 1.5 | 1.51 | 138062.0 |
| 2015-05-28 | BAR | ETF | 2.6 | 2.625 | 2.598 | 2.598 | 25270.0 |
| 2015-05-28 | BBC | ETF | 35.5 | 35.5 | 34.6 | 35.32 | 5648.0 |
| 2015-05-28 | BBH | ETF | 135.81 | 136.17 | 134.3 | 135.05 | 82600.0 |
| 2015-05-28 | BBP | ETF | 32.67 | 32.72 | 32.489 | 32.56 | 1200.0 |
| 2015-05-28 | BCHP | ETF | 20.37 | 20.4008 | 20.3605 | 20.4008 | 800.0 |
| 2015-05-28 | BCM | ETF | 31.036 | 31.2 | 31.036 | 31.199 | 1172.0 |
> showing 50 of 1,171 rows — these rows as CSV