PREVIEW / etf_daily / 2015-08-06
file: by_date/etf_daily/2015/2015-08-06.parquet size: 47 KB rows: 1,184
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-06 | SPY | ETF | 210.29 | 210.42 | 207.65 | 208.35 | 116030800.0 |
| 2015-08-06 | QQQ | ETF | 112.35 | 112.5 | 109.95 | 110.45 | 42125401.0 |
| 2015-08-06 | IWM | ETF | 122.47 | 122.66 | 119.78 | 120.69 | 42225300.0 |
| 2015-08-06 | DIA | ETF | 175.48 | 175.65 | 173.65 | 174.22 | 5374100.0 |
| 2015-08-06 | GLD | ETF | 104.15 | 104.86 | 104.14 | 104.39 | 3908100.0 |
| 2015-08-06 | TLT | ETF | 122.0 | 122.87 | 122.0 | 122.73 | 6118100.0 |
| 2015-08-06 | AADR | ETF | 39.44 | 39.79 | 39.44 | 39.79 | 2100.0 |
| 2015-08-06 | AAXJ | ETF | 58.37 | 58.53 | 58.08 | 58.19 | 1222300.0 |
| 2015-08-06 | ACTX | ETF | 1.77 | 1.77 | 1.711 | 1.77 | 255.0 |
| 2015-08-06 | ACWI | ETF | 59.94 | 59.96 | 59.34 | 59.54 | 1385300.0 |
| 2015-08-06 | ACWV | ETF | 71.51 | 71.57 | 70.96 | 71.08 | 48200.0 |
| 2015-08-06 | ACWX | ETF | 44.02 | 44.02 | 43.76 | 43.895 | 654919.0 |
| 2015-08-06 | ADRE | ETF | 32.47 | 32.47 | 32.275 | 32.4593 | 18255.0 |
| 2015-08-06 | AFK | ETF | 22.4 | 22.4 | 22.24 | 22.35 | 8773.0 |
| 2015-08-06 | AFTY | ETF | 18.325 | 18.325 | 18.1 | 18.11 | 18700.0 |
| 2015-08-06 | AGG | ETF | 108.93 | 109.1 | 108.9 | 109.01 | 1038100.0 |
| 2015-08-06 | AGQ | ETF | 31.28 | 32.0 | 31.26 | 31.43 | 94200.0 |
| 2015-08-06 | AGZ | ETF | 113.25 | 113.5399 | 112.89 | 113.253 | 9967.0 |
| 2015-08-06 | AGZD | ETF | 24.36 | 24.48 | 24.255 | 24.28 | 8800.0 |
| 2015-08-06 | AIA | ETF | 46.164 | 46.164 | 45.9 | 46.04 | 11535.0 |
| 2015-08-06 | AIQ | ETF | 15.12 | 15.8599 | 14.84 | 15.39 | 18152.0 |
| 2015-08-06 | AIRR | ETF | 16.976 | 17.12 | 16.97 | 17.04 | 72700.0 |
| 2015-08-06 | AIVI | ETF | 43.26 | 43.27 | 43.05 | 43.22 | 81400.0 |
| 2015-08-06 | ALTY | ETF | 14.79 | 14.79 | 14.65 | 14.77 | 1500.0 |
| 2015-08-06 | AMJ | ETF | 35.1 | 35.31 | 33.68 | 34.94 | 5593245.0 |
| 2015-08-06 | AMLP | ETF | 72.5 | 72.75 | 69.75 | 72.2 | 3196340.0 |
| 2015-08-06 | AMZA | ETF | 162.5 | 162.8 | 152.9 | 161.06 | 2730.0 |
| 2015-08-06 | ANGL | ETF | 26.83 | 26.83 | 26.75 | 26.79 | 18900.0 |
| 2015-08-06 | AOA | ETF | 47.26 | 47.27 | 46.91 | 47.02 | 92100.0 |
| 2015-08-06 | AOK | ETF | 32.38 | 32.43 | 32.32 | 32.379 | 47994.0 |
| 2015-08-06 | AOM | ETF | 35.19 | 35.19 | 34.994 | 35.06 | 34927.0 |
| 2015-08-06 | AOR | ETF | 40.57 | 40.57 | 40.3001 | 40.346 | 37005.0 |
| 2015-08-06 | ARGT | ETF | 18.21 | 18.56 | 18.06 | 18.55 | 3100.0 |
| 2015-08-06 | ARKG | ETF | 22.92 | 22.92 | 21.94 | 21.94 | 3600.0 |
| 2015-08-06 | ARKK | ETF | 20.75 | 20.8 | 20.7 | 20.8 | 1400.0 |
| 2015-08-06 | ARKQ | ETF | 19.0 | 19.02 | 18.96 | 19.02 | 2700.0 |
| 2015-08-06 | ARKW | ETF | 23.59 | 23.59 | 23.18 | 23.3 | 2600.0 |
| 2015-08-06 | ASEA | ETF | 14.28 | 14.28 | 14.13 | 14.15 | 2900.0 |
| 2015-08-06 | ASHR | ETF | 39.75 | 39.99 | 39.55 | 39.65 | 1941500.0 |
| 2015-08-06 | ASHS | ETF | 48.6 | 48.6 | 48.31 | 48.39 | 23100.0 |
| 2015-08-06 | ATMP | ETF | 23.57 | 24.19 | 23.33 | 24.06 | 38800.0 |
| 2015-08-06 | AWAY | ETF | 31.26 | 31.73 | 30.28 | 30.61 | 1464448.0 |
| 2015-08-06 | BAB | ETF | 29.03 | 29.23 | 29.0273 | 29.13 | 85973.0 |
| 2015-08-06 | BAL | ETF | 42.04 | 42.04 | 41.48 | 41.5799 | 50274.0 |
| 2015-08-06 | BBC | ETF | 36.67 | 37.24 | 34.4 | 34.53 | 31560.0 |
| 2015-08-06 | BBH | ETF | 141.91 | 141.99 | 135.87 | 136.02 | 161600.0 |
| 2015-08-06 | BBP | ETF | 36.78 | 36.78 | 34.78 | 34.95 | 51400.0 |
| 2015-08-06 | BCM | ETF | 27.3712 | 27.41 | 27.36 | 27.3895 | 9122.0 |
| 2015-08-06 | BFOR | ETF | 8.215 | 8.215 | 8.105 | 8.15 | 63600.0 |
| 2015-08-06 | BIB | ETF | 98.74 | 98.9599 | 90.0 | 90.27 | 1250690.0 |
> showing 50 of 1,184 rows — these rows as CSV