05_SimpleStock_ReadWriteCSV.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "source": [
        "# Read CSV in R"
      ],
      "metadata": {}
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Current working directory"
      ],
      "metadata": {}
    },
    {
      "cell_type": "code",
      "source": [
        "print(getwd())"
      ],
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "[1] \"C:/Users/Tin Hang/Desktop/WorkingOnPython/SimpleStocksR\"\n"
          ]
        }
      ],
      "execution_count": 1,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "data <- read.csv(\"AAPL.csv\")"
      ],
      "outputs": [],
      "execution_count": 2,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "head(data)"
      ],
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<table>\n",
              "<caption>A data.frame: 6 × 7</caption>\n",
              "<thead>\n",
              "\t<tr><th scope=col>Date</th><th scope=col>Open</th><th scope=col>High</th><th scope=col>Low</th><th scope=col>Close</th><th scope=col>Adj.Close</th><th scope=col>Volume</th></tr>\n",
              "\t<tr><th scope=col>&lt;fct&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;int&gt;</th></tr>\n",
              "</thead>\n",
              "<tbody>\n",
              "\t<tr><td>2016-01-04</td><td>102.61</td><td>105.37</td><td>102.00</td><td>105.35</td><td>99.49911</td><td>67649400</td></tr>\n",
              "\t<tr><td>2016-01-05</td><td>105.75</td><td>105.85</td><td>102.41</td><td>102.71</td><td>97.00573</td><td>55791000</td></tr>\n",
              "\t<tr><td>2016-01-06</td><td>100.56</td><td>102.37</td><td> 99.87</td><td>100.70</td><td>95.10736</td><td>68457400</td></tr>\n",
              "\t<tr><td>2016-01-07</td><td> 98.68</td><td>100.13</td><td> 96.43</td><td> 96.45</td><td>91.09340</td><td>81094400</td></tr>\n",
              "\t<tr><td>2016-01-08</td><td> 98.55</td><td> 99.11</td><td> 96.76</td><td> 96.96</td><td>91.57507</td><td>70798000</td></tr>\n",
              "\t<tr><td>2016-01-11</td><td> 98.97</td><td> 99.06</td><td> 97.34</td><td> 98.53</td><td>93.05787</td><td>49739400</td></tr>\n",
              "</tbody>\n",
              "</table>\n"
            ],
            "text/markdown": [
              "\n",
              "A data.frame: 6 × 7\n",
              "\n",
              "| Date &lt;fct&gt; | Open &lt;dbl&gt; | High &lt;dbl&gt; | Low &lt;dbl&gt; | Close &lt;dbl&gt; | Adj.Close &lt;dbl&gt; | Volume &lt;int&gt; |\n",
              "|---|---|---|---|---|---|---|\n",
              "| 2016-01-04 | 102.61 | 105.37 | 102.00 | 105.35 | 99.49911 | 67649400 |\n",
              "| 2016-01-05 | 105.75 | 105.85 | 102.41 | 102.71 | 97.00573 | 55791000 |\n",
              "| 2016-01-06 | 100.56 | 102.37 |  99.87 | 100.70 | 95.10736 | 68457400 |\n",
              "| 2016-01-07 |  98.68 | 100.13 |  96.43 |  96.45 | 91.09340 | 81094400 |\n",
              "| 2016-01-08 |  98.55 |  99.11 |  96.76 |  96.96 | 91.57507 | 70798000 |\n",
              "| 2016-01-11 |  98.97 |  99.06 |  97.34 |  98.53 | 93.05787 | 49739400 |\n",
              "\n"
            ],
            "text/latex": [
              "A data.frame: 6 × 7\n",
              "\\begin{tabular}{r|lllllll}\n",
              " Date & Open & High & Low & Close & Adj.Close & Volume\\\\\n",
              " <fct> & <dbl> & <dbl> & <dbl> & <dbl> & <dbl> & <int>\\\\\n",
              "\\hline\n",
              "\t 2016-01-04 & 102.61 & 105.37 & 102.00 & 105.35 & 99.49911 & 67649400\\\\\n",
              "\t 2016-01-05 & 105.75 & 105.85 & 102.41 & 102.71 & 97.00573 & 55791000\\\\\n",
              "\t 2016-01-06 & 100.56 & 102.37 &  99.87 & 100.70 & 95.10736 & 68457400\\\\\n",
              "\t 2016-01-07 &  98.68 & 100.13 &  96.43 &  96.45 & 91.09340 & 81094400\\\\\n",
              "\t 2016-01-08 &  98.55 &  99.11 &  96.76 &  96.96 & 91.57507 & 70798000\\\\\n",
              "\t 2016-01-11 &  98.97 &  99.06 &  97.34 &  98.53 & 93.05787 & 49739400\\\\\n",
              "\\end{tabular}\n"
            ],
            "text/plain": [
              "  Date       Open   High   Low    Close  Adj.Close Volume  \n",
              "1 2016-01-04 102.61 105.37 102.00 105.35 99.49911  67649400\n",
              "2 2016-01-05 105.75 105.85 102.41 102.71 97.00573  55791000\n",
              "3 2016-01-06 100.56 102.37  99.87 100.70 95.10736  68457400\n",
              "4 2016-01-07  98.68 100.13  96.43  96.45 91.09340  81094400\n",
              "5 2016-01-08  98.55  99.11  96.76  96.96 91.57507  70798000\n",
              "6 2016-01-11  98.97  99.06  97.34  98.53 93.05787  49739400"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 3,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "is.data.frame(data)"
      ],
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "TRUE"
            ],
            "text/markdown": [
              "TRUE"
            ],
            "text/latex": [
              "TRUE"
            ],
            "text/plain": [
              "[1] TRUE"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 4,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Check how many columns\n",
        "ncol(data)"
      ],
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "7"
            ],
            "text/markdown": [
              "7"
            ],
            "text/latex": [
              "7"
            ],
            "text/plain": [
              "[1] 7"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 5,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Check how many rows\n",
        "nrow(data)"
      ],
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "754"
            ],
            "text/markdown": [
              "754"
            ],
            "text/latex": [
              "754"
            ],
            "text/plain": [
              "[1] 754"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 6,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Find the max closing price\n",
        "max(data$Adj.Close)"
      ],
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "230.275482"
            ],
            "text/markdown": [
              "230.275482"
            ],
            "text/latex": [
              "230.275482"
            ],
            "text/plain": [
              "[1] 230.2755"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 7,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Find the min closing price\n",
        "max(data$Adj.Close)"
      ],
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "230.275482"
            ],
            "text/markdown": [
              "230.275482"
            ],
            "text/latex": [
              "230.275482"
            ],
            "text/plain": [
              "[1] 230.2755"
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 8,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Add Typical Price in the data frame\n",
        "# Sum of rows in certain columns and divide by 3\n",
        "data$TypicalPrice <- rowSums(data[,c(\"High\", \"Low\", \"Adj.Close\")]/3, na.rm=TRUE)"
      ],
      "outputs": [],
      "execution_count": 9,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "head(data)"
      ],
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<table>\n",
              "<caption>A data.frame: 6 × 8</caption>\n",
              "<thead>\n",
              "\t<tr><th scope=col>Date</th><th scope=col>Open</th><th scope=col>High</th><th scope=col>Low</th><th scope=col>Close</th><th scope=col>Adj.Close</th><th scope=col>Volume</th><th scope=col>TypicalPrice</th></tr>\n",
              "\t<tr><th scope=col>&lt;fct&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;dbl&gt;</th><th scope=col>&lt;int&gt;</th><th scope=col>&lt;dbl&gt;</th></tr>\n",
              "</thead>\n",
              "<tbody>\n",
              "\t<tr><td>2016-01-04</td><td>102.61</td><td>105.37</td><td>102.00</td><td>105.35</td><td>99.49911</td><td>67649400</td><td>102.28970</td></tr>\n",
              "\t<tr><td>2016-01-05</td><td>105.75</td><td>105.85</td><td>102.41</td><td>102.71</td><td>97.00573</td><td>55791000</td><td>101.75524</td></tr>\n",
              "\t<tr><td>2016-01-06</td><td>100.56</td><td>102.37</td><td> 99.87</td><td>100.70</td><td>95.10736</td><td>68457400</td><td> 99.11579</td></tr>\n",
              "\t<tr><td>2016-01-07</td><td> 98.68</td><td>100.13</td><td> 96.43</td><td> 96.45</td><td>91.09340</td><td>81094400</td><td> 95.88447</td></tr>\n",
              "\t<tr><td>2016-01-08</td><td> 98.55</td><td> 99.11</td><td> 96.76</td><td> 96.96</td><td>91.57507</td><td>70798000</td><td> 95.81503</td></tr>\n",
              "\t<tr><td>2016-01-11</td><td> 98.97</td><td> 99.06</td><td> 97.34</td><td> 98.53</td><td>93.05787</td><td>49739400</td><td> 96.48595</td></tr>\n",
              "</tbody>\n",
              "</table>\n"
            ],
            "text/markdown": [
              "\n",
              "A data.frame: 6 × 8\n",
              "\n",
              "| Date &lt;fct&gt; | Open &lt;dbl&gt; | High &lt;dbl&gt; | Low &lt;dbl&gt; | Close &lt;dbl&gt; | Adj.Close &lt;dbl&gt; | Volume &lt;int&gt; | TypicalPrice &lt;dbl&gt; |\n",
              "|---|---|---|---|---|---|---|---|\n",
              "| 2016-01-04 | 102.61 | 105.37 | 102.00 | 105.35 | 99.49911 | 67649400 | 102.28970 |\n",
              "| 2016-01-05 | 105.75 | 105.85 | 102.41 | 102.71 | 97.00573 | 55791000 | 101.75524 |\n",
              "| 2016-01-06 | 100.56 | 102.37 |  99.87 | 100.70 | 95.10736 | 68457400 |  99.11579 |\n",
              "| 2016-01-07 |  98.68 | 100.13 |  96.43 |  96.45 | 91.09340 | 81094400 |  95.88447 |\n",
              "| 2016-01-08 |  98.55 |  99.11 |  96.76 |  96.96 | 91.57507 | 70798000 |  95.81503 |\n",
              "| 2016-01-11 |  98.97 |  99.06 |  97.34 |  98.53 | 93.05787 | 49739400 |  96.48595 |\n",
              "\n"
            ],
            "text/latex": [
              "A data.frame: 6 × 8\n",
              "\\begin{tabular}{r|llllllll}\n",
              " Date & Open & High & Low & Close & Adj.Close & Volume & TypicalPrice\\\\\n",
              " <fct> & <dbl> & <dbl> & <dbl> & <dbl> & <dbl> & <int> & <dbl>\\\\\n",
              "\\hline\n",
              "\t 2016-01-04 & 102.61 & 105.37 & 102.00 & 105.35 & 99.49911 & 67649400 & 102.28970\\\\\n",
              "\t 2016-01-05 & 105.75 & 105.85 & 102.41 & 102.71 & 97.00573 & 55791000 & 101.75524\\\\\n",
              "\t 2016-01-06 & 100.56 & 102.37 &  99.87 & 100.70 & 95.10736 & 68457400 &  99.11579\\\\\n",
              "\t 2016-01-07 &  98.68 & 100.13 &  96.43 &  96.45 & 91.09340 & 81094400 &  95.88447\\\\\n",
              "\t 2016-01-08 &  98.55 &  99.11 &  96.76 &  96.96 & 91.57507 & 70798000 &  95.81503\\\\\n",
              "\t 2016-01-11 &  98.97 &  99.06 &  97.34 &  98.53 & 93.05787 & 49739400 &  96.48595\\\\\n",
              "\\end{tabular}\n"
            ],
            "text/plain": [
              "  Date       Open   High   Low    Close  Adj.Close Volume   TypicalPrice\n",
              "1 2016-01-04 102.61 105.37 102.00 105.35 99.49911  67649400 102.28970   \n",
              "2 2016-01-05 105.75 105.85 102.41 102.71 97.00573  55791000 101.75524   \n",
              "3 2016-01-06 100.56 102.37  99.87 100.70 95.10736  68457400  99.11579   \n",
              "4 2016-01-07  98.68 100.13  96.43  96.45 91.09340  81094400  95.88447   \n",
              "5 2016-01-08  98.55  99.11  96.76  96.96 91.57507  70798000  95.81503   \n",
              "6 2016-01-11  98.97  99.06  97.34  98.53 93.05787  49739400  96.48595   "
            ]
          },
          "metadata": {}
        }
      ],
      "execution_count": 10,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Save new data to CSV\n",
        "write.csv(data,\"NewAAPL.csv\", row.names = FALSE)\n",
        "newdata <- read.csv(\"NewAAPL.csv\")\n",
        "print(newdata)"
      ],
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "          Date   Open   High    Low  Close Adj.Close    Volume TypicalPrice\n",
            "1   2016-01-04 102.61 105.37 102.00 105.35  99.49911  67649400    102.28970\n",
            "2   2016-01-05 105.75 105.85 102.41 102.71  97.00573  55791000    101.75524\n",
            "3   2016-01-06 100.56 102.37  99.87 100.70  95.10736  68457400     99.11579\n",
            "4   2016-01-07  98.68 100.13  96.43  96.45  91.09340  81094400     95.88447\n",
            "5   2016-01-08  98.55  99.11  96.76  96.96  91.57507  70798000     95.81503\n",
            "6   2016-01-11  98.97  99.06  97.34  98.53  93.05787  49739400     96.48595\n",
            "7   2016-01-12 100.55 100.69  98.84  99.96  94.40845  49154200     97.97948\n",
            "8   2016-01-13 100.32 101.19  97.30  97.39  91.98119  62439600     96.82373\n",
            "9   2016-01-14  97.96 100.48  95.74  99.52  93.99289  63170100     96.73763\n",
            "10  2016-01-15  96.20  97.71  95.36  97.13  91.73563  79010000     94.93521\n",
            "11  2016-01-19  98.41  98.65  95.50  96.66  91.29172  53087700     95.14724\n",
            "12  2016-01-20  95.10  98.19  93.42  96.79  91.41452  72334400     94.34151\n",
            "13  2016-01-21  97.06  97.88  94.94  96.30  90.95174  52161500     94.59058\n",
            "14  2016-01-22  98.63 101.46  98.37 101.42  95.78737  65800500     98.53912\n",
            "15  2016-01-25 101.52 101.53  99.21  99.44  93.91734  51794500     98.21911\n",
            "16  2016-01-26  99.93 100.88  98.07  99.99  94.43679  75077000     97.79560\n",
            "17  2016-01-27  96.04  96.63  93.34  93.42  88.23166 133369700     92.73388\n",
            "18  2016-01-28  93.79  94.52  92.39  94.09  88.86445  55678800     91.92481\n",
            "19  2016-01-29  94.79  97.34  94.35  97.34  91.93396  64416500     94.54132\n",
            "20  2016-02-01  96.47  96.71  95.40  96.43  91.07450  40943500     94.39483\n",
            "21  2016-02-02  95.42  96.04  94.28  94.48  89.23280  37357200     93.18427\n",
            "22  2016-02-03  95.00  96.84  94.08  96.35  90.99893  45964300     93.97298\n",
            "23  2016-02-04  95.86  97.33  95.19  96.60  91.73011  46471700     94.75004\n",
            "24  2016-02-05  96.52  96.92  93.69  94.02  89.28019  46418100     93.29673\n",
            "25  2016-02-08  93.13  95.70  93.04  95.01  90.22028  54021400     92.98676\n",
            "26  2016-02-09  94.29  95.94  93.93  94.99  90.20129  44331200     93.35710\n",
            "27  2016-02-10  95.92  96.35  94.10  94.27  89.51759  42343600     93.32253\n",
            "28  2016-02-11  93.79  94.72  92.59  93.70  88.97632  50074700     92.09544\n",
            "29  2016-02-12  94.19  94.50  93.01  93.99  89.25169  40351400     92.25390\n",
            "30  2016-02-16  95.02  96.85  94.61  96.64  91.76809  49057900     94.40936\n",
            "31  2016-02-17  96.67  98.21  96.15  98.12  93.17351  44863200     95.84450\n",
            "32  2016-02-18  98.84  98.89  96.09  96.26  91.40727  39021000     95.46242\n",
            "33  2016-02-19  96.00  96.76  95.80  96.04  91.19834  35374200     94.58612\n",
            "34  2016-02-22  96.31  96.90  95.92  96.88  91.99599  34280800     94.93867\n",
            "35  2016-02-23  96.40  96.50  94.55  94.69  89.91642  31942600     93.65547\n",
            "36  2016-02-24  93.98  96.38  93.32  96.10  91.25533  36255700     93.65178\n",
            "37  2016-02-25  96.05  96.76  95.25  96.76  91.88206  27582700     94.63069\n",
            "38  2016-02-26  97.20  98.02  96.58  96.91  92.02449  28991100     95.54150\n",
            "39  2016-02-29  96.86  98.23  96.65  96.69  91.81560  35216300     95.56520\n",
            "40  2016-03-01  97.65 100.77  97.42 100.53  95.46200  50407100     97.88400\n",
            "41  2016-03-02 100.51 100.89  99.64 100.75  95.67091  33169600     98.73364\n",
            "42  2016-03-03 100.58 101.71 100.45 101.50  96.38309  36955700     99.51436\n",
            "43  2016-03-04 102.37 103.75 101.37 103.01  97.81699  46055100    100.97900\n",
            "44  2016-03-07 102.39 102.83 100.96 101.87  96.73444  35828900    100.17481\n",
            "45  2016-03-08 100.78 101.76 100.40 101.03  95.93680  31561900     99.36560\n",
            "46  2016-03-09 101.31 101.58 100.27 101.12  96.02226  27201700     99.29075\n",
            "47  2016-03-10 101.41 102.24 100.15 101.17  96.06973  33513600     99.48658\n",
            "48  2016-03-11 102.24 102.28 101.50 102.26  97.10480  27408200    100.29493\n",
            "49  2016-03-14 101.91 102.91 101.78 102.52  97.35168  25076100    100.68056\n",
            "50  2016-03-15 103.96 105.18 103.85 104.58  99.30783  40067700    102.77928\n",
            "51  2016-03-16 104.61 106.31 104.59 105.97 100.62776  38303500    103.84259\n",
            "52  2016-03-17 105.52 106.47 104.96 105.80 100.46632  34420700    103.96544\n",
            "53  2016-03-18 106.34 106.50 105.19 105.92 100.58028  44205200    104.09009\n",
            "54  2016-03-21 105.93 107.65 105.14 105.91 100.57078  35502700    104.45359\n",
            "55  2016-03-22 105.25 107.29 105.21 106.72 101.33994  32444400    104.61331\n",
            "56  2016-03-23 106.48 107.07 105.90 106.13 100.77969  25703500    104.58323\n",
            "57  2016-03-24 105.47 106.25 104.89 105.67 100.34287  26133000    103.82762\n",
            "58  2016-03-28 106.00 106.19 105.06 105.19  99.88709  19411400    103.71236\n",
            "59  2016-03-29 104.89 107.79 104.88 107.68 102.25156  31190100    104.97385\n",
            "60  2016-03-30 108.65 110.42 108.60 109.56 104.03676  45601100    107.68558\n",
            "61  2016-03-31 109.72 109.90 108.88 108.99 103.49551  25888400    107.42517\n",
            "62  2016-04-01 108.78 110.00 108.20 109.99 104.44509  25874000    107.54836\n",
            "63  2016-04-04 110.42 112.19 110.27 111.12 105.51813  37356200    109.32604\n",
            "64  2016-04-05 109.51 110.73 109.42 109.81 104.27416  26578700    108.14139\n",
            "65  2016-04-06 110.23 110.98 109.20 110.96 105.36620  26404100    108.51540\n",
            "66  2016-04-07 109.95 110.42 108.12 108.54 103.06819  31801900    107.20273\n",
            "67  2016-04-08 108.91 109.77 108.17 108.66 103.18214  23581700    107.04071\n",
            "68  2016-04-11 108.97 110.61 108.83 109.02 103.52399  29407500    107.65466\n",
            "69  2016-04-12 109.34 110.50 108.66 110.44 104.87241  27232300    108.01080\n",
            "70  2016-04-13 110.80 112.34 110.80 112.04 106.39175  33257300    109.84392\n",
            "71  2016-04-14 111.62 112.39 111.33 112.10 106.44872  25473900    110.05624\n",
            "72  2016-04-15 112.11 112.30 109.73 109.85 104.31215  46939000    108.78072\n",
            "73  2016-04-18 108.89 108.95 106.94 107.48 102.06164  60834000    105.98388\n",
            "74  2016-04-19 107.88 108.00 106.23 106.91 101.52037  32384900    105.25012\n",
            "75  2016-04-20 106.64 108.09 106.06 107.13 101.72928  30611000    105.29309\n",
            "76  2016-04-21 106.93 106.93 105.52 105.97 100.62776  31552500    104.35925\n",
            "77  2016-04-22 105.01 106.48 104.62 105.68 100.35237  33683100    103.81746\n",
            "78  2016-04-25 105.00 105.65 104.51 105.08  99.78263  28031600    103.31421\n",
            "79  2016-04-26 103.91 105.30 103.91 104.35  99.08941  56016200    102.76647\n",
            "80  2016-04-27  96.00  98.71  95.68  97.82  92.88863 114602100     95.75954\n",
            "81  2016-04-28  97.61  97.88  94.25  94.83  90.04936  82242700     94.05979\n",
            "82  2016-04-29  93.99  94.72  92.51  93.74  89.01430  68531500     92.08143\n",
            "83  2016-05-02  93.97  94.08  92.40  93.64  88.91933  48160100     91.79978\n",
            "84  2016-05-03  94.20  95.74  93.68  95.18  90.38171  56831300     93.26724\n",
            "85  2016-05-04  95.20  95.90  93.82  94.19  89.44161  41025500     93.05387\n",
            "86  2016-05-05  94.00  94.07  92.68  93.24  89.07858  35890500     91.94286\n",
            "87  2016-05-06  93.37  93.45  91.85  92.72  88.58179  43458200     91.29393\n",
            "88  2016-05-09  93.00  93.77  92.59  92.79  88.64865  32936400     91.66955\n",
            "89  2016-05-10  93.33  93.57  92.11  93.42  89.25054  33686800     91.64351\n",
            "90  2016-05-11  93.48  93.57  92.46  92.51  88.38116  28719100     91.47039\n",
            "91  2016-05-12  92.72  92.78  89.47  90.34  86.30801  76314700     89.51934\n",
            "92  2016-05-13  90.00  91.67  90.00  90.52  86.47997  44392800     89.38332\n",
            "93  2016-05-16  92.39  94.39  91.65  93.88  89.69002  61259800     91.91001\n",
            "94  2016-05-17  94.55  94.70  93.01  93.49  89.31741  46916900     92.34247\n",
            "95  2016-05-18  94.16  95.21  93.89  94.56  90.33968  42062400     93.14656\n",
            "96  2016-05-19  94.64  94.64  93.57  94.20  89.99573  30442100     92.73524\n",
            "97  2016-05-20  94.64  95.43  94.52  95.22  90.97021  32026000     93.64007\n",
            "98  2016-05-23  95.87  97.19  95.67  96.43  92.12620  38018600     94.99540\n",
            "99  2016-05-24  97.22  98.09  96.84  97.90  93.53061  35140200     96.15353\n",
            "100 2016-05-25  98.67  99.74  98.11  99.62  95.17383  38168800     97.67461\n",
            "101 2016-05-26  99.68 100.73  98.64 100.41  95.92857  56331200     98.43286\n",
            "102 2016-05-27  99.44 100.47  99.25 100.35  95.87124  36229500     98.53041\n",
            "103 2016-05-31  99.60 100.40  98.82  99.86  95.40312  42307200     98.20771\n",
            "104 2016-06-01  99.02  99.54  98.33  98.46  94.06560  29173300     97.31187\n",
            "105 2016-06-02  97.60  97.84  96.63  97.72  93.35864  40191600     95.94288\n",
            "106 2016-06-03  97.79  98.27  97.45  97.92  93.54971  28062900     96.42323\n",
            "107 2016-06-06  97.99 101.89  97.55  98.63  94.22800  23292500     97.88934\n",
            "108 2016-06-07  99.25  99.87  98.96  99.03  94.61016  22409500     97.81339\n",
            "109 2016-06-08  99.02  99.56  98.68  98.94  94.52419  20848100     97.58806\n",
            "110 2016-06-09  98.50  99.99  98.46  99.65  95.20249  26601400     97.88416\n",
            "111 2016-06-10  98.53  99.35  98.48  98.83  94.41910  31712900     97.41637\n",
            "112 2016-06-13  98.69  99.12  97.10  97.34  92.99558  38020500     96.40519\n",
            "113 2016-06-14  97.32  98.48  96.75  97.46  93.11023  31931900     96.11341\n",
            "114 2016-06-15  97.82  98.41  97.03  97.14  92.80452  29445200     96.08151\n",
            "115 2016-06-16  96.45  97.75  96.07  97.55  93.19623  31326800     95.67208\n",
            "116 2016-06-17  96.62  96.65  95.30  95.33  91.07530  61008200     94.34177\n",
            "117 2016-06-20  96.00  96.57  95.03  95.10  90.85556  34411900     94.15185\n",
            "118 2016-06-21  94.94  96.35  94.68  95.91  91.62942  35546400     94.21981\n",
            "119 2016-06-22  96.25  96.89  95.35  95.55  91.28548  29219100     94.50849\n",
            "120 2016-06-23  95.94  96.29  95.25  96.10  91.81095  32240200     94.45032\n",
            "121 2016-06-24  92.91  94.66  92.65  93.40  89.23144  75311400     92.18048\n",
            "122 2016-06-27  93.00  93.05  91.50  92.04  87.93213  45489600     90.82738\n",
            "123 2016-06-28  92.90  93.66  92.14  93.59  89.41295  40444900     91.73765\n",
            "124 2016-06-29  93.97  94.55  93.63  94.40  90.18681  36531000     92.78894\n",
            "125 2016-06-30  94.44  95.77  94.30  95.60  91.33325  35836400     93.80108\n",
            "126 2016-07-01  95.49  96.47  95.33  95.89  91.61031  26026500     94.47010\n",
            "127 2016-07-05  95.39  95.40  94.46  94.99  90.75047  27705200     93.53682\n",
            "128 2016-07-06  94.60  95.66  94.37  95.53  91.26638  30949100     93.76546\n",
            "129 2016-07-07  95.70  96.50  95.62  95.94  91.65807  25139600     94.59269\n",
            "130 2016-07-08  96.49  96.89  96.05  96.68  92.36503  28912100     95.10168\n",
            "131 2016-07-11  96.75  97.65  96.73  96.98  92.65166  23794900     95.67722\n",
            "132 2016-07-12  97.17  97.70  97.12  97.42  93.07204  24167500     95.96401\n",
            "133 2016-07-13  97.41  97.67  96.84  96.87  92.54656  25892200     95.68552\n",
            "134 2016-07-14  97.39  98.99  97.32  98.79  94.38088  38919000     96.89696\n",
            "135 2016-07-15  98.92  99.30  98.50  98.78  94.37131  30137000     97.39044\n",
            "136 2016-07-18  98.70 100.13  98.60  99.83  95.37445  36493900     98.03482\n",
            "137 2016-07-19  99.56 100.00  99.34  99.87  95.41267  23779900     98.25089\n",
            "138 2016-07-20 100.00 100.46  99.74  99.96  95.49866  26276000     98.56622\n",
            "139 2016-07-21  99.83 101.00  99.13  99.43  94.99231  32702000     98.37410\n",
            "140 2016-07-22  99.26  99.30  98.31  98.66  94.25668  28313700     97.28889\n",
            "141 2016-07-25  98.25  98.84  96.92  97.34  92.99558  40382900     96.25186\n",
            "142 2016-07-26  96.82  97.97  96.42  96.67  92.35549  56239800     95.58183\n",
            "143 2016-07-27 104.27 104.35 102.75 102.95  98.35522  92344800    101.81840\n",
            "144 2016-07-28 102.83 104.45 102.82 104.34  99.68316  39869800    102.31772\n",
            "145 2016-07-29 104.19 104.55 103.68 104.21  99.55898  27733700    102.59633\n",
            "146 2016-08-01 104.41 106.15 104.41 106.05 101.31685  38167900    103.95895\n",
            "147 2016-08-02 106.05 106.07 104.00 104.48  99.81692  33816600    103.29564\n",
            "148 2016-08-03 104.81 105.84 104.77 105.79 101.06845  30202600    103.89281\n",
            "149 2016-08-04 105.58 106.00 105.28 105.87 101.69282  27408700    104.32427\n",
            "150 2016-08-05 106.27 107.65 106.18 107.48 103.23929  40553400    105.68976\n",
            "151 2016-08-08 107.52 108.37 107.16 108.37 104.09418  28037200    106.54139\n",
            "152 2016-08-09 108.23 108.94 108.01 108.81 104.51681  26315200    107.15561\n",
            "153 2016-08-10 108.71 108.90 107.76 108.00 103.73876  24008500    106.79959\n",
            "154 2016-08-11 108.52 108.93 107.85 107.93 103.67153  27484500    106.81718\n",
            "155 2016-08-12 107.78 108.44 107.78 108.18 103.91166  18660400    106.71055\n",
            "156 2016-08-15 108.14 109.54 108.08 109.48 105.16038  25868200    107.59346\n",
            "157 2016-08-16 109.63 110.23 109.21 109.38 105.06432  33794400    108.16811\n",
            "158 2016-08-17 109.10 109.37 108.34 109.22 104.91062  25356000    107.54021\n",
            "159 2016-08-18 109.23 109.60 109.02 109.08 104.77616  21984700    107.79872\n",
            "160 2016-08-19 108.77 109.69 108.36 109.36 105.04511  25368100    107.69837\n",
            "161 2016-08-22 108.86 109.10 107.85 108.51 104.22866  25820200    107.05955\n",
            "162 2016-08-23 108.59 109.32 108.53 108.85 104.55523  21257700    107.46841\n",
            "163 2016-08-24 108.57 108.75 107.68 108.03 103.76759  23675100    106.73253\n",
            "164 2016-08-25 107.39 107.88 106.68 107.57 103.32574  25086200    105.96191\n",
            "165 2016-08-26 107.41 107.95 106.31 106.94 102.72058  27766300    105.66019\n",
            "166 2016-08-29 106.62 107.44 106.29 106.82 102.60533  24970300    105.44511\n",
            "167 2016-08-30 105.80 106.50 105.50 106.00 101.81767  24863900    104.60589\n",
            "168 2016-08-31 105.66 106.57 105.64 106.10 101.91373  29662400    104.70791\n",
            "169 2016-09-01 106.14 106.80 105.62 106.73 102.51887  26701500    104.97963\n",
            "170 2016-09-02 107.70 108.00 106.82 107.73 103.47942  26802500    106.09981\n",
            "171 2016-09-06 107.90 108.30 107.51 107.70 103.45059  26880400    106.42020\n",
            "172 2016-09-07 107.83 108.76 107.07 108.36 104.08456  42364300    106.63819\n",
            "173 2016-09-08 107.25 107.27 105.24 105.52 101.35661  53002000    104.62220\n",
            "174 2016-09-09 104.64 105.72 103.13 103.13  99.06092  46557000    102.63697\n",
            "175 2016-09-12 102.65 105.72 102.53 105.44 101.27977  45292800    103.17659\n",
            "176 2016-09-13 107.51 108.79 107.24 107.95 103.69073  62176200    106.57358\n",
            "177 2016-09-14 108.73 113.03 108.60 111.77 107.36002 110888700    109.66334\n",
            "178 2016-09-15 113.86 115.73 113.49 115.57 111.01009  89983600    113.41003\n",
            "179 2016-09-16 115.12 116.13 114.04 114.92 110.38573  79886900    113.51858\n",
            "180 2016-09-19 115.19 116.18 113.25 113.58 109.09860  47023000    112.84287\n",
            "181 2016-09-20 113.05 114.12 112.51 113.57 109.08898  34514300    111.90633\n",
            "182 2016-09-21 113.85 113.99 112.44 113.55 109.06978  36003200    111.83326\n",
            "183 2016-09-22 114.35 114.94 114.00 114.62 110.09757  31074000    113.01252\n",
            "184 2016-09-23 114.42 114.79 111.55 112.71 108.26292  52481200    111.53431\n",
            "185 2016-09-26 111.64 113.39 111.55 112.88 108.42622  29869400    111.12208\n",
            "186 2016-09-27 113.00 113.18 112.34 113.09 108.62794  24607400    111.38264\n",
            "187 2016-09-28 113.69 114.64 113.43 113.95 109.45400  29641100    112.50800\n",
            "188 2016-09-29 113.16 113.80 111.80 112.18 107.75384  35887000    111.11795\n",
            "189 2016-09-30 112.46 113.37 111.80 113.05 108.58952  36379100    111.25318\n",
            "190 2016-10-03 112.71 113.05 112.28 112.52 108.08041  21701800    111.13681\n",
            "191 2016-10-04 113.06 114.31 112.63 113.00 108.54148  29736800    111.82716\n",
            "192 2016-10-05 113.40 113.66 112.69 113.05 108.58952  21453100    111.64651\n",
            "193 2016-10-06 113.70 114.34 113.13 113.89 109.39637  28779300    112.28879\n",
            "194 2016-10-07 114.31 114.56 113.51 114.06 109.55968  24358400    112.54323\n",
            "195 2016-10-10 115.02 116.75 114.72 116.05 111.47115  36236000    114.31372\n",
            "196 2016-10-11 117.70 118.69 116.20 116.30 111.71129  64041000    115.53376\n",
            "197 2016-10-12 117.35 117.98 116.75 117.34 112.71024  37586800    115.81341\n",
            "198 2016-10-13 116.79 117.44 115.72 116.98 112.36446  35192400    115.17482\n",
            "199 2016-10-14 117.88 118.17 117.13 117.63 112.98880  35652200    116.09627\n",
            "200 2016-10-17 117.33 117.84 116.78 117.55 112.91196  23624900    115.84399\n",
            "201 2016-10-18 118.18 118.21 117.45 117.47 112.83511  24553500    116.16504\n",
            "202 2016-10-19 117.25 117.76 113.80 117.12 112.49893  20034600    114.68631\n",
            "203 2016-10-20 116.86 117.38 116.33 117.06 112.44128  24125800    115.38376\n",
            "204 2016-10-21 116.81 116.91 116.28 116.60 111.99945  23192700    115.06315\n",
            "205 2016-10-24 117.10 117.74 117.00 117.65 113.00802  23538700    115.91601\n",
            "206 2016-10-25 117.95 118.36 117.31 118.25 113.58434  48129000    116.41811\n",
            "207 2016-10-26 114.31 115.70 113.31 115.59 111.02929  66134200    113.34643\n",
            "208 2016-10-27 115.39 115.86 114.10 114.48 109.96310  34562000    113.30770\n",
            "209 2016-10-28 113.87 115.21 113.45 113.72 109.23308  37861700    112.63102\n",
            "210 2016-10-31 113.65 114.23 113.20 113.54 109.06019  26419400    112.16340\n",
            "211 2016-11-01 113.46 113.77 110.53 111.49 107.09106  43825800    110.46369\n",
            "212 2016-11-02 111.40 112.35 111.23 111.59 107.18711  28331700    110.25570\n",
            "213 2016-11-03 110.98 111.46 109.55 109.83 106.03821  26932600    109.01607\n",
            "214 2016-11-04 108.53 110.25 108.11 108.84 105.08237  30837000    107.81413\n",
            "215 2016-11-07 110.08 110.51 109.46 110.41 106.59817  32560000    108.85606\n",
            "216 2016-11-08 110.31 111.72 109.70 111.06 107.22573  24054500    109.54858\n",
            "217 2016-11-09 109.88 111.32 108.05 110.88 107.05196  59176400    108.80732\n",
            "218 2016-11-10 111.09 111.09 105.83 107.79 104.06863  57134500    106.99621\n",
            "219 2016-11-11 107.12 108.87 106.55 108.43 104.68653  34094100    106.70218\n",
            "220 2016-11-14 107.71 107.81 104.08 105.71 102.06046  51175500    104.65015\n",
            "221 2016-11-15 106.57 107.68 106.16 107.11 103.41212  32264500    105.75071\n",
            "222 2016-11-16 106.70 110.23 106.60 109.99 106.19268  58840500    107.67423\n",
            "223 2016-11-17 109.81 110.35 108.83 109.95 106.15406  27632000    108.44469\n",
            "224 2016-11-18 109.72 110.54 109.66 110.06 106.26027  28428900    108.82009\n",
            "225 2016-11-21 110.12 111.99 110.01 111.73 107.87262  29264600    109.95754\n",
            "226 2016-11-22 111.95 112.42 111.40 111.80 107.94019  25965500    110.58673\n",
            "227 2016-11-23 111.36 111.51 110.33 111.23 107.38987  27426400    109.74329\n",
            "228 2016-11-25 111.13 111.87 110.95 111.79 107.93053  11475900    110.25018\n",
            "229 2016-11-28 111.43 112.47 111.39 111.57 107.71814  27194000    110.52605\n",
            "230 2016-11-29 110.78 112.03 110.07 111.46 107.61195  28528800    109.90398\n",
            "231 2016-11-30 111.60 112.20 110.27 110.52 106.70438  36162300    109.72479\n",
            "232 2016-12-01 110.37 110.94 109.03 109.49 105.70995  37086900    108.55998\n",
            "233 2016-12-02 109.17 110.09 108.85 109.90 106.10579  26528000    108.34859\n",
            "234 2016-12-05 110.00 110.03 108.25 109.11 105.34306  34324500    107.87435\n",
            "235 2016-12-06 109.50 110.36 109.19 109.95 106.15406  26195500    108.56802\n",
            "236 2016-12-07 109.26 111.19 109.16 111.03 107.19677  29998700    109.18226\n",
            "237 2016-12-08 110.86 112.43 110.60 112.12 108.24915  27068300    110.42638\n",
            "238 2016-12-09 112.31 114.70 112.31 113.95 110.01596  34402600    112.34199\n",
            "239 2016-12-12 113.29 115.00 112.49 113.30 109.38840  26374400    112.29280\n",
            "240 2016-12-13 113.84 115.92 113.75 115.19 111.21315  43733800    113.62772\n",
            "241 2016-12-14 115.04 116.20 114.98 115.19 111.21315  34031800    114.13105\n",
            "242 2016-12-15 115.38 116.73 115.23 115.82 111.82140  46524500    114.59380\n",
            "243 2016-12-16 116.47 116.50 115.65 115.97 111.96623  44351100    114.70541\n",
            "244 2016-12-19 115.80 117.38 115.75 116.64 112.61310  27779400    115.24770\n",
            "245 2016-12-20 116.74 117.50 116.68 116.95 112.91239  21425000    115.69746\n",
            "246 2016-12-21 116.80 117.40 116.78 117.06 113.01859  23783200    115.73286\n",
            "247 2016-12-22 116.35 116.51 115.64 116.29 112.27518  26085900    114.80840\n",
            "248 2016-12-23 115.59 116.52 115.59 116.52 112.49725  14249500    114.86908\n",
            "249 2016-12-27 116.52 117.80 116.49 117.26 113.21169  18296900    115.83390\n",
            "250 2016-12-28 117.52 118.02 116.20 116.76 112.72895  20905900    115.64965\n",
            "251 2016-12-29 116.45 117.11 116.40 116.73 112.69999  15039500    115.40333\n",
            "252 2016-12-30 116.65 117.20 115.43 115.82 111.82140  30586300    114.81713\n",
            "253 2017-01-03 115.80 116.33 114.76 116.15 112.14001  28781900    114.41000\n",
            "254 2017-01-04 115.85 116.51 115.75 116.02 112.01450  21118100    114.75817\n",
            "255 2017-01-05 115.92 116.86 115.81 116.61 112.58413  22193600    115.08471\n",
            "256 2017-01-06 116.78 118.16 116.47 117.91 113.83925  31751900    116.15642\n",
            "257 2017-01-09 117.95 119.43 117.94 118.99 114.88195  33561900    117.41732\n",
            "258 2017-01-10 118.77 119.38 118.30 119.11 114.99782  24462100    117.55927\n",
            "259 2017-01-11 118.74 119.93 118.60 119.75 115.61572  27588600    118.04857\n",
            "260 2017-01-12 118.90 119.30 118.21 119.25 115.13299  27086200    117.54766\n",
            "261 2017-01-13 119.11 119.62 118.81 119.04 114.93024  26111900    117.78675\n",
            "262 2017-01-17 118.34 120.24 118.22 120.00 115.85709  34439800    118.10569\n",
            "263 2017-01-18 120.00 120.50 119.71 119.99 115.84744  23713000    118.68581\n",
            "264 2017-01-19 119.40 120.09 119.37 119.78 115.64469  25597300    118.36823\n",
            "265 2017-01-20 120.45 120.45 119.73 120.00 115.85709  32597900    118.67903\n",
            "266 2017-01-23 120.00 120.81 119.77 120.08 115.93433  22050200    118.83811\n",
            "267 2017-01-24 119.55 120.10 119.50 119.97 115.82812  23211000    118.47604\n",
            "268 2017-01-25 120.42 122.10 120.28 121.88 117.67219  32377600    120.01739\n",
            "269 2017-01-26 121.67 122.44 121.60 121.94 117.73012  26337600    120.59004\n",
            "270 2017-01-27 122.14 122.35 121.60 121.95 117.73977  20562900    120.56325\n",
            "271 2017-01-30 120.93 121.63 120.66 121.63 117.43082  30377500    119.90694\n",
            "272 2017-01-31 121.15 121.39 120.62 121.35 117.16049  49201000    119.72350\n",
            "273 2017-02-01 127.03 130.49 127.01 128.75 124.30500 111985000    127.26834\n",
            "274 2017-02-02 127.98 129.39 127.78 128.53 124.09261  33710400    127.08753\n",
            "275 2017-02-03 128.31 129.19 128.16 129.08 124.62362  24507300    127.32454\n",
            "276 2017-02-06 129.13 130.50 128.90 130.29 125.79184  26845900    128.39728\n",
            "277 2017-02-07 130.54 132.09 130.45 131.53 126.98903  38183800    129.84301\n",
            "278 2017-02-08 131.35 132.22 131.22 132.04 127.48141  23004100    130.30714\n",
            "279 2017-02-09 131.65 132.45 131.12 132.42 128.40260  28349900    130.65753\n",
            "280 2017-02-10 132.46 132.94 132.05 132.12 128.11171  20065500    131.03391\n",
            "281 2017-02-13 133.08 133.82 132.75 133.29 129.24620  23035400    131.93874\n",
            "282 2017-02-14 133.47 135.09 133.25 135.02 130.92372  33226200    133.08791\n",
            "283 2017-02-15 135.52 136.27 134.62 135.51 131.39883  35623100    134.09628\n",
            "284 2017-02-16 135.67 135.90 134.84 135.35 131.24373  22584600    133.99457\n",
            "285 2017-02-17 135.10 135.83 135.10 135.72 131.60249  22198200    134.17750\n",
            "286 2017-02-21 136.23 136.75 135.98 136.70 132.55275  24507200    135.09425\n",
            "287 2017-02-22 136.43 137.12 136.11 137.11 132.95032  20836900    135.39344\n",
            "288 2017-02-23 137.38 137.48 136.30 136.53 132.38791  20788200    135.38930\n",
            "289 2017-02-24 135.91 136.66 135.28 136.66 132.51396  21776600    134.81799\n",
            "290 2017-02-27 137.14 137.44 136.28 136.93 132.77577  20257400    135.49859\n",
            "291 2017-02-28 137.08 137.44 136.70 136.99 132.83397  23482900    135.65799\n",
            "292 2017-03-01 137.89 140.15 137.60 139.79 135.54900  36414600    137.76633\n",
            "293 2017-03-02 140.00 140.28 138.76 138.96 134.74419  26211000    137.92806\n",
            "294 2017-03-03 138.78 139.83 138.59 139.78 135.53931  21108100    137.98644\n",
            "295 2017-03-06 139.37 139.77 138.60 139.34 135.11266  21750000    137.82756\n",
            "296 2017-03-07 139.06 139.98 138.79 139.52 135.28720  17446300    138.01906\n",
            "297 2017-03-08 138.95 139.80 138.82 139.00 134.78297  18707200    137.80099\n",
            "298 2017-03-09 138.74 138.79 137.05 138.68 134.47267  22155900    136.77089\n",
            "299 2017-03-10 139.25 139.36 138.64 139.14 134.91873  19612800    137.63958\n",
            "300 2017-03-13 138.85 139.43 138.82 139.20 134.97690  17421700    137.74230\n",
            "301 2017-03-14 139.30 139.65 138.84 138.99 134.77328  15309100    137.75442\n",
            "302 2017-03-15 139.41 140.75 139.03 140.46 136.19869  25691800    138.65956\n",
            "303 2017-03-16 140.72 141.02 140.26 140.69 136.42169  19232000    139.23390\n",
            "304 2017-03-17 141.00 141.00 139.89 139.99 135.74295  43885000    138.87765\n",
            "305 2017-03-20 140.40 141.50 140.23 141.46 137.16836  21542000    139.63279\n",
            "306 2017-03-21 142.11 142.80 139.73 139.84 135.59750  39529900    139.37583\n",
            "307 2017-03-22 139.85 141.60 139.76 141.42 137.12956  25860200    139.49652\n",
            "308 2017-03-23 141.26 141.58 140.61 140.92 136.64471  20346300    139.61157\n",
            "309 2017-03-24 141.50 141.74 140.35 140.64 136.37323  22395600    139.48775\n",
            "310 2017-03-27 139.39 141.22 138.62 140.88 136.60596  23575100    138.81532\n",
            "311 2017-03-28 140.91 144.04 140.62 143.80 139.43735  33374800    141.36578\n",
            "312 2017-03-29 143.68 144.49 143.19 144.12 139.74765  29190000    142.47589\n",
            "313 2017-03-30 144.19 144.50 143.50 143.93 139.56342  21207300    142.52114\n",
            "314 2017-03-31 143.72 144.27 143.01 143.66 139.30160  19661700    142.19387\n",
            "315 2017-04-03 143.71 144.12 143.05 143.70 139.34039  19985700    142.17013\n",
            "316 2017-04-04 143.25 144.89 143.17 144.77 140.37793  19891400    142.81264\n",
            "317 2017-04-05 144.22 145.46 143.81 144.02 139.65068  27717900    142.97356\n",
            "318 2017-04-06 144.29 144.52 143.45 143.66 139.30160  21149000    142.42387\n",
            "319 2017-04-07 143.73 144.18 143.27 143.34 138.99132  16672200    142.14711\n",
            "320 2017-04-10 143.60 143.88 142.90 143.17 138.82646  18933400    141.86882\n",
            "321 2017-04-11 142.94 143.35 140.06 141.63 137.33321  30379400    140.24774\n",
            "322 2017-04-12 141.60 142.15 141.01 141.80 137.49803  20350000    140.21934\n",
            "323 2017-04-13 141.91 142.38 141.05 141.05 136.77078  17822900    140.06693\n",
            "324 2017-04-17 141.48 141.88 140.87 141.83 137.52713  16582100    140.09238\n",
            "325 2017-04-18 141.41 142.04 141.11 141.20 136.91623  14697500    140.02207\n",
            "326 2017-04-19 141.88 142.00 140.45 140.68 136.41200  17328400    139.62067\n",
            "327 2017-04-20 141.22 142.92 141.16 142.44 138.11862  23319600    140.73287\n",
            "328 2017-04-21 142.44 142.68 141.85 142.27 137.95378  17320900    140.82793\n",
            "329 2017-04-24 143.50 143.95 143.18 143.64 139.28220  17134300    142.13740\n",
            "330 2017-04-25 143.91 144.90 143.87 144.53 140.14519  18871500    142.97173\n",
            "331 2017-04-26 144.47 144.60 143.38 143.68 139.32098  20041200    142.43366\n",
            "332 2017-04-27 143.92 144.16 143.31 143.79 139.42764  14246300    142.29922\n",
            "333 2017-04-28 144.09 144.30 143.27 143.65 139.29189  20860400    142.28730\n",
            "334 2017-05-01 145.10 147.20 144.96 146.58 142.13300  33602900    144.76433\n",
            "335 2017-05-02 147.54 148.09 146.84 147.51 143.03481  45352200    145.98827\n",
            "336 2017-05-03 145.59 147.49 144.27 147.06 142.59845  45697000    144.78615\n",
            "337 2017-05-04 146.52 147.14 145.81 146.53 142.08452  23371900    145.01150\n",
            "338 2017-05-05 146.76 148.98 146.76 148.96 144.44081  27327700    146.72693\n",
            "339 2017-05-08 149.03 153.70 149.03 153.01 148.36792  48752400    150.36597\n",
            "340 2017-05-09 153.87 154.88 153.45 153.99 149.31819  39130400    152.54940\n",
            "341 2017-05-10 153.63 153.94 152.11 153.26 148.61035  25805700    151.55345\n",
            "342 2017-05-11 152.45 154.07 152.31 153.95 149.89557  27255100    152.09186\n",
            "343 2017-05-12 154.70 156.42 154.67 156.10 151.98897  32527000    154.35965\n",
            "344 2017-05-15 156.01 156.65 155.05 155.70 151.59952  26009700    154.43317\n",
            "345 2017-05-16 155.94 156.06 154.72 155.47 151.37555  20048500    154.05185\n",
            "346 2017-05-17 153.60 154.57 149.71 150.25 146.29303  50767700    150.19101\n",
            "347 2017-05-18 151.27 153.34 151.13 152.54 148.52271  33568200    150.99757\n",
            "348 2017-05-19 153.38 153.98 152.63 153.06 149.02901  26960800    151.87967\n",
            "349 2017-05-22 154.00 154.58 152.91 153.99 149.93454  22966400    152.47485\n",
            "350 2017-05-23 154.90 154.90 153.31 153.80 149.74954  19918900    152.65318\n",
            "351 2017-05-24 153.84 154.17 152.67 153.34 149.30164  19178000    152.04721\n",
            "352 2017-05-25 153.73 154.35 153.03 153.87 149.81767  19235600    152.39923\n",
            "353 2017-05-26 154.00 154.24 153.31 153.61 149.56453  21927600    152.37151\n",
            "354 2017-05-30 153.42 154.43 153.33 153.67 149.62295  20126900    152.46098\n",
            "355 2017-05-31 153.97 154.17 152.38 152.76 148.73691  24451200    151.76230\n",
            "356 2017-06-01 153.17 153.33 152.22 153.18 149.14584  16404100    151.56528\n",
            "357 2017-06-02 153.58 155.45 152.89 155.45 151.35608  27770700    153.23202\n",
            "358 2017-06-05 154.34 154.45 153.46 153.93 149.87610  25331700    152.59537\n",
            "359 2017-06-06 153.90 155.81 153.78 154.45 150.38242  26624900    153.32414\n",
            "360 2017-06-07 155.02 155.98 154.48 155.37 151.27820  21069600    153.91273\n",
            "361 2017-06-08 155.25 155.54 154.40 154.99 150.90820  21250800    153.61606\n",
            "362 2017-06-09 155.19 155.19 146.02 148.98 145.05646  64882700    148.75549\n",
            "363 2017-06-12 145.74 146.09 142.51 145.42 141.59024  72307300    143.39674\n",
            "364 2017-06-13 147.16 147.45 145.15 146.59 142.72942  34165400    145.10980\n",
            "365 2017-06-14 147.50 147.50 143.84 145.16 141.33707  31531200    144.22569\n",
            "366 2017-06-15 143.32 144.48 142.21 144.29 140.48996  32165400    142.39332\n",
            "367 2017-06-16 143.78 144.50 142.20 142.27 138.52321  50361100    141.74107\n",
            "368 2017-06-19 143.66 146.74 143.66 146.34 142.48601  32541400    144.29534\n",
            "369 2017-06-20 146.87 146.87 144.94 145.01 141.19101  24900100    144.33367\n",
            "370 2017-06-21 145.52 146.07 144.61 145.87 142.02837  21265800    144.23612\n",
            "371 2017-06-22 145.77 146.70 145.12 145.63 141.79471  19106300    144.53823\n",
            "372 2017-06-23 145.13 147.16 145.11 146.28 142.42760  35439400    144.89920\n",
            "373 2017-06-26 147.17 148.28 145.38 145.82 141.97969  25692400    145.21323\n",
            "374 2017-06-27 145.01 146.16 143.62 143.73 139.94473  24761900    143.24158\n",
            "375 2017-06-28 144.49 146.11 143.16 145.83 141.98944  22082400    143.75315\n",
            "376 2017-06-29 144.71 145.13 142.28 143.68 139.89604  31499400    142.43535\n",
            "377 2017-06-30 144.45 144.96 143.78 144.02 140.22710  23024100    142.98903\n",
            "378 2017-07-03 144.88 145.30 143.10 143.50 139.72080  14277800    142.70693\n",
            "379 2017-07-05 143.69 144.79 142.72 144.09 140.29524  21569600    142.60175\n",
            "380 2017-07-06 143.02 143.50 142.41 142.73 138.97107  24128800    141.62702\n",
            "381 2017-07-07 142.90 144.75 142.90 144.18 140.38287  19201700    142.67762\n",
            "382 2017-07-10 144.11 145.95 143.37 145.06 141.23970  21090600    143.51990\n",
            "383 2017-07-11 144.73 145.85 144.38 145.53 141.69733  19781800    143.97578\n",
            "384 2017-07-12 145.87 146.18 144.82 145.74 141.90181  24884500    144.30060\n",
            "385 2017-07-13 145.50 148.49 145.44 147.77 143.87834  25199400    145.93612\n",
            "386 2017-07-14 147.97 149.33 147.33 149.04 145.11488  20132100    147.25830\n",
            "387 2017-07-17 148.82 150.90 148.57 149.56 145.62117  23793500    148.36372\n",
            "388 2017-07-18 149.20 150.13 148.67 150.08 146.12752  17868800    148.30917\n",
            "389 2017-07-19 150.48 151.42 149.95 151.02 147.04274  20923000    149.47091\n",
            "390 2017-07-20 151.50 151.74 150.19 150.34 146.38066  17243700    149.43689\n",
            "391 2017-07-21 149.99 150.44 148.88 150.27 146.31253  26252600    148.54418\n",
            "392 2017-07-24 150.58 152.44 149.90 152.09 148.08456  21493200    150.14152\n",
            "393 2017-07-25 151.80 153.84 151.80 152.74 148.71745  18853900    151.45248\n",
            "394 2017-07-26 153.35 153.93 153.06 153.46 149.41852  15781000    152.13617\n",
            "395 2017-07-27 153.75 153.99 147.30 150.56 146.59486  32476300    149.29496\n",
            "396 2017-07-28 149.89 150.23 149.19 149.50 145.56277  17213700    148.32759\n",
            "397 2017-07-31 149.90 150.33 148.13 148.73 144.81303  19845900    147.75768\n",
            "398 2017-08-01 149.10 150.22 148.41 150.05 146.09830  35368600    148.24277\n",
            "399 2017-08-02 159.28 159.75 156.16 157.14 153.00157  69936800    156.30386\n",
            "400 2017-08-03 157.05 157.21 155.02 155.57 151.47293  27097300    154.56765\n",
            "401 2017-08-04 156.07 157.40 155.69 156.39 152.27132  20559900    155.12044\n",
            "402 2017-08-07 157.06 158.92 156.67 158.81 154.62761  21870300    156.73920\n",
            "403 2017-08-08 158.60 161.83 158.27 160.08 155.86415  36205900    158.65472\n",
            "404 2017-08-09 159.26 161.27 159.11 161.06 156.81833  26131500    159.06611\n",
            "405 2017-08-10 159.90 160.00 154.63 155.32 151.82338  40804300    155.48446\n",
            "406 2017-08-11 156.60 158.57 156.07 157.48 153.93475  26257100    156.19159\n",
            "407 2017-08-14 159.32 160.21 158.75 159.85 156.25142  22122700    158.40381\n",
            "408 2017-08-15 160.66 162.20 160.14 161.60 157.96199  29465500    160.10066\n",
            "409 2017-08-16 161.94 162.51 160.15 160.95 157.32665  27671600    159.99554\n",
            "410 2017-08-17 160.52 160.71 157.84 157.86 154.30621  27940600    157.61874\n",
            "411 2017-08-18 157.86 159.50 156.72 157.50 153.95430  27428100    156.72477\n",
            "412 2017-08-21 157.50 157.89 155.11 157.21 153.67084  26368500    155.55695\n",
            "413 2017-08-22 158.23 160.00 158.02 159.78 156.18297  21604600    158.06766\n",
            "414 2017-08-23 159.07 160.47 158.88 159.98 156.37846  19399100    158.57616\n",
            "415 2017-08-24 160.43 160.74 158.55 159.27 155.68445  19818900    158.32482\n",
            "416 2017-08-25 159.65 160.56 159.27 159.86 156.26115  25480100    158.69705\n",
            "417 2017-08-28 160.14 162.00 159.93 161.47 157.83491  25966000    159.92164\n",
            "418 2017-08-29 160.10 163.12 160.00 162.91 159.24251  29516900    160.78750\n",
            "419 2017-08-30 163.80 163.89 162.61 163.35 159.67262  27269600    162.05754\n",
            "420 2017-08-31 163.64 164.52 163.48 164.00 160.30797  26785100    162.76932\n",
            "421 2017-09-01 164.80 164.94 163.63 164.05 160.35684  16591100    162.97562\n",
            "422 2017-09-05 163.75 164.25 160.56 162.08 158.43118  29468500    161.08039\n",
            "423 2017-09-06 162.71 162.99 160.52 161.91 158.26503  21651700    160.59168\n",
            "424 2017-09-07 162.09 162.24 160.36 161.26 157.62965  21928500    160.07655\n",
            "425 2017-09-08 160.86 161.15 158.53 158.63 155.05887  28611500    158.24629\n",
            "426 2017-09-11 160.50 162.05 159.89 161.50 157.86426  31580800    159.93475\n",
            "427 2017-09-12 162.61 163.96 158.77 160.86 157.23865  71714000    159.98955\n",
            "428 2017-09-13 159.87 159.96 157.91 159.65 156.05588  44907400    157.97530\n",
            "429 2017-09-14 158.99 159.40 158.09 158.28 154.71674  23760700    157.40224\n",
            "430 2017-09-15 158.47 160.97 158.00 159.88 156.28072  49114600    158.41691\n",
            "431 2017-09-18 160.11 160.50 158.00 158.67 155.09795  28269400    157.86598\n",
            "432 2017-09-19 159.51 159.77 158.44 158.73 155.15660  20810600    157.78887\n",
            "433 2017-09-20 157.90 158.26 153.83 156.07 152.55650  52951400    154.88217\n",
            "434 2017-09-21 155.80 155.80 152.75 153.39 149.93683  37511700    152.82894\n",
            "435 2017-09-22 151.54 152.27 150.56 151.89 148.47060  46645400    150.43353\n",
            "436 2017-09-25 149.99 151.83 149.16 150.55 147.16075  44387300    149.38359\n",
            "437 2017-09-26 151.78 153.92 151.69 153.14 149.69244  36660000    151.76748\n",
            "438 2017-09-27 153.80 154.72 153.54 154.23 150.75794  25504200    153.00598\n",
            "439 2017-09-28 153.89 154.28 152.70 153.28 149.82932  22005500    152.26977\n",
            "440 2017-09-29 153.21 154.13 152.00 154.12 150.65037  26299800    152.26013\n",
            "441 2017-10-02 154.26 154.45 152.72 153.81 150.34738  18698800    152.50579\n",
            "442 2017-10-03 154.01 155.09 153.91 154.48 151.00227  16230300    153.33409\n",
            "443 2017-10-04 153.63 153.86 152.46 153.48 150.02480  20163800    152.11493\n",
            "444 2017-10-05 154.18 155.44 154.05 155.39 151.89178  21283800    153.79393\n",
            "445 2017-10-06 154.97 155.49 154.56 155.30 151.80382  17407600    153.95127\n",
            "446 2017-10-09 155.81 156.73 155.49 155.84 152.33166  16262900    154.85056\n",
            "447 2017-10-10 156.06 158.00 155.10 155.90 152.39031  15617000    155.16344\n",
            "448 2017-10-11 155.97 156.98 155.75 156.55 153.02570  16905600    155.25190\n",
            "449 2017-10-12 156.35 157.37 155.73 156.00 152.48805  16125100    155.19601\n",
            "450 2017-10-13 156.73 157.28 156.41 156.99 153.45577  16394200    155.71526\n",
            "451 2017-10-16 157.90 160.00 157.65 159.88 156.28072  24121500    157.97690\n",
            "452 2017-10-17 159.78 160.87 159.23 160.47 156.85744  18997300    158.98581\n",
            "453 2017-10-18 160.42 160.71 159.60 159.76 156.16342  16374200    158.82448\n",
            "454 2017-10-19 156.75 157.08 155.02 155.98 152.46852  42584200    154.85618\n",
            "455 2017-10-20 156.61 157.75 155.96 156.25 152.73242  23974100    155.48081\n",
            "456 2017-10-23 156.89 157.69 155.50 156.17 152.65422  21984300    155.28141\n",
            "457 2017-10-24 156.29 157.42 156.20 157.10 153.56331  17757200    155.72777\n",
            "458 2017-10-25 156.91 157.55 155.27 156.41 152.88884  21207100    155.23628\n",
            "459 2017-10-26 157.23 157.83 156.78 157.41 153.86630  17000500    156.15877\n",
            "460 2017-10-27 159.29 163.60 158.70 163.05 159.37936  44454200    160.55979\n",
            "461 2017-10-30 163.89 168.07 163.72 166.72 162.96675  44700800    164.91892\n",
            "462 2017-10-31 167.90 169.65 166.94 169.04 165.23451  36046800    167.27484\n",
            "463 2017-11-01 169.87 169.94 165.61 166.89 163.13292  33637800    166.22764\n",
            "464 2017-11-02 166.60 168.50 165.28 168.11 164.32546  41393400    166.03515\n",
            "465 2017-11-03 174.00 174.26 171.12 172.50 168.61661  59398600    171.33220\n",
            "466 2017-11-06 172.37 174.99 171.72 174.25 170.32721  34319500    172.34574\n",
            "467 2017-11-07 173.91 175.25 173.60 174.81 170.87462  24361500    173.24154\n",
            "468 2017-11-08 174.66 176.24 174.33 176.24 172.27241  24409500    174.28081\n",
            "469 2017-11-09 175.11 176.10 173.14 175.88 171.92053  29482600    173.72018\n",
            "470 2017-11-10 175.11 175.38 174.27 174.67 171.35153  25145500    173.66718\n",
            "471 2017-11-13 173.50 174.50 173.40 173.97 170.66484  16982100    172.85494\n",
            "472 2017-11-14 173.04 173.48 171.18 171.34 168.08479  24782500    170.91493\n",
            "473 2017-11-15 169.97 170.32 168.38 169.08 165.86774  29158100    168.18925\n",
            "474 2017-11-16 171.18 171.87 170.30 171.10 167.84938  23637500    170.00646\n",
            "475 2017-11-17 171.04 171.39 169.64 170.15 166.91742  21899500    169.31581\n",
            "476 2017-11-20 170.29 170.56 169.56 169.98 166.75064  16262400    168.95688\n",
            "477 2017-11-21 170.78 173.70 170.78 173.14 169.85060  25131300    171.44353\n",
            "478 2017-11-22 173.36 175.00 173.05 174.96 171.63603  25588900    173.22868\n",
            "479 2017-11-24 175.10 175.50 174.65 174.97 171.64586  14026700    173.93195\n",
            "480 2017-11-27 175.05 175.08 173.34 174.09 170.78255  20716800    173.06751\n",
            "481 2017-11-28 174.30 174.87 171.86 173.07 169.78195  26428800    172.17065\n",
            "482 2017-11-29 172.63 172.92 167.16 169.48 166.26015  41666400    168.78005\n",
            "483 2017-11-30 170.43 172.14 168.44 171.85 168.58511  41527200    169.72170\n",
            "484 2017-12-01 169.95 171.67 168.50 171.05 167.80031  39759300    169.32344\n",
            "485 2017-12-04 172.48 172.62 169.63 169.80 166.57408  32542400    169.60803\n",
            "486 2017-12-05 169.06 171.52 168.40 169.64 166.41710  27350200    168.77903\n",
            "487 2017-12-06 167.50 170.20 166.46 169.01 165.79909  28560000    167.48636\n",
            "488 2017-12-07 169.03 170.44 168.91 169.32 166.10319  25673300    168.48440\n",
            "489 2017-12-08 170.49 171.00 168.82 169.37 166.15222  23355200    168.65741\n",
            "490 2017-12-11 169.20 172.89 168.79 172.67 169.38954  35273800    170.35651\n",
            "491 2017-12-12 172.15 172.39 171.46 171.70 168.43797  19409200    170.76266\n",
            "492 2017-12-13 172.50 173.54 172.00 172.27 168.99713  23818400    171.51237\n",
            "493 2017-12-14 172.40 173.13 171.65 172.22 168.94807  20476500    171.24269\n",
            "494 2017-12-15 173.63 174.17 172.46 173.97 170.66484  40169300    172.43162\n",
            "495 2017-12-18 174.88 177.20 174.86 176.42 173.06828  29421100    175.04276\n",
            "496 2017-12-19 175.03 175.39 174.09 174.54 171.22401  27436400    173.56800\n",
            "497 2017-12-20 174.87 175.42 173.25 174.35 171.03763  23475600    173.23588\n",
            "498 2017-12-21 174.17 176.02 174.10 175.01 171.68507  20949900    173.93503\n",
            "499 2017-12-22 174.68 175.42 174.50 175.01 171.68507  16114600    173.86836\n",
            "500 2017-12-26 170.80 171.47 169.68 170.57 167.32945  33185500    169.49315\n",
            "501 2017-12-27 170.10 170.78 169.71 170.60 167.35887  21498200    169.28296\n",
            "502 2017-12-28 171.00 171.85 170.48 171.08 167.82976  16480200    170.05325\n",
            "503 2017-12-29 170.52 170.59 169.22 169.23 166.01491  25884400    168.60830\n",
            "504 2018-01-02 170.16 172.30 169.26 172.26 168.98732  25555900    170.18244\n",
            "505 2018-01-03 172.53 174.55 171.96 172.23 168.95789  29517900    171.82263\n",
            "506 2018-01-04 172.54 173.47 172.08 173.03 169.74271  22434600    171.76424\n",
            "507 2018-01-05 173.44 175.37 173.05 175.00 171.67528  23660000    173.36509\n",
            "508 2018-01-08 174.35 175.61 173.93 174.35 171.03763  20567800    173.52587\n",
            "509 2018-01-09 174.55 175.06 173.41 174.33 171.01800  21584000    173.16267\n",
            "510 2018-01-10 173.16 174.30 173.00 174.29 170.97876  23959900    172.75959\n",
            "511 2018-01-11 174.59 175.49 174.49 175.28 171.94995  18667700    173.97665\n",
            "512 2018-01-12 176.18 177.36 175.65 177.09 173.72557  25226000    175.57852\n",
            "513 2018-01-16 177.90 179.39 176.14 176.19 172.84268  29565900    176.12423\n",
            "514 2018-01-17 176.15 179.25 175.07 179.10 175.69739  34386800    176.67246\n",
            "515 2018-01-18 179.37 180.10 178.25 179.26 175.85434  31193400    178.06812\n",
            "516 2018-01-19 178.61 179.58 177.41 178.46 175.06955  32425100    177.35319\n",
            "517 2018-01-22 177.30 177.78 176.60 177.00 173.63728  27108600    176.00576\n",
            "518 2018-01-23 177.30 179.44 176.82 177.04 173.67651  32689100    176.64551\n",
            "519 2018-01-24 177.25 177.30 173.20 174.22 170.91008  51105100    173.80336\n",
            "520 2018-01-25 174.51 174.95 170.53 171.11 167.85916  41529000    171.11305\n",
            "521 2018-01-26 172.00 172.00 170.06 171.51 168.25156  39143000    170.10385\n",
            "522 2018-01-29 170.16 170.16 167.07 167.96 164.76901  50640400    167.33301\n",
            "523 2018-01-30 165.53 167.37 164.70 166.97 163.79784  46048200    165.28928\n",
            "524 2018-01-31 166.87 168.44 166.50 167.43 164.24908  32478900    166.39636\n",
            "525 2018-02-01 167.17 168.62 166.76 167.78 164.59244  47230800    166.65748\n",
            "526 2018-02-02 166.00 166.80 160.10 160.50 157.45075  86593800    161.45025\n",
            "527 2018-02-05 159.10 163.88 156.00 156.49 153.51695  72738500    157.79899\n",
            "528 2018-02-06 154.83 163.72 154.00 163.03 159.93266  68243800    159.21755\n",
            "529 2018-02-07 163.09 163.40 159.07 159.54 156.50897  51608600    159.65966\n",
            "530 2018-02-08 160.29 161.00 155.03 155.15 152.20239  54390500    156.07746\n",
            "531 2018-02-09 157.07 157.89 150.24 156.41 154.06406  70672600    154.06469\n",
            "532 2018-02-12 158.50 163.89 157.51 162.71 160.26956  60819500    160.55652\n",
            "533 2018-02-13 161.95 164.75 161.65 164.34 161.87511  32549200    162.75837\n",
            "534 2018-02-14 163.04 167.54 162.88 167.37 164.85965  40644900    165.09322\n",
            "535 2018-02-15 169.79 173.09 169.00 172.99 170.39537  51147200    170.82846\n",
            "536 2018-02-16 172.36 174.82 171.77 172.43 169.84376  40176100    172.14459\n",
            "537 2018-02-20 172.05 174.26 171.42 171.85 169.27246  33930500    171.65082\n",
            "538 2018-02-21 172.83 174.12 171.01 171.07 168.50417  37471600    171.21139\n",
            "539 2018-02-22 171.80 173.95 171.71 172.50 169.91270  30991900    171.85757\n",
            "540 2018-02-23 173.67 175.65 173.54 175.50 172.86771  33812400    174.01923\n",
            "541 2018-02-26 176.35 179.39 176.21 178.97 176.28567  38162200    177.29523\n",
            "542 2018-02-27 179.10 180.48 178.16 178.39 175.71439  38928100    178.11813\n",
            "543 2018-02-28 179.26 180.62 178.05 178.12 175.44841  37782100    178.03947\n",
            "544 2018-03-01 178.54 179.78 172.66 175.00 172.37521  48802000    174.93841\n",
            "545 2018-03-02 172.80 176.30 172.45 176.21 173.56708  38454000    174.10569\n",
            "546 2018-03-05 175.21 177.74 174.52 176.82 174.16792  28401400    175.47598\n",
            "547 2018-03-06 177.91 178.25 176.13 176.67 174.02017  23788500    176.13339\n",
            "548 2018-03-07 174.94 175.85 174.27 175.03 172.40477  31703500    174.17493\n",
            "549 2018-03-08 175.48 177.12 175.07 176.94 174.28612  23774100    175.49204\n",
            "550 2018-03-09 177.96 180.00 177.39 179.98 177.28052  32185200    178.22351\n",
            "551 2018-03-12 180.29 182.39 180.21 181.72 178.99442  32207100    180.53147\n",
            "552 2018-03-13 182.59 183.50 179.24 179.97 177.27066  31693500    180.00356\n",
            "553 2018-03-14 180.32 180.52 177.81 178.44 175.76361  29368400    178.03120\n",
            "554 2018-03-15 178.50 180.24 178.07 178.65 175.97046  22743800    178.09349\n",
            "555 2018-03-16 178.65 179.12 177.62 178.02 175.34992  39404700    177.36330\n",
            "556 2018-03-19 177.32 177.47 173.66 175.30 172.67073  33446800    174.60025\n",
            "557 2018-03-20 175.24 176.80 174.94 175.24 172.61162  19649400    174.78387\n",
            "558 2018-03-21 175.04 175.09 171.26 171.27 168.70116  36338100    171.68372\n",
            "559 2018-03-22 170.00 172.68 168.60 168.85 166.31746  41490800    169.19915\n",
            "560 2018-03-23 168.39 169.92 164.94 164.94 162.46609  41028800    165.77536\n",
            "561 2018-03-26 168.07 173.10 166.44 172.77 170.17868  37541200    169.90623\n",
            "562 2018-03-27 173.68 175.15 166.92 168.34 165.81511  40922600    169.29503\n",
            "563 2018-03-28 167.25 170.02 165.19 166.48 163.98300  41668500    166.39767\n",
            "564 2018-03-29 167.81 171.75 166.90 167.78 165.26350  38398500    167.97117\n",
            "565 2018-04-02 166.64 168.94 164.47 166.68 164.18001  37586800    165.86334\n",
            "566 2018-04-03 167.64 168.75 164.88 168.39 165.86435  30278000    166.49812\n",
            "567 2018-04-04 164.88 172.01 164.77 171.61 169.03607  34605500    168.60536\n",
            "568 2018-04-05 172.58 174.23 172.08 172.80 170.20821  26933200    172.17273\n",
            "569 2018-04-06 170.97 172.48 168.20 168.38 165.85452  35005300    168.84484\n",
            "570 2018-04-09 169.88 173.09 169.85 170.05 167.49947  29017700    170.14649\n",
            "571 2018-04-10 173.00 174.00 171.53 173.25 170.65146  28408600    172.06049\n",
            "572 2018-04-11 172.23 173.92 171.70 172.44 169.85362  22431600    171.82454\n",
            "573 2018-04-12 173.41 175.00 173.04 174.14 171.52811  22889300    173.18937\n",
            "574 2018-04-13 174.78 175.84 173.85 174.73 172.10927  25124300    173.93309\n",
            "575 2018-04-16 175.03 176.19 174.83 175.82 173.18292  21578400    174.73431\n",
            "576 2018-04-17 176.49 178.94 176.41 178.24 175.56662  26509000    176.97221\n",
            "577 2018-04-18 177.81 178.82 176.88 177.84 175.17261  20754500    176.95754\n",
            "578 2018-04-19 173.76 175.39 172.66 172.80 170.20821  34808800    172.75274\n",
            "579 2018-04-20 170.60 171.22 165.43 165.72 163.23439  65491100    166.62813\n",
            "580 2018-04-23 166.83 166.92 164.09 165.24 162.76160  36515500    164.59053\n",
            "581 2018-04-24 165.67 166.33 161.22 162.94 160.49611  33692000    162.68204\n",
            "582 2018-04-25 162.62 165.42 162.41 163.65 161.19545  28382100    163.00848\n",
            "583 2018-04-26 164.12 165.73 163.37 164.22 161.75691  27963000    163.61897\n",
            "584 2018-04-27 164.00 164.33 160.63 162.32 159.88541  35655800    161.61514\n",
            "585 2018-04-30 162.13 167.26 161.84 165.26 162.78130  42427400    163.96043\n",
            "586 2018-05-01 166.41 169.20 165.27 169.10 166.56370  53569400    167.01124\n",
            "587 2018-05-02 175.23 177.75 173.80 176.57 173.92168  66539400    175.15723\n",
            "588 2018-05-03 175.88 177.50 174.44 176.89 174.23686  34068200    175.39229\n",
            "589 2018-05-04 178.25 184.25 178.17 183.83 181.07277  56201300    181.16426\n",
            "590 2018-05-07 185.18 187.67 184.75 185.16 182.38281  42451400    184.93427\n",
            "591 2018-05-08 184.99 186.22 183.67 186.05 183.25948  28402800    184.38316\n",
            "592 2018-05-09 186.55 187.40 185.22 187.36 184.54984  23211200    185.72328\n",
            "593 2018-05-10 187.74 190.37 187.65 190.04 187.18962  27989300    188.40320\n",
            "594 2018-05-11 189.49 190.06 187.45 188.59 186.47769  26212200    187.99590\n",
            "595 2018-05-14 189.01 189.53 187.86 188.15 186.04262  20778800    187.81087\n",
            "596 2018-05-15 186.78 187.07 185.10 186.44 184.35178  23695200    185.50726\n",
            "597 2018-05-16 186.07 188.46 186.00 188.18 186.07227  19183100    186.84409\n",
            "598 2018-05-17 188.00 188.91 186.36 186.99 184.89561  17294000    186.72187\n",
            "599 2018-05-18 187.19 187.81 186.13 186.31 184.22324  18297700    186.05441\n",
            "600 2018-05-21 188.00 189.27 186.91 187.63 185.52844  18400800    187.23615\n",
            "601 2018-05-22 188.38 188.88 186.78 187.16 185.06372  15240700    186.90791\n",
            "602 2018-05-23 186.35 188.50 185.76 188.36 186.25026  20058400    186.83675\n",
            "603 2018-05-24 188.77 188.84 186.21 188.15 186.04262  23234000    187.03087\n",
            "604 2018-05-25 188.23 189.65 187.65 188.58 186.46780  17461000    187.92260\n",
            "605 2018-05-29 187.60 188.75 186.87 187.90 185.79542  22514100    187.13847\n",
            "606 2018-05-30 187.72 188.00 186.78 187.50 185.39989  18690500    186.72663\n",
            "607 2018-05-31 187.22 188.23 186.14 186.87 184.77695  27482800    186.38231\n",
            "608 2018-06-01 187.99 190.26 187.75 190.24 188.10922  23442500    188.70641\n",
            "609 2018-06-04 191.64 193.42 191.35 191.83 189.68140  26266200    191.48380\n",
            "610 2018-06-05 193.07 193.94 192.36 193.31 191.14482  21566000    192.48161\n",
            "611 2018-06-06 193.63 194.08 191.92 193.98 191.80731  20933600    192.60244\n",
            "612 2018-06-07 194.14 194.20 192.34 193.46 191.29315  21347200    192.61105\n",
            "613 2018-06-08 191.17 192.00 189.77 191.70 189.55286  26656800    190.44095\n",
            "614 2018-06-11 191.35 191.97 190.21 191.23 189.08813  18308500    190.42271\n",
            "615 2018-06-12 191.39 192.61 191.15 192.28 190.12636  16911100    191.29545\n",
            "616 2018-06-13 192.42 192.88 190.44 190.70 188.56406  21638400    190.62802\n",
            "617 2018-06-14 191.55 191.57 190.22 190.80 188.66293  21610100    190.15098\n",
            "618 2018-06-15 190.03 190.16 188.26 188.84 186.72488  61719200    188.38163\n",
            "619 2018-06-18 187.88 189.22 187.20 188.74 186.62602  18484900    187.68201\n",
            "620 2018-06-19 185.14 186.33 183.45 185.69 183.61017  33578500    184.46339\n",
            "621 2018-06-20 186.35 187.20 185.73 186.50 184.41110  20628700    185.78036\n",
            "622 2018-06-21 187.25 188.35 184.94 185.46 183.38275  25711900    185.55759\n",
            "623 2018-06-22 186.12 186.15 184.70 184.92 182.84878  27200400    184.56626\n",
            "624 2018-06-25 183.40 184.92 180.73 182.17 180.12961  31663100    181.92653\n",
            "625 2018-06-26 182.99 186.53 182.54 184.43 182.36429  24569200    183.81143\n",
            "626 2018-06-27 185.23 187.28 184.03 184.16 182.09732  25285300    184.46911\n",
            "627 2018-06-28 184.10 186.21 183.80 185.50 183.42230  17365200    184.47744\n",
            "628 2018-06-29 186.29 187.19 182.91 185.11 183.03668  22737700    184.37890\n",
            "629 2018-07-02 183.82 187.30 183.42 187.18 185.08347  17731300    185.26782\n",
            "630 2018-07-03 187.79 187.95 183.54 183.92 181.85998  13954800    184.44999\n",
            "631 2018-07-05 185.26 186.41 184.28 185.40 183.32341  16604200    184.67114\n",
            "632 2018-07-06 185.42 188.43 185.20 187.97 185.86465  17485200    186.49821\n",
            "633 2018-07-09 189.50 190.68 189.30 190.58 188.44540  19756600    189.47513\n",
            "634 2018-07-10 190.71 191.28 190.18 190.35 188.21797  15939100    189.89265\n",
            "635 2018-07-11 188.50 189.78 187.61 187.88 185.77565  18831500    187.72188\n",
            "636 2018-07-12 189.53 191.41 189.31 191.03 188.89037  18041100    189.87012\n",
            "637 2018-07-13 191.08 191.84 190.90 191.33 189.18701  12513900    190.64233\n",
            "638 2018-07-16 191.52 192.65 190.42 190.91 188.77171  15043100    190.61390\n",
            "639 2018-07-17 189.75 191.87 189.20 191.45 189.30566  15534500    190.12522\n",
            "640 2018-07-18 191.78 191.80 189.93 190.40 188.26741  16393400    189.99914\n",
            "641 2018-07-19 189.69 192.55 189.69 191.88 189.73085  20286800    190.65695\n",
            "642 2018-07-20 191.78 192.43 190.17 191.44 189.29578  20676200    190.63192\n",
            "643 2018-07-23 190.68 191.96 189.56 191.61 189.46387  15989400    190.32796\n",
            "644 2018-07-24 192.45 193.66 192.05 193.00 190.83830  18697900    192.18277\n",
            "645 2018-07-25 193.06 194.85 192.43 194.82 192.63792  16709900    193.30597\n",
            "646 2018-07-26 194.61 195.96 193.61 194.21 192.03476  19076000    193.86826\n",
            "647 2018-07-27 194.99 195.19 190.10 190.98 188.84091  24024000    191.37697\n",
            "648 2018-07-30 191.90 192.20 189.07 189.91 187.78291  21029500    189.68431\n",
            "649 2018-07-31 190.30 192.14 189.34 190.29 188.15865  39373000    189.87955\n",
            "650 2018-08-01 199.13 201.76 197.31 201.50 199.24309  67935700    199.43769\n",
            "651 2018-08-02 200.58 208.38 200.35 207.39 205.06712  62404000    204.59904\n",
            "652 2018-08-03 207.03 208.74 205.48 207.99 205.66042  33447400    206.62681\n",
            "653 2018-08-06 208.00 209.25 207.07 209.07 206.72832  25425400    207.68277\n",
            "654 2018-08-07 209.32 209.50 206.76 207.11 204.79027  25587400    207.01675\n",
            "655 2018-08-08 206.05 207.81 204.52 207.25 204.92870  22525500    205.75290\n",
            "656 2018-08-09 207.28 209.78 207.20 208.88 206.54044  23469200    207.84014\n",
            "657 2018-08-10 207.36 209.10 206.67 207.53 205.92523  24611200    207.23175\n",
            "658 2018-08-13 207.70 210.95 207.70 208.87 207.25488  25869100    208.63496\n",
            "659 2018-08-14 210.16 210.56 208.26 209.75 208.12807  20748000    208.98269\n",
            "660 2018-08-15 209.22 210.74 208.33 210.24 208.61427  28807600    209.22809\n",
            "661 2018-08-16 211.75 213.81 211.47 213.32 211.67047  28500400    212.31682\n",
            "662 2018-08-17 213.44 217.95 213.16 217.58 215.89752  35427000    215.66917\n",
            "663 2018-08-20 218.10 219.18 215.11 215.46 213.79393  30287700    216.02797\n",
            "664 2018-08-21 216.80 217.19 214.03 215.04 213.37717  26159800    214.86572\n",
            "665 2018-08-22 214.10 216.36 213.84 215.05 213.38709  19018100    214.52903\n",
            "666 2018-08-23 214.65 217.05 214.60 215.49 213.82369  18883200    215.15790\n",
            "667 2018-08-24 216.60 216.90 215.11 216.16 214.48850  18476400    215.49950\n",
            "668 2018-08-27 217.15 218.74 216.33 217.94 216.25475  20525100    217.10825\n",
            "669 2018-08-28 219.01 220.54 218.92 219.70 218.00113  22776800    219.15371\n",
            "670 2018-08-29 220.15 223.49 219.41 222.98 221.25575  27254800    221.38525\n",
            "671 2018-08-30 223.25 228.26 222.40 225.03 223.28992  48793800    224.64997\n",
            "672 2018-08-31 226.51 228.87 226.00 227.63 225.86981  43340100    226.91327\n",
            "673 2018-09-04 228.41 229.18 226.63 228.36 226.59416  27390100    227.46805\n",
            "674 2018-09-05 228.99 229.67 225.10 226.87 225.11568  33333000    226.62856\n",
            "675 2018-09-06 226.23 227.35 221.30 223.10 221.37485  34290000    223.34162\n",
            "676 2018-09-07 221.85 225.37 220.71 221.30 219.58876  37619800    221.88959\n",
            "677 2018-09-10 220.95 221.85 216.47 218.33 216.64172  39516500    218.32058\n",
            "678 2018-09-11 218.01 224.30 216.56 223.85 222.11905  35749000    220.99302\n",
            "679 2018-09-12 224.94 225.00 219.84 221.07 219.36055  49278700    221.40018\n",
            "680 2018-09-13 223.52 228.35 222.57 226.41 224.65926  41706400    225.19309\n",
            "681 2018-09-14 225.75 226.84 222.52 223.84 222.10910  31999300    223.82303\n",
            "682 2018-09-17 222.15 222.95 217.27 217.88 216.19521  37195100    218.80507\n",
            "683 2018-09-18 217.79 221.85 217.12 218.24 216.55241  31571700    218.50747\n",
            "684 2018-09-19 218.50 219.62 215.30 218.37 216.68141  27123800    217.20047\n",
            "685 2018-09-20 220.24 222.28 219.15 220.03 218.32858  26608800    219.91953\n",
            "686 2018-09-21 220.78 221.36 217.29 217.66 215.97691  96246700    218.20897\n",
            "687 2018-09-24 216.82 221.26 216.63 220.79 219.08269  27693400    218.99090\n",
            "688 2018-09-25 219.75 222.82 219.70 222.19 220.47188  24554400    220.99729\n",
            "689 2018-09-26 221.00 223.75 219.76 220.42 218.71556  23984700    220.74185\n",
            "690 2018-09-27 223.82 226.44 223.54 224.95 223.21053  30181200    224.39684\n",
            "691 2018-09-28 224.79 225.84 224.02 225.74 223.99443  22929400    224.61814\n",
            "692 2018-10-01 227.95 229.42 226.35 227.26 225.50267  23600800    227.09089\n",
            "693 2018-10-02 227.25 230.00 226.63 229.28 227.50705  24788200    228.04568\n",
            "694 2018-10-03 230.05 233.47 229.78 232.07 230.27548  28654800    231.17516\n",
            "695 2018-10-04 230.78 232.35 226.73 227.99 226.22704  32042000    228.43568\n",
            "696 2018-10-05 227.96 228.41 220.58 224.29 222.55563  33580500    223.84855\n",
            "697 2018-10-08 222.21 224.80 220.20 223.77 222.03966  29663900    222.34655\n",
            "698 2018-10-09 223.64 227.27 222.25 226.87 225.11568  26891000    224.87856\n",
            "699 2018-10-10 225.46 226.35 216.05 216.36 214.68697  41990600    219.02899\n",
            "700 2018-10-11 214.52 219.50 212.32 214.45 212.79172  53124400    214.87058\n",
            "701 2018-10-12 220.42 222.88 216.84 222.11 220.39250  40337900    220.03750\n",
            "702 2018-10-15 221.16 221.83 217.27 217.36 215.67923  30791000    218.25975\n",
            "703 2018-10-16 218.93 222.99 216.76 222.15 220.43218  29184000    220.06072\n",
            "704 2018-10-17 222.30 222.64 219.34 221.19 219.47961  22885400    220.48654\n",
            "705 2018-10-18 217.86 219.74 213.00 216.02 214.34958  32581300    215.69653\n",
            "706 2018-10-19 218.06 221.26 217.43 219.31 217.61415  33078700    218.76805\n",
            "707 2018-10-22 219.79 223.36 218.94 220.65 218.94377  28792100    220.41459\n",
            "708 2018-10-23 215.83 223.25 214.70 222.73 221.00769  38767800    219.65256\n",
            "709 2018-10-24 222.60 224.23 214.54 215.09 213.42677  40925500    217.39892\n",
            "710 2018-10-25 217.71 221.38 216.75 219.80 218.10036  29855800    218.74345\n",
            "711 2018-10-26 215.90 220.19 212.67 216.30 214.62741  47258400    215.82914\n",
            "712 2018-10-29 219.19 219.69 206.09 212.24 210.59883  45935500    212.12628\n",
            "713 2018-10-30 211.15 215.18 209.27 213.30 211.65062  36660000    212.03354\n",
            "714 2018-10-31 216.88 220.45 216.62 218.86 217.16762  38358900    218.07920\n",
            "715 2018-11-01 219.05 222.36 216.81 222.22 220.50163  58323200    219.89054\n",
            "716 2018-11-02 209.55 213.65 205.43 207.48 205.87561  91328700    208.31853\n",
            "717 2018-11-05 204.30 204.39 198.17 201.59 200.03116  66163700    200.86372\n",
            "718 2018-11-06 201.92 204.72 201.69 203.77 202.19432  31882900    202.86811\n",
            "719 2018-11-07 205.97 210.06 204.13 209.95 208.32651  33424400    207.50550\n",
            "720 2018-11-08 209.98 210.12 206.75 208.49 207.59966  25362600    208.15655\n",
            "721 2018-11-09 205.55 206.01 202.25 204.47 203.59682  34365800    203.95227\n",
            "722 2018-11-12 199.00 199.85 193.79 194.17 193.34079  51135500    195.66026\n",
            "723 2018-11-13 191.63 197.18 191.45 192.23 191.40907  46882900    193.34635\n",
            "724 2018-11-14 193.90 194.48 185.93 186.80 186.00227  60801000    188.80409\n",
            "725 2018-11-15 188.39 191.97 186.90 191.41 190.59259  46478800    189.82086\n",
            "726 2018-11-16 190.50 194.97 189.46 193.53 192.70354  36928300    192.37785\n",
            "727 2018-11-19 190.00 190.70 184.99 185.86 185.06628  41925300    186.91876\n",
            "728 2018-11-20 178.37 181.47 175.51 176.98 176.22420  67825200    177.73473\n",
            "729 2018-11-21 179.73 180.27 176.55 176.78 176.02506  31124200    177.61502\n",
            "730 2018-11-23 174.94 176.60 172.10 172.29 171.55423  23624000    173.41808\n",
            "731 2018-11-26 174.24 174.95 170.26 174.62 173.87428  44998500    173.02809\n",
            "732 2018-11-27 171.51 174.77 170.88 174.24 173.49591  41387400    173.04864\n",
            "733 2018-11-28 176.73 181.29 174.93 180.94 180.16730  46062500    178.79576\n",
            "734 2018-11-29 182.66 182.80 177.70 179.55 178.78323  41770000    179.76108\n",
            "735 2018-11-30 180.29 180.33 177.03 178.58 177.81738  39531500    178.39246\n",
            "736 2018-12-03 184.46 184.94 181.21 184.82 184.03073  40802500    183.39358\n",
            "737 2018-12-04 180.95 182.39 176.27 176.69 175.93545  41344300    178.19849\n",
            "738 2018-12-06 171.76 174.78 170.42 174.72 173.97386  43098400    173.05795\n",
            "739 2018-12-07 173.49 174.49 168.30 168.49 167.77048  42281600    170.18683\n",
            "740 2018-12-10 165.00 170.09 163.33 169.60 168.87573  62026000    167.43191\n",
            "741 2018-12-11 171.66 171.79 167.00 168.63 167.90987  47281700    168.89995\n",
            "742 2018-12-12 170.40 171.92 169.02 169.10 168.37787  35627700    169.77262\n",
            "743 2018-12-13 170.49 172.57 169.55 170.95 170.21995  31898600    170.77999\n",
            "744 2018-12-14 169.00 169.08 165.28 165.48 164.77331  40703700    166.37777\n",
            "745 2018-12-17 165.45 168.35 162.73 163.94 163.23990  44287900    164.77330\n",
            "746 2018-12-18 165.38 167.53 164.39 166.07 165.36081  33841500    165.76027\n",
            "747 2018-12-19 166.00 167.45 159.09 160.89 160.20293  49047300    162.24764\n",
            "748 2018-12-20 160.40 162.11 155.30 156.83 156.16026  64773000    157.85676\n",
            "749 2018-12-21 156.86 158.16 149.63 150.73 150.08630  95744600    152.62544\n",
            "750 2018-12-24 148.15 151.55 146.59 146.83 146.20297  37169200    148.11432\n",
            "751 2018-12-26 148.30 157.23 146.72 157.17 156.49881  58582500    153.48294\n",
            "752 2018-12-27 155.84 156.77 150.07 156.15 155.48315  53117100    154.10772\n",
            "753 2018-12-28 157.50 158.52 154.55 156.23 155.56282  42291400    156.21094\n",
            "754 2018-12-31 158.53 159.36 156.48 157.74 157.06638  35003500    157.63546\n"
          ]
        }
      ],
      "execution_count": 11,
      "metadata": {
        "collapsed": false,
        "outputHidden": false,
        "inputHidden": false
      }
    }
  ],
  "metadata": {
    "kernel_info": {
      "name": "ir"
    },
    "language_info": {
      "name": "R",
      "codemirror_mode": "r",
      "pygments_lexer": "r",
      "mimetype": "text/x-r-source",
      "file_extension": ".r",
      "version": "3.5.2"
    },
    "kernelspec": {
      "name": "ir",
      "language": "R",
      "display_name": "R"
    },
    "nteract": {
      "version": "0.14.2"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}