PREVIEW / etf_daily / 2015-11-03
file: by_date/etf_daily/2015/2015-11-03.parquet size: 49 KB rows: 1,221
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-11-03 | SPY | ETF | 209.97 | 211.66 | 209.7 | 211.0 | 95246100.0 |
| 2015-11-03 | QQQ | ETF | 114.38 | 115.42 | 114.21 | 115.01 | 20418387.0 |
| 2015-11-03 | IWM | ETF | 117.59 | 119.03 | 117.39 | 118.35 | 28626300.0 |
| 2015-11-03 | DIA | ETF | 177.92 | 179.6 | 177.8 | 179.07 | 4284900.0 |
| 2015-11-03 | GLD | ETF | 107.79 | 107.81 | 106.68 | 106.98 | 7145300.0 |
| 2015-11-03 | TLT | ETF | 121.65 | 121.74 | 120.79 | 120.95 | 8921600.0 |
| 2015-11-03 | AADR | ETF | 38.62 | 39.12 | 38.62 | 39.12 | 4000.0 |
| 2015-11-03 | AAXJ | ETF | 57.13 | 58.0 | 57.13 | 57.79 | 767500.0 |
| 2015-11-03 | ACTX | ETF | 11.8001 | 11.8001 | 9.4401 | 9.4401 | 1436.0 |
| 2015-11-03 | ACWF | ETF | 24.11 | 24.11 | 24.11 | 24.11 | 1204.0 |
| 2015-11-03 | ACWI | ETF | 58.56 | 59.05 | 58.48 | 58.91 | 1305600.0 |
| 2015-11-03 | ACWV | ETF | 70.85 | 71.2 | 70.58 | 70.98 | 100200.0 |
| 2015-11-03 | ACWX | ETF | 41.82 | 42.26 | 41.81 | 42.16 | 1490525.0 |
| 2015-11-03 | ADRE | ETF | 31.33 | 31.9599 | 31.33 | 31.7 | 8102.0 |
| 2015-11-03 | AFK | ETF | 20.44 | 20.75 | 20.37 | 20.54 | 139927.0 |
| 2015-11-03 | AFTY | ETF | 15.79 | 15.922 | 15.79 | 15.85 | 3700.0 |
| 2015-11-03 | AGG | ETF | 108.95 | 109.0 | 108.79 | 108.82 | 3033400.0 |
| 2015-11-03 | AGQ | ETF | 33.62 | 33.7 | 33.11 | 33.41 | 186700.0 |
| 2015-11-03 | AGZ | ETF | 113.64 | 113.64 | 113.4 | 113.41 | 28598.0 |
| 2015-11-03 | AGZD | ETF | 24.04 | 24.11 | 24.0 | 24.0 | 2400.0 |
| 2015-11-03 | AIA | ETF | 45.92 | 46.49 | 45.92 | 46.3 | 16159.0 |
| 2015-11-03 | AIQ | ETF | 9.38 | 9.5 | 8.5 | 9.1 | 37961.0 |
| 2015-11-03 | AIRR | ETF | 17.1 | 17.27 | 17.1 | 17.24 | 29900.0 |
| 2015-11-03 | AIVI | ETF | 40.4 | 40.88 | 40.4 | 40.77 | 22800.0 |
| 2015-11-03 | AMJ | ETF | 33.87 | 34.89 | 33.76 | 34.71 | 3325167.0 |
| 2015-11-03 | AMLP | ETF | 69.25 | 70.8 | 69.0 | 70.45 | 2995560.0 |
| 2015-11-03 | AMZA | ETF | 148.0 | 152.9 | 148.0 | 151.7 | 1840.0 |
| 2015-11-03 | ANGL | ETF | 26.13 | 26.13 | 26.02 | 26.09 | 7400.0 |
| 2015-11-03 | AOA | ETF | 46.34 | 46.59 | 46.22 | 46.48 | 73700.0 |
| 2015-11-03 | AOK | ETF | 32.22 | 32.26 | 32.14 | 32.2011 | 46179.0 |
| 2015-11-03 | AOM | ETF | 34.81 | 34.88 | 34.725 | 34.86 | 88084.0 |
| 2015-11-03 | AOR | ETF | 39.75 | 40.05 | 39.75 | 40.0 | 105388.0 |
| 2015-11-03 | ARGT | ETF | 19.6 | 19.6 | 19.12 | 19.54 | 24000.0 |
| 2015-11-03 | ARKG | ETF | 20.49 | 20.49 | 20.49 | 20.49 | 400.0 |
| 2015-11-03 | ARKK | ETF | 20.455 | 20.455 | 20.455 | 20.455 | 500.0 |
| 2015-11-03 | ARKQ | ETF | 19.36 | 19.36 | 19.36 | 19.36 | 200.0 |
| 2015-11-03 | ARKW | ETF | 23.56 | 23.56 | 23.48 | 23.48 | 700.0 |
| 2015-11-03 | ASEA | ETF | 13.2 | 13.41 | 13.2 | 13.34 | 8300.0 |
| 2015-11-03 | ASHR | ETF | 34.9 | 35.08 | 34.69 | 34.92 | 800200.0 |
| 2015-11-03 | ASHS | ETF | 42.26 | 42.26 | 41.89 | 41.9 | 25200.0 |
| 2015-11-03 | ASHX | ETF | 24.4458 | 24.4458 | 24.44 | 24.44 | 2260.0 |
| 2015-11-03 | ATMP | ETF | 22.59 | 23.4 | 22.49 | 23.28 | 212600.0 |
| 2015-11-03 | AWAY | ETF | 32.52 | 32.52 | 31.63 | 31.74 | 1123789.0 |
| 2015-11-03 | BAB | ETF | 29.11 | 29.1685 | 29.02 | 29.05 | 75536.0 |
| 2015-11-03 | BAL | ETF | 42.48 | 42.57 | 41.74 | 41.846 | 12798.0 |
| 2015-11-03 | BBC | ETF | 29.59 | 30.28 | 29.0 | 29.87 | 19247.0 |
| 2015-11-03 | BBH | ETF | 127.38 | 127.9 | 125.63 | 127.14 | 127000.0 |
| 2015-11-03 | BBP | ETF | 32.07 | 32.47 | 31.706 | 32.28 | 5300.0 |
| 2015-11-03 | BCM | ETF | 26.903 | 27.0199 | 26.903 | 27.0199 | 11049.0 |
| 2015-11-03 | BDCZ | ETF | 20.33 | 20.44 | 20.27 | 20.39 | 1000.0 |
> showing 50 of 1,221 rows — these rows as CSV