{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Exploratory Data Analysis (EDA) of ETFs" ] }, { "cell_type": "markdown", "metadata": { "collapsed": true }, "source": [ "Original data from https://s3.amazonaws.com/zanran_storage/www.etftopics.com/ContentPages/13968652.xls , modified and available locally as ETFs.csv . \n", "\n", "This notebook only works in Quantopian Research, but one only needs to modify the loading of the file to work with it locally." ] }, { "cell_type": "code", "execution_count": 193, "metadata": { "collapsed": false }, "outputs": [], "source": [ "import numpy as np\n", "import pandas as pd\n", "import matplotlib.pyplot as pyplot\n", "import seaborn as sns" ] }, { "cell_type": "code", "execution_count": 194, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameIndexDescriptionCategoryProviderExpense_RatioDividendDiv_YieldMarket_CapShares...BetaAssetSizeStyleRegionSectorLeveragedInverseTop_HoldingsChart
Symbol
AAXJiShares MSCI All Country Asia ex Japan Index FundMSCI All Country Asia ex Japan IndexThe index measures the performance of 11 devel...Asia Pacific EquitiesiShares0.7400%$0.361.8400%$1,687.8931...1EquityNaNNaNPacific ex-JapanNaNNaNNaNNaNNaN
ACWIMSCI All Country World Index FundMSCI All Country World IndexThe Index is designed to measure the performan...Global EquitiesiShares0.3500%$0.361.4100%$1,176.6430...1EquityLarge-CapBlendGlobal/Multi-RegionNaNNaNNaNNaNNaN
\n", "

2 rows × 21 columns

\n", "
" ], "text/plain": [ " Name \\\n", "Symbol \n", "AAXJ iShares MSCI All Country Asia ex Japan Index Fund \n", "ACWI MSCI All Country World Index Fund \n", "\n", " Index \\\n", "Symbol \n", "AAXJ MSCI All Country Asia ex Japan Index \n", "ACWI MSCI All Country World Index \n", "\n", " Description \\\n", "Symbol \n", "AAXJ The index measures the performance of 11 devel... \n", "ACWI The Index is designed to measure the performan... \n", "\n", " Category Provider Expense_Ratio Dividend Div_Yield \\\n", "Symbol \n", "AAXJ Asia Pacific Equities iShares 0.7400% $0.36 1.8400% \n", "ACWI Global Equities iShares 0.3500% $0.36 1.4100% \n", "\n", " Market_Cap Shares ... Beta Asset Size Style \\\n", "Symbol ... \n", "AAXJ $1,687.89 31 ... 1 Equity NaN NaN \n", "ACWI $1,176.64 30 ... 1 Equity Large-Cap Blend \n", "\n", " Region Sector Leveraged Inverse Top_Holdings Chart \n", "Symbol \n", "AAXJ Pacific ex-Japan NaN NaN NaN NaN NaN \n", "ACWI Global/Multi-Region NaN NaN NaN NaN NaN \n", "\n", "[2 rows x 21 columns]" ] }, "execution_count": 194, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ETFs = local_csv('ETFs.csv', skipinitialspace=True, \n", " na_values=['n/a','NaN'], thousands=',')\n", "ETFs = ETFs.set_index('Symbol')\n", "ETFs[:2]" ] }, { "cell_type": "code", "execution_count": 195, "metadata": { "collapsed": false }, "outputs": [], "source": [ "del ETFs['Top_Holdings']\n", "del ETFs['Chart']" ] }, { "cell_type": "code", "execution_count": 196, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Index([u'Name', u'Index', u'Description', u'Category', u'Provider', u'Expense_Ratio', u'Dividend', u'Div_Yield', u'Market_Cap', u'Shares', u'Avg_Vol', u'Beta', u'Asset', u'Size', u'Style', u'Region', u'Sector', u'Leveraged', u'Inverse'], dtype='object')" ] }, "execution_count": 196, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ETFs.columns" ] }, { "cell_type": "code", "execution_count": 197, "metadata": { "collapsed": false }, "outputs": [], "source": [ "def p2f(x):\n", " if type(x) is str:\n", " return float(x.strip('%'))/100\n", " else:\n", " return x / 100\n", "\n", "def d2f(x):\n", " if type(x) is str:\n", " return float(x.strip('$').replace(',',''))\n", " else:\n", " return x\n", "\n", "def s2b(x):\n", " if type(x) is str:\n", " if x == 'Yes':\n", " return True\n", " else:\n", " return False\n", " else:\n", " return False " ] }, { "cell_type": "code", "execution_count": 198, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameIndexDescriptionCategoryProviderExpense_RatioDividendDiv_YieldMarket_CapSharesAvg_VolBetaAssetSizeStyleRegionSectorLeveragedInverse
Symbol
AAXJiShares MSCI All Country Asia ex Japan Index FundMSCI All Country Asia ex Japan IndexThe index measures the performance of 11 devel...Asia Pacific EquitiesiShares0.00740.360.01841687.89315278901EquityNaNNaNPacific ex-JapanNaNNaNFalse
ACWIMSCI All Country World Index FundMSCI All Country World IndexThe Index is designed to measure the performan...Global EquitiesiShares0.00350.360.01411176.64303797811EquityLarge-CapBlendGlobal/Multi-RegionNaNNaNFalse
ACWXiShares MSCI ACWI ex US Index FundMSCI All Country World ex-U.S. IndexThe index measures the performance of global e...Global EquitiesiShares0.00350.520.0147654.07171619241EquityLarge-CapBlendEx-U.S.NaNNaNFalse
\n", "
" ], "text/plain": [ " Name \\\n", "Symbol \n", "AAXJ iShares MSCI All Country Asia ex Japan Index Fund \n", "ACWI MSCI All Country World Index Fund \n", "ACWX iShares MSCI ACWI ex US Index Fund \n", "\n", " Index \\\n", "Symbol \n", "AAXJ MSCI All Country Asia ex Japan Index \n", "ACWI MSCI All Country World Index \n", "ACWX MSCI All Country World ex-U.S. Index \n", "\n", " Description \\\n", "Symbol \n", "AAXJ The index measures the performance of 11 devel... \n", "ACWI The Index is designed to measure the performan... \n", "ACWX The index measures the performance of global e... \n", "\n", " Category Provider Expense_Ratio Dividend Div_Yield \\\n", "Symbol \n", "AAXJ Asia Pacific Equities iShares 0.0074 0.36 0.0184 \n", "ACWI Global Equities iShares 0.0035 0.36 0.0141 \n", "ACWX Global Equities iShares 0.0035 0.52 0.0147 \n", "\n", " Market_Cap Shares Avg_Vol Beta Asset Size Style \\\n", "Symbol \n", "AAXJ 1687.89 31 527890 1 Equity NaN NaN \n", "ACWI 1176.64 30 379781 1 Equity Large-Cap Blend \n", "ACWX 654.07 17 161924 1 Equity Large-Cap Blend \n", "\n", " Region Sector Leveraged Inverse \n", "Symbol \n", "AAXJ Pacific ex-Japan NaN NaN False \n", "ACWI Global/Multi-Region NaN NaN False \n", "ACWX Ex-U.S. NaN NaN False " ] }, "execution_count": 198, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Apply conversions\n", "ETFs.Expense_Ratio = ETFs.Expense_Ratio.apply(p2f) \n", "ETFs.Dividend = ETFs.Dividend.apply(d2f)\n", "ETFs.Div_Yield = ETFs.Div_Yield.apply(p2f)\n", "ETFs.Market_Cap = ETFs.Market_Cap.apply(d2f)\n", "ETFs.Inverse = ETFs.Inverse.apply(s2b)\n", "ETFs[:3]" ] }, { "cell_type": "code", "execution_count": 199, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "1020" ] }, "execution_count": 199, "metadata": {}, "output_type": "execute_result" } ], "source": [ "len(ETFs.index)" ] }, { "cell_type": "code", "execution_count": 223, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Leveraged Equities 120\n", "Emerging Markets Equities 46\n", "Energy Equities 40\n", "Large Cap Value Equities 36\n", "Technology Equities 32\n", "Large Cap Blend Equities 30\n", "Currency 29\n", "Financials Equities 28\n", "Europe Equities 25\n", "Foreign Large Cap Equities 25\n", "Health & Biotech Equities 22\n", "National Munis 21\n", "Commodities 19\n", "All Cap Equities 19\n", "Commodity Producers Equities 18\n", "Precious Metals 18\n", "Government Bonds 18\n", "Leveraged Commodities 18\n", "Large Cap Growth Equities 18\n", "Asia Pacific Equities 17\n", "China Equities 16\n", "Quantitative Methodology Indexes 16\n", "Global Equities 16\n", "Oil & Gas 15\n", "Inverse Equities 15\n", "Small Cap Blend Equities 15\n", "Consumer Discretionary Equities 14\n", "Miscellaneous Sector Equities 14\n", "Utilities Equities 14\n", "Real Estate 12\n", " ... \n", "Consumer Staples Equities 11\n", "Corporate Bonds 11\n", "Latin America Equities 10\n", "Materials 10\n", "Foreign Small & Mid Cap Equities 10\n", "Diversified Portfolio 10\n", "Small Cap Value Equities 10\n", "Global Real Estate 9\n", "Mid Cap Value Equities 9\n", "Metals 9\n", "Communications Equities 8\n", "Inverse Commodities 8\n", "Mid Cap Growth Equities 8\n", "Japan Equities 8\n", "Leveraged Real Estate 7\n", "Small Cap Growth Equities 7\n", "Money Market 7\n", "Leveraged Currency 6\n", "Inflation-Protected Bonds 6\n", "Hedge Fund 6\n", "Long-Short 6\n", "Preferred Stock/Convertible Bonds 5\n", "International Government Bonds 4\n", "Transportation Equities 4\n", "Mortgage Backed Securities 3\n", "High Yield Bonds 3\n", "California Munis 3\n", "New York Munis 3\n", "Volatility 2\n", "Emerging Markets Bonds 2\n", "dtype: int64" ] }, "execution_count": 223, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ETFs.Category.value_counts()" ] }, { "cell_type": "code", "execution_count": 222, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "iShares 201\n", "Invesco PowerShares 146\n", "ProShares 111\n", "State Street 89\n", "Wisdom Tree 52\n", "Vanguard 46\n", "First Trust 44\n", "Rydex 40\n", "Barclays iPath 38\n", "Claymore 36\n", "Direxion 34\n", "Van Eck 29\n", "Merrill Lynch HOLDRs 17\n", "ELEMENTS 16\n", "UBS 13\n", "PIMCO 10\n", "Global X 10\n", "IndexIQ 9\n", "Charles Schwab 8\n", "Grail Advisors 7\n", "US Commodity Funds 7\n", "EG Shares 6\n", "XShares 6\n", "RevenueShares 6\n", "GlobalShares 5\n", "FaithShares 5\n", "ETF Securities 4\n", "MacroMarkets 4\n", "Jefferies 4\n", "Credit Suisse 2\n", "JP Morgan 2\n", "Javelin Funds 2\n", "Geary Advisors 2\n", "ALPS 2\n", "Goldman Sachs 2\n", "GreenHaven 1\n", "Fidelity 1\n", "AdvisorShares 1\n", "Sprott Asset Management 1\n", "U.S. One 1\n", "dtype: int64" ] }, "execution_count": 222, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ETFs.Provider.value_counts()" ] }, { "cell_type": "code", "execution_count": 202, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 202, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": [ "iVBORw0KGgoAAAANSUhEUgAAA1AAAAHiCAYAAADmhi1mAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n", "AAALEgAACxIB0t1+/AAAG7tJREFUeJzt3X+Q3Hd93/GXYqFg4aswUBmQXQTU94mNoRBlHNpMC81A\n", "x4UW6GQGAg2YH02YQqCTaVNsmBD6i18pDA0ZSCk/akhtcFNwXCcMGNpQaPhRbgjgsfuhBt3FdpDE\n", "GBDCxsg/1D9uDWcjn96S9rvfle7x+Ee7393v7Xvvc+vbp7+7e5sOHToUAAAAjuynxh4AAADgRCGg\n", "AAAAigQUAABAkYACAAAoElAAAABFAgoAAKBo81BfuLV2VpL3J9me5FCSd/Xef7e19qAkH0ryiCTL\n", "SZ7de//uZJ+Lk7w4yZ1JXtl7//hQ8wEAABytIY9A3Z7kN3rvj0nyxCQvb62dk+SiJFf33heTfHJy\n", "Pq21c5M8J8m5SS5I8o7WmiNkAADA3BgsUHrve3rvfz45/f0k1yXZkeQZSS6ZXO2SJM+anH5mkst6\n", "77f33peTXJ/k/KHmAwAAOFozOcLTWtuZ5AlJPp/kjN773slFe5OcMTn98CQ3rtntxqwGFwAAwFwY\n", "7D1Qd2utnZbkvyX5Z733A621H13Wez/UWju0zu7rXZalpaV1LwcAANi1a9emaX2tQQOqtXa/rMbT\n", "B3rvV0w2722tPbT3vqe19rAk+ybbb0py1prdz5xsW9euXbumOTIzsrS0ZO1OYNbvxGb9TlzW7sRm\n", "/U5c1u7EtrS0NNWvN9hL+Fprm5K8J8m1vfe3rbnoyiQXTk5fmOSKNdt/ubW2pbX2yCRnJ/nCUPMB\n", "AAAcrSGPQP1Ckl9J8pXW2pcm2y5O8sYkl7fWXpLJx5gnSe/92tba5UmuTXJHkpf13r1EDwAAmBuD\n", "BVTv/TO57yNcT7mPfV6f5PVDzQQwawcPHszy8vLYY9zDyspKFhYWZn67O3fuzJYtW2Z+uwAwTYN/\n", "iATARra8vJznX3xptm7bPvYo93TVnpne3K379+UDb3heFhcXZ3q7ADBtAgpgYFu3bc9pp/urDABw\n", "MpjJ34ECAAA4GQgoAACAIgEFAABQJKAAAACKBBQAAECRgAIAACgSUAAAAEUCCgAAoEhAAQAAFAko\n", "AACAIgEFAABQJKAAAACKBBQAAECRgAIAACgSUAAAAEUCCgAAoEhAAQAAFAkoAACAIgEFAABQJKAA\n", "AACKBBQAAECRgAIAACgSUAAAAEUCCgAAoEhAAQAAFAkoAACAIgEFAABQJKAAAACKBBQAAECRgAIA\n", "ACgSUAAAAEUCCgAAoEhAAQAAFAkoAACAIgEFAABQJKAAAACKBBQAAECRgAIAACgSUAAAAEUCCgAA\n", "oEhAAQAAFAkoAACAIgEFAABQJKAAAACKBBQAAECRgAIAACgSUAAAAEUCCgAAoEhAAQAAFAkoAACA\n", "IgEFAABQJKAAAACKBBQAAECRgAIAACgSUAAAAEUCCgAAoEhAAQAAFAkoAACAIgEFAABQJKAAAACK\n", "BBQAAECRgAIAACgSUAAAAEUCCgAAoEhAAQAAFAkoAACAIgEFAABQJKAAAACKBBQAAECRgAIAACgS\n", "UAAAAEUCCgAAoEhAAQAAFAkoAACAIgEFAABQJKAAAACKBBQAAECRgAIAACgSUAAAAEUCCgAAoEhA\n", "AQAAFAkoAACAIgEFAABQJKAAAACKBBQAAECRgAIAACgSUAAAAEUCCgAAoEhAAQAAFAkoAACAIgEF\n", "AABQtHnsAQA4+d115x3ZvXv32GPMjZ07d2bLli1jjzGqgwcPZnl5eewxZmplZSULCwuHvczPBJw4\n", "BBQAg7vt+zfnte/6bLZu+/rYo4zu1v378oE3PC+Li4tjjzKq5eXlPP/iS7N12/axR5mtq/b8xCY/\n", "E3BiEVAAzMTWbdtz2uk7xh6DOeJnAjgReQ8UAABAkYACAAAoElAAAABFAgoAAKBIQAEAABQJKAAA\n", "gCIBBQAAUDTo34Fqrb03ydOT7Ou9P3ay7XVJ/kmSb02u9ure+0cnl12c5MVJ7kzyyt77x4ecDwAA\n", "4GgM/Yd035fk7Unev2bboSRv7b2/de0VW2vnJnlOknOT7EjyidbaYu/9roFnBAAAKBn0JXy9908n\n", "+c5hLtp0mG3PTHJZ7/323vtykuuTnD/geAAAAEdlrPdAvaK19uXW2ntaaw+cbHt4khvXXOfGrB6J\n", "AgAAmAtDv4TvcN6Z5F9PTv+bJG9J8pL7uO6hI32xpaWlKY3FrFm7E5v1q1lZWRl7BObQNddckwMH\n", "DhzTvifLY89j456O52eC2ThZHnscv5kHVO99392nW2vvTvLfJ2dvSnLWmqueOdm2rl27dk11PmZj\n", "aWnJ2p3ArF/dwsJCctWescdgzpx33nlZXFw86v1Opseex8Y9HevPBLNxMj32NqJpx+/MX8LXWnvY\n", "mrP/KMlXJ6evTPLLrbUtrbVHJjk7yRdmPR8AAMB9GfpjzC9L8qQkD2mt3ZDkt5M8ubX2+Ky+PG93\n", "kpcmSe/92tba5UmuTXJHkpf13o/4Ej4AAIBZGTSgeu/PPczm965z/dcnef1wEwEAABy7sT6FDwAA\n", "4IQjoAAAAIoEFAAAQJGAAgAAKBJQAAAARTP/Q7rAxnDw4MEsLy+PPcbodu/ePfYIAMAUCShgEMvL\n", "y3n+xZdm67btY48yqptvvC4PPvOcsccAAKZEQAGD2bpte047fcfYY4zq1v17xx4BAJgi74ECAAAo\n", "ElAAAABFAgoAAKBIQAEAABQJKAAAgCIBBQAAUCSgAAAAigQUAABAkYACAAAoElAAAABFAgoAAKBI\n", "QAEAABQJKAAAgCIBBQAAUCSgAAAAigQUAABAkYACAAAoElAAAABFAgoAAKBIQAEAABQJKAAAgCIB\n", "BQAAUCSgAAAAigQUAABAkYACAAAoElAAAABFAgoAAKBIQAEAABQJKAAAgCIBBQAAUCSgAAAAigQU\n", "AABAkYACAAAoElAAAABFAgoAAKBIQAEAABQJKAAAgCIBBQAAUCSgAAAAigQUAABAkYACAAAoElAA\n", "AABFm8cegJPDwYMHs7y8XL7+yspKFhYWhhtoRDt37syWLVvGHgMAgAEIKKZieXk5z7/40mzdtr2+\n", "01V7hhtoJLfu35cPvOF5WVxcHHsUAAAGIKCYmq3btue003eMPQYAAAzGe6AAAACKBBQAAECRgAIA\n", "ACgSUAAAAEUCCgAAoEhAAQAAFAkoAACAIgEFAABQJKAAAACKBBQAAECRgAIAACgSUAAAAEUCCgAA\n", "oEhAAQAAFAkoAACAIgEFAABQJKAAAACKBBQAAECRgAIAACjaPPYAcDK56847snv37rHHGNzKykoW\n", "FhbWvc5G+D4AABuPgIIpuu37N+e17/pstm77+tijDO+qPetefPON1+XBZ54zo2EAAGZDQMGUbd22\n", "PaedvmPsMUZ36/69Y48AADB13gMFAABQJKAAAACKBBQAAECRgAIAACgSUAAAAEUCCgAAoEhAAQAA\n", "FAkoAACAIgEFAABQJKAAAACKBBQAAECRgAIAACgSUAAAAEUCCgAAoEhAAQAAFG0+0hVaa2ckeUuS\n", "R/Te/3Zr7XFJ/lbv/fcHnw4AAGCOVI5A/ack/zvJAyfne5KXDzYRAADAnKoE1I7e+zuT3JEkvfcf\n", "Jrlr0KkAAADmUCWg7mitbbr7TGvtgetdGQAA4GRVCagPJ/n9JH+ltfbCJFcned+QQwEAAMyjIwZU\n", "7/1NST6dZCnJ05L8h97724YeDAAAYN4c8VP4kqT3/gdJ/mDgWQAAAObaEY9AtdYWW2ufaa0tT87/\n", "bGvtdQPPBQAAMHcq74F6Z5J/l+S7k/NfTvLswSYCAACYU5WA2tZ7/2iSQ0nSe78zycFBpwIAAJhD\n", "1Y8x33L3mdbajiR3DjcSAADAfKq+hO/DSR7SWvtXST6T5C2DTgUAADCHjvgpfL33S1pr30jyD5Oc\n", "muQFvfdPV754a+29SZ6eZF/v/bGTbQ9K8qEkj0iynOTZvffvTi67OMmLs3qE65W9948f9T0CAAAY\n", "yLoB1VrbnOQLvfefzerfgjpa70vy9iTvX7PtoiRX997f3Fp71eT8Ra21c5M8J8m5SXYk+URrbbH3\n", "ftcx3C4AAMDUrfsSvt77HUm+31o79Vi++ORI1XfutfkZSS6ZnL4kybMmp5+Z5LLe++299+Uk1yc5\n", "/1huFwAAYAiVP6T7tSSfaq39YZJbJtsO9d7fcYy3eUbvfe/k9N4kZ0xOPzzJ59Zc78asHokCAACY\n", "C5WA2pzk2iTnTPvGe++HWmuH1rnKepcBAADMVOVDJF445dvc21p7aO99T2vtYUn2TbbflOSsNdc7\n", "c7JtXUtLS1Mej2OxsrIy9ggAJ4xrrrkmBw4cOKZ9T5bfe35v3NPx/EwwGyfLY4/jd8SAaq29PD95\n", "JGh/Vj9c4v8dw21emeTCJG+a/HvFmu2XttbemtWX7p2d5AtH+mK7du06hhGYtoWFheSqPWOPAXBC\n", "OO+887K4uHjU+y0tLZ00v/f83rinY/2ZYDZOpsfeRjTt+K38HagLkrwhyVOSPDXJ67MaPv+jtfaS\n", "9XZsrV2W5M9WT7YbWmsvSvLGJE9trX0tyS9Ozqf3fm2Sy7P6csGPJnlZ791L+AAAgLlReQ/UXUke\n", "23v/iyRprZ2V5B1Z/YS8TyR5z33t2Ht/7n1c9JT7uP7rsxpoAAAAc6dyBOrRd8dTkvTeb0jyyN77\n", "N5PcPthkAAAAc6ZyBGpva+3VWf2juJuy+vK9fa21U+JT8gAAgA2kcgTqBUl2JbkmyVeT/Nxk2/0m\n", "/wIAAGwIlY8xvynJL93HxV+d7jgAAADzq/Ix5g9IcnGSR/Xen9da+5kkP9N7v+IIuwIAAJxUKi/h\n", "e2dWX673+Mn5m5K8bqiBAAAA5lUloB7Xe39Vkh8mSe/9QFY/TAIAAGBDqQTUD9eeaa3dv7gfAADA\n", "SaUSQv+rtfaaJPdvrT05yX9N8keDTgUAADCHKgH16sm/30vy5iSfj/dAAQAAG9C6n8LXWjs/yb9I\n", "8pjJpmuSfKz3fsfQgwEAAMyb+zwC1Vr7m0k+luTrSV6T5LeSfCPJx1trT5zNeAAAAPNjvSNQr0ry\n", "4t77R9Zs+3Br7XNJLkryrEEnAwAAmDPrvQfqMfeKpyRJ7/2P8uOX9AEAAGwY6wXULcd4GQAAwElp\n", "vZfw/XRr7dzDbN+U5KcHmgcAAGBurRdQpyb541kNAgAAMO/uM6B67ztnOAcAAMDcq/whXQAAACKg\n", "AAAAygQUAABAkYACAAAoElAAAABFAgoAAKBIQAEAABQJKAAAgCIBBQAAUCSgAAAAigQUAABAkYAC\n", "AAAoElAAAABFAgoAAKBIQAEAABQJKAAAgCIBBQAAUCSgAAAAigQUAABAkYACAAAoElAAAABFAgoA\n", "AKBIQAEAABQJKAAAgCIBBQAAUCSgAAAAigQUAABAkYACAAAoElAAAABFAgoAAKBIQAEAABQJKAAA\n", "gCIBBQAAUCSgAAAAigQUAABAkYACAAAoElAAAABFAgoAAKBIQAEAABQJKAAAgCIBBQAAUCSgAAAA\n", "igQUAABAkYACAAAoElAAAABFAgoAAKBIQAEAABQJKAAAgCIBBQAAUCSgAAAAigQUAABAkYACAAAo\n", "ElAAAABFAgoAAKBIQAEAABQJKAAAgCIBBQAAUCSgAAAAigQUAABAkYACAAAoElAAAABFAgoAAKBI\n", "QAEAABQJKAAAgCIBBQAAUCSgAAAAijaPPcCJ7mNX/89873vfH3uM0e3f/+2xRwAAgMEJqOP0n6/4\n", "QvZvftTYY4xu07e+ktz/0WOPAQAAgxJQx+mUUzbnlM1bxh5jdId+yo8SAAAnP++BAgAAKBJQAAAA\n", "RQIKAACgSEABAAAUCSgAAIAiAQUAAFAkoAAAAIoEFAAAQJGAAgAAKBJQAAAARQIKAACgSEABAAAU\n", "CSgAAIAiAQUAAFAkoAAAAIoEFAAAQNHmsW64tbac5HtJ7kxye+/9/Nbag5J8KMkjkiwneXbv/btj\n", "zQgAALDWmEegDiV5cu/9Cb338yfbLkpyde99McknJ+cBAADmwtgv4dt0r/PPSHLJ5PQlSZ4123EA\n", "AADu29hHoD7RWvtia+1XJ9vO6L3vnZzem+SMcUYDAAD4SaO9ByrJL/Tev9la+6tJrm6t/d+1F/be\n", "D7XWDh3piywtLQ02YMUtt96SbBt1hLlw220/SLaMPQXAieGaa67JgQMHjmnfsX/vTcvKysrYI8yV\n", "4/mZYDZOlscex2+0gOq9f3Py77daax9Jcn6Sva21h/be97TWHpZk35G+zq5duwaedH0P2Pqn2T/q\n", "BPPh/vc/NbeMPQTACeK8887L4uLiUe+3tLQ0+u+9aVlYWEiu2jP2GHPjWH8mmI2T6bG3EU07fkd5\n", "CV9rbWtrbWFy+gFJ/l6Srya5MsmFk6tdmOSKMeYDAAA4nLGOQJ2R5COttbtn+C+994+31r6Y5PLW\n", "2ksy+RjzkeYDAAD4CaMEVO99d5LHH2b7t5M8ZfYTAQAAHNnYH2MOAABwwhBQAAAARQIKAACgSEAB\n", "AAAUCSgAAIAiAQUAAFAkoAAAAIoEFAAAQJGAAgAAKBJQAAAARZvHHgAANpK77rwju3fvPqZ9V1ZW\n", "srCwMOWJxnGs3wOAsQkoAJih275/c177rs9m67avH9sXuGrPdAcayc03XpcHn3nO2GMAHDUBBQAz\n", "tnXb9px2+o6xxxjVrfv3jj0CwDHxHigAAIAiAQUAAFAkoAAAAIoEFAAAQJGAAgAAKBJQAAAARQIK\n", "AACgSEABAAAUCSgAAIAiAQUAAFAkoAAAAIoEFAAAQJGAAgAAKBJQAAAARQIKAACgSEABAAAUCSgA\n", "AIAiAQUAAFAkoAAAAIoEFAAAQJGAAgAAKBJQAAAARQIKAACgSEABAAAUCSgAAIAiAQUAAFAkoAAA\n", "AIoEFAAAQJGAAgAAKBJQAAAARQIKAACgSEABAAAUCSgAAIAiAQUAAFAkoAAAAIoEFAAAQJGAAgAA\n", "KBJQAAAARQIKAACgSEABAAAUCSgAAIAiAQUAAFAkoAAAAIoEFAAAQJGAAgAAKBJQAAAARQIKAACg\n", "SEABAAAUCSgAAIAiAQUAAFAkoAAAAIoEFAAAQJGAAgAAKBJQAAAARQIKAACgSEABAAAUCSgAAIAi\n", "AQUAAFAkoAAAAIoEFAAAQJGAAgAAKBJQAAAARQIKAACgSEABAAAUCSgAAIAiAQUAAFAkoAAAAIoE\n", "FAAAQJGAAgAAKBJQAAAARQIKAACgSEABAAAUCSgAAIAiAQUAAFAkoAAAAIoEFAAAQJGAAgAAKBJQ\n", "AAAARQIKAACgSEABAAAUCSgAAIAiAQUAAFAkoAAAAIoEFAAAQNHmsQcAAICDBw9meXl57DEOa2Vl\n", "JQsLCzO7vZ07d2bLli0zuz2OjoACAGB0y8vLef7Fl2brtu1jj3J4V+2Zyc3cun9fPvCG52VxcXEm\n", "t8fRE1AAAMyFrdu257TTd4w9BqzLe6AAAACKBBQAAECRgAIAACiau/dAtdYuSPK2JKckeXfv/U0j\n", "jwQAAJBkzo5AtdZOSfJ7SS5Icm6S57bWzhl3KgAAgFVzFVBJzk9yfe99ufd+e5IPJnnmyDMBAAAk\n", "mb+X8O1IcsOa8zcm+fmRZik5eGBPNp3yw7HHGN3tt3wrt/7g1LHHGN0PDnw7yaaxx5gLvherfB9W\n", "+T78mO/FKt+HH7t1/77s3r177DFGt3v37ty6f9/YY4zO92D+bTp06NDYM/xIa+2XklzQe//Vyflf\n", "SfLzvfdXHO76S0tL8zM8AAAwl3bt2jW1/2Mzb0egbkpy1przZ2X1KNRhTfMbAQAAcCTzFlBfTHJ2\n", "a21nkr9M8pwkzx11IgAAgIm5+hCJ3vsdSX49yceSXJvkQ73368adCgAAYNVcvQcKAABgns3VESgA\n", "AIB5JqAAAACKBBQAAEDR3HwKX2vtgiRvS3JKknf33t90mOv8bpK/n+TWJC/svX9pvX1baw9K8qEk\n", "j0iynOTZvffvDn9vNp6B1u93kvyDJAeTfD3Ji3rv+2dwdzaUIdZuzX7/PMnvJHlI7/3bg96RDWqo\n", "9WutvSLJy5LcmeSPe++vGvq+bEQD/bfz/CS/l+R+Se5I8rLe+/+Zwd3ZUI5z7d6b5OlJ9vXeH7vm\n", "+p63zMhA6+d5ywwMsXZr9is9b5mLI1CttVOy+h/7C5Kcm+S5rbVz7nWdpyX56733s5P8WpJ3Fva9\n", "KMnVvffFJJ+cnGfKBly/jyd5TO/9byT5WpKLZ3B3NpQB1y6ttbOSPDXJygzuyoY01Pq11v5ukmck\n", "eVzv/bwk/34292hjGfDx9+Ykv9V7f0KS107OM0XHs3YT75vse2+et8zAgOvnecvABly7o3reMhcB\n", "leT8JNf33pd777cn+WCSZ97rOs9IckmS9N4/n+SBrbWHHmHfH+0z+fdZw96NDWuQ9eu9X917v2uy\n", "/+eTnDn8XdlwhnrsJclbk/zLoe/ABjfU+v3TJG+YbE/v/VvD35UNaaj1+2aSbZPTD8zqH6lnuo5n\n", "7dJ7/3SS7xzm63reMhuDrJ/nLTMx1GMvOYrnLfMSUDuS3LDm/I2TbZXrPHydfc/ove+dnN6b5Ixp\n", "Dcw9DLV+a704yZ8c96Tc2yBr11p7ZpIbe+9fmfbA3MNQj72zk/yd1trnWmt/2lr7ualOzd2GWr+L\n", "kryltfYXWX0piv8LPn3Hs3br8bxlNoZav7U8bxnGIGt3tM9b5iWgqn+MalPxOj/x9Xrvh47idjg6\n", "01y/n9Bae02Sg733S49lf9Y19bVrrZ2a5NVJfvtY9ueoDPXY25zk9N77E5P8ZpLLj3J/aoZav/ck\n", "eWXv/a8l+Y0k7z3K/TmyY1278vMQz1sGNej6ed4yqKmvXWtta47yecu8BNRNSc5ac/6srNbietc5\n", "c3Kdw22/++UKe+8+ZNdae1iSfVOcmR+b5vrdY9/W2guTPC3JP57euKwxxNo9OsnOJF9ure2eXH+p\n", "tbZ9qpOTDPfYuzHJh5Nk8uEDd7XWHjy9sZkYav3O771/ZHL6D7P6khem61jX7kgvp/S8ZTaGWj/P\n", "W4Y3xNod9fOWefkUvi8mObu1tjPJXyZ5TpLn3us6Vyb59SQfbK09Mcl3e+97W2s3r7PvlUkuTPKm\n", "yb9XDHw/NqpB1m/yKSu/meRJvffbZnFHNqCpr13v/bqsednJ5D9Gu3wK3yCG+m/nFUl+McmnWmuL\n", "Sbb03m8e+s5sQEOt3/WttSf13j+V1XX82uD3ZOM55rU7wtf1vGU2Blk/z1tmYupr13v/ao7yectc\n", "HIHqvd+R1Tv6sSTXJvlQ7/261tpLW2svnVznT5J8o7V2fZL/mNWP173PfSdf+o1Jntpa+1pWf4m8\n", "cYZ3a8MYcP3enuS0JFe31r7UWnvHLO/XRjDg2q3lJSgDGXD93pvkUa21rya5LMkLZni3NowB1+/X\n", "kry5tfbnSf7t5DxTdDxrlySttcuS/FmSxdbaDa21F00u8rxlBgZcP89bBjbg2q11xOctmw4d8twG\n", "AACgYi6OQAEAAJwIBBQAAECRgAIAACgSUAAAAEUCCgAAoEhAAQAAFAkoAACAov8PTBT1Ld3pXj4A\n", "AAAASUVORK5CYII=\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "ETFs.Expense_Ratio.plot(kind='hist')" ] }, { "cell_type": "code", "execution_count": 203, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 203, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": [ "iVBORw0KGgoAAAANSUhEUgAAA0UAAAHiCAYAAAAnAWfKAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n", "AAALEgAACxIB0t1+/AAAHyRJREFUeJzt3X+sZ3dd5/FXbR2g/CiDLNOfaavpvGUQFrhaUXQV0pr6\n", "g7aJSVsIUinhH1DQjYQWo3Gz2fJjdcWNWw2LkgHW2opQii6hpRgWV6VyAwoOvGuxo0ylU5ZOC4hA\n", "f8z+cU/hUmemF+j5fu/M5/FImjnnfM+5827u6U2ePT/uUfv37w8AAMCovm3ZAwAAACyTKAIAAIYm\n", "igAAgKGJIgAAYGiiCAAAGJooAgAAhnbMnF+8qi5L8vwk9yX5aJIXJnlkkquSnJpkd5ILuvvOdftf\n", "kuTeJC/r7uvmnA8AAGC2K0VVdVqSFyd5enc/OcnRSS5KcmmS67t7e5IbpvVU1Y4kFybZkeScJFdU\n", "lStZAADArOaMjs8luTvJsVV1TJJjk/xzknOT7Jz22Znk/Gn5vCRXdvfd3b07yc1JzpxxPgAAgPmi\n", "qLvvSPIbSf4pazF0Z3dfn2Rbd++ddtubZNu0fGKSPeu+xJ4kJ801HwAAQDLjM0VV9V1JfiHJaUnu\n", "SvJHVfX89ft09/6q2n+IL3Ooz7K6unrIzwEAAFZWVo461Odzvmjhe5P8RXd/Nkmq6u1JfiDJbVV1\n", "fHffVlUnJLl92v/WJKesO/7kadshraysPLRTw0Gsrq4631go5xyL5HxjkZxvLNLq6uqD7jPnM0Wf\n", "SPKMqnpEVR2V5Kwku5K8K8nF0z4XJ7lmWr42yUVVtaWqTk9yRpIbZ5wPAABg1meK/ibJm5N8KMnf\n", "TpvfkOQ1Sc6uqpuSPHtaT3fvSnJ11sLp3Ule0t1ujwMAAGY16+8p6u7XJXndAzbfkbWrRgfa//Ik\n", "l885EwAAwHp+DxAAADA0UQQAAAxNFAEAAEMTRQAAwNBEEQAAMDRRBAAADE0UAQAAQxNFAADA0EQR\n", "AAAwNFEEAAAMTRQBAABDE0UAAMDQRBEAADA0UQQAAAxNFAEAAEMTRQAAwNBEEQAAMDRRBAAADE0U\n", "AQAAQxNFAADA0EQRAAAwNFEEAAAMTRQBAABDE0UAAMDQRBEAADA0UQQAAAxNFAEAAEMTRQAAwNBE\n", "EQAAMDRRBAAADE0UAQAAQxNFAADA0EQRAAAwtGOWPcC36oX/8TeXPUKS5OTvOCb/+Zd/ftljAAAA\n", "36DDPor+31HfuewRkiTHfXnPskcAAAC+CW6fAwAAhiaKAACAoYkiAABgaKIIAAAYmigCAACGJooA\n", "AIChiSIAAGBooggAABiaKAIAAIYmigAAgKGJIgAAYGiiCAAAGNoxc37xqqokf7hu03cm+ZUkb01y\n", "VZJTk+xOckF33zkdc1mSS5Lcm+Rl3X3dnDMCAABjm/VKUa95Wnc/LclKki8meUeSS5Nc393bk9ww\n", "raeqdiS5MMmOJOckuaKqXM0CAABms8jgOCvJzd39qSTnJtk5bd+Z5Pxp+bwkV3b33d29O8nNSc5c\n", "4IwAAMBgFhlFFyW5clre1t17p+W9SbZNyycm2bPumD1JTlrMeAAAwIhmfaboflW1JclzkrzygZ91\n", "9/6q2n+Iww/12aaxb9++rK6uLnsMZuZ7zKI551gk5xuL5HxjM1lIFCX58SSr3f2ZaX1vVR3f3bdV\n", "1QlJbp+235rklHXHnTxt2/S2bt2alZWVZY/BjFZXV32PWSjnHIvkfGORnG8s0kYCfFG3zz03X7t1\n", "LkmuTXLxtHxxkmvWbb+oqrZU1elJzkhy44JmBAAABjR7FFXVI7P2koW3r9v8miRnV9VNSZ49rae7\n", "dyW5OsmuJO9O8pLuPixunwMAAA5Ps98+193/kuTxD9h2R9ZC6UD7X57k8rnnAgAASBb79jkAAIBN\n", "RxQBAABDE0UAAMDQRBEAADA0UQQAAAxNFAEAAEMTRQAAwNBEEQAAMDRRBAAADE0UAQAAQxNFAADA\n", "0EQRAAAwNFEEAAAMTRQBAABDE0UAAMDQRBEAADA0UQQAAAxNFAEAAEMTRQAAwNBEEQAAMDRRBAAA\n", "DE0UAQAAQxNFAADA0EQRAAAwNFEEAAAMTRQBAABDE0UAAMDQRBEAADA0UQQAAAxNFAEAAEMTRQAA\n", "wNBEEQAAMDRRBAAADE0UAQAAQxNFAADA0EQRAAAwNFEEAAAMTRQBAABDE0UAAMDQRBEAADA0UQQA\n", "AAxNFAEAAEMTRQAAwNBEEQAAMDRRBAAADE0UAQAAQxNFAADA0I6Z+y+oqscmeWOSJyXZn+SFSf4+\n", "yVVJTk2yO8kF3X3ntP9lSS5Jcm+Sl3X3dXPPCAAAjGsRV4p+K8n/7u4nJnlKkk8kuTTJ9d29PckN\n", "03qqakeSC5PsSHJOkiuqytUsAABgNrMGR1Udl+SHu/v3k6S77+nuu5Kcm2TntNvOJOdPy+clubK7\n", "7+7u3UluTnLmnDMCAABjm/v2udOTfKaq3pTk3ydZTfILSbZ1995pn71Jtk3LJyb5q3XH70ly0swz\n", "AgAAA5s7io5J8vQkP9fdf11Vr890q9z9unt/Ve0/xNc41Gebxr59+7K6urrsMZiZ7zGL5pxjkZxv\n", "LJLzjc1k7ijak2RPd//1tP62JJclua2qju/u26rqhCS3T5/fmuSUdcefPG3b9LZu3ZqVlZVlj8GM\n", "VldXfY9ZKOcci+R8Y5GcbyzSRgJ81meKuvu2JJ+qqu3TprOS/F2SdyW5eNp2cZJrpuVrk1xUVVuq\n", "6vQkZyS5cc4ZAQCAsc3+Su4kP5/kf1XVliSfzNoruY9OcnVVvSjTK7mTpLt3VdXVSXYluSfJS7r7\n", "sLh9DgAAODzNHkXd/TdJvu8AH511kP0vT3L5rEMBAABM/A4gAABgaKIIAAAYmigCAACGJooAAICh\n", "iSIAAGBooggAABiaKAIAAIYmigAAgKGJIgAAYGiiCAAAGJooAgAAhiaKAACAoYkiAABgaKIIAAAY\n", "migCAACGJooAAIChiSIAAGBooggAABiaKAIAAIYmigAAgKGJIgAAYGiiCAAAGJooAgAAhiaKAACA\n", "oYkiAABgaKIIAAAYmigCAACGJooAAIChiSIAAGBooggAABiaKAIAAIYmigAAgKGJIgAAYGiiCAAA\n", "GJooAgAAhiaKAACAoYkiAABgaKIIAAAYmigCAACGJooAAIChiSIAAGBooggAABiaKAIAAIYmigAA\n", "gKGJIgAAYGiiCAAAGJooAgAAhnbM3H9BVe1O8rkk9ya5u7vPrKrHJbkqyalJdie5oLvvnPa/LMkl\n", "0/4v6+7r5p4RAAAY1yKuFO1P8qPd/bTuPnPadmmS67t7e5IbpvVU1Y4kFybZkeScJFdUlatZAADA\n", "bBYVHEc9YP3cJDun5Z1Jzp+Wz0tyZXff3d27k9yc5MwAAADMZFFXit5bVR+qqhdP27Z1995peW+S\n", "bdPyiUn2rDt2T5KTFjAjAAAwqNmfKUryzO7+dFX9uyTXV9Un1n/Y3furav8hjj/UZ5vGvn37srq6\n", "uuwxmJnvMYvmnGORnG8skvONzWT2KOruT09/fqaq3pG12+H2VtXx3X1bVZ2Q5PZp91uTnLLu8JOn\n", "bZve1q1bs7KysuwxmNHq6qrvMQvlnGORnG8skvONRdpIgM96+1xVHVtVj56WH5nkx5J8NMm1SS6e\n", "drs4yTXT8rVJLqqqLVV1epIzktw454wAAMDY5n6maFuSD1TVR5J8MMmfTK/Yfk2Ss6vqpiTPntbT\n", "3buSXJ1kV5J3J3lJdx8Wt88BAACHp1lvn+vuW5I89QDb70hy1kGOuTzJ5XPOBQAAcD+/AwgAABia\n", "KAIAAIYmigAAgKGJIgAAYGiiCAAAGJooAgAAhiaKAACAoYkiAABgaKIIAAAYmigCAACGJooAAICh\n", "iSIAAGBooggAABiaKAIAAIYmigAAgKGJIgAAYGiiCAAAGJooAgAAhiaKAACAoYkiAABgaKIIAAAY\n", "migCAACGJooAAIChiSIAAGBooggAABiaKAIAAIYmigAAgKGJIgAAYGiiCAAAGJooAgAAhiaKAACA\n", "oYkiAABgaKIIAAAYmigCAACGdsyD7VBV25L8RpJTu/uHq+opSX6wu3939ukAAABmtpErRf8zyf9N\n", "8thpvZO8dLaJAAAAFmgjUXRSd/9OknuSpLu/nOS+WacCAABYkI1E0T1VddT9K1X12EPtDAAAcDjZ\n", "SBS9PcnvJnlMVf1skuuTvGnOoQAAABblQaOou1+b5ANJVpP8RJLf6u7Xzz0YAADAIjzo2+eSpLvf\n", "muStM88CAACwcA96paiqtlfVn1fV7mn96VX1azPPBQAAsBAbeabod5L8lyR3Tut/k+SC2SYCAABY\n", "oI1E0XHd/e4k+5Oku+9N8pVZpwIAAFiQjb6Se8v9K1V1UpJ75xsJAABgcTZ6+9zbkzy+qv5Tkj9P\n", "8huzTgUAALAgD/r2ue7eWVX/kOQ5SR6R5AXd/YGN/gVVdXSSDyXZ093PqarHJbkqyalJdie5oLvv\n", "nPa9LMklWbsS9bLuvu4b/PcBAAD4hhwyiqrqmCQ3dvfTs/a7ir4ZL0+yK8mjp/VLk1zf3a+rqldO\n", "65dW1Y4kFybZkeSkJO+tqu3dfd83+fcCAAA8qEPePtfd9yT5QlU94pv54lV1ctZ+4esbkxw1bT43\n", "yc5peWeS86fl85Jc2d13d/fuJDcnOfOb+XsBAAA2aiO/vPWmJO+vqrcl+Zdp2/7uvmIDx/5mklck\n", "ecy6bdu6e++0vDfJtmn5xCR/tW6/PVm7YgQAADCbjbxo4Zis3f72xCTfO/3zfQ92UFX9VJLbu/vD\n", "+dpVoq/T3fszver7IA71GQAAwLdsIy9a+Nlv8mv/YJJzq+onkjw8yWOq6i1J9lbV8d19W1WdkOT2\n", "af9bk5yy7viTp22HhX379mV1dXXZYzAz32MWzTnHIjnfWCTnG5vJg0ZRVb00//aKzV1ZewHD3x/s\n", "uO5+VZJXTV/jR5L8Unf/TFW9LsnFSV47/XnNdMi1Sf6gqv5b1m6bOyPJjd/Yv87ybN26NSsrK8se\n", "gxmtrq76HrNQzjkWyfnGIjnfWKSNBPhGbp87J8mrk5yV5Owkl2ctZt5XVS/6Bua5P6xek+Tsqrop\n", "ybOn9XT3riRXZ+1WvXcnecl0ex0AAMBsNvKihfuSPLm7/ylJquqUJFdk7c1w703yew/2Bbr7/Une\n", "Py3fkbXAOtB+l2ctugAAABZiI1eKvuv+IEqS7v5UktO7+9NJ7p5tMgAAgAXYyJWivVX1qiRvytpb\n", "5C5OcntVHR1vhwMAAA5zG7lS9IIkK0k+luSjWXsl9wuSfPv0JwAAwGFrI6/kvjXJTx/k448+tOMA\n", "AAAs1kZeyf3IJJcl+c7ufl5VfXeS7+7uax7kUAAAgE1vI7fP/U7WbpV76rR+a5Jfm2sgAACARdpI\n", "FD2lu1+Z5MtJ0t2fz9oLFwAAAA57G4miL69fqaqHb/A4AACATW8jcfN/quqXkzy8qn40yR8leees\n", "UwEAACzIRqLoVdOfn0vyuiQfjGeKAACAI8Qh3z5XVWcm+aUkT5o2fSzJe7r7nrkHAwAAWISDXimq\n", "qh9I8p4kn0zyy0l+Jck/JLmuqp6xmPEAAADmdagrRa9Mckl3v2PdtrdX1V8luTTJ+bNOBgAAsACH\n", "eqboSQ8IoiRJd78zX7udDgAA4LB2qCj6l2/yMwAAgMPGoW6fe1hV7TjA9qOSPGymeQAAABbqUFH0\n", "iCR/uqhBAAAAluGgUdTdpy1wDgAAgKXYyC9vBQAAOGKJIgAAYGiiCAAAGJooAgAAhiaKAACAoYki\n", "AABgaKIIAAAYmigCAACGJooAAIChiSIAAGBooggAABiaKAIAAIYmigAAgKGJIgAAYGiiCAAAGJoo\n", "AgAAhiaKAACAoYkiAABgaKIIAAAYmigCAACGJooAAIChiSIAAGBooggAABiaKAIAAIYmigAAgKGJ\n", "IgAAYGiiCAAAGJooAgAAhiaKAACAoR0z1xeuqocneX+ShyXZkuSd3X1ZVT0uyVVJTk2yO8kF3X3n\n", "dMxlSS5Jcm+Sl3X3dXPNBwAAkMx4pai7v5TkWd391CRPSfKsqvqhJJcmub67tye5YVpPVe1IcmGS\n", "HUnOSXJFVbmSBQAAzGrW6OjuL06LW5IcnWRfknOT7Jy270xy/rR8XpIru/vu7t6d5OYkZ845HwAA\n", "wKxRVFXfVlUfSbI3yZ91998l2dbde6dd9ibZNi2fmGTPusP3JDlpzvkAAABme6YoSbr7viRPrarj\n", "krynqp71gM/3V9X+Q3yJQ322qezbty+rq6vLHoOZ+R6zaM45Fsn5xiI539hMZo2i+3X3XVX1p0lW\n", "kuytquO7+7aqOiHJ7dNutyY5Zd1hJ0/bDgtbt27NysrKssdgRqurq77HLJRzjkVyvrFIzjcWaSMB\n", "Ptvtc1X1+Kp67LT8iCRnJ/lwkmuTXDztdnGSa6bla5NcVFVbqur0JGckuXGu+QAAAJJ5nyk6Icn7\n", "pmeKPpjkXd19Q5LXJDm7qm5K8uxpPd29K8nVSXYleXeSl3T3YXP7HAAAcHia7fa57v5okqcfYPsd\n", "Sc46yDGXJ7l8rpkAAAAeyO8BAgAAhiaKAACAoYkiAABgaKIIAAAYmigCAACGJooAAIChiSIAAGBo\n", "oggAABiaKAIAAIYmigAAgKGJIgAAYGiiCAAAGJooAgAAhiaKAACAoYkiAABgaKIIAAAYmigCAACG\n", "JooAAIChiSIAAGBooggAABiaKAIAAIYmigAAgKGJIgAAYGiiCAAAGJooAgAAhiaKAACAoYkiAABg\n", "aKIIAAAYmigCAACGJooAAIChiSIAAGBooggAABiaKAIAAIYmigAAgKGJIgAAYGiiCAAAGJooAgAA\n", "hiaKAACAoYkiAABgaKIIAAAYmigCAACGJooAAIChiSIAAGBooggAABiaKAIAAIYmigAAgKGJIgAA\n", "YGjHzPnFq+qUJG9O8oQk+5O8obv/e1U9LslVSU5NsjvJBd1953TMZUkuSXJvkpd193VzzggAAIxt\n", "7itFdyf5xe5+UpJnJHlpVT0xyaVJru/u7UlumNZTVTuSXJhkR5JzklxRVa5mAQAAs5k1OLr7tu7+\n", "yLT8hSQfT3JSknOT7Jx225nk/Gn5vCRXdvfd3b07yc1JzpxzRgAAYGwLuwpTVacleVqSDybZ1t17\n", "p4/2Jtk2LZ+YZM+6w/ZkLaIAAABmMeszRferqkcl+eMkL+/uz1fVVz/r7v1Vtf8Qhx/qs01j3759\n", "WV1dXfYYzMz3mEVzzrFIzjcWyfnGZjJ7FFXVt2ctiN7S3ddMm/dW1fHdfVtVnZDk9mn7rUlOWXf4\n", "ydO2TW/r1q1ZWVlZ9hjMaHV11feYhXLOsUjONxbJ+cYibSTAZ719rqqOSvJ7SXZ19+vXfXRtkoun\n", "5YuTXLNu+0VVtaWqTk9yRpIb55wRAAAY29xXip6Z5PlJ/raqPjxtuyzJa5JcXVUvyvRK7iTp7l1V\n", "dXWSXUnuSfKS7j4sbp8DAAAOT7NGUXf/eQ5+NeqsgxxzeZLLZxsKAABgHb8DCAAAGJooAgAAhiaK\n", "AACAoYkiAABgaKIIAAAYmigCAACGNvfvKRrGvffek5tuumnZY3zVaaedli1btix7DAAA2PRE0UPk\n", "c3d+Nj9z2R/k2OOesOxR8sW7bs9bXv28bN++fdmjAADApieKHkLHHveEPGrrScseAwAA+AZ4pggA\n", "ABiaKAIAAIYmigAAgKGJIgAAYGiiCAAAGJooAgAAhiaKAACAoYkiAABgaKIIAAAYmigCAACGJooA\n", "AIChiSIAAGBooggAABiaKAIAAIYmigAAgKGJIgAAYGiiCAAAGJooAgAAhiaKAACAoYkiAABgaKII\n", "AAAYmigCAACGJooAAIChiSIAAGBooggAABiaKAIAAIYmigAAgKGJIgAAYGiiCAAAGJooAgAAhiaK\n", "AACAoYkiAABgaKIIAAAYmigCAACGJooAAIChiSIAAGBooggAABiaKAIAAIZ2zJxfvKp+P8lPJrm9\n", "u588bXtckquSnJpkd5ILuvvO6bPLklyS5N4kL+vu6+acDwAAYO4rRW9Kcs4Dtl2a5Pru3p7khmk9\n", "VbUjyYVJdkzHXFFVrmQBAACzmjU6uvsDSfY9YPO5SXZOyzuTnD8tn5fkyu6+u7t3J7k5yZlzzgcA\n", "ALCMKzHbunvvtLw3ybZp+cQke9bttyfJSYscDAAAGM+szxQ9mO7eX1X7D7HLoT7bVD531+eSLccv\n", "e4yv+tjHPpbPf/7zyx7jiLO6urrsERiMc45Fcr6xSM43NpNlRNHeqjq+u2+rqhOS3D5tvzXJKev2\n", "O3nadlh4zHGPyZ3/uuwpvuZ7vud7sn379mWPcURZXV3NysrKssdgIM45Fsn5xiI531ikjQT4Mm6f\n", "uzbJxdPyxUmuWbf9oqraUlWnJzkjyY1LmA8AABjI3K/kvjLJjyR5fFV9KsmvJnlNkqur6kWZXsmd\n", "JN29q6quTrIryT1JXtLdh83tcwAAwOFp1ijq7uce5KOzDrL/5Ukun28iAACAr+f3AAEAAEMTRQAA\n", "wNBEEQAAMDRRBAAADE0UAQAAQxNFAADA0EQRAAAwNFEEAAAMTRQBAABDE0UAAMDQRBEAADA0UQQA\n", "AAxNFAEAAEMTRQAAwNBEEQAAMDRRBAAADE0UAQAAQxNFAADA0EQRAAAwNFEEAAAMTRQBAABDE0UA\n", "AMDQRBEAADA0UQQAAAztmGUPwEPvvnvvyS233LLsMb7qtNNOy5YtW5Y9BgAAHJAoOgJ96Qufza++\n", "4S9z7HGfXPYo+eJdt+ctr35etm/fvuxRAADggETREerY456QR209adljAADApueZIgAAYGiiCAAA\n", "GJooAgAAhiaKAACAoYkiAABgaKIIAAAYmigCAACGJooAAIChiSIAAGBooggAABiaKAIAAIZ2zLIH\n", "4Mh237335JZbbln2GF/ntNNOy5YtW5Y9BgAAm4QoYlZf+sJn86tv+Msce9wnlz1KkuSLd92et7z6\n", "edm+ffuyRwEAYJMQRczu2OOekEdtPWnZYwAAwAF5pggAABiaKAIAAIYmigAAgKF5poihfCtvw/vH\n", "f/zHPPrRj35I5/EmPACA5RNFDOVbfhven9z2kM3iTXgAAJuDKGI43oYHAMB6my6KquqcJK9PcnSS\n", "N3b3a5c8EhzxvvKVr2T37t3LHuPruLUQAFiUTRVFVXV0kt9OclaSW5P8dVVd290fX+5k8ND7Vp5v\n", "eqjdcsst022FT1j2KEk2162FywzGgz3HJhgB4KG1qaIoyZlJbu7u3UlSVX+Y5Lwkoogjzrf8fNND\n", "6LN7Pp7vOPmJm+a2QsG4zgOeYxOMB/aVr3wlSTZVLIpXeGhspp81yeb7eeNnzUNjs0XRSUk+tW59\n", "T5LvP9QBR931d7MOtFH35vP54l2b4w3n//r5O5IctewxkmyuWZLNNc+/fv6OPOLR37HsMb7qi3fd\n", "vuwRvmrfp/8+r/j1T+Thj3rcskfJXXv/IY89YfkBst5mCsZX/Po7N8336WGPfOymmCVJvvSFO/Jf\n", "f+m8nH766cseZcPmeMMmHMw3cr5tpp81yeb6efOlL9yRt/2PX9gU/6PscHfU/v37lz3DV1XVTyc5\n", "p7tfPK0/P8n3d/fPH2j/1dXVzTM8AACwKa2srBzy/4pvtitFtyY5Zd36KVm7WnRAD/YvBwAA8GA2\n", "WxR9KMkZVXVakn9OcmGS5y51IgAA4Ii2OR6CmXT3PUl+Lsl7kuxKcpU3zwEAAHPaVM8UAQAALNqm\n", "ulIEAACwaKIIAAAYmigCAACGttnePrdhVXVOktcnOTrJG7v7tUseiSNUVf1+kp9Mcnt3P3nZ83Bk\n", "q6pTkrw5yROS7E/yhu7+78udiiNVVT08yfuTPCzJliTv7O7LljsVR7qqOjprbxze093PWfY8HNmq\n", "aneSzyW5N8nd3X3mgfY7LK8UTf8x/XaSc5LsSPLcqnricqfiCPamrJ1rsAh3J/nF7n5Skmckeamf\n", "b8ylu7+U5Fnd/dQkT0nyrKr6oSWPxZHv5Vl7y7C3fbEI+5P8aHc/7WBBlBymUZTkzCQ3d/fu7r47\n", "yR8mOW/JM3GE6u4PJNm37DkYQ3ff1t0fmZa/kOTjSU5c7lQcybr7i9PilqzdfXHHEsfhCFdVJyf5\n", "iSRvTHLUksdhHA96rh2uUXRSkk+tW98zbQM4Yky/yPppST645FE4glXVt1XVR5LsTfJn3b1r2TNx\n", "RPvNJK9Ict+yB2EY+5O8t6o+VFUvPthOh2sUudwKHNGq6lFJ3pbk5dMVI5hFd9833T53cpL/UFU/\n", "uuSROEJV1U9l7fncD8dVIhbnmd39tCQ/nrVb0n/4QDsdrlF0a5JT1q2fkrWrRQCHvar69iR/nOSt\n", "3X3NsudhDN19V5I/TfK9y56FI9YPJjm3qm5JcmWSZ1fVm5c8E0e47v709Odnkrwja4/h/BuHaxR9\n", "KMkZVXVaVW1JcmGSa5c8E8C3rKqOSvJ7SXZ19+uXPQ9Htqp6fFU9dlp+RJKzk3x4uVNxpOruV3X3\n", "Kd19epKLkryvu1+w7Lk4clXVsVX16Gn5kUl+LMlHD7TvYRlF3X1Pkp9L8p6svb3kqu7++HKn4khV\n", "VVcm+Ysk26vqU1X1wmXPxBHtmUmen7W3gH14+sfbD5nLCUneNz1T9MEk7+ruG5Y8E+PwOARz25bk\n", "A+t+xv1Jd193oB2P2r/f+QgAAIzrsLxSBAAA8FARRQAAwNBEEQAAMDRRBAAADE0UAQAAQxNFAADA\n", "0EQRAAAwtP8P0ukbo4bXAD4AAAAASUVORK5CYII=\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "ETFs.Dividend.plot(kind='hist', bins=20)" ] }, { "cell_type": "code", "execution_count": 204, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 204, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": [ "iVBORw0KGgoAAAANSUhEUgAAA00AAAHiCAYAAAA01ic+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n", "AAALEgAACxIB0t1+/AAAHqBJREFUeJzt3X3QpXdd3/FPSFgggAGGZvPYJNbdrywrBbZG60MLTLCR\n", "1iTWmSTgQzSMfQBB29GS6MjotA1odYqOBUWU2aKGpAohPjAkoEOxRQK3qKyr3xjYVTaQDQWSTUgx\n", "m+TuH3sS7252f3vvw3m4d1+vf/Y617muO99sfnsm773Ouc5Jy8vLAQAA4MCeMO8BAAAAFploAgAA\n", "GBBNAAAAA6IJAABgQDQBAAAMiCYAAICBU6b5w6uqkrxzxa6vTPLjSX4tyQ1JzkuyM8nl3X3P5Jxr\n", "k1yd5OEkr+3uW6Y5IwAAwMhJs/qepqp6QpI7k1yY5DVJ/k93/3RVvS7JM7v7mqralOQ3knxtkrOT\n", "vD/Jxu5+ZCZDAgAA7GeWb8+7KMkd3f3pJJck2TrZvzXJZZPtS5Nc3917u3tnkjuyL7IAAADmYpbR\n", "dGWS6yfb67t792R7d5L1k+2zkuxacc6u7LviBAAAMBdT/UzTo6pqXZJvS/K6/Z/r7uWqGr1H8KDP\n", "LS0tzea9hQAAwJq1ZcuWk47m/JlEU5JvTbLU3Z+bPN5dVWd0911VdWaSuyf770xy7orzzpnsO6gt\n", "W7Yc82HhQJaWlqw3ZsqaY5asN2bJemOWlpaWjvpnzOrteS/P3701L0luTnLVZPuqJDet2H9lVa2r\n", "qguSbEhy24xmBAAAeJypR1NVPTX7bgLxrhW735jkpVV1e5KXTB6nu7cnuTHJ9iTvTfKq7vYWPAAA\n", "YG6m/va87v5Skmfvt+8L2RdSBzr+uiTXTXsuAACA1Zjl3fMAAADWHNEEAAAwIJoAAAAGRBMAAMCA\n", "aAIAABgQTQAAAAOiCQAAYEA0AQAADIgmAACAAdEEAAAwIJoAAAAGRBMAAMCAaAIAABg4Zd4DHK13\n", "3/zeeY9wQP/son+aU089dd5jAAAAR2nNR9Nb379n3iM8zpe+cGc2P+ersmHDhnmPAgAAHKU1H02n\n", "PPHJ8x7hcU5+4pPmPQIAAHCM+EwTAADAgGgCAAAYEE0AAAADogkAAGBANAEAAAyIJgAAgAHRBAAA\n", "MCCaAAAABkQTAADAgGgCAAAYEE0AAAADogkAAGBANAEAAAyIJgAAgAHRBAAAMCCaAAAABkQTAADA\n", "gGgCAAAYEE0AAAADogkAAGBANAEAAAyIJgAAgAHRBAAAMCCaAAAABkQTAADAgGgCAAAYEE0AAAAD\n", "ogkAAGBANAEAAAyIJgAAgAHRBAAAMCCaAAAABkQTAADAgGgCAAAYEE0AAAADogkAAGBANAEAAAyI\n", "JgAAgAHRBAAAMHDKtP8BVfWMJG9L8twky0m+L8lfJbkhyXlJdia5vLvvmRx/bZKrkzyc5LXdfcu0\n", "ZwQAADiYWVxp+rkkv9fdz0nyvCR/meSaJLd298YkH5g8TlVtSnJFkk1JLk7y5qpyNQwAAJibqQZJ\n", "VZ2W5Ju7+1eTpLsf6u57k1ySZOvksK1JLptsX5rk+u7e2907k9yR5MJpzggAADAy7bfnXZDkc1X1\n", "9iT/MMlSkh9Ksr67d0+O2Z1k/WT7rCR/tOL8XUnOnvKMAAAABzXtaDolyQuT/EB3f7Sq3pTJW/Ee\n", "1d3LVbU8+Bmj5xbWtm3bsmfPnnmPwTG2tLQ07xE4wVhzzJL1xixZb6wl046mXUl2dfdHJ49/M8m1\n", "Se6qqjO6+66qOjPJ3ZPn70xy7orzz5nsW3M2b96cDRs2zHsMjqGlpaVs2bJl3mNwArHmmCXrjVmy\n", "3pilYxHoU/1MU3ffleTTVbVxsuuiJH+e5LeTXDXZd1WSmybbNye5sqrWVdUFSTYkuW2aMwIAAIxM\n", "/ZbjSV6T5Neral2ST2bfLcdPTnJjVb0yk1uOJ0l3b6+qG5NsT/JQkld195p8ex4AAHB8mHo0dfef\n", "JvnaAzx10UGOvy7JdVMdCgAAYJV8BxIAAMCAaAIAABgQTQAAAAOiCQAAYEA0AQAADIgmAACAAdEE\n", "AAAwIJoAAAAGRBMAAMCAaAIAABgQTQAAAAOiCQAAYEA0AQAADIgmAACAAdEEAAAwIJoAAAAGRBMA\n", "AMCAaAIAABgQTQAAAAOiCQAAYEA0AQAADIgmAACAAdEEAAAwIJoAAAAGRBMAAMCAaAIAABgQTQAA\n", "AAOiCQAAYEA0AQAADIgmAACAAdEEAAAwIJoAAAAGRBMAAMCAaAIAABgQTQAAAAOiCQAAYEA0AQAA\n", "DIgmAACAAdEEAAAwIJoAAAAGRBMAAMCAaAIAABgQTQAAAAOiCQAAYEA0AQAADIgmAACAAdEEAAAw\n", "IJoAAAAGRBMAAMCAaAIAABgQTQAAAAOiCQAAYEA0AQAADIgmAACAAdEEAAAwcMq0/wFVtTPJniQP\n", "J9nb3RdW1bOS3JDkvCQ7k1ze3fdMjr82ydWT41/b3bdMe0YAAICDmcWVpuUkL+ruF3T3hZN91yS5\n", "tbs3JvnA5HGqalOSK5JsSnJxkjdXlathAADA3MwqSE7a7/ElSbZOtrcmuWyyfWmS67t7b3fvTHJH\n", "kgsDAAAwJ7O60vT+qvpYVX3/ZN/67t492d6dZP1k+6wku1acuyvJ2TOYEQAA4ICm/pmmJN/Y3Z+t\n", "qr+X5Naq+suVT3b3clUtD84fPbewtm3blj179sx7DI6xpaWleY/ACcaaY5asN2bJemMtmXo0dfdn\n", "J79+rqrenX1vt9tdVWd0911VdWaSuyeH35nk3BWnnzPZt+Zs3rw5GzZsmPcYHENLS0vZsmXLvMfg\n", "BGLNMUvWG7NkvTFLxyLQp/r2vKo6taqePtl+apJvSfKJJDcnuWpy2FVJbpps35zkyqpaV1UXJNmQ\n", "5LZpzggAADAy7c80rU/yoar6kyQfSfI7k1uIvzHJS6vq9iQvmTxOd29PcmOS7Unem+RV3b0m354H\n", "AAAcH6b69rzu3pHk+QfY/4UkFx3knOuSXDfNuQAAAFbLdyABAAAMiCYAAIAB0QQAADAgmgAAAAZE\n", "EwAAwIBoAgAAGBBNAAAAA6IJAABgQDQBAAAMiCYAAIAB0QQAADAgmgAAAAZEEwAAwIBoAgAAGBBN\n", "AAAAA6IJAABgQDQBAAAMiCYAAIAB0QQAADAgmgAAAAZEEwAAwIBoAgAAGBBNAAAAA6IJAABgQDQB\n", "AAAMiCYAAIAB0QQAADAgmgAAAAZEEwAAwIBoAgAAGBBNAAAAA6IJAABgQDQBAAAMiCYAAIAB0QQA\n", "ADAgmgAAAAZEEwAAwIBoAgAAGBBNAAAAA6IJAABgQDQBAAAMiCYAAIAB0QQAADAgmgAAAAZEEwAA\n", "wIBoAgAAGBBNAAAAA6IJAABgQDQBAAAMiCYAAIAB0QQAADAgmgAAAAZEEwAAwIBoAgAAGBBNAAAA\n", "A6dM+x9QVScn+ViSXd39bVX1rCQ3JDkvyc4kl3f3PZNjr01ydZKHk7y2u2+Z9nwAAAAjs7jS9INJ\n", "tidZnjy+Jsmt3b0xyQcmj1NVm5JckWRTkouTvLmqXAkDAADmaqpRUlXnJHlZkrclOWmy+5IkWyfb\n", "W5NcNtm+NMn13b23u3cmuSPJhdOcDwAA4FCmfSXnvyb5kSSPrNi3vrt3T7Z3J1k/2T4rya4Vx+1K\n", "cvaU5wMAABia2meaqupfJLm7uz9eVS860DHdvVxVywd6bmL03ELbtm1b9uzZM+8xOMaWlpbmPQIn\n", "GGuOWbLemCXrjbVkmjeC+IYkl1TVy5I8OclXVNU7kuyuqjO6+66qOjPJ3ZPj70xy7orzz5nsW5M2\n", "b96cDRs2zHsMjqGlpaVs2bJl3mNwArHmmCXrjVmy3pilYxHoU3t7Xnf/aHef290XJLkyye9393cn\n", "uTnJVZPDrkpy02T75iRXVtW6qrogyYYkt01rPgAAgNWY5d3pHn2r3RuTvLSqbk/yksnjdPf2JDdm\n", "35323pvkVd29Zt+eBwAAHB+m/j1NSdLdH0zywcn2F5JcdJDjrkty3SxmAgAAWA3fgwQAADAgmgAA\n", "AAZEEwAAwIBoAgAAGBBNAAAAA6IJAABgQDQBAAAMiCYAAIAB0QQAADAgmgAAAAZOOdQBVbU+yc8m\n", "Oa+7v7mqnpfkG7r7F6c+HQAAwJyt5krTLyf5X0meMXncSV49tYkAAAAWyGqi6ezufkuSh5Kku/82\n", "ySNTnQoAAGBBrCaaHqqqkx59UFXPGB0MAABwPFlNNL0ryS8m+Yqq+t4ktyZ5+zSHAgAAWBSHjKbu\n", "/qkkH0qylORlSX6uu9807cEAAAAWwSHvnpck3f1rSX5tyrMAAAAsnENeaaqqjVX1h1W1c/L4hVX1\n", "E1OeCwAAYCGs5jNNb0nyn5PcM3n8p0kun9pEAAAAC2Q10XRad783yXKSdPfDSR6c6lQAAAALYrW3\n", "HF/36IOqOjvJw9MbCQAAYHGs9u1570ry7Kr6ySR/mORnpzoVAADAgjjk3fO6e2tVfSrJtyV5SpLv\n", "6e4PTX0yAACABTCMpqo6Jclt3f3C7PuuJgAAgBPK8O153f1Qkvur6ikzmgcAAGChrObLbW9P8sGq\n", "+s0kX5rsW+7uN09vLAAAgMWwmmg6Jcn2JM+Z8iwAAAALZzU3gvjeGcwBAACwkA4ZTVX16ky+2HaF\n", "e7PvBhF/NZWpAAAAFsRqvqfp4iRvSHJRkpcmuS7JVUl+v6peOcXZAAAA5m410fRIkq/p7n/Z3d+e\n", "5GuS/G2SC5P8+2kOBwAAMG+riaZ/0N1/8+iD7v50kgu6+7NJ9k5tMgAAgAWwmrvn7a6qH03y9iQn\n", "Zd9b8+6uqpPz+M86AQAAHFdWc6Xpe5JsSbItySeS/KPJvidOfgUAADhureaW43cm+Y6DPP2JYzsO\n", "AADAYlnNLcefmuTaJF/Z3a+oqq9O8tXdfdPUpwMAAJiz1bw97y3Z91a8508e35nkJ6Y1EAAAwCJZ\n", "TTQ9r7tfl323GU9335d9N4QAAAA47q0mmv525YOqevIqzwMAAFjzVhM//7OqfizJk6vqRUn+R5L3\n", "THUqAACABbGaaPrRya97kvx0ko/EZ5oAAIATxPDueVV1YZIfTvLcya5tSd7X3Q9NezAAAIBFcNAr\n", "TVX1j5O8L8knk/xYkh9P8qkkt1TV189mPAAAgPkaXWl6XZKru/vdK/a9q6r+KMk1SS6b6mQAAAAL\n", "YPSZpufuF0xJku5+T/7u7XoAAADHtVE0fekInwMAADhujN6e96Sq2nSA/ScledKU5gEAAFgoo2h6\n", "SpLfndUgAAAAi+ig0dTd589wDgAAgIW0mi+3BQAAOGGJJgAAgAHRBAAAMCCaAAAABkQTAADAwOiW\n", "40elqp6c5IPZ951O65K8p7uvrapnJbkhyXlJdia5vLvvmZxzbZKrkzyc5LXdfcu05gMAAFiNqV1p\n", "6u4vJ3lxdz8/yfOSvLiqvinJNUlu7e6NST4weZzJF+lekWRTkouTvLmqXAkDAADmaqpR0t0PTDbX\n", "JTk5yReTXJJk62T/1iSXTbYvTXJ9d+/t7p1J7khy4TTnAwAAOJSpRlNVPaGq/iTJ7iR/0N1/nmR9\n", "d++eHLI7yfrJ9llJdq04fVeSs6c5HwAAwKFM7TNNSdLdjyR5flWdluR9VfXi/Z5frqrlwY8YPbfQ\n", "tm3blj179sx7DI6xpaWleY/ACcaaY5asN2bJemMtmWo0Paq7762q302yJcnuqjqju++qqjOT3D05\n", "7M4k56447ZzJvjVp8+bN2bBhw7zH4BhaWlrKli1b5j0GJxBrjlmy3pgl641ZOhaBPrW351XVs6vq\n", "GZPtpyR5aZKPJ7k5yVWTw65KctNk++YkV1bVuqq6IMmGJLdNaz4AAIDVmOZnms5M8vuTzzR9JMlv\n", "d/cHkrwxyUur6vYkL5k8TndvT3Jjku1J3pvkVd29Zt+eBwAAHB+m9va87v5EkhceYP8Xklx0kHOu\n", "S3LdtGYCAAA4XL4HCQAAYEA0AQAADIgmAACAAdEEAAAwIJoAAAAGRBMAAMCAaAIAABgQTQAAAAOi\n", "CQAAYEA0AQAADIgmAACAAdEEAAAwIJoAAAAGRBMAAMCAaAIAABgQTQAAAAOiCQAAYEA0AQAADIgm\n", "AACAAdEEAAAwIJoAAAAGRBMAAMCAaAIAABgQTQAAAAOiCQAAYEA0AQAADIgmAACAAdEEAAAwIJoA\n", "AAAGRBMAAMCAaAIAABgQTQAAAAOiCQAAYEA0AQAADIgmAACAAdEEAAAwIJoAAAAGRBMAAMCAaAIA\n", "ABgQTQAAAAOiCQAAYEA0AQAADIgmAACAAdEEAAAwIJoAAAAGRBMAAMCAaAIAABgQTQAAAAOiCQAA\n", "YEA0AQAADIgmAACAAdEEAAAwIJoAAAAGRBMAAMCAaAIAABg4ZZo/vKrOTfLfk5yeZDnJW7v756vq\n", "WUluSHJekp1JLu/ueybnXJvk6iQPJ3ltd98yzRkBAABGpn2laW+Sf9fdz03y9UleXVXPSXJNklu7\n", "e2OSD0wep6o2JbkiyaYkFyd5c1W5GgYAAMzNVIOku+/q7j+ZbN+f5C+SnJ3kkiRbJ4dtTXLZZPvS\n", "JNd3997u3pnkjiQXTnNGAACAkZldxamq85O8IMlHkqzv7t2Tp3YnWT/ZPivJrhWn7cq+yAIAAJiL\n", "qX6m6VFV9bQkv5XkB7v7vqp67LnuXq6q5cHpo+cW1rZt27Jnz555j8ExtrS0NO8ROMFYc8yS9cYs\n", "WW+sJVOPpqp6YvYF0zu6+6bJ7t1VdUZ331VVZya5e7L/ziTnrjj9nMm+NWfz5s3ZsGHDvMfgGFpa\n", "WsqWLVvmPQYnEGuOWbLemCXrjVk6FoE+1bfnVdVJSX4lyfbuftOKp25OctVk+6okN63Yf2VVrauq\n", "C5JsSHLbNGcEAAAYmfaVpm9M8l1J/qyqPj7Zd22SNya5sapemcktx5Oku7dX1Y1Jtid5KMmruntN\n", "vj0PAAA4Pkw1mrr7D3Pwq1kXHeSc65JcN7WhAAAADoPvQAIAABgQTQAAAAOiCQAAYEA0AQAADIgm\n", "AACAAdEEAAAwIJoAAAAGRBMAAMCAaAIAABgQTQAAAAOiCQAAYEA0AQAADIgmAACAAdEEAAAwIJoA\n", "AAAGRBMAAMCAaAIAABgQTQAAAAOiCQAAYEA0AQAADIgmAACAAdEEAAAwIJoAAAAGRBMAAMCAaAIA\n", "ABgQTQAAAAOnzHuA49EjDz+UHTt2ZHl5ed6jHND555+fdevWzXsMAABYE0TTFHz5/s/nx3/pf+fU\n", "0+6Y9yiP88C9d+cdb3hFNm7cOO9RAABgTRBNU3Lqaafnac88e95jAAAAR8lnmgAAAAZEEwAAwIBo\n", "AgAAGBBNAAAAA6IJAABgQDQBAAAMiCYAAIAB0QQAADAgmgAAAAZEEwAAwIBoAgAAGBBNAAAAA6IJ\n", "AABgQDQBAAAMiCYAAIAB0QQAADAgmgAAAAZEEwAAwIBoAgAAGBBNAAAAA6IJAABgQDQBAAAMiCYA\n", "AIAB0QQAADAgmgAAAAZEEwAAwMAp0/zhVfWrSf55kru7+2sm+56V5IYk5yXZmeTy7r5n8ty1Sa5O\n", "8nCS13b3LdOcDwAA4FCmfaXp7Uku3m/fNUlu7e6NST4weZyq2pTkiiSbJue8uapcCQMAAOZqqlHS\n", "3R9K8sX9dl+SZOtke2uSyybblya5vrv3dvfOJHckuXCa8wEAABzKPK7krO/u3ZPt3UnWT7bPSrJr\n", "xXG7kpw9y8EAAAD2N9XPNB1Kdy9X1fLgkNFzHKFt27blvvvum/cYa9LS0tK8R+AEY80xS9Ybs2S9\n", "sZbMI5p2V9UZ3X1XVZ2Z5O7J/juTnLviuHMm+zjGNm/enI0bN857jDVnaWkpW7ZsmfcYnECsOWbJ\n", "emOWrDdm6VgE+jzenndzkqsm21cluWnF/iural1VXZBkQ5Lb5jAfAADAY6Z9y/Hrk/zTJM+uqk8n\n", "eX2SNya5sapemcktx5Oku7dX1Y1Jtid5KMmrutvb8wAAgLmaajR198sP8tRFBzn+uiTXTW8iAACA\n", "w+N7kAAAAAZEEwAAwIBoAgAAGBBNAAAAA6IJAABgQDQBAAAMiCYAAICBqX5PE4vnkYcfyo4dO+Y9\n", "xkGdf/75Wbdu3bzHAACAx4imE8yX7/98Xv/WD+fU0z4571Ee54F778473vCKbNy4cd6jAADAY0TT\n", "CejU007P05559rzHAACANcFnmgAAAAZEEwAAwIBoAgAAGBBNAAAAA6IJAABgQDQBAAAMiCYAAIAB\n", "0QQAADAgmgAAAAZEEwAAwIBoAgAAGBBNAAAAA6IJAABg4JR5DwCPeuThh7Jjx455j3FQe/funfcI\n", "AADMgWhiYXz5/s/n9W/9cE497ZPzHuVxHrj37rzuO5837zEAAJgD0cRCOfW00/O0Z5497zEAAOAx\n", "PtMEAAAwIJoAAAAGRBMAAMCAaAIAABgQTQAAAAOiCQAAYEA0AQAADIgmAACAAdEEAAAwIJoAAAAG\n", "RBMAAMCAaAIAABgQTQAAAAOiCQAAYEA0AQAADIgmAACAAdEEAAAwIJoAAAAGRBMAAMCAaAIAABg4\n", "Zd4DwFrwyMMP5TOf+Uxuv/32eY/yOOeff37WrVs37zEAAI5boglW4cv3fz7v+IOT8lt//P55j/L/\n", "eeDeu/OON7wiGzdunPcoAADHLdEEq3Tqaafnac88e95jAAAwYz7TBAAAMCCaAAAABkQTAADAgM80\n", "wRr2yMMPZceOHfMe46Dc2Q8AOB6IJljDvnz/5/P6t344p572yXmP8jj3f/Gz+U//5ptywQUXzHuU\n", "AxJ0AMBqiSZY4xb1rn4P3Lt7YYPOrdoBgMOxcNFUVRcneVOSk5O8rbt/as4jAUdoUYNukT344IPZ\n", "uXNnkuSv//qv8/SnP32+A+3HFToATkQLFU1VdXKSX0hyUZI7k3y0qm7u7r+Y72QAs7Fz585897W/\n", "kVNPO33fjt+5a74DrbDIV+hWxuYiEpsAa9tCRVOSC5Pc0d07k6Sq3pnk0iSiCThmFvkGGjt27FjY\n", "K3SL/vu27+2gp897lMdZ1NjcPzQX7crmooamQD8yi7zeHnzwwSRZyN+3ZDH/m56Ifw4WLZrOTvLp\n", "FY93Jfm60Qkn3fvnUx3oSDzhgU/ngZMW827u//e+LyQ5ad5jHJDZDt+izpUs9mxf/Oxf5Ud+5i/z\n", "5Kc9a96jPM69uz+VZ5y5WP9z/Si/b0duEWNzx44d+ZGfec9+/z3/eG7zrPTl+7+Q//LDly7kjWQO\n", "/Pu2GNbe79tirLd7d38qT3rqM/w3PQyL/ufgN//bDx3zv6g6aXl5+Zj+wKNRVd+R5OLu/v7J4+9K\n", "8nXd/ZoDHb+0tLQ4wwMAAAtpy5YtR/U3uYt2penOJOeueHxu9l1tOqCj/ZcHAAA4lEWLpo8l2VBV\n", "5yf5TJIrkrx8rhMBAAAntIX64E13P5TkB5K8L8n2JDe4cx4AADBPC/WZJgAAgEWzUFeaAAAAFo1o\n", "AgAAGBBNAAAAA4t297zHVNXFSd6U5OQkb+vunzrAMT+f5FuTPJDke7v746s9F1Y6yvW2M8meJA8n\n", "2dvdF85obNaoQ623qvrqJG9P8oIkP9bdP7vac2F/R7nedsbrG4dpFWvuO5P8h+z7BvT7kvzb7v6z\n", "1ZwL+zvK9bYzq3yNW8grTVV1cpJfSHJxkk1JXl5Vz9nvmJcl+aru3pDkXyV5y2rPhZWOZr1NLCd5\n", "UXe/wP9QcCirfI36fJLXJPmZIzgXHnM0623C6xuHZZVr7lNJ/kl3Py/Jf0zy1sM4Fx5zNOttYtWv\n", "cQsZTUkuTHJHd+/s7r1J3pnk0v2OuSTJ1iTp7o8keUZVnbHKc2GlI11v61c874uWWa1Drrfu/lx3\n", "fyzJ3sM9F/ZzNOvtUV7fOByrWXMf7u57Jw8/kuSc1Z4L+zma9faoVb3GLWo0nZ3k0yse75rsW80x\n", "Z63iXFjpaNZbsu9vKd5fVR+rqu+f2pQcL1az3qZxLiemo10zXt84XIe75l6Z5PeO8Fw4mvWWHMZr\n", "3KJG02q/PMrffnEsHO16+6bufkH2fd7p1VX1zcdmLI5TR/PleL5Yj8N1tGvmG72+cZhWveaq6sVJ\n", "rk7yusM9FyaOZr0lh/Eat6jRdGeSc1c8Pjf7ynF0zDmTY1ZzLqx0pOvtziTp7s9Mfv1ckndn36Vi\n", "OJijeY3y+sbhOqo1092fnfzq9Y3VWtWaq6rnJfnlJJd09xcP51xY4WjW22G9xi3q3fM+lmRDVZ2f\n", "5DNJrkjy8v2OuTnJDyR5Z1V9fZJ7unt3VX1+FefCSkez3k5NcnJ331dVT03yLUl+cnajswatZr09\n", "av+rm4dzLiRHsd68vnGEDrnmqurvJ3lXku/q7jsO51zYzxGvt8N9jTtpeXkxr4RW1bfm724f+Cvd\n", "/Yaq+tdJ0t2/NDnm0btlfCnJ93X3Hx/s3Dn8K7CGHOl6q6qvzL4/iMm+v4T4deuNQznUepvc1Oaj\n", "Sb4iySPZd4vUTd19v9c3DteRrrckp8frG0dgFWvubUm+PcnfTE557FbPXuM4XEe63g73/+EWNpoA\n", "AAAWwaJ+pgkAAGAhiCYAAIAB0QQAADAgmgAAAAZEEwAAwIBoAgAAGBBNAAAAA/8PpsFEcPB1IGoA\n", "AAAASUVORK5CYII=\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "ETFs.Div_Yield.plot(kind='hist', bins=20)" ] }, { "cell_type": "code", "execution_count": 205, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 205, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": [ "iVBORw0KGgoAAAANSUhEUgAAA1gAAAHiCAYAAAD1UW2SAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n", "AAALEgAACxIB0t1+/AAAHotJREFUeJzt3X2QZXdd5/HPkBhIIBtkKZKQZEliJV8JNawwbkBd1ocN\n", "WxElYdctEiwwmhT/BHlwS0qCq+VW7UZwRdFyg4U8GKLGRMQQyweSxS0W19VAgzgy8JVABjOjmVhk\n", "Eh4ikkl6/7hn1mZMJk3md+/t7rxe/8w5555772/ur7tn3n3OPXfb6upqAAAAOHKPWfYAAAAAtgqB\n", "BQAAMIjAAgAAGERgAQAADCKwAAAABhFYAAAAgxw9rweuqnck+Z4kd3b39mnbk5Jcl+RpSXYneXF3\n", "3z3ddkWSS5Pcn+RV3X3TtH1Hkl9N8rgkv9/dr57XmAEAAI7EPI9gvTPJ+Ydse12Sm7v77CTvn9ZT\n", "VeckuSjJOdN9rqqqbdN93pLksu4+K8lZVXXoYwIAAGwIcwus7v5gkv2HbL4gydXT8tVJXjQtX5jk\n", "2u6+r7t3J7k1yXOq6uQkx3f3LdN+71pzHwAAgA1l0e/BOrG7903L+5KcOC0/NcmeNfvtSXLKg2zf\n", "O20HAADYcOb2HqyH092rVbU6j8deWVmZy+MCAABbx44dO7Y9/F5fm0UH1r6qOqm775hO/7tz2r43\n", "yWlr9js1syNXe6fltdv3rueJduzYMWC4PFIrKyvmYAMwDxuDeVg+c7AxmIeNwTwsnznYGFZWVuby\n", "uIs+RfDGJJdMy5ckuWHN9our6piqOiPJWUlu6e47kny+qp4zXfTiZWvuAwAAsKHM8zLt1yb59iRP\n", "rqrbk/xkkjckub6qLst0mfYk6e5dVXV9kl1JDiS5vLsPnuZ3eWaXaT82s8u0/+G8xgwAAHAk5hZY\n", "3f2Sh7jpvIfY/8okVz7I9pUk2wcODQAAYC4WfYogAADAliWwAAAABhFYAAAAgwgsAACAQQQWAADA\n", "IAILAABgEIEFAAAwiMACAAAYRGABAAAMIrAAAAAGEVgAAACDCCwAAIBBBBYAAMAgAgsAAGAQgQUA\n", "ADCIwAIAABhEYAEAAAwisAAAAAYRWAAAAIMILAAAgEEEFgAAwCACCwAAYBCBBQAAMIjAAgAAGERg\n", "AQAADCKwAAAABhFYAAAAgwgsAACAQQQWAADAIAILAABgEIEFAAAwiMACAAAY5OhlD2BeXvmff+kR\n", "3/fvv/T5/NcfuzQnnXTSwBEBAABb3ZYNrN1/f9ojvu+X7r49995778DRAAAAjwZOEQQAABhEYAEA\n", "AAwisAAAAAYRWAAAAIMILAAAgEEEFgAAwCACCwAAYBCBBQAAMIjAAgAAGERgAQAADCKwAAAABhFY\n", "AAAAgwgsAACAQQQWAADAIAILAABgEIEFAAAwiMACAAAYRGABAAAMIrAAAAAGEVgAAACDCCwAAIBB\n", "BBYAAMAgAgsAAGAQgQUAADCIwAIAABhEYAEAAAwisAAAAAYRWAAAAIMILAAAgEEEFgAAwCACCwAA\n", "YBCBBQAAMIjAAgAAGERgAQAADCKwAAAABhFYAAAAgwgsAACAQQQWAADAIAILAABgEIEFAAAwiMAC\n", "AAAYRGABAAAMIrAAAAAGEVgAAACDCCwAAIBBBBYAAMAgRy/jSavqiiQvTfJAkp1JfijJ45Ncl+Rp\n", "SXYneXF3371m/0uT3J/kVd190xKGDQAAcFgLP4JVVacneXmSZ3f39iRHJbk4yeuS3NzdZyd5/7Se\n", "qjonyUVJzklyfpKrqsqRNwAAYMNZRqh8Psl9SY6rqqOTHJfkb5JckOTqaZ+rk7xoWr4wybXdfV93\n", "705ya5JzFzpiAACAdVh4YHX3XUnelOSvMwuru7v75iQndve+abd9SU6clp+aZM+ah9iT5JQFDRcA\n", "AGDdlnGK4DckeU2S0zOLpydU1UvX7tPdq0lWD/Mwh7sNAABgKZZxkYtvTvIn3f25JKmq9yT5liR3\n", "VNVJ3X1HVZ2c5M5p/71JTltz/1OnbXOzurqanTt3Zv/+/fN8mi1vZWVl2UMg5mGjMA/LZw42BvOw\n", "MZiH5TMHW9cyAuuTSX6iqo5N8uUk5yW5JcmXklyS5I3TnzdM+9+Y5Deq6ucyOzXwrGn/udm2bVu2\n", "b9+eM888c55Ps6WtrKxkx44dyx7Go5552BjMw/KZg43BPGwM5mH5zMHGMK/IXcZ7sD6W5F1JPpzk\n", "L6bNb03yhiTPr6q/SvJd03q6e1eS65PsSvIHSS6fTiEEAADYUJbyOVjd/TNJfuaQzXdldjTrwfa/\n", "MsmV8x4XAADAkfB5UgAAAIMILAAAgEEEFgAAwCACCwAAYBCBBQAAMIjAAgAAGERgAQAADCKwAAAA\n", "BhFYAAAAgwgsAACAQQQWAADAIAILAABgEIEFAAAwiMACAAAYRGABAAAMIrAAAAAGEVgAAACDCCwA\n", "AIBBBBYAAMAgAgsAAGAQgQUAADCIwAIAABhEYAEAAAwisAAAAAYRWAAAAIMILAAAgEEEFgAAwCAC\n", "CwAAYBCBBQAAMIjAAgAAGERgAQAADCKwAAAABhFYAAAAgwgsAACAQQQWAADAIAILAABgEIEFAAAw\n", "iMACAAAYRGABAAAMIrAAAAAGEVgAAACDCCwAAIBBBBYAAMAgAgsAAGAQgQUAADCIwAIAABhEYAEA\n", "AAwisAAAAAYRWAAAAIMILAAAgEEEFgAAwCACCwAAYBCBBQAAMIjAAgAAGERgAQAADCKwAAAABhFY\n", "AAAAgwgsAACAQQQWAADAIAILAABgEIEFAAAwiMACAAAYRGABAAAMIrAAAAAGEVgAAACDCCwAAIBB\n", "BBYAAMAgAgsAAGAQgQUAADCIwAIAABhEYAEAAAwisAAAAAYRWAAAAIMILAAAgEEEFgAAwCACCwAA\n", "YBCBBQAAMIjAAgAAGERgAQAADCKwAAAABhFYAAAAgxy9jCetqicmeVuSZyRZTfJDST6V5LokT0uy\n", "O8mLu/vuaf8rklya5P4kr+rum5YwbAAAgMNa1hGsX0jy+9399CTPTPLJJK9LcnN3n53k/dN6quqc\n", "JBclOSfJ+UmuqipH3gAAgA1n4aFSVSckeV53vyNJuvtAd9+T5IIkV0+7XZ3kRdPyhUmu7e77unt3\n", "kluTnLvYUQMAADy8ZZwieEaSv6uqdyb5l0lWkrwmyYndvW/aZ1+SE6flpyb50zX335PklAWNFQAA\n", "YN2WEVhHJ3l2kh/u7g9V1ZsznQ54UHevVtXqYR7jcLcdsdXV1ezcuTP79++f59NseSsrK8seAjEP\n", "G4V5WD5zsDGYh43BPCyfOdi6lhFYe5Ls6e4PTevvTnJFkjuq6qTuvqOqTk5y53T73iSnrbn/qdO2\n", "udm2bVu2b9+eM888c55Ps6WtrKxkx44dyx7Go5552BjMw/KZg43BPGwM5mH5zMHGMK/IXfh7sLr7\n", "jiS3V9XZ06bzknw8ye8muWTadkmSG6blG5NcXFXHVNUZSc5KcssChwwAALAuS7lMe5JXJvn1qjom\n", "yaczu0z7UUmur6rLMl2mPUm6e1dVXZ9kV5IDSS7v7rmeIggAAPBILCWwuvtjSf7Vg9x03kPsf2WS\n", "K+c6KAAAgCPk86QAAAAGEVgAAACDCCwAAIBBBBYAAMAgAgsAAGAQgQUAADCIwAIAABhEYAEAAAwi\n", "sAAAAAYRWAAAAIMILAAAgEEEFgAAwCACCwAAYBCBBQAAMIjAAgAAGERgAQAADCKwAAAABhFYAAAA\n", "gwgsAACAQQQWAADAIAILAABgEIEFAAAwiMACAAAY5OiH26GqTkzypiRP6+7nVdUzk3xrd//y3EcH\n", "AACwiaznCNavJPk/SZ44rXeSV8xtRAAAAJvUegLrlO5+S5IDSdLd/5DkgbmOCgAAYBNaT2AdqKpt\n", "B1eq6omH2xkAAODRaj2B9Z4kv5zkn1XVDya5Ock75zkoAACAzehhA6u735jkg0lWkrwgyS9095vn\n", "PTAAAIDN5mGvIpgk3f1rSX5tzmMBAADY1B72CFZVnV1Vf1xVu6f1Z1fVT815XAAAAJvOet6D9ZYk\n", "/y3J3dP6x5K8eG4jAgAA2KTWE1gndPcfJFlNku6+P8lX5joqAACATWi9l2k/5uBKVZ2S5P75DQkA\n", "AGBzWu8pgu9J8uSq+i9J/jjJm+Y6KgAAgE3oYa8i2N1XV9VnkrwwybFJfqC7Pzj3kQEAAGwyhw2s\n", "qjo6yS3d/ezMPgsLAACAh3DYUwS7+0CSL1bVsQsaDwAAwKa1ng8a/qskH6iqdyf50rRttbuvmt+w\n", "AAAANp/1BNbRSXYlefqcxwIAALCpreciFz+4gHEAAABseg8bWFX1ikwfMrzGPZld/OJTcxkVAADA\n", "JrSez8E6P8lPJzkvyfOTXJnkkiR/VFWXzXFsAAAAm8p6AuuBJNu7+z90979Psj3JPyQ5N8l/mufg\n", "AAAANpP1BNY3dPdfH1zp7tuTnNHdf5vkvrmNDAAAYJNZz1UE91XV65O8M8m2zE4PvLOqjso/fW8W\n", "AADAo9Z6jmD9QJIdSf4yyc4k3zxt+7rpTwAAALK+y7TvTfJ9D3HzzrHDAQAA2LzWc5n2xye5IsmZ\n", "3f39VfWNSb6xu2+Y++gAAAA2kfWcIviWzE4H/KZpfW+Sn5rXgAAAADar9QTWM7v7xzK7NHu6+wuZ\n", "XewCAACANdYTWP+wdqWqHrfO+wEAADyqrCeU/ndV/XiSx1XVdyT5rSTvneuoAAAANqH1BNbrpz8/\n", "n+RnkvxZvAcLAADgnzjsVQSr6twkP5rkGdOmv0zyvu4+MO+BAQAAbDYPeQSrqr4lyfuSfDrJjyf5\n", "iSSfSXJTVT13McMDAADYPA53BOvHklza3b+zZtt7qupPk7wuyYvmOjIAAIBN5nDvwXrGIXGVJOnu\n", "9+YfTxkEAABgcrjA+tIjvA0AAOBR6XCnCD62qs55kO3bkjx2TuMBAADYtA4XWMcm+b1FDQQAAGCz\n", "e8jA6u7TFzgOAACATW89HzQMAADAOggsAACAQQQWAADAIAILAABgEIEFAAAwiMACAAAYRGABAAAM\n", "IrAAAAAGEVgAAACDCCwAAIBBBBYAAMAgAgsAAGAQgQUAADCIwAIAABhEYAEAAAwisAAAAAYRWAAA\n", "AIMILAAAgEGOXtYTV9VRST6cZE93v7CqnpTkuiRPS7I7yYu7++5p3yuSXJrk/iSv6u6bljNqAACA\n", "h7bMI1ivTrIryeq0/rokN3f32UneP62nqs5JclGSc5Kcn+SqqnLkDQAA2HCWEipVdWqSFyR5W5Jt\n", "0+YLklw9LV+d5EXT8oVJru3u+7p7d5Jbk5y7uNECAACsz7KOBP18ktcmeWDNthO7e9+0vC/JidPy\n", "U5PsWbPfniSnzH2EAAAAX6OFvwerqr43yZ3d/dGq+o4H26e7V6tq9cFumxzutiO2urqanTt3Zv/+\n", "/fN8mi1vZWVl2UMg5mGjMA/LZw42BvOwMZiH5TMHW9cyLnLxrUkuqKoXJHlckn9WVdck2VdVJ3X3\n", "HVV1cpI7p/33Jjltzf1PnbbNzbZt27J9+/aceeaZ83yaLW1lZSU7duxY9jAe9czDxmAels8cbAzm\n", "YWMwD8tnDjaGeUXuwk8R7O7Xd/dp3X1GkouT/FF3vyzJjUkumXa7JMkN0/KNSS6uqmOq6owkZyW5\n", "ZdHjBgAAeDgb4Wp8B0/3e0OS51fVXyX5rmk93b0ryfWZXXHwD5Jc3t1zPUUQAADgkVja52AlSXd/\n", "IMkHpuW7kpz3EPtdmeTKBQ4NAADga7YRjmABAABsCQILAABgEIEFAAAwiMACAAAYRGABAAAMIrAA\n", "AAAGEVgAAACDCCwAAIBBBBYAAMAgAgsAAGAQgQUAADCIwAIAABhEYAEAAAwisAAAAAYRWAAAAIMI\n", "LAAAgEEEFgAAwCACCwAAYBCBBQAAMIjAAgAAGERgAQAADCKwAAAABhFYAAAAgwgsAACAQQQWAADA\n", "IAILAABgEIEFAAAwiMACAAAYRGABAAAMIrAAAAAGEVgAAACDCCwAAIBBBBYAAMAgAgsAAGAQgQUA\n", "ADCIwAIAABhEYAEAAAwisAAAAAYRWAAAAIMILAAAgEEEFgAAwCACCwAAYBCBBQAAMIjAAgAAGERg\n", "AQAADCKwAAAABhFYAAAAgwgsAACAQQQWAADAIAILAABgEIEFAAAwiMACAAAYRGABAAAMIrAAAAAG\n", "EVgAAACDCCwAAIBBBBYAAMAgAgsAAGAQgQUAADCIwAIAABhEYAEAAAwisAAAAAYRWAAAAIMILAAA\n", "gEEEFgAAwCACCwAAYBCBBQAAMIjAAgAAGERgAQAADCKwAAAABhFYAAAAgwgsAACAQQQWAADAIAIL\n", "AABgEIEFAAAwiMACAAAYRGABAAAMIrAAAAAGEVgAAACDCCwAAIBBjl70E1bVaUneleQpSVaTvLW7\n", "f7GqnpTkuiRPS7I7yYu7++7pPlckuTTJ/Ule1d03LXrcAAAAD2cZR7DuS/Ij3f2MJM9N8oqqenqS\n", "1yW5ubvPTvL+aT1VdU6Si5Kck+T8JFdVlSNvAADAhrPwUOnuO7r7z6flLyb5RJJTklyQ5Oppt6uT\n", "vGhavjDJtd19X3fvTnJrknMXOmgAAIB1WOqRoKo6PcmzkvxZkhO7e990074kJ07LT02yZ83d9mQW\n", "ZAAAABvK0gKrqp6Q5LeTvLq7v7D2tu5ezez9WQ/lcLcBAAAsxcIvcpEkVfV1mcXVNd19w7R5X1Wd\n", "1N13VNXJSe6ctu9Nctqau586bZub1dXV7Ny5M/v375/n02x5Kysryx4CMQ8bhXlYPnOwMZiHjcE8\n", "LJ852LqWcRXBbUnenmRXd795zU03JrkkyRunP29Ys/03qurnMjs18Kwkt8xzjNu2bcv27dtz5pln\n", "zvNptrSVlZXs2LFj2cN41DMPG4N5WD5zsDGYh43BPCyfOdgY5hW5yziC9W1JXprkL6rqo9O2K5K8\n", "Icn1VXVZpsu0J0l376qq65PsSnIgyeXTKYQAAAAbysIDq7v/OA/93q/zHuI+Vya5cm6DAgAAGMDn\n", "SQEAAAwisAAAAAYRWAAAAIMILAAAgEEEFgAAwCACCwAAYBCBBQAAMIjAAgAAGERgAQAADCKwAAAA\n", "BhFYAAAAgwgsAACAQQQWAADAIAILAABgEIEFAAAwiMACAAAYRGABAAAMIrAAAAAGEVgAAACDCCwA\n", "AIBBBBYAAMAgAgsAAGAQgQUAADCIwAIAABhEYAEAAAwisAAAAAYRWAAAAIMILAAAgEEEFgAAwCAC\n", "CwAAYBCBBQAAMIjAAgAAGERgAQAADCKwAAAABhFYAAAAgwgsAACAQQQWAADAIAILAABgEIEFAAAw\n", "iMACAAAYRGABAAAMIrAAAAAGEVgAAACDCCwAAIBBBBYAAMAgAgsAAGAQgQUAADCIwAIAABhEYAEA\n", "AAwisAAAAAYRWAAAAIMILAAAgEEEFgAAwCACCwAAYBCBBQAAMIjAAgAAGERgAQAADCKwAAAABhFY\n", "AAAAgwgsAACAQQQWAADAIAILAABgEIEFAAAwiMACAAAYRGABAAAMcvSyB7ARPXD/gdx22205cODA\n", "ET3O6aefnmOOOWbQqAAAgI1OYD2IL3/xrrz+qg/muBOe8ogf49577sw1P/39OfvssweODAAA2MgE\n", "1kM47oSn5Alff8qyhwEAAGwi3oMFAAAwiMACAAAYRGABAAAMIrAAAAAGEVgAAACDCCwAAIBBBBYA\n", "AMAgAgsAAGAQHzQ8Jw/cfyC33XbbET/O6aefnmOOOWbAiAAAgHkTWHPy5S9+Lj/51v+b40749CN+\n", "jHvvuTPX/PT35+yzzx44MgAAYF4E1hwdd8JT8oSvP2XZwwAAABbEe7AAAAAGEVgAAACDbJpTBKvq\n", "/CRvTnJUkrd19xuXPKS5G3GhjK985StJMuRCGS64AQAAh7cpAquqjkryS0nOS7I3yYeq6sbu/sRy\n", "RzZfIy6U8bk9n8ixx//zHHfCU45oLBvlghtf+cpXsnv37iN+HLEIAMA8bIrASnJuklu7e3eSVNVv\n", "JrkwyZYOrOTIL5Rx7z37hlxs42s9mvbZz342xx9//FdtG3E07bbbbpui85EH41aKxYd7TR9sHh7J\n", "46zXkYargP5qo16PjTK/bG3r+Xpdz88kX2dsFkfyM3rt94Kv+a1nswTWKUluX7O+J8lzDneHbfd8\n", "/BE/2WPuvT33bjuyt6f9/RfuSrJtSzxGkuz/20/ltT/7yTzuCU/6Gu71ka9au2ffZ/LYxz/xa3yM\n", "r3bPvs/kiScfeRiN+IyyEWN47c++94hfj4d/TT9ymNu+lsc5vC9/8a789x+9MGecccYjfowRr8mI\n", "cYy23tA91IjXI9k487tMj3QOWL/1f70+9M+kzf51tln4fhjjyH9GfyRf/uJdeff/eM3Sf+nLWNtW\n", "V1eXPYaHVVXfl+T87n75tP7SJM/p7lc+2P4rKysb/y8FAAAs1Y4dO478SMQhNssRrL1JTluzflpm\n", "R7Ee1DxeKAAAgIezWQLrw0nOqqrTk/xNkouSvGSpIwIAADjEpvgcrO4+kOSHk7wvya4k1231KwgC\n", "AACbz6Z4DxYAAMBmsCmOYAEAAGwGAgsAAGAQgQUAADDIZrmK4LpU1flJ3pzkqCRv6+43LnlIm1pV\n", "vSPJ9yS5s7u3T9uelOS6JE9LsjvJi7v77um2K5JcmuT+JK/q7pum7TuS/GqSxyX5/e5+9bT9sUne\n", "leTZST6X5KLu/uyi/n6bRVWdltnr9JQkq0ne2t2/aC4Wq6oel+QDSR6b5Jgk7+3uK8zD4lXVUZld\n", "XXZPd7/QHCxeVe1O8vnMXtf7uvtc87B4VfXEJG9L8ozM/n34oSSfinlYiKqqJL+5ZtOZSX4iya/F\n", "HCzU9Lq+NMkDSXZm9r3w+CxpHrbMEazpH9xfSnJ+knOSvKSqnr7cUW1678zs9VzrdUlu7u6zk7x/\n", "Wk9VnZPZ5fPPme5zVVUd/DyytyS5rLvPyuxy+wcf87Ikn5u2/3wSQfzg7kvyI939jCTPTfKK6Wvb\n", "XCxQd385yXd29zcleWaS76yqfx3zsAyvzuyKsgev0mQOFm81yXd097O6+9xpm3lYvF/I7D+BT8/s\n", "59InYx4Wpmee1d3PSrIjyb1JfifmYKGmj3F6eZJnTwcEjkpycZY4D1smsJKcm+TW7t7d3fdl9huF\n", "C5c8pk2tuz+YZP8hmy9IcvW0fHWSF03LFya5trvv6+7dSW5N8pyqOjnJ8d19y7Tfu9bcZ+1j/XaS\n", "fzv8L7EFdPcd3f3n0/IXk3wiySkxFwvX3fdOi8dk9gN8f8zDQlXVqUlekNlv7Q/+g2gOlmPbIevm\n", "YYGq6oQkz+vudySzj7Tp7ntiHpblvMz+H3p7zMGifT6zX0YfV1VHJzkus8/NXdo8bKXAOiXJ7WvW\n", "90zbGOvE7t43Le9LcuK0/NTMXvODDr7+h27fm3+cl/8/Z9Nnnd0znWLCQ5h+S/OsJH8Wc7FwVfWY\n", "qvrzzF7v/9XdH495WLSfT/LazE4DOcgcLN5qkv9ZVR+uqpdP28zDYp2R5O+q6p1V9ZGq+pWqenzM\n", "w7JcnOTaadkcLFB335XkTUn+OrOwuru7b84S52ErBZYP9Fqw7l6N131hquoJmf3W5NXd/YW1t5mL\n", "xejuB6ZTBE9N8m+q6jsPud08zFFVfW9m7wn9aP7p0ZMk5mCBvm06Leq7Mztt+XlrbzQPC3F0Zu8H\n", "uaq7n53kS5lOgTrIPCxGVR2T5IVJfuvQ28zB/FXVNyR5TZLTM4ukJ1TVS9fus+h52EqBtTfJaWvW\n", "T8tXVyhj7Kuqk5JkOpR657T90Nf/1Mxe/73T8qHbD97nX0yPdXSSE6bfQnCIqvq6zOLqmu6+Ydps\n", "LpZkOg3n9zI75948LM63Jrmgqm7L7DfF31VV18QcLFx3/+30599l9p6Tc2MeFm1PZhd6+dC0/u7M\n", "gusO87Bw351kZfp+SHwvLNo3J/mT7v7cdHTpPUm+JUv8XthKgfXhzN6Mdvr0m4SLkty45DFtRTcm\n", "uWRaviTJDWu2X1xVx1TVGUnOSnJLd9+R5PNV9ZzpDYQvS/LeB3ms/5jZGxA5xPS6vT3Jru5+85qb\n", "zMUCVdWTpyt2paqOTfL8JB+NeViY7n59d5/W3WdkdjrOH3X3y2IOFqqqjquq46flxyf5d5ldtcs8\n", "LND0+t1eVWdPm85L8vEkvxvzsGgvyT+eHpj4Xli0TyZ5blUdO71+52V2IaSlfS9smcu0d/eBqvrh\n", "JO/L7M3nb+/uTyx5WJtaVV2b5NuTPLmqbk/yk0nekOT6qros0yUvk6S7d1XV9Zl9QR9Icvl0ODZJ\n", "Ls/skpfHZna1oz+ctr89yTVV9anMLnl58SL+XpvQt2V26dG/qKqPTtuuiLlYtJOTXF1Vj8nsl1PX\n", "dPf7pzkxD8tx8PX0vbBYJyb5napKZv+P+PXuvqmqPhzzsGivTPLr0y+WP53ZpamPinlYmOmXDOdl\n", "dhW7g/xMWqDu/lhVvSuzgy0PJPlIkrcmOT5Lmodtq6tOCwUAABhhK50iCAAAsFQCCwAAYBCBBQAA\n", "MIjAAgAAGERgAQAADCKwAAAABhFYAAAAg/w/VsBKp2oQeIMAAAAASUVORK5CYII=\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "ETFs.Market_Cap.plot(kind='hist',bins=40)" ] }, { "cell_type": "code", "execution_count": 221, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Equity 725\n", "Bond 106\n", "Commodity 100\n", "Currency 35\n", "Real Estate 28\n", "Multi-Asset 26\n", "dtype: int64" ] }, "execution_count": 221, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ETFs.Asset.value_counts()" ] }, { "cell_type": "code", "execution_count": 220, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Large-Cap 205\n", "Small-Cap 79\n", "Mid-Cap 53\n", "Multi-Cap 24\n", "dtype: int64" ] }, "execution_count": 220, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ETFs.Size.value_counts()" ] }, { "cell_type": "code", "execution_count": 219, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Blend 177\n", "Value 85\n", "Growth 59\n", "dtype: int64" ] }, "execution_count": 219, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ETFs.Style.value_counts()" ] }, { "cell_type": "code", "execution_count": 209, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "" ] }, "execution_count": 209, "metadata": {}, "output_type": "execute_result" }, { "data": { "image/png": [ "iVBORw0KGgoAAAANSUhEUgAAA0YAAAHiCAYAAADMNtzJAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\n", "AAALEgAACxIB0t1+/AAAHdZJREFUeJzt3X+w5Xdd3/FXSFwg5rKANEt+7CSpk/uWsCKyGq0/RqCh\n", "TVETnE4JMmIwTP8QLNSZMmahRZ2OAWytaB1wKMhELJHUHyEGKYk4InQQ5ArKuvDG4N5bNrIbBRIX\n", "U8yv7R/3pF0he/duds8999zP4/HPfs853++97/CZvdznfr/ne047cuRIAAAARvaoWQ8AAAAwa8II\n", "AAAYnjACAACGJ4wAAIDhCSMAAGB4wggAABjeGdP+BlX1+CRvSfLUJEeS/EiSv0jyziQXJFlO8vzu\n", "vmuy/54k1yR5IMnLu/vWac8IAACMbSPOGP1Ckt/t7qckeVqSTyW5Nslt3b2Y5H2Tx6mqS5JcleSS\n", "JJcneWNVOasFAABM1VSjo6q2J/nu7v6VJOnu+7v77iRXJLl+stv1SZ432b4yyQ3dfV93Lye5Pcml\n", "05wRAABg2pfSXZTkr6vqbUm+KclSkn+bZEd3H5rscyjJjsn2uUn+6KjjDyQ5b8ozAgAAg5t2GJ2R\n", "5BlJfqy7/7iq3pDJZXMP6e4jVXVkja9xzNeWlpbWOg4AACC7d+8+7Xj7TDuMDiQ50N1/PHn8G0n2\n", "JDlYVU/u7oNVdU6SOyev35Fk51HHnz957ph27959ikdmoywtLVm/OWXt5pv1m2/Wb35Zu/lm/ebX\n", "0tLSuvab6nuMuvtgks9W1eLkqcuS/HmS30ly9eS5q5PcNNm+OckLqmpbVV2U5OIkH5nmjAAAAFO/\n", "XXeSf5Pkv1fVtiSfyertuk9PcmNVvSST23UnSXfvq6obk+xLcn+Sl3a3y+UAAICpmnoYdfefJvnW\n", "h3npsmPsf12S66Y6FAAAwFF8RhAAADA8YQQAAAxPGAEAAMMTRgAAwPCEEQAAMDxhBAAADE8YAQAA\n", "wxNGAADA8IQRAAAwPGEEAAAMTxgBAADDE0YAAMDwhBEAADA8YQQAAAxPGAEAAMMTRgAAwPCEEQAA\n", "MDxhBAAADE8YAQAAwxNGAADA8IQRAAAwPGEEAAAMTxgBAADDE0YAAMDwhBEAADA8YQQAAAxPGAEA\n", "AMMTRgAAwPCEEQAAMDxhBAAADE8YAQAAwxNGAADA8IQRAAAwPGEEAAAMTxgBAADDE0YAAMDwhBEA\n", "ADA8YQQAAAxPGAEAAMMTRgAAwPCEEQAAMDxhBAAADE8YAQAAwxNGAADA8IQRAAAwPGEEAAAMTxgB\n", "AADDE0YAAMDwhBEAADA8YQQAAAxPGAEAAMMTRgAAwPCEEQAAMDxhBAAADE8YAQAAwxNGAADA8IQR\n", "AAAwPGEEAAAMTxgBAADDO2PWAwDAqXLvvfdmeXl51mNM1crKShYWFmY9xpouvPDCbNu2bdZjAJwQ\n", "YQTAlrG8vJwX7XlHztx+9qxHma5bDs56gmO65+478/bXvjCLi4uzHgXghAgjALaUM7efnbOecN6s\n", "xwBgzniPEQAAMDxhBAAADE8YAQAAwxNGAADA8KZ+84WqWk7yt0keSHJfd19aVU9M8s4kFyRZTvL8\n", "7r5rsv+eJNdM9n95d9867RkBAICxbcQZoyNJntnd39zdl06euzbJbd29mOR9k8epqkuSXJXkkiSX\n", "J3ljVTmrBQAATNVGRcdpX/H4iiTXT7avT/K8yfaVSW7o7vu6eznJ7UkuDQAAwBRt1Bmj36uqj1bV\n", "v548t6O7D022DyXZMdk+N8mBo449kMSHUQAAAFO1ER/w+p3d/bmq+kdJbquqTx39Yncfqaojaxy/\n", "1mtZWlo6FTMyI9Zvflm7+bZV129lZWXWI5Bk7969OXz48KzH2JS26t+9UVi/rW3qYdTdn5v8+ddV\n", "9dtZvTTuUFU9ubsPVtU5Se6c7H5Hkp1HHX7+5Llj2r179xSmZiMsLS1Zvzll7ebbVl6/hYWF5JaD\n", "sx5jeLt27cri4uKsx9h0tvLfvRFYv/m13qCd6qV0VXVmVS1Mtr82yT9L8okkNye5erLb1Ulummzf\n", "nOQFVbWtqi5KcnGSj0xzRgAAgGm/x2hHkg9U1ceTfDjJLZPbb78uyXOq6tNJnj15nO7el+TGJPuS\n", "vCfJS7t7zUvpAAAATtZUL6Xr7v1Jnv4wz38hyWXHOOa6JNdNcy4AAICj+YwgAABgeMIIAAAYnjAC\n", "AACGJ4wAAIDhCSMAAGB4wggAABieMAIAAIYnjAAAgOEJIwAAYHjCCAAAGJ4wAgAAhieMAACA4Qkj\n", "AABgeMIIAAAYnjACAACGJ4wAAIDhCSMAAGB4wggAABieMAIAAIYnjAAAgOEJIwAAYHjCCAAAGJ4w\n", "AgAAhieMAACA4QkjAABgeMIIAAAYnjACAACGJ4wAAIDhCSMAAGB4wggAABieMAIAAIYnjAAAgOEJ\n", "IwAAYHjCCAAAGJ4wAgAAhieMAACA4QkjAABgeMIIAAAYnjACAACGJ4wAAIDhCSMAAGB4wggAABie\n", "MAIAAIYnjAAAgOEJIwAAYHjCCAAAGJ4wAgAAhieMAACA4QkjAABgeMIIAAAYnjACAACGJ4wAAIDh\n", "CSMAAGB4wggAABieMAIAAIYnjAAAgOEJIwAAYHjCCAAAGJ4wAgAAhieMAACA4QkjAABgeMIIAAAY\n", "njACAACGJ4wAAIDhCSMAAGB4Z0z7G1TV6Uk+muRAd39/VT0xyTuTXJBkOcnzu/uuyb57klyT5IEk\n", "L+/uW6c9HwAAwEacMXpFkn1JjkweX5vktu5eTPK+yeNU1SVJrkpySZLLk7yxqpzRAgAApm6q4VFV\n", "5yd5bpK3JDlt8vQVSa6fbF+f5HmT7SuT3NDd93X3cpLbk1w6zfkAAACS6Z8x+vkkr0zy4FHP7eju\n", "Q5PtQ0l2TLbPTXLgqP0OJDlvyvMBAABM7z1GVfV9Se7s7o9V1TMfbp/uPlJVRx7utYm1XkuSLC0t\n", "PcIJ2Qys3/yydvNtq67fysrKrEcgyd69e3P48OFZj7EpbdW/e6OwflvbNG++8B1Jrqiq5yZ5TJLH\n", "VdXbkxyqqid398GqOifJnZP970iy86jjz588t6bdu3ef4rHZKEtLS9ZvTlm7+baV129hYSG55eCs\n", "xxjerl27sri4OOsxNp2t/HdvBNZvfq03aKd2KV13v6q7d3b3RUlekOT3u/tFSW5OcvVkt6uT3DTZ\n", "vjnJC6pqW1VdlOTiJB+Z1nwAAAAP2ci7vj10Wdzrkjynqj6d5NmTx+nufUluzOod7N6T5KXdfdxL\n", "6QAAAE7W1D/HKEm6+/1J3j/Z/kKSy46x33VJrtuImQAAAB7ic4IAAIDhCSMAAGB4wggAABieMAIA\n", "AIYnjAAAgOEJIwAAYHjCCAAAGJ4wAgAAhieMAACA4QkjAABgeMIIAAAYnjACAACGJ4wAAIDhCSMA\n", "AGB4wggAABieMAIAAIYnjAAAgOEJIwAAYHjCCAAAGJ4wAgAAhieMAACA4QkjAABgeMIIAAAYnjAC\n", "AACGJ4wAAIDhCSMAAGB4wggAABieMAIAAIYnjAAAgOEJIwAAYHjCCAAAGJ4wAgAAhieMAACA4Qkj\n", "AABgeMIIAAAYnjACAACGJ4wAAIDhnTHrAQC2gnvvvTfLy8uzHmNdVlZWsrCwMOsxpmL//v2zHgGA\n", "OSWMAE6B5eXlvGjPO3Lm9rNnPcr63HJw1hNMxecPfDJfd/5TZj0GAHNIGAGcImduPztnPeG8WY8x\n", "tHvuPjTrEQCYU95jBAAADE8YAQAAwxNGAADA8IQRAAAwPGEEAAAMTxgBAADDE0YAAMDwhBEAADA8\n", "YQQAAAxPGAEAAMMTRgAAwPCEEQAAMDxhBAAADO+M4+1QVTuS/FySC7r7u6vqaUm+o7t/eerTAQAA\n", "bID1nDH6b0n+V5LHTx53kpdNbSIAAIANtp4wOq+735Tk/iTp7r9P8uBUpwIAANhA6wmj+6vqtIce\n", "VNXj19oZAABg3qwnjH4ryS8neVxVvTjJbUneNs2hAAAANtJxw6i7X5/kA0mWkjw3yS909xumPRgA\n", "AMBGOe5d6ZKku38tya9NeRYAAICZOO4Zo6parKoPVtXy5PEzquqnpjwXAADAhlnPe4zelORnktw1\n", "efynSZ4/tYkAAAA22HrCaHt3vyfJkSTp7geS3DvVqQAAADbQem/Xve2hB1V1XpIHpjcSAADAxlrv\n", "pXS/leRJVfXTST6Y5OemOhUAAMAGOu5d6br7+qr6yyTfn+SxSX64uz9wvOOq6jFJ3p/k0Um2JXlX\n", "d++pqicmeWeSC5IsJ3l+d981OWZPkmuyekbq5d196yP6rwIAADgBa4ZRVZ2R5CPd/YysfpbRunX3\n", "l6vqWd19z+TrfLCqvivJFUlu6+6fraqfSHJtkmur6pIkVyW5JMl5SX6vqha7+8FH8N8FAACwbmte\n", "Stfd9yf5UlU99pF88e6+Z7K5LcnpSb6Y1TC6fvL89UmeN9m+MskN3X1fdy8nuT3JpY/k+wIAAJyI\n", "9XzA66eTvL+qfiPJ302eO9LdbzzegVX1qCR/kuTrk7ypu/+8qnZ096HJLoeS7Jhsn5vkj446/EBW\n", "zxwBAABM1XrC6Iwk+5I85US/+OQyuKdX1fYk762qZ33F60eq6sgaX2Kt1wAAAE6J9dx84cUn+026\n", "++6qeneS3UkOVdWTu/tgVZ2T5M7Jbnck2XnUYedPnlvT0tLSyY7HDFm/+WXt/qGVlZVZjwCbxt69\n", "e3P48OFZj7Ep+dk536zf1nbcMKqql+Wrz9zcndWbMvzFGsc9Kcn93X3X5D1Kz0ny00luTnJ1ktdP\n", "/rxpcsjNSd5RVf8lq5fQXZzkI8ebb/fu3cfbhU1qaWnJ+s0pa/fVFhYWklsOznoM2BR27dqVxcXF\n", "WY+x6fjZOd+s3/xab9Cu53OMLk/y2iSXZTVurstq0Px+Vb1kjePOmezz8SQfTvI73f2+JK9L8pyq\n", "+nSSZ08ep7v3Jbkxq5ftvSfJS7vbpXQAAMDUrec9Rg8m+cbu/t9JUlU7k7wxq3eM+70kb324g7r7\n", "E0me8TDPfyGrkfVwx1yX1fACAADYMOs5Y/T1D0VRknT3Z5Nc1N2fS3Lf1CYDAADYIOs5Y3Soql6V\n", "5G1JTsvqZXR3VtXpcdc4AABgC1jPGaMfzurd5PYm+USSb5k89zWTPwEAAObaem7XfUeSf3mMlz9x\n", "ascBAADYeOu5XffXJtmT5B939wur6huSfEN333ScQwEAAObCei6le1NWL5t7+uTxHUl+aloDAQAA\n", "bLT1hNHTuvsnkvx9knT34azehAEAAGBLWE8Y/f3RD6rqMes8DgAAYC6sJ3D+sKpeneQxVfXMJP8j\n", "ybumOhUAAMAGWk8YvWry598m+dkkH473GAEAAFvImnelq6pLk/y7JE+dPLU3yXu7+/5pDwYAALBR\n", "jnnGqKr+SZL3JvlMklcn+Q9J/jLJrVX17RszHgAAwPStdcboJ5Jc092/fdRzv1VVf5Tk2iTPm+pk\n", "AAAAG2St9xg99SuiKEnS3e/K/7+0DgAAYO6tFUZ/9whfAwAAmCtrXUr36Kq65GGePy3Jo6c0DwAA\n", "wIZbK4wem+TdGzUIAADArBwzjLr7wg2cAwAAYGbW8wGvAAAAW5owAgAAhieMAACA4QkjAABgeMII\n", "AAAYnjACAACGJ4wAAIDhCSMAAGB4wggAABieMAIAAIYnjAAAgOEJIwAAYHjCCAAAGJ4wAgAAhieM\n", "AACA4QkjAABgeMIIAAAYnjACAACGJ4wAAIDhCSMAAGB4wggAABieMAIAAIYnjAAAgOEJIwAAYHjC\n", "CAAAGJ4wAgAAhieMAACA4QkjAABgeMIIAAAYnjACAACGJ4wAAIDhCSMAAGB4wggAABieMAIAAIYn\n", "jAAAgOEJIwAAYHjCCAAAGJ4wAgAAhieMAACA4QkjAABgeMIIAAAYnjACAACGJ4wAAIDhCSMAAGB4\n", "wggAABieMAIAAIYnjAAAgOEJIwAAYHhnTPOLV9XOJL+a5OwkR5K8ubt/saqemOSdSS5Ispzk+d19\n", "1+SYPUmuSfJAkpd3963TnBEAAGDaZ4zuS/Lj3f3UJN+e5GVV9ZQk1ya5rbsXk7xv8jhVdUmSq5Jc\n", "kuTyJG+sKme1AACAqZpqdHT3we7++GT7S0k+meS8JFckuX6y2/VJnjfZvjLJDd19X3cvJ7k9yaXT\n", "nBEAAGDDzsZU1YVJvjnJh5Ps6O5Dk5cOJdkx2T43yYGjDjuQ1ZACAACYmqm+x+ghVXVWkt9M8oru\n", "PlxV/++17j5SVUfWOHyt17K0tHRqhmQmrN/8snb/0MrKyqxHgE1j7969OXz48KzH2JT87Jxv1m9r\n", "m3oYVdXXZDWK3t7dN02ePlRVT+7ug1V1TpI7J8/fkWTnUYefP3numHbv3n2qR2aDLC0tWb85Ze2+\n", "2sLCQnLLwVmPAZvCrl27sri4OOsxNh0/O+eb9Ztf6w3aqV5KV1WnJXlrkn3d/YajXro5ydWT7auT\n", "3HTU8y+oqm1VdVGSi5N8ZJozAgAATPuM0Xcm+aEkf1ZVH5s8tyfJ65LcWFUvyeR23UnS3fuq6sYk\n", "+5Lcn+Sl3b3mpXQAAAAna6ph1N0fzLHPSl12jGOuS3Ld1IYCAAD4Cj4jCAAAGJ4wAgAAhieMAACA\n", "4QkjAABgeMIIAAAYnjACAACGJ4wAAIDhCSMAAGB4wggAABieMAIAAIYnjAAAgOEJIwAAYHjCCAAA\n", "GJ4wAgAAhieMAACA4QkjAABgeMIIAAAYnjACAACGJ4wAAIDhCSMAAGB4wggAABieMAIAAIYnjAAA\n", "gOEJIwAAYHjCCAAAGJ4wAgAAhieMAACA4QkjAABgeMIIAAAYnjACAACGJ4wAAIDhCSMAAGB4wggA\n", "ABieMAIAAIYnjAAAgOEJIwAAYHjCCAAAGJ4wAgAAhieMAACA4QkjAABgeMIIAAAYnjACAACGJ4wA\n", "AIDhCSMAAGB4wggAABieMAIAAIYnjAAAgOEJIwAAYHjCCAAAGJ4wAgAAhieMAACA4QkjAABgeMII\n", "AAAYnjACAACGJ4wAAIDhCSMAAGB4wggAABieMAIAAIYnjAAAgOEJIwAAYHjCCAAAGJ4wAgAAhieM\n", "AACA4QkjAABgeMIIAAAY3hnT/OJV9StJvjfJnd39jZPnnpjknUkuSLKc5PndfdfktT1JrknyQJKX\n", "d/et05wPAAAgmf4Zo7clufwrnrs2yW3dvZjkfZPHqapLklyV5JLJMW+sKme0AACAqZtqeHT3B5J8\n", "8SueviLJ9ZPt65M8b7J9ZZIbuvu+7l5OcnuSS6c5HwAAQDKb9xjt6O5Dk+1DSXZMts9NcuCo/Q4k\n", "OW8jBwMAAMY01fcYHU93H6mqI2vsstZrSZKlpaVTOBEbzfrNL2v3D62srMx6BNg09u7dm8OHD896\n", "jE3Jz875Zv22tlmE0aGqenJ3H6yqc5LcOXn+jiQ7j9rv/Mlza9q9e/cURmQjLC0tWb85Ze2+2sLC\n", "QnLLwVmPAZvCrl27sri4OOsxNh0/O+eb9Ztf6w3aWVxKd3OSqyfbVye56ajnX1BV26rqoiQXJ/nI\n", "DOYDAAAGM+3bdd+Q5HuSPKmqPpvkNUlel+TGqnpJJrfrTpLu3ldVNybZl+T+JC/t7uNeSgcAAHCy\n", "phpG3f2Dx3jpsmPsf12S66Y3EQAAwFfzOUEAAMDwhBEAADA8YQQAAAxPGAEAAMMTRgAAwPCEEQAA\n", "MDxhBAAADE8YAQAAwxNGAADA8IQRAAAwPGEEAAAMTxgBAADDE0YAAMDwhBEAADA8YQQAAAxPGAEA\n", "AMMTRgAAwPCEEQAAMDxhBAAADE8YAQAAwxNGAADA8IQRAAAwPGEEAAAMTxgBAADDE0YAAMDwhBEA\n", "ADA8YQQAAAxPGAEAAMMTRgAAwPDOmPUAAMDW8eAD92f//v2zHmNTWllZycLCwoZ9vwsvvDDbtm3b\n", "sO8H804YAQCnzJe/9Pm85s0fypnbPzPrUTanWw5uyLe55+478/bXvjCLi4sb8v1gKxBGAMApdeb2\n", "s3PWE86b9RgAJ8R7jAAAgOEJIwAAYHjCCAAAGJ4wAgAAhieMAACA4QkjAABgeMIIAAAYnjACAACG\n", "J4wAAIDhCSMAAGB4wggAABieMAIAAIYnjAAAgOEJIwAAYHjCCAAAGJ4wAgAAhnfGrAcATs69996b\n", "5eXlDf2eKysrWVhY2NDvudnt379/1iMAACdBGHFSTuaXcr9cnxr79+/Pa978oZy5/eyN/ca3HNzY\n", "77fJff7AJ/N15z9l1mMAAI+QMOKkLC8v50V73vHIfyn3y/VJe+gX8rOecN6sRxnaPXcfmvUIAMBJ\n", "EEactDO3n+2X8hnyCzkAwMlz8wUAAGB4wggAABieMAIAAIYnjAAAgOEJIwAAYHjCCAAAGJ4wAgAA\n", "hieMAACA4QkjAABgeMIIAAAYnjACAACGJ4wAAIDhCSMAAGB4Z8x6AAAATq0HH7g/+/fvn/UYW8rK\n", "ykoWFhZO+LgLL7ww27Ztm8JEnGqbLoyq6vIkb0hyepK3dPfrZzwSAMBc+fKXPp/XvPlDOXP7Z2Y9\n", "ytZyy8ET2v2eu+/M21/7wiwuLk5pIE6lTRVGVXV6kl9KclmSO5L8cVXd3N2fPNYx//61b96o8XgY\n", "f3NwJcl5sx4DAPgKZ24/O2c9wf9Hw3ptqjBKcmmS27t7OUmq6teTXJnkmGH0p3+zY2Mm42Hd81ed\n", "nPhZZQCALc8ljfNls4XReUk+e9TjA0m+ba0DTrv7z6c6EGu7/+8O5ssPKqNZ+j+Hv5DktFmPMTzr\n", "sDlYh9mzBpuDddgcvvi5v8gr//On8piznjjrUYb15S99IW973UvWte9mC6MjJ3rAT/7oP5/GHKyb\n", "//1nb81/O2DDWIfNwTrMnjXYHKzD5mAd5slmC6M7kuw86vHOrJ41eli7d+/2TyEAAMBJ22xh9NEk\n", "F1fVhUn+KslVSX5wphMBAABb3qb6gNfuvj/JjyV5b5J9Sd651h3pAAAAToXTjhw54bf1AAAAbCmb\n", "6owRAADALAgjAABgeMIIAAAY3ma7K90Jq6r/mOSKrH4G0ueTvLi7P7v2UWwGVfWfknxfknuTfCbJ\n", "j3T33bOdivWqqn+V5KeSfEOSb+3uP5ntRBxPVV2e5A1JTk/ylu5+/YxHYp2q6leSfG+SO7v7G2c9\n", "DyemqnYm+dUkZ2f195U3d/cvznYq1qOqHpPk/UkenWRbknd1957ZTsWJqqrTs3r36wPd/f3H2m8r\n", "nDH62e7+pu5+epKbkvzkrAdi3W5N8tTu/qYkn07iB818+USSH0jyh7MehOOb/J/CLyW5PMklSX6w\n", "qp4y26k4AW/L6toxn+5L8uPd/dQk357kZf7+zYfu/nKSZ01+z3xakmdV1XfNeCxO3CuyesfrNe86\n", "N/dh1N2Hj3p4VpK/mdUsnJjuvq27H5w8/HCS82c5Dyemuz/V3Z+e9Rys26VJbu/u5e6+L8mvJ7ly\n", "xjOxTt39gSRfnPUcPDLdfbC7Pz7Z/lKSTyY5d7ZTsV7dfc9kc1tWz7h/YYbjcIKq6vwkz03yliSn\n", "rbXv3F9KlyRV9TNJXpTknqz+Swzz55okN8x6CNjCzkty9GXGB5J824xmgWFNPsT+m7P6D4LMgap6\n", "VJI/SfL1Sd7U3ftmPBIn5ueTvDLJ446341yEUVXdluTJD/PSq7r7d7r71UleXVXXZvU//kc2dECO\n", "6XhrN9nn1Unu7e53bOhwHNd61o+54UPrYMaq6qwkv5HkFZMzR8yBydUtT6+q7UneW1XP7O4/mPFY\n", "rENVfV9W35v5sap65vH2n4sw6u7nrHPXdyT53WnOwok53tpV1Yuzenrzn27IQJyQE/i7x+Z3R5Kd\n", "Rz3emdWzRsAGqKqvSfKbSX6tu2+a9TycuO6+u6reneRbkvzBjMdhfb4jyRVV9dwkj0nyuKr61e7+\n", "4Yfbee7fY1RVFx/18MokH5vVLJyYyR2yXpnkysmbG5lfa16zy6bw0SQXV9WFVbUtyVVJbp7xTDCE\n", "qjotyVuT7OvuN8x6Htavqp5UVY+fbD82yXPid8250d2v6u6d3X1Rkhck+f1jRVEyJ2eMjuO1VVVJ\n", "HsjqLZ9/dMbzsH7/NatvZLxtdQnzoe5+6WxHYr2q6geS/GKSJyV5d1V9rLv/xYzH4hi6+/6q+rEk\n", "783qm4ff2t2fnPFYrFNV3ZDke5J8XVV9NslruvttMx6L9fvOJD+U5M+q6qFfqvd09/+c4UyszzlJ\n", "rp+8z+hRSd7e3e+b8Uw8cmteVn7akSMuOwcAAMY295fSAQAAnCxhBAAADE8YAQAAwxNGAADA8IQR\n", "AAAwPGEEAAAMTxgBAADD+79lB14xV812IQAAAABJRU5ErkJggg==\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "ETFs.Beta.plot(kind='hist',bins=8)" ] }, { "cell_type": "code", "execution_count": 218, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "U.S. 460\n", "Global/Multi-Region 107\n", "Emerging Markets 28\n", "China 20\n", "Europe 15\n", "Japan 10\n", "Developed Markets 9\n", "Ex-U.S. 9\n", "EAFE 8\n", "Asia 7\n", "India 6\n", "Pacific ex-Japan 6\n", "BRIC 5\n", "Brazil 5\n", "Latin America 5\n", "Canada 3\n", "Euro-Pacific 3\n", "Middle East 3\n", "Mexico 3\n", "South Korea 2\n", "Africa 2\n", "Taiwan 2\n", "Australia 2\n", "Russia 2\n", "Indonesia 2\n", "Middle East/Africa 2\n", "Israel 1\n", "Colombia 1\n", "Austria 1\n", "France 1\n", "Turkey 1\n", "Ireland 1\n", "Italy 1\n", "Switzerland 1\n", "Malaysia 1\n", "United Kingdom 1\n", "Germany 1\n", "Pacific 1\n", "Singapore 1\n", "Chindia 1\n", "Nordic 1\n", "Poland 1\n", "Chile 1\n", "Belgium 1\n", "Thailand 1\n", "Hong Kong 1\n", "Netherlands 1\n", "South Africa 1\n", "Peru 1\n", "North America 1\n", "Sweden 1\n", "Vietnam 1\n", "Spain 1\n", "dtype: int64" ] }, "execution_count": 218, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ETFs.Region.value_counts()" ] }, { "cell_type": "code", "execution_count": 217, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "Energy 45\n", "Technology 41\n", "Financial 41\n", "Industrial 32\n", "Health & Biotech 25\n", "Utilities 17\n", "Retail & Consumer 15\n", "Materials 12\n", "Communications 11\n", "Consumer Staples 6\n", "Consumer Discretionary 6\n", "Transportation 4\n", "Building & Construction 3\n", "Agriculture 3\n", "Aerospace & Defense 2\n", "Environmental 1\n", "dtype: int64" ] }, "execution_count": 217, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ETFs.Sector.value_counts()" ] }, { "cell_type": "code", "execution_count": 216, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "2x 116\n", "3x 44\n", "dtype: int64" ] }, "execution_count": 216, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ETFs.Leveraged.value_counts()" ] }, { "cell_type": "code", "execution_count": 215, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "False 914\n", "True 106\n", "dtype: int64" ] }, "execution_count": 215, "metadata": {}, "output_type": "execute_result" } ], "source": [ "ETFs.Inverse.value_counts()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Places to collect holdings data " ] }, { "cell_type": "code", "execution_count": 213, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# http://www.etfreplay.com/" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# http://etfdb.com/etf/###\n", "# http://finance.yahoo.com/q/hl?s=### ETF holdings" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [ "# https://accounts.profunds.com/etfdata/ByFund/EFAD-psdlyhld.csv\n", "# http://www.ishares.com/us/products/239709/ishares-russell-2000-growth-etf" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 2", "language": "python", "name": "python2" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 2 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython2", "version": "2.7.9" } }, "nbformat": 4, "nbformat_minor": 0 }