PREVIEW / etf_daily / 2015-11-13
file: by_date/etf_daily/2015/2015-11-13.parquet size: 49 KB rows: 1,215
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-13 | SPY | ETF | 204.35 | 204.67 | 202.44 | 202.54 | 153577100.0 |
| 2015-11-13 | QQQ | ETF | 111.57 | 111.69 | 109.78 | 109.84 | 52836036.0 |
| 2015-11-13 | IWM | ETF | 114.44 | 115.34 | 113.66 | 114.07 | 43883000.0 |
| 2015-11-13 | DIA | ETF | 174.07 | 174.55 | 172.55 | 172.61 | 8011100.0 |
| 2015-11-13 | GLD | ETF | 103.54 | 103.74 | 103.45 | 103.56 | 3224200.0 |
| 2015-11-13 | TLT | ETF | 119.32 | 119.9 | 119.22 | 119.68 | 7906600.0 |
| 2015-11-13 | AADR | ETF | 37.63 | 37.99 | 37.58 | 37.99 | 1700.0 |
| 2015-11-13 | AAXJ | ETF | 54.75 | 54.8 | 54.34 | 54.46 | 1355300.0 |
| 2015-11-13 | ACTX | ETF | 5.31 | 5.31 | 4.13 | 4.72 | 4841.0 |
| 2015-11-13 | ACWI | ETF | 56.72 | 56.84 | 56.37 | 56.41 | 1071800.0 |
| 2015-11-13 | ACWV | ETF | 69.06 | 69.13 | 68.61 | 68.68 | 65700.0 |
| 2015-11-13 | ACWX | ETF | 40.4 | 40.45 | 40.18 | 40.25 | 744915.0 |
| 2015-11-13 | ADRE | ETF | 30.09 | 30.09 | 29.5701 | 29.66 | 10723.0 |
| 2015-11-13 | AFK | ETF | 19.09 | 19.1081 | 18.9 | 18.98 | 33387.0 |
| 2015-11-13 | AFTY | ETF | 16.477 | 16.73 | 16.44 | 16.697 | 173700.0 |
| 2015-11-13 | AGG | ETF | 108.48 | 108.59 | 108.45 | 108.55 | 3784100.0 |
| 2015-11-13 | AGQ | ETF | 28.99 | 29.09 | 28.8 | 28.94 | 155100.0 |
| 2015-11-13 | AGZ | ETF | 113.2004 | 113.4 | 113.12 | 113.35 | 14571.0 |
| 2015-11-13 | AGZD | ETF | 24.05 | 24.095 | 24.05 | 24.06 | 800.0 |
| 2015-11-13 | AIA | ETF | 44.3 | 44.3 | 43.99 | 44.04 | 65445.0 |
| 2015-11-13 | AIQ | ETF | 8.6 | 9.29 | 8.41 | 9.17 | 96629.0 |
| 2015-11-13 | AIRR | ETF | 16.6 | 16.95 | 16.6 | 16.782 | 4700.0 |
| 2015-11-13 | AIVI | ETF | 38.65 | 38.68 | 38.46 | 38.54 | 24700.0 |
| 2015-11-13 | AMJ | ETF | 30.82 | 31.31 | 30.23 | 31.06 | 5330996.0 |
| 2015-11-13 | AMLP | ETF | 61.95 | 62.7 | 60.5 | 62.1 | 2237740.0 |
| 2015-11-13 | AMZA | ETF | 130.0 | 130.3 | 123.0 | 129.1 | 2380.0 |
| 2015-11-13 | ANGL | ETF | 25.69 | 25.69 | 25.56 | 25.61 | 11200.0 |
| 2015-11-13 | AOA | ETF | 45.34 | 45.34 | 44.97 | 45.01 | 43800.0 |
| 2015-11-13 | AOK | ETF | 31.73 | 31.88 | 31.73 | 31.77 | 107000.0 |
| 2015-11-13 | AOM | ETF | 34.3 | 34.33 | 34.2 | 34.25 | 137165.0 |
| 2015-11-13 | AOR | ETF | 39.09 | 39.15 | 38.955 | 38.99 | 171217.0 |
| 2015-11-13 | ARGT | ETF | 19.08 | 19.21 | 18.97 | 19.19 | 10600.0 |
| 2015-11-13 | ARKG | ETF | 19.65 | 19.86 | 19.65 | 19.8 | 700.0 |
| 2015-11-13 | ARKK | ETF | 19.94 | 19.94 | 19.82 | 19.82 | 1000.0 |
| 2015-11-13 | ARKQ | ETF | 18.65 | 18.65 | 18.43 | 18.43 | 200.0 |
| 2015-11-13 | ARKW | ETF | 23.0 | 23.0 | 22.58 | 22.595 | 3200.0 |
| 2015-11-13 | ASEA | ETF | 12.64 | 12.64 | 12.52 | 12.54 | 4000.0 |
| 2015-11-13 | ASHR | ETF | 36.69 | 36.69 | 36.06 | 36.18 | 3108200.0 |
| 2015-11-13 | ASHS | ETF | 45.01 | 45.8 | 44.28 | 44.61 | 242500.0 |
| 2015-11-13 | ASHX | ETF | 26.23 | 26.23 | 25.472 | 25.472 | 500.0 |
| 2015-11-13 | ATMP | ETF | 20.35 | 20.59 | 19.93 | 20.59 | 99800.0 |
| 2015-11-13 | AWAY | ETF | 36.3 | 36.41 | 35.7 | 35.77 | 4159960.0 |
| 2015-11-13 | BAB | ETF | 28.72 | 28.78 | 28.72 | 28.75 | 57746.0 |
| 2015-11-13 | BAL | ETF | 41.14 | 41.18 | 40.91 | 41.1 | 10022.0 |
| 2015-11-13 | BBC | ETF | 28.0544 | 30.1499 | 28.0544 | 29.65 | 11147.0 |
| 2015-11-13 | BBH | ETF | 120.51 | 122.6 | 119.76 | 120.85 | 96900.0 |
| 2015-11-13 | BBP | ETF | 30.0 | 30.8 | 29.705 | 30.44 | 10700.0 |
| 2015-11-13 | BCM | ETF | 25.1 | 25.15 | 25.0901 | 25.14 | 1633.0 |
| 2015-11-13 | BFOR | ETF | 7.7 | 7.7 | 7.63 | 7.645 | 33600.0 |
| 2015-11-13 | BIB | ETF | 64.44 | 67.85 | 64.0 | 65.95 | 795295.0 |
> showing 50 of 1,215 rows — these rows as CSV