PREVIEW / etf_daily / 2015-06-15
file: by_date/etf_daily/2015/2015-06-15.parquet size: 48 KB rows: 1,191
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-15 | SPY | ETF | 208.64 | 209.45 | 207.79 | 209.11 | 124384200.0 |
| 2015-06-15 | QQQ | ETF | 107.94 | 108.38 | 107.31 | 108.21 | 31238798.0 |
| 2015-06-15 | IWM | ETF | 125.11 | 125.8 | 123.94 | 125.53 | 30618300.0 |
| 2015-06-15 | DIA | ETF | 177.89 | 178.37 | 177.11 | 178.1 | 5502700.0 |
| 2015-06-15 | GLD | ETF | 113.28 | 114.15 | 113.21 | 113.73 | 5055100.0 |
| 2015-06-15 | TLT | ETF | 118.89 | 119.06 | 117.74 | 118.14 | 8194200.0 |
| 2015-06-15 | AAXJ | ETF | 63.59 | 63.86 | 63.59 | 63.73 | 808700.0 |
| 2015-06-15 | ACTX | ETF | 2.95 | 3.54 | 2.95 | 3.54 | 87.0 |
| 2015-06-15 | ACWF | ETF | 24.69 | 24.85 | 24.69 | 24.85 | 3590.0 |
| 2015-06-15 | ACWI | ETF | 60.67 | 61.02 | 60.63 | 60.99 | 1126100.0 |
| 2015-06-15 | ACWV | ETF | 70.7 | 70.81 | 70.5 | 70.73 | 75700.0 |
| 2015-06-15 | ACWX | ETF | 45.28 | 45.5199 | 45.28 | 45.48 | 369419.0 |
| 2015-06-15 | ADRE | ETF | 35.41 | 35.5 | 35.2301 | 35.3 | 3921.0 |
| 2015-06-15 | AFK | ETF | 24.86 | 24.9 | 24.6001 | 24.9 | 22899.0 |
| 2015-06-15 | AFTY | ETF | 23.1 | 23.1 | 22.695 | 22.81 | 65800.0 |
| 2015-06-15 | AGG | ETF | 108.96 | 108.96 | 108.63 | 108.71 | 1666600.0 |
| 2015-06-15 | AGQ | ETF | 37.93 | 39.26 | 37.93 | 38.52 | 301600.0 |
| 2015-06-15 | AGZ | ETF | 112.93 | 113.07 | 112.8 | 112.81 | 10859.0 |
| 2015-06-15 | AGZD | ETF | 24.36 | 24.44 | 24.36 | 24.425 | 2800.0 |
| 2015-06-15 | AIA | ETF | 51.19 | 51.19 | 50.61 | 50.91 | 14159.0 |
| 2015-06-15 | AIQ | ETF | 18.36 | 18.7 | 18.25 | 18.58 | 16669.0 |
| 2015-06-15 | AIRR | ETF | 18.44 | 18.52 | 18.44 | 18.52 | 16700.0 |
| 2015-06-15 | AIVI | ETF | 44.33 | 44.54 | 44.18 | 44.47 | 55400.0 |
| 2015-06-15 | AMJ | ETF | 41.52 | 42.25 | 41.39 | 42.14 | 1073094.0 |
| 2015-06-15 | AMLP | ETF | 80.25 | 81.5 | 80.2 | 81.35 | 1736840.0 |
| 2015-06-15 | AMZA | ETF | 205.6 | 208.7 | 205.6 | 208.7 | 390.0 |
| 2015-06-15 | ANGL | ETF | 27.28 | 27.33 | 27.28 | 27.32 | 23900.0 |
| 2015-06-15 | AOA | ETF | 48.77 | 48.77 | 47.59 | 47.79 | 30800.0 |
| 2015-06-15 | AOK | ETF | 32.56 | 32.6 | 32.46 | 32.48 | 69556.0 |
| 2015-06-15 | AOM | ETF | 35.26 | 35.39 | 35.26 | 35.34 | 51616.0 |
| 2015-06-15 | AOR | ETF | 40.61 | 40.83 | 40.61 | 40.74 | 217608.0 |
| 2015-06-15 | ARGT | ETF | 21.13 | 21.13 | 20.93 | 20.98 | 18900.0 |
| 2015-06-15 | ARKG | ETF | 22.93 | 23.2 | 22.88 | 23.2 | 800.0 |
| 2015-06-15 | ARKK | ETF | 21.6 | 21.6 | 21.37 | 21.37 | 400.0 |
| 2015-06-15 | ARKQ | ETF | 20.01 | 20.01 | 19.95 | 19.95 | 200.0 |
| 2015-06-15 | ARKW | ETF | 23.34 | 23.34 | 23.304 | 23.304 | 700.0 |
| 2015-06-15 | ASEA | ETF | 14.96 | 15.0 | 14.95 | 14.97 | 4400.0 |
| 2015-06-15 | ASHR | ETF | 53.27 | 53.43 | 52.91 | 53.21 | 3047100.0 |
| 2015-06-15 | ASHS | ETF | 74.25 | 74.25 | 73.68 | 73.78 | 165000.0 |
| 2015-06-15 | ATMP | ETF | 28.25 | 28.49 | 28.2 | 28.49 | 20800.0 |
| 2015-06-15 | AWAY | ETF | 30.41 | 31.0 | 30.05 | 30.97 | 784472.0 |
| 2015-06-15 | BAB | ETF | 28.89 | 28.95 | 28.74 | 28.8 | 62648.0 |
| 2015-06-15 | BAL | ETF | 42.86 | 42.86 | 42.36 | 42.8 | 8629.0 |
| 2015-06-15 | BALT | ETF | 1.54 | 1.55 | 1.52 | 1.53 | 121679.0 |
| 2015-06-15 | BAR | ETF | 2.613 | 2.6412 | 2.611 | 2.6159 | 35200.0 |
| 2015-06-15 | BBC | ETF | 35.98 | 35.98 | 35.11 | 35.85 | 33310.0 |
| 2015-06-15 | BBH | ETF | 132.59 | 133.52 | 131.62 | 133.35 | 125200.0 |
| 2015-06-15 | BBP | ETF | 33.9 | 33.9 | 33.25 | 33.76 | 36000.0 |
| 2015-06-15 | BCHP | ETF | 20.021 | 20.021 | 20.021 | 20.021 | 150.0 |
| 2015-06-15 | BCM | ETF | 31.88 | 31.88 | 31.12 | 31.15 | 3189.0 |
> showing 50 of 1,191 rows — these rows as CSV