PREVIEW / etf_daily / 2015-12-01
file: by_date/etf_daily/2015/2015-12-01.parquet size: 49 KB rows: 1,217
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-12-01 | SPY | ETF | 209.44 | 210.82 | 209.11 | 210.68 | 97858400.0 |
| 2015-12-01 | QQQ | ETF | 114.475 | 115.16 | 114.34 | 115.16 | 28639445.0 |
| 2015-12-01 | IWM | ETF | 119.61 | 119.91 | 118.9 | 119.89 | 27899900.0 |
| 2015-12-01 | DIA | ETF | 177.92 | 178.9 | 177.64 | 178.81 | 6058300.0 |
| 2015-12-01 | GLD | ETF | 102.3 | 102.43 | 101.81 | 102.28 | 4645900.0 |
| 2015-12-01 | TLT | ETF | 121.26 | 122.85 | 121.26 | 122.83 | 12766600.0 |
| 2015-12-01 | AADR | ETF | 39.3 | 39.65 | 39.29 | 39.34 | 2600.0 |
| 2015-12-01 | AAXJ | ETF | 55.82 | 56.08 | 55.74 | 56.04 | 761100.0 |
| 2015-12-01 | ACTX | ETF | 7.6701 | 8.2601 | 7.0801 | 8.2601 | 4220.0 |
| 2015-12-01 | ACWF | ETF | 24.0 | 24.25 | 23.9999 | 24.24 | 35346.0 |
| 2015-12-01 | ACWI | ETF | 58.06 | 58.36 | 57.97 | 58.33 | 1331400.0 |
| 2015-12-01 | ACWV | ETF | 70.18 | 70.58 | 70.18 | 70.48 | 566600.0 |
| 2015-12-01 | ACWX | ETF | 41.36 | 41.56 | 41.34 | 41.54 | 815359.0 |
| 2015-12-01 | ADRE | ETF | 30.75 | 30.85 | 30.69 | 30.83 | 11928.0 |
| 2015-12-01 | AFK | ETF | 18.79 | 18.99 | 18.78 | 18.99 | 51694.0 |
| 2015-12-01 | AFTY | ETF | 16.44 | 16.44 | 16.23 | 16.25 | 4200.0 |
| 2015-12-01 | AGG | ETF | 108.54 | 108.84 | 108.43 | 108.82 | 4260000.0 |
| 2015-12-01 | AGGY | ETF | 49.46 | 49.645 | 49.46 | 49.645 | 5400.0 |
| 2015-12-01 | AGQ | ETF | 28.7 | 28.75 | 28.33 | 28.68 | 141700.0 |
| 2015-12-01 | AGZ | ETF | 113.0 | 113.48 | 112.9 | 113.45 | 25375.0 |
| 2015-12-01 | AGZD | ETF | 24.095 | 24.095 | 24.005 | 24.005 | 2800.0 |
| 2015-12-01 | AIA | ETF | 44.75 | 45.0 | 44.73 | 44.99 | 32885.0 |
| 2015-12-01 | AIQ | ETF | 9.04 | 9.46 | 9.04 | 9.44 | 31098.0 |
| 2015-12-01 | AIRR | ETF | 18.03 | 18.1 | 17.96 | 18.1 | 10700.0 |
| 2015-12-01 | AIVI | ETF | 39.72 | 39.77 | 39.55 | 39.76 | 25800.0 |
| 2015-12-01 | AMJ | ETF | 29.9 | 30.18 | 29.3 | 29.59 | 4825508.0 |
| 2015-12-01 | AMLP | ETF | 61.25 | 61.7 | 59.8 | 60.4 | 2744300.0 |
| 2015-12-01 | AMZA | ETF | 125.0 | 125.0 | 121.1 | 123.7 | 1960.0 |
| 2015-12-01 | ANGL | ETF | 25.4 | 25.45 | 25.29 | 25.42 | 25200.0 |
| 2015-12-01 | AOA | ETF | 46.26 | 46.35 | 46.14 | 46.35 | 218000.0 |
| 2015-12-01 | AOK | ETF | 32.09 | 32.27 | 32.09 | 32.26 | 198749.0 |
| 2015-12-01 | AOM | ETF | 34.77 | 34.89 | 34.7345 | 34.86 | 585701.0 |
| 2015-12-01 | AOR | ETF | 39.7881 | 39.93 | 39.74 | 39.9 | 426558.0 |
| 2015-12-01 | ARGT | ETF | 19.02 | 19.02 | 18.61 | 18.77 | 26100.0 |
| 2015-12-01 | ARKG | ETF | 20.58 | 20.58 | 20.58 | 20.58 | 100.0 |
| 2015-12-01 | ARKK | ETF | 21.27 | 21.31 | 21.25 | 21.31 | 600.0 |
| 2015-12-01 | ARKQ | ETF | 19.756 | 19.756 | 19.756 | 19.756 | 200.0 |
| 2015-12-01 | ARKW | ETF | 24.23 | 24.23 | 23.99 | 24.16 | 6800.0 |
| 2015-12-01 | ASEA | ETF | 12.88 | 12.9 | 12.86 | 12.9 | 1200.0 |
| 2015-12-01 | ASET | ETF | 25.1 | 25.15 | 25.1 | 25.15 | 7000.0 |
| 2015-12-01 | ASHR | ETF | 36.0 | 36.15 | 35.71 | 35.83 | 1016200.0 |
| 2015-12-01 | ASHS | ETF | 44.88 | 45.37 | 44.88 | 45.19 | 76300.0 |
| 2015-12-01 | ASHX | ETF | 25.49 | 25.57 | 25.42 | 25.46 | 1166.0 |
| 2015-12-01 | ATMP | ETF | 20.0 | 20.04 | 19.37 | 19.49 | 589400.0 |
| 2015-12-01 | AWAY | ETF | 35.38 | 35.93 | 35.35 | 35.8 | 2132647.0 |
| 2015-12-01 | BAB | ETF | 29.22 | 29.43 | 29.16 | 29.42 | 69751.0 |
| 2015-12-01 | BAL | ETF | 41.82 | 42.25 | 41.8 | 42.249 | 7014.0 |
| 2015-12-01 | BBC | ETF | 31.65 | 31.65 | 30.93 | 31.5099 | 7381.0 |
| 2015-12-01 | BBH | ETF | 125.22 | 125.49 | 123.63 | 125.07 | 69100.0 |
| 2015-12-01 | BBP | ETF | 31.45 | 31.64 | 31.2 | 31.64 | 5000.0 |
> showing 50 of 1,217 rows — these rows as CSV