PREVIEW / etf_daily / 2015-11-18
file: by_date/etf_daily/2015/2015-11-18.parquet size: 49 KB rows: 1,226
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-18 | SPY | ETF | 206.04 | 208.9 | 205.99 | 208.73 | 121342500.0 |
| 2015-11-18 | QQQ | ETF | 111.94 | 113.74 | 111.83 | 113.63 | 32966463.0 |
| 2015-11-18 | IWM | ETF | 114.93 | 116.65 | 114.52 | 116.55 | 35554300.0 |
| 2015-11-18 | DIA | ETF | 175.68 | 177.84 | 175.67 | 177.73 | 6254400.0 |
| 2015-11-18 | GLD | ETF | 102.39 | 102.95 | 102.04 | 102.43 | 5043800.0 |
| 2015-11-18 | TLT | ETF | 119.58 | 120.19 | 119.36 | 120.02 | 5233900.0 |
| 2015-11-18 | AADR | ETF | 38.5 | 38.5 | 38.5 | 38.5 | 700.0 |
| 2015-11-18 | AAXJ | ETF | 54.83 | 55.54 | 54.83 | 55.48 | 1032400.0 |
| 2015-11-18 | ACTX | ETF | 4.72 | 5.31 | 3.953 | 4.72 | 6789.0 |
| 2015-11-18 | ACWF | ETF | 24.07 | 24.07 | 24.07 | 24.07 | 200.0 |
| 2015-11-18 | ACWI | ETF | 57.42 | 57.95 | 57.32 | 57.86 | 6718300.0 |
| 2015-11-18 | ACWV | ETF | 69.44 | 70.12 | 69.36 | 70.11 | 124800.0 |
| 2015-11-18 | ACWX | ETF | 40.98 | 41.28 | 40.89 | 41.25 | 1346363.0 |
| 2015-11-18 | ADRE | ETF | 30.07 | 30.37 | 29.9801 | 30.37 | 6364.0 |
| 2015-11-18 | AFK | ETF | 18.98 | 19.185 | 18.97 | 19.12 | 151041.0 |
| 2015-11-18 | AFTY | ETF | 16.96 | 17.06 | 16.96 | 17.04 | 4000.0 |
| 2015-11-18 | AGG | ETF | 108.65 | 108.71 | 108.54 | 108.64 | 1952100.0 |
| 2015-11-18 | AGGY | ETF | 49.42 | 49.42 | 49.41 | 49.41 | 900.0 |
| 2015-11-18 | AGQ | ETF | 28.56 | 28.92 | 28.18 | 28.73 | 197600.0 |
| 2015-11-18 | AGZ | ETF | 113.15 | 113.4199 | 113.12 | 113.23 | 47238.0 |
| 2015-11-18 | AGZD | ETF | 24.1 | 24.1 | 24.03 | 24.03 | 1600.0 |
| 2015-11-18 | AIA | ETF | 44.26 | 44.661 | 44.26 | 44.661 | 30852.0 |
| 2015-11-18 | AIQ | ETF | 7.25 | 7.62 | 6.73 | 7.28 | 206544.0 |
| 2015-11-18 | AIRR | ETF | 17.06 | 17.31 | 17.06 | 17.31 | 6500.0 |
| 2015-11-18 | AIVI | ETF | 39.33 | 39.61 | 39.3 | 39.59 | 58700.0 |
| 2015-11-18 | AMJ | ETF | 31.93 | 32.32 | 31.45 | 31.87 | 3542563.0 |
| 2015-11-18 | AMLP | ETF | 64.3 | 64.8 | 63.0 | 63.95 | 1759460.0 |
| 2015-11-18 | AMZA | ETF | 130.0 | 136.0 | 130.0 | 133.1 | 570.0 |
| 2015-11-18 | ANGL | ETF | 25.67 | 25.73 | 25.55 | 25.71 | 256600.0 |
| 2015-11-18 | AOA | ETF | 45.62 | 46.0 | 45.51 | 46.0 | 109000.0 |
| 2015-11-18 | AOK | ETF | 31.876 | 32.04 | 31.876 | 32.04 | 131578.0 |
| 2015-11-18 | AOM | ETF | 34.4868 | 34.61 | 34.4301 | 34.6 | 1267207.0 |
| 2015-11-18 | AOR | ETF | 39.47 | 39.6 | 39.32 | 39.6 | 166342.0 |
| 2015-11-18 | ARGT | ETF | 19.25 | 19.43 | 19.2 | 19.43 | 8800.0 |
| 2015-11-18 | ARKG | ETF | 20.27 | 20.355 | 20.27 | 20.355 | 700.0 |
| 2015-11-18 | ARKK | ETF | 20.19 | 20.19 | 20.19 | 20.19 | 1000.0 |
| 2015-11-18 | ARKQ | ETF | 18.9 | 18.9 | 18.9 | 18.9 | 100.0 |
| 2015-11-18 | ARKW | ETF | 22.886 | 23.18 | 22.886 | 23.18 | 1400.0 |
| 2015-11-18 | ASEA | ETF | 12.62 | 12.73 | 12.62 | 12.73 | 1700.0 |
| 2015-11-18 | ASHR | ETF | 37.16 | 37.57 | 37.08 | 37.47 | 3502500.0 |
| 2015-11-18 | ASHS | ETF | 45.92 | 46.26 | 45.5 | 45.96 | 75300.0 |
| 2015-11-18 | ASHX | ETF | 26.2775 | 26.2775 | 26.2775 | 26.2775 | 700.0 |
| 2015-11-18 | ATMP | ETF | 21.09 | 21.35 | 20.89 | 21.16 | 53300.0 |
| 2015-11-18 | AWAY | ETF | 34.81 | 35.77 | 34.72 | 35.66 | 8231652.0 |
| 2015-11-18 | BAB | ETF | 28.95 | 29.0 | 28.8419 | 28.97 | 30116.0 |
| 2015-11-18 | BAL | ETF | 41.85 | 41.8815 | 41.84 | 41.88 | 726.0 |
| 2015-11-18 | BBC | ETF | 29.07 | 29.98 | 29.07 | 29.98 | 7153.0 |
| 2015-11-18 | BBH | ETF | 124.26 | 127.07 | 123.85 | 126.98 | 109700.0 |
| 2015-11-18 | BBP | ETF | 30.83 | 31.64 | 30.83 | 31.64 | 8000.0 |
| 2015-11-18 | BCM | ETF | 24.89 | 24.94 | 24.79 | 24.94 | 2799.0 |
> showing 50 of 1,226 rows — these rows as CSV