Produccion.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "684d0d24-cdd0-44d6-adb7-3b744dd92370",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Python version\n",
      "3.7.9 (tags/v3.7.9:13c94747c7, Aug 17 2020, 18:58:18) [MSC v.1900 64 bit (AMD64)]\n"
     ]
    }
   ],
   "source": [
    "%reset -f\n",
    "import sys\n",
    "print(\"Python version\")\n",
    "print(sys.version)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "5e8696e4-a0f6-40c9-b681-64b04505ddf2",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "pd.set_option(\"display.max_columns\", None)\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "7a940513-1bea-4974-a966-8ff329687303",
   "metadata": {},
   "outputs": [],
   "source": [
    "#Coingecko api\n",
    "from pycoingecko import CoinGeckoAPI\n",
    "cg = CoinGeckoAPI()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "fe70c753-2009-47a3-9287-8a28274b055b",
   "metadata": {},
   "outputs": [],
   "source": [
    "import time\n",
    "import datetime\n",
    "\n",
    "def edit_prices_dict(d): \n",
    "    df=pd.DataFrame(d)\n",
    "    #Saving dates\n",
    "    dates=df['prices'].map(lambda x: x[0])  \n",
    "    #Filtering the values without dates\n",
    "    df=df.applymap(lambda x: x[1])\n",
    "    df['dates']=dates \n",
    "    df[\"dates\"] = pd.to_datetime(df['dates'], unit='ms')\n",
    "    df.index = df[\"dates\"]\n",
    "    df=df[['prices','total_volumes']]\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "29a88c3d-a559-47be-988d-e02f0983bbd9",
   "metadata": {},
   "outputs": [],
   "source": [
    "#dd/mm/yyyy\n",
    "from_date = \"01/01/2021\"\n",
    "to_date = \"21/12/2021\"\n",
    "from_unix = time.mktime(datetime.datetime.strptime(from_date, \"%d/%m/%Y\").timetuple())\n",
    "to_unix = time.mktime(datetime.datetime.strptime(to_date, \"%d/%m/%Y\").timetuple())\n",
    "\n",
    "token = \"bitcoin\"; vs_currency = \"usd\"\n",
    "\n",
    "response=cg.get_coin_market_chart_range_by_id(id = token, vs_currency = vs_currency, from_timestamp = from_unix, to_timestamp = to_unix)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a00dba4b-9c6e-4349-8cc1-efca07389fcc",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(341, 2)\n"
     ]
    },
    {
     "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>prices</th>\n",
       "      <th>total_volumes</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dates</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-12-03</th>\n",
       "      <td>56508.268054</td>\n",
       "      <td>3.629634e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-04</th>\n",
       "      <td>53785.967172</td>\n",
       "      <td>3.952711e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-05</th>\n",
       "      <td>49161.990710</td>\n",
       "      <td>5.594141e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-06</th>\n",
       "      <td>49268.469891</td>\n",
       "      <td>3.282657e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-07</th>\n",
       "      <td>50461.576837</td>\n",
       "      <td>3.612602e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  prices  total_volumes\n",
       "dates                                  \n",
       "2021-12-03  56508.268054   3.629634e+10\n",
       "2021-12-04  53785.967172   3.952711e+10\n",
       "2021-12-05  49161.990710   5.594141e+10\n",
       "2021-12-06  49268.469891   3.282657e+10\n",
       "2021-12-07  50461.576837   3.612602e+10"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = edit_prices_dict(response)\n",
    "print(df.shape)\n",
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "603a28ef-a060-43ba-9070-f2b38d05c45f",
   "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>prices</th>\n",
       "      <th>total_volumes</th>\n",
       "      <th>y</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dates</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-12-03</th>\n",
       "      <td>56508.268054</td>\n",
       "      <td>3.629634e+10</td>\n",
       "      <td>53785.967172</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-04</th>\n",
       "      <td>53785.967172</td>\n",
       "      <td>3.952711e+10</td>\n",
       "      <td>49161.990710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-05</th>\n",
       "      <td>49161.990710</td>\n",
       "      <td>5.594141e+10</td>\n",
       "      <td>49268.469891</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-06</th>\n",
       "      <td>49268.469891</td>\n",
       "      <td>3.282657e+10</td>\n",
       "      <td>50461.576837</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-07</th>\n",
       "      <td>50461.576837</td>\n",
       "      <td>3.612602e+10</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  prices  total_volumes             y\n",
       "dates                                                \n",
       "2021-12-03  56508.268054   3.629634e+10  53785.967172\n",
       "2021-12-04  53785.967172   3.952711e+10  49161.990710\n",
       "2021-12-05  49161.990710   5.594141e+10  49268.469891\n",
       "2021-12-06  49268.469891   3.282657e+10  50461.576837\n",
       "2021-12-07  50461.576837   3.612602e+10           NaN"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Esto hay que hacerlo pues es con la info de hoy predecir mañana\n",
    "lag_days = 1\n",
    "df[\"y\"] = df[\"prices\"].shift(-1 * lag_days)\n",
    "df.tail(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "185cbb54-d360-421b-ab1a-87503376c0c5",
   "metadata": {},
   "outputs": [],
   "source": [
    "#https://towardsdatascience.com/building-a-comprehensive-set-of-technical-indicators-in-python-for-quantitative-trading-8d98751b5fb\n",
    "# MovingAverage\n",
    "values_ma = [5,15,30]\n",
    "\n",
    "for i in values_ma:\n",
    "    df[\"ma_close_\" + str(i)] = df[\"prices\"].rolling(window=i).mean()\n",
    "\n",
    "# ExponentialMovingWindow\n",
    "values_ema = [5,15,30]\n",
    "\n",
    "for i in values_ema:\n",
    "    df[\"ema_\" + str(i)] = df[\"prices\"].ewm(span = i, adjust = False).mean()\n",
    "    \n",
    "# RSI https://stackoverflow.com/questions/20526414/relative-strength-index-in-python-pandas\n",
    "values_rsi = [7,14,21]\n",
    "close = df['prices']\n",
    "\n",
    "# Get the difference in price from previous step\n",
    "delta = close.diff()\n",
    "\n",
    "# Make the positive gains (up) and negative gains (down) Series\n",
    "up, down = delta.copy(), delta.copy()\n",
    "up[up < 0] = 0\n",
    "down[down > 0] = 0\n",
    "\n",
    "for i in values_rsi:\n",
    "    # Calculate the EWMA\n",
    "    #roll_up1 = up.ewm(span=i).mean()\n",
    "    #roll_down1 = down.abs().ewm(span=i).mean()\n",
    "\n",
    "    ## Calculate the RSI based on EWMA\n",
    "    #RS1 = roll_up1 / roll_down1\n",
    "    #RSI1 = 100.0 - (100.0 / (1.0 + RS1))\n",
    "\n",
    "    # Calculate the SMA\n",
    "    roll_up2 = up.rolling(i).mean()\n",
    "    roll_down2 = down.abs().rolling(i).mean()\n",
    "\n",
    "    # Calculate the RSI based on SMA\n",
    "    RS2 = roll_up2 / roll_down2\n",
    "    RSI2 = 100.0 - (100.0 / (1.0 + RS2))\n",
    "    \n",
    "    #df[\"rsi_ewma_\" + str(i)] = RSI1.values\n",
    "    df[\"rsi_sma_\" + str(i)]  = RSI2.values\n",
    "    \n",
    "# BollingerBand\n",
    "values_bollinger = [5,10,20]\n",
    "for i in values_bollinger:\n",
    "    df['bollinger_upper_' + str(i)] = df['prices'].rolling(window=i).mean() + (df['prices'].rolling(window=i).std()  * 2)\n",
    "    df['bollinger_lower_' + str(i)] = df['prices'].rolling(window=i).mean() - (df['prices'].rolling(window=i).std()  * 2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "15c95295-b4e3-4dbd-9389-f228038e8007",
   "metadata": {},
   "outputs": [],
   "source": [
    "minus = 15 # Es el lag del pasado cuanto pillamos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "379b6362-845f-4026-8193-d350cab6a1b4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['prices', 'total_volumes', 'ma_close_5', 'ma_close_15', 'ma_close_30', 'ema_5', 'ema_15', 'ema_30', 'rsi_sma_7', 'rsi_sma_14', 'rsi_sma_21', 'bollinger_upper_5', 'bollinger_lower_5', 'bollinger_upper_10', 'bollinger_lower_10', 'bollinger_upper_20', 'bollinger_lower_20']\n"
     ]
    }
   ],
   "source": [
    "all_columns = list(df.columns)\n",
    "keep_columns = [item for item in all_columns if item not in \"y\"]\n",
    "print(keep_columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "b7604e5f-9992-4b6f-ae7e-fb37d47f49bf",
   "metadata": {},
   "outputs": [],
   "source": [
    "list_shift = list(range(1, minus))\n",
    "\n",
    "for i in list_shift:\n",
    "    for j in keep_columns:\n",
    "        df[str(j) + \"minus\" + str(i)] = df[str(j)].shift(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "3474fb80-7317-48a8-b6cb-b7ab1a058352",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shape: (341, 256)\n",
      "Shape: (297, 256)\n"
     ]
    }
   ],
   "source": [
    "print(\"Shape: \" + str(df.shape))\n",
    "df.dropna(inplace = True)\n",
    "print(\"Shape: \" + str(df.shape))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "8dafa425-6808-4dac-8c8d-01a4c8cee79d",
   "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>prices</th>\n",
       "      <th>total_volumes</th>\n",
       "      <th>y</th>\n",
       "      <th>ma_close_5</th>\n",
       "      <th>ma_close_15</th>\n",
       "      <th>ma_close_30</th>\n",
       "      <th>ema_5</th>\n",
       "      <th>ema_15</th>\n",
       "      <th>ema_30</th>\n",
       "      <th>rsi_sma_7</th>\n",
       "      <th>rsi_sma_14</th>\n",
       "      <th>rsi_sma_21</th>\n",
       "      <th>bollinger_upper_5</th>\n",
       "      <th>bollinger_lower_5</th>\n",
       "      <th>bollinger_upper_10</th>\n",
       "      <th>bollinger_lower_10</th>\n",
       "      <th>bollinger_upper_20</th>\n",
       "      <th>bollinger_lower_20</th>\n",
       "      <th>pricesminus1</th>\n",
       "      <th>total_volumesminus1</th>\n",
       "      <th>ma_close_5minus1</th>\n",
       "      <th>ma_close_15minus1</th>\n",
       "      <th>ma_close_30minus1</th>\n",
       "      <th>ema_5minus1</th>\n",
       "      <th>ema_15minus1</th>\n",
       "      <th>ema_30minus1</th>\n",
       "      <th>rsi_sma_7minus1</th>\n",
       "      <th>rsi_sma_14minus1</th>\n",
       "      <th>rsi_sma_21minus1</th>\n",
       "      <th>bollinger_upper_5minus1</th>\n",
       "      <th>bollinger_lower_5minus1</th>\n",
       "      <th>bollinger_upper_10minus1</th>\n",
       "      <th>bollinger_lower_10minus1</th>\n",
       "      <th>bollinger_upper_20minus1</th>\n",
       "      <th>bollinger_lower_20minus1</th>\n",
       "      <th>pricesminus2</th>\n",
       "      <th>total_volumesminus2</th>\n",
       "      <th>ma_close_5minus2</th>\n",
       "      <th>ma_close_15minus2</th>\n",
       "      <th>ma_close_30minus2</th>\n",
       "      <th>ema_5minus2</th>\n",
       "      <th>ema_15minus2</th>\n",
       "      <th>ema_30minus2</th>\n",
       "      <th>rsi_sma_7minus2</th>\n",
       "      <th>rsi_sma_14minus2</th>\n",
       "      <th>rsi_sma_21minus2</th>\n",
       "      <th>bollinger_upper_5minus2</th>\n",
       "      <th>bollinger_lower_5minus2</th>\n",
       "      <th>bollinger_upper_10minus2</th>\n",
       "      <th>bollinger_lower_10minus2</th>\n",
       "      <th>bollinger_upper_20minus2</th>\n",
       "      <th>bollinger_lower_20minus2</th>\n",
       "      <th>pricesminus3</th>\n",
       "      <th>total_volumesminus3</th>\n",
       "      <th>ma_close_5minus3</th>\n",
       "      <th>ma_close_15minus3</th>\n",
       "      <th>ma_close_30minus3</th>\n",
       "      <th>ema_5minus3</th>\n",
       "      <th>ema_15minus3</th>\n",
       "      <th>ema_30minus3</th>\n",
       "      <th>rsi_sma_7minus3</th>\n",
       "      <th>rsi_sma_14minus3</th>\n",
       "      <th>rsi_sma_21minus3</th>\n",
       "      <th>bollinger_upper_5minus3</th>\n",
       "      <th>bollinger_lower_5minus3</th>\n",
       "      <th>bollinger_upper_10minus3</th>\n",
       "      <th>bollinger_lower_10minus3</th>\n",
       "      <th>bollinger_upper_20minus3</th>\n",
       "      <th>bollinger_lower_20minus3</th>\n",
       "      <th>pricesminus4</th>\n",
       "      <th>total_volumesminus4</th>\n",
       "      <th>ma_close_5minus4</th>\n",
       "      <th>ma_close_15minus4</th>\n",
       "      <th>ma_close_30minus4</th>\n",
       "      <th>ema_5minus4</th>\n",
       "      <th>ema_15minus4</th>\n",
       "      <th>ema_30minus4</th>\n",
       "      <th>rsi_sma_7minus4</th>\n",
       "      <th>rsi_sma_14minus4</th>\n",
       "      <th>rsi_sma_21minus4</th>\n",
       "      <th>bollinger_upper_5minus4</th>\n",
       "      <th>bollinger_lower_5minus4</th>\n",
       "      <th>bollinger_upper_10minus4</th>\n",
       "      <th>bollinger_lower_10minus4</th>\n",
       "      <th>bollinger_upper_20minus4</th>\n",
       "      <th>bollinger_lower_20minus4</th>\n",
       "      <th>pricesminus5</th>\n",
       "      <th>total_volumesminus5</th>\n",
       "      <th>ma_close_5minus5</th>\n",
       "      <th>ma_close_15minus5</th>\n",
       "      <th>ma_close_30minus5</th>\n",
       "      <th>ema_5minus5</th>\n",
       "      <th>ema_15minus5</th>\n",
       "      <th>ema_30minus5</th>\n",
       "      <th>rsi_sma_7minus5</th>\n",
       "      <th>rsi_sma_14minus5</th>\n",
       "      <th>rsi_sma_21minus5</th>\n",
       "      <th>bollinger_upper_5minus5</th>\n",
       "      <th>bollinger_lower_5minus5</th>\n",
       "      <th>bollinger_upper_10minus5</th>\n",
       "      <th>bollinger_lower_10minus5</th>\n",
       "      <th>bollinger_upper_20minus5</th>\n",
       "      <th>bollinger_lower_20minus5</th>\n",
       "      <th>pricesminus6</th>\n",
       "      <th>total_volumesminus6</th>\n",
       "      <th>ma_close_5minus6</th>\n",
       "      <th>ma_close_15minus6</th>\n",
       "      <th>ma_close_30minus6</th>\n",
       "      <th>ema_5minus6</th>\n",
       "      <th>ema_15minus6</th>\n",
       "      <th>ema_30minus6</th>\n",
       "      <th>rsi_sma_7minus6</th>\n",
       "      <th>rsi_sma_14minus6</th>\n",
       "      <th>rsi_sma_21minus6</th>\n",
       "      <th>bollinger_upper_5minus6</th>\n",
       "      <th>bollinger_lower_5minus6</th>\n",
       "      <th>bollinger_upper_10minus6</th>\n",
       "      <th>bollinger_lower_10minus6</th>\n",
       "      <th>bollinger_upper_20minus6</th>\n",
       "      <th>bollinger_lower_20minus6</th>\n",
       "      <th>pricesminus7</th>\n",
       "      <th>total_volumesminus7</th>\n",
       "      <th>ma_close_5minus7</th>\n",
       "      <th>ma_close_15minus7</th>\n",
       "      <th>ma_close_30minus7</th>\n",
       "      <th>ema_5minus7</th>\n",
       "      <th>ema_15minus7</th>\n",
       "      <th>ema_30minus7</th>\n",
       "      <th>rsi_sma_7minus7</th>\n",
       "      <th>rsi_sma_14minus7</th>\n",
       "      <th>rsi_sma_21minus7</th>\n",
       "      <th>bollinger_upper_5minus7</th>\n",
       "      <th>bollinger_lower_5minus7</th>\n",
       "      <th>bollinger_upper_10minus7</th>\n",
       "      <th>bollinger_lower_10minus7</th>\n",
       "      <th>bollinger_upper_20minus7</th>\n",
       "      <th>bollinger_lower_20minus7</th>\n",
       "      <th>pricesminus8</th>\n",
       "      <th>total_volumesminus8</th>\n",
       "      <th>ma_close_5minus8</th>\n",
       "      <th>ma_close_15minus8</th>\n",
       "      <th>ma_close_30minus8</th>\n",
       "      <th>ema_5minus8</th>\n",
       "      <th>ema_15minus8</th>\n",
       "      <th>ema_30minus8</th>\n",
       "      <th>rsi_sma_7minus8</th>\n",
       "      <th>rsi_sma_14minus8</th>\n",
       "      <th>rsi_sma_21minus8</th>\n",
       "      <th>bollinger_upper_5minus8</th>\n",
       "      <th>bollinger_lower_5minus8</th>\n",
       "      <th>bollinger_upper_10minus8</th>\n",
       "      <th>bollinger_lower_10minus8</th>\n",
       "      <th>bollinger_upper_20minus8</th>\n",
       "      <th>bollinger_lower_20minus8</th>\n",
       "      <th>pricesminus9</th>\n",
       "      <th>total_volumesminus9</th>\n",
       "      <th>ma_close_5minus9</th>\n",
       "      <th>ma_close_15minus9</th>\n",
       "      <th>ma_close_30minus9</th>\n",
       "      <th>ema_5minus9</th>\n",
       "      <th>ema_15minus9</th>\n",
       "      <th>ema_30minus9</th>\n",
       "      <th>rsi_sma_7minus9</th>\n",
       "      <th>rsi_sma_14minus9</th>\n",
       "      <th>rsi_sma_21minus9</th>\n",
       "      <th>bollinger_upper_5minus9</th>\n",
       "      <th>bollinger_lower_5minus9</th>\n",
       "      <th>bollinger_upper_10minus9</th>\n",
       "      <th>bollinger_lower_10minus9</th>\n",
       "      <th>bollinger_upper_20minus9</th>\n",
       "      <th>bollinger_lower_20minus9</th>\n",
       "      <th>pricesminus10</th>\n",
       "      <th>total_volumesminus10</th>\n",
       "      <th>ma_close_5minus10</th>\n",
       "      <th>ma_close_15minus10</th>\n",
       "      <th>ma_close_30minus10</th>\n",
       "      <th>ema_5minus10</th>\n",
       "      <th>ema_15minus10</th>\n",
       "      <th>ema_30minus10</th>\n",
       "      <th>rsi_sma_7minus10</th>\n",
       "      <th>rsi_sma_14minus10</th>\n",
       "      <th>rsi_sma_21minus10</th>\n",
       "      <th>bollinger_upper_5minus10</th>\n",
       "      <th>bollinger_lower_5minus10</th>\n",
       "      <th>bollinger_upper_10minus10</th>\n",
       "      <th>bollinger_lower_10minus10</th>\n",
       "      <th>bollinger_upper_20minus10</th>\n",
       "      <th>bollinger_lower_20minus10</th>\n",
       "      <th>pricesminus11</th>\n",
       "      <th>total_volumesminus11</th>\n",
       "      <th>ma_close_5minus11</th>\n",
       "      <th>ma_close_15minus11</th>\n",
       "      <th>ma_close_30minus11</th>\n",
       "      <th>ema_5minus11</th>\n",
       "      <th>ema_15minus11</th>\n",
       "      <th>ema_30minus11</th>\n",
       "      <th>rsi_sma_7minus11</th>\n",
       "      <th>rsi_sma_14minus11</th>\n",
       "      <th>rsi_sma_21minus11</th>\n",
       "      <th>bollinger_upper_5minus11</th>\n",
       "      <th>bollinger_lower_5minus11</th>\n",
       "      <th>bollinger_upper_10minus11</th>\n",
       "      <th>bollinger_lower_10minus11</th>\n",
       "      <th>bollinger_upper_20minus11</th>\n",
       "      <th>bollinger_lower_20minus11</th>\n",
       "      <th>pricesminus12</th>\n",
       "      <th>total_volumesminus12</th>\n",
       "      <th>ma_close_5minus12</th>\n",
       "      <th>ma_close_15minus12</th>\n",
       "      <th>ma_close_30minus12</th>\n",
       "      <th>ema_5minus12</th>\n",
       "      <th>ema_15minus12</th>\n",
       "      <th>ema_30minus12</th>\n",
       "      <th>rsi_sma_7minus12</th>\n",
       "      <th>rsi_sma_14minus12</th>\n",
       "      <th>rsi_sma_21minus12</th>\n",
       "      <th>bollinger_upper_5minus12</th>\n",
       "      <th>bollinger_lower_5minus12</th>\n",
       "      <th>bollinger_upper_10minus12</th>\n",
       "      <th>bollinger_lower_10minus12</th>\n",
       "      <th>bollinger_upper_20minus12</th>\n",
       "      <th>bollinger_lower_20minus12</th>\n",
       "      <th>pricesminus13</th>\n",
       "      <th>total_volumesminus13</th>\n",
       "      <th>ma_close_5minus13</th>\n",
       "      <th>ma_close_15minus13</th>\n",
       "      <th>ma_close_30minus13</th>\n",
       "      <th>ema_5minus13</th>\n",
       "      <th>ema_15minus13</th>\n",
       "      <th>ema_30minus13</th>\n",
       "      <th>rsi_sma_7minus13</th>\n",
       "      <th>rsi_sma_14minus13</th>\n",
       "      <th>rsi_sma_21minus13</th>\n",
       "      <th>bollinger_upper_5minus13</th>\n",
       "      <th>bollinger_lower_5minus13</th>\n",
       "      <th>bollinger_upper_10minus13</th>\n",
       "      <th>bollinger_lower_10minus13</th>\n",
       "      <th>bollinger_upper_20minus13</th>\n",
       "      <th>bollinger_lower_20minus13</th>\n",
       "      <th>pricesminus14</th>\n",
       "      <th>total_volumesminus14</th>\n",
       "      <th>ma_close_5minus14</th>\n",
       "      <th>ma_close_15minus14</th>\n",
       "      <th>ma_close_30minus14</th>\n",
       "      <th>ema_5minus14</th>\n",
       "      <th>ema_15minus14</th>\n",
       "      <th>ema_30minus14</th>\n",
       "      <th>rsi_sma_7minus14</th>\n",
       "      <th>rsi_sma_14minus14</th>\n",
       "      <th>rsi_sma_21minus14</th>\n",
       "      <th>bollinger_upper_5minus14</th>\n",
       "      <th>bollinger_lower_5minus14</th>\n",
       "      <th>bollinger_upper_10minus14</th>\n",
       "      <th>bollinger_lower_10minus14</th>\n",
       "      <th>bollinger_upper_20minus14</th>\n",
       "      <th>bollinger_lower_20minus14</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dates</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-12-05</th>\n",
       "      <td>49161.990710</td>\n",
       "      <td>5.594141e+10</td>\n",
       "      <td>49268.469891</td>\n",
       "      <td>54727.375681</td>\n",
       "      <td>56435.925442</td>\n",
       "      <td>59753.464608</td>\n",
       "      <td>53605.222889</td>\n",
       "      <td>56297.338312</td>\n",
       "      <td>57905.964223</td>\n",
       "      <td>28.197488</td>\n",
       "      <td>28.504040</td>\n",
       "      <td>29.850475</td>\n",
       "      <td>61525.235977</td>\n",
       "      <td>47929.515385</td>\n",
       "      <td>61290.776455</td>\n",
       "      <td>49905.694907</td>\n",
       "      <td>63509.165535</td>\n",
       "      <td>51187.985795</td>\n",
       "      <td>53785.967172</td>\n",
       "      <td>3.952711e+10</td>\n",
       "      <td>56464.732246</td>\n",
       "      <td>57055.743096</td>\n",
       "      <td>60168.123037</td>\n",
       "      <td>55826.838978</td>\n",
       "      <td>57316.673683</td>\n",
       "      <td>58508.996879</td>\n",
       "      <td>49.751037</td>\n",
       "      <td>39.569458</td>\n",
       "      <td>34.372794</td>\n",
       "      <td>59609.327629</td>\n",
       "      <td>53320.136863</td>\n",
       "      <td>59903.463566</td>\n",
       "      <td>52900.246423</td>\n",
       "      <td>64129.992223</td>\n",
       "      <td>52215.857816</td>\n",
       "      <td>56508.268054</td>\n",
       "      <td>3.629634e+10</td>\n",
       "      <td>57155.071039</td>\n",
       "      <td>57269.166774</td>\n",
       "      <td>60479.622210</td>\n",
       "      <td>56847.274881</td>\n",
       "      <td>57821.060328</td>\n",
       "      <td>58834.723066</td>\n",
       "      <td>38.883325</td>\n",
       "      <td>48.867568</td>\n",
       "      <td>36.687047</td>\n",
       "      <td>58118.024115</td>\n",
       "      <td>56192.117964</td>\n",
       "      <td>59852.374375</td>\n",
       "      <td>53743.900815</td>\n",
       "      <td>64965.686899</td>\n",
       "      <td>52467.599958</td>\n",
       "      <td>57169.371994</td>\n",
       "      <td>4.938307e+10</td>\n",
       "      <td>56760.098205</td>\n",
       "      <td>57542.192628</td>\n",
       "      <td>60704.253573</td>\n",
       "      <td>57016.778295</td>\n",
       "      <td>58008.602081</td>\n",
       "      <td>58995.168239</td>\n",
       "      <td>49.877774</td>\n",
       "      <td>42.876941</td>\n",
       "      <td>37.396801</td>\n",
       "      <td>59329.542796</td>\n",
       "      <td>54190.653614</td>\n",
       "      <td>59846.313715</td>\n",
       "      <td>53725.679234</td>\n",
       "      <td>65764.143304</td>\n",
       "      <td>52461.521542</td>\n",
       "      <td>57011.280474</td>\n",
       "      <td>3.572304e+10</td>\n",
       "      <td>56091.782379</td>\n",
       "      <td>57760.805329</td>\n",
       "      <td>60836.002213</td>\n",
       "      <td>56940.481446</td>\n",
       "      <td>58128.492094</td>\n",
       "      <td>59121.085222</td>\n",
       "      <td>46.972146</td>\n",
       "      <td>42.869836</td>\n",
       "      <td>34.753644</td>\n",
       "      <td>59669.452691</td>\n",
       "      <td>52514.112067</td>\n",
       "      <td>60387.448383</td>\n",
       "      <td>53578.626023</td>\n",
       "      <td>66583.414079</td>\n",
       "      <td>52425.878084</td>\n",
       "      <td>57848.773537</td>\n",
       "      <td>3.098520e+10</td>\n",
       "      <td>56469.095681</td>\n",
       "      <td>58222.308994</td>\n",
       "      <td>60984.688480</td>\n",
       "      <td>56905.081931</td>\n",
       "      <td>58288.093754</td>\n",
       "      <td>59266.588997</td>\n",
       "      <td>55.754108</td>\n",
       "      <td>38.626727</td>\n",
       "      <td>35.140478</td>\n",
       "      <td>60841.328525</td>\n",
       "      <td>52096.862837</td>\n",
       "      <td>61219.716382</td>\n",
       "      <td>53360.684263</td>\n",
       "      <td>67297.518304</td>\n",
       "      <td>52516.751253</td>\n",
       "      <td>57237.661137</td>\n",
       "      <td>2.765946e+10</td>\n",
       "      <td>56338.977743</td>\n",
       "      <td>58742.322611</td>\n",
       "      <td>61117.637929</td>\n",
       "      <td>56433.236129</td>\n",
       "      <td>58350.853784</td>\n",
       "      <td>59364.369374</td>\n",
       "      <td>43.593428</td>\n",
       "      <td>34.901938</td>\n",
       "      <td>41.945316</td>\n",
       "      <td>60541.337225</td>\n",
       "      <td>52136.618261</td>\n",
       "      <td>61337.886437</td>\n",
       "      <td>53364.610604</td>\n",
       "      <td>68362.331822</td>\n",
       "      <td>52381.597874</td>\n",
       "      <td>54533.403882</td>\n",
       "      <td>2.825685e+10</td>\n",
       "      <td>56441.204150</td>\n",
       "      <td>59237.167558</td>\n",
       "      <td>61285.822492</td>\n",
       "      <td>56031.023624</td>\n",
       "      <td>58509.881305</td>\n",
       "      <td>59511.038907</td>\n",
       "      <td>28.792655</td>\n",
       "      <td>30.629437</td>\n",
       "      <td>39.963147</td>\n",
       "      <td>60775.661640</td>\n",
       "      <td>52106.746660</td>\n",
       "      <td>61319.161614</td>\n",
       "      <td>53333.267667</td>\n",
       "      <td>69358.190632</td>\n",
       "      <td>52423.674505</td>\n",
       "      <td>53827.792865</td>\n",
       "      <td>4.132581e+10</td>\n",
       "      <td>56811.894744</td>\n",
       "      <td>59897.077163</td>\n",
       "      <td>61493.627558</td>\n",
       "      <td>56779.833495</td>\n",
       "      <td>59077.949509</td>\n",
       "      <td>59854.324081</td>\n",
       "      <td>33.461394</td>\n",
       "      <td>29.339150</td>\n",
       "      <td>39.465977</td>\n",
       "      <td>60615.013979</td>\n",
       "      <td>53008.775509</td>\n",
       "      <td>61884.621628</td>\n",
       "      <td>53981.858050</td>\n",
       "      <td>69289.402915</td>\n",
       "      <td>53354.444853</td>\n",
       "      <td>58897.846983</td>\n",
       "      <td>3.372110e+10</td>\n",
       "      <td>57874.292027</td>\n",
       "      <td>60642.267316</td>\n",
       "      <td>61654.067845</td>\n",
       "      <td>58255.853810</td>\n",
       "      <td>59827.971886</td>\n",
       "      <td>60269.946924</td>\n",
       "      <td>59.181813</td>\n",
       "      <td>35.571827</td>\n",
       "      <td>45.567613</td>\n",
       "      <td>60183.936668</td>\n",
       "      <td>55564.647387</td>\n",
       "      <td>61593.011089</td>\n",
       "      <td>55597.622519</td>\n",
       "      <td>68857.512479</td>\n",
       "      <td>54569.691869</td>\n",
       "      <td>57198.183846</td>\n",
       "      <td>3.169537e+10</td>\n",
       "      <td>58111.304964</td>\n",
       "      <td>61053.147810</td>\n",
       "      <td>61710.945909</td>\n",
       "      <td>57934.857224</td>\n",
       "      <td>59960.846873</td>\n",
       "      <td>60364.574506</td>\n",
       "      <td>36.179678</td>\n",
       "      <td>29.861481</td>\n",
       "      <td>40.220013</td>\n",
       "      <td>61091.895288</td>\n",
       "      <td>55130.714641</td>\n",
       "      <td>63624.940326</td>\n",
       "      <td>54572.890974</td>\n",
       "      <td>68856.315886</td>\n",
       "      <td>54805.842258</td>\n",
       "      <td>57748.793174</td>\n",
       "      <td>3.642119e+10</td>\n",
       "      <td>58363.519298</td>\n",
       "      <td>61716.293883</td>\n",
       "      <td>61911.946908</td>\n",
       "      <td>58303.193913</td>\n",
       "      <td>60355.513019</td>\n",
       "      <td>60582.946276</td>\n",
       "      <td>38.680219</td>\n",
       "      <td>27.686349</td>\n",
       "      <td>40.804333</td>\n",
       "      <td>61165.864340</td>\n",
       "      <td>55561.174256</td>\n",
       "      <td>65840.885540</td>\n",
       "      <td>54047.104549</td>\n",
       "      <td>68732.741026</td>\n",
       "      <td>55369.773090</td>\n",
       "      <td>56386.856853</td>\n",
       "      <td>3.400147e+10</td>\n",
       "      <td>58211.225131</td>\n",
       "      <td>62374.175374</td>\n",
       "      <td>62026.092682</td>\n",
       "      <td>58580.394282</td>\n",
       "      <td>60727.901569</td>\n",
       "      <td>60778.405110</td>\n",
       "      <td>23.139259</td>\n",
       "      <td>22.154860</td>\n",
       "      <td>42.278309</td>\n",
       "      <td>61253.132433</td>\n",
       "      <td>55169.317830</td>\n",
       "      <td>66990.828351</td>\n",
       "      <td>54279.470173</td>\n",
       "      <td>68698.893162</td>\n",
       "      <td>55941.835872</td>\n",
       "      <td>59139.779280</td>\n",
       "      <td>2.574343e+10</td>\n",
       "      <td>59054.584934</td>\n",
       "      <td>62825.266930</td>\n",
       "      <td>62198.935468</td>\n",
       "      <td>59677.162996</td>\n",
       "      <td>61348.050814</td>\n",
       "      <td>61081.270507</td>\n",
       "      <td>24.984948</td>\n",
       "      <td>40.826921</td>\n",
       "      <td>45.873479</td>\n",
       "      <td>61899.286405</td>\n",
       "      <td>56209.883463</td>\n",
       "      <td>67431.660020</td>\n",
       "      <td>55447.676724</td>\n",
       "      <td>68404.389504</td>\n",
       "      <td>56922.374741</td>\n",
       "      <td>60082.911668</td>\n",
       "      <td>2.967655e+10</td>\n",
       "      <td>59316.341581</td>\n",
       "      <td>62993.372223</td>\n",
       "      <td>62261.918523</td>\n",
       "      <td>59945.854855</td>\n",
       "      <td>61663.518176</td>\n",
       "      <td>61215.166454</td>\n",
       "      <td>32.470137</td>\n",
       "      <td>46.480606</td>\n",
       "      <td>46.830976</td>\n",
       "      <td>62428.520747</td>\n",
       "      <td>56204.162415</td>\n",
       "      <td>68164.288708</td>\n",
       "      <td>55888.221212</td>\n",
       "      <td>68312.642859</td>\n",
       "      <td>57212.326578</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-12-06</th>\n",
       "      <td>49268.469891</td>\n",
       "      <td>3.282657e+10</td>\n",
       "      <td>50461.576837</td>\n",
       "      <td>53178.813564</td>\n",
       "      <td>55714.962657</td>\n",
       "      <td>59354.167440</td>\n",
       "      <td>52159.638556</td>\n",
       "      <td>55418.729759</td>\n",
       "      <td>57348.706524</td>\n",
       "      <td>9.008569</td>\n",
       "      <td>29.908276</td>\n",
       "      <td>28.203599</td>\n",
       "      <td>60847.197538</td>\n",
       "      <td>45510.429590</td>\n",
       "      <td>61058.080544</td>\n",
       "      <td>48212.515399</td>\n",
       "      <td>62963.866056</td>\n",
       "      <td>50266.748720</td>\n",
       "      <td>49161.990710</td>\n",
       "      <td>5.594141e+10</td>\n",
       "      <td>54727.375681</td>\n",
       "      <td>56435.925442</td>\n",
       "      <td>59753.464608</td>\n",
       "      <td>53605.222889</td>\n",
       "      <td>56297.338312</td>\n",
       "      <td>57905.964223</td>\n",
       "      <td>28.197488</td>\n",
       "      <td>28.504040</td>\n",
       "      <td>29.850475</td>\n",
       "      <td>61525.235977</td>\n",
       "      <td>47929.515385</td>\n",
       "      <td>61290.776455</td>\n",
       "      <td>49905.694907</td>\n",
       "      <td>63509.165535</td>\n",
       "      <td>51187.985795</td>\n",
       "      <td>53785.967172</td>\n",
       "      <td>3.952711e+10</td>\n",
       "      <td>56464.732246</td>\n",
       "      <td>57055.743096</td>\n",
       "      <td>60168.123037</td>\n",
       "      <td>55826.838978</td>\n",
       "      <td>57316.673683</td>\n",
       "      <td>58508.996879</td>\n",
       "      <td>49.751037</td>\n",
       "      <td>39.569458</td>\n",
       "      <td>34.372794</td>\n",
       "      <td>59609.327629</td>\n",
       "      <td>53320.136863</td>\n",
       "      <td>59903.463566</td>\n",
       "      <td>52900.246423</td>\n",
       "      <td>64129.992223</td>\n",
       "      <td>52215.857816</td>\n",
       "      <td>56508.268054</td>\n",
       "      <td>3.629634e+10</td>\n",
       "      <td>57155.071039</td>\n",
       "      <td>57269.166774</td>\n",
       "      <td>60479.622210</td>\n",
       "      <td>56847.274881</td>\n",
       "      <td>57821.060328</td>\n",
       "      <td>58834.723066</td>\n",
       "      <td>38.883325</td>\n",
       "      <td>48.867568</td>\n",
       "      <td>36.687047</td>\n",
       "      <td>58118.024115</td>\n",
       "      <td>56192.117964</td>\n",
       "      <td>59852.374375</td>\n",
       "      <td>53743.900815</td>\n",
       "      <td>64965.686899</td>\n",
       "      <td>52467.599958</td>\n",
       "      <td>57169.371994</td>\n",
       "      <td>4.938307e+10</td>\n",
       "      <td>56760.098205</td>\n",
       "      <td>57542.192628</td>\n",
       "      <td>60704.253573</td>\n",
       "      <td>57016.778295</td>\n",
       "      <td>58008.602081</td>\n",
       "      <td>58995.168239</td>\n",
       "      <td>49.877774</td>\n",
       "      <td>42.876941</td>\n",
       "      <td>37.396801</td>\n",
       "      <td>59329.542796</td>\n",
       "      <td>54190.653614</td>\n",
       "      <td>59846.313715</td>\n",
       "      <td>53725.679234</td>\n",
       "      <td>65764.143304</td>\n",
       "      <td>52461.521542</td>\n",
       "      <td>57011.280474</td>\n",
       "      <td>3.572304e+10</td>\n",
       "      <td>56091.782379</td>\n",
       "      <td>57760.805329</td>\n",
       "      <td>60836.002213</td>\n",
       "      <td>56940.481446</td>\n",
       "      <td>58128.492094</td>\n",
       "      <td>59121.085222</td>\n",
       "      <td>46.972146</td>\n",
       "      <td>42.869836</td>\n",
       "      <td>34.753644</td>\n",
       "      <td>59669.452691</td>\n",
       "      <td>52514.112067</td>\n",
       "      <td>60387.448383</td>\n",
       "      <td>53578.626023</td>\n",
       "      <td>66583.414079</td>\n",
       "      <td>52425.878084</td>\n",
       "      <td>57848.773537</td>\n",
       "      <td>3.098520e+10</td>\n",
       "      <td>56469.095681</td>\n",
       "      <td>58222.308994</td>\n",
       "      <td>60984.688480</td>\n",
       "      <td>56905.081931</td>\n",
       "      <td>58288.093754</td>\n",
       "      <td>59266.588997</td>\n",
       "      <td>55.754108</td>\n",
       "      <td>38.626727</td>\n",
       "      <td>35.140478</td>\n",
       "      <td>60841.328525</td>\n",
       "      <td>52096.862837</td>\n",
       "      <td>61219.716382</td>\n",
       "      <td>53360.684263</td>\n",
       "      <td>67297.518304</td>\n",
       "      <td>52516.751253</td>\n",
       "      <td>57237.661137</td>\n",
       "      <td>2.765946e+10</td>\n",
       "      <td>56338.977743</td>\n",
       "      <td>58742.322611</td>\n",
       "      <td>61117.637929</td>\n",
       "      <td>56433.236129</td>\n",
       "      <td>58350.853784</td>\n",
       "      <td>59364.369374</td>\n",
       "      <td>43.593428</td>\n",
       "      <td>34.901938</td>\n",
       "      <td>41.945316</td>\n",
       "      <td>60541.337225</td>\n",
       "      <td>52136.618261</td>\n",
       "      <td>61337.886437</td>\n",
       "      <td>53364.610604</td>\n",
       "      <td>68362.331822</td>\n",
       "      <td>52381.597874</td>\n",
       "      <td>54533.403882</td>\n",
       "      <td>2.825685e+10</td>\n",
       "      <td>56441.204150</td>\n",
       "      <td>59237.167558</td>\n",
       "      <td>61285.822492</td>\n",
       "      <td>56031.023624</td>\n",
       "      <td>58509.881305</td>\n",
       "      <td>59511.038907</td>\n",
       "      <td>28.792655</td>\n",
       "      <td>30.629437</td>\n",
       "      <td>39.963147</td>\n",
       "      <td>60775.661640</td>\n",
       "      <td>52106.746660</td>\n",
       "      <td>61319.161614</td>\n",
       "      <td>53333.267667</td>\n",
       "      <td>69358.190632</td>\n",
       "      <td>52423.674505</td>\n",
       "      <td>53827.792865</td>\n",
       "      <td>4.132581e+10</td>\n",
       "      <td>56811.894744</td>\n",
       "      <td>59897.077163</td>\n",
       "      <td>61493.627558</td>\n",
       "      <td>56779.833495</td>\n",
       "      <td>59077.949509</td>\n",
       "      <td>59854.324081</td>\n",
       "      <td>33.461394</td>\n",
       "      <td>29.339150</td>\n",
       "      <td>39.465977</td>\n",
       "      <td>60615.013979</td>\n",
       "      <td>53008.775509</td>\n",
       "      <td>61884.621628</td>\n",
       "      <td>53981.858050</td>\n",
       "      <td>69289.402915</td>\n",
       "      <td>53354.444853</td>\n",
       "      <td>58897.846983</td>\n",
       "      <td>3.372110e+10</td>\n",
       "      <td>57874.292027</td>\n",
       "      <td>60642.267316</td>\n",
       "      <td>61654.067845</td>\n",
       "      <td>58255.853810</td>\n",
       "      <td>59827.971886</td>\n",
       "      <td>60269.946924</td>\n",
       "      <td>59.181813</td>\n",
       "      <td>35.571827</td>\n",
       "      <td>45.567613</td>\n",
       "      <td>60183.936668</td>\n",
       "      <td>55564.647387</td>\n",
       "      <td>61593.011089</td>\n",
       "      <td>55597.622519</td>\n",
       "      <td>68857.512479</td>\n",
       "      <td>54569.691869</td>\n",
       "      <td>57198.183846</td>\n",
       "      <td>3.169537e+10</td>\n",
       "      <td>58111.304964</td>\n",
       "      <td>61053.147810</td>\n",
       "      <td>61710.945909</td>\n",
       "      <td>57934.857224</td>\n",
       "      <td>59960.846873</td>\n",
       "      <td>60364.574506</td>\n",
       "      <td>36.179678</td>\n",
       "      <td>29.861481</td>\n",
       "      <td>40.220013</td>\n",
       "      <td>61091.895288</td>\n",
       "      <td>55130.714641</td>\n",
       "      <td>63624.940326</td>\n",
       "      <td>54572.890974</td>\n",
       "      <td>68856.315886</td>\n",
       "      <td>54805.842258</td>\n",
       "      <td>57748.793174</td>\n",
       "      <td>3.642119e+10</td>\n",
       "      <td>58363.519298</td>\n",
       "      <td>61716.293883</td>\n",
       "      <td>61911.946908</td>\n",
       "      <td>58303.193913</td>\n",
       "      <td>60355.513019</td>\n",
       "      <td>60582.946276</td>\n",
       "      <td>38.680219</td>\n",
       "      <td>27.686349</td>\n",
       "      <td>40.804333</td>\n",
       "      <td>61165.864340</td>\n",
       "      <td>55561.174256</td>\n",
       "      <td>65840.885540</td>\n",
       "      <td>54047.104549</td>\n",
       "      <td>68732.741026</td>\n",
       "      <td>55369.773090</td>\n",
       "      <td>56386.856853</td>\n",
       "      <td>3.400147e+10</td>\n",
       "      <td>58211.225131</td>\n",
       "      <td>62374.175374</td>\n",
       "      <td>62026.092682</td>\n",
       "      <td>58580.394282</td>\n",
       "      <td>60727.901569</td>\n",
       "      <td>60778.405110</td>\n",
       "      <td>23.139259</td>\n",
       "      <td>22.154860</td>\n",
       "      <td>42.278309</td>\n",
       "      <td>61253.132433</td>\n",
       "      <td>55169.317830</td>\n",
       "      <td>66990.828351</td>\n",
       "      <td>54279.470173</td>\n",
       "      <td>68698.893162</td>\n",
       "      <td>55941.835872</td>\n",
       "      <td>59139.779280</td>\n",
       "      <td>2.574343e+10</td>\n",
       "      <td>59054.584934</td>\n",
       "      <td>62825.266930</td>\n",
       "      <td>62198.935468</td>\n",
       "      <td>59677.162996</td>\n",
       "      <td>61348.050814</td>\n",
       "      <td>61081.270507</td>\n",
       "      <td>24.984948</td>\n",
       "      <td>40.826921</td>\n",
       "      <td>45.873479</td>\n",
       "      <td>61899.286405</td>\n",
       "      <td>56209.883463</td>\n",
       "      <td>67431.660020</td>\n",
       "      <td>55447.676724</td>\n",
       "      <td>68404.389504</td>\n",
       "      <td>56922.374741</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  prices  total_volumes             y    ma_close_5  \\\n",
       "dates                                                                 \n",
       "2021-12-05  49161.990710   5.594141e+10  49268.469891  54727.375681   \n",
       "2021-12-06  49268.469891   3.282657e+10  50461.576837  53178.813564   \n",
       "\n",
       "             ma_close_15   ma_close_30         ema_5        ema_15  \\\n",
       "dates                                                                \n",
       "2021-12-05  56435.925442  59753.464608  53605.222889  56297.338312   \n",
       "2021-12-06  55714.962657  59354.167440  52159.638556  55418.729759   \n",
       "\n",
       "                  ema_30  rsi_sma_7  rsi_sma_14  rsi_sma_21  \\\n",
       "dates                                                         \n",
       "2021-12-05  57905.964223  28.197488   28.504040   29.850475   \n",
       "2021-12-06  57348.706524   9.008569   29.908276   28.203599   \n",
       "\n",
       "            bollinger_upper_5  bollinger_lower_5  bollinger_upper_10  \\\n",
       "dates                                                                  \n",
       "2021-12-05       61525.235977       47929.515385        61290.776455   \n",
       "2021-12-06       60847.197538       45510.429590        61058.080544   \n",
       "\n",
       "            bollinger_lower_10  bollinger_upper_20  bollinger_lower_20  \\\n",
       "dates                                                                    \n",
       "2021-12-05        49905.694907        63509.165535        51187.985795   \n",
       "2021-12-06        48212.515399        62963.866056        50266.748720   \n",
       "\n",
       "            pricesminus1  total_volumesminus1  ma_close_5minus1  \\\n",
       "dates                                                             \n",
       "2021-12-05  53785.967172         3.952711e+10      56464.732246   \n",
       "2021-12-06  49161.990710         5.594141e+10      54727.375681   \n",
       "\n",
       "            ma_close_15minus1  ma_close_30minus1   ema_5minus1  ema_15minus1  \\\n",
       "dates                                                                          \n",
       "2021-12-05       57055.743096       60168.123037  55826.838978  57316.673683   \n",
       "2021-12-06       56435.925442       59753.464608  53605.222889  56297.338312   \n",
       "\n",
       "            ema_30minus1  rsi_sma_7minus1  rsi_sma_14minus1  rsi_sma_21minus1  \\\n",
       "dates                                                                           \n",
       "2021-12-05  58508.996879        49.751037         39.569458         34.372794   \n",
       "2021-12-06  57905.964223        28.197488         28.504040         29.850475   \n",
       "\n",
       "            bollinger_upper_5minus1  bollinger_lower_5minus1  \\\n",
       "dates                                                          \n",
       "2021-12-05             59609.327629             53320.136863   \n",
       "2021-12-06             61525.235977             47929.515385   \n",
       "\n",
       "            bollinger_upper_10minus1  bollinger_lower_10minus1  \\\n",
       "dates                                                            \n",
       "2021-12-05              59903.463566              52900.246423   \n",
       "2021-12-06              61290.776455              49905.694907   \n",
       "\n",
       "            bollinger_upper_20minus1  bollinger_lower_20minus1  pricesminus2  \\\n",
       "dates                                                                          \n",
       "2021-12-05              64129.992223              52215.857816  56508.268054   \n",
       "2021-12-06              63509.165535              51187.985795  53785.967172   \n",
       "\n",
       "            total_volumesminus2  ma_close_5minus2  ma_close_15minus2  \\\n",
       "dates                                                                  \n",
       "2021-12-05         3.629634e+10      57155.071039       57269.166774   \n",
       "2021-12-06         3.952711e+10      56464.732246       57055.743096   \n",
       "\n",
       "            ma_close_30minus2   ema_5minus2  ema_15minus2  ema_30minus2  \\\n",
       "dates                                                                     \n",
       "2021-12-05       60479.622210  56847.274881  57821.060328  58834.723066   \n",
       "2021-12-06       60168.123037  55826.838978  57316.673683  58508.996879   \n",
       "\n",
       "            rsi_sma_7minus2  rsi_sma_14minus2  rsi_sma_21minus2  \\\n",
       "dates                                                             \n",
       "2021-12-05        38.883325         48.867568         36.687047   \n",
       "2021-12-06        49.751037         39.569458         34.372794   \n",
       "\n",
       "            bollinger_upper_5minus2  bollinger_lower_5minus2  \\\n",
       "dates                                                          \n",
       "2021-12-05             58118.024115             56192.117964   \n",
       "2021-12-06             59609.327629             53320.136863   \n",
       "\n",
       "            bollinger_upper_10minus2  bollinger_lower_10minus2  \\\n",
       "dates                                                            \n",
       "2021-12-05              59852.374375              53743.900815   \n",
       "2021-12-06              59903.463566              52900.246423   \n",
       "\n",
       "            bollinger_upper_20minus2  bollinger_lower_20minus2  pricesminus3  \\\n",
       "dates                                                                          \n",
       "2021-12-05              64965.686899              52467.599958  57169.371994   \n",
       "2021-12-06              64129.992223              52215.857816  56508.268054   \n",
       "\n",
       "            total_volumesminus3  ma_close_5minus3  ma_close_15minus3  \\\n",
       "dates                                                                  \n",
       "2021-12-05         4.938307e+10      56760.098205       57542.192628   \n",
       "2021-12-06         3.629634e+10      57155.071039       57269.166774   \n",
       "\n",
       "            ma_close_30minus3   ema_5minus3  ema_15minus3  ema_30minus3  \\\n",
       "dates                                                                     \n",
       "2021-12-05       60704.253573  57016.778295  58008.602081  58995.168239   \n",
       "2021-12-06       60479.622210  56847.274881  57821.060328  58834.723066   \n",
       "\n",
       "            rsi_sma_7minus3  rsi_sma_14minus3  rsi_sma_21minus3  \\\n",
       "dates                                                             \n",
       "2021-12-05        49.877774         42.876941         37.396801   \n",
       "2021-12-06        38.883325         48.867568         36.687047   \n",
       "\n",
       "            bollinger_upper_5minus3  bollinger_lower_5minus3  \\\n",
       "dates                                                          \n",
       "2021-12-05             59329.542796             54190.653614   \n",
       "2021-12-06             58118.024115             56192.117964   \n",
       "\n",
       "            bollinger_upper_10minus3  bollinger_lower_10minus3  \\\n",
       "dates                                                            \n",
       "2021-12-05              59846.313715              53725.679234   \n",
       "2021-12-06              59852.374375              53743.900815   \n",
       "\n",
       "            bollinger_upper_20minus3  bollinger_lower_20minus3  pricesminus4  \\\n",
       "dates                                                                          \n",
       "2021-12-05              65764.143304              52461.521542  57011.280474   \n",
       "2021-12-06              64965.686899              52467.599958  57169.371994   \n",
       "\n",
       "            total_volumesminus4  ma_close_5minus4  ma_close_15minus4  \\\n",
       "dates                                                                  \n",
       "2021-12-05         3.572304e+10      56091.782379       57760.805329   \n",
       "2021-12-06         4.938307e+10      56760.098205       57542.192628   \n",
       "\n",
       "            ma_close_30minus4   ema_5minus4  ema_15minus4  ema_30minus4  \\\n",
       "dates                                                                     \n",
       "2021-12-05       60836.002213  56940.481446  58128.492094  59121.085222   \n",
       "2021-12-06       60704.253573  57016.778295  58008.602081  58995.168239   \n",
       "\n",
       "            rsi_sma_7minus4  rsi_sma_14minus4  rsi_sma_21minus4  \\\n",
       "dates                                                             \n",
       "2021-12-05        46.972146         42.869836         34.753644   \n",
       "2021-12-06        49.877774         42.876941         37.396801   \n",
       "\n",
       "            bollinger_upper_5minus4  bollinger_lower_5minus4  \\\n",
       "dates                                                          \n",
       "2021-12-05             59669.452691             52514.112067   \n",
       "2021-12-06             59329.542796             54190.653614   \n",
       "\n",
       "            bollinger_upper_10minus4  bollinger_lower_10minus4  \\\n",
       "dates                                                            \n",
       "2021-12-05              60387.448383              53578.626023   \n",
       "2021-12-06              59846.313715              53725.679234   \n",
       "\n",
       "            bollinger_upper_20minus4  bollinger_lower_20minus4  pricesminus5  \\\n",
       "dates                                                                          \n",
       "2021-12-05              66583.414079              52425.878084  57848.773537   \n",
       "2021-12-06              65764.143304              52461.521542  57011.280474   \n",
       "\n",
       "            total_volumesminus5  ma_close_5minus5  ma_close_15minus5  \\\n",
       "dates                                                                  \n",
       "2021-12-05         3.098520e+10      56469.095681       58222.308994   \n",
       "2021-12-06         3.572304e+10      56091.782379       57760.805329   \n",
       "\n",
       "            ma_close_30minus5   ema_5minus5  ema_15minus5  ema_30minus5  \\\n",
       "dates                                                                     \n",
       "2021-12-05       60984.688480  56905.081931  58288.093754  59266.588997   \n",
       "2021-12-06       60836.002213  56940.481446  58128.492094  59121.085222   \n",
       "\n",
       "            rsi_sma_7minus5  rsi_sma_14minus5  rsi_sma_21minus5  \\\n",
       "dates                                                             \n",
       "2021-12-05        55.754108         38.626727         35.140478   \n",
       "2021-12-06        46.972146         42.869836         34.753644   \n",
       "\n",
       "            bollinger_upper_5minus5  bollinger_lower_5minus5  \\\n",
       "dates                                                          \n",
       "2021-12-05             60841.328525             52096.862837   \n",
       "2021-12-06             59669.452691             52514.112067   \n",
       "\n",
       "            bollinger_upper_10minus5  bollinger_lower_10minus5  \\\n",
       "dates                                                            \n",
       "2021-12-05              61219.716382              53360.684263   \n",
       "2021-12-06              60387.448383              53578.626023   \n",
       "\n",
       "            bollinger_upper_20minus5  bollinger_lower_20minus5  pricesminus6  \\\n",
       "dates                                                                          \n",
       "2021-12-05              67297.518304              52516.751253  57237.661137   \n",
       "2021-12-06              66583.414079              52425.878084  57848.773537   \n",
       "\n",
       "            total_volumesminus6  ma_close_5minus6  ma_close_15minus6  \\\n",
       "dates                                                                  \n",
       "2021-12-05         2.765946e+10      56338.977743       58742.322611   \n",
       "2021-12-06         3.098520e+10      56469.095681       58222.308994   \n",
       "\n",
       "            ma_close_30minus6   ema_5minus6  ema_15minus6  ema_30minus6  \\\n",
       "dates                                                                     \n",
       "2021-12-05       61117.637929  56433.236129  58350.853784  59364.369374   \n",
       "2021-12-06       60984.688480  56905.081931  58288.093754  59266.588997   \n",
       "\n",
       "            rsi_sma_7minus6  rsi_sma_14minus6  rsi_sma_21minus6  \\\n",
       "dates                                                             \n",
       "2021-12-05        43.593428         34.901938         41.945316   \n",
       "2021-12-06        55.754108         38.626727         35.140478   \n",
       "\n",
       "            bollinger_upper_5minus6  bollinger_lower_5minus6  \\\n",
       "dates                                                          \n",
       "2021-12-05             60541.337225             52136.618261   \n",
       "2021-12-06             60841.328525             52096.862837   \n",
       "\n",
       "            bollinger_upper_10minus6  bollinger_lower_10minus6  \\\n",
       "dates                                                            \n",
       "2021-12-05              61337.886437              53364.610604   \n",
       "2021-12-06              61219.716382              53360.684263   \n",
       "\n",
       "            bollinger_upper_20minus6  bollinger_lower_20minus6  pricesminus7  \\\n",
       "dates                                                                          \n",
       "2021-12-05              68362.331822              52381.597874  54533.403882   \n",
       "2021-12-06              67297.518304              52516.751253  57237.661137   \n",
       "\n",
       "            total_volumesminus7  ma_close_5minus7  ma_close_15minus7  \\\n",
       "dates                                                                  \n",
       "2021-12-05         2.825685e+10      56441.204150       59237.167558   \n",
       "2021-12-06         2.765946e+10      56338.977743       58742.322611   \n",
       "\n",
       "            ma_close_30minus7   ema_5minus7  ema_15minus7  ema_30minus7  \\\n",
       "dates                                                                     \n",
       "2021-12-05       61285.822492  56031.023624  58509.881305  59511.038907   \n",
       "2021-12-06       61117.637929  56433.236129  58350.853784  59364.369374   \n",
       "\n",
       "            rsi_sma_7minus7  rsi_sma_14minus7  rsi_sma_21minus7  \\\n",
       "dates                                                             \n",
       "2021-12-05        28.792655         30.629437         39.963147   \n",
       "2021-12-06        43.593428         34.901938         41.945316   \n",
       "\n",
       "            bollinger_upper_5minus7  bollinger_lower_5minus7  \\\n",
       "dates                                                          \n",
       "2021-12-05             60775.661640             52106.746660   \n",
       "2021-12-06             60541.337225             52136.618261   \n",
       "\n",
       "            bollinger_upper_10minus7  bollinger_lower_10minus7  \\\n",
       "dates                                                            \n",
       "2021-12-05              61319.161614              53333.267667   \n",
       "2021-12-06              61337.886437              53364.610604   \n",
       "\n",
       "            bollinger_upper_20minus7  bollinger_lower_20minus7  pricesminus8  \\\n",
       "dates                                                                          \n",
       "2021-12-05              69358.190632              52423.674505  53827.792865   \n",
       "2021-12-06              68362.331822              52381.597874  54533.403882   \n",
       "\n",
       "            total_volumesminus8  ma_close_5minus8  ma_close_15minus8  \\\n",
       "dates                                                                  \n",
       "2021-12-05         4.132581e+10      56811.894744       59897.077163   \n",
       "2021-12-06         2.825685e+10      56441.204150       59237.167558   \n",
       "\n",
       "            ma_close_30minus8   ema_5minus8  ema_15minus8  ema_30minus8  \\\n",
       "dates                                                                     \n",
       "2021-12-05       61493.627558  56779.833495  59077.949509  59854.324081   \n",
       "2021-12-06       61285.822492  56031.023624  58509.881305  59511.038907   \n",
       "\n",
       "            rsi_sma_7minus8  rsi_sma_14minus8  rsi_sma_21minus8  \\\n",
       "dates                                                             \n",
       "2021-12-05        33.461394         29.339150         39.465977   \n",
       "2021-12-06        28.792655         30.629437         39.963147   \n",
       "\n",
       "            bollinger_upper_5minus8  bollinger_lower_5minus8  \\\n",
       "dates                                                          \n",
       "2021-12-05             60615.013979             53008.775509   \n",
       "2021-12-06             60775.661640             52106.746660   \n",
       "\n",
       "            bollinger_upper_10minus8  bollinger_lower_10minus8  \\\n",
       "dates                                                            \n",
       "2021-12-05              61884.621628              53981.858050   \n",
       "2021-12-06              61319.161614              53333.267667   \n",
       "\n",
       "            bollinger_upper_20minus8  bollinger_lower_20minus8  pricesminus9  \\\n",
       "dates                                                                          \n",
       "2021-12-05              69289.402915              53354.444853  58897.846983   \n",
       "2021-12-06              69358.190632              52423.674505  53827.792865   \n",
       "\n",
       "            total_volumesminus9  ma_close_5minus9  ma_close_15minus9  \\\n",
       "dates                                                                  \n",
       "2021-12-05         3.372110e+10      57874.292027       60642.267316   \n",
       "2021-12-06         4.132581e+10      56811.894744       59897.077163   \n",
       "\n",
       "            ma_close_30minus9   ema_5minus9  ema_15minus9  ema_30minus9  \\\n",
       "dates                                                                     \n",
       "2021-12-05       61654.067845  58255.853810  59827.971886  60269.946924   \n",
       "2021-12-06       61493.627558  56779.833495  59077.949509  59854.324081   \n",
       "\n",
       "            rsi_sma_7minus9  rsi_sma_14minus9  rsi_sma_21minus9  \\\n",
       "dates                                                             \n",
       "2021-12-05        59.181813         35.571827         45.567613   \n",
       "2021-12-06        33.461394         29.339150         39.465977   \n",
       "\n",
       "            bollinger_upper_5minus9  bollinger_lower_5minus9  \\\n",
       "dates                                                          \n",
       "2021-12-05             60183.936668             55564.647387   \n",
       "2021-12-06             60615.013979             53008.775509   \n",
       "\n",
       "            bollinger_upper_10minus9  bollinger_lower_10minus9  \\\n",
       "dates                                                            \n",
       "2021-12-05              61593.011089              55597.622519   \n",
       "2021-12-06              61884.621628              53981.858050   \n",
       "\n",
       "            bollinger_upper_20minus9  bollinger_lower_20minus9  pricesminus10  \\\n",
       "dates                                                                           \n",
       "2021-12-05              68857.512479              54569.691869   57198.183846   \n",
       "2021-12-06              69289.402915              53354.444853   58897.846983   \n",
       "\n",
       "            total_volumesminus10  ma_close_5minus10  ma_close_15minus10  \\\n",
       "dates                                                                     \n",
       "2021-12-05          3.169537e+10       58111.304964        61053.147810   \n",
       "2021-12-06          3.372110e+10       57874.292027        60642.267316   \n",
       "\n",
       "            ma_close_30minus10  ema_5minus10  ema_15minus10  ema_30minus10  \\\n",
       "dates                                                                        \n",
       "2021-12-05        61710.945909  57934.857224   59960.846873   60364.574506   \n",
       "2021-12-06        61654.067845  58255.853810   59827.971886   60269.946924   \n",
       "\n",
       "            rsi_sma_7minus10  rsi_sma_14minus10  rsi_sma_21minus10  \\\n",
       "dates                                                                \n",
       "2021-12-05         36.179678          29.861481          40.220013   \n",
       "2021-12-06         59.181813          35.571827          45.567613   \n",
       "\n",
       "            bollinger_upper_5minus10  bollinger_lower_5minus10  \\\n",
       "dates                                                            \n",
       "2021-12-05              61091.895288              55130.714641   \n",
       "2021-12-06              60183.936668              55564.647387   \n",
       "\n",
       "            bollinger_upper_10minus10  bollinger_lower_10minus10  \\\n",
       "dates                                                              \n",
       "2021-12-05               63624.940326               54572.890974   \n",
       "2021-12-06               61593.011089               55597.622519   \n",
       "\n",
       "            bollinger_upper_20minus10  bollinger_lower_20minus10  \\\n",
       "dates                                                              \n",
       "2021-12-05               68856.315886               54805.842258   \n",
       "2021-12-06               68857.512479               54569.691869   \n",
       "\n",
       "            pricesminus11  total_volumesminus11  ma_close_5minus11  \\\n",
       "dates                                                                \n",
       "2021-12-05   57748.793174          3.642119e+10       58363.519298   \n",
       "2021-12-06   57198.183846          3.169537e+10       58111.304964   \n",
       "\n",
       "            ma_close_15minus11  ma_close_30minus11  ema_5minus11  \\\n",
       "dates                                                              \n",
       "2021-12-05        61716.293883        61911.946908  58303.193913   \n",
       "2021-12-06        61053.147810        61710.945909  57934.857224   \n",
       "\n",
       "            ema_15minus11  ema_30minus11  rsi_sma_7minus11  rsi_sma_14minus11  \\\n",
       "dates                                                                           \n",
       "2021-12-05   60355.513019   60582.946276         38.680219          27.686349   \n",
       "2021-12-06   59960.846873   60364.574506         36.179678          29.861481   \n",
       "\n",
       "            rsi_sma_21minus11  bollinger_upper_5minus11  \\\n",
       "dates                                                     \n",
       "2021-12-05          40.804333              61165.864340   \n",
       "2021-12-06          40.220013              61091.895288   \n",
       "\n",
       "            bollinger_lower_5minus11  bollinger_upper_10minus11  \\\n",
       "dates                                                             \n",
       "2021-12-05              55561.174256               65840.885540   \n",
       "2021-12-06              55130.714641               63624.940326   \n",
       "\n",
       "            bollinger_lower_10minus11  bollinger_upper_20minus11  \\\n",
       "dates                                                              \n",
       "2021-12-05               54047.104549               68732.741026   \n",
       "2021-12-06               54572.890974               68856.315886   \n",
       "\n",
       "            bollinger_lower_20minus11  pricesminus12  total_volumesminus12  \\\n",
       "dates                                                                        \n",
       "2021-12-05               55369.773090   56386.856853          3.400147e+10   \n",
       "2021-12-06               54805.842258   57748.793174          3.642119e+10   \n",
       "\n",
       "            ma_close_5minus12  ma_close_15minus12  ma_close_30minus12  \\\n",
       "dates                                                                   \n",
       "2021-12-05       58211.225131        62374.175374        62026.092682   \n",
       "2021-12-06       58363.519298        61716.293883        61911.946908   \n",
       "\n",
       "            ema_5minus12  ema_15minus12  ema_30minus12  rsi_sma_7minus12  \\\n",
       "dates                                                                      \n",
       "2021-12-05  58580.394282   60727.901569   60778.405110         23.139259   \n",
       "2021-12-06  58303.193913   60355.513019   60582.946276         38.680219   \n",
       "\n",
       "            rsi_sma_14minus12  rsi_sma_21minus12  bollinger_upper_5minus12  \\\n",
       "dates                                                                        \n",
       "2021-12-05          22.154860          42.278309              61253.132433   \n",
       "2021-12-06          27.686349          40.804333              61165.864340   \n",
       "\n",
       "            bollinger_lower_5minus12  bollinger_upper_10minus12  \\\n",
       "dates                                                             \n",
       "2021-12-05              55169.317830               66990.828351   \n",
       "2021-12-06              55561.174256               65840.885540   \n",
       "\n",
       "            bollinger_lower_10minus12  bollinger_upper_20minus12  \\\n",
       "dates                                                              \n",
       "2021-12-05               54279.470173               68698.893162   \n",
       "2021-12-06               54047.104549               68732.741026   \n",
       "\n",
       "            bollinger_lower_20minus12  pricesminus13  total_volumesminus13  \\\n",
       "dates                                                                        \n",
       "2021-12-05               55941.835872   59139.779280          2.574343e+10   \n",
       "2021-12-06               55369.773090   56386.856853          3.400147e+10   \n",
       "\n",
       "            ma_close_5minus13  ma_close_15minus13  ma_close_30minus13  \\\n",
       "dates                                                                   \n",
       "2021-12-05       59054.584934        62825.266930        62198.935468   \n",
       "2021-12-06       58211.225131        62374.175374        62026.092682   \n",
       "\n",
       "            ema_5minus13  ema_15minus13  ema_30minus13  rsi_sma_7minus13  \\\n",
       "dates                                                                      \n",
       "2021-12-05  59677.162996   61348.050814   61081.270507         24.984948   \n",
       "2021-12-06  58580.394282   60727.901569   60778.405110         23.139259   \n",
       "\n",
       "            rsi_sma_14minus13  rsi_sma_21minus13  bollinger_upper_5minus13  \\\n",
       "dates                                                                        \n",
       "2021-12-05          40.826921          45.873479              61899.286405   \n",
       "2021-12-06          22.154860          42.278309              61253.132433   \n",
       "\n",
       "            bollinger_lower_5minus13  bollinger_upper_10minus13  \\\n",
       "dates                                                             \n",
       "2021-12-05              56209.883463               67431.660020   \n",
       "2021-12-06              55169.317830               66990.828351   \n",
       "\n",
       "            bollinger_lower_10minus13  bollinger_upper_20minus13  \\\n",
       "dates                                                              \n",
       "2021-12-05               55447.676724               68404.389504   \n",
       "2021-12-06               54279.470173               68698.893162   \n",
       "\n",
       "            bollinger_lower_20minus13  pricesminus14  total_volumesminus14  \\\n",
       "dates                                                                        \n",
       "2021-12-05               56922.374741   60082.911668          2.967655e+10   \n",
       "2021-12-06               55941.835872   59139.779280          2.574343e+10   \n",
       "\n",
       "            ma_close_5minus14  ma_close_15minus14  ma_close_30minus14  \\\n",
       "dates                                                                   \n",
       "2021-12-05       59316.341581        62993.372223        62261.918523   \n",
       "2021-12-06       59054.584934        62825.266930        62198.935468   \n",
       "\n",
       "            ema_5minus14  ema_15minus14  ema_30minus14  rsi_sma_7minus14  \\\n",
       "dates                                                                      \n",
       "2021-12-05  59945.854855   61663.518176   61215.166454         32.470137   \n",
       "2021-12-06  59677.162996   61348.050814   61081.270507         24.984948   \n",
       "\n",
       "            rsi_sma_14minus14  rsi_sma_21minus14  bollinger_upper_5minus14  \\\n",
       "dates                                                                        \n",
       "2021-12-05          46.480606          46.830976              62428.520747   \n",
       "2021-12-06          40.826921          45.873479              61899.286405   \n",
       "\n",
       "            bollinger_lower_5minus14  bollinger_upper_10minus14  \\\n",
       "dates                                                             \n",
       "2021-12-05              56204.162415               68164.288708   \n",
       "2021-12-06              56209.883463               67431.660020   \n",
       "\n",
       "            bollinger_lower_10minus14  bollinger_upper_20minus14  \\\n",
       "dates                                                              \n",
       "2021-12-05               55888.221212               68312.642859   \n",
       "2021-12-06               55447.676724               68404.389504   \n",
       "\n",
       "            bollinger_lower_20minus14  \n",
       "dates                                  \n",
       "2021-12-05               57212.326578  \n",
       "2021-12-06               56922.374741  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "dbb0e6ac-fe5e-499e-bb60-e5506abf112d",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importing module and initializing setup\n",
    "from pycaret.regression import *\n",
    "\n",
    "def pipeline(df):\n",
    "    modelo = setup(data = df,\n",
    "                   target = 'y', feature_interaction = False,\n",
    "                   remove_outliers=True,\n",
    "                   normalize = True, normalize_method = \"zscore\",\n",
    "                   silent = True, verbose=False);"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "ac620273-6bec-40cc-a6c9-a1e767eff27c",
   "metadata": {},
   "outputs": [],
   "source": [
    "past_t = 250 # Es hiperparametro del modelo"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "d44523bb-dbb8-4fa9-a5b0-02567c0a33be",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shape: (250, 256)\n"
     ]
    },
    {
     "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>prices</th>\n",
       "      <th>total_volumes</th>\n",
       "      <th>y</th>\n",
       "      <th>ma_close_5</th>\n",
       "      <th>ma_close_15</th>\n",
       "      <th>ma_close_30</th>\n",
       "      <th>ema_5</th>\n",
       "      <th>ema_15</th>\n",
       "      <th>ema_30</th>\n",
       "      <th>rsi_sma_7</th>\n",
       "      <th>rsi_sma_14</th>\n",
       "      <th>rsi_sma_21</th>\n",
       "      <th>bollinger_upper_5</th>\n",
       "      <th>bollinger_lower_5</th>\n",
       "      <th>bollinger_upper_10</th>\n",
       "      <th>bollinger_lower_10</th>\n",
       "      <th>bollinger_upper_20</th>\n",
       "      <th>bollinger_lower_20</th>\n",
       "      <th>pricesminus1</th>\n",
       "      <th>total_volumesminus1</th>\n",
       "      <th>ma_close_5minus1</th>\n",
       "      <th>ma_close_15minus1</th>\n",
       "      <th>ma_close_30minus1</th>\n",
       "      <th>ema_5minus1</th>\n",
       "      <th>ema_15minus1</th>\n",
       "      <th>ema_30minus1</th>\n",
       "      <th>rsi_sma_7minus1</th>\n",
       "      <th>rsi_sma_14minus1</th>\n",
       "      <th>rsi_sma_21minus1</th>\n",
       "      <th>bollinger_upper_5minus1</th>\n",
       "      <th>bollinger_lower_5minus1</th>\n",
       "      <th>bollinger_upper_10minus1</th>\n",
       "      <th>bollinger_lower_10minus1</th>\n",
       "      <th>bollinger_upper_20minus1</th>\n",
       "      <th>bollinger_lower_20minus1</th>\n",
       "      <th>pricesminus2</th>\n",
       "      <th>total_volumesminus2</th>\n",
       "      <th>ma_close_5minus2</th>\n",
       "      <th>ma_close_15minus2</th>\n",
       "      <th>ma_close_30minus2</th>\n",
       "      <th>ema_5minus2</th>\n",
       "      <th>ema_15minus2</th>\n",
       "      <th>ema_30minus2</th>\n",
       "      <th>rsi_sma_7minus2</th>\n",
       "      <th>rsi_sma_14minus2</th>\n",
       "      <th>rsi_sma_21minus2</th>\n",
       "      <th>bollinger_upper_5minus2</th>\n",
       "      <th>bollinger_lower_5minus2</th>\n",
       "      <th>bollinger_upper_10minus2</th>\n",
       "      <th>bollinger_lower_10minus2</th>\n",
       "      <th>bollinger_upper_20minus2</th>\n",
       "      <th>bollinger_lower_20minus2</th>\n",
       "      <th>pricesminus3</th>\n",
       "      <th>total_volumesminus3</th>\n",
       "      <th>ma_close_5minus3</th>\n",
       "      <th>ma_close_15minus3</th>\n",
       "      <th>ma_close_30minus3</th>\n",
       "      <th>ema_5minus3</th>\n",
       "      <th>ema_15minus3</th>\n",
       "      <th>ema_30minus3</th>\n",
       "      <th>rsi_sma_7minus3</th>\n",
       "      <th>rsi_sma_14minus3</th>\n",
       "      <th>rsi_sma_21minus3</th>\n",
       "      <th>bollinger_upper_5minus3</th>\n",
       "      <th>bollinger_lower_5minus3</th>\n",
       "      <th>bollinger_upper_10minus3</th>\n",
       "      <th>bollinger_lower_10minus3</th>\n",
       "      <th>bollinger_upper_20minus3</th>\n",
       "      <th>bollinger_lower_20minus3</th>\n",
       "      <th>pricesminus4</th>\n",
       "      <th>total_volumesminus4</th>\n",
       "      <th>ma_close_5minus4</th>\n",
       "      <th>ma_close_15minus4</th>\n",
       "      <th>ma_close_30minus4</th>\n",
       "      <th>ema_5minus4</th>\n",
       "      <th>ema_15minus4</th>\n",
       "      <th>ema_30minus4</th>\n",
       "      <th>rsi_sma_7minus4</th>\n",
       "      <th>rsi_sma_14minus4</th>\n",
       "      <th>rsi_sma_21minus4</th>\n",
       "      <th>bollinger_upper_5minus4</th>\n",
       "      <th>bollinger_lower_5minus4</th>\n",
       "      <th>bollinger_upper_10minus4</th>\n",
       "      <th>bollinger_lower_10minus4</th>\n",
       "      <th>bollinger_upper_20minus4</th>\n",
       "      <th>bollinger_lower_20minus4</th>\n",
       "      <th>pricesminus5</th>\n",
       "      <th>total_volumesminus5</th>\n",
       "      <th>ma_close_5minus5</th>\n",
       "      <th>ma_close_15minus5</th>\n",
       "      <th>ma_close_30minus5</th>\n",
       "      <th>ema_5minus5</th>\n",
       "      <th>ema_15minus5</th>\n",
       "      <th>ema_30minus5</th>\n",
       "      <th>rsi_sma_7minus5</th>\n",
       "      <th>rsi_sma_14minus5</th>\n",
       "      <th>rsi_sma_21minus5</th>\n",
       "      <th>bollinger_upper_5minus5</th>\n",
       "      <th>bollinger_lower_5minus5</th>\n",
       "      <th>bollinger_upper_10minus5</th>\n",
       "      <th>bollinger_lower_10minus5</th>\n",
       "      <th>bollinger_upper_20minus5</th>\n",
       "      <th>bollinger_lower_20minus5</th>\n",
       "      <th>pricesminus6</th>\n",
       "      <th>total_volumesminus6</th>\n",
       "      <th>ma_close_5minus6</th>\n",
       "      <th>ma_close_15minus6</th>\n",
       "      <th>ma_close_30minus6</th>\n",
       "      <th>ema_5minus6</th>\n",
       "      <th>ema_15minus6</th>\n",
       "      <th>ema_30minus6</th>\n",
       "      <th>rsi_sma_7minus6</th>\n",
       "      <th>rsi_sma_14minus6</th>\n",
       "      <th>rsi_sma_21minus6</th>\n",
       "      <th>bollinger_upper_5minus6</th>\n",
       "      <th>bollinger_lower_5minus6</th>\n",
       "      <th>bollinger_upper_10minus6</th>\n",
       "      <th>bollinger_lower_10minus6</th>\n",
       "      <th>bollinger_upper_20minus6</th>\n",
       "      <th>bollinger_lower_20minus6</th>\n",
       "      <th>pricesminus7</th>\n",
       "      <th>total_volumesminus7</th>\n",
       "      <th>ma_close_5minus7</th>\n",
       "      <th>ma_close_15minus7</th>\n",
       "      <th>ma_close_30minus7</th>\n",
       "      <th>ema_5minus7</th>\n",
       "      <th>ema_15minus7</th>\n",
       "      <th>ema_30minus7</th>\n",
       "      <th>rsi_sma_7minus7</th>\n",
       "      <th>rsi_sma_14minus7</th>\n",
       "      <th>rsi_sma_21minus7</th>\n",
       "      <th>bollinger_upper_5minus7</th>\n",
       "      <th>bollinger_lower_5minus7</th>\n",
       "      <th>bollinger_upper_10minus7</th>\n",
       "      <th>bollinger_lower_10minus7</th>\n",
       "      <th>bollinger_upper_20minus7</th>\n",
       "      <th>bollinger_lower_20minus7</th>\n",
       "      <th>pricesminus8</th>\n",
       "      <th>total_volumesminus8</th>\n",
       "      <th>ma_close_5minus8</th>\n",
       "      <th>ma_close_15minus8</th>\n",
       "      <th>ma_close_30minus8</th>\n",
       "      <th>ema_5minus8</th>\n",
       "      <th>ema_15minus8</th>\n",
       "      <th>ema_30minus8</th>\n",
       "      <th>rsi_sma_7minus8</th>\n",
       "      <th>rsi_sma_14minus8</th>\n",
       "      <th>rsi_sma_21minus8</th>\n",
       "      <th>bollinger_upper_5minus8</th>\n",
       "      <th>bollinger_lower_5minus8</th>\n",
       "      <th>bollinger_upper_10minus8</th>\n",
       "      <th>bollinger_lower_10minus8</th>\n",
       "      <th>bollinger_upper_20minus8</th>\n",
       "      <th>bollinger_lower_20minus8</th>\n",
       "      <th>pricesminus9</th>\n",
       "      <th>total_volumesminus9</th>\n",
       "      <th>ma_close_5minus9</th>\n",
       "      <th>ma_close_15minus9</th>\n",
       "      <th>ma_close_30minus9</th>\n",
       "      <th>ema_5minus9</th>\n",
       "      <th>ema_15minus9</th>\n",
       "      <th>ema_30minus9</th>\n",
       "      <th>rsi_sma_7minus9</th>\n",
       "      <th>rsi_sma_14minus9</th>\n",
       "      <th>rsi_sma_21minus9</th>\n",
       "      <th>bollinger_upper_5minus9</th>\n",
       "      <th>bollinger_lower_5minus9</th>\n",
       "      <th>bollinger_upper_10minus9</th>\n",
       "      <th>bollinger_lower_10minus9</th>\n",
       "      <th>bollinger_upper_20minus9</th>\n",
       "      <th>bollinger_lower_20minus9</th>\n",
       "      <th>pricesminus10</th>\n",
       "      <th>total_volumesminus10</th>\n",
       "      <th>ma_close_5minus10</th>\n",
       "      <th>ma_close_15minus10</th>\n",
       "      <th>ma_close_30minus10</th>\n",
       "      <th>ema_5minus10</th>\n",
       "      <th>ema_15minus10</th>\n",
       "      <th>ema_30minus10</th>\n",
       "      <th>rsi_sma_7minus10</th>\n",
       "      <th>rsi_sma_14minus10</th>\n",
       "      <th>rsi_sma_21minus10</th>\n",
       "      <th>bollinger_upper_5minus10</th>\n",
       "      <th>bollinger_lower_5minus10</th>\n",
       "      <th>bollinger_upper_10minus10</th>\n",
       "      <th>bollinger_lower_10minus10</th>\n",
       "      <th>bollinger_upper_20minus10</th>\n",
       "      <th>bollinger_lower_20minus10</th>\n",
       "      <th>pricesminus11</th>\n",
       "      <th>total_volumesminus11</th>\n",
       "      <th>ma_close_5minus11</th>\n",
       "      <th>ma_close_15minus11</th>\n",
       "      <th>ma_close_30minus11</th>\n",
       "      <th>ema_5minus11</th>\n",
       "      <th>ema_15minus11</th>\n",
       "      <th>ema_30minus11</th>\n",
       "      <th>rsi_sma_7minus11</th>\n",
       "      <th>rsi_sma_14minus11</th>\n",
       "      <th>rsi_sma_21minus11</th>\n",
       "      <th>bollinger_upper_5minus11</th>\n",
       "      <th>bollinger_lower_5minus11</th>\n",
       "      <th>bollinger_upper_10minus11</th>\n",
       "      <th>bollinger_lower_10minus11</th>\n",
       "      <th>bollinger_upper_20minus11</th>\n",
       "      <th>bollinger_lower_20minus11</th>\n",
       "      <th>pricesminus12</th>\n",
       "      <th>total_volumesminus12</th>\n",
       "      <th>ma_close_5minus12</th>\n",
       "      <th>ma_close_15minus12</th>\n",
       "      <th>ma_close_30minus12</th>\n",
       "      <th>ema_5minus12</th>\n",
       "      <th>ema_15minus12</th>\n",
       "      <th>ema_30minus12</th>\n",
       "      <th>rsi_sma_7minus12</th>\n",
       "      <th>rsi_sma_14minus12</th>\n",
       "      <th>rsi_sma_21minus12</th>\n",
       "      <th>bollinger_upper_5minus12</th>\n",
       "      <th>bollinger_lower_5minus12</th>\n",
       "      <th>bollinger_upper_10minus12</th>\n",
       "      <th>bollinger_lower_10minus12</th>\n",
       "      <th>bollinger_upper_20minus12</th>\n",
       "      <th>bollinger_lower_20minus12</th>\n",
       "      <th>pricesminus13</th>\n",
       "      <th>total_volumesminus13</th>\n",
       "      <th>ma_close_5minus13</th>\n",
       "      <th>ma_close_15minus13</th>\n",
       "      <th>ma_close_30minus13</th>\n",
       "      <th>ema_5minus13</th>\n",
       "      <th>ema_15minus13</th>\n",
       "      <th>ema_30minus13</th>\n",
       "      <th>rsi_sma_7minus13</th>\n",
       "      <th>rsi_sma_14minus13</th>\n",
       "      <th>rsi_sma_21minus13</th>\n",
       "      <th>bollinger_upper_5minus13</th>\n",
       "      <th>bollinger_lower_5minus13</th>\n",
       "      <th>bollinger_upper_10minus13</th>\n",
       "      <th>bollinger_lower_10minus13</th>\n",
       "      <th>bollinger_upper_20minus13</th>\n",
       "      <th>bollinger_lower_20minus13</th>\n",
       "      <th>pricesminus14</th>\n",
       "      <th>total_volumesminus14</th>\n",
       "      <th>ma_close_5minus14</th>\n",
       "      <th>ma_close_15minus14</th>\n",
       "      <th>ma_close_30minus14</th>\n",
       "      <th>ema_5minus14</th>\n",
       "      <th>ema_15minus14</th>\n",
       "      <th>ema_30minus14</th>\n",
       "      <th>rsi_sma_7minus14</th>\n",
       "      <th>rsi_sma_14minus14</th>\n",
       "      <th>rsi_sma_21minus14</th>\n",
       "      <th>bollinger_upper_5minus14</th>\n",
       "      <th>bollinger_lower_5minus14</th>\n",
       "      <th>bollinger_upper_10minus14</th>\n",
       "      <th>bollinger_lower_10minus14</th>\n",
       "      <th>bollinger_upper_20minus14</th>\n",
       "      <th>bollinger_lower_20minus14</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dates</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-12-05</th>\n",
       "      <td>49161.99071</td>\n",
       "      <td>5.594141e+10</td>\n",
       "      <td>49268.469891</td>\n",
       "      <td>54727.375681</td>\n",
       "      <td>56435.925442</td>\n",
       "      <td>59753.464608</td>\n",
       "      <td>53605.222889</td>\n",
       "      <td>56297.338312</td>\n",
       "      <td>57905.964223</td>\n",
       "      <td>28.197488</td>\n",
       "      <td>28.50404</td>\n",
       "      <td>29.850475</td>\n",
       "      <td>61525.235977</td>\n",
       "      <td>47929.515385</td>\n",
       "      <td>61290.776455</td>\n",
       "      <td>49905.694907</td>\n",
       "      <td>63509.165535</td>\n",
       "      <td>51187.985795</td>\n",
       "      <td>53785.967172</td>\n",
       "      <td>3.952711e+10</td>\n",
       "      <td>56464.732246</td>\n",
       "      <td>57055.743096</td>\n",
       "      <td>60168.123037</td>\n",
       "      <td>55826.838978</td>\n",
       "      <td>57316.673683</td>\n",
       "      <td>58508.996879</td>\n",
       "      <td>49.751037</td>\n",
       "      <td>39.569458</td>\n",
       "      <td>34.372794</td>\n",
       "      <td>59609.327629</td>\n",
       "      <td>53320.136863</td>\n",
       "      <td>59903.463566</td>\n",
       "      <td>52900.246423</td>\n",
       "      <td>64129.992223</td>\n",
       "      <td>52215.857816</td>\n",
       "      <td>56508.268054</td>\n",
       "      <td>3.629634e+10</td>\n",
       "      <td>57155.071039</td>\n",
       "      <td>57269.166774</td>\n",
       "      <td>60479.62221</td>\n",
       "      <td>56847.274881</td>\n",
       "      <td>57821.060328</td>\n",
       "      <td>58834.723066</td>\n",
       "      <td>38.883325</td>\n",
       "      <td>48.867568</td>\n",
       "      <td>36.687047</td>\n",
       "      <td>58118.024115</td>\n",
       "      <td>56192.117964</td>\n",
       "      <td>59852.374375</td>\n",
       "      <td>53743.900815</td>\n",
       "      <td>64965.686899</td>\n",
       "      <td>52467.599958</td>\n",
       "      <td>57169.371994</td>\n",
       "      <td>4.938307e+10</td>\n",
       "      <td>56760.098205</td>\n",
       "      <td>57542.192628</td>\n",
       "      <td>60704.253573</td>\n",
       "      <td>57016.778295</td>\n",
       "      <td>58008.602081</td>\n",
       "      <td>58995.168239</td>\n",
       "      <td>49.877774</td>\n",
       "      <td>42.876941</td>\n",
       "      <td>37.396801</td>\n",
       "      <td>59329.542796</td>\n",
       "      <td>54190.653614</td>\n",
       "      <td>59846.313715</td>\n",
       "      <td>53725.679234</td>\n",
       "      <td>65764.143304</td>\n",
       "      <td>52461.521542</td>\n",
       "      <td>57011.280474</td>\n",
       "      <td>3.572304e+10</td>\n",
       "      <td>56091.782379</td>\n",
       "      <td>57760.805329</td>\n",
       "      <td>60836.002213</td>\n",
       "      <td>56940.481446</td>\n",
       "      <td>58128.492094</td>\n",
       "      <td>59121.085222</td>\n",
       "      <td>46.972146</td>\n",
       "      <td>42.869836</td>\n",
       "      <td>34.753644</td>\n",
       "      <td>59669.452691</td>\n",
       "      <td>52514.112067</td>\n",
       "      <td>60387.448383</td>\n",
       "      <td>53578.626023</td>\n",
       "      <td>66583.414079</td>\n",
       "      <td>52425.878084</td>\n",
       "      <td>57848.773537</td>\n",
       "      <td>3.098520e+10</td>\n",
       "      <td>56469.095681</td>\n",
       "      <td>58222.308994</td>\n",
       "      <td>60984.68848</td>\n",
       "      <td>56905.081931</td>\n",
       "      <td>58288.093754</td>\n",
       "      <td>59266.588997</td>\n",
       "      <td>55.754108</td>\n",
       "      <td>38.626727</td>\n",
       "      <td>35.140478</td>\n",
       "      <td>60841.328525</td>\n",
       "      <td>52096.862837</td>\n",
       "      <td>61219.716382</td>\n",
       "      <td>53360.684263</td>\n",
       "      <td>67297.518304</td>\n",
       "      <td>52516.751253</td>\n",
       "      <td>57237.661137</td>\n",
       "      <td>2.765946e+10</td>\n",
       "      <td>56338.977743</td>\n",
       "      <td>58742.322611</td>\n",
       "      <td>61117.637929</td>\n",
       "      <td>56433.236129</td>\n",
       "      <td>58350.853784</td>\n",
       "      <td>59364.369374</td>\n",
       "      <td>43.593428</td>\n",
       "      <td>34.901938</td>\n",
       "      <td>41.945316</td>\n",
       "      <td>60541.337225</td>\n",
       "      <td>52136.618261</td>\n",
       "      <td>61337.886437</td>\n",
       "      <td>53364.610604</td>\n",
       "      <td>68362.331822</td>\n",
       "      <td>52381.597874</td>\n",
       "      <td>54533.403882</td>\n",
       "      <td>2.825685e+10</td>\n",
       "      <td>56441.20415</td>\n",
       "      <td>59237.167558</td>\n",
       "      <td>61285.822492</td>\n",
       "      <td>56031.023624</td>\n",
       "      <td>58509.881305</td>\n",
       "      <td>59511.038907</td>\n",
       "      <td>28.792655</td>\n",
       "      <td>30.629437</td>\n",
       "      <td>39.963147</td>\n",
       "      <td>60775.66164</td>\n",
       "      <td>52106.74666</td>\n",
       "      <td>61319.161614</td>\n",
       "      <td>53333.267667</td>\n",
       "      <td>69358.190632</td>\n",
       "      <td>52423.674505</td>\n",
       "      <td>53827.792865</td>\n",
       "      <td>4.132581e+10</td>\n",
       "      <td>56811.894744</td>\n",
       "      <td>59897.077163</td>\n",
       "      <td>61493.627558</td>\n",
       "      <td>56779.833495</td>\n",
       "      <td>59077.949509</td>\n",
       "      <td>59854.324081</td>\n",
       "      <td>33.461394</td>\n",
       "      <td>29.33915</td>\n",
       "      <td>39.465977</td>\n",
       "      <td>60615.013979</td>\n",
       "      <td>53008.775509</td>\n",
       "      <td>61884.621628</td>\n",
       "      <td>53981.85805</td>\n",
       "      <td>69289.402915</td>\n",
       "      <td>53354.444853</td>\n",
       "      <td>58897.846983</td>\n",
       "      <td>3.372110e+10</td>\n",
       "      <td>57874.292027</td>\n",
       "      <td>60642.267316</td>\n",
       "      <td>61654.067845</td>\n",
       "      <td>58255.85381</td>\n",
       "      <td>59827.971886</td>\n",
       "      <td>60269.946924</td>\n",
       "      <td>59.181813</td>\n",
       "      <td>35.571827</td>\n",
       "      <td>45.567613</td>\n",
       "      <td>60183.936668</td>\n",
       "      <td>55564.647387</td>\n",
       "      <td>61593.011089</td>\n",
       "      <td>55597.622519</td>\n",
       "      <td>68857.512479</td>\n",
       "      <td>54569.691869</td>\n",
       "      <td>57198.183846</td>\n",
       "      <td>3.169537e+10</td>\n",
       "      <td>58111.304964</td>\n",
       "      <td>61053.14781</td>\n",
       "      <td>61710.945909</td>\n",
       "      <td>57934.857224</td>\n",
       "      <td>59960.846873</td>\n",
       "      <td>60364.574506</td>\n",
       "      <td>36.179678</td>\n",
       "      <td>29.861481</td>\n",
       "      <td>40.220013</td>\n",
       "      <td>61091.895288</td>\n",
       "      <td>55130.714641</td>\n",
       "      <td>63624.940326</td>\n",
       "      <td>54572.890974</td>\n",
       "      <td>68856.315886</td>\n",
       "      <td>54805.842258</td>\n",
       "      <td>57748.793174</td>\n",
       "      <td>3.642119e+10</td>\n",
       "      <td>58363.519298</td>\n",
       "      <td>61716.293883</td>\n",
       "      <td>61911.946908</td>\n",
       "      <td>58303.193913</td>\n",
       "      <td>60355.513019</td>\n",
       "      <td>60582.946276</td>\n",
       "      <td>38.680219</td>\n",
       "      <td>27.686349</td>\n",
       "      <td>40.804333</td>\n",
       "      <td>61165.86434</td>\n",
       "      <td>55561.174256</td>\n",
       "      <td>65840.88554</td>\n",
       "      <td>54047.104549</td>\n",
       "      <td>68732.741026</td>\n",
       "      <td>55369.77309</td>\n",
       "      <td>56386.856853</td>\n",
       "      <td>3.400147e+10</td>\n",
       "      <td>58211.225131</td>\n",
       "      <td>62374.175374</td>\n",
       "      <td>62026.092682</td>\n",
       "      <td>58580.394282</td>\n",
       "      <td>60727.901569</td>\n",
       "      <td>60778.40511</td>\n",
       "      <td>23.139259</td>\n",
       "      <td>22.15486</td>\n",
       "      <td>42.278309</td>\n",
       "      <td>61253.132433</td>\n",
       "      <td>55169.31783</td>\n",
       "      <td>66990.828351</td>\n",
       "      <td>54279.470173</td>\n",
       "      <td>68698.893162</td>\n",
       "      <td>55941.835872</td>\n",
       "      <td>59139.77928</td>\n",
       "      <td>2.574343e+10</td>\n",
       "      <td>59054.584934</td>\n",
       "      <td>62825.26693</td>\n",
       "      <td>62198.935468</td>\n",
       "      <td>59677.162996</td>\n",
       "      <td>61348.050814</td>\n",
       "      <td>61081.270507</td>\n",
       "      <td>24.984948</td>\n",
       "      <td>40.826921</td>\n",
       "      <td>45.873479</td>\n",
       "      <td>61899.286405</td>\n",
       "      <td>56209.883463</td>\n",
       "      <td>67431.66002</td>\n",
       "      <td>55447.676724</td>\n",
       "      <td>68404.389504</td>\n",
       "      <td>56922.374741</td>\n",
       "      <td>60082.911668</td>\n",
       "      <td>2.967655e+10</td>\n",
       "      <td>59316.341581</td>\n",
       "      <td>62993.372223</td>\n",
       "      <td>62261.918523</td>\n",
       "      <td>59945.854855</td>\n",
       "      <td>61663.518176</td>\n",
       "      <td>61215.166454</td>\n",
       "      <td>32.470137</td>\n",
       "      <td>46.480606</td>\n",
       "      <td>46.830976</td>\n",
       "      <td>62428.520747</td>\n",
       "      <td>56204.162415</td>\n",
       "      <td>68164.288708</td>\n",
       "      <td>55888.221212</td>\n",
       "      <td>68312.642859</td>\n",
       "      <td>57212.326578</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 prices  total_volumes             y    ma_close_5  \\\n",
       "dates                                                                \n",
       "2021-12-05  49161.99071   5.594141e+10  49268.469891  54727.375681   \n",
       "\n",
       "             ma_close_15   ma_close_30         ema_5        ema_15  \\\n",
       "dates                                                                \n",
       "2021-12-05  56435.925442  59753.464608  53605.222889  56297.338312   \n",
       "\n",
       "                  ema_30  rsi_sma_7  rsi_sma_14  rsi_sma_21  \\\n",
       "dates                                                         \n",
       "2021-12-05  57905.964223  28.197488    28.50404   29.850475   \n",
       "\n",
       "            bollinger_upper_5  bollinger_lower_5  bollinger_upper_10  \\\n",
       "dates                                                                  \n",
       "2021-12-05       61525.235977       47929.515385        61290.776455   \n",
       "\n",
       "            bollinger_lower_10  bollinger_upper_20  bollinger_lower_20  \\\n",
       "dates                                                                    \n",
       "2021-12-05        49905.694907        63509.165535        51187.985795   \n",
       "\n",
       "            pricesminus1  total_volumesminus1  ma_close_5minus1  \\\n",
       "dates                                                             \n",
       "2021-12-05  53785.967172         3.952711e+10      56464.732246   \n",
       "\n",
       "            ma_close_15minus1  ma_close_30minus1   ema_5minus1  ema_15minus1  \\\n",
       "dates                                                                          \n",
       "2021-12-05       57055.743096       60168.123037  55826.838978  57316.673683   \n",
       "\n",
       "            ema_30minus1  rsi_sma_7minus1  rsi_sma_14minus1  rsi_sma_21minus1  \\\n",
       "dates                                                                           \n",
       "2021-12-05  58508.996879        49.751037         39.569458         34.372794   \n",
       "\n",
       "            bollinger_upper_5minus1  bollinger_lower_5minus1  \\\n",
       "dates                                                          \n",
       "2021-12-05             59609.327629             53320.136863   \n",
       "\n",
       "            bollinger_upper_10minus1  bollinger_lower_10minus1  \\\n",
       "dates                                                            \n",
       "2021-12-05              59903.463566              52900.246423   \n",
       "\n",
       "            bollinger_upper_20minus1  bollinger_lower_20minus1  pricesminus2  \\\n",
       "dates                                                                          \n",
       "2021-12-05              64129.992223              52215.857816  56508.268054   \n",
       "\n",
       "            total_volumesminus2  ma_close_5minus2  ma_close_15minus2  \\\n",
       "dates                                                                  \n",
       "2021-12-05         3.629634e+10      57155.071039       57269.166774   \n",
       "\n",
       "            ma_close_30minus2   ema_5minus2  ema_15minus2  ema_30minus2  \\\n",
       "dates                                                                     \n",
       "2021-12-05        60479.62221  56847.274881  57821.060328  58834.723066   \n",
       "\n",
       "            rsi_sma_7minus2  rsi_sma_14minus2  rsi_sma_21minus2  \\\n",
       "dates                                                             \n",
       "2021-12-05        38.883325         48.867568         36.687047   \n",
       "\n",
       "            bollinger_upper_5minus2  bollinger_lower_5minus2  \\\n",
       "dates                                                          \n",
       "2021-12-05             58118.024115             56192.117964   \n",
       "\n",
       "            bollinger_upper_10minus2  bollinger_lower_10minus2  \\\n",
       "dates                                                            \n",
       "2021-12-05              59852.374375              53743.900815   \n",
       "\n",
       "            bollinger_upper_20minus2  bollinger_lower_20minus2  pricesminus3  \\\n",
       "dates                                                                          \n",
       "2021-12-05              64965.686899              52467.599958  57169.371994   \n",
       "\n",
       "            total_volumesminus3  ma_close_5minus3  ma_close_15minus3  \\\n",
       "dates                                                                  \n",
       "2021-12-05         4.938307e+10      56760.098205       57542.192628   \n",
       "\n",
       "            ma_close_30minus3   ema_5minus3  ema_15minus3  ema_30minus3  \\\n",
       "dates                                                                     \n",
       "2021-12-05       60704.253573  57016.778295  58008.602081  58995.168239   \n",
       "\n",
       "            rsi_sma_7minus3  rsi_sma_14minus3  rsi_sma_21minus3  \\\n",
       "dates                                                             \n",
       "2021-12-05        49.877774         42.876941         37.396801   \n",
       "\n",
       "            bollinger_upper_5minus3  bollinger_lower_5minus3  \\\n",
       "dates                                                          \n",
       "2021-12-05             59329.542796             54190.653614   \n",
       "\n",
       "            bollinger_upper_10minus3  bollinger_lower_10minus3  \\\n",
       "dates                                                            \n",
       "2021-12-05              59846.313715              53725.679234   \n",
       "\n",
       "            bollinger_upper_20minus3  bollinger_lower_20minus3  pricesminus4  \\\n",
       "dates                                                                          \n",
       "2021-12-05              65764.143304              52461.521542  57011.280474   \n",
       "\n",
       "            total_volumesminus4  ma_close_5minus4  ma_close_15minus4  \\\n",
       "dates                                                                  \n",
       "2021-12-05         3.572304e+10      56091.782379       57760.805329   \n",
       "\n",
       "            ma_close_30minus4   ema_5minus4  ema_15minus4  ema_30minus4  \\\n",
       "dates                                                                     \n",
       "2021-12-05       60836.002213  56940.481446  58128.492094  59121.085222   \n",
       "\n",
       "            rsi_sma_7minus4  rsi_sma_14minus4  rsi_sma_21minus4  \\\n",
       "dates                                                             \n",
       "2021-12-05        46.972146         42.869836         34.753644   \n",
       "\n",
       "            bollinger_upper_5minus4  bollinger_lower_5minus4  \\\n",
       "dates                                                          \n",
       "2021-12-05             59669.452691             52514.112067   \n",
       "\n",
       "            bollinger_upper_10minus4  bollinger_lower_10minus4  \\\n",
       "dates                                                            \n",
       "2021-12-05              60387.448383              53578.626023   \n",
       "\n",
       "            bollinger_upper_20minus4  bollinger_lower_20minus4  pricesminus5  \\\n",
       "dates                                                                          \n",
       "2021-12-05              66583.414079              52425.878084  57848.773537   \n",
       "\n",
       "            total_volumesminus5  ma_close_5minus5  ma_close_15minus5  \\\n",
       "dates                                                                  \n",
       "2021-12-05         3.098520e+10      56469.095681       58222.308994   \n",
       "\n",
       "            ma_close_30minus5   ema_5minus5  ema_15minus5  ema_30minus5  \\\n",
       "dates                                                                     \n",
       "2021-12-05        60984.68848  56905.081931  58288.093754  59266.588997   \n",
       "\n",
       "            rsi_sma_7minus5  rsi_sma_14minus5  rsi_sma_21minus5  \\\n",
       "dates                                                             \n",
       "2021-12-05        55.754108         38.626727         35.140478   \n",
       "\n",
       "            bollinger_upper_5minus5  bollinger_lower_5minus5  \\\n",
       "dates                                                          \n",
       "2021-12-05             60841.328525             52096.862837   \n",
       "\n",
       "            bollinger_upper_10minus5  bollinger_lower_10minus5  \\\n",
       "dates                                                            \n",
       "2021-12-05              61219.716382              53360.684263   \n",
       "\n",
       "            bollinger_upper_20minus5  bollinger_lower_20minus5  pricesminus6  \\\n",
       "dates                                                                          \n",
       "2021-12-05              67297.518304              52516.751253  57237.661137   \n",
       "\n",
       "            total_volumesminus6  ma_close_5minus6  ma_close_15minus6  \\\n",
       "dates                                                                  \n",
       "2021-12-05         2.765946e+10      56338.977743       58742.322611   \n",
       "\n",
       "            ma_close_30minus6   ema_5minus6  ema_15minus6  ema_30minus6  \\\n",
       "dates                                                                     \n",
       "2021-12-05       61117.637929  56433.236129  58350.853784  59364.369374   \n",
       "\n",
       "            rsi_sma_7minus6  rsi_sma_14minus6  rsi_sma_21minus6  \\\n",
       "dates                                                             \n",
       "2021-12-05        43.593428         34.901938         41.945316   \n",
       "\n",
       "            bollinger_upper_5minus6  bollinger_lower_5minus6  \\\n",
       "dates                                                          \n",
       "2021-12-05             60541.337225             52136.618261   \n",
       "\n",
       "            bollinger_upper_10minus6  bollinger_lower_10minus6  \\\n",
       "dates                                                            \n",
       "2021-12-05              61337.886437              53364.610604   \n",
       "\n",
       "            bollinger_upper_20minus6  bollinger_lower_20minus6  pricesminus7  \\\n",
       "dates                                                                          \n",
       "2021-12-05              68362.331822              52381.597874  54533.403882   \n",
       "\n",
       "            total_volumesminus7  ma_close_5minus7  ma_close_15minus7  \\\n",
       "dates                                                                  \n",
       "2021-12-05         2.825685e+10       56441.20415       59237.167558   \n",
       "\n",
       "            ma_close_30minus7   ema_5minus7  ema_15minus7  ema_30minus7  \\\n",
       "dates                                                                     \n",
       "2021-12-05       61285.822492  56031.023624  58509.881305  59511.038907   \n",
       "\n",
       "            rsi_sma_7minus7  rsi_sma_14minus7  rsi_sma_21minus7  \\\n",
       "dates                                                             \n",
       "2021-12-05        28.792655         30.629437         39.963147   \n",
       "\n",
       "            bollinger_upper_5minus7  bollinger_lower_5minus7  \\\n",
       "dates                                                          \n",
       "2021-12-05              60775.66164              52106.74666   \n",
       "\n",
       "            bollinger_upper_10minus7  bollinger_lower_10minus7  \\\n",
       "dates                                                            \n",
       "2021-12-05              61319.161614              53333.267667   \n",
       "\n",
       "            bollinger_upper_20minus7  bollinger_lower_20minus7  pricesminus8  \\\n",
       "dates                                                                          \n",
       "2021-12-05              69358.190632              52423.674505  53827.792865   \n",
       "\n",
       "            total_volumesminus8  ma_close_5minus8  ma_close_15minus8  \\\n",
       "dates                                                                  \n",
       "2021-12-05         4.132581e+10      56811.894744       59897.077163   \n",
       "\n",
       "            ma_close_30minus8   ema_5minus8  ema_15minus8  ema_30minus8  \\\n",
       "dates                                                                     \n",
       "2021-12-05       61493.627558  56779.833495  59077.949509  59854.324081   \n",
       "\n",
       "            rsi_sma_7minus8  rsi_sma_14minus8  rsi_sma_21minus8  \\\n",
       "dates                                                             \n",
       "2021-12-05        33.461394          29.33915         39.465977   \n",
       "\n",
       "            bollinger_upper_5minus8  bollinger_lower_5minus8  \\\n",
       "dates                                                          \n",
       "2021-12-05             60615.013979             53008.775509   \n",
       "\n",
       "            bollinger_upper_10minus8  bollinger_lower_10minus8  \\\n",
       "dates                                                            \n",
       "2021-12-05              61884.621628               53981.85805   \n",
       "\n",
       "            bollinger_upper_20minus8  bollinger_lower_20minus8  pricesminus9  \\\n",
       "dates                                                                          \n",
       "2021-12-05              69289.402915              53354.444853  58897.846983   \n",
       "\n",
       "            total_volumesminus9  ma_close_5minus9  ma_close_15minus9  \\\n",
       "dates                                                                  \n",
       "2021-12-05         3.372110e+10      57874.292027       60642.267316   \n",
       "\n",
       "            ma_close_30minus9  ema_5minus9  ema_15minus9  ema_30minus9  \\\n",
       "dates                                                                    \n",
       "2021-12-05       61654.067845  58255.85381  59827.971886  60269.946924   \n",
       "\n",
       "            rsi_sma_7minus9  rsi_sma_14minus9  rsi_sma_21minus9  \\\n",
       "dates                                                             \n",
       "2021-12-05        59.181813         35.571827         45.567613   \n",
       "\n",
       "            bollinger_upper_5minus9  bollinger_lower_5minus9  \\\n",
       "dates                                                          \n",
       "2021-12-05             60183.936668             55564.647387   \n",
       "\n",
       "            bollinger_upper_10minus9  bollinger_lower_10minus9  \\\n",
       "dates                                                            \n",
       "2021-12-05              61593.011089              55597.622519   \n",
       "\n",
       "            bollinger_upper_20minus9  bollinger_lower_20minus9  pricesminus10  \\\n",
       "dates                                                                           \n",
       "2021-12-05              68857.512479              54569.691869   57198.183846   \n",
       "\n",
       "            total_volumesminus10  ma_close_5minus10  ma_close_15minus10  \\\n",
       "dates                                                                     \n",
       "2021-12-05          3.169537e+10       58111.304964         61053.14781   \n",
       "\n",
       "            ma_close_30minus10  ema_5minus10  ema_15minus10  ema_30minus10  \\\n",
       "dates                                                                        \n",
       "2021-12-05        61710.945909  57934.857224   59960.846873   60364.574506   \n",
       "\n",
       "            rsi_sma_7minus10  rsi_sma_14minus10  rsi_sma_21minus10  \\\n",
       "dates                                                                \n",
       "2021-12-05         36.179678          29.861481          40.220013   \n",
       "\n",
       "            bollinger_upper_5minus10  bollinger_lower_5minus10  \\\n",
       "dates                                                            \n",
       "2021-12-05              61091.895288              55130.714641   \n",
       "\n",
       "            bollinger_upper_10minus10  bollinger_lower_10minus10  \\\n",
       "dates                                                              \n",
       "2021-12-05               63624.940326               54572.890974   \n",
       "\n",
       "            bollinger_upper_20minus10  bollinger_lower_20minus10  \\\n",
       "dates                                                              \n",
       "2021-12-05               68856.315886               54805.842258   \n",
       "\n",
       "            pricesminus11  total_volumesminus11  ma_close_5minus11  \\\n",
       "dates                                                                \n",
       "2021-12-05   57748.793174          3.642119e+10       58363.519298   \n",
       "\n",
       "            ma_close_15minus11  ma_close_30minus11  ema_5minus11  \\\n",
       "dates                                                              \n",
       "2021-12-05        61716.293883        61911.946908  58303.193913   \n",
       "\n",
       "            ema_15minus11  ema_30minus11  rsi_sma_7minus11  rsi_sma_14minus11  \\\n",
       "dates                                                                           \n",
       "2021-12-05   60355.513019   60582.946276         38.680219          27.686349   \n",
       "\n",
       "            rsi_sma_21minus11  bollinger_upper_5minus11  \\\n",
       "dates                                                     \n",
       "2021-12-05          40.804333               61165.86434   \n",
       "\n",
       "            bollinger_lower_5minus11  bollinger_upper_10minus11  \\\n",
       "dates                                                             \n",
       "2021-12-05              55561.174256                65840.88554   \n",
       "\n",
       "            bollinger_lower_10minus11  bollinger_upper_20minus11  \\\n",
       "dates                                                              \n",
       "2021-12-05               54047.104549               68732.741026   \n",
       "\n",
       "            bollinger_lower_20minus11  pricesminus12  total_volumesminus12  \\\n",
       "dates                                                                        \n",
       "2021-12-05                55369.77309   56386.856853          3.400147e+10   \n",
       "\n",
       "            ma_close_5minus12  ma_close_15minus12  ma_close_30minus12  \\\n",
       "dates                                                                   \n",
       "2021-12-05       58211.225131        62374.175374        62026.092682   \n",
       "\n",
       "            ema_5minus12  ema_15minus12  ema_30minus12  rsi_sma_7minus12  \\\n",
       "dates                                                                      \n",
       "2021-12-05  58580.394282   60727.901569    60778.40511         23.139259   \n",
       "\n",
       "            rsi_sma_14minus12  rsi_sma_21minus12  bollinger_upper_5minus12  \\\n",
       "dates                                                                        \n",
       "2021-12-05           22.15486          42.278309              61253.132433   \n",
       "\n",
       "            bollinger_lower_5minus12  bollinger_upper_10minus12  \\\n",
       "dates                                                             \n",
       "2021-12-05               55169.31783               66990.828351   \n",
       "\n",
       "            bollinger_lower_10minus12  bollinger_upper_20minus12  \\\n",
       "dates                                                              \n",
       "2021-12-05               54279.470173               68698.893162   \n",
       "\n",
       "            bollinger_lower_20minus12  pricesminus13  total_volumesminus13  \\\n",
       "dates                                                                        \n",
       "2021-12-05               55941.835872    59139.77928          2.574343e+10   \n",
       "\n",
       "            ma_close_5minus13  ma_close_15minus13  ma_close_30minus13  \\\n",
       "dates                                                                   \n",
       "2021-12-05       59054.584934         62825.26693        62198.935468   \n",
       "\n",
       "            ema_5minus13  ema_15minus13  ema_30minus13  rsi_sma_7minus13  \\\n",
       "dates                                                                      \n",
       "2021-12-05  59677.162996   61348.050814   61081.270507         24.984948   \n",
       "\n",
       "            rsi_sma_14minus13  rsi_sma_21minus13  bollinger_upper_5minus13  \\\n",
       "dates                                                                        \n",
       "2021-12-05          40.826921          45.873479              61899.286405   \n",
       "\n",
       "            bollinger_lower_5minus13  bollinger_upper_10minus13  \\\n",
       "dates                                                             \n",
       "2021-12-05              56209.883463                67431.66002   \n",
       "\n",
       "            bollinger_lower_10minus13  bollinger_upper_20minus13  \\\n",
       "dates                                                              \n",
       "2021-12-05               55447.676724               68404.389504   \n",
       "\n",
       "            bollinger_lower_20minus13  pricesminus14  total_volumesminus14  \\\n",
       "dates                                                                        \n",
       "2021-12-05               56922.374741   60082.911668          2.967655e+10   \n",
       "\n",
       "            ma_close_5minus14  ma_close_15minus14  ma_close_30minus14  \\\n",
       "dates                                                                   \n",
       "2021-12-05       59316.341581        62993.372223        62261.918523   \n",
       "\n",
       "            ema_5minus14  ema_15minus14  ema_30minus14  rsi_sma_7minus14  \\\n",
       "dates                                                                      \n",
       "2021-12-05  59945.854855   61663.518176   61215.166454         32.470137   \n",
       "\n",
       "            rsi_sma_14minus14  rsi_sma_21minus14  bollinger_upper_5minus14  \\\n",
       "dates                                                                        \n",
       "2021-12-05          46.480606          46.830976              62428.520747   \n",
       "\n",
       "            bollinger_lower_5minus14  bollinger_upper_10minus14  \\\n",
       "dates                                                             \n",
       "2021-12-05              56204.162415               68164.288708   \n",
       "\n",
       "            bollinger_lower_10minus14  bollinger_upper_20minus14  \\\n",
       "dates                                                              \n",
       "2021-12-05               55888.221212               68312.642859   \n",
       "\n",
       "            bollinger_lower_20minus14  \n",
       "dates                                  \n",
       "2021-12-05               57212.326578  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Train\n",
    "train = df.iloc[len(df) - past_t - 1 : len(df) - 1]\n",
    "print(\"Shape: \" + str(train.shape))\n",
    "train.tail(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "fdafb928-0370-4a9e-9df6-fc527ff3cb40",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shape: (1, 256)\n"
     ]
    },
    {
     "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>prices</th>\n",
       "      <th>total_volumes</th>\n",
       "      <th>y</th>\n",
       "      <th>ma_close_5</th>\n",
       "      <th>ma_close_15</th>\n",
       "      <th>ma_close_30</th>\n",
       "      <th>ema_5</th>\n",
       "      <th>ema_15</th>\n",
       "      <th>ema_30</th>\n",
       "      <th>rsi_sma_7</th>\n",
       "      <th>rsi_sma_14</th>\n",
       "      <th>rsi_sma_21</th>\n",
       "      <th>bollinger_upper_5</th>\n",
       "      <th>bollinger_lower_5</th>\n",
       "      <th>bollinger_upper_10</th>\n",
       "      <th>bollinger_lower_10</th>\n",
       "      <th>bollinger_upper_20</th>\n",
       "      <th>bollinger_lower_20</th>\n",
       "      <th>pricesminus1</th>\n",
       "      <th>total_volumesminus1</th>\n",
       "      <th>ma_close_5minus1</th>\n",
       "      <th>ma_close_15minus1</th>\n",
       "      <th>ma_close_30minus1</th>\n",
       "      <th>ema_5minus1</th>\n",
       "      <th>ema_15minus1</th>\n",
       "      <th>ema_30minus1</th>\n",
       "      <th>rsi_sma_7minus1</th>\n",
       "      <th>rsi_sma_14minus1</th>\n",
       "      <th>rsi_sma_21minus1</th>\n",
       "      <th>bollinger_upper_5minus1</th>\n",
       "      <th>bollinger_lower_5minus1</th>\n",
       "      <th>bollinger_upper_10minus1</th>\n",
       "      <th>bollinger_lower_10minus1</th>\n",
       "      <th>bollinger_upper_20minus1</th>\n",
       "      <th>bollinger_lower_20minus1</th>\n",
       "      <th>pricesminus2</th>\n",
       "      <th>total_volumesminus2</th>\n",
       "      <th>ma_close_5minus2</th>\n",
       "      <th>ma_close_15minus2</th>\n",
       "      <th>ma_close_30minus2</th>\n",
       "      <th>ema_5minus2</th>\n",
       "      <th>ema_15minus2</th>\n",
       "      <th>ema_30minus2</th>\n",
       "      <th>rsi_sma_7minus2</th>\n",
       "      <th>rsi_sma_14minus2</th>\n",
       "      <th>rsi_sma_21minus2</th>\n",
       "      <th>bollinger_upper_5minus2</th>\n",
       "      <th>bollinger_lower_5minus2</th>\n",
       "      <th>bollinger_upper_10minus2</th>\n",
       "      <th>bollinger_lower_10minus2</th>\n",
       "      <th>bollinger_upper_20minus2</th>\n",
       "      <th>bollinger_lower_20minus2</th>\n",
       "      <th>pricesminus3</th>\n",
       "      <th>total_volumesminus3</th>\n",
       "      <th>ma_close_5minus3</th>\n",
       "      <th>ma_close_15minus3</th>\n",
       "      <th>ma_close_30minus3</th>\n",
       "      <th>ema_5minus3</th>\n",
       "      <th>ema_15minus3</th>\n",
       "      <th>ema_30minus3</th>\n",
       "      <th>rsi_sma_7minus3</th>\n",
       "      <th>rsi_sma_14minus3</th>\n",
       "      <th>rsi_sma_21minus3</th>\n",
       "      <th>bollinger_upper_5minus3</th>\n",
       "      <th>bollinger_lower_5minus3</th>\n",
       "      <th>bollinger_upper_10minus3</th>\n",
       "      <th>bollinger_lower_10minus3</th>\n",
       "      <th>bollinger_upper_20minus3</th>\n",
       "      <th>bollinger_lower_20minus3</th>\n",
       "      <th>pricesminus4</th>\n",
       "      <th>total_volumesminus4</th>\n",
       "      <th>ma_close_5minus4</th>\n",
       "      <th>ma_close_15minus4</th>\n",
       "      <th>ma_close_30minus4</th>\n",
       "      <th>ema_5minus4</th>\n",
       "      <th>ema_15minus4</th>\n",
       "      <th>ema_30minus4</th>\n",
       "      <th>rsi_sma_7minus4</th>\n",
       "      <th>rsi_sma_14minus4</th>\n",
       "      <th>rsi_sma_21minus4</th>\n",
       "      <th>bollinger_upper_5minus4</th>\n",
       "      <th>bollinger_lower_5minus4</th>\n",
       "      <th>bollinger_upper_10minus4</th>\n",
       "      <th>bollinger_lower_10minus4</th>\n",
       "      <th>bollinger_upper_20minus4</th>\n",
       "      <th>bollinger_lower_20minus4</th>\n",
       "      <th>pricesminus5</th>\n",
       "      <th>total_volumesminus5</th>\n",
       "      <th>ma_close_5minus5</th>\n",
       "      <th>ma_close_15minus5</th>\n",
       "      <th>ma_close_30minus5</th>\n",
       "      <th>ema_5minus5</th>\n",
       "      <th>ema_15minus5</th>\n",
       "      <th>ema_30minus5</th>\n",
       "      <th>rsi_sma_7minus5</th>\n",
       "      <th>rsi_sma_14minus5</th>\n",
       "      <th>rsi_sma_21minus5</th>\n",
       "      <th>bollinger_upper_5minus5</th>\n",
       "      <th>bollinger_lower_5minus5</th>\n",
       "      <th>bollinger_upper_10minus5</th>\n",
       "      <th>bollinger_lower_10minus5</th>\n",
       "      <th>bollinger_upper_20minus5</th>\n",
       "      <th>bollinger_lower_20minus5</th>\n",
       "      <th>pricesminus6</th>\n",
       "      <th>total_volumesminus6</th>\n",
       "      <th>ma_close_5minus6</th>\n",
       "      <th>ma_close_15minus6</th>\n",
       "      <th>ma_close_30minus6</th>\n",
       "      <th>ema_5minus6</th>\n",
       "      <th>ema_15minus6</th>\n",
       "      <th>ema_30minus6</th>\n",
       "      <th>rsi_sma_7minus6</th>\n",
       "      <th>rsi_sma_14minus6</th>\n",
       "      <th>rsi_sma_21minus6</th>\n",
       "      <th>bollinger_upper_5minus6</th>\n",
       "      <th>bollinger_lower_5minus6</th>\n",
       "      <th>bollinger_upper_10minus6</th>\n",
       "      <th>bollinger_lower_10minus6</th>\n",
       "      <th>bollinger_upper_20minus6</th>\n",
       "      <th>bollinger_lower_20minus6</th>\n",
       "      <th>pricesminus7</th>\n",
       "      <th>total_volumesminus7</th>\n",
       "      <th>ma_close_5minus7</th>\n",
       "      <th>ma_close_15minus7</th>\n",
       "      <th>ma_close_30minus7</th>\n",
       "      <th>ema_5minus7</th>\n",
       "      <th>ema_15minus7</th>\n",
       "      <th>ema_30minus7</th>\n",
       "      <th>rsi_sma_7minus7</th>\n",
       "      <th>rsi_sma_14minus7</th>\n",
       "      <th>rsi_sma_21minus7</th>\n",
       "      <th>bollinger_upper_5minus7</th>\n",
       "      <th>bollinger_lower_5minus7</th>\n",
       "      <th>bollinger_upper_10minus7</th>\n",
       "      <th>bollinger_lower_10minus7</th>\n",
       "      <th>bollinger_upper_20minus7</th>\n",
       "      <th>bollinger_lower_20minus7</th>\n",
       "      <th>pricesminus8</th>\n",
       "      <th>total_volumesminus8</th>\n",
       "      <th>ma_close_5minus8</th>\n",
       "      <th>ma_close_15minus8</th>\n",
       "      <th>ma_close_30minus8</th>\n",
       "      <th>ema_5minus8</th>\n",
       "      <th>ema_15minus8</th>\n",
       "      <th>ema_30minus8</th>\n",
       "      <th>rsi_sma_7minus8</th>\n",
       "      <th>rsi_sma_14minus8</th>\n",
       "      <th>rsi_sma_21minus8</th>\n",
       "      <th>bollinger_upper_5minus8</th>\n",
       "      <th>bollinger_lower_5minus8</th>\n",
       "      <th>bollinger_upper_10minus8</th>\n",
       "      <th>bollinger_lower_10minus8</th>\n",
       "      <th>bollinger_upper_20minus8</th>\n",
       "      <th>bollinger_lower_20minus8</th>\n",
       "      <th>pricesminus9</th>\n",
       "      <th>total_volumesminus9</th>\n",
       "      <th>ma_close_5minus9</th>\n",
       "      <th>ma_close_15minus9</th>\n",
       "      <th>ma_close_30minus9</th>\n",
       "      <th>ema_5minus9</th>\n",
       "      <th>ema_15minus9</th>\n",
       "      <th>ema_30minus9</th>\n",
       "      <th>rsi_sma_7minus9</th>\n",
       "      <th>rsi_sma_14minus9</th>\n",
       "      <th>rsi_sma_21minus9</th>\n",
       "      <th>bollinger_upper_5minus9</th>\n",
       "      <th>bollinger_lower_5minus9</th>\n",
       "      <th>bollinger_upper_10minus9</th>\n",
       "      <th>bollinger_lower_10minus9</th>\n",
       "      <th>bollinger_upper_20minus9</th>\n",
       "      <th>bollinger_lower_20minus9</th>\n",
       "      <th>pricesminus10</th>\n",
       "      <th>total_volumesminus10</th>\n",
       "      <th>ma_close_5minus10</th>\n",
       "      <th>ma_close_15minus10</th>\n",
       "      <th>ma_close_30minus10</th>\n",
       "      <th>ema_5minus10</th>\n",
       "      <th>ema_15minus10</th>\n",
       "      <th>ema_30minus10</th>\n",
       "      <th>rsi_sma_7minus10</th>\n",
       "      <th>rsi_sma_14minus10</th>\n",
       "      <th>rsi_sma_21minus10</th>\n",
       "      <th>bollinger_upper_5minus10</th>\n",
       "      <th>bollinger_lower_5minus10</th>\n",
       "      <th>bollinger_upper_10minus10</th>\n",
       "      <th>bollinger_lower_10minus10</th>\n",
       "      <th>bollinger_upper_20minus10</th>\n",
       "      <th>bollinger_lower_20minus10</th>\n",
       "      <th>pricesminus11</th>\n",
       "      <th>total_volumesminus11</th>\n",
       "      <th>ma_close_5minus11</th>\n",
       "      <th>ma_close_15minus11</th>\n",
       "      <th>ma_close_30minus11</th>\n",
       "      <th>ema_5minus11</th>\n",
       "      <th>ema_15minus11</th>\n",
       "      <th>ema_30minus11</th>\n",
       "      <th>rsi_sma_7minus11</th>\n",
       "      <th>rsi_sma_14minus11</th>\n",
       "      <th>rsi_sma_21minus11</th>\n",
       "      <th>bollinger_upper_5minus11</th>\n",
       "      <th>bollinger_lower_5minus11</th>\n",
       "      <th>bollinger_upper_10minus11</th>\n",
       "      <th>bollinger_lower_10minus11</th>\n",
       "      <th>bollinger_upper_20minus11</th>\n",
       "      <th>bollinger_lower_20minus11</th>\n",
       "      <th>pricesminus12</th>\n",
       "      <th>total_volumesminus12</th>\n",
       "      <th>ma_close_5minus12</th>\n",
       "      <th>ma_close_15minus12</th>\n",
       "      <th>ma_close_30minus12</th>\n",
       "      <th>ema_5minus12</th>\n",
       "      <th>ema_15minus12</th>\n",
       "      <th>ema_30minus12</th>\n",
       "      <th>rsi_sma_7minus12</th>\n",
       "      <th>rsi_sma_14minus12</th>\n",
       "      <th>rsi_sma_21minus12</th>\n",
       "      <th>bollinger_upper_5minus12</th>\n",
       "      <th>bollinger_lower_5minus12</th>\n",
       "      <th>bollinger_upper_10minus12</th>\n",
       "      <th>bollinger_lower_10minus12</th>\n",
       "      <th>bollinger_upper_20minus12</th>\n",
       "      <th>bollinger_lower_20minus12</th>\n",
       "      <th>pricesminus13</th>\n",
       "      <th>total_volumesminus13</th>\n",
       "      <th>ma_close_5minus13</th>\n",
       "      <th>ma_close_15minus13</th>\n",
       "      <th>ma_close_30minus13</th>\n",
       "      <th>ema_5minus13</th>\n",
       "      <th>ema_15minus13</th>\n",
       "      <th>ema_30minus13</th>\n",
       "      <th>rsi_sma_7minus13</th>\n",
       "      <th>rsi_sma_14minus13</th>\n",
       "      <th>rsi_sma_21minus13</th>\n",
       "      <th>bollinger_upper_5minus13</th>\n",
       "      <th>bollinger_lower_5minus13</th>\n",
       "      <th>bollinger_upper_10minus13</th>\n",
       "      <th>bollinger_lower_10minus13</th>\n",
       "      <th>bollinger_upper_20minus13</th>\n",
       "      <th>bollinger_lower_20minus13</th>\n",
       "      <th>pricesminus14</th>\n",
       "      <th>total_volumesminus14</th>\n",
       "      <th>ma_close_5minus14</th>\n",
       "      <th>ma_close_15minus14</th>\n",
       "      <th>ma_close_30minus14</th>\n",
       "      <th>ema_5minus14</th>\n",
       "      <th>ema_15minus14</th>\n",
       "      <th>ema_30minus14</th>\n",
       "      <th>rsi_sma_7minus14</th>\n",
       "      <th>rsi_sma_14minus14</th>\n",
       "      <th>rsi_sma_21minus14</th>\n",
       "      <th>bollinger_upper_5minus14</th>\n",
       "      <th>bollinger_lower_5minus14</th>\n",
       "      <th>bollinger_upper_10minus14</th>\n",
       "      <th>bollinger_lower_10minus14</th>\n",
       "      <th>bollinger_upper_20minus14</th>\n",
       "      <th>bollinger_lower_20minus14</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dates</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-12-06</th>\n",
       "      <td>49268.469891</td>\n",
       "      <td>3.282657e+10</td>\n",
       "      <td>50461.576837</td>\n",
       "      <td>53178.813564</td>\n",
       "      <td>55714.962657</td>\n",
       "      <td>59354.16744</td>\n",
       "      <td>52159.638556</td>\n",
       "      <td>55418.729759</td>\n",
       "      <td>57348.706524</td>\n",
       "      <td>9.008569</td>\n",
       "      <td>29.908276</td>\n",
       "      <td>28.203599</td>\n",
       "      <td>60847.197538</td>\n",
       "      <td>45510.42959</td>\n",
       "      <td>61058.080544</td>\n",
       "      <td>48212.515399</td>\n",
       "      <td>62963.866056</td>\n",
       "      <td>50266.74872</td>\n",
       "      <td>49161.99071</td>\n",
       "      <td>5.594141e+10</td>\n",
       "      <td>54727.375681</td>\n",
       "      <td>56435.925442</td>\n",
       "      <td>59753.464608</td>\n",
       "      <td>53605.222889</td>\n",
       "      <td>56297.338312</td>\n",
       "      <td>57905.964223</td>\n",
       "      <td>28.197488</td>\n",
       "      <td>28.50404</td>\n",
       "      <td>29.850475</td>\n",
       "      <td>61525.235977</td>\n",
       "      <td>47929.515385</td>\n",
       "      <td>61290.776455</td>\n",
       "      <td>49905.694907</td>\n",
       "      <td>63509.165535</td>\n",
       "      <td>51187.985795</td>\n",
       "      <td>53785.967172</td>\n",
       "      <td>3.952711e+10</td>\n",
       "      <td>56464.732246</td>\n",
       "      <td>57055.743096</td>\n",
       "      <td>60168.123037</td>\n",
       "      <td>55826.838978</td>\n",
       "      <td>57316.673683</td>\n",
       "      <td>58508.996879</td>\n",
       "      <td>49.751037</td>\n",
       "      <td>39.569458</td>\n",
       "      <td>34.372794</td>\n",
       "      <td>59609.327629</td>\n",
       "      <td>53320.136863</td>\n",
       "      <td>59903.463566</td>\n",
       "      <td>52900.246423</td>\n",
       "      <td>64129.992223</td>\n",
       "      <td>52215.857816</td>\n",
       "      <td>56508.268054</td>\n",
       "      <td>3.629634e+10</td>\n",
       "      <td>57155.071039</td>\n",
       "      <td>57269.166774</td>\n",
       "      <td>60479.62221</td>\n",
       "      <td>56847.274881</td>\n",
       "      <td>57821.060328</td>\n",
       "      <td>58834.723066</td>\n",
       "      <td>38.883325</td>\n",
       "      <td>48.867568</td>\n",
       "      <td>36.687047</td>\n",
       "      <td>58118.024115</td>\n",
       "      <td>56192.117964</td>\n",
       "      <td>59852.374375</td>\n",
       "      <td>53743.900815</td>\n",
       "      <td>64965.686899</td>\n",
       "      <td>52467.599958</td>\n",
       "      <td>57169.371994</td>\n",
       "      <td>4.938307e+10</td>\n",
       "      <td>56760.098205</td>\n",
       "      <td>57542.192628</td>\n",
       "      <td>60704.253573</td>\n",
       "      <td>57016.778295</td>\n",
       "      <td>58008.602081</td>\n",
       "      <td>58995.168239</td>\n",
       "      <td>49.877774</td>\n",
       "      <td>42.876941</td>\n",
       "      <td>37.396801</td>\n",
       "      <td>59329.542796</td>\n",
       "      <td>54190.653614</td>\n",
       "      <td>59846.313715</td>\n",
       "      <td>53725.679234</td>\n",
       "      <td>65764.143304</td>\n",
       "      <td>52461.521542</td>\n",
       "      <td>57011.280474</td>\n",
       "      <td>3.572304e+10</td>\n",
       "      <td>56091.782379</td>\n",
       "      <td>57760.805329</td>\n",
       "      <td>60836.002213</td>\n",
       "      <td>56940.481446</td>\n",
       "      <td>58128.492094</td>\n",
       "      <td>59121.085222</td>\n",
       "      <td>46.972146</td>\n",
       "      <td>42.869836</td>\n",
       "      <td>34.753644</td>\n",
       "      <td>59669.452691</td>\n",
       "      <td>52514.112067</td>\n",
       "      <td>60387.448383</td>\n",
       "      <td>53578.626023</td>\n",
       "      <td>66583.414079</td>\n",
       "      <td>52425.878084</td>\n",
       "      <td>57848.773537</td>\n",
       "      <td>3.098520e+10</td>\n",
       "      <td>56469.095681</td>\n",
       "      <td>58222.308994</td>\n",
       "      <td>60984.68848</td>\n",
       "      <td>56905.081931</td>\n",
       "      <td>58288.093754</td>\n",
       "      <td>59266.588997</td>\n",
       "      <td>55.754108</td>\n",
       "      <td>38.626727</td>\n",
       "      <td>35.140478</td>\n",
       "      <td>60841.328525</td>\n",
       "      <td>52096.862837</td>\n",
       "      <td>61219.716382</td>\n",
       "      <td>53360.684263</td>\n",
       "      <td>67297.518304</td>\n",
       "      <td>52516.751253</td>\n",
       "      <td>57237.661137</td>\n",
       "      <td>2.765946e+10</td>\n",
       "      <td>56338.977743</td>\n",
       "      <td>58742.322611</td>\n",
       "      <td>61117.637929</td>\n",
       "      <td>56433.236129</td>\n",
       "      <td>58350.853784</td>\n",
       "      <td>59364.369374</td>\n",
       "      <td>43.593428</td>\n",
       "      <td>34.901938</td>\n",
       "      <td>41.945316</td>\n",
       "      <td>60541.337225</td>\n",
       "      <td>52136.618261</td>\n",
       "      <td>61337.886437</td>\n",
       "      <td>53364.610604</td>\n",
       "      <td>68362.331822</td>\n",
       "      <td>52381.597874</td>\n",
       "      <td>54533.403882</td>\n",
       "      <td>2.825685e+10</td>\n",
       "      <td>56441.20415</td>\n",
       "      <td>59237.167558</td>\n",
       "      <td>61285.822492</td>\n",
       "      <td>56031.023624</td>\n",
       "      <td>58509.881305</td>\n",
       "      <td>59511.038907</td>\n",
       "      <td>28.792655</td>\n",
       "      <td>30.629437</td>\n",
       "      <td>39.963147</td>\n",
       "      <td>60775.66164</td>\n",
       "      <td>52106.74666</td>\n",
       "      <td>61319.161614</td>\n",
       "      <td>53333.267667</td>\n",
       "      <td>69358.190632</td>\n",
       "      <td>52423.674505</td>\n",
       "      <td>53827.792865</td>\n",
       "      <td>4.132581e+10</td>\n",
       "      <td>56811.894744</td>\n",
       "      <td>59897.077163</td>\n",
       "      <td>61493.627558</td>\n",
       "      <td>56779.833495</td>\n",
       "      <td>59077.949509</td>\n",
       "      <td>59854.324081</td>\n",
       "      <td>33.461394</td>\n",
       "      <td>29.33915</td>\n",
       "      <td>39.465977</td>\n",
       "      <td>60615.013979</td>\n",
       "      <td>53008.775509</td>\n",
       "      <td>61884.621628</td>\n",
       "      <td>53981.85805</td>\n",
       "      <td>69289.402915</td>\n",
       "      <td>53354.444853</td>\n",
       "      <td>58897.846983</td>\n",
       "      <td>3.372110e+10</td>\n",
       "      <td>57874.292027</td>\n",
       "      <td>60642.267316</td>\n",
       "      <td>61654.067845</td>\n",
       "      <td>58255.85381</td>\n",
       "      <td>59827.971886</td>\n",
       "      <td>60269.946924</td>\n",
       "      <td>59.181813</td>\n",
       "      <td>35.571827</td>\n",
       "      <td>45.567613</td>\n",
       "      <td>60183.936668</td>\n",
       "      <td>55564.647387</td>\n",
       "      <td>61593.011089</td>\n",
       "      <td>55597.622519</td>\n",
       "      <td>68857.512479</td>\n",
       "      <td>54569.691869</td>\n",
       "      <td>57198.183846</td>\n",
       "      <td>3.169537e+10</td>\n",
       "      <td>58111.304964</td>\n",
       "      <td>61053.14781</td>\n",
       "      <td>61710.945909</td>\n",
       "      <td>57934.857224</td>\n",
       "      <td>59960.846873</td>\n",
       "      <td>60364.574506</td>\n",
       "      <td>36.179678</td>\n",
       "      <td>29.861481</td>\n",
       "      <td>40.220013</td>\n",
       "      <td>61091.895288</td>\n",
       "      <td>55130.714641</td>\n",
       "      <td>63624.940326</td>\n",
       "      <td>54572.890974</td>\n",
       "      <td>68856.315886</td>\n",
       "      <td>54805.842258</td>\n",
       "      <td>57748.793174</td>\n",
       "      <td>3.642119e+10</td>\n",
       "      <td>58363.519298</td>\n",
       "      <td>61716.293883</td>\n",
       "      <td>61911.946908</td>\n",
       "      <td>58303.193913</td>\n",
       "      <td>60355.513019</td>\n",
       "      <td>60582.946276</td>\n",
       "      <td>38.680219</td>\n",
       "      <td>27.686349</td>\n",
       "      <td>40.804333</td>\n",
       "      <td>61165.86434</td>\n",
       "      <td>55561.174256</td>\n",
       "      <td>65840.88554</td>\n",
       "      <td>54047.104549</td>\n",
       "      <td>68732.741026</td>\n",
       "      <td>55369.77309</td>\n",
       "      <td>56386.856853</td>\n",
       "      <td>3.400147e+10</td>\n",
       "      <td>58211.225131</td>\n",
       "      <td>62374.175374</td>\n",
       "      <td>62026.092682</td>\n",
       "      <td>58580.394282</td>\n",
       "      <td>60727.901569</td>\n",
       "      <td>60778.40511</td>\n",
       "      <td>23.139259</td>\n",
       "      <td>22.15486</td>\n",
       "      <td>42.278309</td>\n",
       "      <td>61253.132433</td>\n",
       "      <td>55169.31783</td>\n",
       "      <td>66990.828351</td>\n",
       "      <td>54279.470173</td>\n",
       "      <td>68698.893162</td>\n",
       "      <td>55941.835872</td>\n",
       "      <td>59139.77928</td>\n",
       "      <td>2.574343e+10</td>\n",
       "      <td>59054.584934</td>\n",
       "      <td>62825.26693</td>\n",
       "      <td>62198.935468</td>\n",
       "      <td>59677.162996</td>\n",
       "      <td>61348.050814</td>\n",
       "      <td>61081.270507</td>\n",
       "      <td>24.984948</td>\n",
       "      <td>40.826921</td>\n",
       "      <td>45.873479</td>\n",
       "      <td>61899.286405</td>\n",
       "      <td>56209.883463</td>\n",
       "      <td>67431.66002</td>\n",
       "      <td>55447.676724</td>\n",
       "      <td>68404.389504</td>\n",
       "      <td>56922.374741</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  prices  total_volumes             y    ma_close_5  \\\n",
       "dates                                                                 \n",
       "2021-12-06  49268.469891   3.282657e+10  50461.576837  53178.813564   \n",
       "\n",
       "             ma_close_15  ma_close_30         ema_5        ema_15  \\\n",
       "dates                                                               \n",
       "2021-12-06  55714.962657  59354.16744  52159.638556  55418.729759   \n",
       "\n",
       "                  ema_30  rsi_sma_7  rsi_sma_14  rsi_sma_21  \\\n",
       "dates                                                         \n",
       "2021-12-06  57348.706524   9.008569   29.908276   28.203599   \n",
       "\n",
       "            bollinger_upper_5  bollinger_lower_5  bollinger_upper_10  \\\n",
       "dates                                                                  \n",
       "2021-12-06       60847.197538        45510.42959        61058.080544   \n",
       "\n",
       "            bollinger_lower_10  bollinger_upper_20  bollinger_lower_20  \\\n",
       "dates                                                                    \n",
       "2021-12-06        48212.515399        62963.866056         50266.74872   \n",
       "\n",
       "            pricesminus1  total_volumesminus1  ma_close_5minus1  \\\n",
       "dates                                                             \n",
       "2021-12-06   49161.99071         5.594141e+10      54727.375681   \n",
       "\n",
       "            ma_close_15minus1  ma_close_30minus1   ema_5minus1  ema_15minus1  \\\n",
       "dates                                                                          \n",
       "2021-12-06       56435.925442       59753.464608  53605.222889  56297.338312   \n",
       "\n",
       "            ema_30minus1  rsi_sma_7minus1  rsi_sma_14minus1  rsi_sma_21minus1  \\\n",
       "dates                                                                           \n",
       "2021-12-06  57905.964223        28.197488          28.50404         29.850475   \n",
       "\n",
       "            bollinger_upper_5minus1  bollinger_lower_5minus1  \\\n",
       "dates                                                          \n",
       "2021-12-06             61525.235977             47929.515385   \n",
       "\n",
       "            bollinger_upper_10minus1  bollinger_lower_10minus1  \\\n",
       "dates                                                            \n",
       "2021-12-06              61290.776455              49905.694907   \n",
       "\n",
       "            bollinger_upper_20minus1  bollinger_lower_20minus1  pricesminus2  \\\n",
       "dates                                                                          \n",
       "2021-12-06              63509.165535              51187.985795  53785.967172   \n",
       "\n",
       "            total_volumesminus2  ma_close_5minus2  ma_close_15minus2  \\\n",
       "dates                                                                  \n",
       "2021-12-06         3.952711e+10      56464.732246       57055.743096   \n",
       "\n",
       "            ma_close_30minus2   ema_5minus2  ema_15minus2  ema_30minus2  \\\n",
       "dates                                                                     \n",
       "2021-12-06       60168.123037  55826.838978  57316.673683  58508.996879   \n",
       "\n",
       "            rsi_sma_7minus2  rsi_sma_14minus2  rsi_sma_21minus2  \\\n",
       "dates                                                             \n",
       "2021-12-06        49.751037         39.569458         34.372794   \n",
       "\n",
       "            bollinger_upper_5minus2  bollinger_lower_5minus2  \\\n",
       "dates                                                          \n",
       "2021-12-06             59609.327629             53320.136863   \n",
       "\n",
       "            bollinger_upper_10minus2  bollinger_lower_10minus2  \\\n",
       "dates                                                            \n",
       "2021-12-06              59903.463566              52900.246423   \n",
       "\n",
       "            bollinger_upper_20minus2  bollinger_lower_20minus2  pricesminus3  \\\n",
       "dates                                                                          \n",
       "2021-12-06              64129.992223              52215.857816  56508.268054   \n",
       "\n",
       "            total_volumesminus3  ma_close_5minus3  ma_close_15minus3  \\\n",
       "dates                                                                  \n",
       "2021-12-06         3.629634e+10      57155.071039       57269.166774   \n",
       "\n",
       "            ma_close_30minus3   ema_5minus3  ema_15minus3  ema_30minus3  \\\n",
       "dates                                                                     \n",
       "2021-12-06        60479.62221  56847.274881  57821.060328  58834.723066   \n",
       "\n",
       "            rsi_sma_7minus3  rsi_sma_14minus3  rsi_sma_21minus3  \\\n",
       "dates                                                             \n",
       "2021-12-06        38.883325         48.867568         36.687047   \n",
       "\n",
       "            bollinger_upper_5minus3  bollinger_lower_5minus3  \\\n",
       "dates                                                          \n",
       "2021-12-06             58118.024115             56192.117964   \n",
       "\n",
       "            bollinger_upper_10minus3  bollinger_lower_10minus3  \\\n",
       "dates                                                            \n",
       "2021-12-06              59852.374375              53743.900815   \n",
       "\n",
       "            bollinger_upper_20minus3  bollinger_lower_20minus3  pricesminus4  \\\n",
       "dates                                                                          \n",
       "2021-12-06              64965.686899              52467.599958  57169.371994   \n",
       "\n",
       "            total_volumesminus4  ma_close_5minus4  ma_close_15minus4  \\\n",
       "dates                                                                  \n",
       "2021-12-06         4.938307e+10      56760.098205       57542.192628   \n",
       "\n",
       "            ma_close_30minus4   ema_5minus4  ema_15minus4  ema_30minus4  \\\n",
       "dates                                                                     \n",
       "2021-12-06       60704.253573  57016.778295  58008.602081  58995.168239   \n",
       "\n",
       "            rsi_sma_7minus4  rsi_sma_14minus4  rsi_sma_21minus4  \\\n",
       "dates                                                             \n",
       "2021-12-06        49.877774         42.876941         37.396801   \n",
       "\n",
       "            bollinger_upper_5minus4  bollinger_lower_5minus4  \\\n",
       "dates                                                          \n",
       "2021-12-06             59329.542796             54190.653614   \n",
       "\n",
       "            bollinger_upper_10minus4  bollinger_lower_10minus4  \\\n",
       "dates                                                            \n",
       "2021-12-06              59846.313715              53725.679234   \n",
       "\n",
       "            bollinger_upper_20minus4  bollinger_lower_20minus4  pricesminus5  \\\n",
       "dates                                                                          \n",
       "2021-12-06              65764.143304              52461.521542  57011.280474   \n",
       "\n",
       "            total_volumesminus5  ma_close_5minus5  ma_close_15minus5  \\\n",
       "dates                                                                  \n",
       "2021-12-06         3.572304e+10      56091.782379       57760.805329   \n",
       "\n",
       "            ma_close_30minus5   ema_5minus5  ema_15minus5  ema_30minus5  \\\n",
       "dates                                                                     \n",
       "2021-12-06       60836.002213  56940.481446  58128.492094  59121.085222   \n",
       "\n",
       "            rsi_sma_7minus5  rsi_sma_14minus5  rsi_sma_21minus5  \\\n",
       "dates                                                             \n",
       "2021-12-06        46.972146         42.869836         34.753644   \n",
       "\n",
       "            bollinger_upper_5minus5  bollinger_lower_5minus5  \\\n",
       "dates                                                          \n",
       "2021-12-06             59669.452691             52514.112067   \n",
       "\n",
       "            bollinger_upper_10minus5  bollinger_lower_10minus5  \\\n",
       "dates                                                            \n",
       "2021-12-06              60387.448383              53578.626023   \n",
       "\n",
       "            bollinger_upper_20minus5  bollinger_lower_20minus5  pricesminus6  \\\n",
       "dates                                                                          \n",
       "2021-12-06              66583.414079              52425.878084  57848.773537   \n",
       "\n",
       "            total_volumesminus6  ma_close_5minus6  ma_close_15minus6  \\\n",
       "dates                                                                  \n",
       "2021-12-06         3.098520e+10      56469.095681       58222.308994   \n",
       "\n",
       "            ma_close_30minus6   ema_5minus6  ema_15minus6  ema_30minus6  \\\n",
       "dates                                                                     \n",
       "2021-12-06        60984.68848  56905.081931  58288.093754  59266.588997   \n",
       "\n",
       "            rsi_sma_7minus6  rsi_sma_14minus6  rsi_sma_21minus6  \\\n",
       "dates                                                             \n",
       "2021-12-06        55.754108         38.626727         35.140478   \n",
       "\n",
       "            bollinger_upper_5minus6  bollinger_lower_5minus6  \\\n",
       "dates                                                          \n",
       "2021-12-06             60841.328525             52096.862837   \n",
       "\n",
       "            bollinger_upper_10minus6  bollinger_lower_10minus6  \\\n",
       "dates                                                            \n",
       "2021-12-06              61219.716382              53360.684263   \n",
       "\n",
       "            bollinger_upper_20minus6  bollinger_lower_20minus6  pricesminus7  \\\n",
       "dates                                                                          \n",
       "2021-12-06              67297.518304              52516.751253  57237.661137   \n",
       "\n",
       "            total_volumesminus7  ma_close_5minus7  ma_close_15minus7  \\\n",
       "dates                                                                  \n",
       "2021-12-06         2.765946e+10      56338.977743       58742.322611   \n",
       "\n",
       "            ma_close_30minus7   ema_5minus7  ema_15minus7  ema_30minus7  \\\n",
       "dates                                                                     \n",
       "2021-12-06       61117.637929  56433.236129  58350.853784  59364.369374   \n",
       "\n",
       "            rsi_sma_7minus7  rsi_sma_14minus7  rsi_sma_21minus7  \\\n",
       "dates                                                             \n",
       "2021-12-06        43.593428         34.901938         41.945316   \n",
       "\n",
       "            bollinger_upper_5minus7  bollinger_lower_5minus7  \\\n",
       "dates                                                          \n",
       "2021-12-06             60541.337225             52136.618261   \n",
       "\n",
       "            bollinger_upper_10minus7  bollinger_lower_10minus7  \\\n",
       "dates                                                            \n",
       "2021-12-06              61337.886437              53364.610604   \n",
       "\n",
       "            bollinger_upper_20minus7  bollinger_lower_20minus7  pricesminus8  \\\n",
       "dates                                                                          \n",
       "2021-12-06              68362.331822              52381.597874  54533.403882   \n",
       "\n",
       "            total_volumesminus8  ma_close_5minus8  ma_close_15minus8  \\\n",
       "dates                                                                  \n",
       "2021-12-06         2.825685e+10       56441.20415       59237.167558   \n",
       "\n",
       "            ma_close_30minus8   ema_5minus8  ema_15minus8  ema_30minus8  \\\n",
       "dates                                                                     \n",
       "2021-12-06       61285.822492  56031.023624  58509.881305  59511.038907   \n",
       "\n",
       "            rsi_sma_7minus8  rsi_sma_14minus8  rsi_sma_21minus8  \\\n",
       "dates                                                             \n",
       "2021-12-06        28.792655         30.629437         39.963147   \n",
       "\n",
       "            bollinger_upper_5minus8  bollinger_lower_5minus8  \\\n",
       "dates                                                          \n",
       "2021-12-06              60775.66164              52106.74666   \n",
       "\n",
       "            bollinger_upper_10minus8  bollinger_lower_10minus8  \\\n",
       "dates                                                            \n",
       "2021-12-06              61319.161614              53333.267667   \n",
       "\n",
       "            bollinger_upper_20minus8  bollinger_lower_20minus8  pricesminus9  \\\n",
       "dates                                                                          \n",
       "2021-12-06              69358.190632              52423.674505  53827.792865   \n",
       "\n",
       "            total_volumesminus9  ma_close_5minus9  ma_close_15minus9  \\\n",
       "dates                                                                  \n",
       "2021-12-06         4.132581e+10      56811.894744       59897.077163   \n",
       "\n",
       "            ma_close_30minus9   ema_5minus9  ema_15minus9  ema_30minus9  \\\n",
       "dates                                                                     \n",
       "2021-12-06       61493.627558  56779.833495  59077.949509  59854.324081   \n",
       "\n",
       "            rsi_sma_7minus9  rsi_sma_14minus9  rsi_sma_21minus9  \\\n",
       "dates                                                             \n",
       "2021-12-06        33.461394          29.33915         39.465977   \n",
       "\n",
       "            bollinger_upper_5minus9  bollinger_lower_5minus9  \\\n",
       "dates                                                          \n",
       "2021-12-06             60615.013979             53008.775509   \n",
       "\n",
       "            bollinger_upper_10minus9  bollinger_lower_10minus9  \\\n",
       "dates                                                            \n",
       "2021-12-06              61884.621628               53981.85805   \n",
       "\n",
       "            bollinger_upper_20minus9  bollinger_lower_20minus9  pricesminus10  \\\n",
       "dates                                                                           \n",
       "2021-12-06              69289.402915              53354.444853   58897.846983   \n",
       "\n",
       "            total_volumesminus10  ma_close_5minus10  ma_close_15minus10  \\\n",
       "dates                                                                     \n",
       "2021-12-06          3.372110e+10       57874.292027        60642.267316   \n",
       "\n",
       "            ma_close_30minus10  ema_5minus10  ema_15minus10  ema_30minus10  \\\n",
       "dates                                                                        \n",
       "2021-12-06        61654.067845   58255.85381   59827.971886   60269.946924   \n",
       "\n",
       "            rsi_sma_7minus10  rsi_sma_14minus10  rsi_sma_21minus10  \\\n",
       "dates                                                                \n",
       "2021-12-06         59.181813          35.571827          45.567613   \n",
       "\n",
       "            bollinger_upper_5minus10  bollinger_lower_5minus10  \\\n",
       "dates                                                            \n",
       "2021-12-06              60183.936668              55564.647387   \n",
       "\n",
       "            bollinger_upper_10minus10  bollinger_lower_10minus10  \\\n",
       "dates                                                              \n",
       "2021-12-06               61593.011089               55597.622519   \n",
       "\n",
       "            bollinger_upper_20minus10  bollinger_lower_20minus10  \\\n",
       "dates                                                              \n",
       "2021-12-06               68857.512479               54569.691869   \n",
       "\n",
       "            pricesminus11  total_volumesminus11  ma_close_5minus11  \\\n",
       "dates                                                                \n",
       "2021-12-06   57198.183846          3.169537e+10       58111.304964   \n",
       "\n",
       "            ma_close_15minus11  ma_close_30minus11  ema_5minus11  \\\n",
       "dates                                                              \n",
       "2021-12-06         61053.14781        61710.945909  57934.857224   \n",
       "\n",
       "            ema_15minus11  ema_30minus11  rsi_sma_7minus11  rsi_sma_14minus11  \\\n",
       "dates                                                                           \n",
       "2021-12-06   59960.846873   60364.574506         36.179678          29.861481   \n",
       "\n",
       "            rsi_sma_21minus11  bollinger_upper_5minus11  \\\n",
       "dates                                                     \n",
       "2021-12-06          40.220013              61091.895288   \n",
       "\n",
       "            bollinger_lower_5minus11  bollinger_upper_10minus11  \\\n",
       "dates                                                             \n",
       "2021-12-06              55130.714641               63624.940326   \n",
       "\n",
       "            bollinger_lower_10minus11  bollinger_upper_20minus11  \\\n",
       "dates                                                              \n",
       "2021-12-06               54572.890974               68856.315886   \n",
       "\n",
       "            bollinger_lower_20minus11  pricesminus12  total_volumesminus12  \\\n",
       "dates                                                                        \n",
       "2021-12-06               54805.842258   57748.793174          3.642119e+10   \n",
       "\n",
       "            ma_close_5minus12  ma_close_15minus12  ma_close_30minus12  \\\n",
       "dates                                                                   \n",
       "2021-12-06       58363.519298        61716.293883        61911.946908   \n",
       "\n",
       "            ema_5minus12  ema_15minus12  ema_30minus12  rsi_sma_7minus12  \\\n",
       "dates                                                                      \n",
       "2021-12-06  58303.193913   60355.513019   60582.946276         38.680219   \n",
       "\n",
       "            rsi_sma_14minus12  rsi_sma_21minus12  bollinger_upper_5minus12  \\\n",
       "dates                                                                        \n",
       "2021-12-06          27.686349          40.804333               61165.86434   \n",
       "\n",
       "            bollinger_lower_5minus12  bollinger_upper_10minus12  \\\n",
       "dates                                                             \n",
       "2021-12-06              55561.174256                65840.88554   \n",
       "\n",
       "            bollinger_lower_10minus12  bollinger_upper_20minus12  \\\n",
       "dates                                                              \n",
       "2021-12-06               54047.104549               68732.741026   \n",
       "\n",
       "            bollinger_lower_20minus12  pricesminus13  total_volumesminus13  \\\n",
       "dates                                                                        \n",
       "2021-12-06                55369.77309   56386.856853          3.400147e+10   \n",
       "\n",
       "            ma_close_5minus13  ma_close_15minus13  ma_close_30minus13  \\\n",
       "dates                                                                   \n",
       "2021-12-06       58211.225131        62374.175374        62026.092682   \n",
       "\n",
       "            ema_5minus13  ema_15minus13  ema_30minus13  rsi_sma_7minus13  \\\n",
       "dates                                                                      \n",
       "2021-12-06  58580.394282   60727.901569    60778.40511         23.139259   \n",
       "\n",
       "            rsi_sma_14minus13  rsi_sma_21minus13  bollinger_upper_5minus13  \\\n",
       "dates                                                                        \n",
       "2021-12-06           22.15486          42.278309              61253.132433   \n",
       "\n",
       "            bollinger_lower_5minus13  bollinger_upper_10minus13  \\\n",
       "dates                                                             \n",
       "2021-12-06               55169.31783               66990.828351   \n",
       "\n",
       "            bollinger_lower_10minus13  bollinger_upper_20minus13  \\\n",
       "dates                                                              \n",
       "2021-12-06               54279.470173               68698.893162   \n",
       "\n",
       "            bollinger_lower_20minus13  pricesminus14  total_volumesminus14  \\\n",
       "dates                                                                        \n",
       "2021-12-06               55941.835872    59139.77928          2.574343e+10   \n",
       "\n",
       "            ma_close_5minus14  ma_close_15minus14  ma_close_30minus14  \\\n",
       "dates                                                                   \n",
       "2021-12-06       59054.584934         62825.26693        62198.935468   \n",
       "\n",
       "            ema_5minus14  ema_15minus14  ema_30minus14  rsi_sma_7minus14  \\\n",
       "dates                                                                      \n",
       "2021-12-06  59677.162996   61348.050814   61081.270507         24.984948   \n",
       "\n",
       "            rsi_sma_14minus14  rsi_sma_21minus14  bollinger_upper_5minus14  \\\n",
       "dates                                                                        \n",
       "2021-12-06          40.826921          45.873479              61899.286405   \n",
       "\n",
       "            bollinger_lower_5minus14  bollinger_upper_10minus14  \\\n",
       "dates                                                             \n",
       "2021-12-06              56209.883463                67431.66002   \n",
       "\n",
       "            bollinger_lower_10minus14  bollinger_upper_20minus14  \\\n",
       "dates                                                              \n",
       "2021-12-06               55447.676724               68404.389504   \n",
       "\n",
       "            bollinger_lower_20minus14  \n",
       "dates                                  \n",
       "2021-12-06               56922.374741  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Test\n",
    "test = df.iloc[len(df) - 1: len(df)]\n",
    "print(\"Shape: \" + str(test.shape))\n",
    "test.tail(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "02a81224-5a5d-401d-af6f-5062013c9fd3",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Crear pipeline\n",
    "pipeline(train)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "4d07acda-64c9-449f-814a-6794cf0f2bd5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_f73b8_ th {\n",
       "  text-align: left;\n",
       "}\n",
       "#T_f73b8_row0_col0, #T_f73b8_row1_col0, #T_f73b8_row1_col1, #T_f73b8_row1_col2, #T_f73b8_row1_col3, #T_f73b8_row1_col4, #T_f73b8_row1_col5, #T_f73b8_row1_col6, #T_f73b8_row2_col0, #T_f73b8_row2_col1, #T_f73b8_row2_col2, #T_f73b8_row2_col3, #T_f73b8_row2_col4, #T_f73b8_row2_col5, #T_f73b8_row2_col6, #T_f73b8_row3_col0, #T_f73b8_row3_col1, #T_f73b8_row3_col2, #T_f73b8_row3_col3, #T_f73b8_row3_col4, #T_f73b8_row3_col5, #T_f73b8_row3_col6, #T_f73b8_row4_col0, #T_f73b8_row4_col1, #T_f73b8_row4_col2, #T_f73b8_row4_col3, #T_f73b8_row4_col4, #T_f73b8_row4_col5, #T_f73b8_row4_col6, #T_f73b8_row5_col0, #T_f73b8_row5_col1, #T_f73b8_row5_col2, #T_f73b8_row5_col3, #T_f73b8_row5_col4, #T_f73b8_row5_col5, #T_f73b8_row5_col6, #T_f73b8_row6_col0, #T_f73b8_row6_col1, #T_f73b8_row6_col2, #T_f73b8_row6_col3, #T_f73b8_row6_col4, #T_f73b8_row6_col5, #T_f73b8_row6_col6, #T_f73b8_row7_col0, #T_f73b8_row7_col1, #T_f73b8_row7_col2, #T_f73b8_row7_col3, #T_f73b8_row7_col4, #T_f73b8_row7_col5, #T_f73b8_row7_col6, #T_f73b8_row8_col0, #T_f73b8_row8_col1, #T_f73b8_row8_col2, #T_f73b8_row8_col3, #T_f73b8_row8_col4, #T_f73b8_row8_col5, #T_f73b8_row8_col6, #T_f73b8_row9_col0, #T_f73b8_row9_col1, #T_f73b8_row9_col2, #T_f73b8_row9_col3, #T_f73b8_row9_col4, #T_f73b8_row9_col5, #T_f73b8_row9_col6, #T_f73b8_row10_col0, #T_f73b8_row10_col1, #T_f73b8_row10_col2, #T_f73b8_row10_col3, #T_f73b8_row10_col4, #T_f73b8_row10_col5, #T_f73b8_row10_col6, #T_f73b8_row11_col0, #T_f73b8_row11_col1, #T_f73b8_row11_col2, #T_f73b8_row11_col3, #T_f73b8_row11_col4, #T_f73b8_row11_col5, #T_f73b8_row11_col6, #T_f73b8_row12_col0, #T_f73b8_row12_col1, #T_f73b8_row12_col2, #T_f73b8_row12_col3, #T_f73b8_row12_col4, #T_f73b8_row12_col5, #T_f73b8_row12_col6, #T_f73b8_row13_col0, #T_f73b8_row13_col1, #T_f73b8_row13_col2, #T_f73b8_row13_col3, #T_f73b8_row13_col4, #T_f73b8_row13_col5, #T_f73b8_row13_col6, #T_f73b8_row14_col0, #T_f73b8_row14_col1, #T_f73b8_row14_col2, #T_f73b8_row14_col3, #T_f73b8_row14_col4, #T_f73b8_row14_col5, #T_f73b8_row14_col6, #T_f73b8_row15_col0, #T_f73b8_row15_col1, #T_f73b8_row15_col2, #T_f73b8_row15_col3, #T_f73b8_row15_col4, #T_f73b8_row15_col5, #T_f73b8_row15_col6, #T_f73b8_row16_col0, #T_f73b8_row16_col1, #T_f73b8_row16_col2, #T_f73b8_row16_col3, #T_f73b8_row16_col4, #T_f73b8_row16_col5, #T_f73b8_row16_col6 {\n",
       "  text-align: left;\n",
       "}\n",
       "#T_f73b8_row0_col1, #T_f73b8_row0_col2, #T_f73b8_row0_col3, #T_f73b8_row0_col4, #T_f73b8_row0_col5, #T_f73b8_row0_col6 {\n",
       "  text-align: left;\n",
       "  background-color: yellow;\n",
       "}\n",
       "#T_f73b8_row0_col7, #T_f73b8_row1_col7, #T_f73b8_row2_col7, #T_f73b8_row3_col7, #T_f73b8_row4_col7, #T_f73b8_row5_col7, #T_f73b8_row7_col7, #T_f73b8_row8_col7, #T_f73b8_row9_col7, #T_f73b8_row10_col7, #T_f73b8_row11_col7, #T_f73b8_row12_col7, #T_f73b8_row13_col7, #T_f73b8_row14_col7, #T_f73b8_row15_col7, #T_f73b8_row16_col7 {\n",
       "  text-align: left;\n",
       "  background-color: lightgrey;\n",
       "}\n",
       "#T_f73b8_row6_col7 {\n",
       "  text-align: left;\n",
       "  background-color: yellow;\n",
       "  background-color: lightgrey;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_f73b8_\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th class=\"col_heading level0 col0\" >Model</th>\n",
       "      <th class=\"col_heading level0 col1\" >MAE</th>\n",
       "      <th class=\"col_heading level0 col2\" >MSE</th>\n",
       "      <th class=\"col_heading level0 col3\" >RMSE</th>\n",
       "      <th class=\"col_heading level0 col4\" >R2</th>\n",
       "      <th class=\"col_heading level0 col5\" >RMSLE</th>\n",
       "      <th class=\"col_heading level0 col6\" >MAPE</th>\n",
       "      <th class=\"col_heading level0 col7\" >TT (Sec)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row0\" class=\"row_heading level0 row0\" >et</th>\n",
       "      <td id=\"T_f73b8_row0_col0\" class=\"data row0 col0\" >Extra Trees Regressor</td>\n",
       "      <td id=\"T_f73b8_row0_col1\" class=\"data row0 col1\" >1499.4592</td>\n",
       "      <td id=\"T_f73b8_row0_col2\" class=\"data row0 col2\" >4198139.6938</td>\n",
       "      <td id=\"T_f73b8_row0_col3\" class=\"data row0 col3\" >1956.5634</td>\n",
       "      <td id=\"T_f73b8_row0_col4\" class=\"data row0 col4\" >0.9552</td>\n",
       "      <td id=\"T_f73b8_row0_col5\" class=\"data row0 col5\" >0.0413</td>\n",
       "      <td id=\"T_f73b8_row0_col6\" class=\"data row0 col6\" >0.0315</td>\n",
       "      <td id=\"T_f73b8_row0_col7\" class=\"data row0 col7\" >0.1310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row1\" class=\"row_heading level0 row1\" >rf</th>\n",
       "      <td id=\"T_f73b8_row1_col0\" class=\"data row1 col0\" >Random Forest Regressor</td>\n",
       "      <td id=\"T_f73b8_row1_col1\" class=\"data row1 col1\" >1567.8637</td>\n",
       "      <td id=\"T_f73b8_row1_col2\" class=\"data row1 col2\" >4534047.9071</td>\n",
       "      <td id=\"T_f73b8_row1_col3\" class=\"data row1 col3\" >2025.0398</td>\n",
       "      <td id=\"T_f73b8_row1_col4\" class=\"data row1 col4\" >0.9527</td>\n",
       "      <td id=\"T_f73b8_row1_col5\" class=\"data row1 col5\" >0.0431</td>\n",
       "      <td id=\"T_f73b8_row1_col6\" class=\"data row1 col6\" >0.0330</td>\n",
       "      <td id=\"T_f73b8_row1_col7\" class=\"data row1 col7\" >0.1710</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row2\" class=\"row_heading level0 row2\" >lightgbm</th>\n",
       "      <td id=\"T_f73b8_row2_col0\" class=\"data row2 col0\" >Light Gradient Boosting Machine</td>\n",
       "      <td id=\"T_f73b8_row2_col1\" class=\"data row2 col1\" >1622.8655</td>\n",
       "      <td id=\"T_f73b8_row2_col2\" class=\"data row2 col2\" >4577693.8289</td>\n",
       "      <td id=\"T_f73b8_row2_col3\" class=\"data row2 col3\" >2046.1168</td>\n",
       "      <td id=\"T_f73b8_row2_col4\" class=\"data row2 col4\" >0.9520</td>\n",
       "      <td id=\"T_f73b8_row2_col5\" class=\"data row2 col5\" >0.0424</td>\n",
       "      <td id=\"T_f73b8_row2_col6\" class=\"data row2 col6\" >0.0339</td>\n",
       "      <td id=\"T_f73b8_row2_col7\" class=\"data row2 col7\" >0.0210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row3\" class=\"row_heading level0 row3\" >gbr</th>\n",
       "      <td id=\"T_f73b8_row3_col0\" class=\"data row3 col0\" >Gradient Boosting Regressor</td>\n",
       "      <td id=\"T_f73b8_row3_col1\" class=\"data row3 col1\" >1671.6607</td>\n",
       "      <td id=\"T_f73b8_row3_col2\" class=\"data row3 col2\" >4782286.8608</td>\n",
       "      <td id=\"T_f73b8_row3_col3\" class=\"data row3 col3\" >2103.2705</td>\n",
       "      <td id=\"T_f73b8_row3_col4\" class=\"data row3 col4\" >0.9501</td>\n",
       "      <td id=\"T_f73b8_row3_col5\" class=\"data row3 col5\" >0.0440</td>\n",
       "      <td id=\"T_f73b8_row3_col6\" class=\"data row3 col6\" >0.0349</td>\n",
       "      <td id=\"T_f73b8_row3_col7\" class=\"data row3 col7\" >0.0690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row4\" class=\"row_heading level0 row4\" >ada</th>\n",
       "      <td id=\"T_f73b8_row4_col0\" class=\"data row4 col0\" >AdaBoost Regressor</td>\n",
       "      <td id=\"T_f73b8_row4_col1\" class=\"data row4 col1\" >1678.0299</td>\n",
       "      <td id=\"T_f73b8_row4_col2\" class=\"data row4 col2\" >4809592.7576</td>\n",
       "      <td id=\"T_f73b8_row4_col3\" class=\"data row4 col3\" >2093.3086</td>\n",
       "      <td id=\"T_f73b8_row4_col4\" class=\"data row4 col4\" >0.9494</td>\n",
       "      <td id=\"T_f73b8_row4_col5\" class=\"data row4 col5\" >0.0443</td>\n",
       "      <td id=\"T_f73b8_row4_col6\" class=\"data row4 col6\" >0.0353</td>\n",
       "      <td id=\"T_f73b8_row4_col7\" class=\"data row4 col7\" >0.0370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row5\" class=\"row_heading level0 row5\" >catboost</th>\n",
       "      <td id=\"T_f73b8_row5_col0\" class=\"data row5 col0\" >CatBoost Regressor</td>\n",
       "      <td id=\"T_f73b8_row5_col1\" class=\"data row5 col1\" >1690.5057</td>\n",
       "      <td id=\"T_f73b8_row5_col2\" class=\"data row5 col2\" >4867365.7536</td>\n",
       "      <td id=\"T_f73b8_row5_col3\" class=\"data row5 col3\" >2106.7683</td>\n",
       "      <td id=\"T_f73b8_row5_col4\" class=\"data row5 col4\" >0.9490</td>\n",
       "      <td id=\"T_f73b8_row5_col5\" class=\"data row5 col5\" >0.0446</td>\n",
       "      <td id=\"T_f73b8_row5_col6\" class=\"data row5 col6\" >0.0357</td>\n",
       "      <td id=\"T_f73b8_row5_col7\" class=\"data row5 col7\" >10.8240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row6\" class=\"row_heading level0 row6\" >omp</th>\n",
       "      <td id=\"T_f73b8_row6_col0\" class=\"data row6 col0\" >Orthogonal Matching Pursuit</td>\n",
       "      <td id=\"T_f73b8_row6_col1\" class=\"data row6 col1\" >1725.4554</td>\n",
       "      <td id=\"T_f73b8_row6_col2\" class=\"data row6 col2\" >5222416.1068</td>\n",
       "      <td id=\"T_f73b8_row6_col3\" class=\"data row6 col3\" >2230.9482</td>\n",
       "      <td id=\"T_f73b8_row6_col4\" class=\"data row6 col4\" >0.9455</td>\n",
       "      <td id=\"T_f73b8_row6_col5\" class=\"data row6 col5\" >0.0471</td>\n",
       "      <td id=\"T_f73b8_row6_col6\" class=\"data row6 col6\" >0.0364</td>\n",
       "      <td id=\"T_f73b8_row6_col7\" class=\"data row6 col7\" >0.0070</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row7\" class=\"row_heading level0 row7\" >br</th>\n",
       "      <td id=\"T_f73b8_row7_col0\" class=\"data row7 col0\" >Bayesian Ridge</td>\n",
       "      <td id=\"T_f73b8_row7_col1\" class=\"data row7 col1\" >1728.3361</td>\n",
       "      <td id=\"T_f73b8_row7_col2\" class=\"data row7 col2\" >5227423.0504</td>\n",
       "      <td id=\"T_f73b8_row7_col3\" class=\"data row7 col3\" >2189.1846</td>\n",
       "      <td id=\"T_f73b8_row7_col4\" class=\"data row7 col4\" >0.9454</td>\n",
       "      <td id=\"T_f73b8_row7_col5\" class=\"data row7 col5\" >0.0466</td>\n",
       "      <td id=\"T_f73b8_row7_col6\" class=\"data row7 col6\" >0.0368</td>\n",
       "      <td id=\"T_f73b8_row7_col7\" class=\"data row7 col7\" >0.0080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row8\" class=\"row_heading level0 row8\" >llar</th>\n",
       "      <td id=\"T_f73b8_row8_col0\" class=\"data row8 col0\" >Lasso Least Angle Regression</td>\n",
       "      <td id=\"T_f73b8_row8_col1\" class=\"data row8 col1\" >1745.3997</td>\n",
       "      <td id=\"T_f73b8_row8_col2\" class=\"data row8 col2\" >5399842.4969</td>\n",
       "      <td id=\"T_f73b8_row8_col3\" class=\"data row8 col3\" >2247.7109</td>\n",
       "      <td id=\"T_f73b8_row8_col4\" class=\"data row8 col4\" >0.9432</td>\n",
       "      <td id=\"T_f73b8_row8_col5\" class=\"data row8 col5\" >0.0474</td>\n",
       "      <td id=\"T_f73b8_row8_col6\" class=\"data row8 col6\" >0.0370</td>\n",
       "      <td id=\"T_f73b8_row8_col7\" class=\"data row8 col7\" >0.0100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row9\" class=\"row_heading level0 row9\" >en</th>\n",
       "      <td id=\"T_f73b8_row9_col0\" class=\"data row9 col0\" >Elastic Net</td>\n",
       "      <td id=\"T_f73b8_row9_col1\" class=\"data row9 col1\" >1836.7968</td>\n",
       "      <td id=\"T_f73b8_row9_col2\" class=\"data row9 col2\" >5572477.1250</td>\n",
       "      <td id=\"T_f73b8_row9_col3\" class=\"data row9 col3\" >2264.6625</td>\n",
       "      <td id=\"T_f73b8_row9_col4\" class=\"data row9 col4\" >0.9411</td>\n",
       "      <td id=\"T_f73b8_row9_col5\" class=\"data row9 col5\" >0.0479</td>\n",
       "      <td id=\"T_f73b8_row9_col6\" class=\"data row9 col6\" >0.0388</td>\n",
       "      <td id=\"T_f73b8_row9_col7\" class=\"data row9 col7\" >0.0100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row10\" class=\"row_heading level0 row10\" >knn</th>\n",
       "      <td id=\"T_f73b8_row10_col0\" class=\"data row10 col0\" >K Neighbors Regressor</td>\n",
       "      <td id=\"T_f73b8_row10_col1\" class=\"data row10 col1\" >1735.7053</td>\n",
       "      <td id=\"T_f73b8_row10_col2\" class=\"data row10 col2\" >5593376.7875</td>\n",
       "      <td id=\"T_f73b8_row10_col3\" class=\"data row10 col3\" >2270.2292</td>\n",
       "      <td id=\"T_f73b8_row10_col4\" class=\"data row10 col4\" >0.9376</td>\n",
       "      <td id=\"T_f73b8_row10_col5\" class=\"data row10 col5\" >0.0468</td>\n",
       "      <td id=\"T_f73b8_row10_col6\" class=\"data row10 col6\" >0.0364</td>\n",
       "      <td id=\"T_f73b8_row10_col7\" class=\"data row10 col7\" >0.0200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row11\" class=\"row_heading level0 row11\" >ridge</th>\n",
       "      <td id=\"T_f73b8_row11_col0\" class=\"data row11 col0\" >Ridge Regression</td>\n",
       "      <td id=\"T_f73b8_row11_col1\" class=\"data row11 col1\" >1902.4219</td>\n",
       "      <td id=\"T_f73b8_row11_col2\" class=\"data row11 col2\" >6360954.2000</td>\n",
       "      <td id=\"T_f73b8_row11_col3\" class=\"data row11 col3\" >2440.1471</td>\n",
       "      <td id=\"T_f73b8_row11_col4\" class=\"data row11 col4\" >0.9332</td>\n",
       "      <td id=\"T_f73b8_row11_col5\" class=\"data row11 col5\" >0.0511</td>\n",
       "      <td id=\"T_f73b8_row11_col6\" class=\"data row11 col6\" >0.0403</td>\n",
       "      <td id=\"T_f73b8_row11_col7\" class=\"data row11 col7\" >0.0100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row12\" class=\"row_heading level0 row12\" >huber</th>\n",
       "      <td id=\"T_f73b8_row12_col0\" class=\"data row12 col0\" >Huber Regressor</td>\n",
       "      <td id=\"T_f73b8_row12_col1\" class=\"data row12 col1\" >2062.9767</td>\n",
       "      <td id=\"T_f73b8_row12_col2\" class=\"data row12 col2\" >7349468.2027</td>\n",
       "      <td id=\"T_f73b8_row12_col3\" class=\"data row12 col3\" >2623.6859</td>\n",
       "      <td id=\"T_f73b8_row12_col4\" class=\"data row12 col4\" >0.9226</td>\n",
       "      <td id=\"T_f73b8_row12_col5\" class=\"data row12 col5\" >0.0555</td>\n",
       "      <td id=\"T_f73b8_row12_col6\" class=\"data row12 col6\" >0.0440</td>\n",
       "      <td id=\"T_f73b8_row12_col7\" class=\"data row12 col7\" >0.0140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row13\" class=\"row_heading level0 row13\" >par</th>\n",
       "      <td id=\"T_f73b8_row13_col0\" class=\"data row13 col0\" >Passive Aggressive Regressor</td>\n",
       "      <td id=\"T_f73b8_row13_col1\" class=\"data row13 col1\" >2103.8033</td>\n",
       "      <td id=\"T_f73b8_row13_col2\" class=\"data row13 col2\" >7606773.1326</td>\n",
       "      <td id=\"T_f73b8_row13_col3\" class=\"data row13 col3\" >2645.1044</td>\n",
       "      <td id=\"T_f73b8_row13_col4\" class=\"data row13 col4\" >0.9239</td>\n",
       "      <td id=\"T_f73b8_row13_col5\" class=\"data row13 col5\" >0.0566</td>\n",
       "      <td id=\"T_f73b8_row13_col6\" class=\"data row13 col6\" >0.0440</td>\n",
       "      <td id=\"T_f73b8_row13_col7\" class=\"data row13 col7\" >0.0130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row14\" class=\"row_heading level0 row14\" >dt</th>\n",
       "      <td id=\"T_f73b8_row14_col0\" class=\"data row14 col0\" >Decision Tree Regressor</td>\n",
       "      <td id=\"T_f73b8_row14_col1\" class=\"data row14 col1\" >2193.1953</td>\n",
       "      <td id=\"T_f73b8_row14_col2\" class=\"data row14 col2\" >8709637.7002</td>\n",
       "      <td id=\"T_f73b8_row14_col3\" class=\"data row14 col3\" >2871.7533</td>\n",
       "      <td id=\"T_f73b8_row14_col4\" class=\"data row14 col4\" >0.9092</td>\n",
       "      <td id=\"T_f73b8_row14_col5\" class=\"data row14 col5\" >0.0606</td>\n",
       "      <td id=\"T_f73b8_row14_col6\" class=\"data row14 col6\" >0.0463</td>\n",
       "      <td id=\"T_f73b8_row14_col7\" class=\"data row14 col7\" >0.0080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row15\" class=\"row_heading level0 row15\" >lasso</th>\n",
       "      <td id=\"T_f73b8_row15_col0\" class=\"data row15 col0\" >Lasso Regression</td>\n",
       "      <td id=\"T_f73b8_row15_col1\" class=\"data row15 col1\" >2238.7414</td>\n",
       "      <td id=\"T_f73b8_row15_col2\" class=\"data row15 col2\" >9014749.3500</td>\n",
       "      <td id=\"T_f73b8_row15_col3\" class=\"data row15 col3\" >2945.2517</td>\n",
       "      <td id=\"T_f73b8_row15_col4\" class=\"data row15 col4\" >0.9031</td>\n",
       "      <td id=\"T_f73b8_row15_col5\" class=\"data row15 col5\" >0.0616</td>\n",
       "      <td id=\"T_f73b8_row15_col6\" class=\"data row15 col6\" >0.0473</td>\n",
       "      <td id=\"T_f73b8_row15_col7\" class=\"data row15 col7\" >0.2300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_f73b8_level0_row16\" class=\"row_heading level0 row16\" >lr</th>\n",
       "      <td id=\"T_f73b8_row16_col0\" class=\"data row16 col0\" >Linear Regression</td>\n",
       "      <td id=\"T_f73b8_row16_col1\" class=\"data row16 col1\" >3758.4904</td>\n",
       "      <td id=\"T_f73b8_row16_col2\" class=\"data row16 col2\" >23824127.9000</td>\n",
       "      <td id=\"T_f73b8_row16_col3\" class=\"data row16 col3\" >4800.9877</td>\n",
       "      <td id=\"T_f73b8_row16_col4\" class=\"data row16 col4\" >0.7428</td>\n",
       "      <td id=\"T_f73b8_row16_col5\" class=\"data row16 col5\" >0.1031</td>\n",
       "      <td id=\"T_f73b8_row16_col6\" class=\"data row16 col6\" >0.0798</td>\n",
       "      <td id=\"T_f73b8_row16_col7\" class=\"data row16 col7\" >0.4740</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x2219d00fa48>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Modelo\n",
    "metrica = \"MSE\"\n",
    "modelo = compare_models(sort = metrica, exclude = [\"lar\"] ,verbose = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "9b04a9d6-1f9c-4363-86a4-abdd1d279c03",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_8fa9d_row10_col0, #T_8fa9d_row10_col1, #T_8fa9d_row10_col2, #T_8fa9d_row10_col3, #T_8fa9d_row10_col4, #T_8fa9d_row10_col5 {\n",
       "  background: yellow;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_8fa9d_\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th class=\"col_heading level0 col0\" >MAE</th>\n",
       "      <th class=\"col_heading level0 col1\" >MSE</th>\n",
       "      <th class=\"col_heading level0 col2\" >RMSE</th>\n",
       "      <th class=\"col_heading level0 col3\" >R2</th>\n",
       "      <th class=\"col_heading level0 col4\" >RMSLE</th>\n",
       "      <th class=\"col_heading level0 col5\" >MAPE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_8fa9d_level0_row0\" class=\"row_heading level0 row0\" >0</th>\n",
       "      <td id=\"T_8fa9d_row0_col0\" class=\"data row0 col0\" >1667.0158</td>\n",
       "      <td id=\"T_8fa9d_row0_col1\" class=\"data row0 col1\" >4737315.5233</td>\n",
       "      <td id=\"T_8fa9d_row0_col2\" class=\"data row0 col2\" >2176.5375</td>\n",
       "      <td id=\"T_8fa9d_row0_col3\" class=\"data row0 col3\" >0.9473</td>\n",
       "      <td id=\"T_8fa9d_row0_col4\" class=\"data row0 col4\" >0.0498</td>\n",
       "      <td id=\"T_8fa9d_row0_col5\" class=\"data row0 col5\" >0.0379</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_8fa9d_level0_row1\" class=\"row_heading level0 row1\" >1</th>\n",
       "      <td id=\"T_8fa9d_row1_col0\" class=\"data row1 col0\" >1285.2902</td>\n",
       "      <td id=\"T_8fa9d_row1_col1\" class=\"data row1 col1\" >2784918.9628</td>\n",
       "      <td id=\"T_8fa9d_row1_col2\" class=\"data row1 col2\" >1668.8076</td>\n",
       "      <td id=\"T_8fa9d_row1_col3\" class=\"data row1 col3\" >0.9600</td>\n",
       "      <td id=\"T_8fa9d_row1_col4\" class=\"data row1 col4\" >0.0354</td>\n",
       "      <td id=\"T_8fa9d_row1_col5\" class=\"data row1 col5\" >0.0274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_8fa9d_level0_row2\" class=\"row_heading level0 row2\" >2</th>\n",
       "      <td id=\"T_8fa9d_row2_col0\" class=\"data row2 col0\" >1065.0902</td>\n",
       "      <td id=\"T_8fa9d_row2_col1\" class=\"data row2 col1\" >1895671.0836</td>\n",
       "      <td id=\"T_8fa9d_row2_col2\" class=\"data row2 col2\" >1376.8337</td>\n",
       "      <td id=\"T_8fa9d_row2_col3\" class=\"data row2 col3\" >0.9849</td>\n",
       "      <td id=\"T_8fa9d_row2_col4\" class=\"data row2 col4\" >0.0298</td>\n",
       "      <td id=\"T_8fa9d_row2_col5\" class=\"data row2 col5\" >0.0225</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_8fa9d_level0_row3\" class=\"row_heading level0 row3\" >3</th>\n",
       "      <td id=\"T_8fa9d_row3_col0\" class=\"data row3 col0\" >2393.1049</td>\n",
       "      <td id=\"T_8fa9d_row3_col1\" class=\"data row3 col1\" >8217050.3190</td>\n",
       "      <td id=\"T_8fa9d_row3_col2\" class=\"data row3 col2\" >2866.5398</td>\n",
       "      <td id=\"T_8fa9d_row3_col3\" class=\"data row3 col3\" >0.9260</td>\n",
       "      <td id=\"T_8fa9d_row3_col4\" class=\"data row3 col4\" >0.0590</td>\n",
       "      <td id=\"T_8fa9d_row3_col5\" class=\"data row3 col5\" >0.0474</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_8fa9d_level0_row4\" class=\"row_heading level0 row4\" >4</th>\n",
       "      <td id=\"T_8fa9d_row4_col0\" class=\"data row4 col0\" >1811.4421</td>\n",
       "      <td id=\"T_8fa9d_row4_col1\" class=\"data row4 col1\" >5217759.8799</td>\n",
       "      <td id=\"T_8fa9d_row4_col2\" class=\"data row4 col2\" >2284.2416</td>\n",
       "      <td id=\"T_8fa9d_row4_col3\" class=\"data row4 col3\" >0.9237</td>\n",
       "      <td id=\"T_8fa9d_row4_col4\" class=\"data row4 col4\" >0.0463</td>\n",
       "      <td id=\"T_8fa9d_row4_col5\" class=\"data row4 col5\" >0.0389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_8fa9d_level0_row5\" class=\"row_heading level0 row5\" >5</th>\n",
       "      <td id=\"T_8fa9d_row5_col0\" class=\"data row5 col0\" >884.0542</td>\n",
       "      <td id=\"T_8fa9d_row5_col1\" class=\"data row5 col1\" >1161145.3377</td>\n",
       "      <td id=\"T_8fa9d_row5_col2\" class=\"data row5 col2\" >1077.5645</td>\n",
       "      <td id=\"T_8fa9d_row5_col3\" class=\"data row5 col3\" >0.9915</td>\n",
       "      <td id=\"T_8fa9d_row5_col4\" class=\"data row5 col4\" >0.0259</td>\n",
       "      <td id=\"T_8fa9d_row5_col5\" class=\"data row5 col5\" >0.0208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_8fa9d_level0_row6\" class=\"row_heading level0 row6\" >6</th>\n",
       "      <td id=\"T_8fa9d_row6_col0\" class=\"data row6 col0\" >1389.8439</td>\n",
       "      <td id=\"T_8fa9d_row6_col1\" class=\"data row6 col1\" >2917759.1470</td>\n",
       "      <td id=\"T_8fa9d_row6_col2\" class=\"data row6 col2\" >1708.1449</td>\n",
       "      <td id=\"T_8fa9d_row6_col3\" class=\"data row6 col3\" >0.9700</td>\n",
       "      <td id=\"T_8fa9d_row6_col4\" class=\"data row6 col4\" >0.0369</td>\n",
       "      <td id=\"T_8fa9d_row6_col5\" class=\"data row6 col5\" >0.0292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_8fa9d_level0_row7\" class=\"row_heading level0 row7\" >7</th>\n",
       "      <td id=\"T_8fa9d_row7_col0\" class=\"data row7 col0\" >1842.0765</td>\n",
       "      <td id=\"T_8fa9d_row7_col1\" class=\"data row7 col1\" >7954875.6047</td>\n",
       "      <td id=\"T_8fa9d_row7_col2\" class=\"data row7 col2\" >2820.4389</td>\n",
       "      <td id=\"T_8fa9d_row7_col3\" class=\"data row7 col3\" >0.9128</td>\n",
       "      <td id=\"T_8fa9d_row7_col4\" class=\"data row7 col4\" >0.0564</td>\n",
       "      <td id=\"T_8fa9d_row7_col5\" class=\"data row7 col5\" >0.0389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_8fa9d_level0_row8\" class=\"row_heading level0 row8\" >8</th>\n",
       "      <td id=\"T_8fa9d_row8_col0\" class=\"data row8 col0\" >1136.1549</td>\n",
       "      <td id=\"T_8fa9d_row8_col1\" class=\"data row8 col1\" >1984386.6480</td>\n",
       "      <td id=\"T_8fa9d_row8_col2\" class=\"data row8 col2\" >1408.6826</td>\n",
       "      <td id=\"T_8fa9d_row8_col3\" class=\"data row8 col3\" >0.9777</td>\n",
       "      <td id=\"T_8fa9d_row8_col4\" class=\"data row8 col4\" >0.0304</td>\n",
       "      <td id=\"T_8fa9d_row8_col5\" class=\"data row8 col5\" >0.0233</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_8fa9d_level0_row9\" class=\"row_heading level0 row9\" >9</th>\n",
       "      <td id=\"T_8fa9d_row9_col0\" class=\"data row9 col0\" >2051.4815</td>\n",
       "      <td id=\"T_8fa9d_row9_col1\" class=\"data row9 col1\" >7496634.7433</td>\n",
       "      <td id=\"T_8fa9d_row9_col2\" class=\"data row9 col2\" >2737.9983</td>\n",
       "      <td id=\"T_8fa9d_row9_col3\" class=\"data row9 col3\" >0.9359</td>\n",
       "      <td id=\"T_8fa9d_row9_col4\" class=\"data row9 col4\" >0.0551</td>\n",
       "      <td id=\"T_8fa9d_row9_col5\" class=\"data row9 col5\" >0.0412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_8fa9d_level0_row10\" class=\"row_heading level0 row10\" >Mean</th>\n",
       "      <td id=\"T_8fa9d_row10_col0\" class=\"data row10 col0\" >1552.5554</td>\n",
       "      <td id=\"T_8fa9d_row10_col1\" class=\"data row10 col1\" >4436751.7249</td>\n",
       "      <td id=\"T_8fa9d_row10_col2\" class=\"data row10 col2\" >2012.5790</td>\n",
       "      <td id=\"T_8fa9d_row10_col3\" class=\"data row10 col3\" >0.9530</td>\n",
       "      <td id=\"T_8fa9d_row10_col4\" class=\"data row10 col4\" >0.0425</td>\n",
       "      <td id=\"T_8fa9d_row10_col5\" class=\"data row10 col5\" >0.0328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_8fa9d_level0_row11\" class=\"row_heading level0 row11\" >SD</th>\n",
       "      <td id=\"T_8fa9d_row11_col0\" class=\"data row11 col0\" >455.5445</td>\n",
       "      <td id=\"T_8fa9d_row11_col1\" class=\"data row11 col1\" >2548876.6534</td>\n",
       "      <td id=\"T_8fa9d_row11_col2\" class=\"data row11 col2\" >621.5124</td>\n",
       "      <td id=\"T_8fa9d_row11_col3\" class=\"data row11 col3\" >0.0264</td>\n",
       "      <td id=\"T_8fa9d_row11_col4\" class=\"data row11 col4\" >0.0116</td>\n",
       "      <td id=\"T_8fa9d_row11_col5\" class=\"data row11 col5\" >0.0088</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x221a130e448>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "modelo = tune_model(modelo, search_algorithm = \"tpe\", search_library = \"optuna\", optimize = metrica, n_iter = 10,\n",
    "                    tuner_verbose = False, choose_better = True, verbose = True )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "69c5f57e-b713-4f62-9fa4-42e60762d7c4",
   "metadata": {},
   "outputs": [],
   "source": [
    "final_modelo = finalize_model(modelo)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "4311639a-7980-42a6-aa30-3ff6876855ec",
   "metadata": {},
   "outputs": [],
   "source": [
    "prediccion = predict_model(final_modelo, data = test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "f38149e2-d1c7-4024-a3ea-1275dc530062",
   "metadata": {},
   "outputs": [],
   "source": [
    "import telepot\n",
    "\n",
    "bot_token = '1653124784:AAFpL0qlC_ybadcbFX6jKagauRFpiFpSf1E'\n",
    "chatID = '-1001701018194'\n",
    "\n",
    "bot = telepot.Bot(bot_token)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "ef0fbdd9-c1bb-4026-9f14-40f077ff135e",
   "metadata": {},
   "outputs": [],
   "source": [
    "from datetime import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "6b9f817b-20e6-4238-a400-e83793805d93",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "BTC : 50323.83 USD at 07-12-2021\n"
     ]
    }
   ],
   "source": [
    "mensaje = \"BTC : \" + str(prediccion[\"Label\"][0].round(2)) + \" USD at \" + str(datetime.today().strftime('%d-%m-%Y'))\n",
    "print(mensaje)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "07845515-3a6c-4f53-a68d-acde8e91cd83",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'message_id': 11,\n",
       " 'from': {'id': 1653124784,\n",
       "  'is_bot': True,\n",
       "  'first_name': 'JARVIS',\n",
       "  'username': 'JARVIS_Walkn_bot'},\n",
       " 'chat': {'id': -1001701018194,\n",
       "  'title': 'MoneyIsJustANumber',\n",
       "  'type': 'supergroup'},\n",
       " 'date': 1638907732,\n",
       " 'text': 'BTC : 50323.83 USD at 07-12-2021'}"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "bot.sendMessage(chatID, mensaje)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9cc34fbb-d097-4e82-843b-5c03cfc5b972",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}