PREVIEW / etf_daily / 2015-08-05
file: by_date/etf_daily/2015/2015-08-05.parquet size: 48 KB rows: 1,189
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-08-05 | SPY | ETF | 210.45 | 211.31 | 209.73 | 210.07 | 85786800.0 |
| 2015-08-05 | QQQ | ETF | 112.01 | 113.0 | 111.88 | 112.25 | 28989897.0 |
| 2015-08-05 | IWM | ETF | 122.59 | 123.53 | 121.91 | 122.34 | 25673500.0 |
| 2015-08-05 | DIA | ETF | 175.84 | 176.52 | 175.03 | 175.36 | 4565500.0 |
| 2015-08-05 | GLD | ETF | 104.42 | 104.5 | 103.78 | 103.93 | 5041000.0 |
| 2015-08-05 | TLT | ETF | 121.77 | 121.91 | 121.19 | 121.65 | 7574400.0 |
| 2015-08-05 | AADR | ETF | 40.07 | 40.07 | 40.07 | 40.07 | 200.0 |
| 2015-08-05 | AAXJ | ETF | 59.09 | 59.23 | 58.71 | 58.82 | 998900.0 |
| 2015-08-05 | ACTX | ETF | 1.475 | 1.77 | 1.475 | 1.77 | 688.0 |
| 2015-08-05 | ACWI | ETF | 60.04 | 60.23 | 59.87 | 59.94 | 492400.0 |
| 2015-08-05 | ACWV | ETF | 71.6 | 71.78 | 71.48 | 71.52 | 186800.0 |
| 2015-08-05 | ACWX | ETF | 44.12 | 44.29 | 44.02 | 44.07 | 144621.0 |
| 2015-08-05 | ADRE | ETF | 32.7 | 32.8 | 32.54 | 32.54 | 3868.0 |
| 2015-08-05 | AFK | ETF | 22.4 | 22.4125 | 22.21 | 22.23 | 17544.0 |
| 2015-08-05 | AFTY | ETF | 18.4 | 18.4 | 18.24 | 18.24 | 7400.0 |
| 2015-08-05 | AGG | ETF | 108.94 | 109.08 | 108.72 | 108.88 | 2346600.0 |
| 2015-08-05 | AGGY | ETF | 49.9 | 49.9 | 49.9 | 49.9 | 500.0 |
| 2015-08-05 | AGQ | ETF | 31.45 | 31.67 | 31.0 | 31.29 | 141100.0 |
| 2015-08-05 | AGZ | ETF | 113.15 | 113.33 | 113.08 | 113.18 | 7184.0 |
| 2015-08-05 | AGZD | ETF | 24.345 | 24.5 | 24.19 | 24.5 | 100600.0 |
| 2015-08-05 | AIA | ETF | 46.83 | 46.89 | 46.525 | 46.6089 | 12578.0 |
| 2015-08-05 | AIQ | ETF | 14.99 | 15.51 | 14.79 | 15.04 | 30112.0 |
| 2015-08-05 | AIRR | ETF | 17.265 | 17.265 | 16.97 | 17.02 | 9200.0 |
| 2015-08-05 | AIVI | ETF | 43.35 | 43.53 | 43.25 | 43.34 | 24800.0 |
| 2015-08-05 | ALTY | ETF | 14.81 | 14.81 | 14.81 | 14.81 | 100.0 |
| 2015-08-05 | AMJ | ETF | 37.15 | 37.57 | 35.13 | 35.15 | 5381298.0 |
| 2015-08-05 | AMLP | ETF | 75.5 | 76.0 | 72.55 | 72.55 | 3362580.0 |
| 2015-08-05 | AMZA | ETF | 178.9 | 181.3 | 163.4 | 163.6 | 4770.0 |
| 2015-08-05 | ANGL | ETF | 26.87 | 26.87 | 26.84 | 26.85 | 9800.0 |
| 2015-08-05 | AOA | ETF | 47.45 | 47.47 | 47.22 | 47.33 | 47200.0 |
| 2015-08-05 | AOK | ETF | 32.42 | 32.455 | 32.38 | 32.42 | 35389.0 |
| 2015-08-05 | AOM | ETF | 35.16 | 35.2514 | 35.1 | 35.18 | 46101.0 |
| 2015-08-05 | AOR | ETF | 40.58 | 40.6299 | 40.45 | 40.55 | 42937.0 |
| 2015-08-05 | ARGT | ETF | 18.24 | 18.28 | 18.11 | 18.22 | 1600.0 |
| 2015-08-05 | ARKG | ETF | 22.856 | 22.856 | 22.825 | 22.825 | 300.0 |
| 2015-08-05 | ARKK | ETF | 21.26 | 21.26 | 21.1 | 21.1 | 2300.0 |
| 2015-08-05 | ARKQ | ETF | 19.09 | 19.09 | 19.09 | 19.09 | 200.0 |
| 2015-08-05 | ARKW | ETF | 23.68 | 23.68 | 23.62 | 23.62 | 900.0 |
| 2015-08-05 | ASEA | ETF | 14.4 | 14.49 | 14.37 | 14.37 | 4200.0 |
| 2015-08-05 | ASHR | ETF | 40.1 | 40.49 | 40.09 | 40.24 | 2034100.0 |
| 2015-08-05 | ASHS | ETF | 49.09 | 49.27 | 48.93 | 49.04 | 53900.0 |
| 2015-08-05 | ATMP | ETF | 25.49 | 25.85 | 24.27 | 24.29 | 36200.0 |
| 2015-08-05 | AWAY | ETF | 30.85 | 31.86 | 30.37 | 31.07 | 5554423.0 |
| 2015-08-05 | BAB | ETF | 29.18 | 29.18 | 28.98 | 29.08 | 45684.0 |
| 2015-08-05 | BAL | ETF | 42.42 | 42.57 | 42.35 | 42.35 | 1765.0 |
| 2015-08-05 | BBC | ETF | 36.44 | 36.9999 | 36.44 | 36.4401 | 10959.0 |
| 2015-08-05 | BBH | ETF | 141.86 | 142.8 | 141.47 | 141.62 | 77100.0 |
| 2015-08-05 | BBP | ETF | 36.44 | 37.0 | 36.25 | 36.51 | 23500.0 |
| 2015-08-05 | BCHP | ETF | 19.07 | 19.08 | 19.07 | 19.08 | 200.0 |
| 2015-08-05 | BCM | ETF | 27.6 | 27.6 | 27.3 | 27.41 | 15318.0 |
> showing 50 of 1,189 rows — these rows as CSV