PREVIEW / etf_daily / 2015-06-03
file: by_date/etf_daily/2015/2015-06-03.parquet size: 48 KB rows: 1,183
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-03 | SPY | ETF | 212.0 | 212.67 | 211.33 | 211.92 | 87820900.0 |
| 2015-06-03 | QQQ | ETF | 110.57 | 110.81 | 110.13 | 110.4 | 20507208.0 |
| 2015-06-03 | IWM | ETF | 124.76 | 125.93 | 124.42 | 125.76 | 30774800.0 |
| 2015-06-03 | DIA | ETF | 180.85 | 181.74 | 180.12 | 180.88 | 5481500.0 |
| 2015-06-03 | GLD | ETF | 114.13 | 114.37 | 113.08 | 113.64 | 4885200.0 |
| 2015-06-03 | TLT | ETF | 118.39 | 118.6 | 117.2 | 117.52 | 14810900.0 |
| 2015-06-03 | AADR | ETF | 40.21 | 40.21 | 40.21 | 40.21 | 200.0 |
| 2015-06-03 | AAXJ | ETF | 65.97 | 66.1 | 65.74 | 65.99 | 562900.0 |
| 2015-06-03 | ACTX | ETF | 2.95 | 4.13 | 2.891 | 3.54 | 1386.0 |
| 2015-06-03 | ACWF | ETF | 25.24 | 25.28 | 25.24 | 25.28 | 240.0 |
| 2015-06-03 | ACWI | ETF | 62.02 | 62.25 | 61.89 | 62.02 | 1226200.0 |
| 2015-06-03 | ACWV | ETF | 72.14 | 72.17 | 71.82 | 71.9 | 69400.0 |
| 2015-06-03 | ACWX | ETF | 46.44 | 46.74 | 46.44 | 46.54 | 68533.0 |
| 2015-06-03 | ADRE | ETF | 36.17 | 36.26 | 35.98 | 35.98 | 26523.0 |
| 2015-06-03 | AFK | ETF | 25.62 | 25.71 | 25.5 | 25.51 | 26391.0 |
| 2015-06-03 | AFTY | ETF | 22.69 | 22.77 | 22.68 | 22.69 | 65100.0 |
| 2015-06-03 | AGG | ETF | 108.98 | 109.01 | 108.67 | 108.8 | 3413100.0 |
| 2015-06-03 | AGQ | ETF | 40.9 | 41.17 | 39.96 | 40.65 | 262600.0 |
| 2015-06-03 | AGZ | ETF | 113.09 | 113.1 | 112.85 | 112.86 | 44948.0 |
| 2015-06-03 | AGZD | ETF | 24.38 | 24.41 | 24.375 | 24.38 | 28600.0 |
| 2015-06-03 | AIA | ETF | 52.44 | 52.5199 | 52.32 | 52.4 | 12746.0 |
| 2015-06-03 | AIQ | ETF | 18.7 | 18.815 | 18.52 | 18.62 | 8745.0 |
| 2015-06-03 | AIRR | ETF | 18.46 | 18.676 | 18.44 | 18.64 | 4400.0 |
| 2015-06-03 | AIVI | ETF | 45.5 | 45.83 | 45.5 | 45.58 | 28100.0 |
| 2015-06-03 | AMJ | ETF | 43.26 | 43.31 | 42.53 | 42.56 | 1741351.0 |
| 2015-06-03 | AMLP | ETF | 83.1 | 83.25 | 81.9 | 81.95 | 1408940.0 |
| 2015-06-03 | AMZA | ETF | 218.4 | 218.4 | 212.56 | 212.56 | 2290.0 |
| 2015-06-03 | ANGL | ETF | 27.77 | 27.77 | 27.5 | 27.5 | 30600.0 |
| 2015-06-03 | AOA | ETF | 48.38 | 48.57 | 48.37 | 48.45 | 42900.0 |
| 2015-06-03 | AOK | ETF | 32.97 | 32.97 | 32.72 | 32.73 | 32875.0 |
| 2015-06-03 | AOM | ETF | 35.65 | 35.75 | 35.55 | 35.55 | 75954.0 |
| 2015-06-03 | AOR | ETF | 41.34 | 41.38 | 41.1713 | 41.24 | 70663.0 |
| 2015-06-03 | ARGT | ETF | 21.69 | 21.69 | 21.45 | 21.45 | 17800.0 |
| 2015-06-03 | ARKG | ETF | 23.41 | 23.47 | 23.41 | 23.446 | 300.0 |
| 2015-06-03 | ARKK | ETF | 21.62 | 21.68 | 21.616 | 21.68 | 400.0 |
| 2015-06-03 | ARKQ | ETF | 20.324 | 20.324 | 20.28 | 20.3 | 2000.0 |
| 2015-06-03 | ARKW | ETF | 23.38 | 23.38 | 23.25 | 23.37 | 1900.0 |
| 2015-06-03 | ASEA | ETF | 15.16 | 15.17 | 15.16 | 15.17 | 3000.0 |
| 2015-06-03 | ASHR | ETF | 52.97 | 53.12 | 52.84 | 52.96 | 1907900.0 |
| 2015-06-03 | ASHS | ETF | 72.36 | 72.41 | 72.01 | 72.11 | 198200.0 |
| 2015-06-03 | ATMP | ETF | 29.4 | 29.4 | 28.99 | 28.99 | 13600.0 |
| 2015-06-03 | AWAY | ETF | 30.11 | 30.81 | 30.06 | 30.68 | 1656606.0 |
| 2015-06-03 | BAB | ETF | 28.87 | 28.87 | 28.5 | 28.69 | 3649416.0 |
| 2015-06-03 | BAL | ETF | 43.6154 | 44.2977 | 43.6154 | 44.09 | 8223.0 |
| 2015-06-03 | BALT | ETF | 1.53 | 1.56 | 1.5201 | 1.56 | 226683.0 |
| 2015-06-03 | BAR | ETF | 2.672 | 2.672 | 2.606 | 2.606 | 13610.0 |
| 2015-06-03 | BBC | ETF | 35.35 | 36.04 | 35.35 | 35.97 | 36245.0 |
| 2015-06-03 | BBH | ETF | 133.99 | 134.23 | 132.97 | 133.77 | 72400.0 |
| 2015-06-03 | BBP | ETF | 32.91 | 33.55 | 32.91 | 33.439 | 16900.0 |
| 2015-06-03 | BCHP | ETF | 20.62 | 20.62 | 20.62 | 20.62 | 138.0 |
> showing 50 of 1,183 rows — these rows as CSV