PREVIEW / etf_daily / 2015-12-28
file: by_date/etf_daily/2015/2015-12-28.parquet size: 50 KB rows: 1,248
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-28 | SPY | ETF | 204.86 | 205.26 | 203.94 | 205.21 | 65899900.0 |
| 2015-12-28 | QQQ | ETF | 112.32 | 112.55 | 111.51 | 112.53 | 19183637.0 |
| 2015-12-28 | IWM | ETF | 113.98 | 114.07 | 112.96 | 113.97 | 22125500.0 |
| 2015-12-28 | DIA | ETF | 174.49 | 175.13 | 174.12 | 174.98 | 2932200.0 |
| 2015-12-28 | GLD | ETF | 102.48 | 102.6 | 102.03 | 102.27 | 3356200.0 |
| 2015-12-28 | TLT | ETF | 121.99 | 122.67 | 121.85 | 122.19 | 7586600.0 |
| 2015-12-28 | AADR | ETF | 38.73 | 38.84 | 38.4 | 38.4 | 1500.0 |
| 2015-12-28 | AAXJ | ETF | 54.01 | 54.11 | 53.75 | 54.01 | 1706300.0 |
| 2015-12-28 | ACTX | ETF | 6.4901 | 7.0801 | 6.4901 | 7.0801 | 71.0 |
| 2015-12-28 | ACWF | ETF | 23.21 | 23.43 | 23.21 | 23.3953 | 3074.0 |
| 2015-12-28 | ACWI | ETF | 56.19 | 56.32 | 56.02 | 56.3 | 3559200.0 |
| 2015-12-28 | ACWV | ETF | 69.45 | 69.59 | 69.22 | 69.59 | 181100.0 |
| 2015-12-28 | ACWX | ETF | 39.92 | 40.0246 | 39.86 | 39.99 | 1960187.0 |
| 2015-12-28 | ADRE | ETF | 29.62 | 29.89 | 29.3701 | 29.64 | 9208.0 |
| 2015-12-28 | AFK | ETF | 17.9 | 18.05 | 17.72 | 17.99 | 57415.0 |
| 2015-12-28 | AFTY | ETF | 14.1 | 14.37 | 14.1 | 14.34 | 22200.0 |
| 2015-12-28 | AGG | ETF | 108.03 | 108.13 | 107.99 | 108.01 | 3736400.0 |
| 2015-12-28 | AGQ | ETF | 27.95 | 27.96 | 27.26 | 27.54 | 193800.0 |
| 2015-12-28 | AGZ | ETF | 112.91 | 113.14 | 112.65 | 112.84 | 15677.0 |
| 2015-12-28 | AGZD | ETF | 23.92 | 23.99 | 23.87 | 23.99 | 2000.0 |
| 2015-12-28 | AIA | ETF | 42.7 | 42.76 | 42.4301 | 42.76 | 37443.0 |
| 2015-12-28 | AIQ | ETF | 8.92 | 9.1 | 8.89 | 9.08 | 18279.0 |
| 2015-12-28 | AIRR | ETF | 16.9 | 16.9 | 16.68 | 16.79 | 17900.0 |
| 2015-12-28 | AIVI | ETF | 38.55 | 38.55 | 38.32 | 38.44 | 59300.0 |
| 2015-12-28 | AMJ | ETF | 28.76 | 28.76 | 27.88 | 28.32 | 6078606.0 |
| 2015-12-28 | AMLP | ETF | 58.6 | 59.2 | 57.25 | 58.6 | 3952100.0 |
| 2015-12-28 | AMZA | ETF | 110.6 | 114.1 | 105.14 | 108.1 | 4420.0 |
| 2015-12-28 | ANGL | ETF | 24.62 | 24.62 | 24.28 | 24.4 | 59200.0 |
| 2015-12-28 | AOA | ETF | 45.17 | 45.72 | 44.99 | 45.17 | 434900.0 |
| 2015-12-28 | AOK | ETF | 31.7 | 31.7599 | 31.65 | 31.71 | 89202.0 |
| 2015-12-28 | AOM | ETF | 34.32 | 34.32 | 34.12 | 34.24 | 495760.0 |
| 2015-12-28 | AOR | ETF | 39.1 | 39.1 | 38.92 | 39.06 | 945503.0 |
| 2015-12-28 | ARGT | ETF | 18.24 | 18.37 | 17.92 | 18.35 | 20600.0 |
| 2015-12-28 | ARKG | ETF | 20.78 | 20.84 | 20.763 | 20.82 | 2700.0 |
| 2015-12-28 | ARKK | ETF | 20.91 | 20.91 | 20.91 | 20.91 | 200.0 |
| 2015-12-28 | ARKQ | ETF | 19.4 | 19.4 | 19.4 | 19.4 | 100.0 |
| 2015-12-28 | ARKW | ETF | 23.0 | 23.114 | 23.0 | 23.114 | 800.0 |
| 2015-12-28 | ASEA | ETF | 12.63 | 12.72 | 12.57 | 12.63 | 9900.0 |
| 2015-12-28 | ASHR | ETF | 28.37 | 28.37 | 28.07 | 28.17 | 2512000.0 |
| 2015-12-28 | ASHS | ETF | 41.58 | 42.7 | 41.58 | 41.85 | 79000.0 |
| 2015-12-28 | ASHX | ETF | 25.5 | 25.62 | 25.5 | 25.62 | 250.0 |
| 2015-12-28 | ATMP | ETF | 18.38 | 18.65 | 18.24 | 18.63 | 560600.0 |
| 2015-12-28 | BAB | ETF | 29.0 | 29.07 | 28.9607 | 29.04 | 104663.0 |
| 2015-12-28 | BAL | ETF | 42.53 | 42.87 | 42.39 | 42.5519 | 4569.0 |
| 2015-12-28 | BBC | ETF | 29.26 | 29.26 | 28.7 | 28.7914 | 13037.0 |
| 2015-12-28 | BBH | ETF | 126.35 | 126.89 | 126.01 | 126.39 | 53600.0 |
| 2015-12-28 | BBP | ETF | 30.56 | 30.897 | 30.55 | 30.57 | 4000.0 |
| 2015-12-28 | BCM | ETF | 23.5348 | 23.57 | 23.51 | 23.52 | 25127.0 |
| 2015-12-28 | BFOR | ETF | 7.5925 | 7.5925 | 7.525 | 7.585 | 111200.0 |
| 2015-12-28 | BIB | ETF | 70.67 | 71.52 | 70.1201 | 70.87 | 241550.0 |
> showing 50 of 1,248 rows — these rows as CSV