PREVIEW / etf_daily / 2015-04-10
file: by_date/etf_daily/2015/2015-04-10.parquet size: 47 KB rows: 1,167
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-04-10 | SPY | ETF | 209.2 | 210.09 | 208.96 | 210.04 | 72722900.0 |
| 2015-04-10 | QQQ | ETF | 107.27 | 107.76 | 107.03 | 107.75 | 17164343.0 |
| 2015-04-10 | IWM | ETF | 125.44 | 125.79 | 125.22 | 125.62 | 14966300.0 |
| 2015-04-10 | DIA | ETF | 179.67 | 180.44 | 179.18 | 180.37 | 3463600.0 |
| 2015-04-10 | GLD | ETF | 116.0 | 116.19 | 115.5 | 115.97 | 3932400.0 |
| 2015-04-10 | TLT | ETF | 130.32 | 130.45 | 129.55 | 129.62 | 4843000.0 |
| 2015-04-10 | AADR | ETF | 40.23 | 40.48 | 40.23 | 40.48 | 600.0 |
| 2015-04-10 | AAXJ | ETF | 68.13 | 68.43 | 67.94 | 68.35 | 785000.0 |
| 2015-04-10 | ACWI | ETF | 61.56 | 61.86 | 61.55 | 61.86 | 510200.0 |
| 2015-04-10 | ACWV | ETF | 73.26 | 73.39 | 73.04 | 73.36 | 147300.0 |
| 2015-04-10 | ACWX | ETF | 46.36 | 46.55 | 46.32 | 46.54 | 466762.0 |
| 2015-04-10 | ADRE | ETF | 36.91 | 36.9645 | 36.8306 | 36.9104 | 11222.0 |
| 2015-04-10 | AFK | ETF | 26.13 | 26.22 | 26.0 | 26.11 | 4844.0 |
| 2015-04-10 | AFTY | ETF | 20.88 | 21.19 | 20.88 | 21.03 | 86800.0 |
| 2015-04-10 | AGG | ETF | 111.43 | 111.46 | 111.2 | 111.25 | 2055600.0 |
| 2015-04-10 | AGQ | ETF | 41.32 | 41.74 | 40.4 | 40.84 | 207400.0 |
| 2015-04-10 | AGZ | ETF | 114.28 | 114.3 | 113.84 | 114.1699 | 9997.0 |
| 2015-04-10 | AGZD | ETF | 24.53 | 24.53 | 24.44 | 24.515 | 2600.0 |
| 2015-04-10 | AIA | ETF | 53.29 | 53.535 | 53.11 | 53.35 | 61019.0 |
| 2015-04-10 | AIQ | ETF | 23.73 | 24.2 | 23.68 | 24.12 | 19924.0 |
| 2015-04-10 | AIRR | ETF | 19.05 | 19.05 | 18.923 | 18.96 | 12200.0 |
| 2015-04-10 | AIVI | ETF | 45.01 | 45.1 | 44.81 | 45.1 | 33600.0 |
| 2015-04-10 | AMJ | ETF | 43.43 | 43.8 | 43.43 | 43.75 | 322180.0 |
| 2015-04-10 | AMLP | ETF | 83.85 | 84.05 | 83.5 | 84.0 | 571120.0 |
| 2015-04-10 | AMZA | ETF | 213.5 | 214.1 | 213.5 | 214.1 | 220.0 |
| 2015-04-10 | ANGL | ETF | 27.41 | 27.47 | 27.4 | 27.47 | 4500.0 |
| 2015-04-10 | AOA | ETF | 48.4 | 48.4 | 48.22 | 48.37 | 29900.0 |
| 2015-04-10 | AOK | ETF | 33.24 | 33.24 | 33.14 | 33.21 | 75869.0 |
| 2015-04-10 | AOM | ETF | 35.97 | 36.0 | 35.88 | 35.88 | 60664.0 |
| 2015-04-10 | AOR | ETF | 41.46 | 41.46 | 41.27 | 41.43 | 50285.0 |
| 2015-04-10 | ARGT | ETF | 21.95 | 22.16 | 21.95 | 22.06 | 17400.0 |
| 2015-04-10 | ARKG | ETF | 23.2 | 23.308 | 23.165 | 23.308 | 3700.0 |
| 2015-04-10 | ARKK | ETF | 21.41 | 21.496 | 21.41 | 21.49 | 2400.0 |
| 2015-04-10 | ARKQ | ETF | 20.57 | 20.61 | 20.57 | 20.61 | 1500.0 |
| 2015-04-10 | ARKW | ETF | 22.58 | 22.59 | 22.55 | 22.55 | 500.0 |
| 2015-04-10 | ASEA | ETF | 16.0 | 16.0 | 15.97 | 15.97 | 1000.0 |
| 2015-04-10 | ASHR | ETF | 44.24 | 45.0 | 44.2 | 45.0 | 1288900.0 |
| 2015-04-10 | ASHS | ETF | 51.7 | 53.06 | 51.7 | 52.98 | 103400.0 |
| 2015-04-10 | ATMP | ETF | 29.73 | 29.85 | 29.69 | 29.85 | 33900.0 |
| 2015-04-10 | AWAY | ETF | 31.5 | 32.04 | 31.356 | 32.02 | 554878.0 |
| 2015-04-10 | BAB | ETF | 30.42 | 30.45 | 30.28 | 30.28 | 266951.0 |
| 2015-04-10 | BAL | ETF | 44.44 | 44.55 | 44.32 | 44.38 | 25717.0 |
| 2015-04-10 | BALT | ETF | 1.4 | 1.48 | 1.39 | 1.43 | 2145705.0 |
| 2015-04-10 | BAR | ETF | 2.824 | 2.825 | 2.73 | 2.73 | 17780.0 |
| 2015-04-10 | BBC | ETF | 32.74 | 33.95 | 32.74 | 33.849 | 36110.0 |
| 2015-04-10 | BBH | ETF | 131.96 | 133.56 | 131.66 | 132.94 | 79000.0 |
| 2015-04-10 | BBP | ETF | 32.67 | 32.91 | 32.433 | 32.74 | 30400.0 |
| 2015-04-10 | BCHP | ETF | 19.8 | 19.85 | 19.8 | 19.81 | 3014.0 |
| 2015-04-10 | BCM | ETF | 31.02 | 31.07 | 30.99 | 31.0047 | 4379.0 |
| 2015-04-10 | BFOR | ETF | 8.4175 | 8.44 | 8.4125 | 8.44 | 60800.0 |
> showing 50 of 1,167 rows — these rows as CSV