05_ML_Predictor.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Model_Training_Financial_Karthik.ipynb",
      "provenance": [],
      "collapsed_sections": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "metadata": {
        "id": "qfvIkmqgz5ck",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "\n",
        "import pandas as pd\n",
        "import numpy as np\n",
        "import xgboost as xgb\n",
        "import matplotlib.pyplot as plt\n",
        "from sklearn.preprocessing import StandardScaler\n",
        "from sklearn.linear_model import LinearRegression \n",
        "from sklearn.model_selection import train_test_split \n",
        "from sklearn.metrics import mean_squared_error\n",
        "from sklearn.metrics import mean_absolute_error\n",
        "from sklearn import svm\n",
        "import datetime"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZO5Ad-VX1vu6",
        "colab_type": "code",
        "outputId": "b5f7238e-67b6-4049-e631-50f3c0c6bba5",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 758
        }
      },
      "source": [
        "import pandas as pd\n",
        "import pickle\n",
        "f = open(\"final_data.pkl\", \"rb\")\n",
        "all_data = pickle.load(f)\n",
        "# now data has the data\n",
        "all_data"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>index</th>\n",
              "      <th>open</th>\n",
              "      <th>close</th>\n",
              "      <th>vector</th>\n",
              "      <th>0</th>\n",
              "      <th>1</th>\n",
              "      <th>2</th>\n",
              "      <th>3</th>\n",
              "      <th>4</th>\n",
              "      <th>5</th>\n",
              "      <th>6</th>\n",
              "      <th>7</th>\n",
              "      <th>8</th>\n",
              "      <th>9</th>\n",
              "      <th>10</th>\n",
              "      <th>11</th>\n",
              "      <th>12</th>\n",
              "      <th>13</th>\n",
              "      <th>14</th>\n",
              "      <th>15</th>\n",
              "      <th>16</th>\n",
              "      <th>17</th>\n",
              "      <th>18</th>\n",
              "      <th>19</th>\n",
              "      <th>20</th>\n",
              "      <th>21</th>\n",
              "      <th>22</th>\n",
              "      <th>23</th>\n",
              "      <th>24</th>\n",
              "      <th>25</th>\n",
              "      <th>26</th>\n",
              "      <th>27</th>\n",
              "      <th>28</th>\n",
              "      <th>29</th>\n",
              "      <th>30</th>\n",
              "      <th>31</th>\n",
              "      <th>32</th>\n",
              "      <th>33</th>\n",
              "      <th>34</th>\n",
              "      <th>35</th>\n",
              "      <th>...</th>\n",
              "      <th>260</th>\n",
              "      <th>261</th>\n",
              "      <th>262</th>\n",
              "      <th>263</th>\n",
              "      <th>264</th>\n",
              "      <th>265</th>\n",
              "      <th>266</th>\n",
              "      <th>267</th>\n",
              "      <th>268</th>\n",
              "      <th>269</th>\n",
              "      <th>270</th>\n",
              "      <th>271</th>\n",
              "      <th>272</th>\n",
              "      <th>273</th>\n",
              "      <th>274</th>\n",
              "      <th>275</th>\n",
              "      <th>276</th>\n",
              "      <th>277</th>\n",
              "      <th>278</th>\n",
              "      <th>279</th>\n",
              "      <th>280</th>\n",
              "      <th>281</th>\n",
              "      <th>282</th>\n",
              "      <th>283</th>\n",
              "      <th>284</th>\n",
              "      <th>285</th>\n",
              "      <th>286</th>\n",
              "      <th>287</th>\n",
              "      <th>288</th>\n",
              "      <th>289</th>\n",
              "      <th>290</th>\n",
              "      <th>291</th>\n",
              "      <th>292</th>\n",
              "      <th>293</th>\n",
              "      <th>294</th>\n",
              "      <th>295</th>\n",
              "      <th>296</th>\n",
              "      <th>297</th>\n",
              "      <th>298</th>\n",
              "      <th>299</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2020-02-10</td>\n",
              "      <td>768.79</td>\n",
              "      <td>771.2800</td>\n",
              "      <td>[-0.010529628023505211, 0.09834949672222137, -...</td>\n",
              "      <td>-0.010530</td>\n",
              "      <td>0.098349</td>\n",
              "      <td>-0.045928</td>\n",
              "      <td>-0.011833</td>\n",
              "      <td>0.000039</td>\n",
              "      <td>-0.035110</td>\n",
              "      <td>0.026545</td>\n",
              "      <td>0.010549</td>\n",
              "      <td>-0.045595</td>\n",
              "      <td>0.464039</td>\n",
              "      <td>-0.007673</td>\n",
              "      <td>0.000267</td>\n",
              "      <td>-0.039774</td>\n",
              "      <td>0.021322</td>\n",
              "      <td>-0.062420</td>\n",
              "      <td>-0.019703</td>\n",
              "      <td>-0.040905</td>\n",
              "      <td>0.390657</td>\n",
              "      <td>-0.040404</td>\n",
              "      <td>0.048236</td>\n",
              "      <td>-0.027159</td>\n",
              "      <td>-0.013454</td>\n",
              "      <td>0.046854</td>\n",
              "      <td>-0.032057</td>\n",
              "      <td>-0.018340</td>\n",
              "      <td>-0.019731</td>\n",
              "      <td>-0.074852</td>\n",
              "      <td>-0.038799</td>\n",
              "      <td>0.088942</td>\n",
              "      <td>0.000842</td>\n",
              "      <td>-0.046198</td>\n",
              "      <td>-0.020416</td>\n",
              "      <td>-0.024594</td>\n",
              "      <td>-0.033290</td>\n",
              "      <td>0.038381</td>\n",
              "      <td>-0.072644</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.039115</td>\n",
              "      <td>-0.052305</td>\n",
              "      <td>0.003053</td>\n",
              "      <td>0.023218</td>\n",
              "      <td>-0.004120</td>\n",
              "      <td>0.002400</td>\n",
              "      <td>0.004611</td>\n",
              "      <td>0.104128</td>\n",
              "      <td>0.078473</td>\n",
              "      <td>-0.016218</td>\n",
              "      <td>0.172741</td>\n",
              "      <td>-0.012899</td>\n",
              "      <td>-0.031154</td>\n",
              "      <td>0.003300</td>\n",
              "      <td>0.046798</td>\n",
              "      <td>0.024688</td>\n",
              "      <td>0.024468</td>\n",
              "      <td>0.001825</td>\n",
              "      <td>0.015203</td>\n",
              "      <td>0.037794</td>\n",
              "      <td>-0.033292</td>\n",
              "      <td>-0.007909</td>\n",
              "      <td>0.005622</td>\n",
              "      <td>0.000046</td>\n",
              "      <td>-0.071204</td>\n",
              "      <td>-0.018797</td>\n",
              "      <td>-0.028606</td>\n",
              "      <td>-0.059602</td>\n",
              "      <td>0.037949</td>\n",
              "      <td>-0.052446</td>\n",
              "      <td>-0.045793</td>\n",
              "      <td>-0.072902</td>\n",
              "      <td>0.039745</td>\n",
              "      <td>-0.095667</td>\n",
              "      <td>-0.010243</td>\n",
              "      <td>-0.072656</td>\n",
              "      <td>0.037246</td>\n",
              "      <td>0.000729</td>\n",
              "      <td>-0.009160</td>\n",
              "      <td>0.031896</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2020-01-03</td>\n",
              "      <td>440.47</td>\n",
              "      <td>443.0100</td>\n",
              "      <td>[-0.4195824184571393, 4.046570305654313, -0.82...</td>\n",
              "      <td>-0.419582</td>\n",
              "      <td>4.046570</td>\n",
              "      <td>-0.821298</td>\n",
              "      <td>-0.124958</td>\n",
              "      <td>0.078892</td>\n",
              "      <td>-1.239797</td>\n",
              "      <td>0.506607</td>\n",
              "      <td>-1.720687</td>\n",
              "      <td>-0.335473</td>\n",
              "      <td>24.625812</td>\n",
              "      <td>-1.674629</td>\n",
              "      <td>0.609996</td>\n",
              "      <td>0.319260</td>\n",
              "      <td>-0.856638</td>\n",
              "      <td>-2.015128</td>\n",
              "      <td>-0.996078</td>\n",
              "      <td>-1.299597</td>\n",
              "      <td>19.581936</td>\n",
              "      <td>-1.796622</td>\n",
              "      <td>-1.010514</td>\n",
              "      <td>0.830938</td>\n",
              "      <td>0.184110</td>\n",
              "      <td>0.203215</td>\n",
              "      <td>-1.106292</td>\n",
              "      <td>0.235508</td>\n",
              "      <td>0.729707</td>\n",
              "      <td>-1.084618</td>\n",
              "      <td>-0.286390</td>\n",
              "      <td>1.518729</td>\n",
              "      <td>0.792822</td>\n",
              "      <td>-0.218741</td>\n",
              "      <td>-0.500823</td>\n",
              "      <td>-0.114990</td>\n",
              "      <td>1.218946</td>\n",
              "      <td>1.497805</td>\n",
              "      <td>-1.100177</td>\n",
              "      <td>...</td>\n",
              "      <td>2.377019</td>\n",
              "      <td>2.087115</td>\n",
              "      <td>0.281279</td>\n",
              "      <td>0.929935</td>\n",
              "      <td>0.320272</td>\n",
              "      <td>-2.383286</td>\n",
              "      <td>-0.261530</td>\n",
              "      <td>1.090553</td>\n",
              "      <td>4.185575</td>\n",
              "      <td>0.447643</td>\n",
              "      <td>1.443201</td>\n",
              "      <td>-0.361346</td>\n",
              "      <td>-0.032489</td>\n",
              "      <td>-1.228383</td>\n",
              "      <td>-0.458936</td>\n",
              "      <td>0.207309</td>\n",
              "      <td>-0.039224</td>\n",
              "      <td>0.669236</td>\n",
              "      <td>1.092565</td>\n",
              "      <td>1.517070</td>\n",
              "      <td>0.633888</td>\n",
              "      <td>1.275198</td>\n",
              "      <td>0.066641</td>\n",
              "      <td>0.758871</td>\n",
              "      <td>0.046087</td>\n",
              "      <td>-0.509770</td>\n",
              "      <td>1.070561</td>\n",
              "      <td>-1.299019</td>\n",
              "      <td>0.045601</td>\n",
              "      <td>-0.348186</td>\n",
              "      <td>-3.327241</td>\n",
              "      <td>0.828651</td>\n",
              "      <td>2.196073</td>\n",
              "      <td>-0.262937</td>\n",
              "      <td>0.344921</td>\n",
              "      <td>-1.721509</td>\n",
              "      <td>-0.774386</td>\n",
              "      <td>-0.443695</td>\n",
              "      <td>-0.107372</td>\n",
              "      <td>2.147399</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2020-01-02</td>\n",
              "      <td>440.50</td>\n",
              "      <td>430.2600</td>\n",
              "      <td>[0.2606369946151972, 0.6727603478357196, -0.07...</td>\n",
              "      <td>0.260637</td>\n",
              "      <td>0.672760</td>\n",
              "      <td>-0.074915</td>\n",
              "      <td>0.133570</td>\n",
              "      <td>0.179052</td>\n",
              "      <td>-0.046128</td>\n",
              "      <td>0.036259</td>\n",
              "      <td>-0.274081</td>\n",
              "      <td>-0.232924</td>\n",
              "      <td>2.881890</td>\n",
              "      <td>-0.199384</td>\n",
              "      <td>0.061396</td>\n",
              "      <td>-0.251091</td>\n",
              "      <td>-0.168093</td>\n",
              "      <td>-0.231142</td>\n",
              "      <td>-0.104217</td>\n",
              "      <td>-0.324346</td>\n",
              "      <td>2.919163</td>\n",
              "      <td>-0.482350</td>\n",
              "      <td>-0.077116</td>\n",
              "      <td>0.087737</td>\n",
              "      <td>-0.326059</td>\n",
              "      <td>0.146974</td>\n",
              "      <td>-0.294548</td>\n",
              "      <td>-0.289237</td>\n",
              "      <td>0.223385</td>\n",
              "      <td>-0.096183</td>\n",
              "      <td>0.075815</td>\n",
              "      <td>0.267266</td>\n",
              "      <td>0.357177</td>\n",
              "      <td>-0.089957</td>\n",
              "      <td>0.063248</td>\n",
              "      <td>0.208909</td>\n",
              "      <td>0.252365</td>\n",
              "      <td>0.148010</td>\n",
              "      <td>-0.128405</td>\n",
              "      <td>...</td>\n",
              "      <td>0.202719</td>\n",
              "      <td>0.245576</td>\n",
              "      <td>0.187146</td>\n",
              "      <td>-0.111262</td>\n",
              "      <td>0.266358</td>\n",
              "      <td>-0.195035</td>\n",
              "      <td>0.010573</td>\n",
              "      <td>0.511056</td>\n",
              "      <td>0.307005</td>\n",
              "      <td>0.239992</td>\n",
              "      <td>-0.111199</td>\n",
              "      <td>0.092526</td>\n",
              "      <td>0.052587</td>\n",
              "      <td>-0.085673</td>\n",
              "      <td>-0.027430</td>\n",
              "      <td>0.111592</td>\n",
              "      <td>0.163198</td>\n",
              "      <td>-0.031398</td>\n",
              "      <td>-0.134688</td>\n",
              "      <td>0.023019</td>\n",
              "      <td>0.016885</td>\n",
              "      <td>0.156086</td>\n",
              "      <td>0.313640</td>\n",
              "      <td>-0.080347</td>\n",
              "      <td>0.020779</td>\n",
              "      <td>-0.108167</td>\n",
              "      <td>0.017540</td>\n",
              "      <td>-0.122178</td>\n",
              "      <td>-0.073524</td>\n",
              "      <td>-0.087641</td>\n",
              "      <td>-0.278707</td>\n",
              "      <td>-0.139921</td>\n",
              "      <td>0.088437</td>\n",
              "      <td>-0.165880</td>\n",
              "      <td>0.179655</td>\n",
              "      <td>0.095238</td>\n",
              "      <td>-0.036637</td>\n",
              "      <td>0.285722</td>\n",
              "      <td>-0.086894</td>\n",
              "      <td>0.149904</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2019-11-19</td>\n",
              "      <td>360.00</td>\n",
              "      <td>359.5200</td>\n",
              "      <td>[-0.03865484055131674, 0.4882129020988941, -0....</td>\n",
              "      <td>-0.038655</td>\n",
              "      <td>0.488213</td>\n",
              "      <td>-0.191833</td>\n",
              "      <td>-0.085065</td>\n",
              "      <td>0.095400</td>\n",
              "      <td>-0.165370</td>\n",
              "      <td>0.060908</td>\n",
              "      <td>-0.336775</td>\n",
              "      <td>0.074119</td>\n",
              "      <td>3.231776</td>\n",
              "      <td>-0.371671</td>\n",
              "      <td>0.041697</td>\n",
              "      <td>0.058887</td>\n",
              "      <td>-0.196129</td>\n",
              "      <td>-0.241486</td>\n",
              "      <td>-0.031997</td>\n",
              "      <td>-0.246629</td>\n",
              "      <td>2.124208</td>\n",
              "      <td>-0.210703</td>\n",
              "      <td>-0.076747</td>\n",
              "      <td>0.226441</td>\n",
              "      <td>-0.064183</td>\n",
              "      <td>0.006958</td>\n",
              "      <td>-0.108566</td>\n",
              "      <td>0.016339</td>\n",
              "      <td>0.144655</td>\n",
              "      <td>-0.195437</td>\n",
              "      <td>-0.040126</td>\n",
              "      <td>0.103941</td>\n",
              "      <td>0.264947</td>\n",
              "      <td>0.063838</td>\n",
              "      <td>-0.051996</td>\n",
              "      <td>-0.050581</td>\n",
              "      <td>0.338113</td>\n",
              "      <td>0.238084</td>\n",
              "      <td>-0.153214</td>\n",
              "      <td>...</td>\n",
              "      <td>0.302983</td>\n",
              "      <td>0.188003</td>\n",
              "      <td>0.038411</td>\n",
              "      <td>0.092598</td>\n",
              "      <td>0.078161</td>\n",
              "      <td>-0.287610</td>\n",
              "      <td>-0.057278</td>\n",
              "      <td>0.131842</td>\n",
              "      <td>0.318623</td>\n",
              "      <td>0.033791</td>\n",
              "      <td>0.171544</td>\n",
              "      <td>-0.074002</td>\n",
              "      <td>-0.041412</td>\n",
              "      <td>-0.101353</td>\n",
              "      <td>-0.011238</td>\n",
              "      <td>-0.054416</td>\n",
              "      <td>-0.096314</td>\n",
              "      <td>0.000646</td>\n",
              "      <td>0.116481</td>\n",
              "      <td>0.095254</td>\n",
              "      <td>0.169899</td>\n",
              "      <td>0.047401</td>\n",
              "      <td>0.016519</td>\n",
              "      <td>0.141191</td>\n",
              "      <td>-0.052866</td>\n",
              "      <td>-0.016772</td>\n",
              "      <td>0.094082</td>\n",
              "      <td>-0.090283</td>\n",
              "      <td>0.149669</td>\n",
              "      <td>-0.144825</td>\n",
              "      <td>-0.417886</td>\n",
              "      <td>0.014717</td>\n",
              "      <td>0.286323</td>\n",
              "      <td>-0.117986</td>\n",
              "      <td>-0.033695</td>\n",
              "      <td>-0.175512</td>\n",
              "      <td>-0.118734</td>\n",
              "      <td>-0.125407</td>\n",
              "      <td>-0.009186</td>\n",
              "      <td>0.220200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2019-11-07</td>\n",
              "      <td>334.50</td>\n",
              "      <td>335.5400</td>\n",
              "      <td>[0.010165030136704445, 0.6968159340322018, -0....</td>\n",
              "      <td>0.010165</td>\n",
              "      <td>0.696816</td>\n",
              "      <td>-0.041311</td>\n",
              "      <td>-0.263856</td>\n",
              "      <td>0.368052</td>\n",
              "      <td>-0.148849</td>\n",
              "      <td>-0.007752</td>\n",
              "      <td>-0.432938</td>\n",
              "      <td>0.058721</td>\n",
              "      <td>5.665106</td>\n",
              "      <td>-0.688363</td>\n",
              "      <td>0.048936</td>\n",
              "      <td>0.163013</td>\n",
              "      <td>-0.252358</td>\n",
              "      <td>-0.477406</td>\n",
              "      <td>0.038895</td>\n",
              "      <td>-0.429953</td>\n",
              "      <td>4.602379</td>\n",
              "      <td>-0.506534</td>\n",
              "      <td>-0.255824</td>\n",
              "      <td>0.327551</td>\n",
              "      <td>-0.121507</td>\n",
              "      <td>0.146235</td>\n",
              "      <td>-0.169132</td>\n",
              "      <td>0.116315</td>\n",
              "      <td>0.262696</td>\n",
              "      <td>-0.119440</td>\n",
              "      <td>0.034605</td>\n",
              "      <td>0.317691</td>\n",
              "      <td>0.350574</td>\n",
              "      <td>-0.155853</td>\n",
              "      <td>0.175069</td>\n",
              "      <td>0.063007</td>\n",
              "      <td>0.368334</td>\n",
              "      <td>0.182164</td>\n",
              "      <td>-0.359126</td>\n",
              "      <td>...</td>\n",
              "      <td>0.416243</td>\n",
              "      <td>0.572453</td>\n",
              "      <td>0.031796</td>\n",
              "      <td>0.009834</td>\n",
              "      <td>0.170258</td>\n",
              "      <td>-0.637243</td>\n",
              "      <td>0.006125</td>\n",
              "      <td>0.202336</td>\n",
              "      <td>0.633837</td>\n",
              "      <td>-0.011023</td>\n",
              "      <td>0.127955</td>\n",
              "      <td>-0.067466</td>\n",
              "      <td>-0.317820</td>\n",
              "      <td>-0.672999</td>\n",
              "      <td>-0.188789</td>\n",
              "      <td>0.034988</td>\n",
              "      <td>0.127537</td>\n",
              "      <td>0.056095</td>\n",
              "      <td>0.213908</td>\n",
              "      <td>0.317358</td>\n",
              "      <td>0.457804</td>\n",
              "      <td>0.246731</td>\n",
              "      <td>-0.154674</td>\n",
              "      <td>0.024880</td>\n",
              "      <td>-0.007467</td>\n",
              "      <td>-0.341912</td>\n",
              "      <td>0.080073</td>\n",
              "      <td>-0.156554</td>\n",
              "      <td>0.064298</td>\n",
              "      <td>-0.091419</td>\n",
              "      <td>-0.734608</td>\n",
              "      <td>0.009351</td>\n",
              "      <td>0.568975</td>\n",
              "      <td>-0.185727</td>\n",
              "      <td>0.111318</td>\n",
              "      <td>-0.384590</td>\n",
              "      <td>-0.230492</td>\n",
              "      <td>0.189818</td>\n",
              "      <td>-0.041457</td>\n",
              "      <td>0.219561</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1560</th>\n",
              "      <td>2012-12-21</td>\n",
              "      <td>33.64</td>\n",
              "      <td>34.0000</td>\n",
              "      <td>[0.0011539468541741371, 0.08054973930120468, -...</td>\n",
              "      <td>0.001154</td>\n",
              "      <td>0.080550</td>\n",
              "      <td>-0.046503</td>\n",
              "      <td>-0.032234</td>\n",
              "      <td>0.017378</td>\n",
              "      <td>-0.007543</td>\n",
              "      <td>0.018119</td>\n",
              "      <td>-0.046309</td>\n",
              "      <td>-0.004964</td>\n",
              "      <td>0.666836</td>\n",
              "      <td>-0.036337</td>\n",
              "      <td>0.014083</td>\n",
              "      <td>0.028625</td>\n",
              "      <td>-0.015268</td>\n",
              "      <td>-0.056148</td>\n",
              "      <td>-0.015998</td>\n",
              "      <td>-0.033109</td>\n",
              "      <td>0.339428</td>\n",
              "      <td>-0.045860</td>\n",
              "      <td>0.002016</td>\n",
              "      <td>0.002940</td>\n",
              "      <td>-0.020550</td>\n",
              "      <td>-0.001827</td>\n",
              "      <td>-0.007933</td>\n",
              "      <td>0.000495</td>\n",
              "      <td>0.015960</td>\n",
              "      <td>-0.036518</td>\n",
              "      <td>-0.041102</td>\n",
              "      <td>0.012735</td>\n",
              "      <td>-0.032119</td>\n",
              "      <td>-0.034420</td>\n",
              "      <td>0.035072</td>\n",
              "      <td>0.024528</td>\n",
              "      <td>0.006986</td>\n",
              "      <td>0.003308</td>\n",
              "      <td>-0.027061</td>\n",
              "      <td>...</td>\n",
              "      <td>0.051358</td>\n",
              "      <td>0.051385</td>\n",
              "      <td>0.013639</td>\n",
              "      <td>0.021820</td>\n",
              "      <td>0.028262</td>\n",
              "      <td>-0.009175</td>\n",
              "      <td>-0.008685</td>\n",
              "      <td>0.010959</td>\n",
              "      <td>0.102867</td>\n",
              "      <td>0.009125</td>\n",
              "      <td>0.058644</td>\n",
              "      <td>-0.024684</td>\n",
              "      <td>-0.062933</td>\n",
              "      <td>-0.043068</td>\n",
              "      <td>-0.017311</td>\n",
              "      <td>0.011048</td>\n",
              "      <td>0.001286</td>\n",
              "      <td>0.012282</td>\n",
              "      <td>0.011610</td>\n",
              "      <td>0.077472</td>\n",
              "      <td>0.076096</td>\n",
              "      <td>0.017258</td>\n",
              "      <td>0.009345</td>\n",
              "      <td>-0.028928</td>\n",
              "      <td>-0.020235</td>\n",
              "      <td>-0.023512</td>\n",
              "      <td>0.024613</td>\n",
              "      <td>-0.009947</td>\n",
              "      <td>0.021768</td>\n",
              "      <td>-0.023020</td>\n",
              "      <td>-0.048886</td>\n",
              "      <td>0.007171</td>\n",
              "      <td>0.016834</td>\n",
              "      <td>-0.006503</td>\n",
              "      <td>0.041791</td>\n",
              "      <td>-0.037994</td>\n",
              "      <td>-0.015102</td>\n",
              "      <td>-0.005336</td>\n",
              "      <td>0.011091</td>\n",
              "      <td>0.031600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1561</th>\n",
              "      <td>2012-11-12</td>\n",
              "      <td>31.29</td>\n",
              "      <td>31.0700</td>\n",
              "      <td>[0.04647105932235718, 0.0875493586063385, 0.02...</td>\n",
              "      <td>0.046471</td>\n",
              "      <td>0.087549</td>\n",
              "      <td>0.020803</td>\n",
              "      <td>-0.010359</td>\n",
              "      <td>-0.018569</td>\n",
              "      <td>-0.070328</td>\n",
              "      <td>0.038205</td>\n",
              "      <td>-0.035953</td>\n",
              "      <td>-0.000309</td>\n",
              "      <td>0.445255</td>\n",
              "      <td>-0.070960</td>\n",
              "      <td>-0.021908</td>\n",
              "      <td>0.008805</td>\n",
              "      <td>-0.007845</td>\n",
              "      <td>-0.055111</td>\n",
              "      <td>-0.015822</td>\n",
              "      <td>-0.085804</td>\n",
              "      <td>0.413454</td>\n",
              "      <td>-0.008883</td>\n",
              "      <td>-0.000776</td>\n",
              "      <td>0.052113</td>\n",
              "      <td>-0.028783</td>\n",
              "      <td>0.020277</td>\n",
              "      <td>-0.024565</td>\n",
              "      <td>-0.005597</td>\n",
              "      <td>0.087315</td>\n",
              "      <td>-0.015133</td>\n",
              "      <td>0.014124</td>\n",
              "      <td>0.028550</td>\n",
              "      <td>0.105915</td>\n",
              "      <td>-0.000378</td>\n",
              "      <td>-0.049893</td>\n",
              "      <td>0.004769</td>\n",
              "      <td>0.060624</td>\n",
              "      <td>0.087780</td>\n",
              "      <td>-0.023161</td>\n",
              "      <td>...</td>\n",
              "      <td>0.045448</td>\n",
              "      <td>0.054760</td>\n",
              "      <td>-0.022358</td>\n",
              "      <td>0.032279</td>\n",
              "      <td>0.006725</td>\n",
              "      <td>-0.063645</td>\n",
              "      <td>0.000693</td>\n",
              "      <td>0.046354</td>\n",
              "      <td>0.044601</td>\n",
              "      <td>-0.012617</td>\n",
              "      <td>0.016111</td>\n",
              "      <td>-0.007893</td>\n",
              "      <td>0.000671</td>\n",
              "      <td>-0.070442</td>\n",
              "      <td>0.010652</td>\n",
              "      <td>0.012318</td>\n",
              "      <td>0.024646</td>\n",
              "      <td>0.027765</td>\n",
              "      <td>0.025412</td>\n",
              "      <td>0.034197</td>\n",
              "      <td>-0.032823</td>\n",
              "      <td>0.027153</td>\n",
              "      <td>-0.002967</td>\n",
              "      <td>0.054978</td>\n",
              "      <td>0.043927</td>\n",
              "      <td>0.023311</td>\n",
              "      <td>0.016446</td>\n",
              "      <td>-0.055317</td>\n",
              "      <td>-0.024318</td>\n",
              "      <td>0.018599</td>\n",
              "      <td>-0.067712</td>\n",
              "      <td>0.007267</td>\n",
              "      <td>0.064695</td>\n",
              "      <td>-0.037769</td>\n",
              "      <td>0.018582</td>\n",
              "      <td>-0.048050</td>\n",
              "      <td>-0.033916</td>\n",
              "      <td>0.006268</td>\n",
              "      <td>-0.012020</td>\n",
              "      <td>0.027254</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1562</th>\n",
              "      <td>2012-11-01</td>\n",
              "      <td>29.27</td>\n",
              "      <td>29.2454</td>\n",
              "      <td>[0.05331643112003803, 0.2084670141339302, 0.02...</td>\n",
              "      <td>0.053316</td>\n",
              "      <td>0.208467</td>\n",
              "      <td>0.028113</td>\n",
              "      <td>0.012835</td>\n",
              "      <td>-0.035201</td>\n",
              "      <td>-0.110717</td>\n",
              "      <td>0.067742</td>\n",
              "      <td>-0.050683</td>\n",
              "      <td>-0.037390</td>\n",
              "      <td>0.908033</td>\n",
              "      <td>-0.209244</td>\n",
              "      <td>-0.018876</td>\n",
              "      <td>-0.001891</td>\n",
              "      <td>-0.057978</td>\n",
              "      <td>-0.127619</td>\n",
              "      <td>-0.005628</td>\n",
              "      <td>-0.168104</td>\n",
              "      <td>0.760077</td>\n",
              "      <td>-0.019652</td>\n",
              "      <td>0.005223</td>\n",
              "      <td>0.103235</td>\n",
              "      <td>-0.020599</td>\n",
              "      <td>0.058732</td>\n",
              "      <td>-0.043471</td>\n",
              "      <td>0.020683</td>\n",
              "      <td>0.139655</td>\n",
              "      <td>-0.013933</td>\n",
              "      <td>0.045786</td>\n",
              "      <td>0.055577</td>\n",
              "      <td>0.175737</td>\n",
              "      <td>0.035172</td>\n",
              "      <td>-0.057107</td>\n",
              "      <td>0.004968</td>\n",
              "      <td>0.178322</td>\n",
              "      <td>0.119352</td>\n",
              "      <td>-0.044231</td>\n",
              "      <td>...</td>\n",
              "      <td>0.102717</td>\n",
              "      <td>0.086294</td>\n",
              "      <td>-0.086840</td>\n",
              "      <td>0.073258</td>\n",
              "      <td>0.007694</td>\n",
              "      <td>-0.148075</td>\n",
              "      <td>-0.003626</td>\n",
              "      <td>0.040763</td>\n",
              "      <td>0.066440</td>\n",
              "      <td>0.003711</td>\n",
              "      <td>-0.019803</td>\n",
              "      <td>-0.015371</td>\n",
              "      <td>0.027712</td>\n",
              "      <td>-0.070566</td>\n",
              "      <td>0.006015</td>\n",
              "      <td>0.067794</td>\n",
              "      <td>0.027789</td>\n",
              "      <td>0.027432</td>\n",
              "      <td>0.022062</td>\n",
              "      <td>0.036204</td>\n",
              "      <td>-0.076316</td>\n",
              "      <td>0.006707</td>\n",
              "      <td>0.015551</td>\n",
              "      <td>0.085208</td>\n",
              "      <td>0.113152</td>\n",
              "      <td>-0.007980</td>\n",
              "      <td>0.032298</td>\n",
              "      <td>-0.082107</td>\n",
              "      <td>-0.052607</td>\n",
              "      <td>0.040649</td>\n",
              "      <td>-0.156620</td>\n",
              "      <td>-0.009864</td>\n",
              "      <td>0.083159</td>\n",
              "      <td>-0.082261</td>\n",
              "      <td>0.051352</td>\n",
              "      <td>-0.124707</td>\n",
              "      <td>-0.023358</td>\n",
              "      <td>-0.080174</td>\n",
              "      <td>0.022553</td>\n",
              "      <td>0.054556</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1563</th>\n",
              "      <td>2012-09-14</td>\n",
              "      <td>32.35</td>\n",
              "      <td>30.3900</td>\n",
              "      <td>[-0.05011148378252983, 0.09796100854873657, 0....</td>\n",
              "      <td>-0.050111</td>\n",
              "      <td>0.097961</td>\n",
              "      <td>0.040084</td>\n",
              "      <td>-0.001147</td>\n",
              "      <td>-0.041411</td>\n",
              "      <td>-0.043300</td>\n",
              "      <td>0.001605</td>\n",
              "      <td>-0.055593</td>\n",
              "      <td>-0.009566</td>\n",
              "      <td>0.532355</td>\n",
              "      <td>-0.101697</td>\n",
              "      <td>0.034329</td>\n",
              "      <td>0.016074</td>\n",
              "      <td>0.038805</td>\n",
              "      <td>-0.045839</td>\n",
              "      <td>0.002286</td>\n",
              "      <td>-0.011421</td>\n",
              "      <td>0.359941</td>\n",
              "      <td>-0.031954</td>\n",
              "      <td>-0.029731</td>\n",
              "      <td>0.036293</td>\n",
              "      <td>-0.064188</td>\n",
              "      <td>0.043951</td>\n",
              "      <td>0.019455</td>\n",
              "      <td>-0.053461</td>\n",
              "      <td>0.018777</td>\n",
              "      <td>0.000928</td>\n",
              "      <td>-0.008965</td>\n",
              "      <td>-0.024806</td>\n",
              "      <td>0.003424</td>\n",
              "      <td>0.027979</td>\n",
              "      <td>0.096629</td>\n",
              "      <td>-0.007553</td>\n",
              "      <td>-0.035057</td>\n",
              "      <td>0.017769</td>\n",
              "      <td>0.039170</td>\n",
              "      <td>...</td>\n",
              "      <td>0.044093</td>\n",
              "      <td>-0.016140</td>\n",
              "      <td>-0.062140</td>\n",
              "      <td>-0.021707</td>\n",
              "      <td>-0.038545</td>\n",
              "      <td>-0.014044</td>\n",
              "      <td>0.053007</td>\n",
              "      <td>0.026318</td>\n",
              "      <td>0.159803</td>\n",
              "      <td>0.049669</td>\n",
              "      <td>-0.066042</td>\n",
              "      <td>0.020231</td>\n",
              "      <td>-0.112440</td>\n",
              "      <td>-0.016680</td>\n",
              "      <td>-0.056696</td>\n",
              "      <td>-0.008878</td>\n",
              "      <td>0.016795</td>\n",
              "      <td>0.038932</td>\n",
              "      <td>0.022628</td>\n",
              "      <td>0.059328</td>\n",
              "      <td>0.057841</td>\n",
              "      <td>-0.024400</td>\n",
              "      <td>-0.015501</td>\n",
              "      <td>-0.046345</td>\n",
              "      <td>0.005504</td>\n",
              "      <td>-0.000803</td>\n",
              "      <td>0.105034</td>\n",
              "      <td>0.012430</td>\n",
              "      <td>0.033719</td>\n",
              "      <td>-0.012482</td>\n",
              "      <td>-0.060444</td>\n",
              "      <td>-0.008065</td>\n",
              "      <td>0.008618</td>\n",
              "      <td>-0.028784</td>\n",
              "      <td>0.083775</td>\n",
              "      <td>-0.074961</td>\n",
              "      <td>-0.025425</td>\n",
              "      <td>-0.020453</td>\n",
              "      <td>-0.030247</td>\n",
              "      <td>0.080751</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1564</th>\n",
              "      <td>2012-02-09</td>\n",
              "      <td>32.26</td>\n",
              "      <td>32.5800</td>\n",
              "      <td>[0.032809387892484665, 0.15807706117630005, 0....</td>\n",
              "      <td>0.032809</td>\n",
              "      <td>0.158077</td>\n",
              "      <td>0.020348</td>\n",
              "      <td>0.038550</td>\n",
              "      <td>-0.074135</td>\n",
              "      <td>-0.021159</td>\n",
              "      <td>0.070355</td>\n",
              "      <td>-0.051542</td>\n",
              "      <td>0.008305</td>\n",
              "      <td>0.120342</td>\n",
              "      <td>0.053337</td>\n",
              "      <td>-0.024198</td>\n",
              "      <td>-0.027383</td>\n",
              "      <td>-0.051990</td>\n",
              "      <td>-0.051306</td>\n",
              "      <td>0.021595</td>\n",
              "      <td>-0.079944</td>\n",
              "      <td>0.358448</td>\n",
              "      <td>-0.028045</td>\n",
              "      <td>-0.029133</td>\n",
              "      <td>0.024311</td>\n",
              "      <td>-0.009844</td>\n",
              "      <td>0.028636</td>\n",
              "      <td>-0.029174</td>\n",
              "      <td>0.011329</td>\n",
              "      <td>0.035447</td>\n",
              "      <td>-0.012565</td>\n",
              "      <td>0.011281</td>\n",
              "      <td>0.079013</td>\n",
              "      <td>0.090174</td>\n",
              "      <td>-0.059787</td>\n",
              "      <td>-0.003390</td>\n",
              "      <td>0.014204</td>\n",
              "      <td>0.079898</td>\n",
              "      <td>0.006395</td>\n",
              "      <td>0.002633</td>\n",
              "      <td>...</td>\n",
              "      <td>0.056204</td>\n",
              "      <td>0.045981</td>\n",
              "      <td>0.060122</td>\n",
              "      <td>-0.002836</td>\n",
              "      <td>-0.040280</td>\n",
              "      <td>-0.045609</td>\n",
              "      <td>-0.029865</td>\n",
              "      <td>0.045695</td>\n",
              "      <td>-0.011047</td>\n",
              "      <td>0.065111</td>\n",
              "      <td>-0.015595</td>\n",
              "      <td>-0.019489</td>\n",
              "      <td>-0.016505</td>\n",
              "      <td>0.013985</td>\n",
              "      <td>-0.019345</td>\n",
              "      <td>0.019192</td>\n",
              "      <td>0.010341</td>\n",
              "      <td>-0.023182</td>\n",
              "      <td>-0.062093</td>\n",
              "      <td>0.054111</td>\n",
              "      <td>0.031180</td>\n",
              "      <td>-0.020002</td>\n",
              "      <td>-0.013532</td>\n",
              "      <td>0.051220</td>\n",
              "      <td>0.069186</td>\n",
              "      <td>0.046565</td>\n",
              "      <td>0.018766</td>\n",
              "      <td>-0.011041</td>\n",
              "      <td>-0.033631</td>\n",
              "      <td>0.102022</td>\n",
              "      <td>-0.007516</td>\n",
              "      <td>0.026908</td>\n",
              "      <td>0.072936</td>\n",
              "      <td>0.003576</td>\n",
              "      <td>-0.035146</td>\n",
              "      <td>-0.031145</td>\n",
              "      <td>0.010972</td>\n",
              "      <td>-0.000367</td>\n",
              "      <td>-0.007931</td>\n",
              "      <td>0.052451</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1565 rows × 304 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "           index    open     close  ...       297       298       299\n",
              "0     2020-02-10  768.79  771.2800  ...  0.000729 -0.009160  0.031896\n",
              "1     2020-01-03  440.47  443.0100  ... -0.443695 -0.107372  2.147399\n",
              "2     2020-01-02  440.50  430.2600  ...  0.285722 -0.086894  0.149904\n",
              "3     2019-11-19  360.00  359.5200  ... -0.125407 -0.009186  0.220200\n",
              "4     2019-11-07  334.50  335.5400  ...  0.189818 -0.041457  0.219561\n",
              "...          ...     ...       ...  ...       ...       ...       ...\n",
              "1560  2012-12-21   33.64   34.0000  ... -0.005336  0.011091  0.031600\n",
              "1561  2012-11-12   31.29   31.0700  ...  0.006268 -0.012020  0.027254\n",
              "1562  2012-11-01   29.27   29.2454  ... -0.080174  0.022553  0.054556\n",
              "1563  2012-09-14   32.35   30.3900  ... -0.020453 -0.030247  0.080751\n",
              "1564  2012-02-09   32.26   32.5800  ... -0.000367 -0.007931  0.052451\n",
              "\n",
              "[1565 rows x 304 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "jbJ7hlql3ErH",
        "colab_type": "code",
        "outputId": "340f47a3-8691-4389-b2f5-55bbdaa8680f",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 590
        }
      },
      "source": [
        "\n",
        "all_data.drop(columns=[\"vector\"], inplace=True)\n",
        "all_data\n"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>index</th>\n",
              "      <th>open</th>\n",
              "      <th>close</th>\n",
              "      <th>0</th>\n",
              "      <th>1</th>\n",
              "      <th>2</th>\n",
              "      <th>3</th>\n",
              "      <th>4</th>\n",
              "      <th>5</th>\n",
              "      <th>6</th>\n",
              "      <th>7</th>\n",
              "      <th>8</th>\n",
              "      <th>9</th>\n",
              "      <th>10</th>\n",
              "      <th>11</th>\n",
              "      <th>12</th>\n",
              "      <th>13</th>\n",
              "      <th>14</th>\n",
              "      <th>15</th>\n",
              "      <th>16</th>\n",
              "      <th>17</th>\n",
              "      <th>18</th>\n",
              "      <th>19</th>\n",
              "      <th>20</th>\n",
              "      <th>21</th>\n",
              "      <th>22</th>\n",
              "      <th>23</th>\n",
              "      <th>24</th>\n",
              "      <th>25</th>\n",
              "      <th>26</th>\n",
              "      <th>27</th>\n",
              "      <th>28</th>\n",
              "      <th>29</th>\n",
              "      <th>30</th>\n",
              "      <th>31</th>\n",
              "      <th>32</th>\n",
              "      <th>33</th>\n",
              "      <th>34</th>\n",
              "      <th>35</th>\n",
              "      <th>36</th>\n",
              "      <th>...</th>\n",
              "      <th>260</th>\n",
              "      <th>261</th>\n",
              "      <th>262</th>\n",
              "      <th>263</th>\n",
              "      <th>264</th>\n",
              "      <th>265</th>\n",
              "      <th>266</th>\n",
              "      <th>267</th>\n",
              "      <th>268</th>\n",
              "      <th>269</th>\n",
              "      <th>270</th>\n",
              "      <th>271</th>\n",
              "      <th>272</th>\n",
              "      <th>273</th>\n",
              "      <th>274</th>\n",
              "      <th>275</th>\n",
              "      <th>276</th>\n",
              "      <th>277</th>\n",
              "      <th>278</th>\n",
              "      <th>279</th>\n",
              "      <th>280</th>\n",
              "      <th>281</th>\n",
              "      <th>282</th>\n",
              "      <th>283</th>\n",
              "      <th>284</th>\n",
              "      <th>285</th>\n",
              "      <th>286</th>\n",
              "      <th>287</th>\n",
              "      <th>288</th>\n",
              "      <th>289</th>\n",
              "      <th>290</th>\n",
              "      <th>291</th>\n",
              "      <th>292</th>\n",
              "      <th>293</th>\n",
              "      <th>294</th>\n",
              "      <th>295</th>\n",
              "      <th>296</th>\n",
              "      <th>297</th>\n",
              "      <th>298</th>\n",
              "      <th>299</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2020-02-10</td>\n",
              "      <td>768.79</td>\n",
              "      <td>771.2800</td>\n",
              "      <td>-0.010530</td>\n",
              "      <td>0.098349</td>\n",
              "      <td>-0.045928</td>\n",
              "      <td>-0.011833</td>\n",
              "      <td>0.000039</td>\n",
              "      <td>-0.035110</td>\n",
              "      <td>0.026545</td>\n",
              "      <td>0.010549</td>\n",
              "      <td>-0.045595</td>\n",
              "      <td>0.464039</td>\n",
              "      <td>-0.007673</td>\n",
              "      <td>0.000267</td>\n",
              "      <td>-0.039774</td>\n",
              "      <td>0.021322</td>\n",
              "      <td>-0.062420</td>\n",
              "      <td>-0.019703</td>\n",
              "      <td>-0.040905</td>\n",
              "      <td>0.390657</td>\n",
              "      <td>-0.040404</td>\n",
              "      <td>0.048236</td>\n",
              "      <td>-0.027159</td>\n",
              "      <td>-0.013454</td>\n",
              "      <td>0.046854</td>\n",
              "      <td>-0.032057</td>\n",
              "      <td>-0.018340</td>\n",
              "      <td>-0.019731</td>\n",
              "      <td>-0.074852</td>\n",
              "      <td>-0.038799</td>\n",
              "      <td>0.088942</td>\n",
              "      <td>0.000842</td>\n",
              "      <td>-0.046198</td>\n",
              "      <td>-0.020416</td>\n",
              "      <td>-0.024594</td>\n",
              "      <td>-0.033290</td>\n",
              "      <td>0.038381</td>\n",
              "      <td>-0.072644</td>\n",
              "      <td>-0.042151</td>\n",
              "      <td>...</td>\n",
              "      <td>-0.039115</td>\n",
              "      <td>-0.052305</td>\n",
              "      <td>0.003053</td>\n",
              "      <td>0.023218</td>\n",
              "      <td>-0.004120</td>\n",
              "      <td>0.002400</td>\n",
              "      <td>0.004611</td>\n",
              "      <td>0.104128</td>\n",
              "      <td>0.078473</td>\n",
              "      <td>-0.016218</td>\n",
              "      <td>0.172741</td>\n",
              "      <td>-0.012899</td>\n",
              "      <td>-0.031154</td>\n",
              "      <td>0.003300</td>\n",
              "      <td>0.046798</td>\n",
              "      <td>0.024688</td>\n",
              "      <td>0.024468</td>\n",
              "      <td>0.001825</td>\n",
              "      <td>0.015203</td>\n",
              "      <td>0.037794</td>\n",
              "      <td>-0.033292</td>\n",
              "      <td>-0.007909</td>\n",
              "      <td>0.005622</td>\n",
              "      <td>0.000046</td>\n",
              "      <td>-0.071204</td>\n",
              "      <td>-0.018797</td>\n",
              "      <td>-0.028606</td>\n",
              "      <td>-0.059602</td>\n",
              "      <td>0.037949</td>\n",
              "      <td>-0.052446</td>\n",
              "      <td>-0.045793</td>\n",
              "      <td>-0.072902</td>\n",
              "      <td>0.039745</td>\n",
              "      <td>-0.095667</td>\n",
              "      <td>-0.010243</td>\n",
              "      <td>-0.072656</td>\n",
              "      <td>0.037246</td>\n",
              "      <td>0.000729</td>\n",
              "      <td>-0.009160</td>\n",
              "      <td>0.031896</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2020-01-03</td>\n",
              "      <td>440.47</td>\n",
              "      <td>443.0100</td>\n",
              "      <td>-0.419582</td>\n",
              "      <td>4.046570</td>\n",
              "      <td>-0.821298</td>\n",
              "      <td>-0.124958</td>\n",
              "      <td>0.078892</td>\n",
              "      <td>-1.239797</td>\n",
              "      <td>0.506607</td>\n",
              "      <td>-1.720687</td>\n",
              "      <td>-0.335473</td>\n",
              "      <td>24.625812</td>\n",
              "      <td>-1.674629</td>\n",
              "      <td>0.609996</td>\n",
              "      <td>0.319260</td>\n",
              "      <td>-0.856638</td>\n",
              "      <td>-2.015128</td>\n",
              "      <td>-0.996078</td>\n",
              "      <td>-1.299597</td>\n",
              "      <td>19.581936</td>\n",
              "      <td>-1.796622</td>\n",
              "      <td>-1.010514</td>\n",
              "      <td>0.830938</td>\n",
              "      <td>0.184110</td>\n",
              "      <td>0.203215</td>\n",
              "      <td>-1.106292</td>\n",
              "      <td>0.235508</td>\n",
              "      <td>0.729707</td>\n",
              "      <td>-1.084618</td>\n",
              "      <td>-0.286390</td>\n",
              "      <td>1.518729</td>\n",
              "      <td>0.792822</td>\n",
              "      <td>-0.218741</td>\n",
              "      <td>-0.500823</td>\n",
              "      <td>-0.114990</td>\n",
              "      <td>1.218946</td>\n",
              "      <td>1.497805</td>\n",
              "      <td>-1.100177</td>\n",
              "      <td>0.519993</td>\n",
              "      <td>...</td>\n",
              "      <td>2.377019</td>\n",
              "      <td>2.087115</td>\n",
              "      <td>0.281279</td>\n",
              "      <td>0.929935</td>\n",
              "      <td>0.320272</td>\n",
              "      <td>-2.383286</td>\n",
              "      <td>-0.261530</td>\n",
              "      <td>1.090553</td>\n",
              "      <td>4.185575</td>\n",
              "      <td>0.447643</td>\n",
              "      <td>1.443201</td>\n",
              "      <td>-0.361346</td>\n",
              "      <td>-0.032489</td>\n",
              "      <td>-1.228383</td>\n",
              "      <td>-0.458936</td>\n",
              "      <td>0.207309</td>\n",
              "      <td>-0.039224</td>\n",
              "      <td>0.669236</td>\n",
              "      <td>1.092565</td>\n",
              "      <td>1.517070</td>\n",
              "      <td>0.633888</td>\n",
              "      <td>1.275198</td>\n",
              "      <td>0.066641</td>\n",
              "      <td>0.758871</td>\n",
              "      <td>0.046087</td>\n",
              "      <td>-0.509770</td>\n",
              "      <td>1.070561</td>\n",
              "      <td>-1.299019</td>\n",
              "      <td>0.045601</td>\n",
              "      <td>-0.348186</td>\n",
              "      <td>-3.327241</td>\n",
              "      <td>0.828651</td>\n",
              "      <td>2.196073</td>\n",
              "      <td>-0.262937</td>\n",
              "      <td>0.344921</td>\n",
              "      <td>-1.721509</td>\n",
              "      <td>-0.774386</td>\n",
              "      <td>-0.443695</td>\n",
              "      <td>-0.107372</td>\n",
              "      <td>2.147399</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2020-01-02</td>\n",
              "      <td>440.50</td>\n",
              "      <td>430.2600</td>\n",
              "      <td>0.260637</td>\n",
              "      <td>0.672760</td>\n",
              "      <td>-0.074915</td>\n",
              "      <td>0.133570</td>\n",
              "      <td>0.179052</td>\n",
              "      <td>-0.046128</td>\n",
              "      <td>0.036259</td>\n",
              "      <td>-0.274081</td>\n",
              "      <td>-0.232924</td>\n",
              "      <td>2.881890</td>\n",
              "      <td>-0.199384</td>\n",
              "      <td>0.061396</td>\n",
              "      <td>-0.251091</td>\n",
              "      <td>-0.168093</td>\n",
              "      <td>-0.231142</td>\n",
              "      <td>-0.104217</td>\n",
              "      <td>-0.324346</td>\n",
              "      <td>2.919163</td>\n",
              "      <td>-0.482350</td>\n",
              "      <td>-0.077116</td>\n",
              "      <td>0.087737</td>\n",
              "      <td>-0.326059</td>\n",
              "      <td>0.146974</td>\n",
              "      <td>-0.294548</td>\n",
              "      <td>-0.289237</td>\n",
              "      <td>0.223385</td>\n",
              "      <td>-0.096183</td>\n",
              "      <td>0.075815</td>\n",
              "      <td>0.267266</td>\n",
              "      <td>0.357177</td>\n",
              "      <td>-0.089957</td>\n",
              "      <td>0.063248</td>\n",
              "      <td>0.208909</td>\n",
              "      <td>0.252365</td>\n",
              "      <td>0.148010</td>\n",
              "      <td>-0.128405</td>\n",
              "      <td>0.014056</td>\n",
              "      <td>...</td>\n",
              "      <td>0.202719</td>\n",
              "      <td>0.245576</td>\n",
              "      <td>0.187146</td>\n",
              "      <td>-0.111262</td>\n",
              "      <td>0.266358</td>\n",
              "      <td>-0.195035</td>\n",
              "      <td>0.010573</td>\n",
              "      <td>0.511056</td>\n",
              "      <td>0.307005</td>\n",
              "      <td>0.239992</td>\n",
              "      <td>-0.111199</td>\n",
              "      <td>0.092526</td>\n",
              "      <td>0.052587</td>\n",
              "      <td>-0.085673</td>\n",
              "      <td>-0.027430</td>\n",
              "      <td>0.111592</td>\n",
              "      <td>0.163198</td>\n",
              "      <td>-0.031398</td>\n",
              "      <td>-0.134688</td>\n",
              "      <td>0.023019</td>\n",
              "      <td>0.016885</td>\n",
              "      <td>0.156086</td>\n",
              "      <td>0.313640</td>\n",
              "      <td>-0.080347</td>\n",
              "      <td>0.020779</td>\n",
              "      <td>-0.108167</td>\n",
              "      <td>0.017540</td>\n",
              "      <td>-0.122178</td>\n",
              "      <td>-0.073524</td>\n",
              "      <td>-0.087641</td>\n",
              "      <td>-0.278707</td>\n",
              "      <td>-0.139921</td>\n",
              "      <td>0.088437</td>\n",
              "      <td>-0.165880</td>\n",
              "      <td>0.179655</td>\n",
              "      <td>0.095238</td>\n",
              "      <td>-0.036637</td>\n",
              "      <td>0.285722</td>\n",
              "      <td>-0.086894</td>\n",
              "      <td>0.149904</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2019-11-19</td>\n",
              "      <td>360.00</td>\n",
              "      <td>359.5200</td>\n",
              "      <td>-0.038655</td>\n",
              "      <td>0.488213</td>\n",
              "      <td>-0.191833</td>\n",
              "      <td>-0.085065</td>\n",
              "      <td>0.095400</td>\n",
              "      <td>-0.165370</td>\n",
              "      <td>0.060908</td>\n",
              "      <td>-0.336775</td>\n",
              "      <td>0.074119</td>\n",
              "      <td>3.231776</td>\n",
              "      <td>-0.371671</td>\n",
              "      <td>0.041697</td>\n",
              "      <td>0.058887</td>\n",
              "      <td>-0.196129</td>\n",
              "      <td>-0.241486</td>\n",
              "      <td>-0.031997</td>\n",
              "      <td>-0.246629</td>\n",
              "      <td>2.124208</td>\n",
              "      <td>-0.210703</td>\n",
              "      <td>-0.076747</td>\n",
              "      <td>0.226441</td>\n",
              "      <td>-0.064183</td>\n",
              "      <td>0.006958</td>\n",
              "      <td>-0.108566</td>\n",
              "      <td>0.016339</td>\n",
              "      <td>0.144655</td>\n",
              "      <td>-0.195437</td>\n",
              "      <td>-0.040126</td>\n",
              "      <td>0.103941</td>\n",
              "      <td>0.264947</td>\n",
              "      <td>0.063838</td>\n",
              "      <td>-0.051996</td>\n",
              "      <td>-0.050581</td>\n",
              "      <td>0.338113</td>\n",
              "      <td>0.238084</td>\n",
              "      <td>-0.153214</td>\n",
              "      <td>0.048793</td>\n",
              "      <td>...</td>\n",
              "      <td>0.302983</td>\n",
              "      <td>0.188003</td>\n",
              "      <td>0.038411</td>\n",
              "      <td>0.092598</td>\n",
              "      <td>0.078161</td>\n",
              "      <td>-0.287610</td>\n",
              "      <td>-0.057278</td>\n",
              "      <td>0.131842</td>\n",
              "      <td>0.318623</td>\n",
              "      <td>0.033791</td>\n",
              "      <td>0.171544</td>\n",
              "      <td>-0.074002</td>\n",
              "      <td>-0.041412</td>\n",
              "      <td>-0.101353</td>\n",
              "      <td>-0.011238</td>\n",
              "      <td>-0.054416</td>\n",
              "      <td>-0.096314</td>\n",
              "      <td>0.000646</td>\n",
              "      <td>0.116481</td>\n",
              "      <td>0.095254</td>\n",
              "      <td>0.169899</td>\n",
              "      <td>0.047401</td>\n",
              "      <td>0.016519</td>\n",
              "      <td>0.141191</td>\n",
              "      <td>-0.052866</td>\n",
              "      <td>-0.016772</td>\n",
              "      <td>0.094082</td>\n",
              "      <td>-0.090283</td>\n",
              "      <td>0.149669</td>\n",
              "      <td>-0.144825</td>\n",
              "      <td>-0.417886</td>\n",
              "      <td>0.014717</td>\n",
              "      <td>0.286323</td>\n",
              "      <td>-0.117986</td>\n",
              "      <td>-0.033695</td>\n",
              "      <td>-0.175512</td>\n",
              "      <td>-0.118734</td>\n",
              "      <td>-0.125407</td>\n",
              "      <td>-0.009186</td>\n",
              "      <td>0.220200</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2019-11-07</td>\n",
              "      <td>334.50</td>\n",
              "      <td>335.5400</td>\n",
              "      <td>0.010165</td>\n",
              "      <td>0.696816</td>\n",
              "      <td>-0.041311</td>\n",
              "      <td>-0.263856</td>\n",
              "      <td>0.368052</td>\n",
              "      <td>-0.148849</td>\n",
              "      <td>-0.007752</td>\n",
              "      <td>-0.432938</td>\n",
              "      <td>0.058721</td>\n",
              "      <td>5.665106</td>\n",
              "      <td>-0.688363</td>\n",
              "      <td>0.048936</td>\n",
              "      <td>0.163013</td>\n",
              "      <td>-0.252358</td>\n",
              "      <td>-0.477406</td>\n",
              "      <td>0.038895</td>\n",
              "      <td>-0.429953</td>\n",
              "      <td>4.602379</td>\n",
              "      <td>-0.506534</td>\n",
              "      <td>-0.255824</td>\n",
              "      <td>0.327551</td>\n",
              "      <td>-0.121507</td>\n",
              "      <td>0.146235</td>\n",
              "      <td>-0.169132</td>\n",
              "      <td>0.116315</td>\n",
              "      <td>0.262696</td>\n",
              "      <td>-0.119440</td>\n",
              "      <td>0.034605</td>\n",
              "      <td>0.317691</td>\n",
              "      <td>0.350574</td>\n",
              "      <td>-0.155853</td>\n",
              "      <td>0.175069</td>\n",
              "      <td>0.063007</td>\n",
              "      <td>0.368334</td>\n",
              "      <td>0.182164</td>\n",
              "      <td>-0.359126</td>\n",
              "      <td>0.166982</td>\n",
              "      <td>...</td>\n",
              "      <td>0.416243</td>\n",
              "      <td>0.572453</td>\n",
              "      <td>0.031796</td>\n",
              "      <td>0.009834</td>\n",
              "      <td>0.170258</td>\n",
              "      <td>-0.637243</td>\n",
              "      <td>0.006125</td>\n",
              "      <td>0.202336</td>\n",
              "      <td>0.633837</td>\n",
              "      <td>-0.011023</td>\n",
              "      <td>0.127955</td>\n",
              "      <td>-0.067466</td>\n",
              "      <td>-0.317820</td>\n",
              "      <td>-0.672999</td>\n",
              "      <td>-0.188789</td>\n",
              "      <td>0.034988</td>\n",
              "      <td>0.127537</td>\n",
              "      <td>0.056095</td>\n",
              "      <td>0.213908</td>\n",
              "      <td>0.317358</td>\n",
              "      <td>0.457804</td>\n",
              "      <td>0.246731</td>\n",
              "      <td>-0.154674</td>\n",
              "      <td>0.024880</td>\n",
              "      <td>-0.007467</td>\n",
              "      <td>-0.341912</td>\n",
              "      <td>0.080073</td>\n",
              "      <td>-0.156554</td>\n",
              "      <td>0.064298</td>\n",
              "      <td>-0.091419</td>\n",
              "      <td>-0.734608</td>\n",
              "      <td>0.009351</td>\n",
              "      <td>0.568975</td>\n",
              "      <td>-0.185727</td>\n",
              "      <td>0.111318</td>\n",
              "      <td>-0.384590</td>\n",
              "      <td>-0.230492</td>\n",
              "      <td>0.189818</td>\n",
              "      <td>-0.041457</td>\n",
              "      <td>0.219561</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1560</th>\n",
              "      <td>2012-12-21</td>\n",
              "      <td>33.64</td>\n",
              "      <td>34.0000</td>\n",
              "      <td>0.001154</td>\n",
              "      <td>0.080550</td>\n",
              "      <td>-0.046503</td>\n",
              "      <td>-0.032234</td>\n",
              "      <td>0.017378</td>\n",
              "      <td>-0.007543</td>\n",
              "      <td>0.018119</td>\n",
              "      <td>-0.046309</td>\n",
              "      <td>-0.004964</td>\n",
              "      <td>0.666836</td>\n",
              "      <td>-0.036337</td>\n",
              "      <td>0.014083</td>\n",
              "      <td>0.028625</td>\n",
              "      <td>-0.015268</td>\n",
              "      <td>-0.056148</td>\n",
              "      <td>-0.015998</td>\n",
              "      <td>-0.033109</td>\n",
              "      <td>0.339428</td>\n",
              "      <td>-0.045860</td>\n",
              "      <td>0.002016</td>\n",
              "      <td>0.002940</td>\n",
              "      <td>-0.020550</td>\n",
              "      <td>-0.001827</td>\n",
              "      <td>-0.007933</td>\n",
              "      <td>0.000495</td>\n",
              "      <td>0.015960</td>\n",
              "      <td>-0.036518</td>\n",
              "      <td>-0.041102</td>\n",
              "      <td>0.012735</td>\n",
              "      <td>-0.032119</td>\n",
              "      <td>-0.034420</td>\n",
              "      <td>0.035072</td>\n",
              "      <td>0.024528</td>\n",
              "      <td>0.006986</td>\n",
              "      <td>0.003308</td>\n",
              "      <td>-0.027061</td>\n",
              "      <td>0.013200</td>\n",
              "      <td>...</td>\n",
              "      <td>0.051358</td>\n",
              "      <td>0.051385</td>\n",
              "      <td>0.013639</td>\n",
              "      <td>0.021820</td>\n",
              "      <td>0.028262</td>\n",
              "      <td>-0.009175</td>\n",
              "      <td>-0.008685</td>\n",
              "      <td>0.010959</td>\n",
              "      <td>0.102867</td>\n",
              "      <td>0.009125</td>\n",
              "      <td>0.058644</td>\n",
              "      <td>-0.024684</td>\n",
              "      <td>-0.062933</td>\n",
              "      <td>-0.043068</td>\n",
              "      <td>-0.017311</td>\n",
              "      <td>0.011048</td>\n",
              "      <td>0.001286</td>\n",
              "      <td>0.012282</td>\n",
              "      <td>0.011610</td>\n",
              "      <td>0.077472</td>\n",
              "      <td>0.076096</td>\n",
              "      <td>0.017258</td>\n",
              "      <td>0.009345</td>\n",
              "      <td>-0.028928</td>\n",
              "      <td>-0.020235</td>\n",
              "      <td>-0.023512</td>\n",
              "      <td>0.024613</td>\n",
              "      <td>-0.009947</td>\n",
              "      <td>0.021768</td>\n",
              "      <td>-0.023020</td>\n",
              "      <td>-0.048886</td>\n",
              "      <td>0.007171</td>\n",
              "      <td>0.016834</td>\n",
              "      <td>-0.006503</td>\n",
              "      <td>0.041791</td>\n",
              "      <td>-0.037994</td>\n",
              "      <td>-0.015102</td>\n",
              "      <td>-0.005336</td>\n",
              "      <td>0.011091</td>\n",
              "      <td>0.031600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1561</th>\n",
              "      <td>2012-11-12</td>\n",
              "      <td>31.29</td>\n",
              "      <td>31.0700</td>\n",
              "      <td>0.046471</td>\n",
              "      <td>0.087549</td>\n",
              "      <td>0.020803</td>\n",
              "      <td>-0.010359</td>\n",
              "      <td>-0.018569</td>\n",
              "      <td>-0.070328</td>\n",
              "      <td>0.038205</td>\n",
              "      <td>-0.035953</td>\n",
              "      <td>-0.000309</td>\n",
              "      <td>0.445255</td>\n",
              "      <td>-0.070960</td>\n",
              "      <td>-0.021908</td>\n",
              "      <td>0.008805</td>\n",
              "      <td>-0.007845</td>\n",
              "      <td>-0.055111</td>\n",
              "      <td>-0.015822</td>\n",
              "      <td>-0.085804</td>\n",
              "      <td>0.413454</td>\n",
              "      <td>-0.008883</td>\n",
              "      <td>-0.000776</td>\n",
              "      <td>0.052113</td>\n",
              "      <td>-0.028783</td>\n",
              "      <td>0.020277</td>\n",
              "      <td>-0.024565</td>\n",
              "      <td>-0.005597</td>\n",
              "      <td>0.087315</td>\n",
              "      <td>-0.015133</td>\n",
              "      <td>0.014124</td>\n",
              "      <td>0.028550</td>\n",
              "      <td>0.105915</td>\n",
              "      <td>-0.000378</td>\n",
              "      <td>-0.049893</td>\n",
              "      <td>0.004769</td>\n",
              "      <td>0.060624</td>\n",
              "      <td>0.087780</td>\n",
              "      <td>-0.023161</td>\n",
              "      <td>0.005733</td>\n",
              "      <td>...</td>\n",
              "      <td>0.045448</td>\n",
              "      <td>0.054760</td>\n",
              "      <td>-0.022358</td>\n",
              "      <td>0.032279</td>\n",
              "      <td>0.006725</td>\n",
              "      <td>-0.063645</td>\n",
              "      <td>0.000693</td>\n",
              "      <td>0.046354</td>\n",
              "      <td>0.044601</td>\n",
              "      <td>-0.012617</td>\n",
              "      <td>0.016111</td>\n",
              "      <td>-0.007893</td>\n",
              "      <td>0.000671</td>\n",
              "      <td>-0.070442</td>\n",
              "      <td>0.010652</td>\n",
              "      <td>0.012318</td>\n",
              "      <td>0.024646</td>\n",
              "      <td>0.027765</td>\n",
              "      <td>0.025412</td>\n",
              "      <td>0.034197</td>\n",
              "      <td>-0.032823</td>\n",
              "      <td>0.027153</td>\n",
              "      <td>-0.002967</td>\n",
              "      <td>0.054978</td>\n",
              "      <td>0.043927</td>\n",
              "      <td>0.023311</td>\n",
              "      <td>0.016446</td>\n",
              "      <td>-0.055317</td>\n",
              "      <td>-0.024318</td>\n",
              "      <td>0.018599</td>\n",
              "      <td>-0.067712</td>\n",
              "      <td>0.007267</td>\n",
              "      <td>0.064695</td>\n",
              "      <td>-0.037769</td>\n",
              "      <td>0.018582</td>\n",
              "      <td>-0.048050</td>\n",
              "      <td>-0.033916</td>\n",
              "      <td>0.006268</td>\n",
              "      <td>-0.012020</td>\n",
              "      <td>0.027254</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1562</th>\n",
              "      <td>2012-11-01</td>\n",
              "      <td>29.27</td>\n",
              "      <td>29.2454</td>\n",
              "      <td>0.053316</td>\n",
              "      <td>0.208467</td>\n",
              "      <td>0.028113</td>\n",
              "      <td>0.012835</td>\n",
              "      <td>-0.035201</td>\n",
              "      <td>-0.110717</td>\n",
              "      <td>0.067742</td>\n",
              "      <td>-0.050683</td>\n",
              "      <td>-0.037390</td>\n",
              "      <td>0.908033</td>\n",
              "      <td>-0.209244</td>\n",
              "      <td>-0.018876</td>\n",
              "      <td>-0.001891</td>\n",
              "      <td>-0.057978</td>\n",
              "      <td>-0.127619</td>\n",
              "      <td>-0.005628</td>\n",
              "      <td>-0.168104</td>\n",
              "      <td>0.760077</td>\n",
              "      <td>-0.019652</td>\n",
              "      <td>0.005223</td>\n",
              "      <td>0.103235</td>\n",
              "      <td>-0.020599</td>\n",
              "      <td>0.058732</td>\n",
              "      <td>-0.043471</td>\n",
              "      <td>0.020683</td>\n",
              "      <td>0.139655</td>\n",
              "      <td>-0.013933</td>\n",
              "      <td>0.045786</td>\n",
              "      <td>0.055577</td>\n",
              "      <td>0.175737</td>\n",
              "      <td>0.035172</td>\n",
              "      <td>-0.057107</td>\n",
              "      <td>0.004968</td>\n",
              "      <td>0.178322</td>\n",
              "      <td>0.119352</td>\n",
              "      <td>-0.044231</td>\n",
              "      <td>-0.017550</td>\n",
              "      <td>...</td>\n",
              "      <td>0.102717</td>\n",
              "      <td>0.086294</td>\n",
              "      <td>-0.086840</td>\n",
              "      <td>0.073258</td>\n",
              "      <td>0.007694</td>\n",
              "      <td>-0.148075</td>\n",
              "      <td>-0.003626</td>\n",
              "      <td>0.040763</td>\n",
              "      <td>0.066440</td>\n",
              "      <td>0.003711</td>\n",
              "      <td>-0.019803</td>\n",
              "      <td>-0.015371</td>\n",
              "      <td>0.027712</td>\n",
              "      <td>-0.070566</td>\n",
              "      <td>0.006015</td>\n",
              "      <td>0.067794</td>\n",
              "      <td>0.027789</td>\n",
              "      <td>0.027432</td>\n",
              "      <td>0.022062</td>\n",
              "      <td>0.036204</td>\n",
              "      <td>-0.076316</td>\n",
              "      <td>0.006707</td>\n",
              "      <td>0.015551</td>\n",
              "      <td>0.085208</td>\n",
              "      <td>0.113152</td>\n",
              "      <td>-0.007980</td>\n",
              "      <td>0.032298</td>\n",
              "      <td>-0.082107</td>\n",
              "      <td>-0.052607</td>\n",
              "      <td>0.040649</td>\n",
              "      <td>-0.156620</td>\n",
              "      <td>-0.009864</td>\n",
              "      <td>0.083159</td>\n",
              "      <td>-0.082261</td>\n",
              "      <td>0.051352</td>\n",
              "      <td>-0.124707</td>\n",
              "      <td>-0.023358</td>\n",
              "      <td>-0.080174</td>\n",
              "      <td>0.022553</td>\n",
              "      <td>0.054556</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1563</th>\n",
              "      <td>2012-09-14</td>\n",
              "      <td>32.35</td>\n",
              "      <td>30.3900</td>\n",
              "      <td>-0.050111</td>\n",
              "      <td>0.097961</td>\n",
              "      <td>0.040084</td>\n",
              "      <td>-0.001147</td>\n",
              "      <td>-0.041411</td>\n",
              "      <td>-0.043300</td>\n",
              "      <td>0.001605</td>\n",
              "      <td>-0.055593</td>\n",
              "      <td>-0.009566</td>\n",
              "      <td>0.532355</td>\n",
              "      <td>-0.101697</td>\n",
              "      <td>0.034329</td>\n",
              "      <td>0.016074</td>\n",
              "      <td>0.038805</td>\n",
              "      <td>-0.045839</td>\n",
              "      <td>0.002286</td>\n",
              "      <td>-0.011421</td>\n",
              "      <td>0.359941</td>\n",
              "      <td>-0.031954</td>\n",
              "      <td>-0.029731</td>\n",
              "      <td>0.036293</td>\n",
              "      <td>-0.064188</td>\n",
              "      <td>0.043951</td>\n",
              "      <td>0.019455</td>\n",
              "      <td>-0.053461</td>\n",
              "      <td>0.018777</td>\n",
              "      <td>0.000928</td>\n",
              "      <td>-0.008965</td>\n",
              "      <td>-0.024806</td>\n",
              "      <td>0.003424</td>\n",
              "      <td>0.027979</td>\n",
              "      <td>0.096629</td>\n",
              "      <td>-0.007553</td>\n",
              "      <td>-0.035057</td>\n",
              "      <td>0.017769</td>\n",
              "      <td>0.039170</td>\n",
              "      <td>0.010638</td>\n",
              "      <td>...</td>\n",
              "      <td>0.044093</td>\n",
              "      <td>-0.016140</td>\n",
              "      <td>-0.062140</td>\n",
              "      <td>-0.021707</td>\n",
              "      <td>-0.038545</td>\n",
              "      <td>-0.014044</td>\n",
              "      <td>0.053007</td>\n",
              "      <td>0.026318</td>\n",
              "      <td>0.159803</td>\n",
              "      <td>0.049669</td>\n",
              "      <td>-0.066042</td>\n",
              "      <td>0.020231</td>\n",
              "      <td>-0.112440</td>\n",
              "      <td>-0.016680</td>\n",
              "      <td>-0.056696</td>\n",
              "      <td>-0.008878</td>\n",
              "      <td>0.016795</td>\n",
              "      <td>0.038932</td>\n",
              "      <td>0.022628</td>\n",
              "      <td>0.059328</td>\n",
              "      <td>0.057841</td>\n",
              "      <td>-0.024400</td>\n",
              "      <td>-0.015501</td>\n",
              "      <td>-0.046345</td>\n",
              "      <td>0.005504</td>\n",
              "      <td>-0.000803</td>\n",
              "      <td>0.105034</td>\n",
              "      <td>0.012430</td>\n",
              "      <td>0.033719</td>\n",
              "      <td>-0.012482</td>\n",
              "      <td>-0.060444</td>\n",
              "      <td>-0.008065</td>\n",
              "      <td>0.008618</td>\n",
              "      <td>-0.028784</td>\n",
              "      <td>0.083775</td>\n",
              "      <td>-0.074961</td>\n",
              "      <td>-0.025425</td>\n",
              "      <td>-0.020453</td>\n",
              "      <td>-0.030247</td>\n",
              "      <td>0.080751</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1564</th>\n",
              "      <td>2012-02-09</td>\n",
              "      <td>32.26</td>\n",
              "      <td>32.5800</td>\n",
              "      <td>0.032809</td>\n",
              "      <td>0.158077</td>\n",
              "      <td>0.020348</td>\n",
              "      <td>0.038550</td>\n",
              "      <td>-0.074135</td>\n",
              "      <td>-0.021159</td>\n",
              "      <td>0.070355</td>\n",
              "      <td>-0.051542</td>\n",
              "      <td>0.008305</td>\n",
              "      <td>0.120342</td>\n",
              "      <td>0.053337</td>\n",
              "      <td>-0.024198</td>\n",
              "      <td>-0.027383</td>\n",
              "      <td>-0.051990</td>\n",
              "      <td>-0.051306</td>\n",
              "      <td>0.021595</td>\n",
              "      <td>-0.079944</td>\n",
              "      <td>0.358448</td>\n",
              "      <td>-0.028045</td>\n",
              "      <td>-0.029133</td>\n",
              "      <td>0.024311</td>\n",
              "      <td>-0.009844</td>\n",
              "      <td>0.028636</td>\n",
              "      <td>-0.029174</td>\n",
              "      <td>0.011329</td>\n",
              "      <td>0.035447</td>\n",
              "      <td>-0.012565</td>\n",
              "      <td>0.011281</td>\n",
              "      <td>0.079013</td>\n",
              "      <td>0.090174</td>\n",
              "      <td>-0.059787</td>\n",
              "      <td>-0.003390</td>\n",
              "      <td>0.014204</td>\n",
              "      <td>0.079898</td>\n",
              "      <td>0.006395</td>\n",
              "      <td>0.002633</td>\n",
              "      <td>-0.010083</td>\n",
              "      <td>...</td>\n",
              "      <td>0.056204</td>\n",
              "      <td>0.045981</td>\n",
              "      <td>0.060122</td>\n",
              "      <td>-0.002836</td>\n",
              "      <td>-0.040280</td>\n",
              "      <td>-0.045609</td>\n",
              "      <td>-0.029865</td>\n",
              "      <td>0.045695</td>\n",
              "      <td>-0.011047</td>\n",
              "      <td>0.065111</td>\n",
              "      <td>-0.015595</td>\n",
              "      <td>-0.019489</td>\n",
              "      <td>-0.016505</td>\n",
              "      <td>0.013985</td>\n",
              "      <td>-0.019345</td>\n",
              "      <td>0.019192</td>\n",
              "      <td>0.010341</td>\n",
              "      <td>-0.023182</td>\n",
              "      <td>-0.062093</td>\n",
              "      <td>0.054111</td>\n",
              "      <td>0.031180</td>\n",
              "      <td>-0.020002</td>\n",
              "      <td>-0.013532</td>\n",
              "      <td>0.051220</td>\n",
              "      <td>0.069186</td>\n",
              "      <td>0.046565</td>\n",
              "      <td>0.018766</td>\n",
              "      <td>-0.011041</td>\n",
              "      <td>-0.033631</td>\n",
              "      <td>0.102022</td>\n",
              "      <td>-0.007516</td>\n",
              "      <td>0.026908</td>\n",
              "      <td>0.072936</td>\n",
              "      <td>0.003576</td>\n",
              "      <td>-0.035146</td>\n",
              "      <td>-0.031145</td>\n",
              "      <td>0.010972</td>\n",
              "      <td>-0.000367</td>\n",
              "      <td>-0.007931</td>\n",
              "      <td>0.052451</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1565 rows × 303 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "           index    open     close  ...       297       298       299\n",
              "0     2020-02-10  768.79  771.2800  ...  0.000729 -0.009160  0.031896\n",
              "1     2020-01-03  440.47  443.0100  ... -0.443695 -0.107372  2.147399\n",
              "2     2020-01-02  440.50  430.2600  ...  0.285722 -0.086894  0.149904\n",
              "3     2019-11-19  360.00  359.5200  ... -0.125407 -0.009186  0.220200\n",
              "4     2019-11-07  334.50  335.5400  ...  0.189818 -0.041457  0.219561\n",
              "...          ...     ...       ...  ...       ...       ...       ...\n",
              "1560  2012-12-21   33.64   34.0000  ... -0.005336  0.011091  0.031600\n",
              "1561  2012-11-12   31.29   31.0700  ...  0.006268 -0.012020  0.027254\n",
              "1562  2012-11-01   29.27   29.2454  ... -0.080174  0.022553  0.054556\n",
              "1563  2012-09-14   32.35   30.3900  ... -0.020453 -0.030247  0.080751\n",
              "1564  2012-02-09   32.26   32.5800  ... -0.000367 -0.007931  0.052451\n",
              "\n",
              "[1565 rows x 303 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "U-M2JQaPAbtB",
        "colab_type": "code",
        "outputId": "2dc5e1be-ea7f-4dc6-ffdb-7a0424efd731",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 118
        }
      },
      "source": [
        " columns = all_data.columns\n",
        " print(columns)\n",
        " X = all_data[columns[2:]]\n",
        " Y = all_data[columns[1]]\n",
        "print(X.shape)\n",
        "print(Y.shape)\n",
        "\n"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Index(['index', 'open', 'close', '0', '1', '2', '3', '4', '5', '6',\n",
            "       ...\n",
            "       '290', '291', '292', '293', '294', '295', '296', '297', '298', '299'],\n",
            "      dtype='object', length=303)\n",
            "(1565, 301)\n",
            "(1565,)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fy2GQoDXBdqt",
        "colab_type": "code",
        "outputId": "508b1a36-60bc-4a62-f941-4be9c7bbb23c",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 84
        }
      },
      "source": [
        "X_train, X_test, Y_train, Y_test = train_test_split(X, Y, test_size = 0.2)\n",
        "xg_reg = xgb.XGBRegressor(random_state=1, objective ='reg:linear', colsample_bytree = 0.3, learning_rate = 0.5,\n",
        "                max_depth = 3, alpha = 10, n_estimators = 10)\n",
        "xg_reg.fit(X_train, Y_train)\n",
        "\n",
        "preds = xg_reg.predict(X_test)\n",
        "mean_error = mean_absolute_error(Y_test, preds)\n",
        "print(str(mean_error))"
      ],
      "execution_count": 0,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "[15:13:05] WARNING: /workspace/src/objective/regression_obj.cu:152: reg:linear is now deprecated in favor of reg:squarederror.\n",
            "25.44152668967933\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.6/dist-packages/xgboost/core.py:587: FutureWarning: Series.base is deprecated and will be removed in a future version\n",
            "  if getattr(data, 'base', None) is not None and \\\n"
          ],
          "name": "stderr"
        }
      ]
    }
  ]
}