Machine Learning for Investment - Part 4 - Quandl.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "import pandas as pd\n",
    "import os\n",
    "import time\n",
    "from Quandl import Quandl\n",
    "auth_tok = 'aQ5ZPmDWastS5z3yjfvJ'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\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>2000-12-12</th>\n",
       "      <td> 58.31</td>\n",
       "      <td> 58.6900</td>\n",
       "      <td> 57.6200</td>\n",
       "      <td> 58.00</td>\n",
       "      <td>  4004100</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 23.159879</td>\n",
       "      <td> 23.310809</td>\n",
       "      <td> 22.885821</td>\n",
       "      <td> 23.036752</td>\n",
       "      <td>  8008200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-13</th>\n",
       "      <td> 58.00</td>\n",
       "      <td> 58.3100</td>\n",
       "      <td> 57.2500</td>\n",
       "      <td> 57.81</td>\n",
       "      <td>  3704900</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 23.036752</td>\n",
       "      <td> 23.159879</td>\n",
       "      <td> 22.738862</td>\n",
       "      <td> 22.961286</td>\n",
       "      <td>  7409800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-14</th>\n",
       "      <td> 57.44</td>\n",
       "      <td> 57.4400</td>\n",
       "      <td> 55.7500</td>\n",
       "      <td> 57.00</td>\n",
       "      <td>  5023800</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 22.814328</td>\n",
       "      <td> 22.814328</td>\n",
       "      <td> 22.143084</td>\n",
       "      <td> 22.639566</td>\n",
       "      <td> 10047600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-15</th>\n",
       "      <td> 56.69</td>\n",
       "      <td> 56.6900</td>\n",
       "      <td> 53.5000</td>\n",
       "      <td> 53.50</td>\n",
       "      <td> 13770200</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 22.516439</td>\n",
       "      <td> 22.516439</td>\n",
       "      <td> 21.249417</td>\n",
       "      <td> 21.249417</td>\n",
       "      <td> 27540400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-18</th>\n",
       "      <td> 53.62</td>\n",
       "      <td> 55.5600</td>\n",
       "      <td> 53.6200</td>\n",
       "      <td> 54.88</td>\n",
       "      <td>  5152300</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 21.297080</td>\n",
       "      <td> 22.067619</td>\n",
       "      <td> 21.297080</td>\n",
       "      <td> 21.797533</td>\n",
       "      <td> 10304600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-19</th>\n",
       "      <td> 54.88</td>\n",
       "      <td> 57.9400</td>\n",
       "      <td> 54.6900</td>\n",
       "      <td> 56.75</td>\n",
       "      <td>  5844100</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 21.797533</td>\n",
       "      <td> 23.012920</td>\n",
       "      <td> 21.722068</td>\n",
       "      <td> 22.540270</td>\n",
       "      <td> 11688200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-20</th>\n",
       "      <td> 56.75</td>\n",
       "      <td> 58.0000</td>\n",
       "      <td> 55.5600</td>\n",
       "      <td> 56.25</td>\n",
       "      <td>  6672100</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 22.540270</td>\n",
       "      <td> 23.036752</td>\n",
       "      <td> 22.067619</td>\n",
       "      <td> 22.341677</td>\n",
       "      <td> 13344200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-21</th>\n",
       "      <td> 56.25</td>\n",
       "      <td> 59.6200</td>\n",
       "      <td> 56.1200</td>\n",
       "      <td> 59.38</td>\n",
       "      <td>  5965400</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 22.341677</td>\n",
       "      <td> 23.680192</td>\n",
       "      <td> 22.290043</td>\n",
       "      <td> 23.584867</td>\n",
       "      <td> 11930800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-22</th>\n",
       "      <td> 59.00</td>\n",
       "      <td> 59.0000</td>\n",
       "      <td> 57.5000</td>\n",
       "      <td> 58.88</td>\n",
       "      <td>  3741800</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 23.433937</td>\n",
       "      <td> 23.433937</td>\n",
       "      <td> 22.838159</td>\n",
       "      <td> 23.386275</td>\n",
       "      <td>  7483600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-26</th>\n",
       "      <td> 58.88</td>\n",
       "      <td> 60.0000</td>\n",
       "      <td> 58.6200</td>\n",
       "      <td> 60.00</td>\n",
       "      <td>  2835000</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 23.386275</td>\n",
       "      <td> 23.831122</td>\n",
       "      <td> 23.283006</td>\n",
       "      <td> 23.831122</td>\n",
       "      <td>  5670000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-27</th>\n",
       "      <td> 60.00</td>\n",
       "      <td> 61.3800</td>\n",
       "      <td> 60.0000</td>\n",
       "      <td> 60.56</td>\n",
       "      <td>  3855500</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 23.831122</td>\n",
       "      <td> 24.379238</td>\n",
       "      <td> 23.831122</td>\n",
       "      <td> 24.053546</td>\n",
       "      <td>  7711000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-28</th>\n",
       "      <td> 60.56</td>\n",
       "      <td> 61.9400</td>\n",
       "      <td> 60.5600</td>\n",
       "      <td> 61.06</td>\n",
       "      <td>  2760400</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 24.053546</td>\n",
       "      <td> 24.601662</td>\n",
       "      <td> 24.053546</td>\n",
       "      <td> 24.252139</td>\n",
       "      <td>  5520800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-12-29</th>\n",
       "      <td> 61.06</td>\n",
       "      <td> 61.1200</td>\n",
       "      <td> 60.1900</td>\n",
       "      <td> 60.94</td>\n",
       "      <td>  2485200</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 24.252139</td>\n",
       "      <td> 24.275970</td>\n",
       "      <td> 23.906587</td>\n",
       "      <td> 24.204477</td>\n",
       "      <td>  4970400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-02</th>\n",
       "      <td> 60.94</td>\n",
       "      <td> 61.9400</td>\n",
       "      <td> 60.2500</td>\n",
       "      <td> 60.81</td>\n",
       "      <td>  5303000</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 24.204477</td>\n",
       "      <td> 24.601662</td>\n",
       "      <td> 23.930419</td>\n",
       "      <td> 24.152842</td>\n",
       "      <td> 10606000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-03</th>\n",
       "      <td> 60.81</td>\n",
       "      <td> 62.1900</td>\n",
       "      <td> 59.0600</td>\n",
       "      <td> 59.25</td>\n",
       "      <td>  6234800</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 24.152842</td>\n",
       "      <td> 24.700958</td>\n",
       "      <td> 23.457768</td>\n",
       "      <td> 23.533233</td>\n",
       "      <td> 12469600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-04</th>\n",
       "      <td> 58.88</td>\n",
       "      <td> 58.8800</td>\n",
       "      <td> 56.7500</td>\n",
       "      <td> 57.56</td>\n",
       "      <td>  7385300</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 23.386275</td>\n",
       "      <td> 23.386275</td>\n",
       "      <td> 22.540270</td>\n",
       "      <td> 22.861990</td>\n",
       "      <td> 14770600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-05</th>\n",
       "      <td> 57.56</td>\n",
       "      <td> 58.7500</td>\n",
       "      <td> 57.5000</td>\n",
       "      <td> 57.69</td>\n",
       "      <td>  3980100</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 22.861990</td>\n",
       "      <td> 23.334641</td>\n",
       "      <td> 22.838159</td>\n",
       "      <td> 22.913624</td>\n",
       "      <td>  7960200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-08</th>\n",
       "      <td> 57.81</td>\n",
       "      <td> 59.6900</td>\n",
       "      <td> 57.8100</td>\n",
       "      <td> 58.62</td>\n",
       "      <td>  4764600</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 22.961286</td>\n",
       "      <td> 23.707995</td>\n",
       "      <td> 22.961286</td>\n",
       "      <td> 23.283006</td>\n",
       "      <td>  9529200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-09</th>\n",
       "      <td> 58.62</td>\n",
       "      <td> 59.9400</td>\n",
       "      <td> 57.6200</td>\n",
       "      <td> 59.38</td>\n",
       "      <td>  4258100</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 23.283006</td>\n",
       "      <td> 23.807291</td>\n",
       "      <td> 22.885821</td>\n",
       "      <td> 23.584867</td>\n",
       "      <td>  8516200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-10</th>\n",
       "      <td> 59.25</td>\n",
       "      <td> 59.2500</td>\n",
       "      <td> 57.8800</td>\n",
       "      <td> 59.12</td>\n",
       "      <td>  3981600</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 23.533233</td>\n",
       "      <td> 23.533233</td>\n",
       "      <td> 22.989089</td>\n",
       "      <td> 23.481599</td>\n",
       "      <td>  7963200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-11</th>\n",
       "      <td> 58.88</td>\n",
       "      <td> 58.8800</td>\n",
       "      <td> 57.1200</td>\n",
       "      <td> 57.38</td>\n",
       "      <td>  3454500</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 23.386275</td>\n",
       "      <td> 23.386275</td>\n",
       "      <td> 22.687228</td>\n",
       "      <td> 22.790497</td>\n",
       "      <td>  6909000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-12</th>\n",
       "      <td> 57.38</td>\n",
       "      <td> 57.4400</td>\n",
       "      <td> 56.2500</td>\n",
       "      <td> 56.62</td>\n",
       "      <td>  3606000</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 22.790497</td>\n",
       "      <td> 22.814328</td>\n",
       "      <td> 22.341677</td>\n",
       "      <td> 22.488636</td>\n",
       "      <td>  7212000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-16</th>\n",
       "      <td> 56.62</td>\n",
       "      <td> 57.3100</td>\n",
       "      <td> 56.1900</td>\n",
       "      <td> 57.00</td>\n",
       "      <td>  3581800</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 22.488636</td>\n",
       "      <td> 22.762694</td>\n",
       "      <td> 22.317846</td>\n",
       "      <td> 22.639566</td>\n",
       "      <td>  7163600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-17</th>\n",
       "      <td> 57.06</td>\n",
       "      <td> 58.6900</td>\n",
       "      <td> 57.0600</td>\n",
       "      <td> 57.94</td>\n",
       "      <td>  3825900</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 22.663397</td>\n",
       "      <td> 23.310809</td>\n",
       "      <td> 22.663397</td>\n",
       "      <td> 23.012920</td>\n",
       "      <td>  7651800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-18</th>\n",
       "      <td> 57.94</td>\n",
       "      <td> 58.6900</td>\n",
       "      <td> 56.9400</td>\n",
       "      <td> 57.12</td>\n",
       "      <td>  3507200</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 23.012920</td>\n",
       "      <td> 23.310809</td>\n",
       "      <td> 22.615735</td>\n",
       "      <td> 22.687228</td>\n",
       "      <td>  7014400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-19</th>\n",
       "      <td> 57.12</td>\n",
       "      <td> 57.1200</td>\n",
       "      <td> 55.3100</td>\n",
       "      <td> 55.81</td>\n",
       "      <td>  4912100</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 22.687228</td>\n",
       "      <td> 22.687228</td>\n",
       "      <td> 21.968323</td>\n",
       "      <td> 22.166916</td>\n",
       "      <td>  9824200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-22</th>\n",
       "      <td> 55.81</td>\n",
       "      <td> 56.0600</td>\n",
       "      <td> 55.1900</td>\n",
       "      <td> 55.69</td>\n",
       "      <td>  3437300</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 22.166916</td>\n",
       "      <td> 22.266212</td>\n",
       "      <td> 21.920661</td>\n",
       "      <td> 22.119253</td>\n",
       "      <td>  6874600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-23</th>\n",
       "      <td> 55.69</td>\n",
       "      <td> 57.1900</td>\n",
       "      <td> 55.4400</td>\n",
       "      <td> 56.88</td>\n",
       "      <td>  3853900</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 22.119253</td>\n",
       "      <td> 22.715031</td>\n",
       "      <td> 22.019957</td>\n",
       "      <td> 22.591904</td>\n",
       "      <td>  7707800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-24</th>\n",
       "      <td> 56.88</td>\n",
       "      <td> 58.0600</td>\n",
       "      <td> 56.1200</td>\n",
       "      <td> 58.06</td>\n",
       "      <td>  4594700</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 22.591904</td>\n",
       "      <td> 23.060583</td>\n",
       "      <td> 22.290043</td>\n",
       "      <td> 23.060583</td>\n",
       "      <td>  9189400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2001-01-25</th>\n",
       "      <td> 58.06</td>\n",
       "      <td> 59.0000</td>\n",
       "      <td> 57.8100</td>\n",
       "      <td> 58.62</td>\n",
       "      <td>  3743400</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 23.060583</td>\n",
       "      <td> 23.433937</td>\n",
       "      <td> 22.961286</td>\n",
       "      <td> 23.283006</td>\n",
       "      <td>  7486800</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>2014-11-11</th>\n",
       "      <td> 42.38</td>\n",
       "      <td> 42.7100</td>\n",
       "      <td> 42.3600</td>\n",
       "      <td> 42.51</td>\n",
       "      <td>  8519256</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 41.409768</td>\n",
       "      <td> 41.732213</td>\n",
       "      <td> 41.390226</td>\n",
       "      <td> 41.536792</td>\n",
       "      <td>  8519256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-11-12</th>\n",
       "      <td> 42.51</td>\n",
       "      <td> 42.8900</td>\n",
       "      <td> 42.3100</td>\n",
       "      <td> 42.71</td>\n",
       "      <td> 12767870</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 41.536792</td>\n",
       "      <td> 41.908092</td>\n",
       "      <td> 41.341370</td>\n",
       "      <td> 41.732213</td>\n",
       "      <td> 12767870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-11-13</th>\n",
       "      <td> 42.65</td>\n",
       "      <td> 43.0800</td>\n",
       "      <td> 42.6299</td>\n",
       "      <td> 42.79</td>\n",
       "      <td> 12006900</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 41.673587</td>\n",
       "      <td> 42.093742</td>\n",
       "      <td> 41.653947</td>\n",
       "      <td> 41.810381</td>\n",
       "      <td> 12006900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-11-14</th>\n",
       "      <td> 42.70</td>\n",
       "      <td> 42.9700</td>\n",
       "      <td> 42.5000</td>\n",
       "      <td> 42.73</td>\n",
       "      <td> 10939420</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 41.722442</td>\n",
       "      <td> 41.986261</td>\n",
       "      <td> 41.527021</td>\n",
       "      <td> 41.751755</td>\n",
       "      <td> 10939420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-11-17</th>\n",
       "      <td> 42.75</td>\n",
       "      <td> 42.9900</td>\n",
       "      <td> 42.7300</td>\n",
       "      <td> 42.92</td>\n",
       "      <td> 10647040</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 41.771297</td>\n",
       "      <td> 42.005803</td>\n",
       "      <td> 41.751755</td>\n",
       "      <td> 41.937405</td>\n",
       "      <td> 10647040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-11-18</th>\n",
       "      <td> 42.99</td>\n",
       "      <td> 43.8600</td>\n",
       "      <td> 42.7500</td>\n",
       "      <td> 43.53</td>\n",
       "      <td> 26132605</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 42.005803</td>\n",
       "      <td> 42.855885</td>\n",
       "      <td> 41.771297</td>\n",
       "      <td> 42.533440</td>\n",
       "      <td> 26132605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-11-19</th>\n",
       "      <td> 43.54</td>\n",
       "      <td> 44.4297</td>\n",
       "      <td> 43.5600</td>\n",
       "      <td> 44.22</td>\n",
       "      <td> 25347462</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 42.543211</td>\n",
       "      <td> 43.412543</td>\n",
       "      <td> 42.562753</td>\n",
       "      <td> 43.207644</td>\n",
       "      <td> 25347462</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-11-20</th>\n",
       "      <td> 43.85</td>\n",
       "      <td> 44.4200</td>\n",
       "      <td> 43.8500</td>\n",
       "      <td> 44.25</td>\n",
       "      <td> 13462838</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 42.846114</td>\n",
       "      <td> 43.403065</td>\n",
       "      <td> 42.846114</td>\n",
       "      <td> 43.236957</td>\n",
       "      <td> 13462838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-11-21</th>\n",
       "      <td> 44.58</td>\n",
       "      <td> 44.7400</td>\n",
       "      <td> 44.2800</td>\n",
       "      <td> 44.50</td>\n",
       "      <td> 14382570</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 43.559402</td>\n",
       "      <td> 43.715739</td>\n",
       "      <td> 43.266270</td>\n",
       "      <td> 43.481233</td>\n",
       "      <td> 14382570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-11-24</th>\n",
       "      <td> 44.51</td>\n",
       "      <td> 44.7800</td>\n",
       "      <td> 44.2000</td>\n",
       "      <td> 44.27</td>\n",
       "      <td> 12844590</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 43.491004</td>\n",
       "      <td> 43.754823</td>\n",
       "      <td> 43.188101</td>\n",
       "      <td> 43.256499</td>\n",
       "      <td> 12844590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-11-25</th>\n",
       "      <td> 44.17</td>\n",
       "      <td> 44.5900</td>\n",
       "      <td> 44.1200</td>\n",
       "      <td> 44.43</td>\n",
       "      <td> 10728465</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 43.158788</td>\n",
       "      <td> 43.569173</td>\n",
       "      <td> 43.109933</td>\n",
       "      <td> 43.412836</td>\n",
       "      <td> 10728465</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-11-26</th>\n",
       "      <td> 43.98</td>\n",
       "      <td> 44.3650</td>\n",
       "      <td> 43.9700</td>\n",
       "      <td> 44.29</td>\n",
       "      <td>  9196101</td>\n",
       "      <td> 0.305</td>\n",
       "      <td> 1</td>\n",
       "      <td> 43.269070</td>\n",
       "      <td> 43.647846</td>\n",
       "      <td> 43.259231</td>\n",
       "      <td> 43.574058</td>\n",
       "      <td>  9196101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-11-28</th>\n",
       "      <td> 44.23</td>\n",
       "      <td> 45.0000</td>\n",
       "      <td> 44.1500</td>\n",
       "      <td> 44.83</td>\n",
       "      <td> 10501972</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 43.515028</td>\n",
       "      <td> 44.272581</td>\n",
       "      <td> 43.436321</td>\n",
       "      <td> 44.105329</td>\n",
       "      <td> 10501972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-01</th>\n",
       "      <td> 44.32</td>\n",
       "      <td> 44.7650</td>\n",
       "      <td> 44.1300</td>\n",
       "      <td> 44.55</td>\n",
       "      <td> 10052497</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 43.603573</td>\n",
       "      <td> 44.041380</td>\n",
       "      <td> 43.416645</td>\n",
       "      <td> 43.829856</td>\n",
       "      <td> 10052497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-02</th>\n",
       "      <td> 44.38</td>\n",
       "      <td> 44.6700</td>\n",
       "      <td> 44.2300</td>\n",
       "      <td> 44.54</td>\n",
       "      <td>  9860626</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 43.662604</td>\n",
       "      <td> 43.947916</td>\n",
       "      <td> 43.515028</td>\n",
       "      <td> 43.820017</td>\n",
       "      <td>  9860626</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-04</th>\n",
       "      <td> 43.62</td>\n",
       "      <td> 43.8400</td>\n",
       "      <td> 43.3700</td>\n",
       "      <td> 43.50</td>\n",
       "      <td> 13775398</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 42.914889</td>\n",
       "      <td> 43.131333</td>\n",
       "      <td> 42.668930</td>\n",
       "      <td> 42.796829</td>\n",
       "      <td> 13775398</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-05</th>\n",
       "      <td> 43.32</td>\n",
       "      <td> 43.6100</td>\n",
       "      <td> 43.2000</td>\n",
       "      <td> 43.53</td>\n",
       "      <td> 12525974</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 42.619738</td>\n",
       "      <td> 42.905051</td>\n",
       "      <td> 42.501678</td>\n",
       "      <td> 42.826344</td>\n",
       "      <td> 12525974</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-09</th>\n",
       "      <td> 42.31</td>\n",
       "      <td> 42.5310</td>\n",
       "      <td> 41.6700</td>\n",
       "      <td> 42.04</td>\n",
       "      <td> 25455917</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 41.626065</td>\n",
       "      <td> 41.843492</td>\n",
       "      <td> 40.996410</td>\n",
       "      <td> 41.360429</td>\n",
       "      <td> 25455917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-10</th>\n",
       "      <td> 42.04</td>\n",
       "      <td> 42.2400</td>\n",
       "      <td> 41.5600</td>\n",
       "      <td> 41.60</td>\n",
       "      <td> 18234879</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 41.360429</td>\n",
       "      <td> 41.557196</td>\n",
       "      <td> 40.888188</td>\n",
       "      <td> 40.927542</td>\n",
       "      <td> 18234879</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-11</th>\n",
       "      <td> 41.61</td>\n",
       "      <td> 42.0100</td>\n",
       "      <td> 41.5000</td>\n",
       "      <td> 41.53</td>\n",
       "      <td> 16168066</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 40.937380</td>\n",
       "      <td> 41.330914</td>\n",
       "      <td> 40.829158</td>\n",
       "      <td> 40.858673</td>\n",
       "      <td> 16168066</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-15</th>\n",
       "      <td> 41.10</td>\n",
       "      <td> 41.1800</td>\n",
       "      <td> 40.5600</td>\n",
       "      <td> 40.57</td>\n",
       "      <td> 23235600</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 40.435624</td>\n",
       "      <td> 40.514331</td>\n",
       "      <td> 39.904353</td>\n",
       "      <td> 39.914192</td>\n",
       "      <td> 23235600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-16</th>\n",
       "      <td> 40.21</td>\n",
       "      <td> 41.3100</td>\n",
       "      <td> 39.8000</td>\n",
       "      <td> 40.39</td>\n",
       "      <td> 23417350</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 39.560011</td>\n",
       "      <td> 40.642230</td>\n",
       "      <td> 39.156639</td>\n",
       "      <td> 39.737101</td>\n",
       "      <td> 23417350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-17</th>\n",
       "      <td> 40.44</td>\n",
       "      <td> 41.7600</td>\n",
       "      <td> 40.3800</td>\n",
       "      <td> 41.55</td>\n",
       "      <td> 20175592</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 39.786293</td>\n",
       "      <td> 41.084956</td>\n",
       "      <td> 39.727263</td>\n",
       "      <td> 40.878350</td>\n",
       "      <td> 20175592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-18</th>\n",
       "      <td> 41.86</td>\n",
       "      <td> 42.3900</td>\n",
       "      <td> 41.7500</td>\n",
       "      <td> 42.39</td>\n",
       "      <td> 17918113</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 41.183339</td>\n",
       "      <td> 41.704772</td>\n",
       "      <td> 41.075117</td>\n",
       "      <td> 41.704772</td>\n",
       "      <td> 17918113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-19</th>\n",
       "      <td> 42.49</td>\n",
       "      <td> 42.7900</td>\n",
       "      <td> 41.8900</td>\n",
       "      <td> 41.95</td>\n",
       "      <td> 23926178</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 41.803155</td>\n",
       "      <td> 42.098306</td>\n",
       "      <td> 41.212854</td>\n",
       "      <td> 41.271884</td>\n",
       "      <td> 23926178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-22</th>\n",
       "      <td> 42.14</td>\n",
       "      <td> 42.4400</td>\n",
       "      <td> 42.0900</td>\n",
       "      <td> 42.35</td>\n",
       "      <td> 11131276</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 41.458813</td>\n",
       "      <td> 41.753963</td>\n",
       "      <td> 41.409621</td>\n",
       "      <td> 41.665418</td>\n",
       "      <td> 11131276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-23</th>\n",
       "      <td> 42.54</td>\n",
       "      <td> 43.1400</td>\n",
       "      <td> 42.4700</td>\n",
       "      <td> 42.97</td>\n",
       "      <td> 13026464</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 41.852347</td>\n",
       "      <td> 42.442648</td>\n",
       "      <td> 41.783478</td>\n",
       "      <td> 42.275396</td>\n",
       "      <td> 13026464</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-24</th>\n",
       "      <td> 43.11</td>\n",
       "      <td> 43.2300</td>\n",
       "      <td> 42.9200</td>\n",
       "      <td> 42.94</td>\n",
       "      <td>  6405910</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 42.413133</td>\n",
       "      <td> 42.531193</td>\n",
       "      <td> 42.226204</td>\n",
       "      <td> 42.245881</td>\n",
       "      <td>  6405910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-26</th>\n",
       "      <td> 42.95</td>\n",
       "      <td> 43.3000</td>\n",
       "      <td> 42.9300</td>\n",
       "      <td> 42.96</td>\n",
       "      <td>  6365767</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 42.255719</td>\n",
       "      <td> 42.600062</td>\n",
       "      <td> 42.236043</td>\n",
       "      <td> 42.265558</td>\n",
       "      <td>  6365767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2014-12-30</th>\n",
       "      <td> 42.72</td>\n",
       "      <td> 42.9900</td>\n",
       "      <td> 42.6510</td>\n",
       "      <td> 42.76</td>\n",
       "      <td>  9160093</td>\n",
       "      <td> 0.000</td>\n",
       "      <td> 1</td>\n",
       "      <td> 42.029437</td>\n",
       "      <td> 42.295073</td>\n",
       "      <td> 41.961553</td>\n",
       "      <td> 42.068791</td>\n",
       "      <td>  9160093</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3528 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Open     High      Low  Close    Volume  Ex-Dividend  \\\n",
       "Date                                                                \n",
       "2000-12-12  58.31  58.6900  57.6200  58.00   4004100        0.000   \n",
       "2000-12-13  58.00  58.3100  57.2500  57.81   3704900        0.000   \n",
       "2000-12-14  57.44  57.4400  55.7500  57.00   5023800        0.000   \n",
       "2000-12-15  56.69  56.6900  53.5000  53.50  13770200        0.000   \n",
       "2000-12-18  53.62  55.5600  53.6200  54.88   5152300        0.000   \n",
       "2000-12-19  54.88  57.9400  54.6900  56.75   5844100        0.000   \n",
       "2000-12-20  56.75  58.0000  55.5600  56.25   6672100        0.000   \n",
       "2000-12-21  56.25  59.6200  56.1200  59.38   5965400        0.000   \n",
       "2000-12-22  59.00  59.0000  57.5000  58.88   3741800        0.000   \n",
       "2000-12-26  58.88  60.0000  58.6200  60.00   2835000        0.000   \n",
       "2000-12-27  60.00  61.3800  60.0000  60.56   3855500        0.000   \n",
       "2000-12-28  60.56  61.9400  60.5600  61.06   2760400        0.000   \n",
       "2000-12-29  61.06  61.1200  60.1900  60.94   2485200        0.000   \n",
       "2001-01-02  60.94  61.9400  60.2500  60.81   5303000        0.000   \n",
       "2001-01-03  60.81  62.1900  59.0600  59.25   6234800        0.000   \n",
       "2001-01-04  58.88  58.8800  56.7500  57.56   7385300        0.000   \n",
       "2001-01-05  57.56  58.7500  57.5000  57.69   3980100        0.000   \n",
       "2001-01-08  57.81  59.6900  57.8100  58.62   4764600        0.000   \n",
       "2001-01-09  58.62  59.9400  57.6200  59.38   4258100        0.000   \n",
       "2001-01-10  59.25  59.2500  57.8800  59.12   3981600        0.000   \n",
       "2001-01-11  58.88  58.8800  57.1200  57.38   3454500        0.000   \n",
       "2001-01-12  57.38  57.4400  56.2500  56.62   3606000        0.000   \n",
       "2001-01-16  56.62  57.3100  56.1900  57.00   3581800        0.000   \n",
       "2001-01-17  57.06  58.6900  57.0600  57.94   3825900        0.000   \n",
       "2001-01-18  57.94  58.6900  56.9400  57.12   3507200        0.000   \n",
       "2001-01-19  57.12  57.1200  55.3100  55.81   4912100        0.000   \n",
       "2001-01-22  55.81  56.0600  55.1900  55.69   3437300        0.000   \n",
       "2001-01-23  55.69  57.1900  55.4400  56.88   3853900        0.000   \n",
       "2001-01-24  56.88  58.0600  56.1200  58.06   4594700        0.000   \n",
       "2001-01-25  58.06  59.0000  57.8100  58.62   3743400        0.000   \n",
       "...           ...      ...      ...    ...       ...          ...   \n",
       "2014-11-11  42.38  42.7100  42.3600  42.51   8519256        0.000   \n",
       "2014-11-12  42.51  42.8900  42.3100  42.71  12767870        0.000   \n",
       "2014-11-13  42.65  43.0800  42.6299  42.79  12006900        0.000   \n",
       "2014-11-14  42.70  42.9700  42.5000  42.73  10939420        0.000   \n",
       "2014-11-17  42.75  42.9900  42.7300  42.92  10647040        0.000   \n",
       "2014-11-18  42.99  43.8600  42.7500  43.53  26132605        0.000   \n",
       "2014-11-19  43.54  44.4297  43.5600  44.22  25347462        0.000   \n",
       "2014-11-20  43.85  44.4200  43.8500  44.25  13462838        0.000   \n",
       "2014-11-21  44.58  44.7400  44.2800  44.50  14382570        0.000   \n",
       "2014-11-24  44.51  44.7800  44.2000  44.27  12844590        0.000   \n",
       "2014-11-25  44.17  44.5900  44.1200  44.43  10728465        0.000   \n",
       "2014-11-26  43.98  44.3650  43.9700  44.29   9196101        0.305   \n",
       "2014-11-28  44.23  45.0000  44.1500  44.83  10501972        0.000   \n",
       "2014-12-01  44.32  44.7650  44.1300  44.55  10052497        0.000   \n",
       "2014-12-02  44.38  44.6700  44.2300  44.54   9860626        0.000   \n",
       "2014-12-04  43.62  43.8400  43.3700  43.50  13775398        0.000   \n",
       "2014-12-05  43.32  43.6100  43.2000  43.53  12525974        0.000   \n",
       "2014-12-09  42.31  42.5310  41.6700  42.04  25455917        0.000   \n",
       "2014-12-10  42.04  42.2400  41.5600  41.60  18234879        0.000   \n",
       "2014-12-11  41.61  42.0100  41.5000  41.53  16168066        0.000   \n",
       "2014-12-15  41.10  41.1800  40.5600  40.57  23235600        0.000   \n",
       "2014-12-16  40.21  41.3100  39.8000  40.39  23417350        0.000   \n",
       "2014-12-17  40.44  41.7600  40.3800  41.55  20175592        0.000   \n",
       "2014-12-18  41.86  42.3900  41.7500  42.39  17918113        0.000   \n",
       "2014-12-19  42.49  42.7900  41.8900  41.95  23926178        0.000   \n",
       "2014-12-22  42.14  42.4400  42.0900  42.35  11131276        0.000   \n",
       "2014-12-23  42.54  43.1400  42.4700  42.97  13026464        0.000   \n",
       "2014-12-24  43.11  43.2300  42.9200  42.94   6405910        0.000   \n",
       "2014-12-26  42.95  43.3000  42.9300  42.96   6365767        0.000   \n",
       "2014-12-30  42.72  42.9900  42.6510  42.76   9160093        0.000   \n",
       "\n",
       "            Split Ratio  Adj. Open  Adj. High   Adj. Low  Adj. Close  \\\n",
       "Date                                                                   \n",
       "2000-12-12            1  23.159879  23.310809  22.885821   23.036752   \n",
       "2000-12-13            1  23.036752  23.159879  22.738862   22.961286   \n",
       "2000-12-14            1  22.814328  22.814328  22.143084   22.639566   \n",
       "2000-12-15            1  22.516439  22.516439  21.249417   21.249417   \n",
       "2000-12-18            1  21.297080  22.067619  21.297080   21.797533   \n",
       "2000-12-19            1  21.797533  23.012920  21.722068   22.540270   \n",
       "2000-12-20            1  22.540270  23.036752  22.067619   22.341677   \n",
       "2000-12-21            1  22.341677  23.680192  22.290043   23.584867   \n",
       "2000-12-22            1  23.433937  23.433937  22.838159   23.386275   \n",
       "2000-12-26            1  23.386275  23.831122  23.283006   23.831122   \n",
       "2000-12-27            1  23.831122  24.379238  23.831122   24.053546   \n",
       "2000-12-28            1  24.053546  24.601662  24.053546   24.252139   \n",
       "2000-12-29            1  24.252139  24.275970  23.906587   24.204477   \n",
       "2001-01-02            1  24.204477  24.601662  23.930419   24.152842   \n",
       "2001-01-03            1  24.152842  24.700958  23.457768   23.533233   \n",
       "2001-01-04            1  23.386275  23.386275  22.540270   22.861990   \n",
       "2001-01-05            1  22.861990  23.334641  22.838159   22.913624   \n",
       "2001-01-08            1  22.961286  23.707995  22.961286   23.283006   \n",
       "2001-01-09            1  23.283006  23.807291  22.885821   23.584867   \n",
       "2001-01-10            1  23.533233  23.533233  22.989089   23.481599   \n",
       "2001-01-11            1  23.386275  23.386275  22.687228   22.790497   \n",
       "2001-01-12            1  22.790497  22.814328  22.341677   22.488636   \n",
       "2001-01-16            1  22.488636  22.762694  22.317846   22.639566   \n",
       "2001-01-17            1  22.663397  23.310809  22.663397   23.012920   \n",
       "2001-01-18            1  23.012920  23.310809  22.615735   22.687228   \n",
       "2001-01-19            1  22.687228  22.687228  21.968323   22.166916   \n",
       "2001-01-22            1  22.166916  22.266212  21.920661   22.119253   \n",
       "2001-01-23            1  22.119253  22.715031  22.019957   22.591904   \n",
       "2001-01-24            1  22.591904  23.060583  22.290043   23.060583   \n",
       "2001-01-25            1  23.060583  23.433937  22.961286   23.283006   \n",
       "...                 ...        ...        ...        ...         ...   \n",
       "2014-11-11            1  41.409768  41.732213  41.390226   41.536792   \n",
       "2014-11-12            1  41.536792  41.908092  41.341370   41.732213   \n",
       "2014-11-13            1  41.673587  42.093742  41.653947   41.810381   \n",
       "2014-11-14            1  41.722442  41.986261  41.527021   41.751755   \n",
       "2014-11-17            1  41.771297  42.005803  41.751755   41.937405   \n",
       "2014-11-18            1  42.005803  42.855885  41.771297   42.533440   \n",
       "2014-11-19            1  42.543211  43.412543  42.562753   43.207644   \n",
       "2014-11-20            1  42.846114  43.403065  42.846114   43.236957   \n",
       "2014-11-21            1  43.559402  43.715739  43.266270   43.481233   \n",
       "2014-11-24            1  43.491004  43.754823  43.188101   43.256499   \n",
       "2014-11-25            1  43.158788  43.569173  43.109933   43.412836   \n",
       "2014-11-26            1  43.269070  43.647846  43.259231   43.574058   \n",
       "2014-11-28            1  43.515028  44.272581  43.436321   44.105329   \n",
       "2014-12-01            1  43.603573  44.041380  43.416645   43.829856   \n",
       "2014-12-02            1  43.662604  43.947916  43.515028   43.820017   \n",
       "2014-12-04            1  42.914889  43.131333  42.668930   42.796829   \n",
       "2014-12-05            1  42.619738  42.905051  42.501678   42.826344   \n",
       "2014-12-09            1  41.626065  41.843492  40.996410   41.360429   \n",
       "2014-12-10            1  41.360429  41.557196  40.888188   40.927542   \n",
       "2014-12-11            1  40.937380  41.330914  40.829158   40.858673   \n",
       "2014-12-15            1  40.435624  40.514331  39.904353   39.914192   \n",
       "2014-12-16            1  39.560011  40.642230  39.156639   39.737101   \n",
       "2014-12-17            1  39.786293  41.084956  39.727263   40.878350   \n",
       "2014-12-18            1  41.183339  41.704772  41.075117   41.704772   \n",
       "2014-12-19            1  41.803155  42.098306  41.212854   41.271884   \n",
       "2014-12-22            1  41.458813  41.753963  41.409621   41.665418   \n",
       "2014-12-23            1  41.852347  42.442648  41.783478   42.275396   \n",
       "2014-12-24            1  42.413133  42.531193  42.226204   42.245881   \n",
       "2014-12-26            1  42.255719  42.600062  42.236043   42.265558   \n",
       "2014-12-30            1  42.029437  42.295073  41.961553   42.068791   \n",
       "\n",
       "            Adj. Volume  \n",
       "Date                     \n",
       "2000-12-12      8008200  \n",
       "2000-12-13      7409800  \n",
       "2000-12-14     10047600  \n",
       "2000-12-15     27540400  \n",
       "2000-12-18     10304600  \n",
       "2000-12-19     11688200  \n",
       "2000-12-20     13344200  \n",
       "2000-12-21     11930800  \n",
       "2000-12-22      7483600  \n",
       "2000-12-26      5670000  \n",
       "2000-12-27      7711000  \n",
       "2000-12-28      5520800  \n",
       "2000-12-29      4970400  \n",
       "2001-01-02     10606000  \n",
       "2001-01-03     12469600  \n",
       "2001-01-04     14770600  \n",
       "2001-01-05      7960200  \n",
       "2001-01-08      9529200  \n",
       "2001-01-09      8516200  \n",
       "2001-01-10      7963200  \n",
       "2001-01-11      6909000  \n",
       "2001-01-12      7212000  \n",
       "2001-01-16      7163600  \n",
       "2001-01-17      7651800  \n",
       "2001-01-18      7014400  \n",
       "2001-01-19      9824200  \n",
       "2001-01-22      6874600  \n",
       "2001-01-23      7707800  \n",
       "2001-01-24      9189400  \n",
       "2001-01-25      7486800  \n",
       "...                 ...  \n",
       "2014-11-11      8519256  \n",
       "2014-11-12     12767870  \n",
       "2014-11-13     12006900  \n",
       "2014-11-14     10939420  \n",
       "2014-11-17     10647040  \n",
       "2014-11-18     26132605  \n",
       "2014-11-19     25347462  \n",
       "2014-11-20     13462838  \n",
       "2014-11-21     14382570  \n",
       "2014-11-24     12844590  \n",
       "2014-11-25     10728465  \n",
       "2014-11-26      9196101  \n",
       "2014-11-28     10501972  \n",
       "2014-12-01     10052497  \n",
       "2014-12-02      9860626  \n",
       "2014-12-04     13775398  \n",
       "2014-12-05     12525974  \n",
       "2014-12-09     25455917  \n",
       "2014-12-10     18234879  \n",
       "2014-12-11     16168066  \n",
       "2014-12-15     23235600  \n",
       "2014-12-16     23417350  \n",
       "2014-12-17     20175592  \n",
       "2014-12-18     17918113  \n",
       "2014-12-19     23926178  \n",
       "2014-12-22     11131276  \n",
       "2014-12-23     13026464  \n",
       "2014-12-24      6405910  \n",
       "2014-12-26      6365767  \n",
       "2014-12-30      9160093  \n",
       "\n",
       "[3528 rows x 12 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data = Quandl.get('WIKI/KO', trim_start = '2000-12-12', trim_end = '2014-12-30', authtoken = auth_tok)\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(3528, 12)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "a\n",
      "aa\n",
      "aapl\n",
      "abbv\n",
      "abc\n",
      "abt\n",
      "ace\n",
      "aci\n",
      "acn\n",
      "act\n",
      "adbe\n",
      "adi\n",
      "adm\n",
      "adp\n",
      "adsk\n",
      "adt\n",
      "aee\n",
      "aeo\n",
      "aep\n",
      "aes\n",
      "aet\n",
      "afl\n",
      "agn\n",
      "aig\n",
      "aiv\n",
      "aiz\n",
      "akam\n",
      "all\n",
      "altr\n",
      "alxn\n",
      "amat\n",
      "amd\n",
      "amgn\n",
      "amp\n",
      "amt\n",
      "amzn\n",
      "an\n",
      "anf\n",
      "ann\n",
      "aon\n"
     ]
    },
    {
     "ename": "KeyboardInterrupt",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m                         Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-18-14c85ee8f0e1>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m     20\u001b[0m     \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mhead\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     21\u001b[0m     \u001b[0mdf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mto_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'stock_prices.csv'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 22\u001b[0;31m \u001b[0mstock_prices\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m<ipython-input-18-14c85ee8f0e1>\u001b[0m in \u001b[0;36mstock_prices\u001b[0;34m()\u001b[0m\n\u001b[1;32m     12\u001b[0m                               \u001b[0mtrim_start\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m\"2000-12-12\"\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     13\u001b[0m                               \u001b[0mtrim_end\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m\"2014-12-30\"\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 14\u001b[0;31m                               authtoken=auth_tok)\n\u001b[0m\u001b[1;32m     15\u001b[0m             \u001b[0mdata\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mticker\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mupper\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdata\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"Adj. Close\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     16\u001b[0m             \u001b[0mdf\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mconcat\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mdf\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdata\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mticker\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mupper\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0maxis\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/site-packages/Quandl/Quandl.py\u001b[0m in \u001b[0;36mget\u001b[0;34m(dataset, **kwargs)\u001b[0m\n\u001b[1;32m    117\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0murl\u001b[0m      \u001b[0;31m# for test purpose\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    118\u001b[0m     \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 119\u001b[0;31m         \u001b[0murldata\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0m_download\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0murl\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    120\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mverbose\u001b[0m \u001b[0;32mand\u001b[0m \u001b[0mverbose\u001b[0m \u001b[0;34m!=\u001b[0m \u001b[0;34m'no'\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    121\u001b[0m             \u001b[0mprint\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"Returning Dataframe for \"\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdataset\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/site-packages/Quandl/Quandl.py\u001b[0m in \u001b[0;36m_download\u001b[0;34m(url)\u001b[0m\n\u001b[1;32m    312\u001b[0m \u001b[0;31m# Download data into pandas dataframe\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    313\u001b[0m \u001b[0;32mdef\u001b[0m \u001b[0m_download\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0murl\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 314\u001b[0;31m     \u001b[0mdframe\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0murl\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mindex_col\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mparse_dates\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mTrue\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    315\u001b[0m     \u001b[0;32mreturn\u001b[0m \u001b[0mdframe\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    316\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/site-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36mparser_f\u001b[0;34m(filepath_or_buffer, sep, dialect, compression, doublequote, escapechar, quotechar, quoting, skipinitialspace, lineterminator, header, index_col, names, prefix, skiprows, skipfooter, skip_footer, na_values, na_fvalues, true_values, false_values, delimiter, converters, dtype, usecols, engine, delim_whitespace, as_recarray, na_filter, compact_ints, use_unsigned, low_memory, buffer_lines, warn_bad_lines, error_bad_lines, keep_default_na, thousands, comment, decimal, parse_dates, keep_date_col, dayfirst, date_parser, memory_map, nrows, iterator, chunksize, verbose, encoding, squeeze, mangle_dupe_cols, tupleize_cols, infer_datetime_format)\u001b[0m\n\u001b[1;32m    450\u001b[0m                     infer_datetime_format=infer_datetime_format)\n\u001b[1;32m    451\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 452\u001b[0;31m         \u001b[0;32mreturn\u001b[0m \u001b[0m_read\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkwds\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    453\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    454\u001b[0m     \u001b[0mparser_f\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m__name__\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/site-packages/pandas/io/parsers.py\u001b[0m in \u001b[0;36m_read\u001b[0;34m(filepath_or_buffer, kwds)\u001b[0m\n\u001b[1;32m    220\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    221\u001b[0m     filepath_or_buffer, _ = get_filepath_or_buffer(filepath_or_buffer,\n\u001b[0;32m--> 222\u001b[0;31m                                                    encoding)\n\u001b[0m\u001b[1;32m    223\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    224\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0mkwds\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'date_parser'\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/site-packages/pandas/io/common.py\u001b[0m in \u001b[0;36mget_filepath_or_buffer\u001b[0;34m(filepath_or_buffer, encoding)\u001b[0m\n\u001b[1;32m    116\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    117\u001b[0m     \u001b[0;32mif\u001b[0m \u001b[0m_is_url\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 118\u001b[0;31m         \u001b[0mreq\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0m_urlopen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath_or_buffer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    119\u001b[0m         \u001b[0;32mreturn\u001b[0m \u001b[0mmaybe_read_encoded_stream\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mreq\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mencoding\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    120\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/urllib/request.py\u001b[0m in \u001b[0;36murlopen\u001b[0;34m(url, data, timeout, cafile, capath, cadefault, context)\u001b[0m\n\u001b[1;32m    159\u001b[0m     \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    160\u001b[0m         \u001b[0mopener\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0m_opener\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 161\u001b[0;31m     \u001b[0;32mreturn\u001b[0m \u001b[0mopener\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mopen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0murl\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdata\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtimeout\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    162\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    163\u001b[0m \u001b[0;32mdef\u001b[0m \u001b[0minstall_opener\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mopener\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/urllib/request.py\u001b[0m in \u001b[0;36mopen\u001b[0;34m(self, fullurl, data, timeout)\u001b[0m\n\u001b[1;32m    461\u001b[0m             \u001b[0mreq\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mmeth\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mreq\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    462\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 463\u001b[0;31m         \u001b[0mresponse\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_open\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mreq\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mdata\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    464\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    465\u001b[0m         \u001b[0;31m# post-process response\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/urllib/request.py\u001b[0m in \u001b[0;36m_open\u001b[0;34m(self, req, data)\u001b[0m\n\u001b[1;32m    479\u001b[0m         \u001b[0mprotocol\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mreq\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mtype\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    480\u001b[0m         result = self._call_chain(self.handle_open, protocol, protocol +\n\u001b[0;32m--> 481\u001b[0;31m                                   '_open', req)\n\u001b[0m\u001b[1;32m    482\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mresult\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    483\u001b[0m             \u001b[0;32mreturn\u001b[0m \u001b[0mresult\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/urllib/request.py\u001b[0m in \u001b[0;36m_call_chain\u001b[0;34m(self, chain, kind, meth_name, *args)\u001b[0m\n\u001b[1;32m    439\u001b[0m         \u001b[0;32mfor\u001b[0m \u001b[0mhandler\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mhandlers\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    440\u001b[0m             \u001b[0mfunc\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mgetattr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mhandler\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mmeth_name\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 441\u001b[0;31m             \u001b[0mresult\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mfunc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m*\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    442\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mresult\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    443\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mresult\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/urllib/request.py\u001b[0m in \u001b[0;36mhttps_open\u001b[0;34m(self, req)\u001b[0m\n\u001b[1;32m   1223\u001b[0m         \u001b[0;32mdef\u001b[0m \u001b[0mhttps_open\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mreq\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1224\u001b[0m             return self.do_open(http.client.HTTPSConnection, req,\n\u001b[0;32m-> 1225\u001b[0;31m                 context=self._context, check_hostname=self._check_hostname)\n\u001b[0m\u001b[1;32m   1226\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1227\u001b[0m         \u001b[0mhttps_request\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mAbstractHTTPHandler\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdo_request_\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/urllib/request.py\u001b[0m in \u001b[0;36mdo_open\u001b[0;34m(self, http_class, req, **http_conn_args)\u001b[0m\n\u001b[1;32m   1183\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mOSError\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m:\u001b[0m \u001b[0;31m# timeout error\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1184\u001b[0m                 \u001b[0;32mraise\u001b[0m \u001b[0mURLError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0merr\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1185\u001b[0;31m             \u001b[0mr\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mh\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mgetresponse\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1186\u001b[0m         \u001b[0;32mexcept\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1187\u001b[0m             \u001b[0mh\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mclose\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/http/client.py\u001b[0m in \u001b[0;36mgetresponse\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m   1169\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1170\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 1171\u001b[0;31m             \u001b[0mresponse\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mbegin\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   1172\u001b[0m             \u001b[0;32massert\u001b[0m \u001b[0mresponse\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mwill_close\u001b[0m \u001b[0;34m!=\u001b[0m \u001b[0m_UNKNOWN\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   1173\u001b[0m             \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m__state\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0m_CS_IDLE\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/http/client.py\u001b[0m in \u001b[0;36mbegin\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    349\u001b[0m         \u001b[0;31m# read until we get a non-100 response\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    350\u001b[0m         \u001b[0;32mwhile\u001b[0m \u001b[0;32mTrue\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 351\u001b[0;31m             \u001b[0mversion\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mstatus\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mreason\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_read_status\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    352\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mstatus\u001b[0m \u001b[0;34m!=\u001b[0m \u001b[0mCONTINUE\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    353\u001b[0m                 \u001b[0;32mbreak\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/http/client.py\u001b[0m in \u001b[0;36m_read_status\u001b[0;34m(self)\u001b[0m\n\u001b[1;32m    311\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    312\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_read_status\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 313\u001b[0;31m         \u001b[0mline\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mstr\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mfp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mreadline\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0m_MAXLINE\u001b[0m \u001b[0;34m+\u001b[0m \u001b[0;36m1\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m\"iso-8859-1\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    314\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mline\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m>\u001b[0m \u001b[0m_MAXLINE\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    315\u001b[0m             \u001b[0;32mraise\u001b[0m \u001b[0mLineTooLong\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"status line\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/socket.py\u001b[0m in \u001b[0;36mreadinto\u001b[0;34m(self, b)\u001b[0m\n\u001b[1;32m    372\u001b[0m         \u001b[0;32mwhile\u001b[0m \u001b[0;32mTrue\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    373\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 374\u001b[0;31m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_sock\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mrecv_into\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mb\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    375\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mtimeout\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    376\u001b[0m                 \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_timeout_occurred\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;32mTrue\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/ssl.py\u001b[0m in \u001b[0;36mrecv_into\u001b[0;34m(self, buffer, nbytes, flags)\u001b[0m\n\u001b[1;32m    749\u001b[0m                   \u001b[0;34m\"non-zero flags not allowed in calls to recv_into() on %s\"\u001b[0m \u001b[0;34m%\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    750\u001b[0m                   self.__class__)\n\u001b[0;32m--> 751\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mnbytes\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mbuffer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    752\u001b[0m         \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    753\u001b[0m             \u001b[0;32mreturn\u001b[0m \u001b[0msocket\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mrecv_into\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mbuffer\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mnbytes\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mflags\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Users/aswinrajkumar/anaconda/lib/python3.4/ssl.py\u001b[0m in \u001b[0;36mread\u001b[0;34m(self, len, buffer)\u001b[0m\n\u001b[1;32m    621\u001b[0m         \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    622\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mbuffer\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 623\u001b[0;31m                 \u001b[0mv\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_sslobj\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlen\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mbuffer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    624\u001b[0m             \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    625\u001b[0m                 \u001b[0mv\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_sslobj\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlen\u001b[0m \u001b[0;32mor\u001b[0m \u001b[0;36m1024\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m: "
     ]
    }
   ],
   "source": [
    "path = \"intraQuarter/\"\n",
    "def stock_prices():\n",
    "    df = pd.DataFrame()\n",
    "    statspath = path+'_KeyStats'\n",
    "    stock_list = [x[0] for x in os.walk(statspath)]\n",
    "    for each_dir in stock_list[1:]:\n",
    "        try:\n",
    "            ticker = each_dir.split(\"/\")[2]\n",
    "            print(ticker)\n",
    "            name = \"WIKI/\"+ticker.upper()\n",
    "            data = Quandl.get(name,\n",
    "                              trim_start = \"2000-12-12\",\n",
    "                              trim_end = \"2014-12-30\",\n",
    "                              authtoken=auth_tok)\n",
    "            data[ticker.upper()] = data[\"Adj. Close\"]\n",
    "            df = pd.concat([df, data[ticker.upper()]], axis = 1)\n",
    "        except Exception as e:\n",
    "            print(name,str(e))\n",
    "            time.sleep(10)\n",
    "    print(df.head())\n",
    "    df.to_csv('stock_prices.csv')\n",
    "stock_prices()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.4.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}