Exploring Quandl.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import quandl\n",
    "data = quandl.get(\"FRED/GDP\")\n",
    "\n",
    "# By default, the data is returned as a pandas dataframe.  Quandl can also return data as a numpy array.  \n",
    "# To explicitly specify the data download format, do this:\n",
    "\n",
    "data = quandl.get(\"FRED/GDP\",returns=\"pandas\") \t# pandas data series\n",
    "data = quandl.get(\"FRED/GDP\",returns=\"numpy\")\t\t# numpy array\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Open</th>\n",
       "      <th>High</th>\n",
       "      <th>Low</th>\n",
       "      <th>Close</th>\n",
       "      <th>Volume</th>\n",
       "      <th>Ex-Dividend</th>\n",
       "      <th>Split Ratio</th>\n",
       "      <th>Adj. Open</th>\n",
       "      <th>Adj. High</th>\n",
       "      <th>Adj. Low</th>\n",
       "      <th>Adj. Close</th>\n",
       "      <th>Adj. Volume</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1980-12-12</th>\n",
       "      <td>28.7500</td>\n",
       "      <td>28.87</td>\n",
       "      <td>28.7500</td>\n",
       "      <td>28.7500</td>\n",
       "      <td>2093900.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.424421</td>\n",
       "      <td>0.426193</td>\n",
       "      <td>0.424421</td>\n",
       "      <td>0.424421</td>\n",
       "      <td>117258400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1980-12-15</th>\n",
       "      <td>27.3800</td>\n",
       "      <td>27.38</td>\n",
       "      <td>27.2500</td>\n",
       "      <td>27.2500</td>\n",
       "      <td>785200.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.404196</td>\n",
       "      <td>0.404196</td>\n",
       "      <td>0.402277</td>\n",
       "      <td>0.402277</td>\n",
       "      <td>43971200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1980-12-16</th>\n",
       "      <td>25.3700</td>\n",
       "      <td>25.37</td>\n",
       "      <td>25.2500</td>\n",
       "      <td>25.2500</td>\n",
       "      <td>472000.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.374524</td>\n",
       "      <td>0.374524</td>\n",
       "      <td>0.372752</td>\n",
       "      <td>0.372752</td>\n",
       "      <td>26432000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1980-12-17</th>\n",
       "      <td>25.8700</td>\n",
       "      <td>26.00</td>\n",
       "      <td>25.8700</td>\n",
       "      <td>25.8700</td>\n",
       "      <td>385900.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.381905</td>\n",
       "      <td>0.383824</td>\n",
       "      <td>0.381905</td>\n",
       "      <td>0.381905</td>\n",
       "      <td>21610400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1980-12-18</th>\n",
       "      <td>26.6300</td>\n",
       "      <td>26.75</td>\n",
       "      <td>26.6300</td>\n",
       "      <td>26.6300</td>\n",
       "      <td>327900.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.393125</td>\n",
       "      <td>0.394896</td>\n",
       "      <td>0.393125</td>\n",
       "      <td>0.393125</td>\n",
       "      <td>18362400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1980-12-19</th>\n",
       "      <td>28.2500</td>\n",
       "      <td>28.38</td>\n",
       "      <td>28.2500</td>\n",
       "      <td>28.2500</td>\n",
       "      <td>217100.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.417040</td>\n",
       "      <td>0.418959</td>\n",
       "      <td>0.417040</td>\n",
       "      <td>0.417040</td>\n",
       "      <td>12157600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1980-12-22</th>\n",
       "      <td>29.6300</td>\n",
       "      <td>29.75</td>\n",
       "      <td>29.6300</td>\n",
       "      <td>29.6300</td>\n",
       "      <td>166800.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.437412</td>\n",
       "      <td>0.439183</td>\n",
       "      <td>0.437412</td>\n",
       "      <td>0.437412</td>\n",
       "      <td>9340800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1980-12-23</th>\n",
       "      <td>30.8800</td>\n",
       "      <td>31.00</td>\n",
       "      <td>30.8800</td>\n",
       "      <td>30.8800</td>\n",
       "      <td>209600.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.455865</td>\n",
       "      <td>0.457637</td>\n",
       "      <td>0.455865</td>\n",
       "      <td>0.455865</td>\n",
       "      <td>11737600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1980-12-24</th>\n",
       "      <td>32.5000</td>\n",
       "      <td>32.63</td>\n",
       "      <td>32.5000</td>\n",
       "      <td>32.5000</td>\n",
       "      <td>214300.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.479780</td>\n",
       "      <td>0.481699</td>\n",
       "      <td>0.479780</td>\n",
       "      <td>0.479780</td>\n",
       "      <td>12000800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1980-12-26</th>\n",
       "      <td>35.5000</td>\n",
       "      <td>35.62</td>\n",
       "      <td>35.5000</td>\n",
       "      <td>35.5000</td>\n",
       "      <td>248100.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.524068</td>\n",
       "      <td>0.525839</td>\n",
       "      <td>0.524068</td>\n",
       "      <td>0.524068</td>\n",
       "      <td>13893600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1980-12-29</th>\n",
       "      <td>36.0000</td>\n",
       "      <td>36.13</td>\n",
       "      <td>36.0000</td>\n",
       "      <td>36.0000</td>\n",
       "      <td>415900.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.531449</td>\n",
       "      <td>0.533368</td>\n",
       "      <td>0.531449</td>\n",
       "      <td>0.531449</td>\n",
       "      <td>23290400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1980-12-30</th>\n",
       "      <td>35.2500</td>\n",
       "      <td>35.25</td>\n",
       "      <td>35.1200</td>\n",
       "      <td>35.1200</td>\n",
       "      <td>307500.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.520377</td>\n",
       "      <td>0.520377</td>\n",
       "      <td>0.518458</td>\n",
       "      <td>0.518458</td>\n",
       "      <td>17220000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1980-12-31</th>\n",
       "      <td>34.2500</td>\n",
       "      <td>34.25</td>\n",
       "      <td>34.1300</td>\n",
       "      <td>34.1300</td>\n",
       "      <td>159600.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.505615</td>\n",
       "      <td>0.505615</td>\n",
       "      <td>0.503843</td>\n",
       "      <td>0.503843</td>\n",
       "      <td>8937600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-02</th>\n",
       "      <td>34.5000</td>\n",
       "      <td>34.75</td>\n",
       "      <td>34.5000</td>\n",
       "      <td>34.5000</td>\n",
       "      <td>96700.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.509305</td>\n",
       "      <td>0.512996</td>\n",
       "      <td>0.509305</td>\n",
       "      <td>0.509305</td>\n",
       "      <td>5415200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-05</th>\n",
       "      <td>33.8700</td>\n",
       "      <td>33.87</td>\n",
       "      <td>33.7500</td>\n",
       "      <td>33.7500</td>\n",
       "      <td>159500.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.500005</td>\n",
       "      <td>0.500005</td>\n",
       "      <td>0.498233</td>\n",
       "      <td>0.498233</td>\n",
       "      <td>8932000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-06</th>\n",
       "      <td>32.3700</td>\n",
       "      <td>32.37</td>\n",
       "      <td>32.2500</td>\n",
       "      <td>32.2500</td>\n",
       "      <td>201600.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.477861</td>\n",
       "      <td>0.477861</td>\n",
       "      <td>0.476090</td>\n",
       "      <td>0.476090</td>\n",
       "      <td>11289600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-07</th>\n",
       "      <td>31.0000</td>\n",
       "      <td>31.00</td>\n",
       "      <td>30.8800</td>\n",
       "      <td>30.8800</td>\n",
       "      <td>248600.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.457637</td>\n",
       "      <td>0.457637</td>\n",
       "      <td>0.455865</td>\n",
       "      <td>0.455865</td>\n",
       "      <td>13921600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-08</th>\n",
       "      <td>30.3700</td>\n",
       "      <td>30.37</td>\n",
       "      <td>30.2500</td>\n",
       "      <td>30.2500</td>\n",
       "      <td>177800.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.448336</td>\n",
       "      <td>0.448336</td>\n",
       "      <td>0.446565</td>\n",
       "      <td>0.446565</td>\n",
       "      <td>9956800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-09</th>\n",
       "      <td>31.8800</td>\n",
       "      <td>32.00</td>\n",
       "      <td>31.8800</td>\n",
       "      <td>31.8800</td>\n",
       "      <td>96000.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.470628</td>\n",
       "      <td>0.472399</td>\n",
       "      <td>0.470628</td>\n",
       "      <td>0.470628</td>\n",
       "      <td>5376000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-12</th>\n",
       "      <td>31.8800</td>\n",
       "      <td>31.88</td>\n",
       "      <td>31.6200</td>\n",
       "      <td>31.6200</td>\n",
       "      <td>105800.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.470628</td>\n",
       "      <td>0.470628</td>\n",
       "      <td>0.466789</td>\n",
       "      <td>0.466789</td>\n",
       "      <td>5924800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-13</th>\n",
       "      <td>30.6300</td>\n",
       "      <td>30.63</td>\n",
       "      <td>30.5000</td>\n",
       "      <td>30.5000</td>\n",
       "      <td>102900.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.452174</td>\n",
       "      <td>0.452174</td>\n",
       "      <td>0.450255</td>\n",
       "      <td>0.450255</td>\n",
       "      <td>5762400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-14</th>\n",
       "      <td>30.6300</td>\n",
       "      <td>30.75</td>\n",
       "      <td>30.6300</td>\n",
       "      <td>30.6300</td>\n",
       "      <td>63800.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.452174</td>\n",
       "      <td>0.453946</td>\n",
       "      <td>0.452174</td>\n",
       "      <td>0.452174</td>\n",
       "      <td>3572800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-15</th>\n",
       "      <td>31.2500</td>\n",
       "      <td>31.50</td>\n",
       "      <td>31.2500</td>\n",
       "      <td>31.2500</td>\n",
       "      <td>62800.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.461327</td>\n",
       "      <td>0.465018</td>\n",
       "      <td>0.461327</td>\n",
       "      <td>0.461327</td>\n",
       "      <td>3516800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-16</th>\n",
       "      <td>31.1200</td>\n",
       "      <td>31.12</td>\n",
       "      <td>31.0000</td>\n",
       "      <td>31.0000</td>\n",
       "      <td>59800.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.459408</td>\n",
       "      <td>0.459408</td>\n",
       "      <td>0.457637</td>\n",
       "      <td>0.457637</td>\n",
       "      <td>3348800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-19</th>\n",
       "      <td>32.8700</td>\n",
       "      <td>33.00</td>\n",
       "      <td>32.8700</td>\n",
       "      <td>32.8700</td>\n",
       "      <td>185600.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.485242</td>\n",
       "      <td>0.487162</td>\n",
       "      <td>0.485242</td>\n",
       "      <td>0.485242</td>\n",
       "      <td>10393600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-20</th>\n",
       "      <td>32.0000</td>\n",
       "      <td>32.00</td>\n",
       "      <td>31.8800</td>\n",
       "      <td>31.8800</td>\n",
       "      <td>134300.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.472399</td>\n",
       "      <td>0.472399</td>\n",
       "      <td>0.470628</td>\n",
       "      <td>0.470628</td>\n",
       "      <td>7520800.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-21</th>\n",
       "      <td>32.5000</td>\n",
       "      <td>32.75</td>\n",
       "      <td>32.5000</td>\n",
       "      <td>32.5000</td>\n",
       "      <td>71000.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.479780</td>\n",
       "      <td>0.483471</td>\n",
       "      <td>0.479780</td>\n",
       "      <td>0.479780</td>\n",
       "      <td>3976000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-22</th>\n",
       "      <td>32.8700</td>\n",
       "      <td>33.13</td>\n",
       "      <td>32.8700</td>\n",
       "      <td>32.8700</td>\n",
       "      <td>158700.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.485242</td>\n",
       "      <td>0.489081</td>\n",
       "      <td>0.485242</td>\n",
       "      <td>0.485242</td>\n",
       "      <td>8887200.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-23</th>\n",
       "      <td>32.8700</td>\n",
       "      <td>33.00</td>\n",
       "      <td>32.7500</td>\n",
       "      <td>32.7500</td>\n",
       "      <td>50100.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.485242</td>\n",
       "      <td>0.487162</td>\n",
       "      <td>0.483471</td>\n",
       "      <td>0.483471</td>\n",
       "      <td>2805600.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1981-01-26</th>\n",
       "      <td>32.3700</td>\n",
       "      <td>32.37</td>\n",
       "      <td>32.2500</td>\n",
       "      <td>32.2500</td>\n",
       "      <td>110000.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.477861</td>\n",
       "      <td>0.477861</td>\n",
       "      <td>0.476090</td>\n",
       "      <td>0.476090</td>\n",
       "      <td>6160000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-26</th>\n",
       "      <td>144.4700</td>\n",
       "      <td>144.60</td>\n",
       "      <td>143.3762</td>\n",
       "      <td>143.6508</td>\n",
       "      <td>19614287.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>143.881204</td>\n",
       "      <td>144.010674</td>\n",
       "      <td>142.791862</td>\n",
       "      <td>143.065343</td>\n",
       "      <td>19614287.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-27</th>\n",
       "      <td>143.9225</td>\n",
       "      <td>144.16</td>\n",
       "      <td>143.3100</td>\n",
       "      <td>143.7900</td>\n",
       "      <td>13948980.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>143.335935</td>\n",
       "      <td>143.572467</td>\n",
       "      <td>142.725932</td>\n",
       "      <td>143.203975</td>\n",
       "      <td>13948980.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-04-28</th>\n",
       "      <td>144.0900</td>\n",
       "      <td>144.30</td>\n",
       "      <td>143.2700</td>\n",
       "      <td>143.6500</td>\n",
       "      <td>20247187.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>143.502753</td>\n",
       "      <td>143.711897</td>\n",
       "      <td>142.686095</td>\n",
       "      <td>143.064546</td>\n",
       "      <td>20247187.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-01</th>\n",
       "      <td>145.1000</td>\n",
       "      <td>147.20</td>\n",
       "      <td>144.9600</td>\n",
       "      <td>146.6000</td>\n",
       "      <td>32818760.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>144.508636</td>\n",
       "      <td>146.600078</td>\n",
       "      <td>144.369207</td>\n",
       "      <td>146.002523</td>\n",
       "      <td>32818760.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-02</th>\n",
       "      <td>147.5400</td>\n",
       "      <td>148.09</td>\n",
       "      <td>146.8400</td>\n",
       "      <td>147.5100</td>\n",
       "      <td>39752670.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>146.938692</td>\n",
       "      <td>147.486450</td>\n",
       "      <td>146.241545</td>\n",
       "      <td>146.908814</td>\n",
       "      <td>39752670.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-03</th>\n",
       "      <td>145.5900</td>\n",
       "      <td>147.49</td>\n",
       "      <td>144.2700</td>\n",
       "      <td>147.0600</td>\n",
       "      <td>45142806.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>144.996639</td>\n",
       "      <td>146.888896</td>\n",
       "      <td>143.682019</td>\n",
       "      <td>146.460648</td>\n",
       "      <td>45142806.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-04</th>\n",
       "      <td>146.5200</td>\n",
       "      <td>147.14</td>\n",
       "      <td>145.8100</td>\n",
       "      <td>146.5300</td>\n",
       "      <td>23275690.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>145.922849</td>\n",
       "      <td>146.540322</td>\n",
       "      <td>145.215743</td>\n",
       "      <td>145.932808</td>\n",
       "      <td>23275690.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-05</th>\n",
       "      <td>146.7600</td>\n",
       "      <td>148.98</td>\n",
       "      <td>146.7600</td>\n",
       "      <td>148.9600</td>\n",
       "      <td>26787359.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>146.161871</td>\n",
       "      <td>148.372823</td>\n",
       "      <td>146.161871</td>\n",
       "      <td>148.352905</td>\n",
       "      <td>26787359.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-08</th>\n",
       "      <td>149.0300</td>\n",
       "      <td>153.70</td>\n",
       "      <td>149.0300</td>\n",
       "      <td>153.0000</td>\n",
       "      <td>48339210.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>148.422619</td>\n",
       "      <td>153.073586</td>\n",
       "      <td>148.422619</td>\n",
       "      <td>152.376439</td>\n",
       "      <td>48339210.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-09</th>\n",
       "      <td>153.8700</td>\n",
       "      <td>154.88</td>\n",
       "      <td>153.4500</td>\n",
       "      <td>153.9600</td>\n",
       "      <td>35942435.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>153.242894</td>\n",
       "      <td>154.248777</td>\n",
       "      <td>152.824605</td>\n",
       "      <td>153.332527</td>\n",
       "      <td>35942435.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-10</th>\n",
       "      <td>153.6300</td>\n",
       "      <td>153.94</td>\n",
       "      <td>152.1100</td>\n",
       "      <td>153.2600</td>\n",
       "      <td>25670456.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>153.003872</td>\n",
       "      <td>153.312608</td>\n",
       "      <td>151.490067</td>\n",
       "      <td>152.635380</td>\n",
       "      <td>25670456.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-11</th>\n",
       "      <td>152.4500</td>\n",
       "      <td>154.07</td>\n",
       "      <td>152.3100</td>\n",
       "      <td>153.9500</td>\n",
       "      <td>25596687.0</td>\n",
       "      <td>0.63</td>\n",
       "      <td>1.0</td>\n",
       "      <td>152.450000</td>\n",
       "      <td>154.070000</td>\n",
       "      <td>152.310000</td>\n",
       "      <td>153.950000</td>\n",
       "      <td>25596687.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-12</th>\n",
       "      <td>154.7000</td>\n",
       "      <td>156.42</td>\n",
       "      <td>154.6700</td>\n",
       "      <td>156.1000</td>\n",
       "      <td>32221756.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>154.700000</td>\n",
       "      <td>156.420000</td>\n",
       "      <td>154.670000</td>\n",
       "      <td>156.100000</td>\n",
       "      <td>32221756.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-15</th>\n",
       "      <td>156.0100</td>\n",
       "      <td>156.65</td>\n",
       "      <td>155.0500</td>\n",
       "      <td>155.7000</td>\n",
       "      <td>25700983.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>156.010000</td>\n",
       "      <td>156.650000</td>\n",
       "      <td>155.050000</td>\n",
       "      <td>155.700000</td>\n",
       "      <td>25700983.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-16</th>\n",
       "      <td>155.9400</td>\n",
       "      <td>156.06</td>\n",
       "      <td>154.7200</td>\n",
       "      <td>155.4700</td>\n",
       "      <td>19904679.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>155.940000</td>\n",
       "      <td>156.060000</td>\n",
       "      <td>154.720000</td>\n",
       "      <td>155.470000</td>\n",
       "      <td>19904679.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-17</th>\n",
       "      <td>153.6000</td>\n",
       "      <td>154.57</td>\n",
       "      <td>149.7100</td>\n",
       "      <td>150.2500</td>\n",
       "      <td>49482818.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>153.600000</td>\n",
       "      <td>154.570000</td>\n",
       "      <td>149.710000</td>\n",
       "      <td>150.250000</td>\n",
       "      <td>49482818.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-18</th>\n",
       "      <td>151.2700</td>\n",
       "      <td>153.34</td>\n",
       "      <td>151.1300</td>\n",
       "      <td>152.5400</td>\n",
       "      <td>33159664.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>151.270000</td>\n",
       "      <td>153.340000</td>\n",
       "      <td>151.130000</td>\n",
       "      <td>152.540000</td>\n",
       "      <td>33159664.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-19</th>\n",
       "      <td>153.3800</td>\n",
       "      <td>153.98</td>\n",
       "      <td>152.6300</td>\n",
       "      <td>152.9600</td>\n",
       "      <td>26733798.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>153.380000</td>\n",
       "      <td>153.980000</td>\n",
       "      <td>152.630000</td>\n",
       "      <td>152.960000</td>\n",
       "      <td>26733798.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-22</th>\n",
       "      <td>154.0000</td>\n",
       "      <td>154.58</td>\n",
       "      <td>152.9100</td>\n",
       "      <td>153.9900</td>\n",
       "      <td>22340069.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>154.000000</td>\n",
       "      <td>154.580000</td>\n",
       "      <td>152.910000</td>\n",
       "      <td>153.990000</td>\n",
       "      <td>22340069.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-23</th>\n",
       "      <td>154.9000</td>\n",
       "      <td>154.90</td>\n",
       "      <td>153.3100</td>\n",
       "      <td>153.8000</td>\n",
       "      <td>19430358.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>154.900000</td>\n",
       "      <td>154.900000</td>\n",
       "      <td>153.310000</td>\n",
       "      <td>153.800000</td>\n",
       "      <td>19430358.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-24</th>\n",
       "      <td>153.8400</td>\n",
       "      <td>154.17</td>\n",
       "      <td>152.6700</td>\n",
       "      <td>153.3400</td>\n",
       "      <td>19118319.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>153.840000</td>\n",
       "      <td>154.170000</td>\n",
       "      <td>152.670000</td>\n",
       "      <td>153.340000</td>\n",
       "      <td>19118319.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-25</th>\n",
       "      <td>153.7300</td>\n",
       "      <td>154.35</td>\n",
       "      <td>153.0300</td>\n",
       "      <td>153.8700</td>\n",
       "      <td>19044463.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>153.730000</td>\n",
       "      <td>154.350000</td>\n",
       "      <td>153.030000</td>\n",
       "      <td>153.870000</td>\n",
       "      <td>19044463.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-26</th>\n",
       "      <td>154.0000</td>\n",
       "      <td>154.24</td>\n",
       "      <td>153.3100</td>\n",
       "      <td>153.6100</td>\n",
       "      <td>21632202.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>154.000000</td>\n",
       "      <td>154.240000</td>\n",
       "      <td>153.310000</td>\n",
       "      <td>153.610000</td>\n",
       "      <td>21632202.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-30</th>\n",
       "      <td>153.4200</td>\n",
       "      <td>154.43</td>\n",
       "      <td>153.3300</td>\n",
       "      <td>153.6700</td>\n",
       "      <td>20034934.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>153.420000</td>\n",
       "      <td>154.430000</td>\n",
       "      <td>153.330000</td>\n",
       "      <td>153.670000</td>\n",
       "      <td>20034934.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-31</th>\n",
       "      <td>153.9700</td>\n",
       "      <td>154.17</td>\n",
       "      <td>152.3800</td>\n",
       "      <td>152.7600</td>\n",
       "      <td>23162873.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>153.970000</td>\n",
       "      <td>154.170000</td>\n",
       "      <td>152.380000</td>\n",
       "      <td>152.760000</td>\n",
       "      <td>23162873.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-01</th>\n",
       "      <td>153.1700</td>\n",
       "      <td>153.33</td>\n",
       "      <td>152.2200</td>\n",
       "      <td>153.1800</td>\n",
       "      <td>16180143.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>153.170000</td>\n",
       "      <td>153.330000</td>\n",
       "      <td>152.220000</td>\n",
       "      <td>153.180000</td>\n",
       "      <td>16180143.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-02</th>\n",
       "      <td>153.5800</td>\n",
       "      <td>155.45</td>\n",
       "      <td>152.8900</td>\n",
       "      <td>155.4500</td>\n",
       "      <td>27285861.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>153.580000</td>\n",
       "      <td>155.450000</td>\n",
       "      <td>152.890000</td>\n",
       "      <td>155.450000</td>\n",
       "      <td>27285861.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-05</th>\n",
       "      <td>154.3400</td>\n",
       "      <td>154.45</td>\n",
       "      <td>153.4600</td>\n",
       "      <td>153.9300</td>\n",
       "      <td>24803858.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>154.340000</td>\n",
       "      <td>154.450000</td>\n",
       "      <td>153.460000</td>\n",
       "      <td>153.930000</td>\n",
       "      <td>24803858.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-06</th>\n",
       "      <td>153.9000</td>\n",
       "      <td>155.81</td>\n",
       "      <td>153.7800</td>\n",
       "      <td>154.4500</td>\n",
       "      <td>26249630.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>153.900000</td>\n",
       "      <td>155.810000</td>\n",
       "      <td>153.780000</td>\n",
       "      <td>154.450000</td>\n",
       "      <td>26249630.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-07</th>\n",
       "      <td>155.0200</td>\n",
       "      <td>155.98</td>\n",
       "      <td>154.4800</td>\n",
       "      <td>155.3700</td>\n",
       "      <td>20678772.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1.0</td>\n",
       "      <td>155.020000</td>\n",
       "      <td>155.980000</td>\n",
       "      <td>154.480000</td>\n",
       "      <td>155.370000</td>\n",
       "      <td>20678772.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9200 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Open    High       Low     Close      Volume  Ex-Dividend  \\\n",
       "Date                                                                        \n",
       "1980-12-12   28.7500   28.87   28.7500   28.7500   2093900.0         0.00   \n",
       "1980-12-15   27.3800   27.38   27.2500   27.2500    785200.0         0.00   \n",
       "1980-12-16   25.3700   25.37   25.2500   25.2500    472000.0         0.00   \n",
       "1980-12-17   25.8700   26.00   25.8700   25.8700    385900.0         0.00   \n",
       "1980-12-18   26.6300   26.75   26.6300   26.6300    327900.0         0.00   \n",
       "1980-12-19   28.2500   28.38   28.2500   28.2500    217100.0         0.00   \n",
       "1980-12-22   29.6300   29.75   29.6300   29.6300    166800.0         0.00   \n",
       "1980-12-23   30.8800   31.00   30.8800   30.8800    209600.0         0.00   \n",
       "1980-12-24   32.5000   32.63   32.5000   32.5000    214300.0         0.00   \n",
       "1980-12-26   35.5000   35.62   35.5000   35.5000    248100.0         0.00   \n",
       "1980-12-29   36.0000   36.13   36.0000   36.0000    415900.0         0.00   \n",
       "1980-12-30   35.2500   35.25   35.1200   35.1200    307500.0         0.00   \n",
       "1980-12-31   34.2500   34.25   34.1300   34.1300    159600.0         0.00   \n",
       "1981-01-02   34.5000   34.75   34.5000   34.5000     96700.0         0.00   \n",
       "1981-01-05   33.8700   33.87   33.7500   33.7500    159500.0         0.00   \n",
       "1981-01-06   32.3700   32.37   32.2500   32.2500    201600.0         0.00   \n",
       "1981-01-07   31.0000   31.00   30.8800   30.8800    248600.0         0.00   \n",
       "1981-01-08   30.3700   30.37   30.2500   30.2500    177800.0         0.00   \n",
       "1981-01-09   31.8800   32.00   31.8800   31.8800     96000.0         0.00   \n",
       "1981-01-12   31.8800   31.88   31.6200   31.6200    105800.0         0.00   \n",
       "1981-01-13   30.6300   30.63   30.5000   30.5000    102900.0         0.00   \n",
       "1981-01-14   30.6300   30.75   30.6300   30.6300     63800.0         0.00   \n",
       "1981-01-15   31.2500   31.50   31.2500   31.2500     62800.0         0.00   \n",
       "1981-01-16   31.1200   31.12   31.0000   31.0000     59800.0         0.00   \n",
       "1981-01-19   32.8700   33.00   32.8700   32.8700    185600.0         0.00   \n",
       "1981-01-20   32.0000   32.00   31.8800   31.8800    134300.0         0.00   \n",
       "1981-01-21   32.5000   32.75   32.5000   32.5000     71000.0         0.00   \n",
       "1981-01-22   32.8700   33.13   32.8700   32.8700    158700.0         0.00   \n",
       "1981-01-23   32.8700   33.00   32.7500   32.7500     50100.0         0.00   \n",
       "1981-01-26   32.3700   32.37   32.2500   32.2500    110000.0         0.00   \n",
       "...              ...     ...       ...       ...         ...          ...   \n",
       "2017-04-26  144.4700  144.60  143.3762  143.6508  19614287.0         0.00   \n",
       "2017-04-27  143.9225  144.16  143.3100  143.7900  13948980.0         0.00   \n",
       "2017-04-28  144.0900  144.30  143.2700  143.6500  20247187.0         0.00   \n",
       "2017-05-01  145.1000  147.20  144.9600  146.6000  32818760.0         0.00   \n",
       "2017-05-02  147.5400  148.09  146.8400  147.5100  39752670.0         0.00   \n",
       "2017-05-03  145.5900  147.49  144.2700  147.0600  45142806.0         0.00   \n",
       "2017-05-04  146.5200  147.14  145.8100  146.5300  23275690.0         0.00   \n",
       "2017-05-05  146.7600  148.98  146.7600  148.9600  26787359.0         0.00   \n",
       "2017-05-08  149.0300  153.70  149.0300  153.0000  48339210.0         0.00   \n",
       "2017-05-09  153.8700  154.88  153.4500  153.9600  35942435.0         0.00   \n",
       "2017-05-10  153.6300  153.94  152.1100  153.2600  25670456.0         0.00   \n",
       "2017-05-11  152.4500  154.07  152.3100  153.9500  25596687.0         0.63   \n",
       "2017-05-12  154.7000  156.42  154.6700  156.1000  32221756.0         0.00   \n",
       "2017-05-15  156.0100  156.65  155.0500  155.7000  25700983.0         0.00   \n",
       "2017-05-16  155.9400  156.06  154.7200  155.4700  19904679.0         0.00   \n",
       "2017-05-17  153.6000  154.57  149.7100  150.2500  49482818.0         0.00   \n",
       "2017-05-18  151.2700  153.34  151.1300  152.5400  33159664.0         0.00   \n",
       "2017-05-19  153.3800  153.98  152.6300  152.9600  26733798.0         0.00   \n",
       "2017-05-22  154.0000  154.58  152.9100  153.9900  22340069.0         0.00   \n",
       "2017-05-23  154.9000  154.90  153.3100  153.8000  19430358.0         0.00   \n",
       "2017-05-24  153.8400  154.17  152.6700  153.3400  19118319.0         0.00   \n",
       "2017-05-25  153.7300  154.35  153.0300  153.8700  19044463.0         0.00   \n",
       "2017-05-26  154.0000  154.24  153.3100  153.6100  21632202.0         0.00   \n",
       "2017-05-30  153.4200  154.43  153.3300  153.6700  20034934.0         0.00   \n",
       "2017-05-31  153.9700  154.17  152.3800  152.7600  23162873.0         0.00   \n",
       "2017-06-01  153.1700  153.33  152.2200  153.1800  16180143.0         0.00   \n",
       "2017-06-02  153.5800  155.45  152.8900  155.4500  27285861.0         0.00   \n",
       "2017-06-05  154.3400  154.45  153.4600  153.9300  24803858.0         0.00   \n",
       "2017-06-06  153.9000  155.81  153.7800  154.4500  26249630.0         0.00   \n",
       "2017-06-07  155.0200  155.98  154.4800  155.3700  20678772.0         0.00   \n",
       "\n",
       "            Split Ratio   Adj. Open   Adj. High    Adj. Low  Adj. Close  \\\n",
       "Date                                                                      \n",
       "1980-12-12          1.0    0.424421    0.426193    0.424421    0.424421   \n",
       "1980-12-15          1.0    0.404196    0.404196    0.402277    0.402277   \n",
       "1980-12-16          1.0    0.374524    0.374524    0.372752    0.372752   \n",
       "1980-12-17          1.0    0.381905    0.383824    0.381905    0.381905   \n",
       "1980-12-18          1.0    0.393125    0.394896    0.393125    0.393125   \n",
       "1980-12-19          1.0    0.417040    0.418959    0.417040    0.417040   \n",
       "1980-12-22          1.0    0.437412    0.439183    0.437412    0.437412   \n",
       "1980-12-23          1.0    0.455865    0.457637    0.455865    0.455865   \n",
       "1980-12-24          1.0    0.479780    0.481699    0.479780    0.479780   \n",
       "1980-12-26          1.0    0.524068    0.525839    0.524068    0.524068   \n",
       "1980-12-29          1.0    0.531449    0.533368    0.531449    0.531449   \n",
       "1980-12-30          1.0    0.520377    0.520377    0.518458    0.518458   \n",
       "1980-12-31          1.0    0.505615    0.505615    0.503843    0.503843   \n",
       "1981-01-02          1.0    0.509305    0.512996    0.509305    0.509305   \n",
       "1981-01-05          1.0    0.500005    0.500005    0.498233    0.498233   \n",
       "1981-01-06          1.0    0.477861    0.477861    0.476090    0.476090   \n",
       "1981-01-07          1.0    0.457637    0.457637    0.455865    0.455865   \n",
       "1981-01-08          1.0    0.448336    0.448336    0.446565    0.446565   \n",
       "1981-01-09          1.0    0.470628    0.472399    0.470628    0.470628   \n",
       "1981-01-12          1.0    0.470628    0.470628    0.466789    0.466789   \n",
       "1981-01-13          1.0    0.452174    0.452174    0.450255    0.450255   \n",
       "1981-01-14          1.0    0.452174    0.453946    0.452174    0.452174   \n",
       "1981-01-15          1.0    0.461327    0.465018    0.461327    0.461327   \n",
       "1981-01-16          1.0    0.459408    0.459408    0.457637    0.457637   \n",
       "1981-01-19          1.0    0.485242    0.487162    0.485242    0.485242   \n",
       "1981-01-20          1.0    0.472399    0.472399    0.470628    0.470628   \n",
       "1981-01-21          1.0    0.479780    0.483471    0.479780    0.479780   \n",
       "1981-01-22          1.0    0.485242    0.489081    0.485242    0.485242   \n",
       "1981-01-23          1.0    0.485242    0.487162    0.483471    0.483471   \n",
       "1981-01-26          1.0    0.477861    0.477861    0.476090    0.476090   \n",
       "...                 ...         ...         ...         ...         ...   \n",
       "2017-04-26          1.0  143.881204  144.010674  142.791862  143.065343   \n",
       "2017-04-27          1.0  143.335935  143.572467  142.725932  143.203975   \n",
       "2017-04-28          1.0  143.502753  143.711897  142.686095  143.064546   \n",
       "2017-05-01          1.0  144.508636  146.600078  144.369207  146.002523   \n",
       "2017-05-02          1.0  146.938692  147.486450  146.241545  146.908814   \n",
       "2017-05-03          1.0  144.996639  146.888896  143.682019  146.460648   \n",
       "2017-05-04          1.0  145.922849  146.540322  145.215743  145.932808   \n",
       "2017-05-05          1.0  146.161871  148.372823  146.161871  148.352905   \n",
       "2017-05-08          1.0  148.422619  153.073586  148.422619  152.376439   \n",
       "2017-05-09          1.0  153.242894  154.248777  152.824605  153.332527   \n",
       "2017-05-10          1.0  153.003872  153.312608  151.490067  152.635380   \n",
       "2017-05-11          1.0  152.450000  154.070000  152.310000  153.950000   \n",
       "2017-05-12          1.0  154.700000  156.420000  154.670000  156.100000   \n",
       "2017-05-15          1.0  156.010000  156.650000  155.050000  155.700000   \n",
       "2017-05-16          1.0  155.940000  156.060000  154.720000  155.470000   \n",
       "2017-05-17          1.0  153.600000  154.570000  149.710000  150.250000   \n",
       "2017-05-18          1.0  151.270000  153.340000  151.130000  152.540000   \n",
       "2017-05-19          1.0  153.380000  153.980000  152.630000  152.960000   \n",
       "2017-05-22          1.0  154.000000  154.580000  152.910000  153.990000   \n",
       "2017-05-23          1.0  154.900000  154.900000  153.310000  153.800000   \n",
       "2017-05-24          1.0  153.840000  154.170000  152.670000  153.340000   \n",
       "2017-05-25          1.0  153.730000  154.350000  153.030000  153.870000   \n",
       "2017-05-26          1.0  154.000000  154.240000  153.310000  153.610000   \n",
       "2017-05-30          1.0  153.420000  154.430000  153.330000  153.670000   \n",
       "2017-05-31          1.0  153.970000  154.170000  152.380000  152.760000   \n",
       "2017-06-01          1.0  153.170000  153.330000  152.220000  153.180000   \n",
       "2017-06-02          1.0  153.580000  155.450000  152.890000  155.450000   \n",
       "2017-06-05          1.0  154.340000  154.450000  153.460000  153.930000   \n",
       "2017-06-06          1.0  153.900000  155.810000  153.780000  154.450000   \n",
       "2017-06-07          1.0  155.020000  155.980000  154.480000  155.370000   \n",
       "\n",
       "            Adj. Volume  \n",
       "Date                     \n",
       "1980-12-12  117258400.0  \n",
       "1980-12-15   43971200.0  \n",
       "1980-12-16   26432000.0  \n",
       "1980-12-17   21610400.0  \n",
       "1980-12-18   18362400.0  \n",
       "1980-12-19   12157600.0  \n",
       "1980-12-22    9340800.0  \n",
       "1980-12-23   11737600.0  \n",
       "1980-12-24   12000800.0  \n",
       "1980-12-26   13893600.0  \n",
       "1980-12-29   23290400.0  \n",
       "1980-12-30   17220000.0  \n",
       "1980-12-31    8937600.0  \n",
       "1981-01-02    5415200.0  \n",
       "1981-01-05    8932000.0  \n",
       "1981-01-06   11289600.0  \n",
       "1981-01-07   13921600.0  \n",
       "1981-01-08    9956800.0  \n",
       "1981-01-09    5376000.0  \n",
       "1981-01-12    5924800.0  \n",
       "1981-01-13    5762400.0  \n",
       "1981-01-14    3572800.0  \n",
       "1981-01-15    3516800.0  \n",
       "1981-01-16    3348800.0  \n",
       "1981-01-19   10393600.0  \n",
       "1981-01-20    7520800.0  \n",
       "1981-01-21    3976000.0  \n",
       "1981-01-22    8887200.0  \n",
       "1981-01-23    2805600.0  \n",
       "1981-01-26    6160000.0  \n",
       "...                 ...  \n",
       "2017-04-26   19614287.0  \n",
       "2017-04-27   13948980.0  \n",
       "2017-04-28   20247187.0  \n",
       "2017-05-01   32818760.0  \n",
       "2017-05-02   39752670.0  \n",
       "2017-05-03   45142806.0  \n",
       "2017-05-04   23275690.0  \n",
       "2017-05-05   26787359.0  \n",
       "2017-05-08   48339210.0  \n",
       "2017-05-09   35942435.0  \n",
       "2017-05-10   25670456.0  \n",
       "2017-05-11   25596687.0  \n",
       "2017-05-12   32221756.0  \n",
       "2017-05-15   25700983.0  \n",
       "2017-05-16   19904679.0  \n",
       "2017-05-17   49482818.0  \n",
       "2017-05-18   33159664.0  \n",
       "2017-05-19   26733798.0  \n",
       "2017-05-22   22340069.0  \n",
       "2017-05-23   19430358.0  \n",
       "2017-05-24   19118319.0  \n",
       "2017-05-25   19044463.0  \n",
       "2017-05-26   21632202.0  \n",
       "2017-05-30   20034934.0  \n",
       "2017-05-31   23162873.0  \n",
       "2017-06-01   16180143.0  \n",
       "2017-06-02   27285861.0  \n",
       "2017-06-05   24803858.0  \n",
       "2017-06-06   26249630.0  \n",
       "2017-06-07   20678772.0  \n",
       "\n",
       "[9200 rows x 12 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# data\n",
    "# WIKI/AAPL appears to be method for Apple stock\n",
    "data = quandl.get(\"WIKI/AAPL\")\n",
    "# data ...score! Apple stock data from 1980-12-12 to 2017-06-07\n",
    "# need to review https://www.quandl.com/tools/api for more info\n",
    "# and https://docs.quandl.com/"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [Root]",
   "language": "python",
   "name": "Python [Root]"
  },
  "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.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}