PREVIEW / etf_daily / 2015-06-04
file: by_date/etf_daily/2015/2015-06-04.parquet size: 48 KB rows: 1,179
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-06-04 | SPY | ETF | 211.07 | 211.86 | 209.75 | 210.13 | 151882800.0 |
| 2015-06-04 | QQQ | ETF | 109.78 | 110.48 | 109.21 | 109.56 | 31374588.0 |
| 2015-06-04 | IWM | ETF | 125.08 | 125.62 | 124.08 | 124.5 | 25820600.0 |
| 2015-06-04 | DIA | ETF | 180.18 | 180.92 | 178.78 | 179.21 | 7312500.0 |
| 2015-06-04 | GLD | ETF | 112.98 | 113.15 | 112.48 | 112.84 | 5566600.0 |
| 2015-06-04 | TLT | ETF | 118.26 | 119.29 | 118.14 | 119.05 | 10859300.0 |
| 2015-06-04 | AADR | ETF | 39.81 | 39.81 | 39.81 | 39.81 | 100.0 |
| 2015-06-04 | AAXJ | ETF | 65.55 | 65.63 | 65.17 | 65.24 | 576500.0 |
| 2015-06-04 | ACTX | ETF | 4.13 | 4.13 | 2.95 | 3.54 | 38.0 |
| 2015-06-04 | ACWF | ETF | 24.99 | 24.99 | 24.99 | 24.99 | 1050.0 |
| 2015-06-04 | ACWI | ETF | 61.67 | 61.96 | 61.29 | 61.42 | 681400.0 |
| 2015-06-04 | ACWV | ETF | 71.63 | 71.82 | 71.26 | 71.44 | 167000.0 |
| 2015-06-04 | ACWX | ETF | 46.14 | 46.48 | 45.8601 | 46.0 | 242649.0 |
| 2015-06-04 | ADRE | ETF | 35.73 | 35.7724 | 35.41 | 35.41 | 11608.0 |
| 2015-06-04 | AFK | ETF | 25.43 | 25.43 | 25.12 | 25.12 | 16290.0 |
| 2015-06-04 | AFTY | ETF | 23.51 | 23.51 | 23.07 | 23.07 | 34800.0 |
| 2015-06-04 | AGG | ETF | 108.89 | 109.17 | 108.89 | 109.03 | 1907900.0 |
| 2015-06-04 | AGQ | ETF | 39.35 | 39.59 | 38.6 | 38.9 | 342200.0 |
| 2015-06-04 | AGZ | ETF | 112.92 | 113.151 | 112.92 | 113.08 | 7363.0 |
| 2015-06-04 | AGZD | ETF | 24.45 | 24.465 | 24.33 | 24.345 | 8400.0 |
| 2015-06-04 | AIA | ETF | 52.27 | 52.27 | 51.93 | 51.98 | 16655.0 |
| 2015-06-04 | AIQ | ETF | 18.72 | 18.8 | 18.13 | 18.21 | 12277.0 |
| 2015-06-04 | AIRR | ETF | 18.55 | 18.55 | 18.39 | 18.396 | 15800.0 |
| 2015-06-04 | AIVI | ETF | 45.18 | 45.41 | 44.9 | 45.02 | 12600.0 |
| 2015-06-04 | AMJ | ETF | 42.4 | 42.77 | 41.785 | 41.82 | 2477699.0 |
| 2015-06-04 | AMLP | ETF | 81.7 | 82.05 | 80.8 | 80.85 | 1131080.0 |
| 2015-06-04 | AMZA | ETF | 212.7 | 212.7 | 204.6 | 206.8 | 2330.0 |
| 2015-06-04 | ANGL | ETF | 27.58 | 27.8 | 27.43 | 27.51 | 92200.0 |
| 2015-06-04 | AOA | ETF | 48.39 | 48.39 | 48.05 | 48.06 | 31500.0 |
| 2015-06-04 | AOK | ETF | 32.8 | 32.8 | 32.63 | 32.71 | 54015.0 |
| 2015-06-04 | AOM | ETF | 35.61 | 35.65 | 35.5031 | 35.57 | 43161.0 |
| 2015-06-04 | AOR | ETF | 41.33 | 41.33 | 41.0 | 41.09 | 83518.0 |
| 2015-06-04 | ARGT | ETF | 21.49 | 21.6 | 21.48 | 21.54 | 32400.0 |
| 2015-06-04 | ARKG | ETF | 23.5 | 23.5 | 23.19 | 23.23 | 900.0 |
| 2015-06-04 | ARKK | ETF | 21.6 | 21.6 | 21.6 | 21.6 | 2600.0 |
| 2015-06-04 | ARKQ | ETF | 20.26 | 20.26 | 20.05 | 20.07 | 1600.0 |
| 2015-06-04 | ARKW | ETF | 23.59 | 23.59 | 23.108 | 23.108 | 5700.0 |
| 2015-06-04 | ASEA | ETF | 15.1 | 15.19 | 15.04 | 15.09 | 12900.0 |
| 2015-06-04 | ASHR | ETF | 53.32 | 53.52 | 52.64 | 52.86 | 2678100.0 |
| 2015-06-04 | ASHS | ETF | 72.0 | 72.0 | 70.85 | 71.21 | 204300.0 |
| 2015-06-04 | ATMP | ETF | 29.2 | 29.2 | 28.44 | 28.44 | 21600.0 |
| 2015-06-04 | AWAY | ETF | 30.51 | 30.55 | 29.68 | 30.12 | 1130853.0 |
| 2015-06-04 | BAB | ETF | 28.81 | 29.0 | 28.7609 | 28.98 | 315412.0 |
| 2015-06-04 | BAL | ETF | 44.51 | 44.7154 | 44.17 | 44.2708 | 9298.0 |
| 2015-06-04 | BALT | ETF | 1.54 | 1.56 | 1.48 | 1.49 | 224007.0 |
| 2015-06-04 | BAR | ETF | 2.555 | 2.556 | 2.545 | 2.556 | 19720.0 |
| 2015-06-04 | BBC | ETF | 36.38 | 36.38 | 35.26 | 35.76 | 29378.0 |
| 2015-06-04 | BBH | ETF | 133.22 | 133.9 | 131.77 | 132.56 | 97100.0 |
| 2015-06-04 | BBP | ETF | 33.6 | 33.66 | 33.02 | 33.386 | 24200.0 |
| 2015-06-04 | BCM | ETF | 31.24 | 33.01 | 31.03 | 31.15 | 7288.0 |
> showing 50 of 1,179 rows — these rows as CSV