playing_with_data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"timestamps_features.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "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>date</th>\n",
       "      <th>symbol</th>\n",
       "      <th>angle_between</th>\n",
       "      <th>distance</th>\n",
       "      <th>num_of_ups_downs</th>\n",
       "      <th>('angle_between_1_before',)</th>\n",
       "      <th>('distance_1_before',)</th>\n",
       "      <th>('num_of_ups_downs_1_before',)</th>\n",
       "      <th>('angle_between_2_before',)</th>\n",
       "      <th>('distance_2_before',)</th>\n",
       "      <th>('num_of_ups_downs_2_before',)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1986-11-28</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002200</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1986-12-31</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>-0.043745</td>\n",
       "      <td>0.002964</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002200</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1987-01-30</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>-0.172999</td>\n",
       "      <td>0.005983</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.043745</td>\n",
       "      <td>0.002964</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002200</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1987-02-27</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>-0.116116</td>\n",
       "      <td>0.008010</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-0.172999</td>\n",
       "      <td>0.005983</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.043745</td>\n",
       "      <td>0.002964</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1987-03-31</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>-0.177287</td>\n",
       "      <td>0.011104</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-0.116116</td>\n",
       "      <td>0.008010</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-0.172999</td>\n",
       "      <td>0.005983</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1987-04-30</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>-0.121928</td>\n",
       "      <td>0.013232</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-0.177287</td>\n",
       "      <td>0.011104</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-0.116116</td>\n",
       "      <td>0.008010</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1987-05-29</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>-0.103451</td>\n",
       "      <td>0.015038</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-0.121928</td>\n",
       "      <td>0.013232</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-0.177287</td>\n",
       "      <td>0.011104</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1987-06-30</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>0.091884</td>\n",
       "      <td>0.013434</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.103451</td>\n",
       "      <td>0.015038</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-0.121928</td>\n",
       "      <td>0.013232</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1987-07-31</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>0.183389</td>\n",
       "      <td>0.010233</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.091884</td>\n",
       "      <td>0.013434</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.103451</td>\n",
       "      <td>0.015038</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1987-08-31</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.183389</td>\n",
       "      <td>0.010233</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.091884</td>\n",
       "      <td>0.013434</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1987-09-30</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.183389</td>\n",
       "      <td>0.010233</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1987-10-30</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1987-11-30</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1987-12-01</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>0.243127</td>\n",
       "      <td>0.003313</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1986-11-28</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002200</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1986-12-31</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>-0.043745</td>\n",
       "      <td>0.002964</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002200</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1987-01-30</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>-0.172999</td>\n",
       "      <td>0.005983</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.043745</td>\n",
       "      <td>0.002964</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002200</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1987-02-27</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>-0.116116</td>\n",
       "      <td>0.008010</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-0.172999</td>\n",
       "      <td>0.005983</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.043745</td>\n",
       "      <td>0.002964</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1987-03-31</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>-0.177287</td>\n",
       "      <td>0.011104</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-0.116116</td>\n",
       "      <td>0.008010</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-0.172999</td>\n",
       "      <td>0.005983</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1987-04-30</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>-0.121928</td>\n",
       "      <td>0.013232</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-0.177287</td>\n",
       "      <td>0.011104</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-0.116116</td>\n",
       "      <td>0.008010</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1987-05-29</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>-0.103451</td>\n",
       "      <td>0.015038</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-0.121928</td>\n",
       "      <td>0.013232</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-0.177287</td>\n",
       "      <td>0.011104</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1987-06-30</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>0.091884</td>\n",
       "      <td>0.013434</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.103451</td>\n",
       "      <td>0.015038</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-0.121928</td>\n",
       "      <td>0.013232</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1987-07-31</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>0.183389</td>\n",
       "      <td>0.010233</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.091884</td>\n",
       "      <td>0.013434</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.103451</td>\n",
       "      <td>0.015038</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1987-08-31</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.183389</td>\n",
       "      <td>0.010233</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.091884</td>\n",
       "      <td>0.013434</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1987-09-30</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.183389</td>\n",
       "      <td>0.010233</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1987-10-30</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1987-11-30</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1987-12-31</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>0.078781</td>\n",
       "      <td>0.000444</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1988-01-07</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>-0.036153</td>\n",
       "      <td>0.000187</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.078781</td>\n",
       "      <td>0.000444</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1986-11-28</td>\n",
       "      <td>MSFT_2</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002200</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>1987-03-31</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>-0.177287</td>\n",
       "      <td>0.011104</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-0.116116</td>\n",
       "      <td>0.008010</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-0.172999</td>\n",
       "      <td>0.005983</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>1987-04-30</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>-0.121928</td>\n",
       "      <td>0.013232</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-0.177287</td>\n",
       "      <td>0.011104</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-0.116116</td>\n",
       "      <td>0.008010</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>1987-05-29</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>-0.103451</td>\n",
       "      <td>0.015038</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-0.121928</td>\n",
       "      <td>0.013232</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-0.177287</td>\n",
       "      <td>0.011104</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>1987-06-30</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>0.091884</td>\n",
       "      <td>0.013434</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.103451</td>\n",
       "      <td>0.015038</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-0.121928</td>\n",
       "      <td>0.013232</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>1987-07-31</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>0.183389</td>\n",
       "      <td>0.010233</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.091884</td>\n",
       "      <td>0.013434</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.103451</td>\n",
       "      <td>0.015038</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>1987-08-31</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.183389</td>\n",
       "      <td>0.010233</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.091884</td>\n",
       "      <td>0.013434</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>1987-09-30</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.183389</td>\n",
       "      <td>0.010233</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>1987-10-30</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>1987-11-30</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>1987-12-31</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>0.078781</td>\n",
       "      <td>0.000444</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>1988-01-29</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>0.039149</td>\n",
       "      <td>0.001128</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>0.078781</td>\n",
       "      <td>0.000444</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>1988-02-29</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>-0.032628</td>\n",
       "      <td>0.000558</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.039149</td>\n",
       "      <td>0.001128</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>0.078781</td>\n",
       "      <td>0.000444</td>\n",
       "      <td>-3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>1988-03-31</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>0.036486</td>\n",
       "      <td>0.001195</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.032628</td>\n",
       "      <td>0.000558</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.039149</td>\n",
       "      <td>0.001128</td>\n",
       "      <td>-4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>1988-04-29</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>0.077447</td>\n",
       "      <td>0.002547</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.036486</td>\n",
       "      <td>0.001195</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.032628</td>\n",
       "      <td>0.000558</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>1988-05-31</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>-0.009029</td>\n",
       "      <td>0.002389</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.077447</td>\n",
       "      <td>0.002547</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.036486</td>\n",
       "      <td>0.001195</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>1988-06-30</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>-0.173953</td>\n",
       "      <td>0.000647</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.009029</td>\n",
       "      <td>0.002389</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.077447</td>\n",
       "      <td>0.002547</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>1988-07-26</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>0.051390</td>\n",
       "      <td>0.000250</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.173953</td>\n",
       "      <td>0.000647</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.009029</td>\n",
       "      <td>0.002389</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>1986-11-28</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002200</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>1986-12-31</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>-0.043745</td>\n",
       "      <td>0.002964</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002200</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>1987-01-30</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>-0.172999</td>\n",
       "      <td>0.005983</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.043745</td>\n",
       "      <td>0.002964</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.002200</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>1987-02-27</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>-0.116116</td>\n",
       "      <td>0.008010</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-0.172999</td>\n",
       "      <td>0.005983</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.043745</td>\n",
       "      <td>0.002964</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>1987-03-31</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>-0.177287</td>\n",
       "      <td>0.011104</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-0.116116</td>\n",
       "      <td>0.008010</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-0.172999</td>\n",
       "      <td>0.005983</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>1987-04-30</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>-0.121928</td>\n",
       "      <td>0.013232</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-0.177287</td>\n",
       "      <td>0.011104</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-0.116116</td>\n",
       "      <td>0.008010</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>1987-05-29</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>-0.103451</td>\n",
       "      <td>0.015038</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-0.121928</td>\n",
       "      <td>0.013232</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-0.177287</td>\n",
       "      <td>0.011104</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>1987-06-30</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>0.091884</td>\n",
       "      <td>0.013434</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.103451</td>\n",
       "      <td>0.015038</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-0.121928</td>\n",
       "      <td>0.013232</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>1987-07-31</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>0.183389</td>\n",
       "      <td>0.010233</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.091884</td>\n",
       "      <td>0.013434</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.103451</td>\n",
       "      <td>0.015038</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>1987-08-31</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.183389</td>\n",
       "      <td>0.010233</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.091884</td>\n",
       "      <td>0.013434</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>1987-09-30</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.183389</td>\n",
       "      <td>0.010233</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>1987-10-30</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>1987-11-30</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          date  symbol  angle_between  distance  num_of_ups_downs  \\\n",
       "0   1986-11-28  MSFT_0       0.000000  0.002200               0.0   \n",
       "1   1986-12-31  MSFT_0      -0.043745  0.002964               1.0   \n",
       "2   1987-01-30  MSFT_0      -0.172999  0.005983               2.0   \n",
       "3   1987-02-27  MSFT_0      -0.116116  0.008010               3.0   \n",
       "4   1987-03-31  MSFT_0      -0.177287  0.011104               4.0   \n",
       "5   1987-04-30  MSFT_0      -0.121928  0.013232               5.0   \n",
       "6   1987-05-29  MSFT_0      -0.103451  0.015038               6.0   \n",
       "7   1987-06-30  MSFT_0       0.091884  0.013434              -1.0   \n",
       "8   1987-07-31  MSFT_0       0.183389  0.010233              -2.0   \n",
       "9   1987-08-31  MSFT_0      -0.003729  0.010298               1.0   \n",
       "10  1987-09-30  MSFT_0      -0.043759  0.011062               2.0   \n",
       "11  1987-10-30  MSFT_0       0.273222  0.006293              -1.0   \n",
       "12  1987-11-30  MSFT_0       0.307260  0.000931              -2.0   \n",
       "13  1987-12-01  MSFT_0       0.243127  0.003313              -3.0   \n",
       "14  1986-11-28  MSFT_1       0.000000  0.002200               0.0   \n",
       "15  1986-12-31  MSFT_1      -0.043745  0.002964               1.0   \n",
       "16  1987-01-30  MSFT_1      -0.172999  0.005983               2.0   \n",
       "17  1987-02-27  MSFT_1      -0.116116  0.008010               3.0   \n",
       "18  1987-03-31  MSFT_1      -0.177287  0.011104               4.0   \n",
       "19  1987-04-30  MSFT_1      -0.121928  0.013232               5.0   \n",
       "20  1987-05-29  MSFT_1      -0.103451  0.015038               6.0   \n",
       "21  1987-06-30  MSFT_1       0.091884  0.013434              -1.0   \n",
       "22  1987-07-31  MSFT_1       0.183389  0.010233              -2.0   \n",
       "23  1987-08-31  MSFT_1      -0.003729  0.010298               1.0   \n",
       "24  1987-09-30  MSFT_1      -0.043759  0.011062               2.0   \n",
       "25  1987-10-30  MSFT_1       0.273222  0.006293              -1.0   \n",
       "26  1987-11-30  MSFT_1       0.307260  0.000931              -2.0   \n",
       "27  1987-12-31  MSFT_1       0.078781  0.000444              -3.0   \n",
       "28  1988-01-07  MSFT_1      -0.036153  0.000187               1.0   \n",
       "29  1986-11-28  MSFT_2       0.000000  0.002200               0.0   \n",
       "..         ...     ...            ...       ...               ...   \n",
       "70  1987-03-31  MSFT_4      -0.177287  0.011104               4.0   \n",
       "71  1987-04-30  MSFT_4      -0.121928  0.013232               5.0   \n",
       "72  1987-05-29  MSFT_4      -0.103451  0.015038               6.0   \n",
       "73  1987-06-30  MSFT_4       0.091884  0.013434              -1.0   \n",
       "74  1987-07-31  MSFT_4       0.183389  0.010233              -2.0   \n",
       "75  1987-08-31  MSFT_4      -0.003729  0.010298               1.0   \n",
       "76  1987-09-30  MSFT_4      -0.043759  0.011062               2.0   \n",
       "77  1987-10-30  MSFT_4       0.273222  0.006293              -1.0   \n",
       "78  1987-11-30  MSFT_4       0.307260  0.000931              -2.0   \n",
       "79  1987-12-31  MSFT_4       0.078781  0.000444              -3.0   \n",
       "80  1988-01-29  MSFT_4       0.039149  0.001128              -4.0   \n",
       "81  1988-02-29  MSFT_4      -0.032628  0.000558               1.0   \n",
       "82  1988-03-31  MSFT_4       0.036486  0.001195              -1.0   \n",
       "83  1988-04-29  MSFT_4       0.077447  0.002547              -2.0   \n",
       "84  1988-05-31  MSFT_4      -0.009029  0.002389               1.0   \n",
       "85  1988-06-30  MSFT_4      -0.173953  0.000647               2.0   \n",
       "86  1988-07-26  MSFT_4       0.051390  0.000250              -1.0   \n",
       "87  1986-11-28  MSFT_5       0.000000  0.002200               0.0   \n",
       "88  1986-12-31  MSFT_5      -0.043745  0.002964               1.0   \n",
       "89  1987-01-30  MSFT_5      -0.172999  0.005983               2.0   \n",
       "90  1987-02-27  MSFT_5      -0.116116  0.008010               3.0   \n",
       "91  1987-03-31  MSFT_5      -0.177287  0.011104               4.0   \n",
       "92  1987-04-30  MSFT_5      -0.121928  0.013232               5.0   \n",
       "93  1987-05-29  MSFT_5      -0.103451  0.015038               6.0   \n",
       "94  1987-06-30  MSFT_5       0.091884  0.013434              -1.0   \n",
       "95  1987-07-31  MSFT_5       0.183389  0.010233              -2.0   \n",
       "96  1987-08-31  MSFT_5      -0.003729  0.010298               1.0   \n",
       "97  1987-09-30  MSFT_5      -0.043759  0.011062               2.0   \n",
       "98  1987-10-30  MSFT_5       0.273222  0.006293              -1.0   \n",
       "99  1987-11-30  MSFT_5       0.307260  0.000931              -2.0   \n",
       "\n",
       "    ('angle_between_1_before',)  ('distance_1_before',)  \\\n",
       "0                           NaN                     NaN   \n",
       "1                      0.000000                0.002200   \n",
       "2                     -0.043745                0.002964   \n",
       "3                     -0.172999                0.005983   \n",
       "4                     -0.116116                0.008010   \n",
       "5                     -0.177287                0.011104   \n",
       "6                     -0.121928                0.013232   \n",
       "7                     -0.103451                0.015038   \n",
       "8                      0.091884                0.013434   \n",
       "9                      0.183389                0.010233   \n",
       "10                    -0.003729                0.010298   \n",
       "11                    -0.043759                0.011062   \n",
       "12                     0.273222                0.006293   \n",
       "13                     0.307260                0.000931   \n",
       "14                          NaN                     NaN   \n",
       "15                     0.000000                0.002200   \n",
       "16                    -0.043745                0.002964   \n",
       "17                    -0.172999                0.005983   \n",
       "18                    -0.116116                0.008010   \n",
       "19                    -0.177287                0.011104   \n",
       "20                    -0.121928                0.013232   \n",
       "21                    -0.103451                0.015038   \n",
       "22                     0.091884                0.013434   \n",
       "23                     0.183389                0.010233   \n",
       "24                    -0.003729                0.010298   \n",
       "25                    -0.043759                0.011062   \n",
       "26                     0.273222                0.006293   \n",
       "27                     0.307260                0.000931   \n",
       "28                     0.078781                0.000444   \n",
       "29                          NaN                     NaN   \n",
       "..                          ...                     ...   \n",
       "70                    -0.116116                0.008010   \n",
       "71                    -0.177287                0.011104   \n",
       "72                    -0.121928                0.013232   \n",
       "73                    -0.103451                0.015038   \n",
       "74                     0.091884                0.013434   \n",
       "75                     0.183389                0.010233   \n",
       "76                    -0.003729                0.010298   \n",
       "77                    -0.043759                0.011062   \n",
       "78                     0.273222                0.006293   \n",
       "79                     0.307260                0.000931   \n",
       "80                     0.078781                0.000444   \n",
       "81                     0.039149                0.001128   \n",
       "82                    -0.032628                0.000558   \n",
       "83                     0.036486                0.001195   \n",
       "84                     0.077447                0.002547   \n",
       "85                    -0.009029                0.002389   \n",
       "86                    -0.173953                0.000647   \n",
       "87                          NaN                     NaN   \n",
       "88                     0.000000                0.002200   \n",
       "89                    -0.043745                0.002964   \n",
       "90                    -0.172999                0.005983   \n",
       "91                    -0.116116                0.008010   \n",
       "92                    -0.177287                0.011104   \n",
       "93                    -0.121928                0.013232   \n",
       "94                    -0.103451                0.015038   \n",
       "95                     0.091884                0.013434   \n",
       "96                     0.183389                0.010233   \n",
       "97                    -0.003729                0.010298   \n",
       "98                    -0.043759                0.011062   \n",
       "99                     0.273222                0.006293   \n",
       "\n",
       "    ('num_of_ups_downs_1_before',)  ('angle_between_2_before',)  \\\n",
       "0                              NaN                          NaN   \n",
       "1                              0.0                          NaN   \n",
       "2                              1.0                     0.000000   \n",
       "3                              2.0                    -0.043745   \n",
       "4                              3.0                    -0.172999   \n",
       "5                              4.0                    -0.116116   \n",
       "6                              5.0                    -0.177287   \n",
       "7                              6.0                    -0.121928   \n",
       "8                             -1.0                    -0.103451   \n",
       "9                             -2.0                     0.091884   \n",
       "10                             1.0                     0.183389   \n",
       "11                             2.0                    -0.003729   \n",
       "12                            -1.0                    -0.043759   \n",
       "13                            -2.0                     0.273222   \n",
       "14                             NaN                          NaN   \n",
       "15                             0.0                          NaN   \n",
       "16                             1.0                     0.000000   \n",
       "17                             2.0                    -0.043745   \n",
       "18                             3.0                    -0.172999   \n",
       "19                             4.0                    -0.116116   \n",
       "20                             5.0                    -0.177287   \n",
       "21                             6.0                    -0.121928   \n",
       "22                            -1.0                    -0.103451   \n",
       "23                            -2.0                     0.091884   \n",
       "24                             1.0                     0.183389   \n",
       "25                             2.0                    -0.003729   \n",
       "26                            -1.0                    -0.043759   \n",
       "27                            -2.0                     0.273222   \n",
       "28                            -3.0                     0.307260   \n",
       "29                             NaN                          NaN   \n",
       "..                             ...                          ...   \n",
       "70                             3.0                    -0.172999   \n",
       "71                             4.0                    -0.116116   \n",
       "72                             5.0                    -0.177287   \n",
       "73                             6.0                    -0.121928   \n",
       "74                            -1.0                    -0.103451   \n",
       "75                            -2.0                     0.091884   \n",
       "76                             1.0                     0.183389   \n",
       "77                             2.0                    -0.003729   \n",
       "78                            -1.0                    -0.043759   \n",
       "79                            -2.0                     0.273222   \n",
       "80                            -3.0                     0.307260   \n",
       "81                            -4.0                     0.078781   \n",
       "82                             1.0                     0.039149   \n",
       "83                            -1.0                    -0.032628   \n",
       "84                            -2.0                     0.036486   \n",
       "85                             1.0                     0.077447   \n",
       "86                             2.0                    -0.009029   \n",
       "87                             NaN                          NaN   \n",
       "88                             0.0                          NaN   \n",
       "89                             1.0                     0.000000   \n",
       "90                             2.0                    -0.043745   \n",
       "91                             3.0                    -0.172999   \n",
       "92                             4.0                    -0.116116   \n",
       "93                             5.0                    -0.177287   \n",
       "94                             6.0                    -0.121928   \n",
       "95                            -1.0                    -0.103451   \n",
       "96                            -2.0                     0.091884   \n",
       "97                             1.0                     0.183389   \n",
       "98                             2.0                    -0.003729   \n",
       "99                            -1.0                    -0.043759   \n",
       "\n",
       "    ('distance_2_before',)  ('num_of_ups_downs_2_before',)  \n",
       "0                      NaN                             NaN  \n",
       "1                      NaN                             NaN  \n",
       "2                 0.002200                             0.0  \n",
       "3                 0.002964                             1.0  \n",
       "4                 0.005983                             2.0  \n",
       "5                 0.008010                             3.0  \n",
       "6                 0.011104                             4.0  \n",
       "7                 0.013232                             5.0  \n",
       "8                 0.015038                             6.0  \n",
       "9                 0.013434                            -1.0  \n",
       "10                0.010233                            -2.0  \n",
       "11                0.010298                             1.0  \n",
       "12                0.011062                             2.0  \n",
       "13                0.006293                            -1.0  \n",
       "14                     NaN                             NaN  \n",
       "15                     NaN                             NaN  \n",
       "16                0.002200                             0.0  \n",
       "17                0.002964                             1.0  \n",
       "18                0.005983                             2.0  \n",
       "19                0.008010                             3.0  \n",
       "20                0.011104                             4.0  \n",
       "21                0.013232                             5.0  \n",
       "22                0.015038                             6.0  \n",
       "23                0.013434                            -1.0  \n",
       "24                0.010233                            -2.0  \n",
       "25                0.010298                             1.0  \n",
       "26                0.011062                             2.0  \n",
       "27                0.006293                            -1.0  \n",
       "28                0.000931                            -2.0  \n",
       "29                     NaN                             NaN  \n",
       "..                     ...                             ...  \n",
       "70                0.005983                             2.0  \n",
       "71                0.008010                             3.0  \n",
       "72                0.011104                             4.0  \n",
       "73                0.013232                             5.0  \n",
       "74                0.015038                             6.0  \n",
       "75                0.013434                            -1.0  \n",
       "76                0.010233                            -2.0  \n",
       "77                0.010298                             1.0  \n",
       "78                0.011062                             2.0  \n",
       "79                0.006293                            -1.0  \n",
       "80                0.000931                            -2.0  \n",
       "81                0.000444                            -3.0  \n",
       "82                0.001128                            -4.0  \n",
       "83                0.000558                             1.0  \n",
       "84                0.001195                            -1.0  \n",
       "85                0.002547                            -2.0  \n",
       "86                0.002389                             1.0  \n",
       "87                     NaN                             NaN  \n",
       "88                     NaN                             NaN  \n",
       "89                0.002200                             0.0  \n",
       "90                0.002964                             1.0  \n",
       "91                0.005983                             2.0  \n",
       "92                0.008010                             3.0  \n",
       "93                0.011104                             4.0  \n",
       "94                0.013232                             5.0  \n",
       "95                0.015038                             6.0  \n",
       "96                0.013434                            -1.0  \n",
       "97                0.010233                            -2.0  \n",
       "98                0.010298                             1.0  \n",
       "99                0.011062                             2.0  \n",
       "\n",
       "[100 rows x 11 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "110"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.symbol.nunique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "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>date</th>\n",
       "      <th>symbol</th>\n",
       "      <th>angle_between</th>\n",
       "      <th>distance</th>\n",
       "      <th>num_of_ups_downs</th>\n",
       "      <th>('angle_between_1_before',)</th>\n",
       "      <th>('distance_1_before',)</th>\n",
       "      <th>('num_of_ups_downs_1_before',)</th>\n",
       "      <th>('angle_between_2_before',)</th>\n",
       "      <th>('distance_2_before',)</th>\n",
       "      <th>('num_of_ups_downs_2_before',)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1987-08-31</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.183389</td>\n",
       "      <td>0.010233</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.091884</td>\n",
       "      <td>0.013434</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1987-09-30</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.183389</td>\n",
       "      <td>0.010233</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1987-10-30</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1987-11-30</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1987-12-01</td>\n",
       "      <td>MSFT_0</td>\n",
       "      <td>0.243127</td>\n",
       "      <td>0.003313</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1987-09-30</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.183389</td>\n",
       "      <td>0.010233</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1987-10-30</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.003729</td>\n",
       "      <td>0.010298</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1987-11-30</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1987-12-31</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>0.078781</td>\n",
       "      <td>0.000444</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1988-01-07</td>\n",
       "      <td>MSFT_1</td>\n",
       "      <td>-0.036153</td>\n",
       "      <td>0.000187</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.078781</td>\n",
       "      <td>0.000444</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>1987-11-30</td>\n",
       "      <td>MSFT_2</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.043759</td>\n",
       "      <td>0.011062</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>1987-12-31</td>\n",
       "      <td>MSFT_2</td>\n",
       "      <td>0.078781</td>\n",
       "      <td>0.000444</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.273222</td>\n",
       "      <td>0.006293</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>1988-01-29</td>\n",
       "      <td>MSFT_2</td>\n",
       "      <td>0.039149</td>\n",
       "      <td>0.001128</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>0.078781</td>\n",
       "      <td>0.000444</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>0.307260</td>\n",
       "      <td>0.000931</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>1988-02-29</td>\n",
       "      <td>MSFT_2</td>\n",
       "      <td>-0.032628</td>\n",
       "      <td>0.000558</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.039149</td>\n",
       "      <td>0.001128</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>0.078781</td>\n",
       "      <td>0.000444</td>\n",
       "      <td>-3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>1988-03-03</td>\n",
       "      <td>MSFT_2</td>\n",
       "      <td>-0.036499</td>\n",
       "      <td>0.000079</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.032628</td>\n",
       "      <td>0.000558</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.039149</td>\n",
       "      <td>0.001128</td>\n",
       "      <td>-4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>1988-02-29</td>\n",
       "      <td>MSFT_3</td>\n",
       "      <td>-0.032628</td>\n",
       "      <td>0.000558</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.039149</td>\n",
       "      <td>0.001128</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>0.078781</td>\n",
       "      <td>0.000444</td>\n",
       "      <td>-3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>1988-03-31</td>\n",
       "      <td>MSFT_3</td>\n",
       "      <td>0.036486</td>\n",
       "      <td>0.001195</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.032628</td>\n",
       "      <td>0.000558</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.039149</td>\n",
       "      <td>0.001128</td>\n",
       "      <td>-4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>1988-04-29</td>\n",
       "      <td>MSFT_3</td>\n",
       "      <td>0.077447</td>\n",
       "      <td>0.002547</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.036486</td>\n",
       "      <td>0.001195</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.032628</td>\n",
       "      <td>0.000558</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>1988-05-31</td>\n",
       "      <td>MSFT_3</td>\n",
       "      <td>-0.009029</td>\n",
       "      <td>0.002389</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.077447</td>\n",
       "      <td>0.002547</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.036486</td>\n",
       "      <td>0.001195</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>1988-06-22</td>\n",
       "      <td>MSFT_3</td>\n",
       "      <td>-0.173953</td>\n",
       "      <td>0.000647</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.009029</td>\n",
       "      <td>0.002389</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.077447</td>\n",
       "      <td>0.002547</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>1988-03-31</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>0.036486</td>\n",
       "      <td>0.001195</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.032628</td>\n",
       "      <td>0.000558</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.039149</td>\n",
       "      <td>0.001128</td>\n",
       "      <td>-4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>1988-04-29</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>0.077447</td>\n",
       "      <td>0.002547</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.036486</td>\n",
       "      <td>0.001195</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.032628</td>\n",
       "      <td>0.000558</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>1988-05-31</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>-0.009029</td>\n",
       "      <td>0.002389</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.077447</td>\n",
       "      <td>0.002547</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.036486</td>\n",
       "      <td>0.001195</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>1988-06-30</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>-0.173953</td>\n",
       "      <td>0.000647</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.009029</td>\n",
       "      <td>0.002389</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.077447</td>\n",
       "      <td>0.002547</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>1988-07-26</td>\n",
       "      <td>MSFT_4</td>\n",
       "      <td>0.051390</td>\n",
       "      <td>0.000250</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.173953</td>\n",
       "      <td>0.000647</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.009029</td>\n",
       "      <td>0.002389</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>1988-04-29</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>0.077447</td>\n",
       "      <td>0.002547</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.036486</td>\n",
       "      <td>0.001195</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.032628</td>\n",
       "      <td>0.000558</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>1988-05-31</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>-0.009029</td>\n",
       "      <td>0.002389</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.077447</td>\n",
       "      <td>0.002547</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.036486</td>\n",
       "      <td>0.001195</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>1988-06-30</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>-0.173953</td>\n",
       "      <td>0.000647</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.009029</td>\n",
       "      <td>0.002389</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.077447</td>\n",
       "      <td>0.002547</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>1988-07-29</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>0.026158</td>\n",
       "      <td>0.000190</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.173953</td>\n",
       "      <td>0.000647</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-0.009029</td>\n",
       "      <td>0.002389</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>1988-08-01</td>\n",
       "      <td>MSFT_5</td>\n",
       "      <td>0.066600</td>\n",
       "      <td>0.000972</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>0.026158</td>\n",
       "      <td>0.000190</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.173953</td>\n",
       "      <td>0.000647</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21163</th>\n",
       "      <td>2013-08-30</td>\n",
       "      <td>AAPL_41</td>\n",
       "      <td>-48.820412</td>\n",
       "      <td>3.067684</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-25.718761</td>\n",
       "      <td>4.160542</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.387427</td>\n",
       "      <td>4.867598</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21164</th>\n",
       "      <td>2013-09-30</td>\n",
       "      <td>AAPL_41</td>\n",
       "      <td>-37.380741</td>\n",
       "      <td>2.232785</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-48.820412</td>\n",
       "      <td>3.067684</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-25.718761</td>\n",
       "      <td>4.160542</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21165</th>\n",
       "      <td>2013-10-31</td>\n",
       "      <td>AAPL_41</td>\n",
       "      <td>-55.354262</td>\n",
       "      <td>1.163454</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-37.380741</td>\n",
       "      <td>2.232785</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-48.820412</td>\n",
       "      <td>3.067684</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21166</th>\n",
       "      <td>2013-11-29</td>\n",
       "      <td>AAPL_41</td>\n",
       "      <td>-56.710628</td>\n",
       "      <td>0.074893</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-55.354262</td>\n",
       "      <td>1.163454</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-37.380741</td>\n",
       "      <td>2.232785</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21167</th>\n",
       "      <td>2013-12-02</td>\n",
       "      <td>AAPL_41</td>\n",
       "      <td>-36.660602</td>\n",
       "      <td>0.592590</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-56.710628</td>\n",
       "      <td>0.074893</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-55.354262</td>\n",
       "      <td>1.163454</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21572</th>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>AAPL_42</td>\n",
       "      <td>21.128561</td>\n",
       "      <td>2.935238</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>12.170077</td>\n",
       "      <td>3.428942</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-9.828255</td>\n",
       "      <td>3.750636</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21573</th>\n",
       "      <td>2015-05-29</td>\n",
       "      <td>AAPL_42</td>\n",
       "      <td>9.619803</td>\n",
       "      <td>2.697363</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>21.128561</td>\n",
       "      <td>2.935238</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>12.170077</td>\n",
       "      <td>3.428942</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21574</th>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>AAPL_42</td>\n",
       "      <td>41.008535</td>\n",
       "      <td>1.898084</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>9.619803</td>\n",
       "      <td>2.697363</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>21.128561</td>\n",
       "      <td>2.935238</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21575</th>\n",
       "      <td>2015-07-31</td>\n",
       "      <td>AAPL_42</td>\n",
       "      <td>56.739450</td>\n",
       "      <td>0.817386</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>41.008535</td>\n",
       "      <td>1.898084</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>9.619803</td>\n",
       "      <td>2.697363</td>\n",
       "      <td>-3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21576</th>\n",
       "      <td>2015-08-03</td>\n",
       "      <td>AAPL_42</td>\n",
       "      <td>53.680952</td>\n",
       "      <td>0.257819</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>56.739450</td>\n",
       "      <td>0.817386</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>41.008535</td>\n",
       "      <td>1.898084</td>\n",
       "      <td>-4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21995</th>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>AAPL_43</td>\n",
       "      <td>-3.894893</td>\n",
       "      <td>4.280275</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-12.211191</td>\n",
       "      <td>4.413275</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.540360</td>\n",
       "      <td>4.795113</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21996</th>\n",
       "      <td>2016-07-29</td>\n",
       "      <td>AAPL_43</td>\n",
       "      <td>-40.777717</td>\n",
       "      <td>3.351453</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-3.894893</td>\n",
       "      <td>4.280275</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-12.211191</td>\n",
       "      <td>4.413275</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21997</th>\n",
       "      <td>2016-08-31</td>\n",
       "      <td>AAPL_43</td>\n",
       "      <td>-49.215246</td>\n",
       "      <td>2.308557</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-40.777717</td>\n",
       "      <td>3.351453</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-3.894893</td>\n",
       "      <td>4.280275</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21998</th>\n",
       "      <td>2016-09-30</td>\n",
       "      <td>AAPL_43</td>\n",
       "      <td>-65.873195</td>\n",
       "      <td>1.010436</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-49.215246</td>\n",
       "      <td>2.308557</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-40.777717</td>\n",
       "      <td>3.351453</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21999</th>\n",
       "      <td>2016-10-10</td>\n",
       "      <td>AAPL_43</td>\n",
       "      <td>-56.401294</td>\n",
       "      <td>0.075273</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-65.873195</td>\n",
       "      <td>1.010436</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-49.215246</td>\n",
       "      <td>2.308557</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22419</th>\n",
       "      <td>2016-07-29</td>\n",
       "      <td>AAPL_44</td>\n",
       "      <td>-40.777717</td>\n",
       "      <td>3.351453</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-3.894893</td>\n",
       "      <td>4.280275</td>\n",
       "      <td>2.0</td>\n",
       "      <td>-12.211191</td>\n",
       "      <td>4.413275</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22420</th>\n",
       "      <td>2016-08-31</td>\n",
       "      <td>AAPL_44</td>\n",
       "      <td>-49.215246</td>\n",
       "      <td>2.308557</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-40.777717</td>\n",
       "      <td>3.351453</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-3.894893</td>\n",
       "      <td>4.280275</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22421</th>\n",
       "      <td>2016-09-30</td>\n",
       "      <td>AAPL_44</td>\n",
       "      <td>-65.873195</td>\n",
       "      <td>1.010436</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-49.215246</td>\n",
       "      <td>2.308557</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-40.777717</td>\n",
       "      <td>3.351453</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22422</th>\n",
       "      <td>2016-10-31</td>\n",
       "      <td>AAPL_44</td>\n",
       "      <td>-49.080559</td>\n",
       "      <td>0.097017</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-65.873195</td>\n",
       "      <td>1.010436</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-49.215246</td>\n",
       "      <td>2.308557</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22423</th>\n",
       "      <td>2016-11-01</td>\n",
       "      <td>AAPL_44</td>\n",
       "      <td>-23.805589</td>\n",
       "      <td>0.324974</td>\n",
       "      <td>7.0</td>\n",
       "      <td>-49.080559</td>\n",
       "      <td>0.097017</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-65.873195</td>\n",
       "      <td>1.010436</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22861</th>\n",
       "      <td>2018-01-31</td>\n",
       "      <td>AAPL_45</td>\n",
       "      <td>39.632643</td>\n",
       "      <td>2.675709</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>20.859175</td>\n",
       "      <td>3.513740</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>1.983974</td>\n",
       "      <td>4.066526</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22862</th>\n",
       "      <td>2018-02-28</td>\n",
       "      <td>AAPL_45</td>\n",
       "      <td>0.948720</td>\n",
       "      <td>2.650392</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>39.632643</td>\n",
       "      <td>2.675709</td>\n",
       "      <td>-3.0</td>\n",
       "      <td>20.859175</td>\n",
       "      <td>3.513740</td>\n",
       "      <td>-2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22863</th>\n",
       "      <td>2018-03-30</td>\n",
       "      <td>AAPL_45</td>\n",
       "      <td>57.037623</td>\n",
       "      <td>1.557909</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>0.948720</td>\n",
       "      <td>2.650392</td>\n",
       "      <td>-4.0</td>\n",
       "      <td>39.632643</td>\n",
       "      <td>2.675709</td>\n",
       "      <td>-3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22864</th>\n",
       "      <td>2018-04-30</td>\n",
       "      <td>AAPL_45</td>\n",
       "      <td>62.560425</td>\n",
       "      <td>0.324163</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>57.037623</td>\n",
       "      <td>1.557909</td>\n",
       "      <td>-5.0</td>\n",
       "      <td>0.948720</td>\n",
       "      <td>2.650392</td>\n",
       "      <td>-4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22865</th>\n",
       "      <td>2018-05-01</td>\n",
       "      <td>AAPL_45</td>\n",
       "      <td>39.221003</td>\n",
       "      <td>0.397940</td>\n",
       "      <td>-7.0</td>\n",
       "      <td>62.560425</td>\n",
       "      <td>0.324163</td>\n",
       "      <td>-6.0</td>\n",
       "      <td>57.037623</td>\n",
       "      <td>1.557909</td>\n",
       "      <td>-5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23310</th>\n",
       "      <td>2018-08-31</td>\n",
       "      <td>AAPL_46</td>\n",
       "      <td>-43.126545</td>\n",
       "      <td>3.796027</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-10.004211</td>\n",
       "      <td>1.125953</td>\n",
       "      <td>3.0</td>\n",
       "      <td>-0.705430</td>\n",
       "      <td>0.918073</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23311</th>\n",
       "      <td>2018-09-28</td>\n",
       "      <td>AAPL_46</td>\n",
       "      <td>-27.387994</td>\n",
       "      <td>5.125682</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-43.126545</td>\n",
       "      <td>3.796027</td>\n",
       "      <td>4.0</td>\n",
       "      <td>-10.004211</td>\n",
       "      <td>1.125953</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23312</th>\n",
       "      <td>2018-10-31</td>\n",
       "      <td>AAPL_46</td>\n",
       "      <td>-0.609757</td>\n",
       "      <td>5.144126</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-27.387994</td>\n",
       "      <td>5.125682</td>\n",
       "      <td>5.0</td>\n",
       "      <td>-43.126545</td>\n",
       "      <td>3.796027</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23313</th>\n",
       "      <td>2018-11-30</td>\n",
       "      <td>AAPL_46</td>\n",
       "      <td>94.903693</td>\n",
       "      <td>1.871096</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.609757</td>\n",
       "      <td>5.144126</td>\n",
       "      <td>6.0</td>\n",
       "      <td>-27.387994</td>\n",
       "      <td>5.125682</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23314</th>\n",
       "      <td>2018-12-03</td>\n",
       "      <td>AAPL_46</td>\n",
       "      <td>79.459919</td>\n",
       "      <td>0.443240</td>\n",
       "      <td>-2.0</td>\n",
       "      <td>94.903693</td>\n",
       "      <td>1.871096</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>-0.609757</td>\n",
       "      <td>5.144126</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>550 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             date   symbol  angle_between  distance  num_of_ups_downs  \\\n",
       "9      1987-08-31   MSFT_0      -0.003729  0.010298               1.0   \n",
       "10     1987-09-30   MSFT_0      -0.043759  0.011062               2.0   \n",
       "11     1987-10-30   MSFT_0       0.273222  0.006293              -1.0   \n",
       "12     1987-11-30   MSFT_0       0.307260  0.000931              -2.0   \n",
       "13     1987-12-01   MSFT_0       0.243127  0.003313              -3.0   \n",
       "24     1987-09-30   MSFT_1      -0.043759  0.011062               2.0   \n",
       "25     1987-10-30   MSFT_1       0.273222  0.006293              -1.0   \n",
       "26     1987-11-30   MSFT_1       0.307260  0.000931              -2.0   \n",
       "27     1987-12-31   MSFT_1       0.078781  0.000444              -3.0   \n",
       "28     1988-01-07   MSFT_1      -0.036153  0.000187               1.0   \n",
       "41     1987-11-30   MSFT_2       0.307260  0.000931              -2.0   \n",
       "42     1987-12-31   MSFT_2       0.078781  0.000444              -3.0   \n",
       "43     1988-01-29   MSFT_2       0.039149  0.001128              -4.0   \n",
       "44     1988-02-29   MSFT_2      -0.032628  0.000558               1.0   \n",
       "45     1988-03-03   MSFT_2      -0.036499  0.000079               2.0   \n",
       "61     1988-02-29   MSFT_3      -0.032628  0.000558               1.0   \n",
       "62     1988-03-31   MSFT_3       0.036486  0.001195              -1.0   \n",
       "63     1988-04-29   MSFT_3       0.077447  0.002547              -2.0   \n",
       "64     1988-05-31   MSFT_3      -0.009029  0.002389               1.0   \n",
       "65     1988-06-22   MSFT_3      -0.173953  0.000647               2.0   \n",
       "82     1988-03-31   MSFT_4       0.036486  0.001195              -1.0   \n",
       "83     1988-04-29   MSFT_4       0.077447  0.002547              -2.0   \n",
       "84     1988-05-31   MSFT_4      -0.009029  0.002389               1.0   \n",
       "85     1988-06-30   MSFT_4      -0.173953  0.000647               2.0   \n",
       "86     1988-07-26   MSFT_4       0.051390  0.000250              -1.0   \n",
       "104    1988-04-29   MSFT_5       0.077447  0.002547              -2.0   \n",
       "105    1988-05-31   MSFT_5      -0.009029  0.002389               1.0   \n",
       "106    1988-06-30   MSFT_5      -0.173953  0.000647               2.0   \n",
       "107    1988-07-29   MSFT_5       0.026158  0.000190              -1.0   \n",
       "108    1988-08-01   MSFT_5       0.066600  0.000972              -2.0   \n",
       "...           ...      ...            ...       ...               ...   \n",
       "21163  2013-08-30  AAPL_41     -48.820412  3.067684               2.0   \n",
       "21164  2013-09-30  AAPL_41     -37.380741  2.232785               3.0   \n",
       "21165  2013-10-31  AAPL_41     -55.354262  1.163454               4.0   \n",
       "21166  2013-11-29  AAPL_41     -56.710628  0.074893               5.0   \n",
       "21167  2013-12-02  AAPL_41     -36.660602  0.592590               6.0   \n",
       "21572  2015-04-30  AAPL_42      21.128561  2.935238              -2.0   \n",
       "21573  2015-05-29  AAPL_42       9.619803  2.697363              -3.0   \n",
       "21574  2015-06-30  AAPL_42      41.008535  1.898084              -4.0   \n",
       "21575  2015-07-31  AAPL_42      56.739450  0.817386              -5.0   \n",
       "21576  2015-08-03  AAPL_42      53.680952  0.257819              -6.0   \n",
       "21995  2016-06-30  AAPL_43      -3.894893  4.280275               2.0   \n",
       "21996  2016-07-29  AAPL_43     -40.777717  3.351453               3.0   \n",
       "21997  2016-08-31  AAPL_43     -49.215246  2.308557               4.0   \n",
       "21998  2016-09-30  AAPL_43     -65.873195  1.010436               5.0   \n",
       "21999  2016-10-10  AAPL_43     -56.401294  0.075273               6.0   \n",
       "22419  2016-07-29  AAPL_44     -40.777717  3.351453               3.0   \n",
       "22420  2016-08-31  AAPL_44     -49.215246  2.308557               4.0   \n",
       "22421  2016-09-30  AAPL_44     -65.873195  1.010436               5.0   \n",
       "22422  2016-10-31  AAPL_44     -49.080559  0.097017               6.0   \n",
       "22423  2016-11-01  AAPL_44     -23.805589  0.324974               7.0   \n",
       "22861  2018-01-31  AAPL_45      39.632643  2.675709              -3.0   \n",
       "22862  2018-02-28  AAPL_45       0.948720  2.650392              -4.0   \n",
       "22863  2018-03-30  AAPL_45      57.037623  1.557909              -5.0   \n",
       "22864  2018-04-30  AAPL_45      62.560425  0.324163              -6.0   \n",
       "22865  2018-05-01  AAPL_45      39.221003  0.397940              -7.0   \n",
       "23310  2018-08-31  AAPL_46     -43.126545  3.796027               4.0   \n",
       "23311  2018-09-28  AAPL_46     -27.387994  5.125682               5.0   \n",
       "23312  2018-10-31  AAPL_46      -0.609757  5.144126               6.0   \n",
       "23313  2018-11-30  AAPL_46      94.903693  1.871096              -1.0   \n",
       "23314  2018-12-03  AAPL_46      79.459919  0.443240              -2.0   \n",
       "\n",
       "       ('angle_between_1_before',)  ('distance_1_before',)  \\\n",
       "9                         0.183389                0.010233   \n",
       "10                       -0.003729                0.010298   \n",
       "11                       -0.043759                0.011062   \n",
       "12                        0.273222                0.006293   \n",
       "13                        0.307260                0.000931   \n",
       "24                       -0.003729                0.010298   \n",
       "25                       -0.043759                0.011062   \n",
       "26                        0.273222                0.006293   \n",
       "27                        0.307260                0.000931   \n",
       "28                        0.078781                0.000444   \n",
       "41                        0.273222                0.006293   \n",
       "42                        0.307260                0.000931   \n",
       "43                        0.078781                0.000444   \n",
       "44                        0.039149                0.001128   \n",
       "45                       -0.032628                0.000558   \n",
       "61                        0.039149                0.001128   \n",
       "62                       -0.032628                0.000558   \n",
       "63                        0.036486                0.001195   \n",
       "64                        0.077447                0.002547   \n",
       "65                       -0.009029                0.002389   \n",
       "82                       -0.032628                0.000558   \n",
       "83                        0.036486                0.001195   \n",
       "84                        0.077447                0.002547   \n",
       "85                       -0.009029                0.002389   \n",
       "86                       -0.173953                0.000647   \n",
       "104                       0.036486                0.001195   \n",
       "105                       0.077447                0.002547   \n",
       "106                      -0.009029                0.002389   \n",
       "107                      -0.173953                0.000647   \n",
       "108                       0.026158                0.000190   \n",
       "...                            ...                     ...   \n",
       "21163                   -25.718761                4.160542   \n",
       "21164                   -48.820412                3.067684   \n",
       "21165                   -37.380741                2.232785   \n",
       "21166                   -55.354262                1.163454   \n",
       "21167                   -56.710628                0.074893   \n",
       "21572                    12.170077                3.428942   \n",
       "21573                    21.128561                2.935238   \n",
       "21574                     9.619803                2.697363   \n",
       "21575                    41.008535                1.898084   \n",
       "21576                    56.739450                0.817386   \n",
       "21995                   -12.211191                4.413275   \n",
       "21996                    -3.894893                4.280275   \n",
       "21997                   -40.777717                3.351453   \n",
       "21998                   -49.215246                2.308557   \n",
       "21999                   -65.873195                1.010436   \n",
       "22419                    -3.894893                4.280275   \n",
       "22420                   -40.777717                3.351453   \n",
       "22421                   -49.215246                2.308557   \n",
       "22422                   -65.873195                1.010436   \n",
       "22423                   -49.080559                0.097017   \n",
       "22861                    20.859175                3.513740   \n",
       "22862                    39.632643                2.675709   \n",
       "22863                     0.948720                2.650392   \n",
       "22864                    57.037623                1.557909   \n",
       "22865                    62.560425                0.324163   \n",
       "23310                   -10.004211                1.125953   \n",
       "23311                   -43.126545                3.796027   \n",
       "23312                   -27.387994                5.125682   \n",
       "23313                    -0.609757                5.144126   \n",
       "23314                    94.903693                1.871096   \n",
       "\n",
       "       ('num_of_ups_downs_1_before',)  ('angle_between_2_before',)  \\\n",
       "9                                -2.0                     0.091884   \n",
       "10                                1.0                     0.183389   \n",
       "11                                2.0                    -0.003729   \n",
       "12                               -1.0                    -0.043759   \n",
       "13                               -2.0                     0.273222   \n",
       "24                                1.0                     0.183389   \n",
       "25                                2.0                    -0.003729   \n",
       "26                               -1.0                    -0.043759   \n",
       "27                               -2.0                     0.273222   \n",
       "28                               -3.0                     0.307260   \n",
       "41                               -1.0                    -0.043759   \n",
       "42                               -2.0                     0.273222   \n",
       "43                               -3.0                     0.307260   \n",
       "44                               -4.0                     0.078781   \n",
       "45                                1.0                     0.039149   \n",
       "61                               -4.0                     0.078781   \n",
       "62                                1.0                     0.039149   \n",
       "63                               -1.0                    -0.032628   \n",
       "64                               -2.0                     0.036486   \n",
       "65                                1.0                     0.077447   \n",
       "82                                1.0                     0.039149   \n",
       "83                               -1.0                    -0.032628   \n",
       "84                               -2.0                     0.036486   \n",
       "85                                1.0                     0.077447   \n",
       "86                                2.0                    -0.009029   \n",
       "104                              -1.0                    -0.032628   \n",
       "105                              -2.0                     0.036486   \n",
       "106                               1.0                     0.077447   \n",
       "107                               2.0                    -0.009029   \n",
       "108                              -1.0                    -0.173953   \n",
       "...                               ...                          ...   \n",
       "21163                             1.0                     2.387427   \n",
       "21164                             2.0                   -25.718761   \n",
       "21165                             3.0                   -48.820412   \n",
       "21166                             4.0                   -37.380741   \n",
       "21167                             5.0                   -55.354262   \n",
       "21572                            -1.0                    -9.828255   \n",
       "21573                            -2.0                    12.170077   \n",
       "21574                            -3.0                    21.128561   \n",
       "21575                            -4.0                     9.619803   \n",
       "21576                            -5.0                    41.008535   \n",
       "21995                             1.0                     7.540360   \n",
       "21996                             2.0                   -12.211191   \n",
       "21997                             3.0                    -3.894893   \n",
       "21998                             4.0                   -40.777717   \n",
       "21999                             5.0                   -49.215246   \n",
       "22419                             2.0                   -12.211191   \n",
       "22420                             3.0                    -3.894893   \n",
       "22421                             4.0                   -40.777717   \n",
       "22422                             5.0                   -49.215246   \n",
       "22423                             6.0                   -65.873195   \n",
       "22861                            -2.0                     1.983974   \n",
       "22862                            -3.0                    20.859175   \n",
       "22863                            -4.0                    39.632643   \n",
       "22864                            -5.0                     0.948720   \n",
       "22865                            -6.0                    57.037623   \n",
       "23310                             3.0                    -0.705430   \n",
       "23311                             4.0                   -10.004211   \n",
       "23312                             5.0                   -43.126545   \n",
       "23313                             6.0                   -27.387994   \n",
       "23314                            -1.0                    -0.609757   \n",
       "\n",
       "       ('distance_2_before',)  ('num_of_ups_downs_2_before',)  \n",
       "9                    0.013434                            -1.0  \n",
       "10                   0.010233                            -2.0  \n",
       "11                   0.010298                             1.0  \n",
       "12                   0.011062                             2.0  \n",
       "13                   0.006293                            -1.0  \n",
       "24                   0.010233                            -2.0  \n",
       "25                   0.010298                             1.0  \n",
       "26                   0.011062                             2.0  \n",
       "27                   0.006293                            -1.0  \n",
       "28                   0.000931                            -2.0  \n",
       "41                   0.011062                             2.0  \n",
       "42                   0.006293                            -1.0  \n",
       "43                   0.000931                            -2.0  \n",
       "44                   0.000444                            -3.0  \n",
       "45                   0.001128                            -4.0  \n",
       "61                   0.000444                            -3.0  \n",
       "62                   0.001128                            -4.0  \n",
       "63                   0.000558                             1.0  \n",
       "64                   0.001195                            -1.0  \n",
       "65                   0.002547                            -2.0  \n",
       "82                   0.001128                            -4.0  \n",
       "83                   0.000558                             1.0  \n",
       "84                   0.001195                            -1.0  \n",
       "85                   0.002547                            -2.0  \n",
       "86                   0.002389                             1.0  \n",
       "104                  0.000558                             1.0  \n",
       "105                  0.001195                            -1.0  \n",
       "106                  0.002547                            -2.0  \n",
       "107                  0.002389                             1.0  \n",
       "108                  0.000647                             2.0  \n",
       "...                       ...                             ...  \n",
       "21163                4.867598                            -1.0  \n",
       "21164                4.160542                             1.0  \n",
       "21165                3.067684                             2.0  \n",
       "21166                2.232785                             3.0  \n",
       "21167                1.163454                             4.0  \n",
       "21572                3.750636                             1.0  \n",
       "21573                3.428942                            -1.0  \n",
       "21574                2.935238                            -2.0  \n",
       "21575                2.697363                            -3.0  \n",
       "21576                1.898084                            -4.0  \n",
       "21995                4.795113                            -1.0  \n",
       "21996                4.413275                             1.0  \n",
       "21997                4.280275                             2.0  \n",
       "21998                3.351453                             3.0  \n",
       "21999                2.308557                             4.0  \n",
       "22419                4.413275                             1.0  \n",
       "22420                4.280275                             2.0  \n",
       "22421                3.351453                             3.0  \n",
       "22422                2.308557                             4.0  \n",
       "22423                1.010436                             5.0  \n",
       "22861                4.066526                            -1.0  \n",
       "22862                3.513740                            -2.0  \n",
       "22863                2.675709                            -3.0  \n",
       "22864                2.650392                            -4.0  \n",
       "22865                1.557909                            -5.0  \n",
       "23310                0.918073                             2.0  \n",
       "23311                1.125953                             3.0  \n",
       "23312                3.796027                             4.0  \n",
       "23313                5.125682                             5.0  \n",
       "23314                5.144126                             6.0  \n",
       "\n",
       "[550 rows x 11 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby(\"symbol\").tail(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "15"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.finfo(np.float64).precision"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "nlp",
   "language": "python",
   "name": "nlp"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.15"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}