grid_search.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "63cad04c",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import datetime\n",
    "\n",
    "from tqdm.notebook import tqdm\n",
    "\n",
    "from simulator import Simulator\n",
    "from strategy import Strategy\n",
    "from typing import Optional"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "d389218c",
   "metadata": {},
   "outputs": [],
   "source": [
    "class GridSearchStrategy(Strategy):\n",
    "    required_rows = 1\n",
    "    def __init__(self, rows, const):\n",
    "        self.required_rows = rows\n",
    "        self.const = const\n",
    "        \n",
    "        \n",
    "    def compute_target_position(self, current_data: pd.DataFrame, current_position: float) -> Optional[float]:\n",
    "        avg_price = current_data['price'].mean()\n",
    "        current_price = current_data['price'][-1]\n",
    "\n",
    "        target_position = current_position + (avg_price - current_price) / self.const\n",
    "\n",
    "        return target_position"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3823f709",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "d3fb0e5f",
   "metadata": {},
   "outputs": [],
   "source": [
    "sim_results2 = pd.read_csv('sim_result.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "2ff8fae6",
   "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>timestamp</th>\n",
       "      <th>cash</th>\n",
       "      <th>position</th>\n",
       "      <th>fee</th>\n",
       "      <th>profit</th>\n",
       "      <th>cumulative_fees</th>\n",
       "      <th>profit_without_fees</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Index(['price', 'volume'], dtype='object')</td>\n",
       "      <td>-2.409403e+04</td>\n",
       "      <td>1.435572</td>\n",
       "      <td>9.633760</td>\n",
       "      <td>-9.633760</td>\n",
       "      <td>9.633760</td>\n",
       "      <td>-1.156408e-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Index(['price', 'volume'], dtype='object')</td>\n",
       "      <td>-4.029120e+04</td>\n",
       "      <td>2.400598</td>\n",
       "      <td>6.476275</td>\n",
       "      <td>-15.277403</td>\n",
       "      <td>16.110035</td>\n",
       "      <td>8.326316e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Index(['price', 'volume'], dtype='object')</td>\n",
       "      <td>-6.047529e+04</td>\n",
       "      <td>3.600738</td>\n",
       "      <td>8.070409</td>\n",
       "      <td>58.152503</td>\n",
       "      <td>24.180443</td>\n",
       "      <td>8.233295e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Index(['price', 'volume'], dtype='object')</td>\n",
       "      <td>-6.596469e+04</td>\n",
       "      <td>3.927293</td>\n",
       "      <td>2.194881</td>\n",
       "      <td>26.647617</td>\n",
       "      <td>26.375324</td>\n",
       "      <td>5.302294e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Index(['price', 'volume'], dtype='object')</td>\n",
       "      <td>-7.172118e+04</td>\n",
       "      <td>4.269874</td>\n",
       "      <td>2.301679</td>\n",
       "      <td>-1.613472</td>\n",
       "      <td>28.677003</td>\n",
       "      <td>2.706353e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125246</th>\n",
       "      <td>Index(['price', 'volume'], dtype='object')</td>\n",
       "      <td>-3.485164e+06</td>\n",
       "      <td>196.757412</td>\n",
       "      <td>0.668347</td>\n",
       "      <td>499791.850713</td>\n",
       "      <td>132539.710832</td>\n",
       "      <td>6.323316e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125247</th>\n",
       "      <td>Index(['price', 'volume'], dtype='object')</td>\n",
       "      <td>-3.481822e+06</td>\n",
       "      <td>196.592278</td>\n",
       "      <td>1.337096</td>\n",
       "      <td>497716.690493</td>\n",
       "      <td>132541.047928</td>\n",
       "      <td>6.302577e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125248</th>\n",
       "      <td>Index(['price', 'volume'], dtype='object')</td>\n",
       "      <td>-3.477450e+06</td>\n",
       "      <td>196.376109</td>\n",
       "      <td>1.749507</td>\n",
       "      <td>495851.246189</td>\n",
       "      <td>132542.797435</td>\n",
       "      <td>6.283940e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125249</th>\n",
       "      <td>Index(['price', 'volume'], dtype='object')</td>\n",
       "      <td>-3.473502e+06</td>\n",
       "      <td>196.180759</td>\n",
       "      <td>1.579737</td>\n",
       "      <td>492636.953302</td>\n",
       "      <td>132544.377173</td>\n",
       "      <td>6.251813e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125250</th>\n",
       "      <td>Index(['price', 'volume'], dtype='object')</td>\n",
       "      <td>-3.469764e+06</td>\n",
       "      <td>195.995839</td>\n",
       "      <td>1.496120</td>\n",
       "      <td>494550.181395</td>\n",
       "      <td>132545.873292</td>\n",
       "      <td>6.270961e+05</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>125251 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         timestamp          cash    position  \\\n",
       "0       Index(['price', 'volume'], dtype='object') -2.409403e+04    1.435572   \n",
       "1       Index(['price', 'volume'], dtype='object') -4.029120e+04    2.400598   \n",
       "2       Index(['price', 'volume'], dtype='object') -6.047529e+04    3.600738   \n",
       "3       Index(['price', 'volume'], dtype='object') -6.596469e+04    3.927293   \n",
       "4       Index(['price', 'volume'], dtype='object') -7.172118e+04    4.269874   \n",
       "...                                            ...           ...         ...   \n",
       "125246  Index(['price', 'volume'], dtype='object') -3.485164e+06  196.757412   \n",
       "125247  Index(['price', 'volume'], dtype='object') -3.481822e+06  196.592278   \n",
       "125248  Index(['price', 'volume'], dtype='object') -3.477450e+06  196.376109   \n",
       "125249  Index(['price', 'volume'], dtype='object') -3.473502e+06  196.180759   \n",
       "125250  Index(['price', 'volume'], dtype='object') -3.469764e+06  195.995839   \n",
       "\n",
       "             fee         profit  cumulative_fees  profit_without_fees  \n",
       "0       9.633760      -9.633760         9.633760        -1.156408e-12  \n",
       "1       6.476275     -15.277403        16.110035         8.326316e-01  \n",
       "2       8.070409      58.152503        24.180443         8.233295e+01  \n",
       "3       2.194881      26.647617        26.375324         5.302294e+01  \n",
       "4       2.301679      -1.613472        28.677003         2.706353e+01  \n",
       "...          ...            ...              ...                  ...  \n",
       "125246  0.668347  499791.850713    132539.710832         6.323316e+05  \n",
       "125247  1.337096  497716.690493    132541.047928         6.302577e+05  \n",
       "125248  1.749507  495851.246189    132542.797435         6.283940e+05  \n",
       "125249  1.579737  492636.953302    132544.377173         6.251813e+05  \n",
       "125250  1.496120  494550.181395    132545.873292         6.270961e+05  \n",
       "\n",
       "[125251 rows x 7 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sim_results2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "cd0ba455",
   "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>cash</th>\n",
       "      <th>position</th>\n",
       "      <th>fee</th>\n",
       "      <th>profit</th>\n",
       "      <th>cumulative_fees</th>\n",
       "      <th>profit_without_fees</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>timestamp</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>[price, volume]</th>\n",
       "      <td>-1.042864e+04</td>\n",
       "      <td>0.621360</td>\n",
       "      <td>4.169789</td>\n",
       "      <td>-4.169789</td>\n",
       "      <td>4.169789</td>\n",
       "      <td>4.414247e-13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>[price, volume]</th>\n",
       "      <td>-2.132331e+04</td>\n",
       "      <td>1.270464</td>\n",
       "      <td>4.356125</td>\n",
       "      <td>-8.165525</td>\n",
       "      <td>8.525914</td>\n",
       "      <td>3.603887e-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>[price, volume]</th>\n",
       "      <td>-3.222645e+04</td>\n",
       "      <td>1.918761</td>\n",
       "      <td>4.359513</td>\n",
       "      <td>30.607213</td>\n",
       "      <td>12.885427</td>\n",
       "      <td>4.349264e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>[price, volume]</th>\n",
       "      <td>-3.771585e+04</td>\n",
       "      <td>2.245317</td>\n",
       "      <td>2.194881</td>\n",
       "      <td>12.793617</td>\n",
       "      <td>15.080308</td>\n",
       "      <td>2.787392e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>[price, volume]</th>\n",
       "      <td>-4.816863e+04</td>\n",
       "      <td>2.867381</td>\n",
       "      <td>4.179440</td>\n",
       "      <td>-6.227367</td>\n",
       "      <td>19.259747</td>\n",
       "      <td>1.303238e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>[price, volume]</th>\n",
       "      <td>2.335252e+06</td>\n",
       "      <td>-97.546187</td>\n",
       "      <td>1.117714</td>\n",
       "      <td>359635.861961</td>\n",
       "      <td>79670.816775</td>\n",
       "      <td>4.393067e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>[price, volume]</th>\n",
       "      <td>2.332164e+06</td>\n",
       "      <td>-97.393669</td>\n",
       "      <td>1.234944</td>\n",
       "      <td>360662.763831</td>\n",
       "      <td>79672.051719</td>\n",
       "      <td>4.403348e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>[price, volume]</th>\n",
       "      <td>2.328865e+06</td>\n",
       "      <td>-97.230702</td>\n",
       "      <td>1.318933</td>\n",
       "      <td>361584.736885</td>\n",
       "      <td>79673.370651</td>\n",
       "      <td>4.412581e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>[price, volume]</th>\n",
       "      <td>2.325379e+06</td>\n",
       "      <td>-97.058341</td>\n",
       "      <td>1.393838</td>\n",
       "      <td>363174.037339</td>\n",
       "      <td>79674.764489</td>\n",
       "      <td>4.428488e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>[price, volume]</th>\n",
       "      <td>2.321562e+06</td>\n",
       "      <td>-96.869708</td>\n",
       "      <td>1.526157</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>79676.290646</td>\n",
       "      <td>4.419015e+05</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>125251 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                         cash   position       fee         profit  \\\n",
       "timestamp                                                           \n",
       "[price, volume] -1.042864e+04   0.621360  4.169789      -4.169789   \n",
       "[price, volume] -2.132331e+04   1.270464  4.356125      -8.165525   \n",
       "[price, volume] -3.222645e+04   1.918761  4.359513      30.607213   \n",
       "[price, volume] -3.771585e+04   2.245317  2.194881      12.793617   \n",
       "[price, volume] -4.816863e+04   2.867381  4.179440      -6.227367   \n",
       "...                       ...        ...       ...            ...   \n",
       "[price, volume]  2.335252e+06 -97.546187  1.117714  359635.861961   \n",
       "[price, volume]  2.332164e+06 -97.393669  1.234944  360662.763831   \n",
       "[price, volume]  2.328865e+06 -97.230702  1.318933  361584.736885   \n",
       "[price, volume]  2.325379e+06 -97.058341  1.393838  363174.037339   \n",
       "[price, volume]  2.321562e+06 -96.869708  1.526157  362225.221776   \n",
       "\n",
       "                 cumulative_fees  profit_without_fees  \n",
       "timestamp                                              \n",
       "[price, volume]         4.169789         4.414247e-13  \n",
       "[price, volume]         8.525914         3.603887e-01  \n",
       "[price, volume]        12.885427         4.349264e+01  \n",
       "[price, volume]        15.080308         2.787392e+01  \n",
       "[price, volume]        19.259747         1.303238e+01  \n",
       "...                          ...                  ...  \n",
       "[price, volume]     79670.816775         4.393067e+05  \n",
       "[price, volume]     79672.051719         4.403348e+05  \n",
       "[price, volume]     79673.370651         4.412581e+05  \n",
       "[price, volume]     79674.764489         4.428488e+05  \n",
       "[price, volume]     79676.290646         4.419015e+05  \n",
       "\n",
       "[125251 rows x 6 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "fa412c3c",
   "metadata": {},
   "outputs": [],
   "source": [
    "strategy = GridSearchStrategy(24*60*2, 1000)\n",
    "\n",
    "t = Simulator(strategy)\n",
    "\n",
    "start_date = datetime.datetime(2022, 1, 1)\n",
    "end_date = datetime.datetime(2022, 3, 30)\n",
    "t.run(start_date, end_date)\n",
    "\n",
    "df = t.get_result_dataframe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "db203ae1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "362225.2217755569"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['profit'][-1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "7e3a701c",
   "metadata": {},
   "outputs": [],
   "source": [
    "rows_space = [(24 * 60 * 24) + 60 * i for i in range(21)]\n",
    "const_space = [100 * i for i in range(1, 26)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "9fc5d83a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "25.0"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "36000 / 60 / 24"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "ffdada1c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "2b22396a28664dfa80ad4841bbd7f9c8",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "  0%|          | 0/21 [00:00<?, ?it/s]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "  0%|          | 0/25 [00:00<?, ?it/s]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "profit: 2370907.6501973555\n",
      "\trow: 34560 const: 100\n",
      "profit: 2523845.205722433\n",
      "\trow: 34560 const: 200\n",
      "profit: 2610710.058833402\n",
      "\trow: 34560 const: 300\n",
      "profit: 2660119.378598712\n",
      "\trow: 34560 const: 400\n",
      "profit: 2692797.8963638307\n",
      "\trow: 34560 const: 500\n",
      "profit: 2740905.2890157844\n",
      "\trow: 34560 const: 600\n",
      "profit: 2763162.940780533\n",
      "\trow: 34560 const: 700\n",
      "profit: 2773252.0038414323\n",
      "\trow: 34560 const: 800\n",
      "profit: 2801040.9281612434\n",
      "\trow: 34560 const: 900\n",
      "profit: 2821780.376883417\n",
      "\trow: 34560 const: 1000\n",
      "profit: 2836105.9452491305\n",
      "\trow: 34560 const: 1100\n",
      "profit: 2853028.0505698896\n",
      "\trow: 34560 const: 1200\n"
     ]
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "  0%|          | 0/25 [00:00<?, ?it/s]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "profit: 2854588.32732709\n",
      "\trow: 34620 const: 1200\n"
     ]
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "  0%|          | 0/25 [00:00<?, ?it/s]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "profit: 2855827.160710689\n",
      "\trow: 34680 const: 1200\n"
     ]
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "  0%|          | 0/25 [00:00<?, ?it/s]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "profit: 2856982.574674458\n",
      "\trow: 34740 const: 1200\n"
     ]
    },
    {
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "6d06659a3d4943fb93098cffb327d94b",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "  0%|          | 0/25 [00:00<?, ?it/s]"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "ename": "KeyboardInterrupt",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m                         Traceback (most recent call last)",
      "Input \u001b[0;32mIn [17]\u001b[0m, in \u001b[0;36m<cell line: 6>\u001b[0;34m()\u001b[0m\n\u001b[1;32m     15\u001b[0m start_date \u001b[38;5;241m=\u001b[39m datetime\u001b[38;5;241m.\u001b[39mdatetime(\u001b[38;5;241m2022\u001b[39m, \u001b[38;5;241m1\u001b[39m, \u001b[38;5;241m1\u001b[39m)\n\u001b[1;32m     16\u001b[0m end_date \u001b[38;5;241m=\u001b[39m datetime\u001b[38;5;241m.\u001b[39mdatetime(\u001b[38;5;241m2022\u001b[39m, \u001b[38;5;241m3\u001b[39m, \u001b[38;5;241m30\u001b[39m)\n\u001b[0;32m---> 17\u001b[0m \u001b[43mt\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mrun\u001b[49m\u001b[43m(\u001b[49m\u001b[43mstart_date\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mend_date\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m     19\u001b[0m df \u001b[38;5;241m=\u001b[39m t\u001b[38;5;241m.\u001b[39mget_result_dataframe()\n\u001b[1;32m     21\u001b[0m stats[row][const] \u001b[38;5;241m=\u001b[39m df[\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mprofit\u001b[39m\u001b[38;5;124m'\u001b[39m][\u001b[38;5;241m-\u001b[39m\u001b[38;5;241m1\u001b[39m]\n",
      "File \u001b[0;32m~/projects/python/CryptoTradingHachathon/simulator.py:38\u001b[0m, in \u001b[0;36mSimulator.run\u001b[0;34m(self, start_date, end_date)\u001b[0m\n\u001b[1;32m     35\u001b[0m current_price \u001b[38;5;241m=\u001b[39m data[\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mprice\u001b[39m\u001b[38;5;124m'\u001b[39m]\n\u001b[1;32m     36\u001b[0m current_volume \u001b[38;5;241m=\u001b[39m data[\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mvolume\u001b[39m\u001b[38;5;124m'\u001b[39m]\n\u001b[0;32m---> 38\u001b[0m target_position \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mmodel\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mcompute_target_position\u001b[49m\u001b[43m(\u001b[49m\u001b[43mcurrent_data\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mcurrent_position\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m     40\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;129;01mnot\u001b[39;00m target_position:\n\u001b[1;32m     41\u001b[0m     \u001b[38;5;28;01mcontinue\u001b[39;00m\n",
      "Input \u001b[0;32mIn [2]\u001b[0m, in \u001b[0;36mGridSearchStrategy.compute_target_position\u001b[0;34m(self, current_data, current_position)\u001b[0m\n\u001b[1;32m      8\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21mcompute_target_position\u001b[39m(\u001b[38;5;28mself\u001b[39m, current_data: pd\u001b[38;5;241m.\u001b[39mDataFrame, current_position: \u001b[38;5;28mfloat\u001b[39m) \u001b[38;5;241m-\u001b[39m\u001b[38;5;241m>\u001b[39m Optional[\u001b[38;5;28mfloat\u001b[39m]:\n\u001b[0;32m----> 9\u001b[0m     avg_price \u001b[38;5;241m=\u001b[39m \u001b[43mcurrent_data\u001b[49m\u001b[43m[\u001b[49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[38;5;124;43mprice\u001b[39;49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[43m]\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mmean\u001b[49m\u001b[43m(\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m     10\u001b[0m     current_price \u001b[38;5;241m=\u001b[39m current_data[\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mprice\u001b[39m\u001b[38;5;124m'\u001b[39m][\u001b[38;5;241m-\u001b[39m\u001b[38;5;241m1\u001b[39m]\n\u001b[1;32m     12\u001b[0m     target_position \u001b[38;5;241m=\u001b[39m current_position \u001b[38;5;241m+\u001b[39m (avg_price \u001b[38;5;241m-\u001b[39m current_price) \u001b[38;5;241m/\u001b[39m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mconst\n",
      "File \u001b[0;32m~/.cache/pypoetry/virtualenvs/hackathon-solution-4mKDkVgl-py3.9/lib/python3.9/site-packages/pandas/core/generic.py:11119\u001b[0m, in \u001b[0;36mNDFrame._add_numeric_operations.<locals>.mean\u001b[0;34m(self, axis, skipna, level, numeric_only, **kwargs)\u001b[0m\n\u001b[1;32m  11101\u001b[0m \u001b[38;5;129m@doc\u001b[39m(\n\u001b[1;32m  11102\u001b[0m     _num_doc,\n\u001b[1;32m  11103\u001b[0m     desc\u001b[38;5;241m=\u001b[39m\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mReturn the mean of the values over the requested axis.\u001b[39m\u001b[38;5;124m\"\u001b[39m,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m  11117\u001b[0m     \u001b[38;5;241m*\u001b[39m\u001b[38;5;241m*\u001b[39mkwargs,\n\u001b[1;32m  11118\u001b[0m ):\n\u001b[0;32m> 11119\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43mNDFrame\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mmean\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;28;43mself\u001b[39;49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43maxis\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mskipna\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mlevel\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mnumeric_only\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43mkwargs\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/.cache/pypoetry/virtualenvs/hackathon-solution-4mKDkVgl-py3.9/lib/python3.9/site-packages/pandas/core/generic.py:10689\u001b[0m, in \u001b[0;36mNDFrame.mean\u001b[0;34m(self, axis, skipna, level, numeric_only, **kwargs)\u001b[0m\n\u001b[1;32m  10681\u001b[0m \u001b[38;5;28;01mdef\u001b[39;00m \u001b[38;5;21mmean\u001b[39m(\n\u001b[1;32m  10682\u001b[0m     \u001b[38;5;28mself\u001b[39m,\n\u001b[1;32m  10683\u001b[0m     axis: Axis \u001b[38;5;241m|\u001b[39m \u001b[38;5;28;01mNone\u001b[39;00m \u001b[38;5;241m|\u001b[39m lib\u001b[38;5;241m.\u001b[39mNoDefault \u001b[38;5;241m=\u001b[39m lib\u001b[38;5;241m.\u001b[39mno_default,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m  10687\u001b[0m     \u001b[38;5;241m*\u001b[39m\u001b[38;5;241m*\u001b[39mkwargs,\n\u001b[1;32m  10688\u001b[0m ) \u001b[38;5;241m-\u001b[39m\u001b[38;5;241m>\u001b[39m Series \u001b[38;5;241m|\u001b[39m \u001b[38;5;28mfloat\u001b[39m:\n\u001b[0;32m> 10689\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_stat_function\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m  10690\u001b[0m \u001b[43m        \u001b[49m\u001b[38;5;124;43m\"\u001b[39;49m\u001b[38;5;124;43mmean\u001b[39;49m\u001b[38;5;124;43m\"\u001b[39;49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mnanops\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mnanmean\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43maxis\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mskipna\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mlevel\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mnumeric_only\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43mkwargs\u001b[49m\n\u001b[1;32m  10691\u001b[0m \u001b[43m    \u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/.cache/pypoetry/virtualenvs/hackathon-solution-4mKDkVgl-py3.9/lib/python3.9/site-packages/pandas/core/generic.py:10641\u001b[0m, in \u001b[0;36mNDFrame._stat_function\u001b[0;34m(self, name, func, axis, skipna, level, numeric_only, **kwargs)\u001b[0m\n\u001b[1;32m  10631\u001b[0m     warnings\u001b[38;5;241m.\u001b[39mwarn(\n\u001b[1;32m  10632\u001b[0m         \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mUsing the level keyword in DataFrame and Series aggregations is \u001b[39m\u001b[38;5;124m\"\u001b[39m\n\u001b[1;32m  10633\u001b[0m         \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mdeprecated and will be removed in a future version. Use groupby \u001b[39m\u001b[38;5;124m\"\u001b[39m\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m  10636\u001b[0m         stacklevel\u001b[38;5;241m=\u001b[39mfind_stack_level(),\n\u001b[1;32m  10637\u001b[0m     )\n\u001b[1;32m  10638\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_agg_by_level(\n\u001b[1;32m  10639\u001b[0m         name, axis\u001b[38;5;241m=\u001b[39maxis, level\u001b[38;5;241m=\u001b[39mlevel, skipna\u001b[38;5;241m=\u001b[39mskipna, numeric_only\u001b[38;5;241m=\u001b[39mnumeric_only\n\u001b[1;32m  10640\u001b[0m     )\n\u001b[0;32m> 10641\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_reduce\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m  10642\u001b[0m \u001b[43m    \u001b[49m\u001b[43mfunc\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mname\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mname\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43maxis\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43maxis\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mskipna\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mskipna\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mnumeric_only\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mnumeric_only\u001b[49m\n\u001b[1;32m  10643\u001b[0m \u001b[43m\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/.cache/pypoetry/virtualenvs/hackathon-solution-4mKDkVgl-py3.9/lib/python3.9/site-packages/pandas/core/series.py:4471\u001b[0m, in \u001b[0;36mSeries._reduce\u001b[0;34m(self, op, name, axis, skipna, numeric_only, filter_type, **kwds)\u001b[0m\n\u001b[1;32m   4467\u001b[0m     \u001b[38;5;28;01mraise\u001b[39;00m \u001b[38;5;167;01mNotImplementedError\u001b[39;00m(\n\u001b[1;32m   4468\u001b[0m         \u001b[38;5;124mf\u001b[39m\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mSeries.\u001b[39m\u001b[38;5;132;01m{\u001b[39;00mname\u001b[38;5;132;01m}\u001b[39;00m\u001b[38;5;124m does not implement \u001b[39m\u001b[38;5;132;01m{\u001b[39;00mkwd_name\u001b[38;5;132;01m}\u001b[39;00m\u001b[38;5;124m.\u001b[39m\u001b[38;5;124m\"\u001b[39m\n\u001b[1;32m   4469\u001b[0m     )\n\u001b[1;32m   4470\u001b[0m \u001b[38;5;28;01mwith\u001b[39;00m np\u001b[38;5;241m.\u001b[39merrstate(\u001b[38;5;28mall\u001b[39m\u001b[38;5;241m=\u001b[39m\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mignore\u001b[39m\u001b[38;5;124m\"\u001b[39m):\n\u001b[0;32m-> 4471\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43mop\u001b[49m\u001b[43m(\u001b[49m\u001b[43mdelegate\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mskipna\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mskipna\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43mkwds\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/.cache/pypoetry/virtualenvs/hackathon-solution-4mKDkVgl-py3.9/lib/python3.9/site-packages/pandas/core/nanops.py:93\u001b[0m, in \u001b[0;36mdisallow.__call__.<locals>._f\u001b[0;34m(*args, **kwargs)\u001b[0m\n\u001b[1;32m     91\u001b[0m \u001b[38;5;28;01mtry\u001b[39;00m:\n\u001b[1;32m     92\u001b[0m     \u001b[38;5;28;01mwith\u001b[39;00m np\u001b[38;5;241m.\u001b[39merrstate(invalid\u001b[38;5;241m=\u001b[39m\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mignore\u001b[39m\u001b[38;5;124m\"\u001b[39m):\n\u001b[0;32m---> 93\u001b[0m         \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43mf\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43margs\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43mkwargs\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m     94\u001b[0m \u001b[38;5;28;01mexcept\u001b[39;00m \u001b[38;5;167;01mValueError\u001b[39;00m \u001b[38;5;28;01mas\u001b[39;00m e:\n\u001b[1;32m     95\u001b[0m     \u001b[38;5;66;03m# we want to transform an object array\u001b[39;00m\n\u001b[1;32m     96\u001b[0m     \u001b[38;5;66;03m# ValueError message to the more typical TypeError\u001b[39;00m\n\u001b[1;32m     97\u001b[0m     \u001b[38;5;66;03m# e.g. this is normally a disallowed function on\u001b[39;00m\n\u001b[1;32m     98\u001b[0m     \u001b[38;5;66;03m# object arrays that contain strings\u001b[39;00m\n\u001b[1;32m     99\u001b[0m     \u001b[38;5;28;01mif\u001b[39;00m is_object_dtype(args[\u001b[38;5;241m0\u001b[39m]):\n",
      "File \u001b[0;32m~/.cache/pypoetry/virtualenvs/hackathon-solution-4mKDkVgl-py3.9/lib/python3.9/site-packages/pandas/core/nanops.py:155\u001b[0m, in \u001b[0;36mbottleneck_switch.__call__.<locals>.f\u001b[0;34m(values, axis, skipna, **kwds)\u001b[0m\n\u001b[1;32m    153\u001b[0m         result \u001b[38;5;241m=\u001b[39m alt(values, axis\u001b[38;5;241m=\u001b[39maxis, skipna\u001b[38;5;241m=\u001b[39mskipna, \u001b[38;5;241m*\u001b[39m\u001b[38;5;241m*\u001b[39mkwds)\n\u001b[1;32m    154\u001b[0m \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[0;32m--> 155\u001b[0m     result \u001b[38;5;241m=\u001b[39m \u001b[43malt\u001b[49m\u001b[43m(\u001b[49m\u001b[43mvalues\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43maxis\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43maxis\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mskipna\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mskipna\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43mkwds\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    157\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m result\n",
      "File \u001b[0;32m~/.cache/pypoetry/virtualenvs/hackathon-solution-4mKDkVgl-py3.9/lib/python3.9/site-packages/pandas/core/nanops.py:410\u001b[0m, in \u001b[0;36m_datetimelike_compat.<locals>.new_func\u001b[0;34m(values, axis, skipna, mask, **kwargs)\u001b[0m\n\u001b[1;32m    407\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m datetimelike \u001b[38;5;129;01mand\u001b[39;00m mask \u001b[38;5;129;01mis\u001b[39;00m \u001b[38;5;28;01mNone\u001b[39;00m:\n\u001b[1;32m    408\u001b[0m     mask \u001b[38;5;241m=\u001b[39m isna(values)\n\u001b[0;32m--> 410\u001b[0m result \u001b[38;5;241m=\u001b[39m \u001b[43mfunc\u001b[49m\u001b[43m(\u001b[49m\u001b[43mvalues\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43maxis\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43maxis\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mskipna\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mskipna\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mmask\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mmask\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43mkwargs\u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    412\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m datetimelike:\n\u001b[1;32m    413\u001b[0m     result \u001b[38;5;241m=\u001b[39m _wrap_results(result, orig_values\u001b[38;5;241m.\u001b[39mdtype, fill_value\u001b[38;5;241m=\u001b[39miNaT)\n",
      "File \u001b[0;32m~/.cache/pypoetry/virtualenvs/hackathon-solution-4mKDkVgl-py3.9/lib/python3.9/site-packages/pandas/core/nanops.py:682\u001b[0m, in \u001b[0;36mnanmean\u001b[0;34m(values, axis, skipna, mask)\u001b[0m\n\u001b[1;32m    648\u001b[0m \u001b[38;5;129m@disallow\u001b[39m(PeriodDtype)\n\u001b[1;32m    649\u001b[0m \u001b[38;5;129m@bottleneck_switch\u001b[39m()\n\u001b[1;32m    650\u001b[0m \u001b[38;5;129m@_datetimelike_compat\u001b[39m\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m    656\u001b[0m     mask: npt\u001b[38;5;241m.\u001b[39mNDArray[np\u001b[38;5;241m.\u001b[39mbool_] \u001b[38;5;241m|\u001b[39m \u001b[38;5;28;01mNone\u001b[39;00m \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;01mNone\u001b[39;00m,\n\u001b[1;32m    657\u001b[0m ) \u001b[38;5;241m-\u001b[39m\u001b[38;5;241m>\u001b[39m \u001b[38;5;28mfloat\u001b[39m:\n\u001b[1;32m    658\u001b[0m     \u001b[38;5;124;03m\"\"\"\u001b[39;00m\n\u001b[1;32m    659\u001b[0m \u001b[38;5;124;03m    Compute the mean of the element along an axis ignoring NaNs\u001b[39;00m\n\u001b[1;32m    660\u001b[0m \n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m    680\u001b[0m \u001b[38;5;124;03m    1.5\u001b[39;00m\n\u001b[1;32m    681\u001b[0m \u001b[38;5;124;03m    \"\"\"\u001b[39;00m\n\u001b[0;32m--> 682\u001b[0m     values, mask, dtype, dtype_max, _ \u001b[38;5;241m=\u001b[39m \u001b[43m_get_values\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m    683\u001b[0m \u001b[43m        \u001b[49m\u001b[43mvalues\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mskipna\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mfill_value\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[38;5;241;43m0\u001b[39;49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[43mmask\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mmask\u001b[49m\n\u001b[1;32m    684\u001b[0m \u001b[43m    \u001b[49m\u001b[43m)\u001b[49m\n\u001b[1;32m    685\u001b[0m     dtype_sum \u001b[38;5;241m=\u001b[39m dtype_max\n\u001b[1;32m    686\u001b[0m     dtype_count \u001b[38;5;241m=\u001b[39m np\u001b[38;5;241m.\u001b[39mdtype(np\u001b[38;5;241m.\u001b[39mfloat64)\n",
      "File \u001b[0;32m~/.cache/pypoetry/virtualenvs/hackathon-solution-4mKDkVgl-py3.9/lib/python3.9/site-packages/pandas/core/nanops.py:340\u001b[0m, in \u001b[0;36m_get_values\u001b[0;34m(values, skipna, fill_value, fill_value_typ, mask)\u001b[0m\n\u001b[1;32m    338\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m is_integer_dtype(dtype) \u001b[38;5;129;01mor\u001b[39;00m is_bool_dtype(dtype):\n\u001b[1;32m    339\u001b[0m     dtype_max \u001b[38;5;241m=\u001b[39m np\u001b[38;5;241m.\u001b[39mdtype(np\u001b[38;5;241m.\u001b[39mint64)\n\u001b[0;32m--> 340\u001b[0m \u001b[38;5;28;01melif\u001b[39;00m \u001b[43mis_float_dtype\u001b[49m(dtype):\n\u001b[1;32m    341\u001b[0m     dtype_max \u001b[38;5;241m=\u001b[39m np\u001b[38;5;241m.\u001b[39mdtype(np\u001b[38;5;241m.\u001b[39mfloat64)\n\u001b[1;32m    343\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m values, mask, dtype, dtype_max, fill_value\n",
      "\u001b[0;31mKeyboardInterrupt\u001b[0m: "
     ]
    }
   ],
   "source": [
    "stats = {}\n",
    "best_row = None\n",
    "best_const = None\n",
    "best_profit = -1e10\n",
    "\n",
    "for row in tqdm(rows_space):\n",
    "    stats[row] = {}\n",
    "    \n",
    "    for const in tqdm(const_space, leave=False):\n",
    "        \n",
    "        strategy = GridSearchStrategy(row, const)\n",
    "\n",
    "        t = Simulator(strategy)\n",
    "\n",
    "        start_date = datetime.datetime(2022, 1, 1)\n",
    "        end_date = datetime.datetime(2022, 3, 30)\n",
    "        t.run(start_date, end_date)\n",
    "\n",
    "        df = t.get_result_dataframe()\n",
    "        \n",
    "        stats[row][const] = df['profit'][-1]\n",
    "        if df['profit'][-1] > best_profit:\n",
    "            best_profit = df['profit'][-1]\n",
    "            best_row = row\n",
    "            best_const = const\n",
    "            print('profit:', best_profit)\n",
    "            print(f'\\trow: {best_row} const: {best_const}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "6b942491",
   "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>720</th>\n",
       "      <th>1440</th>\n",
       "      <th>2160</th>\n",
       "      <th>2880</th>\n",
       "      <th>3600</th>\n",
       "      <th>4320</th>\n",
       "      <th>5040</th>\n",
       "      <th>5760</th>\n",
       "      <th>6480</th>\n",
       "      <th>7200</th>\n",
       "      <th>7920</th>\n",
       "      <th>8640</th>\n",
       "      <th>9360</th>\n",
       "      <th>10080</th>\n",
       "      <th>10800</th>\n",
       "      <th>11520</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24500</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25000</th>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>362225.221776</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               720            1440           2160           2880   \\\n",
       "500    362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "1000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "1500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "2000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "2500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "3000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "3500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "4000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "4500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "5000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "5500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "6000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "6500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "7000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "7500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "8000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "8500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "9000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "9500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "10000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "10500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "11000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "11500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "12000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "12500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "13000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "13500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "14000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "14500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "15000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "15500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "16000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "16500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "17000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "17500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "18000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "18500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "19000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "19500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "20000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "20500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "21000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "21500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "22000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "22500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "23000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "23500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "24000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "24500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "25000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "\n",
       "               3600           4320           5040           5760   \\\n",
       "500    362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "1000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "1500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "2000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "2500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "3000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "3500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "4000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "4500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "5000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "5500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "6000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "6500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "7000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "7500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "8000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "8500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "9000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "9500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "10000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "10500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "11000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "11500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "12000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "12500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "13000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "13500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "14000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "14500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "15000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "15500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "16000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "16500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "17000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "17500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "18000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "18500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "19000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "19500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "20000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "20500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "21000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "21500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "22000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "22500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "23000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "23500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "24000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "24500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "25000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "\n",
       "               6480           7200           7920           8640   \\\n",
       "500    362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "1000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "1500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "2000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "2500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "3000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "3500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "4000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "4500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "5000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "5500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "6000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "6500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "7000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "7500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "8000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "8500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "9000   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "9500   362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "10000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "10500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "11000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "11500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "12000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "12500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "13000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "13500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "14000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "14500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "15000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "15500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "16000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "16500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "17000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "17500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "18000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "18500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "19000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "19500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "20000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "20500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "21000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "21500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "22000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "22500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "23000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "23500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "24000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "24500  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "25000  362225.221776  362225.221776  362225.221776  362225.221776   \n",
       "\n",
       "               9360           10080          10800          11520  \n",
       "500    362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "1000   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "1500   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "2000   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "2500   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "3000   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "3500   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "4000   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "4500   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "5000   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "5500   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "6000   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "6500   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "7000   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "7500   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "8000   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "8500   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "9000   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "9500   362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "10000  362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "10500  362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "11000  362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "11500  362225.221776  362225.221776  362225.221776  362225.221776  \n",
       "12000  362225.221776  362225.221776  362225.221776            NaN  \n",
       "12500  362225.221776  362225.221776  362225.221776            NaN  \n",
       "13000  362225.221776  362225.221776  362225.221776            NaN  \n",
       "13500  362225.221776  362225.221776  362225.221776            NaN  \n",
       "14000  362225.221776  362225.221776  362225.221776            NaN  \n",
       "14500  362225.221776  362225.221776  362225.221776            NaN  \n",
       "15000  362225.221776  362225.221776  362225.221776            NaN  \n",
       "15500  362225.221776  362225.221776  362225.221776            NaN  \n",
       "16000  362225.221776  362225.221776  362225.221776            NaN  \n",
       "16500  362225.221776  362225.221776  362225.221776            NaN  \n",
       "17000  362225.221776  362225.221776  362225.221776            NaN  \n",
       "17500  362225.221776  362225.221776  362225.221776            NaN  \n",
       "18000  362225.221776  362225.221776  362225.221776            NaN  \n",
       "18500  362225.221776  362225.221776  362225.221776            NaN  \n",
       "19000  362225.221776  362225.221776  362225.221776            NaN  \n",
       "19500  362225.221776  362225.221776  362225.221776            NaN  \n",
       "20000  362225.221776  362225.221776  362225.221776            NaN  \n",
       "20500  362225.221776  362225.221776  362225.221776            NaN  \n",
       "21000  362225.221776  362225.221776  362225.221776            NaN  \n",
       "21500  362225.221776  362225.221776  362225.221776            NaN  \n",
       "22000  362225.221776  362225.221776  362225.221776            NaN  \n",
       "22500  362225.221776  362225.221776  362225.221776            NaN  \n",
       "23000  362225.221776  362225.221776  362225.221776            NaN  \n",
       "23500  362225.221776  362225.221776  362225.221776            NaN  \n",
       "24000  362225.221776  362225.221776  362225.221776            NaN  \n",
       "24500  362225.221776  362225.221776  362225.221776            NaN  \n",
       "25000  362225.221776  362225.221776  362225.221776            NaN  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame.from_dict(stats)"
   ]
  }
 ],
 "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.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}