StockwithPython.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {
    "button": false,
    "collapsed": false,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": [
    "import glob\n",
    "import pandas as pd\n",
    "import datetime as dt\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "button": false,
    "collapsed": false,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": [
    "path= r'EOD/'\n",
    "\n",
    "allFiles = glob.glob(path + \"*.csv\")\n",
    "frame = pd.DataFrame()\n",
    "list_ = []\n",
    "for file_ in allFiles:\n",
    "    df = pd.read_csv(file_,index_col=None, header=0)\n",
    "    list_.append(df)\n",
    "frame = pd.concat(list_)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false,
    "run_control": {}
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>&lt;TICKER&gt;</th>\n",
       "      <th>&lt;DTYYYYMMDD&gt;</th>\n",
       "      <th>&lt;OPEN&gt;</th>\n",
       "      <th>&lt;HIGH&gt;</th>\n",
       "      <th>&lt;LOW&gt;</th>\n",
       "      <th>&lt;CLOSE&gt;</th>\n",
       "      <th>&lt;VOL&gt;</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1DIV</td>\n",
       "      <td>20170104</td>\n",
       "      <td>11.77</td>\n",
       "      <td>11.81</td>\n",
       "      <td>11.76</td>\n",
       "      <td>11.81</td>\n",
       "      <td>26000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BMSCITH</td>\n",
       "      <td>20170104</td>\n",
       "      <td>10.89</td>\n",
       "      <td>11.03</td>\n",
       "      <td>10.89</td>\n",
       "      <td>11.03</td>\n",
       "      <td>1014600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CHINA</td>\n",
       "      <td>20170104</td>\n",
       "      <td>5.43</td>\n",
       "      <td>5.47</td>\n",
       "      <td>5.43</td>\n",
       "      <td>5.47</td>\n",
       "      <td>156700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>EBANK</td>\n",
       "      <td>20170104</td>\n",
       "      <td>5.30</td>\n",
       "      <td>5.38</td>\n",
       "      <td>5.30</td>\n",
       "      <td>5.38</td>\n",
       "      <td>17200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ECOMM</td>\n",
       "      <td>20170104</td>\n",
       "      <td>7.47</td>\n",
       "      <td>7.54</td>\n",
       "      <td>7.47</td>\n",
       "      <td>7.54</td>\n",
       "      <td>36900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>EFOOD</td>\n",
       "      <td>20170104</td>\n",
       "      <td>6.89</td>\n",
       "      <td>6.89</td>\n",
       "      <td>6.89</td>\n",
       "      <td>6.89</td>\n",
       "      <td>5000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>ENGY</td>\n",
       "      <td>20170104</td>\n",
       "      <td>5.13</td>\n",
       "      <td>5.20</td>\n",
       "      <td>5.13</td>\n",
       "      <td>5.20</td>\n",
       "      <td>24800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>ENY</td>\n",
       "      <td>20170104</td>\n",
       "      <td>5.76</td>\n",
       "      <td>5.84</td>\n",
       "      <td>5.76</td>\n",
       "      <td>5.84</td>\n",
       "      <td>64800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>GLD</td>\n",
       "      <td>20170104</td>\n",
       "      <td>1.80</td>\n",
       "      <td>1.81</td>\n",
       "      <td>1.80</td>\n",
       "      <td>1.81</td>\n",
       "      <td>577100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>TDEX</td>\n",
       "      <td>20170104</td>\n",
       "      <td>9.74</td>\n",
       "      <td>9.78</td>\n",
       "      <td>9.68</td>\n",
       "      <td>9.77</td>\n",
       "      <td>161000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>TGOLDETF</td>\n",
       "      <td>20170104</td>\n",
       "      <td>3.96</td>\n",
       "      <td>3.96</td>\n",
       "      <td>3.94</td>\n",
       "      <td>3.95</td>\n",
       "      <td>116800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2S</td>\n",
       "      <td>20170104</td>\n",
       "      <td>6.90</td>\n",
       "      <td>7.25</td>\n",
       "      <td>6.90</td>\n",
       "      <td>7.05</td>\n",
       "      <td>5382600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>A</td>\n",
       "      <td>20170104</td>\n",
       "      <td>6.30</td>\n",
       "      <td>6.30</td>\n",
       "      <td>6.30</td>\n",
       "      <td>6.30</td>\n",
       "      <td>22000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>AAV</td>\n",
       "      <td>20170104</td>\n",
       "      <td>6.10</td>\n",
       "      <td>6.20</td>\n",
       "      <td>6.05</td>\n",
       "      <td>6.10</td>\n",
       "      <td>17925100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>ABC</td>\n",
       "      <td>20170104</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.36</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.35</td>\n",
       "      <td>9604000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>ABICO</td>\n",
       "      <td>20170104</td>\n",
       "      <td>14.00</td>\n",
       "      <td>14.40</td>\n",
       "      <td>13.90</td>\n",
       "      <td>14.30</td>\n",
       "      <td>7980500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>ABPIF</td>\n",
       "      <td>20170104</td>\n",
       "      <td>8.35</td>\n",
       "      <td>8.35</td>\n",
       "      <td>8.25</td>\n",
       "      <td>8.35</td>\n",
       "      <td>222200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>ACAP</td>\n",
       "      <td>20170104</td>\n",
       "      <td>21.60</td>\n",
       "      <td>21.70</td>\n",
       "      <td>21.00</td>\n",
       "      <td>21.20</td>\n",
       "      <td>2533200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>ACC</td>\n",
       "      <td>20170104</td>\n",
       "      <td>0.69</td>\n",
       "      <td>0.70</td>\n",
       "      <td>0.68</td>\n",
       "      <td>0.69</td>\n",
       "      <td>304300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>ADVANC</td>\n",
       "      <td>20170104</td>\n",
       "      <td>147.00</td>\n",
       "      <td>150.00</td>\n",
       "      <td>147.00</td>\n",
       "      <td>149.50</td>\n",
       "      <td>7239400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>AEC</td>\n",
       "      <td>20170104</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.57</td>\n",
       "      <td>630300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>AEONTS</td>\n",
       "      <td>20170104</td>\n",
       "      <td>106.00</td>\n",
       "      <td>106.00</td>\n",
       "      <td>104.00</td>\n",
       "      <td>104.00</td>\n",
       "      <td>8200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>AF</td>\n",
       "      <td>20170104</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.54</td>\n",
       "      <td>0.54</td>\n",
       "      <td>811900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>AFC</td>\n",
       "      <td>20170104</td>\n",
       "      <td>8.00</td>\n",
       "      <td>8.00</td>\n",
       "      <td>8.00</td>\n",
       "      <td>8.00</td>\n",
       "      <td>700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>AGE</td>\n",
       "      <td>20170104</td>\n",
       "      <td>1.55</td>\n",
       "      <td>1.59</td>\n",
       "      <td>1.55</td>\n",
       "      <td>1.57</td>\n",
       "      <td>4666100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>AH</td>\n",
       "      <td>20170104</td>\n",
       "      <td>16.20</td>\n",
       "      <td>16.30</td>\n",
       "      <td>15.70</td>\n",
       "      <td>16.00</td>\n",
       "      <td>280000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>AHC</td>\n",
       "      <td>20170104</td>\n",
       "      <td>35.50</td>\n",
       "      <td>35.75</td>\n",
       "      <td>35.50</td>\n",
       "      <td>35.75</td>\n",
       "      <td>5000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>AIRA</td>\n",
       "      <td>20170104</td>\n",
       "      <td>2.62</td>\n",
       "      <td>2.62</td>\n",
       "      <td>2.58</td>\n",
       "      <td>2.58</td>\n",
       "      <td>888700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>AIT</td>\n",
       "      <td>20170104</td>\n",
       "      <td>24.70</td>\n",
       "      <td>24.70</td>\n",
       "      <td>24.60</td>\n",
       "      <td>24.60</td>\n",
       "      <td>337300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>AJ</td>\n",
       "      <td>20170104</td>\n",
       "      <td>11.40</td>\n",
       "      <td>11.50</td>\n",
       "      <td>11.20</td>\n",
       "      <td>11.40</td>\n",
       "      <td>594500</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1924</th>\n",
       "      <td>TOPZ17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>78.45</td>\n",
       "      <td>78.45</td>\n",
       "      <td>78.45</td>\n",
       "      <td>78.45</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1925</th>\n",
       "      <td>TPIPLM17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>2.31</td>\n",
       "      <td>2.32</td>\n",
       "      <td>2.29</td>\n",
       "      <td>2.32</td>\n",
       "      <td>18239</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1926</th>\n",
       "      <td>TPIPLU17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>2.35</td>\n",
       "      <td>2.35</td>\n",
       "      <td>2.32</td>\n",
       "      <td>2.32</td>\n",
       "      <td>7748</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1927</th>\n",
       "      <td>TPIPLZ17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>2.33</td>\n",
       "      <td>2.33</td>\n",
       "      <td>2.33</td>\n",
       "      <td>2.33</td>\n",
       "      <td>1400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1928</th>\n",
       "      <td>TRUEH18</td>\n",
       "      <td>20170628</td>\n",
       "      <td>6.30</td>\n",
       "      <td>6.30</td>\n",
       "      <td>6.30</td>\n",
       "      <td>6.30</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1929</th>\n",
       "      <td>TRUEM17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>6.18</td>\n",
       "      <td>6.21</td>\n",
       "      <td>6.17</td>\n",
       "      <td>6.20</td>\n",
       "      <td>3199</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1930</th>\n",
       "      <td>TRUEU17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>6.25</td>\n",
       "      <td>6.26</td>\n",
       "      <td>6.21</td>\n",
       "      <td>6.25</td>\n",
       "      <td>2178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1931</th>\n",
       "      <td>TRUEZ17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>6.27</td>\n",
       "      <td>6.27</td>\n",
       "      <td>6.27</td>\n",
       "      <td>6.27</td>\n",
       "      <td>1600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1932</th>\n",
       "      <td>TTAM17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>9.23</td>\n",
       "      <td>9.24</td>\n",
       "      <td>9.23</td>\n",
       "      <td>9.24</td>\n",
       "      <td>1376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1933</th>\n",
       "      <td>TTAU17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>9.35</td>\n",
       "      <td>9.35</td>\n",
       "      <td>9.30</td>\n",
       "      <td>9.30</td>\n",
       "      <td>582</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1934</th>\n",
       "      <td>TTAZ17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>9.44</td>\n",
       "      <td>9.44</td>\n",
       "      <td>9.44</td>\n",
       "      <td>9.44</td>\n",
       "      <td>1000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1935</th>\n",
       "      <td>TTCLH18</td>\n",
       "      <td>20170628</td>\n",
       "      <td>18.33</td>\n",
       "      <td>18.33</td>\n",
       "      <td>18.33</td>\n",
       "      <td>18.33</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1936</th>\n",
       "      <td>TTCLM17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>17.50</td>\n",
       "      <td>17.77</td>\n",
       "      <td>17.50</td>\n",
       "      <td>17.68</td>\n",
       "      <td>417</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1937</th>\n",
       "      <td>TTCLU17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>17.73</td>\n",
       "      <td>17.96</td>\n",
       "      <td>17.73</td>\n",
       "      <td>17.94</td>\n",
       "      <td>561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1938</th>\n",
       "      <td>TUM17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>21.30</td>\n",
       "      <td>21.30</td>\n",
       "      <td>21.30</td>\n",
       "      <td>21.30</td>\n",
       "      <td>1700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1939</th>\n",
       "      <td>TUU17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>21.41</td>\n",
       "      <td>21.41</td>\n",
       "      <td>21.41</td>\n",
       "      <td>21.41</td>\n",
       "      <td>300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1940</th>\n",
       "      <td>TUZ17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>21.84</td>\n",
       "      <td>21.84</td>\n",
       "      <td>21.84</td>\n",
       "      <td>21.84</td>\n",
       "      <td>1800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1941</th>\n",
       "      <td>TVOU17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>30.50</td>\n",
       "      <td>31.00</td>\n",
       "      <td>30.50</td>\n",
       "      <td>31.00</td>\n",
       "      <td>140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1942</th>\n",
       "      <td>UNIQM17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>19.00</td>\n",
       "      <td>19.00</td>\n",
       "      <td>19.00</td>\n",
       "      <td>19.00</td>\n",
       "      <td>200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1943</th>\n",
       "      <td>UNIQU17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>19.18</td>\n",
       "      <td>19.18</td>\n",
       "      <td>19.18</td>\n",
       "      <td>19.18</td>\n",
       "      <td>1500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1944</th>\n",
       "      <td>UNIQZ17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>18.90</td>\n",
       "      <td>18.90</td>\n",
       "      <td>18.90</td>\n",
       "      <td>18.90</td>\n",
       "      <td>300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1945</th>\n",
       "      <td>USDM17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>33.95</td>\n",
       "      <td>34.00</td>\n",
       "      <td>33.92</td>\n",
       "      <td>33.97</td>\n",
       "      <td>5384</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1946</th>\n",
       "      <td>USDU17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>34.01</td>\n",
       "      <td>34.02</td>\n",
       "      <td>33.98</td>\n",
       "      <td>33.99</td>\n",
       "      <td>1970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1947</th>\n",
       "      <td>VGIU17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>5.56</td>\n",
       "      <td>5.56</td>\n",
       "      <td>5.56</td>\n",
       "      <td>5.56</td>\n",
       "      <td>2000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1948</th>\n",
       "      <td>VNGM17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>12.32</td>\n",
       "      <td>12.32</td>\n",
       "      <td>12.32</td>\n",
       "      <td>12.32</td>\n",
       "      <td>702</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1949</th>\n",
       "      <td>VNGU17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>12.80</td>\n",
       "      <td>12.80</td>\n",
       "      <td>12.80</td>\n",
       "      <td>12.80</td>\n",
       "      <td>800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1950</th>\n",
       "      <td>VNGZ17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>12.60</td>\n",
       "      <td>12.60</td>\n",
       "      <td>12.60</td>\n",
       "      <td>12.60</td>\n",
       "      <td>300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1951</th>\n",
       "      <td>WHAM17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>3.21</td>\n",
       "      <td>3.22</td>\n",
       "      <td>3.16</td>\n",
       "      <td>3.22</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1952</th>\n",
       "      <td>WHAU17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>3.22</td>\n",
       "      <td>3.22</td>\n",
       "      <td>3.22</td>\n",
       "      <td>3.22</td>\n",
       "      <td>4002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1953</th>\n",
       "      <td>WHAZ17</td>\n",
       "      <td>20170628</td>\n",
       "      <td>3.18</td>\n",
       "      <td>3.18</td>\n",
       "      <td>3.18</td>\n",
       "      <td>3.18</td>\n",
       "      <td>700</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>232603 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      <TICKER>  <DTYYYYMMDD>  <OPEN>  <HIGH>   <LOW>  <CLOSE>     <VOL>\n",
       "0         1DIV      20170104   11.77   11.81   11.76    11.81     26000\n",
       "1      BMSCITH      20170104   10.89   11.03   10.89    11.03   1014600\n",
       "2        CHINA      20170104    5.43    5.47    5.43     5.47    156700\n",
       "3        EBANK      20170104    5.30    5.38    5.30     5.38     17200\n",
       "4        ECOMM      20170104    7.47    7.54    7.47     7.54     36900\n",
       "5        EFOOD      20170104    6.89    6.89    6.89     6.89      5000\n",
       "6         ENGY      20170104    5.13    5.20    5.13     5.20     24800\n",
       "7          ENY      20170104    5.76    5.84    5.76     5.84     64800\n",
       "8          GLD      20170104    1.80    1.81    1.80     1.81    577100\n",
       "9         TDEX      20170104    9.74    9.78    9.68     9.77    161000\n",
       "10    TGOLDETF      20170104    3.96    3.96    3.94     3.95    116800\n",
       "11          2S      20170104    6.90    7.25    6.90     7.05   5382600\n",
       "12           A      20170104    6.30    6.30    6.30     6.30     22000\n",
       "13         AAV      20170104    6.10    6.20    6.05     6.10  17925100\n",
       "14         ABC      20170104    0.35    0.36    0.35     0.35   9604000\n",
       "15       ABICO      20170104   14.00   14.40   13.90    14.30   7980500\n",
       "16       ABPIF      20170104    8.35    8.35    8.25     8.35    222200\n",
       "17        ACAP      20170104   21.60   21.70   21.00    21.20   2533200\n",
       "18         ACC      20170104    0.69    0.70    0.68     0.69    304300\n",
       "19      ADVANC      20170104  147.00  150.00  147.00   149.50   7239400\n",
       "20         AEC      20170104    0.57    0.57    0.56     0.57    630300\n",
       "21      AEONTS      20170104  106.00  106.00  104.00   104.00      8200\n",
       "22          AF      20170104    0.56    0.56    0.54     0.54    811900\n",
       "23         AFC      20170104    8.00    8.00    8.00     8.00       700\n",
       "24         AGE      20170104    1.55    1.59    1.55     1.57   4666100\n",
       "25          AH      20170104   16.20   16.30   15.70    16.00    280000\n",
       "26         AHC      20170104   35.50   35.75   35.50    35.75      5000\n",
       "27        AIRA      20170104    2.62    2.62    2.58     2.58    888700\n",
       "28         AIT      20170104   24.70   24.70   24.60    24.60    337300\n",
       "29          AJ      20170104   11.40   11.50   11.20    11.40    594500\n",
       "...        ...           ...     ...     ...     ...      ...       ...\n",
       "1924    TOPZ17      20170628   78.45   78.45   78.45    78.45        20\n",
       "1925  TPIPLM17      20170628    2.31    2.32    2.29     2.32     18239\n",
       "1926  TPIPLU17      20170628    2.35    2.35    2.32     2.32      7748\n",
       "1927  TPIPLZ17      20170628    2.33    2.33    2.33     2.33      1400\n",
       "1928   TRUEH18      20170628    6.30    6.30    6.30     6.30         2\n",
       "1929   TRUEM17      20170628    6.18    6.21    6.17     6.20      3199\n",
       "1930   TRUEU17      20170628    6.25    6.26    6.21     6.25      2178\n",
       "1931   TRUEZ17      20170628    6.27    6.27    6.27     6.27      1600\n",
       "1932    TTAM17      20170628    9.23    9.24    9.23     9.24      1376\n",
       "1933    TTAU17      20170628    9.35    9.35    9.30     9.30       582\n",
       "1934    TTAZ17      20170628    9.44    9.44    9.44     9.44      1000\n",
       "1935   TTCLH18      20170628   18.33   18.33   18.33    18.33       100\n",
       "1936   TTCLM17      20170628   17.50   17.77   17.50    17.68       417\n",
       "1937   TTCLU17      20170628   17.73   17.96   17.73    17.94       561\n",
       "1938     TUM17      20170628   21.30   21.30   21.30    21.30      1700\n",
       "1939     TUU17      20170628   21.41   21.41   21.41    21.41       300\n",
       "1940     TUZ17      20170628   21.84   21.84   21.84    21.84      1800\n",
       "1941    TVOU17      20170628   30.50   31.00   30.50    31.00       140\n",
       "1942   UNIQM17      20170628   19.00   19.00   19.00    19.00       200\n",
       "1943   UNIQU17      20170628   19.18   19.18   19.18    19.18      1500\n",
       "1944   UNIQZ17      20170628   18.90   18.90   18.90    18.90       300\n",
       "1945    USDM17      20170628   33.95   34.00   33.92    33.97      5384\n",
       "1946    USDU17      20170628   34.01   34.02   33.98    33.99      1970\n",
       "1947    VGIU17      20170628    5.56    5.56    5.56     5.56      2000\n",
       "1948    VNGM17      20170628   12.32   12.32   12.32    12.32       702\n",
       "1949    VNGU17      20170628   12.80   12.80   12.80    12.80       800\n",
       "1950    VNGZ17      20170628   12.60   12.60   12.60    12.60       300\n",
       "1951    WHAM17      20170628    3.21    3.22    3.16     3.22         6\n",
       "1952    WHAU17      20170628    3.22    3.22    3.22     3.22      4002\n",
       "1953    WHAZ17      20170628    3.18    3.18    3.18     3.18       700\n",
       "\n",
       "[232603 rows x 7 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": [
    "frame.columns = ['Symbol', 'Date', 'Open', 'High', 'Low', 'Close', 'Volume']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {
    "collapsed": false,
    "run_control": {},
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Applications/Pineapple.app/Contents/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/ipykernel/__main__.py:4: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy\n"
     ]
    },
    {
     "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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</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>2017-01-04</th>\n",
       "      <td>147.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>147.0</td>\n",
       "      <td>149.5</td>\n",
       "      <td>7239400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-05</th>\n",
       "      <td>150.5</td>\n",
       "      <td>154.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>153.5</td>\n",
       "      <td>15745500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-06</th>\n",
       "      <td>154.0</td>\n",
       "      <td>154.0</td>\n",
       "      <td>152.5</td>\n",
       "      <td>152.5</td>\n",
       "      <td>6743100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-09</th>\n",
       "      <td>153.0</td>\n",
       "      <td>153.0</td>\n",
       "      <td>150.5</td>\n",
       "      <td>151.0</td>\n",
       "      <td>5734300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-10</th>\n",
       "      <td>151.0</td>\n",
       "      <td>153.5</td>\n",
       "      <td>151.0</td>\n",
       "      <td>153.0</td>\n",
       "      <td>4839500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-11</th>\n",
       "      <td>153.5</td>\n",
       "      <td>156.5</td>\n",
       "      <td>153.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>12043600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-12</th>\n",
       "      <td>155.5</td>\n",
       "      <td>156.0</td>\n",
       "      <td>153.5</td>\n",
       "      <td>154.0</td>\n",
       "      <td>7291300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-13</th>\n",
       "      <td>154.5</td>\n",
       "      <td>155.5</td>\n",
       "      <td>153.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4884900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-16</th>\n",
       "      <td>154.5</td>\n",
       "      <td>156.5</td>\n",
       "      <td>154.0</td>\n",
       "      <td>155.5</td>\n",
       "      <td>4748500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-17</th>\n",
       "      <td>155.0</td>\n",
       "      <td>156.5</td>\n",
       "      <td>154.5</td>\n",
       "      <td>156.5</td>\n",
       "      <td>5448100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-18</th>\n",
       "      <td>156.5</td>\n",
       "      <td>157.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>4458300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-19</th>\n",
       "      <td>155.0</td>\n",
       "      <td>156.0</td>\n",
       "      <td>154.5</td>\n",
       "      <td>155.0</td>\n",
       "      <td>3779900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-20</th>\n",
       "      <td>155.0</td>\n",
       "      <td>156.5</td>\n",
       "      <td>154.5</td>\n",
       "      <td>155.5</td>\n",
       "      <td>3758100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-23</th>\n",
       "      <td>155.5</td>\n",
       "      <td>156.5</td>\n",
       "      <td>155.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>1846700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-24</th>\n",
       "      <td>155.5</td>\n",
       "      <td>156.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>5032600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-25</th>\n",
       "      <td>155.5</td>\n",
       "      <td>162.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>161.5</td>\n",
       "      <td>17182900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-26</th>\n",
       "      <td>163.5</td>\n",
       "      <td>164.0</td>\n",
       "      <td>161.5</td>\n",
       "      <td>162.5</td>\n",
       "      <td>9659100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-27</th>\n",
       "      <td>162.0</td>\n",
       "      <td>164.5</td>\n",
       "      <td>161.0</td>\n",
       "      <td>163.0</td>\n",
       "      <td>7115000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-30</th>\n",
       "      <td>162.0</td>\n",
       "      <td>163.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>3392600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-01-31</th>\n",
       "      <td>161.0</td>\n",
       "      <td>161.0</td>\n",
       "      <td>158.5</td>\n",
       "      <td>159.0</td>\n",
       "      <td>8637100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-01</th>\n",
       "      <td>158.0</td>\n",
       "      <td>161.0</td>\n",
       "      <td>157.0</td>\n",
       "      <td>160.5</td>\n",
       "      <td>7204700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-02</th>\n",
       "      <td>160.5</td>\n",
       "      <td>161.5</td>\n",
       "      <td>160.0</td>\n",
       "      <td>160.5</td>\n",
       "      <td>2835800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-03</th>\n",
       "      <td>160.0</td>\n",
       "      <td>160.5</td>\n",
       "      <td>159.0</td>\n",
       "      <td>160.5</td>\n",
       "      <td>4846300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-06</th>\n",
       "      <td>160.5</td>\n",
       "      <td>162.0</td>\n",
       "      <td>158.5</td>\n",
       "      <td>161.5</td>\n",
       "      <td>9702200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-07</th>\n",
       "      <td>161.5</td>\n",
       "      <td>164.5</td>\n",
       "      <td>161.0</td>\n",
       "      <td>163.5</td>\n",
       "      <td>11256600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-08</th>\n",
       "      <td>164.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>163.5</td>\n",
       "      <td>170.5</td>\n",
       "      <td>28107900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-09</th>\n",
       "      <td>169.5</td>\n",
       "      <td>171.5</td>\n",
       "      <td>169.5</td>\n",
       "      <td>170.0</td>\n",
       "      <td>11464400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-10</th>\n",
       "      <td>170.5</td>\n",
       "      <td>171.0</td>\n",
       "      <td>168.5</td>\n",
       "      <td>169.0</td>\n",
       "      <td>13558500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-14</th>\n",
       "      <td>170.0</td>\n",
       "      <td>170.5</td>\n",
       "      <td>169.0</td>\n",
       "      <td>169.5</td>\n",
       "      <td>17601000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-02-15</th>\n",
       "      <td>168.5</td>\n",
       "      <td>170.5</td>\n",
       "      <td>168.0</td>\n",
       "      <td>169.0</td>\n",
       "      <td>19782400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-18</th>\n",
       "      <td>179.0</td>\n",
       "      <td>180.0</td>\n",
       "      <td>178.5</td>\n",
       "      <td>179.5</td>\n",
       "      <td>4287500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-19</th>\n",
       "      <td>179.5</td>\n",
       "      <td>180.0</td>\n",
       "      <td>179.0</td>\n",
       "      <td>179.5</td>\n",
       "      <td>4151300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-22</th>\n",
       "      <td>178.0</td>\n",
       "      <td>178.5</td>\n",
       "      <td>177.0</td>\n",
       "      <td>178.5</td>\n",
       "      <td>5313800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-23</th>\n",
       "      <td>178.0</td>\n",
       "      <td>179.0</td>\n",
       "      <td>177.5</td>\n",
       "      <td>177.5</td>\n",
       "      <td>3993400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-24</th>\n",
       "      <td>177.5</td>\n",
       "      <td>179.0</td>\n",
       "      <td>177.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>8098700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-25</th>\n",
       "      <td>178.0</td>\n",
       "      <td>178.5</td>\n",
       "      <td>177.0</td>\n",
       "      <td>177.5</td>\n",
       "      <td>3833200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-26</th>\n",
       "      <td>177.5</td>\n",
       "      <td>178.0</td>\n",
       "      <td>177.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>3968800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-29</th>\n",
       "      <td>177.5</td>\n",
       "      <td>178.5</td>\n",
       "      <td>177.5</td>\n",
       "      <td>178.0</td>\n",
       "      <td>3063600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-30</th>\n",
       "      <td>178.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>177.0</td>\n",
       "      <td>177.0</td>\n",
       "      <td>2765100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-05-31</th>\n",
       "      <td>177.5</td>\n",
       "      <td>178.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>14727500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-01</th>\n",
       "      <td>173.5</td>\n",
       "      <td>174.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>173.5</td>\n",
       "      <td>4857800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-02</th>\n",
       "      <td>173.5</td>\n",
       "      <td>175.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>174.5</td>\n",
       "      <td>5941300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-05</th>\n",
       "      <td>174.0</td>\n",
       "      <td>174.5</td>\n",
       "      <td>170.0</td>\n",
       "      <td>171.0</td>\n",
       "      <td>17782400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-06</th>\n",
       "      <td>171.0</td>\n",
       "      <td>173.5</td>\n",
       "      <td>169.5</td>\n",
       "      <td>172.5</td>\n",
       "      <td>12264700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-07</th>\n",
       "      <td>172.5</td>\n",
       "      <td>174.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>172.5</td>\n",
       "      <td>3896100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-08</th>\n",
       "      <td>173.0</td>\n",
       "      <td>173.5</td>\n",
       "      <td>171.5</td>\n",
       "      <td>173.0</td>\n",
       "      <td>7072600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-09</th>\n",
       "      <td>174.0</td>\n",
       "      <td>174.5</td>\n",
       "      <td>173.0</td>\n",
       "      <td>173.5</td>\n",
       "      <td>6487900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-12</th>\n",
       "      <td>174.0</td>\n",
       "      <td>174.0</td>\n",
       "      <td>171.5</td>\n",
       "      <td>172.5</td>\n",
       "      <td>2358900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-13</th>\n",
       "      <td>172.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>172.0</td>\n",
       "      <td>173.0</td>\n",
       "      <td>4711500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-14</th>\n",
       "      <td>173.0</td>\n",
       "      <td>174.5</td>\n",
       "      <td>172.5</td>\n",
       "      <td>174.5</td>\n",
       "      <td>3261200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-15</th>\n",
       "      <td>173.5</td>\n",
       "      <td>174.5</td>\n",
       "      <td>173.5</td>\n",
       "      <td>173.5</td>\n",
       "      <td>2159200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-16</th>\n",
       "      <td>173.5</td>\n",
       "      <td>174.0</td>\n",
       "      <td>172.5</td>\n",
       "      <td>173.5</td>\n",
       "      <td>4316600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-19</th>\n",
       "      <td>174.0</td>\n",
       "      <td>175.5</td>\n",
       "      <td>173.5</td>\n",
       "      <td>175.5</td>\n",
       "      <td>3657200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-20</th>\n",
       "      <td>175.5</td>\n",
       "      <td>176.0</td>\n",
       "      <td>175.0</td>\n",
       "      <td>175.5</td>\n",
       "      <td>1955100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-21</th>\n",
       "      <td>174.5</td>\n",
       "      <td>177.5</td>\n",
       "      <td>174.5</td>\n",
       "      <td>177.5</td>\n",
       "      <td>7936900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-22</th>\n",
       "      <td>178.0</td>\n",
       "      <td>179.5</td>\n",
       "      <td>178.0</td>\n",
       "      <td>179.0</td>\n",
       "      <td>8482700</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-23</th>\n",
       "      <td>179.5</td>\n",
       "      <td>180.5</td>\n",
       "      <td>179.0</td>\n",
       "      <td>179.5</td>\n",
       "      <td>5066900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-26</th>\n",
       "      <td>179.5</td>\n",
       "      <td>180.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>178.5</td>\n",
       "      <td>1976100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-27</th>\n",
       "      <td>178.5</td>\n",
       "      <td>179.0</td>\n",
       "      <td>178.0</td>\n",
       "      <td>178.5</td>\n",
       "      <td>1962800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2017-06-28</th>\n",
       "      <td>178.5</td>\n",
       "      <td>179.0</td>\n",
       "      <td>176.0</td>\n",
       "      <td>177.0</td>\n",
       "      <td>3639600</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>120 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Open   High    Low  Close    Volume\n",
       "Date                                            \n",
       "2017-01-04  147.0  150.0  147.0  149.5   7239400\n",
       "2017-01-05  150.5  154.0  150.0  153.5  15745500\n",
       "2017-01-06  154.0  154.0  152.5  152.5   6743100\n",
       "2017-01-09  153.0  153.0  150.5  151.0   5734300\n",
       "2017-01-10  151.0  153.5  151.0  153.0   4839500\n",
       "2017-01-11  153.5  156.5  153.0  155.0  12043600\n",
       "2017-01-12  155.5  156.0  153.5  154.0   7291300\n",
       "2017-01-13  154.5  155.5  153.0  155.0   4884900\n",
       "2017-01-16  154.5  156.5  154.0  155.5   4748500\n",
       "2017-01-17  155.0  156.5  154.5  156.5   5448100\n",
       "2017-01-18  156.5  157.0  155.0  155.0   4458300\n",
       "2017-01-19  155.0  156.0  154.5  155.0   3779900\n",
       "2017-01-20  155.0  156.5  154.5  155.5   3758100\n",
       "2017-01-23  155.5  156.5  155.0  155.0   1846700\n",
       "2017-01-24  155.5  156.0  155.0  155.0   5032600\n",
       "2017-01-25  155.5  162.0  155.0  161.5  17182900\n",
       "2017-01-26  163.5  164.0  161.5  162.5   9659100\n",
       "2017-01-27  162.0  164.5  161.0  163.0   7115000\n",
       "2017-01-30  162.0  163.0  162.0  162.0   3392600\n",
       "2017-01-31  161.0  161.0  158.5  159.0   8637100\n",
       "2017-02-01  158.0  161.0  157.0  160.5   7204700\n",
       "2017-02-02  160.5  161.5  160.0  160.5   2835800\n",
       "2017-02-03  160.0  160.5  159.0  160.5   4846300\n",
       "2017-02-06  160.5  162.0  158.5  161.5   9702200\n",
       "2017-02-07  161.5  164.5  161.0  163.5  11256600\n",
       "2017-02-08  164.0  171.0  163.5  170.5  28107900\n",
       "2017-02-09  169.5  171.5  169.5  170.0  11464400\n",
       "2017-02-10  170.5  171.0  168.5  169.0  13558500\n",
       "2017-02-14  170.0  170.5  169.0  169.5  17601000\n",
       "2017-02-15  168.5  170.5  168.0  169.0  19782400\n",
       "...           ...    ...    ...    ...       ...\n",
       "2017-05-18  179.0  180.0  178.5  179.5   4287500\n",
       "2017-05-19  179.5  180.0  179.0  179.5   4151300\n",
       "2017-05-22  178.0  178.5  177.0  178.5   5313800\n",
       "2017-05-23  178.0  179.0  177.5  177.5   3993400\n",
       "2017-05-24  177.5  179.0  177.0  178.0   8098700\n",
       "2017-05-25  178.0  178.5  177.0  177.5   3833200\n",
       "2017-05-26  177.5  178.0  177.0  178.0   3968800\n",
       "2017-05-29  177.5  178.5  177.5  178.0   3063600\n",
       "2017-05-30  178.0  178.0  177.0  177.0   2765100\n",
       "2017-05-31  177.5  178.0  173.0  173.0  14727500\n",
       "2017-06-01  173.5  174.0  172.0  173.5   4857800\n",
       "2017-06-02  173.5  175.0  173.0  174.5   5941300\n",
       "2017-06-05  174.0  174.5  170.0  171.0  17782400\n",
       "2017-06-06  171.0  173.5  169.5  172.5  12264700\n",
       "2017-06-07  172.5  174.0  172.0  172.5   3896100\n",
       "2017-06-08  173.0  173.5  171.5  173.0   7072600\n",
       "2017-06-09  174.0  174.5  173.0  173.5   6487900\n",
       "2017-06-12  174.0  174.0  171.5  172.5   2358900\n",
       "2017-06-13  172.0  173.0  172.0  173.0   4711500\n",
       "2017-06-14  173.0  174.5  172.5  174.5   3261200\n",
       "2017-06-15  173.5  174.5  173.5  173.5   2159200\n",
       "2017-06-16  173.5  174.0  172.5  173.5   4316600\n",
       "2017-06-19  174.0  175.5  173.5  175.5   3657200\n",
       "2017-06-20  175.5  176.0  175.0  175.5   1955100\n",
       "2017-06-21  174.5  177.5  174.5  177.5   7936900\n",
       "2017-06-22  178.0  179.5  178.0  179.0   8482700\n",
       "2017-06-23  179.5  180.5  179.0  179.5   5066900\n",
       "2017-06-26  179.5  180.0  178.0  178.5   1976100\n",
       "2017-06-27  178.5  179.0  178.0  178.5   1962800\n",
       "2017-06-28  178.5  179.0  176.0  177.0   3639600\n",
       "\n",
       "[120 rows x 5 columns]"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "name = 'ADVANC'\n",
    "stock = frame.loc[frame['Symbol'] == name]\n",
    "#stock = stock.sort_values(by='Date')\n",
    "stock['Date'] = pd.to_datetime(stock['Date'], format='%Y%m%d')\n",
    "stock = stock.set_index('Date')\n",
    "del stock['Symbol']\n",
    "stock\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true,
    "run_control": {}
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "button": false,
    "collapsed": true,
    "deletable": true,
    "new_sheet": false,
    "run_control": {
     "read_only": false
    }
   },
   "outputs": [],
   "source": []
  }
 ],
 "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.5.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}