PL_LS_State.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "8a0227ba",
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "module 'modules.LP_Pool_State' has no attribute 'LP_pool_gen'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[0;32m/tmp/ipykernel_22540/3003667655.py\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m     20\u001b[0m \u001b[0mLS_Closing\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"LS_Closing\"\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mindex_col\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     21\u001b[0m \u001b[0mLS_Liquidation\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mread_csv\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"LS_Liquidation\"\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mindex_col\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 22\u001b[0;31m \u001b[0mpool_id\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mlpps\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mLP_pool_gen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0margs\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m     23\u001b[0m \u001b[0mpool_id\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     24\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mAttributeError\u001b[0m: module 'modules.LP_Pool_State' has no attribute 'LP_pool_gen'"
     ]
    }
   ],
   "source": [
    "import json\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import modules.LP_Pool_State as lpps\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')\n",
    "with open(\"config.json\", 'r') as f:\n",
    "    args = json.load(f)\n",
    "with open(\"MP_ASSET_STATE.csv\", \"r\") as outfile:\n",
    "    MP_Asset_State = pd.read_csv(outfile, index_col=0)\n",
    "with open(\"MP_ASSET.csv\", \"r\") as outfile:\n",
    "    MP_Asset = pd.read_csv(outfile, index_col=0)\n",
    "\n",
    "LS_Opening = pd.read_csv(\"LS_Opening\", index_col=0)\n",
    "LP_Deposit = pd.read_csv(\"LP_Deposit\", index_col=0)\n",
    "LP_Withdraw = pd.read_csv(\"LP_Withdraw\", index_col=0)\n",
    "SYS_LP_Withdraw = pd.read_csv(\"SYS_LP_Withdraw\", index_col=0)\n",
    "\n",
    "LS_Repayment = pd.read_csv(\"LS_Repayment\", index_col=0)\n",
    "LS_Closing = pd.read_csv(\"LS_Closing\", index_col=0)\n",
    "LS_Liquidation = pd.read_csv(\"LS_Liquidation\", index_col=0)\n",
    "pool_id = lpps.LP_pool_gen(args)\n",
    "pool_id\n",
    "\n",
    "\n",
    "def LP_pool_gen(args):\n",
    "    list_id = [\"pid\" + str(sub) for sub in range(100, 100 + len(args[\"Pool_Assets\"]))]\n",
    "    #pid100,pid101\n",
    "    lpp = pd.DataFrame({\"LP_Pool_id\": list_id, \"LP_symbol\": args[\"Pool_Assets\"]})\n",
    "    return lpp\n",
    "\n",
    "\n",
    "LP_Pool_State = pd.read_csv(\"LP_Pool_State.csv\", index_col=0)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "ffc9a4e7",
   "metadata": {},
   "outputs": [],
   "source": [
    " with open(\"config.json\", 'r') as f:\n",
    "        args = json.load(f)\n",
    "MP_Asset = pd.read_csv(\"MP_ASSET.csv\",index_col=0)\n",
    "PL_Interest = pd.read_csv(\"PL_Interest_p2\",index_col=0)\n",
    "LS_Opening  = pd.read_csv(\"LS_Opening_p2\",index_col=0)\n",
    "LP_Deposit = pd.read_csv(\"LP_Deposit_p2\",index_col=0)\n",
    "SYS_LP_Withdraw = pd.read_csv(\"SYS_LP_Withdraw_p2\",index_col=0)\n",
    "LP_Withdraw = pd.read_csv(\"LP_Withdraw_p2\",index_col=0)\n",
    "LS_Repayment = pd.read_csv(\"LS_Repayment_p2\",index_col=0)\n",
    "LS_Liquidation = pd.read_csv(\"LS_Liquidation_p2\",index_col=0)\n",
    "LP_Pool_State = pd.read_csv(\"LP_Pool_State_p2\",index_col=0)\n",
    "TR_Profit = pd.read_csv(\"TR_Profit_p2\",index_col=0)\n",
    "PL_State = pd.read_csv(\"PL_State_p2\",index_col=0)\n",
    "LS_Closing = pd.read_csv(\"LS_Closing_p2\",index_col=0)\n",
    "TR_State = pd.read_csv(\"TR_State_p2\",index_col=0)\n",
    "TR_Rewards_Distribution = pd.read_csv(\"TR_Rewards_Distribution\",index_col=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "69988367",
   "metadata": {},
   "outputs": [],
   "source": [
    "LS_Opening = pd.read_csv(\"LS_Opening_p2\", index_col=0)\n",
    "LP_Deposit = pd.read_csv(\"LP_Deposit_p2\", index_col=0)\n",
    "LP_Withdraw = pd.read_csv(\"LP_Withdraw_p2\", index_col=0)\n",
    "SYS_LP_Withdraw = pd.read_csv(\"SYS_LP_Withdraw_p2\", index_col=0)\n",
    "PL_Interest = pd.read_csv(\"PL_Interest_p2\",index_col=0)\n",
    "LS_Repayment = pd.read_csv(\"LS_Repayment_p2\", index_col=0)\n",
    "LS_Liquidation = pd.read_csv(\"LS_Liquidation_p2\", index_col=0)\n",
    "LP_Pool_State = pd.read_csv(\"LP_Pool_State_p2\", index_col=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "cabcbcbd",
   "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>LS_asset_symbol</th>\n",
       "      <th>LS_timestamp</th>\n",
       "      <th>LS_contract_id</th>\n",
       "      <th>LS_address_id</th>\n",
       "      <th>LS_loan_symbol</th>\n",
       "      <th>LS_loan_amnt_asset</th>\n",
       "      <th>LS_loan_amnt_stable</th>\n",
       "      <th>LS_cltr_symbol</th>\n",
       "      <th>LS_cltr_amnt_stable</th>\n",
       "      <th>LS_cltr_amnt_asset</th>\n",
       "      <th>SYS_LS_cltr_amnt_asset</th>\n",
       "      <th>SYS_LS_loan_amnt_asset</th>\n",
       "      <th>LS_native_amnt_nolus</th>\n",
       "      <th>LS_native_amnt_stable</th>\n",
       "      <th>SYS_LS_expected_payment</th>\n",
       "      <th>SYS_LS_expected_penalty</th>\n",
       "      <th>LP_Pool_id</th>\n",
       "      <th>LS_interest</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>solana</td>\n",
       "      <td>2020-08-22 03:00:00</td>\n",
       "      <td>LScid1000000</td>\n",
       "      <td>LS_aid1000000</td>\n",
       "      <td>('solana', None, 16)</td>\n",
       "      <td>146120851640169</td>\n",
       "      <td>4283606072121</td>\n",
       "      <td>solana</td>\n",
       "      <td>5936057173648</td>\n",
       "      <td>202488677762287</td>\n",
       "      <td>2.024887</td>\n",
       "      <td>1.461209</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>pid101</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ethereum</td>\n",
       "      <td>2020-08-22 03:00:00</td>\n",
       "      <td>LScid1000001</td>\n",
       "      <td>LS_aid1000001</td>\n",
       "      <td>('ethereum', None, 13)</td>\n",
       "      <td>8041181306339</td>\n",
       "      <td>310878269545215</td>\n",
       "      <td>ethereum</td>\n",
       "      <td>394108143559885</td>\n",
       "      <td>10194006294830</td>\n",
       "      <td>1.019401</td>\n",
       "      <td>0.804118</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>pid101</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>usd-coin</td>\n",
       "      <td>2020-08-22 03:00:00</td>\n",
       "      <td>LScid1000002</td>\n",
       "      <td>LS_aid1000002</td>\n",
       "      <td>('usd-coin', None, 16)</td>\n",
       "      <td>501203184993</td>\n",
       "      <td>501020135184</td>\n",
       "      <td>usd-coin</td>\n",
       "      <td>659006249718</td>\n",
       "      <td>659247020416</td>\n",
       "      <td>0.659247</td>\n",
       "      <td>0.501203</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>pid100</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>matic-network</td>\n",
       "      <td>2020-08-22 03:00:00</td>\n",
       "      <td>LScid1000003</td>\n",
       "      <td>LS_aid1000003</td>\n",
       "      <td>('matic-network', None, 16)</td>\n",
       "      <td>10738170597123684</td>\n",
       "      <td>26797738702</td>\n",
       "      <td>matic-network</td>\n",
       "      <td>39790148758</td>\n",
       "      <td>15944382852572164</td>\n",
       "      <td>1.594438</td>\n",
       "      <td>1.073817</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>pid101</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>crypto-com-chain</td>\n",
       "      <td>2020-08-22 03:00:00</td>\n",
       "      <td>LScid1000004</td>\n",
       "      <td>LS_aid1000004</td>\n",
       "      <td>('crypto-com-chain', None, 15)</td>\n",
       "      <td>6969856732475531</td>\n",
       "      <td>117280371682</td>\n",
       "      <td>crypto-com-chain</td>\n",
       "      <td>121202182911</td>\n",
       "      <td>7202926102989536</td>\n",
       "      <td>0.720293</td>\n",
       "      <td>0.696986</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>pid101</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>73043</th>\n",
       "      <td>tether</td>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1073043</td>\n",
       "      <td>LS_aid1073043</td>\n",
       "      <td>('tether', None, 12)</td>\n",
       "      <td>1158363644598</td>\n",
       "      <td>1159646859896</td>\n",
       "      <td>tether</td>\n",
       "      <td>1190204761684</td>\n",
       "      <td>1188887732327</td>\n",
       "      <td>1.188888</td>\n",
       "      <td>1.158364</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>pid101</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73044</th>\n",
       "      <td>bitcoin</td>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1073044</td>\n",
       "      <td>LS_aid1073044</td>\n",
       "      <td>('bitcoin', None, 12)</td>\n",
       "      <td>1233262442095</td>\n",
       "      <td>26122219920255380</td>\n",
       "      <td>bitcoin</td>\n",
       "      <td>26956457674587960</td>\n",
       "      <td>1272647842469</td>\n",
       "      <td>1.272648</td>\n",
       "      <td>1.233262</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>pid101</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73045</th>\n",
       "      <td>wrapped-bitcoin</td>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1073045</td>\n",
       "      <td>LS_aid1073045</td>\n",
       "      <td>('wrapped-bitcoin', None, 12)</td>\n",
       "      <td>1522935880862</td>\n",
       "      <td>32224525557920664</td>\n",
       "      <td>wrapped-bitcoin</td>\n",
       "      <td>35167825880797500</td>\n",
       "      <td>1662036692814</td>\n",
       "      <td>1.662037</td>\n",
       "      <td>1.522936</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>pid101</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73046</th>\n",
       "      <td>tether</td>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1073046</td>\n",
       "      <td>LS_aid1073046</td>\n",
       "      <td>('tether', None, 12)</td>\n",
       "      <td>1236486906930</td>\n",
       "      <td>1237171596812</td>\n",
       "      <td>tether</td>\n",
       "      <td>1280949110456</td>\n",
       "      <td>1280240192713</td>\n",
       "      <td>1.280240</td>\n",
       "      <td>1.236487</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>pid100</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73047</th>\n",
       "      <td>bitcoin</td>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1073047</td>\n",
       "      <td>LS_aid1073047</td>\n",
       "      <td>('bitcoin', None, 12)</td>\n",
       "      <td>1142814754850</td>\n",
       "      <td>24193015063215476</td>\n",
       "      <td>bitcoin</td>\n",
       "      <td>26089747772692152</td>\n",
       "      <td>1232411447148</td>\n",
       "      <td>1.232411</td>\n",
       "      <td>1.142815</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>pid100</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>73048 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        LS_asset_symbol         LS_timestamp LS_contract_id  LS_address_id  \\\n",
       "0                solana  2020-08-22 03:00:00   LScid1000000  LS_aid1000000   \n",
       "1              ethereum  2020-08-22 03:00:00   LScid1000001  LS_aid1000001   \n",
       "2              usd-coin  2020-08-22 03:00:00   LScid1000002  LS_aid1000002   \n",
       "3         matic-network  2020-08-22 03:00:00   LScid1000003  LS_aid1000003   \n",
       "4      crypto-com-chain  2020-08-22 03:00:00   LScid1000004  LS_aid1000004   \n",
       "...                 ...                  ...            ...            ...   \n",
       "73043            tether  2022-08-21 03:00:00   LScid1073043  LS_aid1073043   \n",
       "73044           bitcoin  2022-08-21 03:00:00   LScid1073044  LS_aid1073044   \n",
       "73045   wrapped-bitcoin  2022-08-21 03:00:00   LScid1073045  LS_aid1073045   \n",
       "73046            tether  2022-08-21 03:00:00   LScid1073046  LS_aid1073046   \n",
       "73047           bitcoin  2022-08-21 03:00:00   LScid1073047  LS_aid1073047   \n",
       "\n",
       "                       LS_loan_symbol  LS_loan_amnt_asset  \\\n",
       "0                ('solana', None, 16)     146120851640169   \n",
       "1              ('ethereum', None, 13)       8041181306339   \n",
       "2              ('usd-coin', None, 16)        501203184993   \n",
       "3         ('matic-network', None, 16)   10738170597123684   \n",
       "4      ('crypto-com-chain', None, 15)    6969856732475531   \n",
       "...                               ...                 ...   \n",
       "73043            ('tether', None, 12)       1158363644598   \n",
       "73044           ('bitcoin', None, 12)       1233262442095   \n",
       "73045   ('wrapped-bitcoin', None, 12)       1522935880862   \n",
       "73046            ('tether', None, 12)       1236486906930   \n",
       "73047           ('bitcoin', None, 12)       1142814754850   \n",
       "\n",
       "       LS_loan_amnt_stable    LS_cltr_symbol  LS_cltr_amnt_stable  \\\n",
       "0            4283606072121            solana        5936057173648   \n",
       "1          310878269545215          ethereum      394108143559885   \n",
       "2             501020135184          usd-coin         659006249718   \n",
       "3              26797738702     matic-network          39790148758   \n",
       "4             117280371682  crypto-com-chain         121202182911   \n",
       "...                    ...               ...                  ...   \n",
       "73043        1159646859896            tether        1190204761684   \n",
       "73044    26122219920255380           bitcoin    26956457674587960   \n",
       "73045    32224525557920664   wrapped-bitcoin    35167825880797500   \n",
       "73046        1237171596812            tether        1280949110456   \n",
       "73047    24193015063215476           bitcoin    26089747772692152   \n",
       "\n",
       "       LS_cltr_amnt_asset  SYS_LS_cltr_amnt_asset  SYS_LS_loan_amnt_asset  \\\n",
       "0         202488677762287                2.024887                1.461209   \n",
       "1          10194006294830                1.019401                0.804118   \n",
       "2            659247020416                0.659247                0.501203   \n",
       "3       15944382852572164                1.594438                1.073817   \n",
       "4        7202926102989536                0.720293                0.696986   \n",
       "...                   ...                     ...                     ...   \n",
       "73043       1188887732327                1.188888                1.158364   \n",
       "73044       1272647842469                1.272648                1.233262   \n",
       "73045       1662036692814                1.662037                1.522936   \n",
       "73046       1280240192713                1.280240                1.236487   \n",
       "73047       1232411447148                1.232411                1.142815   \n",
       "\n",
       "       LS_native_amnt_nolus  LS_native_amnt_stable  SYS_LS_expected_payment  \\\n",
       "0                         0                      0                        3   \n",
       "1                         0                      0                        2   \n",
       "2                         0                      0                        3   \n",
       "3                         0                      0                        2   \n",
       "4                         0                      0                        5   \n",
       "...                     ...                    ...                      ...   \n",
       "73043                     0                      0                        1   \n",
       "73044                     0                      0                        1   \n",
       "73045                     0                      0                        5   \n",
       "73046                     0                      0                        6   \n",
       "73047                     0                      0                        7   \n",
       "\n",
       "       SYS_LS_expected_penalty LP_Pool_id  LS_interest  \n",
       "0                            0     pid101          NaN  \n",
       "1                            0     pid101          NaN  \n",
       "2                            1     pid100          NaN  \n",
       "3                            0     pid101          NaN  \n",
       "4                            8     pid101          NaN  \n",
       "...                        ...        ...          ...  \n",
       "73043                        0     pid101          NaN  \n",
       "73044                        0     pid101          NaN  \n",
       "73045                        0     pid101          NaN  \n",
       "73046                        0     pid100          NaN  \n",
       "73047                        0     pid100          NaN  \n",
       "\n",
       "[73048 rows x 18 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LS_Opening\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "48e1522f",
   "metadata": {},
   "outputs": [],
   "source": [
    "def count_in_time(timestamp,PL_State, to_count, name=\"count\", timestamp_col_name=\"timestamp\"):\n",
    "    PL_State.loc[PL_State[\"PL_timestamp\"]==timestamp,[name]]=to_count.loc[to_count[timestamp_col_name]==timestamp,[timestamp_col_name]].value_counts().fillna(0).astype('uint64')\n",
    "    return PL_State\n",
    "\n",
    "def LS_Closing_ini():\n",
    "    LS_Closing = pd.DataFrame({\"LS_timestamp\":None,\"LS_contract_id\":None})\n",
    "    return LS_Closing\n",
    "def LS_Closing_update(timestamp,LS_Closing,LS_Repayment):\n",
    "    temp = LS_Repayment.drop_duplicates(subset=[\"LS_contract_id\"],keep=\"last\",ignore_index=True)\n",
    "    temp = temp[[\"LS_timestamp\",\"LS_contract_id\"]]\n",
    "    temp = temp.loc[temp[\"LS_timestamp\"]==timestamp]\n",
    "    try:\n",
    "        LS_Closing = LS_Closing.drop(LS_Closing[\"LS_timestamp\"==timestamp].index)\n",
    "        LS_Closing = pd.concat([LS_Closing,temp],axis=0,ignore_index=True)\n",
    "    except:\n",
    "        LS_Closing = pd.concat([LS_Closing,temp],axis=0,ignore_index=True)\n",
    "    return LS_Closing\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5f2cfa2b",
   "metadata": {},
   "outputs": [],
   "source": [
    "def PL_State_ini(MP_Asset):\n",
    "    timestamp = MP_Asset.drop_duplicates(subset=[\"MP_timestamp\"], keep=\"last\")\n",
    "    PL_State = pd.DataFrame()\n",
    "    PL_State[\"PL_timestamp\"] = timestamp[\"MP_timesta"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "6bfe239c",
   "metadata": {},
   "outputs": [],
   "source": [
    "def PL_State_gen(MP_Asset,LS_Opening,LS_Repayment,LS_Liquidation,LS_Closing,LP_Deposit,LP_Withdraw,args):\n",
    "    timestamp = MP_Asset.drop_duplicates(subset=[\"MP_timestamp\"], keep=\"last\")\n",
    "    PL_State = pd.DataFrame()\n",
    "    PL_State[\"PL_timestamp\"] = timestamp[\"MP_timestamp\"]\n",
    "    PL_State = count_in_time(PL_State, LS_Opening,\"PL_LS_count_opened\",\"LS_timestamp\")\n",
    "    PL_State = count_in_time(PL_State, LP_Deposit,\"PL_LP_count_opened\",\"LP_timestamp\")\n",
    "    PL_State = count_in_time(PL_State, LS_Closing,\"PL_LS_count_closed\",\"LS_timestamp\")\n",
    "    PL_State = count_in_time(PL_State, LP_Withdraw,\"PL_LP_count_closed\",\"LP_timestamp\")\n",
    "\n",
    "    PL_State[\"PL_LS_count_closed\"] = PL_State[\"PL_LS_count_closed\"].fillna(0)\n",
    "    PL_State[\"PL_LP_count_closed\"] = PL_State[\"PL_LP_count_closed\"].fillna(0)\n",
    "    PL_State[\"PL_LS_count_opened\"] = PL_State[\"PL_LS_count_opened\"].fillna(0)\n",
    "    PL_State[\"PL_LP_count_opened\"] = PL_State[\"PL_LP_count_opened\"].fillna(0)\n",
    "    \n",
    "    PL_State[\"PL_LS_count_open\"] = PL_State[\"PL_LS_count_opened\"].cumsum() - PL_State[\"PL_LS_count_closed\"].cumsum()\n",
    "    PL_State[\"PL_LP_count_open\"] = PL_State[\"PL_LP_count_opened\"].cumsum() - PL_State[\"PL_LP_count_closed\"].cumsum()\n",
    "    \n",
    "\n",
    "    PL_State = PL_State.reset_index(drop=True)\n",
    "    return PL_State\n",
    "PL_State = PL_State_gen(MP_Asset,LS_Opening,LS_Repayment,LS_Liquidation,LS_Closing,LP_Deposit,LP_Withdraw,args)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "dc9f1c34",
   "metadata": {},
   "outputs": [],
   "source": [
    "def PL_State_update(prev_timestamp,timestamp,PL_State,LS_Opening,LS_Repayment,LS_Liquidation,LS_Closing,LP_Deposit,LP_Withdraw,args):\n",
    "    present_cond = PL_State[\"PL_timestamp\"]==timestamp\n",
    "    past_cond = PL_State[\"PL_timestamp\"]==prev_timestamp\n",
    "    LS_Closing = LS_Closing_update(timestamp,LS_Closing,LS_Repayment)\n",
    "    if prev_timestamp == None:\n",
    "        prev_timestamp = timestamp\n",
    "    present_cond = PL_State[\"PL_timestamp\"]==timestamp\n",
    "    past_cond = PL_State[\"PL_timestamp\"]==prev_timestamp\n",
    "    \n",
    "    PL_State = count_in_time(timestamp,PL_State, LS_Opening,\"PL_LS_count_opened\",\"LS_timestamp\")\n",
    "    PL_State = count_in_time(timestamp,PL_State, LP_Deposit,\"PL_LP_count_opened\",\"LP_timestamp\")\n",
    "    PL_State = count_in_time(timestamp,PL_State, LS_Closing,\"PL_LS_count_closed\",\"LS_timestamp\")\n",
    "    PL_State = count_in_time(timestamp,PL_State, LP_Withdraw,\"PL_LP_count_closed\",\"LP_timestamp\")\n",
    "    PL_State.loc[present_cond,\"SYS_PL_LS_count_open_sum\"] = PL_State.loc[past_cond,[\"SYS_PL_LS_count_open_sum\"]] + PL_State.loc[present_cond,[\"PL_LS_count_opened\"]]\n",
    "    PL_State.loc[present_cond,\"SYS_PL_LP_count_open_sum\"] = PL_State.loc[past_cond,[\"SYS_PL_LP_count_open_sum\"]] + PL_State.loc[present_cond,[\"PL_LP_count_opened\"]]\n",
    "    PL_State.loc[present_cond,\"SYS_PL_LS_count_closed_sum\"] = PL_State.loc[past_cond,[\"SYS_PL_LS_count_closed_sum\"]] + PL_State.loc[present_cond,[\"PL_LS_count_closed\"]]\n",
    "    PL_State.loc[present_cond,\"SYS_PL_LP_count_closed_sum\"] = PL_State.loc[past_cond,[\"SYS_PL_LP_count_closed_sum\"]] + PL_State.loc[present_cond,[\"PL_LP_count_closed\"]]\n",
    "\n",
    "    PL_State.loc[present_cond,[\"PL_LS_count_open\"]] = PL_State.loc[present_cond,[\"SYS_PL_LS_count_open_sum\"]] - PL_State.loc[present_cond,[\"SYS_PL_LS_count_closed_sum\"]]\n",
    "    PL_State.loc[present_cond,[\"PL_LP_count_open\"]] = PL_State.loc[present_cond,[\"SYS_PL_LP_count_open_sum\"]] - PL_State.loc[present_cond,[\"SYS_PL_LP_count_closed_sum\"]]\n",
    "\n",
    "    return PL_State\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e3564f08",
   "metadata": {},
   "outputs": [],
   "source": [
    "def lso_timestamp(LS_Opening,basis,args):\n",
    "    day = 86400\n",
    "    month = 30*day\n",
    "    if basis == \"day\":\n",
    "        duration = (LS_Opening[\"SYS_LS_expected_payment\"]+LS_Opening[\"SYS_LS_expected_penalty\"]).values\n",
    "        duration = duration*30\n",
    "        print(len(duration))\n",
    "        \n",
    "        timestamp = pd.DataFrame({\"LP_timestamp\":LP_Deposit[\"LP_timestamp\"],\"LP_address_id\":LS_Opening[\"LP_address_id\"],\"SYS_LP_contract_id\":LP_Deposit[\"SYS_LP_contract_id\"]})\n",
    "        timestamp[\"LP_timestamp\"] = LP_Deposit[\"LP_timestamp\"].astype(\"datetime64\").apply(lambda x:datetime.datetime.timestamp(x)).astype(int)\n",
    "        timestamp[\"LP_Pool_id\"] = LP_Deposit[\"LP_Pool_id\"]\n",
    "        #print(type(timestamp[\"LP_\"][0]))    \n",
    "        #timestamp = np.repeat(timestamp.values, duration+1, axis=0)\n",
    "        #timestamp = pd.DataFrame(timestamp.values)\n",
    "        timestamp = pd.DataFrame(np.repeat(timestamp.values, duration, axis=0))\n",
    "        timestamp = pd.DataFrame({\"LP_timestamp\":timestamp[0],\"LP_address_id\":timestamp[1],\"SYS_LP_contract_id\":timestamp[2],\"LP_Pool_id\":timestamp[3]})\n",
    "        timestamp[\"LP_timestamp\"] = timestamp[\"LP_timestamp\"].values.astype(\"uint64\")\n",
    "        #duration = pd.DataFrame({\"duration\":duration})\n",
    "        d = []\n",
    "        l1 = []\n",
    "        for i in duration:\n",
    "            l1 = [s for s in range(1,i+1)]\n",
    "            d.extend(l1)\n",
    "        timestamp[\"Duration\"] = d \n",
    "        timestamp[\"Duration\"] = timestamp[\"Duration\"]*day\n",
    "        timestamp[\"LP_timestamp\"] = timestamp[\"LP_timestamp\"]+timestamp[\"Duration\"]\n",
    "        timestamp[\"LP_timestamp\"] = timestamp[\"LP_timestamp\"].apply(datetime.datetime.fromtimestamp)\n",
    "        timestamp = timestamp.drop(\"Duration\",axis=1)\n",
    "    \n",
    "    return timestamp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "a507d051",
   "metadata": {},
   "outputs": [],
   "source": [
    "def LS_State_gen(LS_Opening,LS_Repayment,LS_Liquidation):\n",
    "    LS_State = pd.DataFrame()\n",
    "    LS_State[\"LS_contract_id\"] = LS_Opening[\"LS_contract_id\"]\n",
    "    LS_State = pd.merge(LS_State,LS_Repayment,on=[\"LS_contract_id\"], how =\"left\")\n",
    "    liq_merge = LS_Liquidation[[\"LS_timestamp\",\"LS_contract_id\",\"LS_amnt_stable\"]]\n",
    "    liq_merge = liq_merge.rename(columns={\"LS_amnt_stable\":\"LS_liq_amnt_stable\"})\n",
    "    LS_State = pd.merge(LS_State,liq_merge, on=[\"LS_timestamp\",\"LS_contract_id\"],how=\"left\")\n",
    "    LS_State = LS_State.fillna(0)\n",
    "    LS_State[\"LS_amnt_stable\"] = LS_State[\"LS_amnt_stable\"] + LS_State[\"LS_liq_amnt_stable\"]\n",
    "    LS_State = LS_State.drop([\"LS_symbol\",\"LS_repayment_height\",\"LS_repayment_idx\",\"LS_liq_amnt_stable\"],axis=1)\n",
    "    \n",
    "    #LS_State[[\"LS_amnt_stable\",\"LS_principal_stable\",\"LS_current_margin_stable\",\"LS_current_interest_stable\",\"LS_prev_interest_stable\",\"LS_prev_margin_stable\"]].groupby(\"LS_contract_id\").cumsum()\n",
    "    #LS_State.groupby(by=[\"LS_timestamp\",\"LS_contract_id\"]).sum()\n",
    "    # LS_State\n",
    "    #LS_State.explode(\"LS_contract_id\")\n",
    "    ##\n",
    "    #\n",
    "    #LS_amnt_stable = (loan_amnt_stable+loan_amnt_stable*LS_interest) - cumsum on month basis(LS_amnt_stable -> rep&liq) \n",
    "    #LS_principle_stable = loan_amnt_stable - cumsum on month basis(LS_principal_stable)\n",
    "    #\n",
    "    #\n",
    "    #\n",
    "    \n",
    "    \n",
    "    return LS_State"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "5fe05898",
   "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>LS_asset_symbol</th>\n",
       "      <th>LS_timestamp</th>\n",
       "      <th>LS_contract_id</th>\n",
       "      <th>LS_address_id</th>\n",
       "      <th>LS_loan_symbol</th>\n",
       "      <th>LS_loan_amnt_asset</th>\n",
       "      <th>LS_loan_amnt_stable</th>\n",
       "      <th>LS_cltr_symbol</th>\n",
       "      <th>LS_cltr_amnt_stable</th>\n",
       "      <th>LS_cltr_amnt_asset</th>\n",
       "      <th>SYS_LS_cltr_amnt_asset</th>\n",
       "      <th>SYS_LS_loan_amnt_asset</th>\n",
       "      <th>LS_native_amnt_nolus</th>\n",
       "      <th>LS_native_amnt_stable</th>\n",
       "      <th>SYS_LS_expected_payment</th>\n",
       "      <th>SYS_LS_expected_penalty</th>\n",
       "      <th>LP_Pool_id</th>\n",
       "      <th>LS_interest</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>solana</td>\n",
       "      <td>2020-08-22 03:00:00</td>\n",
       "      <td>LScid1000000</td>\n",
       "      <td>LS_aid1000000</td>\n",
       "      <td>('solana', None, 16)</td>\n",
       "      <td>250601592496291</td>\n",
       "      <td>7346511406488</td>\n",
       "      <td>solana</td>\n",
       "      <td>10180514034565</td>\n",
       "      <td>347274085389656</td>\n",
       "      <td>3.472741</td>\n",
       "      <td>2.506016</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>pid101</td>\n",
       "      <td>0.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ethereum</td>\n",
       "      <td>2020-08-23 03:00:00</td>\n",
       "      <td>LScid1000001</td>\n",
       "      <td>LS_aid1000001</td>\n",
       "      <td>('ethereum', None, 13)</td>\n",
       "      <td>23199113333516</td>\n",
       "      <td>918141879848972</td>\n",
       "      <td>ethereum</td>\n",
       "      <td>1163951383032364</td>\n",
       "      <td>29410095152301</td>\n",
       "      <td>2.941010</td>\n",
       "      <td>2.319911</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>pid101</td>\n",
       "      <td>0.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>usd-coin</td>\n",
       "      <td>2020-08-23 03:00:00</td>\n",
       "      <td>LScid1000002</td>\n",
       "      <td>LS_aid1000002</td>\n",
       "      <td>('usd-coin', None, 16)</td>\n",
       "      <td>1391882062205</td>\n",
       "      <td>1391794593050</td>\n",
       "      <td>usd-coin</td>\n",
       "      <td>1830667613400</td>\n",
       "      <td>1830782664105</td>\n",
       "      <td>1.830783</td>\n",
       "      <td>1.391882</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>pid100</td>\n",
       "      <td>0.100004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>matic-network</td>\n",
       "      <td>2020-08-24 03:00:00</td>\n",
       "      <td>LScid1000003</td>\n",
       "      <td>LS_aid1000003</td>\n",
       "      <td>('matic-network', None, 16)</td>\n",
       "      <td>24042739354857016</td>\n",
       "      <td>60803446834</td>\n",
       "      <td>matic-network</td>\n",
       "      <td>90282923550</td>\n",
       "      <td>35699436662062996</td>\n",
       "      <td>3.569944</td>\n",
       "      <td>2.404274</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>pid101</td>\n",
       "      <td>0.100498</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>crypto-com-chain</td>\n",
       "      <td>2020-08-24 03:00:00</td>\n",
       "      <td>LScid1000004</td>\n",
       "      <td>LS_aid1000004</td>\n",
       "      <td>('crypto-com-chain', None, 15)</td>\n",
       "      <td>22820091326760080</td>\n",
       "      <td>389629584496</td>\n",
       "      <td>crypto-com-chain</td>\n",
       "      <td>402658650296</td>\n",
       "      <td>23583186541589696</td>\n",
       "      <td>2.358319</td>\n",
       "      <td>2.282009</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>pid101</td>\n",
       "      <td>0.100498</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7303</th>\n",
       "      <td>matic-network</td>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1007303</td>\n",
       "      <td>LS_aid1007303</td>\n",
       "      <td>('matic-network', None, 16)</td>\n",
       "      <td>7976844895424867</td>\n",
       "      <td>628900359875</td>\n",
       "      <td>matic-network</td>\n",
       "      <td>658152942909</td>\n",
       "      <td>8347878738850759</td>\n",
       "      <td>0.834788</td>\n",
       "      <td>0.797684</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>pid101</td>\n",
       "      <td>0.103511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7304</th>\n",
       "      <td>bitcoin</td>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1007304</td>\n",
       "      <td>LS_aid1007304</td>\n",
       "      <td>('bitcoin', None, 12)</td>\n",
       "      <td>493989211459</td>\n",
       "      <td>10457590246510636</td>\n",
       "      <td>bitcoin</td>\n",
       "      <td>12525808274174730</td>\n",
       "      <td>591686421669</td>\n",
       "      <td>0.591686</td>\n",
       "      <td>0.493989</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>pid100</td>\n",
       "      <td>0.103410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7305</th>\n",
       "      <td>wrapped-bitcoin</td>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1007305</td>\n",
       "      <td>LS_aid1007305</td>\n",
       "      <td>('wrapped-bitcoin', None, 12)</td>\n",
       "      <td>868991361565</td>\n",
       "      <td>18387402051697748</td>\n",
       "      <td>wrapped-bitcoin</td>\n",
       "      <td>18661146433454512</td>\n",
       "      <td>881928561848</td>\n",
       "      <td>0.881929</td>\n",
       "      <td>0.868991</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>pid101</td>\n",
       "      <td>0.103511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7306</th>\n",
       "      <td>ethereum</td>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1007306</td>\n",
       "      <td>LS_aid1007306</td>\n",
       "      <td>('ethereum', None, 13)</td>\n",
       "      <td>3851457643974</td>\n",
       "      <td>608145570519231</td>\n",
       "      <td>ethereum</td>\n",
       "      <td>641577003100101</td>\n",
       "      <td>4063182850576</td>\n",
       "      <td>0.406318</td>\n",
       "      <td>0.385146</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>pid100</td>\n",
       "      <td>0.103410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7307</th>\n",
       "      <td>bitcoin</td>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1007307</td>\n",
       "      <td>LS_aid1007307</td>\n",
       "      <td>('bitcoin', None, 12)</td>\n",
       "      <td>659339132333</td>\n",
       "      <td>13965723133160096</td>\n",
       "      <td>bitcoin</td>\n",
       "      <td>15365332931241662</td>\n",
       "      <td>725416448994</td>\n",
       "      <td>0.725416</td>\n",
       "      <td>0.659339</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>pid101</td>\n",
       "      <td>0.103511</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>7308 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       LS_asset_symbol         LS_timestamp LS_contract_id  LS_address_id  \\\n",
       "0               solana  2020-08-22 03:00:00   LScid1000000  LS_aid1000000   \n",
       "1             ethereum  2020-08-23 03:00:00   LScid1000001  LS_aid1000001   \n",
       "2             usd-coin  2020-08-23 03:00:00   LScid1000002  LS_aid1000002   \n",
       "3        matic-network  2020-08-24 03:00:00   LScid1000003  LS_aid1000003   \n",
       "4     crypto-com-chain  2020-08-24 03:00:00   LScid1000004  LS_aid1000004   \n",
       "...                ...                  ...            ...            ...   \n",
       "7303     matic-network  2022-08-21 03:00:00   LScid1007303  LS_aid1007303   \n",
       "7304           bitcoin  2022-08-21 03:00:00   LScid1007304  LS_aid1007304   \n",
       "7305   wrapped-bitcoin  2022-08-21 03:00:00   LScid1007305  LS_aid1007305   \n",
       "7306          ethereum  2022-08-21 03:00:00   LScid1007306  LS_aid1007306   \n",
       "7307           bitcoin  2022-08-21 03:00:00   LScid1007307  LS_aid1007307   \n",
       "\n",
       "                      LS_loan_symbol  LS_loan_amnt_asset  LS_loan_amnt_stable  \\\n",
       "0               ('solana', None, 16)     250601592496291        7346511406488   \n",
       "1             ('ethereum', None, 13)      23199113333516      918141879848972   \n",
       "2             ('usd-coin', None, 16)       1391882062205        1391794593050   \n",
       "3        ('matic-network', None, 16)   24042739354857016          60803446834   \n",
       "4     ('crypto-com-chain', None, 15)   22820091326760080         389629584496   \n",
       "...                              ...                 ...                  ...   \n",
       "7303     ('matic-network', None, 16)    7976844895424867         628900359875   \n",
       "7304           ('bitcoin', None, 12)        493989211459    10457590246510636   \n",
       "7305   ('wrapped-bitcoin', None, 12)        868991361565    18387402051697748   \n",
       "7306          ('ethereum', None, 13)       3851457643974      608145570519231   \n",
       "7307           ('bitcoin', None, 12)        659339132333    13965723133160096   \n",
       "\n",
       "        LS_cltr_symbol  LS_cltr_amnt_stable  LS_cltr_amnt_asset  \\\n",
       "0               solana       10180514034565     347274085389656   \n",
       "1             ethereum     1163951383032364      29410095152301   \n",
       "2             usd-coin        1830667613400       1830782664105   \n",
       "3        matic-network          90282923550   35699436662062996   \n",
       "4     crypto-com-chain         402658650296   23583186541589696   \n",
       "...                ...                  ...                 ...   \n",
       "7303     matic-network         658152942909    8347878738850759   \n",
       "7304           bitcoin    12525808274174730        591686421669   \n",
       "7305   wrapped-bitcoin    18661146433454512        881928561848   \n",
       "7306          ethereum      641577003100101       4063182850576   \n",
       "7307           bitcoin    15365332931241662        725416448994   \n",
       "\n",
       "      SYS_LS_cltr_amnt_asset  SYS_LS_loan_amnt_asset  LS_native_amnt_nolus  \\\n",
       "0                   3.472741                2.506016                     0   \n",
       "1                   2.941010                2.319911                     0   \n",
       "2                   1.830783                1.391882                     0   \n",
       "3                   3.569944                2.404274                     0   \n",
       "4                   2.358319                2.282009                     0   \n",
       "...                      ...                     ...                   ...   \n",
       "7303                0.834788                0.797684                     0   \n",
       "7304                0.591686                0.493989                     0   \n",
       "7305                0.881929                0.868991                     0   \n",
       "7306                0.406318                0.385146                     0   \n",
       "7307                0.725416                0.659339                     0   \n",
       "\n",
       "      LS_native_amnt_stable  SYS_LS_expected_payment  SYS_LS_expected_penalty  \\\n",
       "0                         0                        3                        0   \n",
       "1                         0                        2                        0   \n",
       "2                         0                        3                        1   \n",
       "3                         0                        2                        0   \n",
       "4                         0                        5                        8   \n",
       "...                     ...                      ...                      ...   \n",
       "7303                      0                        1                        0   \n",
       "7304                      0                        1                        0   \n",
       "7305                      0                        1                        0   \n",
       "7306                      0                        1                        0   \n",
       "7307                      0                        9                        0   \n",
       "\n",
       "     LP_Pool_id  LS_interest  \n",
       "0        pid101     0.100000  \n",
       "1        pid101     0.100000  \n",
       "2        pid100     0.100004  \n",
       "3        pid101     0.100498  \n",
       "4        pid101     0.100498  \n",
       "...         ...          ...  \n",
       "7303     pid101     0.103511  \n",
       "7304     pid100     0.103410  \n",
       "7305     pid101     0.103511  \n",
       "7306     pid100     0.103410  \n",
       "7307     pid101     0.103511  \n",
       "\n",
       "[7308 rows x 18 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LS_Opening"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "ed71b4b1",
   "metadata": {},
   "outputs": [],
   "source": [
    "LS_State = LS_State_gen(LS_Opening,LS_Repayment,LS_Liquidation)\n",
    "#LS_State.loc[LS_State[\"LS_contract_id\"] ==\"LScid1040008\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "78d581e3",
   "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>LS_contract_id</th>\n",
       "      <th>LS_timestamp</th>\n",
       "      <th>LS_amnt_stable</th>\n",
       "      <th>LS_principal_stable</th>\n",
       "      <th>LS_current_margin_stable</th>\n",
       "      <th>LS_current_interest_stable</th>\n",
       "      <th>LS_prev_interest_stable</th>\n",
       "      <th>LS_prev_margin_stable</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>LScid1000002</td>\n",
       "      <td>2020-09-22 03:00:00</td>\n",
       "      <td>3.827451e+11</td>\n",
       "      <td>3.479486e+11</td>\n",
       "      <td>7.974178e+09</td>\n",
       "      <td>7.974178e+09</td>\n",
       "      <td>7.974178e+09</td>\n",
       "      <td>7.974178e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>LScid1000002</td>\n",
       "      <td>2020-10-22 03:00:00</td>\n",
       "      <td>3.827451e+11</td>\n",
       "      <td>3.479486e+11</td>\n",
       "      <td>7.974178e+09</td>\n",
       "      <td>7.974178e+09</td>\n",
       "      <td>7.974178e+09</td>\n",
       "      <td>7.974178e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>LScid1000002</td>\n",
       "      <td>2020-11-21 02:00:00</td>\n",
       "      <td>3.827451e+11</td>\n",
       "      <td>3.479486e+11</td>\n",
       "      <td>7.974178e+09</td>\n",
       "      <td>7.974178e+09</td>\n",
       "      <td>7.974178e+09</td>\n",
       "      <td>7.974178e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>LScid1000002</td>\n",
       "      <td>2020-12-21 02:00:00</td>\n",
       "      <td>3.827451e+11</td>\n",
       "      <td>3.479486e+11</td>\n",
       "      <td>7.974178e+09</td>\n",
       "      <td>7.974178e+09</td>\n",
       "      <td>7.974178e+09</td>\n",
       "      <td>7.974178e+09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  LS_contract_id         LS_timestamp  LS_amnt_stable  LS_principal_stable  \\\n",
       "5   LScid1000002  2020-09-22 03:00:00    3.827451e+11         3.479486e+11   \n",
       "6   LScid1000002  2020-10-22 03:00:00    3.827451e+11         3.479486e+11   \n",
       "7   LScid1000002  2020-11-21 02:00:00    3.827451e+11         3.479486e+11   \n",
       "8   LScid1000002  2020-12-21 02:00:00    3.827451e+11         3.479486e+11   \n",
       "\n",
       "   LS_current_margin_stable  LS_current_interest_stable  \\\n",
       "5              7.974178e+09                7.974178e+09   \n",
       "6              7.974178e+09                7.974178e+09   \n",
       "7              7.974178e+09                7.974178e+09   \n",
       "8              7.974178e+09                7.974178e+09   \n",
       "\n",
       "   LS_prev_interest_stable  LS_prev_margin_stable  \n",
       "5             7.974178e+09           7.974178e+09  \n",
       "6             7.974178e+09           7.974178e+09  \n",
       "7             7.974178e+09           7.974178e+09  \n",
       "8             7.974178e+09           7.974178e+09  "
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LS_State.loc[LS_State[\"LS_contract_id\"] ==\"LScid1000002\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "id": "2755d8b4",
   "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>LS_timestamp</th>\n",
       "      <th>LS_contract_id</th>\n",
       "      <th>SYS_LS_cltr_amnt_taken</th>\n",
       "      <th>LS_cltr_amnt_asset</th>\n",
       "      <th>SYS_LS_cltr_price</th>\n",
       "      <th>SYS_PL_OUT_LS_cltr_amnt_stable</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-09-24 03:00:00</td>\n",
       "      <td>LScid1000006</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.027240e+12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-10-04 03:00:00</td>\n",
       "      <td>LScid1000067</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.673635e+12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-10-09 03:00:00</td>\n",
       "      <td>LScid1000118</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.691413e+16</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-10-18 03:00:00</td>\n",
       "      <td>LScid1000217</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.261101e+12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-10-18 03:00:00</td>\n",
       "      <td>LScid1000219</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.892712e+12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5618</th>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1006399</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.000944e+11</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5619</th>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1006401</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.470349e+11</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5620</th>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1006700</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.704567e+14</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5621</th>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1006703</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.604852e+11</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5622</th>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1007001</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.023254e+14</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5623 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             LS_timestamp LS_contract_id  SYS_LS_cltr_amnt_taken  \\\n",
       "0     2020-09-24 03:00:00   LScid1000006                     0.0   \n",
       "1     2020-10-04 03:00:00   LScid1000067                     0.0   \n",
       "2     2020-10-09 03:00:00   LScid1000118                     0.0   \n",
       "3     2020-10-18 03:00:00   LScid1000217                     0.0   \n",
       "4     2020-10-18 03:00:00   LScid1000219                     0.0   \n",
       "...                   ...            ...                     ...   \n",
       "5618  2022-08-21 03:00:00   LScid1006399                     0.0   \n",
       "5619  2022-08-21 03:00:00   LScid1006401                     0.0   \n",
       "5620  2022-08-21 03:00:00   LScid1006700                     0.0   \n",
       "5621  2022-08-21 03:00:00   LScid1006703                     0.0   \n",
       "5622  2022-08-21 03:00:00   LScid1007001                     0.0   \n",
       "\n",
       "      LS_cltr_amnt_asset  SYS_LS_cltr_price  SYS_PL_OUT_LS_cltr_amnt_stable  \n",
       "0           3.027240e+12                0.0                             0.0  \n",
       "1           1.673635e+12                0.0                             0.0  \n",
       "2           1.691413e+16                0.0                             0.0  \n",
       "3           3.261101e+12                0.0                             0.0  \n",
       "4           2.892712e+12                0.0                             0.0  \n",
       "...                  ...                ...                             ...  \n",
       "5618        7.000944e+11                0.0                             0.0  \n",
       "5619        7.470349e+11                0.0                             0.0  \n",
       "5620        6.704567e+14                0.0                             0.0  \n",
       "5621        5.604852e+11                0.0                             0.0  \n",
       "5622        7.023254e+14                0.0                             0.0  \n",
       "\n",
       "[5623 rows x 6 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LS_Closing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "9f805aa5",
   "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>Unnamed: 0</th>\n",
       "      <th>Day</th>\n",
       "      <th>Count</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>726</th>\n",
       "      <td>726</td>\n",
       "      <td>726</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>727</th>\n",
       "      <td>727</td>\n",
       "      <td>727</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>728</th>\n",
       "      <td>728</td>\n",
       "      <td>728</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>729</th>\n",
       "      <td>729</td>\n",
       "      <td>729</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>730</th>\n",
       "      <td>730</td>\n",
       "      <td>730</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>731 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0  Day  Count\n",
       "0             0    0      0\n",
       "1             1    1      9\n",
       "2             2    2     17\n",
       "3             3    3     25\n",
       "4             4    4     32\n",
       "..          ...  ...    ...\n",
       "726         726  726    100\n",
       "727         727  727    100\n",
       "728         728  728    100\n",
       "729         729  729    100\n",
       "730         730  730    100\n",
       "\n",
       "[731 rows x 3 columns]"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LS_tf = pd.read_csv(\"LS_tf.csv\")\n",
    "LP_tf = pd.read_csv(\"LP_tf.csv\")\n",
    "LS_tf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "1d9c7930",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='Day'>"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAEGCAYAAACevtWaAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAbtUlEQVR4nO3de5SU1Znv8e9DX2igURpoEW200YNGVEToMN6ijpfjNWpMzMIkszgzzmJ5ls6JMyeZkThnPDnrJONkXMaJ1yHGyCTGyyAOJpOT0UGMGm9c1MhF5CJKRy5NA0pDd3VX1XP+eN/qLpqG7q5LV9Vbv89avapq11v1PgX6681+d+1t7o6IiETLsEIXICIiuadwFxGJIIW7iEgEKdxFRCJI4S4iEkGVhS4AYPz48d7Y2FjoMkRESsqKFSt2unt9X88VRbg3NjayfPnyQpchIlJSzOyjQz2nYRkRkQhSuIuIRJDCXUQkgopizF1E5HC6urpobm6mo6Oj0KUURE1NDQ0NDVRVVQ34NQp3ESl6zc3NjB49msbGRsys0OUMKXentbWV5uZmJk+ePODXaVhGRIpeR0cH48aNK7tgBzAzxo0bN+h/tSjcRaQklGOwp2Ty2fsNdzN71Mx2mNmqtLZ/NLP3zez3ZvasmY1Je26emW0ws3VmdtmgKxoC2z/r4N7//IB7nl/HT3/3Icmklj0WkWgZSM/9MeDyXm0vAKe5+zTgA2AegJlNBWYDp4avedDMKnJWbY48+uqH3Puf6/nRixv47i/X8PaW3YUuSUSK3LZt25g9ezYnnngiU6dO5corr+SDDz7I2fu/9NJLvPbaazl7v37D3d1fBnb1anve3ePhwzeAhvD+tcCT7h5z9w+BDcCsnFWbAx/u3Mc/v7yJWZPHsvJ/XQrAlx96nRUfKeBFpG/uzpe+9CUuvPBCNm7cyJo1a/j+97/P9u3bc3aOIQ/3Afgz4P+F948FtqQ91xy2HcTM5prZcjNb3tLSkoMyBuaff7sRgJvOm8zYUdXcfsXnALj/xfVDVoOIlJalS5dSVVXFzTff3N02ffp0zjvvPL797W9z2mmncfrpp/PUU08BQVBfffXV3cfeeuutPPbYY0Cw3Mqdd97JjBkzOP3003n//ffZvHkzDz/8MD/84Q+ZPn06r7zyStY1ZzUV0szuAOLA46mmPg7rc0Db3ecD8wGampqGZND749b9PLlsC8ePG8llpx4NwM0XnMhL63awdF0LKz7azczj64aiFBHJ0Hd/uZo1n3yW0/eceswR3PnFUw/5/KpVq5g5c+ZB7YsWLeKdd97h3XffZefOnXz+85/n/PPP7/d848ePZ+XKlTz44IPcfffdPPLII9x8883U1tbyrW99K6vPkpJxz93M5gBXA1/3no1Ym4FJaYc1AJ9kXl5uvbphJwB/f/3pB7T/w5enAXDHs++hPWVFZKBeffVVbrzxRioqKpgwYQIXXHABy5Yt6/d1119/PQAzZ85k8+bNeakto567mV0O/A1wgbvvT3vqOeAXZnYPcAwwBXgr6ypz5PVNrRw1ejhnnzDugPbjx41iWsOR/L75U9bvaOOkCaMLVKGI9OdwPex8OfXUU1m4cOFB7YfqDFZWVpJMJrsf956jPnz4cAAqKiqIx+Pkw0CmQj4BvA6cbGbNZnYTcD8wGnjBzN4xs4cB3H018DSwBvgNcIu7J/JS+SC5O69vbOXsE/v+IsQDX5sBwJ/+tP/fuiJSXi666CJisRg//vGPu9uWLVtGXV0dTz31FIlEgpaWFl5++WVmzZrF8ccfz5o1a4jFYnz66acsWbKk33OMHj2avXv35qzmfnvu7n5jH80/Oczx3wO+l01R+bCxpY2dbbGDeu0pk8aO5JwTx/HaxlaNvYvIAcyMZ599lttuu4277rqLmpoaGhsbuffee2lra+OMM87AzPjBD37A0UcH1/O++tWvMm3aNKZMmcKZZ57Z7zm++MUv8pWvfIXFixdz33338YUvfCG7mothjLmpqcnzvVnHv7y+mb9bvJqXv/3HHDduZJ/HrNu2l8vufZkzJo1h8S3n5rUeERm4tWvXcsoppxS6jILq68/AzFa4e1Nfx5fN8gOvb2zl2DEjmDR2xCGPOfno0Xy1qYF3t+zhtx8M3fRMEZFcK4twTyadNza1ctYJ/S889OdfOAGAf3lt8xBUJiKSH2UR7hta2ti9v4uzThjb77EnTRjNjbOO460PdxFPJPs9XkSGRjEMIRdKJp+9LMJ9U8s+IBh2GYizTxzH3licJ5dt6f9gEcm7mpoaWltbyzLgU+u519TUDOp1ZbFZR/PuYCr+pLq+L6T2du6JwYyaB5Zu4Ot/dFxZLzUqUgwaGhpobm5mKJcqKSapnZgGo0zCvZ3a4ZWMGTmwLarG1Q7nb686hf/772t59Hebuem8ge9+IiK5V1VVNahdiKRMhmW27NpPQ92IQfXArzszWO9s0crmfJUlIpI3ZRHuzbvbaRjgkEzK+Nrh/NWlJ7Fm62fs2d+Zp8pERPIj8uHu7mzZvf+w89sP5ewTx+EOdz+/Lg+ViYjkT+TDfde+TvZ3JgZ8MTXdGQ1jAHh6WTOxeFEskSMiMiCRD/fm3e0ANNQNvudeXTmM+X8yk85EkjueXdX/C0REikTkw31Lahrk2MH33AEuOLmeI0dUsXBFM22x/CzNKSKSa9EP912Z99wBhldW8N1rgvWj//7Xa3NWl4hIPkU+3Jt372fMyCpG1wxsjntfrjnjGKYcVcvjb37Mll37+3+BiEiBRT7ct+xuz+hiarphw4zbLjkJgKe0JIGIlIDIh3vzrsymQfZ21bSJTJ80hvuXbuDDnftyUJmISP5EOtyTSad5z+C/wHQot/7xfwFg3qLf82l7V07eU0QkHyId7i1tMTrjSSZleDG1t0umTuCUiUfwxqZdPPzbjTl5TxGRfIh0uKdWg2zIcBpkX57572dzwvhRPPTSRv6wpz1n7ysikkuRDvdtn8YAOPqIwa2DfDgjqyu5JRyeeWrZFto79c1VESk+kQ731n1BuI+vHZ7T9/3yzAZOmlDLj5as5/x/XEqXdmwSkSIT7XBv68QM6ga4jvtg/OjGM/lv5zTSsjfGdxa9py35RKSo9BvuZvaome0ws1VpbWPN7AUzWx/e1qU9N8/MNpjZOjO7LF+FD0Trvhh1I6uprMj977DPHX0Et10yBYB/XdHMi+/vyPk5REQyNZDUewy4vFfb7cASd58CLAkfY2ZTgdnAqeFrHjSzipxVO0itbZ2MHVWdt/cfM7Katf/ncqoqjO88+x5X3/cKG3a05e18IiID1e82e+7+spk19mq+FrgwvL8AeAn4m7D9SXePAR+a2QZgFvB6juodlNa2TsblMdwBRlRX8LdXTeWNTa38ZvU2fv7GR3x5RrDXYd2oqozm2G/YsZf2Tg3ziJSDI0dUcdy43M3oS8l0D9UJ7r4VwN23mtlRYfuxwBtpxzWHbQWxc1+MU44+Iu/nmXNOI3POaeSa+1/lsdc289hrmwGorhjGa/MuGtQF3Tc2tTJ7/hv9HygikXD1tInc/7UZOX/fXG+Q3dcmpd7ngWZzgbkAxx13XI7LCOza18m42vz23NM99I2ZrP3kMyCYY/+/f7mG7yx6j2PGDPxLVKv+8CmVw4z7vzaDymED3/NVRErThBxO1U6XabhvN7OJYa99IpC6mtgMTEo7rgH4pK83cPf5wHyApqamPn8BZKMrkWTP/q68jrn3duyYERwbBnk8kWThymbe2NQ66Pe5etpELj/t6FyXJyJlJNNwfw6YA9wV3i5Oa/+Fmd0DHANMAd7KtshM7N4XbGqd7zH3Q6msGMav/uILBTm3iEi/4W5mTxBcPB1vZs3AnQSh/rSZ3QR8DNwA4O6rzexpYA0QB25x94J8hXPX/iDcx47K7ReYRERKwUBmy9x4iKcuPsTx3wO+l01RubBnf7BqYz6+wCQiUuwi+w3VPWHP/UiFu4iUociG++7unnthxtxFRAopsuG+R+EuImUswuHeSXXlMGqqIvsRRUQOKbLJt2d/F3UjqzDTF4FEpPxENtx37+/UkIyIlK3Ihvue/V2M0UwZESlT0Q339k7GjFDPXUTKU2TDfff+LupGqecuIuUpkuHu7uzZ38kYjbmLSJmKZLh/1hGnK+EFWzRMRKTQIhnurW0xgEFtkiEiEiXRDPd9qRUh1XMXkfIUzXBvC9dyH8JdmEREikkkwz21IqQuqIpIuYpkuLfF4gCMrsn1FrEiIqUh0uE+qlrhLiLlKZrh3hFnZHUFFcO0aJiIlKdIhvu+zjijhqvXLiLlK5LhvrcjzmiFu4iUsUiG+76Yeu4iUt4iGe5tsTi1CncRKWMRDfeEeu4iUtYiGu5dmuMuImUtq3A3s780s9VmtsrMnjCzGjMba2YvmNn68LYuV8UO1L5YglHDK4b6tCIiRSPjcDezY4H/ATS5+2lABTAbuB1Y4u5TgCXh4yHV1hGndrg26hCR8pXtsEwlMMLMKoGRwCfAtcCC8PkFwHVZnmNQYvEEnYkkteq5i0gZyzjc3f0PwN3Ax8BW4FN3fx6Y4O5bw2O2Akf19Xozm2tmy81seUtLS6ZlHGRfLAGg2TIiUtayGZapI+ilTwaOAUaZ2TcG+np3n+/uTe7eVF9fn2kZB9mXWldG4S4iZSybYZlLgA/dvcXdu4BFwDnAdjObCBDe7si+zIHb26EVIUVEsgn3j4GzzGykmRlwMbAWeA6YEx4zB1icXYmD06aeu4gIGSegu79pZguBlUAceBuYD9QCT5vZTQS/AG7IRaEDlRqW0Zi7iJSzrBLQ3e8E7uzVHCPoxRfEXoW7iEj0vqHa3XPXmLuIlLHIhXtbh3ruIiLRC3dtsSciEs1wH1VdwTBtsSciZSxy4a6NOkREIhjue2NxXUwVkbIXuXDfp12YRESiF+7Bcr8KdxEpb9ELd425i4hEM9xHK9xFpMxFLtw1W0ZEJILh3qbZMiIi0Qr3WDxBV8J1QVVEyl6kwl3ryoiIBCIV7qn9UzXmLiLlLlLhvjfWBajnLiISqXBP9dwV7iJS7iIV7m2pnrtmy4hImYtUuO/tvqBaUeBKREQKK1Lh3jMsU1XgSkRECitS4Z4alhmlnruIlLmIhXs4FVJb7IlImYtWuHdoiz0REYhYuO/TujIiIkCW4W5mY8xsoZm9b2ZrzexsMxtrZi+Y2frwti5XxfZHa7mLiASy7bn/E/Abd/8ccAawFrgdWOLuU4Al4eMhobXcRUQCGYe7mR0BnA/8BMDdO919D3AtsCA8bAFwXXYlDpx67iIigWx67icALcBPzextM3vEzEYBE9x9K0B4e1RfLzazuWa23MyWt7S0ZFFGD22OLSISyCbcK4EZwEPufiawj0EMwbj7fHdvcvem+vr6LMro0aZwFxEBsgv3ZqDZ3d8MHy8kCPvtZjYRILzdkV2JA9fRlaCmWl9gEhHJONzdfRuwxcxODpsuBtYAzwFzwrY5wOKsKhyE9s4EI6oU7iIi2Y5h/AXwuJlVA5uAPyX4hfG0md0EfAzckOU5BsTdae9SuIuIQJbh7u7vAE19PHVxNu+bia6Ek3SoqYrU97JERDISmSRs7wrWlalRz11EJDrhHlO4i4h0i0y4p3ruGnMXEYliuGsqpIhIdMK9oysJ6IKqiAhEKNzbOzXmLiKSEplw74gr3EVEUqIT7p26oCoikhKZcNdsGRGRHpEJ954Lqgp3EZHIhLt67iIiPSIT7h2pb6hWR+YjiYhkLDJJ2NGVwAyqKyLzkUREMhaZJEyt5W5mhS5FRKTgIhPuHfGELqaKiIQiE+7tnUldTBURCUUm3Du6ElpXRkQkFJk0DMJdPXcREYhQuGv/VBGRHpEJd/XcRUR6RCbc27uSCncRkVBkwr2jK6FdmEREQpEK95rKyHwcEZGsZJ2GZlZhZm+b2a/Cx2PN7AUzWx/e1mVfZv/a1XMXEemWi67uN4G1aY9vB5a4+xRgSfg47zo0W0ZEpFtW4W5mDcBVwCNpzdcCC8L7C4DrsjnHQCSTTkdXkuEKdxERIPue+73AXwPJtLYJ7r4VILw9Kstz9CsWD06vnruISCDjcDezq4Ed7r4iw9fPNbPlZra8paUl0zKAtLXctfyAiAiQXc/9XOAaM9sMPAlcZGY/B7ab2USA8HZHXy929/nu3uTuTfX19VmUoV2YRER6yzjc3X2euze4eyMwG3jR3b8BPAfMCQ+bAyzOusp+dIe7ZsuIiAD5med+F3Cpma0HLg0f51VqWGZ4pcJdRASgMhdv4u4vAS+F91uBi3PxvgPVoZ67iMgBInEFsqMrmC2jb6iKiAQikYbtneq5i4iki0a4a7aMiMgBIhHuPfPcFe4iIqBwFxGJpIiEe7j8gMbcRUSAiIR7asxds2VERAKRSMP2rgRVFUZlRSQ+johI1iKRhsEuTBqSERFJiU64a7xdRKRbJMK9vVO7MImIpItEuHd0JbWWu4hImkgkYrv2TxUROUAkwr2jK6H9U0VE0kQm3NVzFxHpEYlw17CMiMiBIhHuuqAqInKgSCRie1dC68qIiKSJRLh3dCW0IqSISJpIhHusK6nNsUVE0pR8uCeTTmciyXCtCCki0q3kE7EzEazlPlwXVEVEupV8IsbCjTo0LCMi0qP0wz0RbNShYRkRkR4ZJ6KZTTKzpWa21sxWm9k3w/axZvaCma0Pb+tyV+7BenruCncRkZRsEjEO/E93PwU4C7jFzKYCtwNL3H0KsCR8nDexeGrMXcMyIiIpGYe7u29195Xh/b3AWuBY4FpgQXjYAuC6LGs8rFg8GJap1hZ7IiLdcpKIZtYInAm8CUxw960Q/AIAjjrEa+aa2XIzW97S0pLxuXt67gp3EZGUrBPRzGqBZ4Db3P2zgb7O3ee7e5O7N9XX12d8fo25i4gcLKtENLMqgmB/3N0Xhc3bzWxi+PxEYEd2JR5e9zx3TYUUEemWzWwZA34CrHX3e9Keeg6YE96fAyzOvLz+xbo0FVJEpLfKLF57LvAnwHtm9k7Y9h3gLuBpM7sJ+Bi4IasK+5Eac9eSvyIiPTIOd3d/FbBDPH1xpu87WKlwr67QsIyISErJd3dTUyE1W0ZEpEfJJ6Jmy4iIHKzkE7F7nrtmy4iIdCv5cO9Mjbmr5y4i0q3kEzEWT1BVYVQMO9S1XRGR8hOBcE9qXRkRkV5KPhVj8YRWhBQR6aX0w71L+6eKiPRW8qkYiyvcRUR6K/lU7IwnNQ1SRKSXkg/3YMy95D+GiEhOlXwqalhGRORgJZ+KsXhSX2ASEeml5FMxFk9ozF1EpJfSD3dNhRQROUjJp2JnQuEuItJbyadi0HPXsIyISLrSD3dNhRQROUjJp6IWDhMROVjJp2IsnlTPXUSkl5JOxXgiSSLpGnMXEemlpMO9M6H9U0VE+lLSqajNsUVE+lbSqdi9ObY26xAROUDewt3MLjezdWa2wcxuz8c5YvEEgGbLiIj0kpdUNLMK4AHgCmAqcKOZTc31eXp67gp3EZF0+UrFWcAGd9/k7p3Ak8C1uT5Jz5i7hmVERNLlK9yPBbakPW4O27qZ2VwzW25my1taWjI6SW1NJVedPpGJR9ZkXqmISATlK9ytjzY/4IH7fHdvcvem+vr6jE4yefwoHvj6DE479siMXi8iElX5CvdmYFLa4wbgkzydS0REeslXuC8DppjZZDOrBmYDz+XpXCIi0ktlPt7U3eNmdivwH0AF8Ki7r87HuURE5GB5CXcAd/818Ot8vb+IiByaJoiLiESQwl1EJIIU7iIiEaRwFxGJIHP3/o/KdxFmLcBHWbzFeGBnjsrJl1KoEVRnLpVCjaA6c2moazze3fv8FmhRhHu2zGy5uzcVuo7DKYUaQXXmUinUCKozl4qpRg3LiIhEkMJdRCSCohLu8wtdwACUQo2gOnOpFGoE1ZlLRVNjJMbcRUTkQFHpuYuISBqFu4hIBJV0uA/FJtyDqOVRM9thZqvS2saa2Qtmtj68rUt7bl5Y9zozu2yIapxkZkvNbK2ZrTazbxZpnTVm9paZvRvW+d1irDM8b4WZvW1mvyriGjeb2Xtm9o6ZLS/iOseY2UIzez/8b/TsYqvTzE4O/xxTP5+Z2W3FVicA7l6SPwRLCW8ETgCqgXeBqQWs53xgBrAqre0HwO3h/duBfwjvTw3rHQ5MDj9HxRDUOBGYEd4fDXwQ1lJsdRpQG96vAt4Eziq2OsNz/xXwC+BXxfh3Hp57MzC+V1sx1rkA+PPwfjUwphjrTKu3AtgGHF+MdQ7ZH0Qe/mDPBv4j7fE8YF6Ba2rkwHBfB0wM708E1vVVK8G692cXoN7FwKXFXCcwElgJ/FGx1Umww9gS4KK0cC+qGsNz9RXuRVUncATwIeEkj2Kts1dt/xX4XbHWWcrDMv1uwl0EJrj7VoDw9qiwveC1m1kjcCZBr7jo6gyHO94BdgAvuHsx1nkv8NdAMq2t2GqEYP/i581shZnNLdI6TwBagJ+Gw1yPmNmoIqwz3WzgifB+0dVZyuHe7ybcRaygtZtZLfAMcJu7f3a4Q/toG5I63T3h7tMJesezzOy0wxw+5HWa2dXADndfMdCX9NE2VH/n57r7DOAK4BYzO/8wxxaqzkqCYc2H3P1MYB/B8MahFPr/oWrgGuBf+zu0j7YhqbOUw70UNuHebmYTAcLbHWF7wWo3syqCYH/c3RcVa50p7r4HeAm4nOKq81zgGjPbDDwJXGRmPy+yGgFw90/C2x3As8CsIqyzGWgO/4UGsJAg7IutzpQrgJXuvj18XHR1lnK4l8Im3M8Bc8L7cwjGuFPts81suJlNBqYAb+W7GDMz4CfAWne/p4jrrDezMeH9EcAlwPvFVKe7z3P3BndvJPhv70V3/0Yx1QhgZqPMbHTqPsE48apiq9PdtwFbzOzksOliYE2x1ZnmRnqGZFL1FFedQ3kBIg8XNK4kmPGxEbijwLU8AWwFugh+W98EjCO44LY+vB2bdvwdYd3rgCuGqMbzCP5J+HvgnfDnyiKscxrwdljnKuDvwvaiqjPt3BfSc0G1qGokGMt+N/xZnfr/pNjqDM87HVge/r3/G1BXpHWOBFqBI9Paiq5OLT8gIhJBpTwsIyIih6BwFxGJIIW7iEgEKdxFRCJI4S4iEkGVhS5ApJDMLAG8R7BAWZxg8ap73T152BeKFDmFu5S7dg+WOcDMjiJY4fFI4M5CFiWSLQ3LiIQ8+Hr+XOBWCzSa2StmtjL8OQfAzH5mZtemXmdmj5vZNYWqW6Qv+hKTlDUza3P32l5tu4HPAXuBpLt3mNkU4Al3bzKzC4C/dPfrzOxIgm/6TnH3+FDXL3IoGpYROVhqJb8q4H4zmw4kgJMA3P23ZvZAOIxzPfCMgl2KjcJdJI2ZnUAQ5DsIxt23A2cQDGF2pB36M+DrBIuG/dkQlynSL4W7SMjM6oGHgfvd3cMhl2Z3T5rZHIJt1VIeI1jdb5u7rx76akUOT+Eu5W5EuONTairkz4DUcsgPAs+Y2Q3AUoINJABw9+1mtpZg9UKRoqMLqiIZMLORBPPjZ7j7p4WuR6Q3TYUUGSQzS20ecp+CXYqVeu4iIhGknruISAQp3EVEIkjhLiISQQp3EZEIUriLiETQ/wfNyQ9PToV02QAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "LS_tf.plot.line(x=\"Day\",y=\"Count\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "id": "2a04e9ce",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='Day'>"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAEGCAYAAAB8Ys7jAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjQuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/MnkTPAAAACXBIWXMAAAsTAAALEwEAmpwYAAAXdklEQVR4nO3de5BcZZnH8d8zPTdCEi7JEAIhTNBwv4QwRrkYXFAXXS4rixYUuil1K0XVsmtcRaGsXcrdfxApxQKRioCxhAXKAOKy1ioFyQKrYi4EyA1BiTACySTK3Uzfnv3jnO6ZzExmOt1nps875/upmpqeM6f7PDOEX568/Z73NXcXACA8Lc0uAABQHwIcAAJFgANAoAhwAAgUAQ4AgWqdyIvNnDnTu7u7J/KSABC8devW7XT3rqHHJzTAu7u7tXbt2om8JAAEz8z+MNJxhlAAIFAEOAAEigAHgEBN6Bg4AOxNoVBQb2+vdu/e3exSmqazs1Nz5sxRW1tbTecT4ABSobe3V9OmTVN3d7fMrNnlTDh3165du9Tb26t58+bV9Jwxh1DM7A4z22FmGwcd+6aZbTWzZ8zsATM7sP6yAUDavXu3ZsyYkcnwliQz04wZM/bpXyC1jIGvkHTekGMPSzrR3U+W9FtJ19R8RQDYi6yGd8W+/vxjDqG4+2Nm1j3k2C8GfflrSZfs01XHSbnsWvHLbXr93XxN50/fr02fPXOeci3Z/kMDIExJjIF/TtK9e/ummS2VtFSS5s6dm8Dl9u73O9/Rvz+0Ob7u6OdWlkE/870zddzs6eNaF4BwvPbaa1q2bJnWrFmjjo4OdXd368Ybb9TRRx+dyOuvXr1a7e3tOuOMMxp+rYYC3My+Jqko6a69nePuyyUtl6Senp5x3T1id6EkSVr+mdP00RMOHfXcVVt36LMr1lSfAwDurk984hNasmSJ7rnnHknShg0btH379kQDfOrUqYkEeN3zwM1siaTzJV3uKdnWp1AqS5LaWsf+sdpyLfFzUlE6gBRYtWqV2tradMUVV1SPLViwQGeddZauuuoqnXjiiTrppJN0773RoMPq1at1/vnnV8+98sortWLFCknR0iHXXnutFi5cqJNOOklbt27Vtm3bdOutt+rb3/62FixYoMcff7yheuvqwM3sPElflXS2u7/bUAUJyhejAO/IjR3g7XHIV54DID2+/l+btPmVNxN9zeMPm65rLzhh1HM2btyo0047bdjx+++/Xxs2bNDTTz+tnTt36n3ve58WL1485jVnzpyp9evX65ZbbtENN9yg2267TVdccYWmTp2qL3/5y3X/LBW1TCO8W9KvJB1jZr1m9nlJN0uaJulhM9tgZrc2XEkCKt10bR24xc8hwAGM7oknntBll12mXC6nWbNm6eyzz9aaNWvGfN7FF18sSTrttNO0bdu2xOuqZRbKZSMcvj3xShKQL0Xj2W01dOCVc/rpwIHUGatTHi8nnHCCVq5cOez43kaJW1tbVS4PZMjQOdwdHR2SpFwup2KxmGClkUm1Fkq+GP2S22sI8I7Wyhg4AQ4gcs4556i/v1/f//73q8fWrFmjgw46SPfee69KpZL6+vr02GOPadGiRTryyCO1efNm9ff364033tAjjzwy5jWmTZumt956K5F6J9Wt9Pk4jNtbx57XXenAGQMHUGFmeuCBB7Rs2TJdd9116uzsrE4jfPvtt3XKKafIzHT99dfr0EOjmW6f+tSndPLJJ2v+/Pk69dRTx7zGBRdcoEsuuUQPPvigbrrpJn3wgx+sv96JnEDS09Pj47mhw33revWlHz+tx676K82dMWXUc195/S8647pHdd3FJ+nSReM7Px3A2LZs2aLjjjuu2WU03Ui/BzNb5+49Q8+dXEMo1WmE+9CBM4QCIFCTKsAr49m1jIEzjRBA6CZVgFfCuJZphO104EDqpOSewKbZ159/cgV4HR14oZjtPzBAWnR2dmrXrl2ZDfHKeuCdnZ01P2dyzUIp1h7guRZTiw3MHQfQXHPmzFFvb6/6+vqaXUrTVHbkqdWkCvBCqazWFlNLjcvDtre2sBYKkBJtbW0170SDyKQJ8EKprHfzpZruwqxoy7Xo3XxxxBUJ23MtNf9FAADNMCkC/MWd7+i8Gx9Tf7Gsg/dvr/l5U9pzuvPXL+nOX7807HtnH92lH35uUZJlAkCiJkWA//HPf1F/sazL3z9XHz5+Vs3P++Ylp2jTCCue/fezr+h3fW8nWSIAJG5SBHhl/vcne47QgiMOrPl5i4/u0uKju4Yd/8Oud7TquR1JlQcA42JSTCOsrChYWSK2UW25Fm7wAZB6kyLAKx14Rw038NSC2SkAQjApArx6B+Y+zEAZDR04gBBMigCvroGSYAeeL5Uze0cYgDBMigCvrkKYUAfeXt1ujQAHkF6TI8CLyXfgErv1AEi3yRHg+7CIVS3YrQdACCZFgFdWFExsCIUOHEAAJkWA50sl5VpMuYTWLmHHegAhmBQBXih5YsMnEjvWAwjDpAjwfLGc2F2YEvtlAgjDmAFuZneY2Q4z2zjo2MFm9rCZPR9/Pmh8yxxdvlRWe2susderdPPs1gMgzWrpwFdIOm/IsaslPeLu8yU9En/dNPliuTp3OwmVPTXZrQdAmo25GqG7P2Zm3UMOXyTpQ/HjH0paLemrSRZWq5889Uetf+nPic0BlwY68Nsef1EPPfNqYq8LILsuf/9cvfeQaYm+Zr3Lyc5y91clyd1fNbND9naimS2VtFSS5s6dW+fl9u4/HtqsN3cXdMEphyX2mkfOmKLDDujUEy/sTOw1AWTbucfOSk2A18zdl0taLkk9PT2JDyr3F8v6+9O79a/nH5/Yax524H765TXnJvZ6ADAe6h132G5msyUp/ty03Q+iGSiTYjINAOyTepPvp5KWxI+XSHowmXL2jbvHM1AIcADZU8s0wrsl/UrSMWbWa2afl3SdpI+Y2fOSPhJ/PeEqqwUmOQMFAEJRyyyUy/byraYPEie9DjgAhCTo5Et6Jx4ACEnQyUcHDiDLgk6+fjpwABkWdPIlvRs9AIQk6ORLei9MAAhJ0MlXWS0wybXAASAUQSdfZbXANoZQAGRQ0MmXpwMHkGFBJ191N/pW7sQEkD1BB/juQjSE0p5LbjceAAhF0AF+86MvSJL2ayfAAWRP0AHe3tqiXIvpPV37N7sUAJhwQQd4vljW4vkzZcYYOIDsCTrACyU2cwCQXUGnX77IZg4Asivo9MuXyswBB5BZQadfge3UAGRY0OnHhsYAsizo9CuUnA4cQGYFnX504ACyLNj0c/f4TUzmgAPIpmADvFCKVyJkCAVARgWbfgV24wGQccGmHzvSA8i6htLPzL5oZpvMbKOZ3W1mnUkVNpY8O9IDyLi608/MDpf0z5J63P1ESTlJlyZV2FjydOAAMq7R9GuVtJ+ZtUqaIumVxkuqzXdXRWuBcys9gKyqO/3c/Y+SbpD0kqRXJb3h7r8Yep6ZLTWztWa2tq+vr/5KBymXXXf/5mVJ0rGzpyXymgAQmkaGUA6SdJGkeZIOk7S/mX166Hnuvtzde9y9p6urq/5KB6kMn3zlvGN07KHTE3lNAAhNI+MPH5b0orv3uXtB0v2SzkimrNFVx78ZPgGQYY0k4EuSPmBmUyzaEudcSVuSKWt0lRkovIEJIMsaGQN/UtJKSeslPRu/1vKE6hoVN/EAQDSLpG7ufq2kaxOqpWbVDpwAB5BhQSZgtQNnCAVAhgWZgPlivJAVHTiADAsyAQfuwmQpWQDZFWSAVxeyyuWaXAkANE+QAT6wkBUdOIDsCjPAWcgKAAINcJaSBYAwA7wyBt5BBw4gw4JMQDpwAAg0wLmRBwACDXBupQeAUAO8xJ2YABBkArKcLAAEGuADy8lyIw+A7AoywPPFslpMamUIBUCGBZmAhVKZKYQAMi/IFMyXyox/A8i8IFMwXywzAwVA5gWZggU6cAAIM8DzRcbAASDIFCyUnA4cQOYFmYL9dOAAEGaAMwYOAIEGeDQLhbswAWRbQwFuZgea2Uoz22pmW8zs9KQKGw038gCA1Nrg878j6X/c/RIza5c0JYGaxpQvlTW1s9HSASBsdbexZjZd0mJJt0uSu+fd/fWE6tqrN3cX9EzvG3TgADKvkRQ8SlKfpB+Y2VNmdpuZ7T/0JDNbamZrzWxtX19fA5eLPNv7hiRp1vSOhl8LAELWSIC3Sloo6XvufqqkdyRdPfQkd1/u7j3u3tPV1dXA5SL5eCnZixfOafi1ACBkjQR4r6Red38y/nqlokAfV2ynBgCRulPQ3V+T9LKZHRMfOlfS5kSqGkVlMwfmgQPIukancvyTpLviGSi/l/TZxksaHR04AEQaCnB33yCpJ5lSalPdTo0OHEDGBZeCdOAAEAkuBfMll0SAA0BwKVjtwBlCAZBxwaVgdQycxawAZFxwAZ4vltViUitDKAAyLrgUZCVCAIgEl4T9RTZzAAApwAAvlMrMQAEABRjgeTpwAJAUYIC/9Kd31coMFAAIK8Df7i/qyRf/VJ0LDgBZFlaA7y5Kkv6OtcABIKwAr3Te7+ma2uRKAKD5wgpwViIEgKqgkpCVCAFgQFBJOLAbD7NQACDMAM/lmlwJADRfUAFeGUJhJUIACC3A2dAYAKqCSsKBDjyosgFgXASVhIV4O7UOOnAACCvA86WSJDpwAJACC/BCMd7QmA4cAMIK8P4SY+AAUNFwEppZzsyeMrOHkihoNAXuxASAqiSS8AuStiTwOmNiGiEADGgoCc1sjqS/kXRbMuWMrsCNPABQ1Wgre6Okr0ja6w4LZrbUzNaa2dq+vr6GLpYvldViUitDKABQf4Cb2fmSdrj7utHOc/fl7t7j7j1dXV31Xk5SFOC8gQkAkUbS8ExJF5rZNkn3SDrHzO5MpKq9YENjABhQdxq6+zXuPsfduyVdKulRd/90YpWNoFAqMwMFAGJBpSEdOAAMaE3iRdx9taTVSbzWaAolZwwcAGJBpSEdOAAMCCoNmYUCAAOCSkM6cAAYEFQaRrNQuAsTAKTAApwOHAAGBJWGBcbAAaAqqDTsL3IjDwBUBJWGhVJZbQyhAICkwAI8Xyqrgw4cACQFFuCFIndiAkBFUGmYL5XV1so0QgCQAgvwQrGs9lyu2WUAQCoEFeD9dOAAUBVMgLu7CryJCQBVwaRhsexyF29iAkAsmDQslKJ9k7mVHgAiwaRhvhgFOB04AESCScM8HTgA7CGYNKx04KyFAgCRYNKwUHJJdOAAUBFMGjIGDgB7CiYNmYUCAHsKJg37qx04d2ICgBRQgNOBA8Ce6k5DMzvCzFaZ2RYz22RmX0iysKGYhQIAe2pt4LlFSV9y9/VmNk3SOjN72N03J1TbHujAAWBPdaehu7/q7uvjx29J2iLp8KQKG2rlul5JzEIBgIpE0tDMuiWdKunJEb631MzWmtnavr6+uq+x8+1+SdK8mfvX/RoAMJk0HOBmNlXSfZKWufubQ7/v7svdvcfde7q6uuq+Tr5Y1oeO6VJnGxs6AIDUYICbWZui8L7L3e9PpqSR5UvOG5gAMEgjs1BM0u2Strj7t5IraWT5YkltvIEJAFWNJOKZkj4j6Rwz2xB/fDyhuoYp0IEDwB7qnkbo7k9ImrDbIvPFMgEOAIMEk4gFNjQGgD0EE+BRB84MFACoCCfA6cABYA9BBLi7K18qq4MxcACoCiIRS2WXO7fRA8BgQSQiGxoDwHBBJGKhGO2HSQcOAAOCSMT+UkkSHTgADBZEIlZ3pKcDB4CqIBKxuhsPHTgAVAWRiJXdeBgDB4ABQSQiHTgADBdEIuarHTh3YgJARRgBTgcOAMMEkYjVHekZAweAqiASsdKB8yYmAAwIIhEL3EoPAMMEkYj9dOAAMEwQiVi5E7ODDhwAqoJIRMbAAWC4IBKRMXAAGC6IRBzowLmRBwAqwghwOnAAGCaIRKx24C1BlAsAE6KhRDSz88zsOTN7wcyuTqqooQqlstpyppYWhlAAoKLuADeznKTvSvqYpOMlXWZmxydV2GD5YpkZKAAwRCOpuEjSC+7+e3fPS7pH0kXJlLWnQqnM+DcADNHawHMPl/TyoK97Jb1/6ElmtlTSUkmaO3duXRc6bvZ07S6U63ouAExWjbS1Iw1I+7AD7svdvcfde7q6uuq60KWL5uobl5xc13MBYLJqJMB7JR0x6Os5kl5prBwAQK0aCfA1kuab2Twza5d0qaSfJlMWAGAsdY+Bu3vRzK6U9HNJOUl3uPumxCoDAIyqkTcx5e4/k/SzhGoBAOwD5uYBQKAIcAAIFAEOAIEiwAEgUOY+7N6b8buYWZ+kP9T59JmSdiZYznihzuSEUKNEnUkKoUZp4us80t2H3Qk5oQHeCDNb6+49za5jLNSZnBBqlKgzSSHUKKWnToZQACBQBDgABCqkAF/e7AJqRJ3JCaFGiTqTFEKNUkrqDGYMHACwp5A6cADAIAQ4AAQqiACfqM2Ta6jjDjPbYWYbBx072MweNrPn488HDfreNXHNz5nZX09gnUeY2Soz22Jmm8zsC2mr1cw6zew3ZvZ0XOPX01bjkHpzZvaUmT2U1jrNbJuZPWtmG8xsbYrrPNDMVprZ1vjP6OlpqtPMjol/h5WPN81sWZpqrHL3VH8oWqr2d5KOktQu6WlJxzeplsWSFkraOOjY9ZKujh9fLekb8ePj41o7JM2Lf4bcBNU5W9LC+PE0Sb+N60lNrYp2dJoaP26T9KSkD6SpxiH1/ouk/5T0UIr/u2+TNHPIsTTW+UNJ/xA/bpd0YBrrjK+fk/SapCPTWOOE/BIa/AWeLunng76+RtI1TaynW3sG+HOSZsePZ0t6bqQ6Fa2bfnqTan5Q0kfSWqukKZLWK9pTNXU1Ktpt6hFJ5wwK8DTWOVKAp6pOSdMlvah4AkVa6xx0vY9K+r+01hjCEMpImycf3qRaRjLL3V+VpPjzIfHxVNRtZt2STlXU4aaq1nhYYoOkHZIedvfU1Ri7UdJXJA3eWTuNdbqkX5jZungz8TTWeZSkPkk/iIekbjOz/VNYZ8Wlku6OH6euxhACvKbNk1Oo6XWb2VRJ90la5u5vjnbqCMfGvVZ3L7n7AkUd7iIzO3GU05tSo5mdL2mHu6+r9SkjHJuo/+5nuvtCSR+T9I9mtniUc5tVZ6uiYcjvufupkt5RNByxN037fcZbRV4o6cdjnTrCsQmpMYQAT/vmydvNbLYkxZ93xMebWreZtSkK77vc/f401+rur0taLem8FNZ4pqQLzWybpHsknWNmd6awTrn7K/HnHZIekLQohXX2SuqN/7UlSSsVBXra6pSivwjXu/v2+OvU1RhCgKd98+SfSloSP16iaLy5cvxSM+sws3mS5kv6zUQUZGYm6XZJW9z9W2ms1cy6zOzA+PF+kj4saWuaapQkd7/G3ee4e7eiP3uPuvun01anme1vZtMqjxWN3W5MW53u/pqkl83smPjQuZI2p63O2GUaGD6p1JKuGifqzYAG30j4uKKZFL+T9LUm1nG3pFclFRT9rft5STMUvcH1fPz54EHnfy2u+TlJH5vAOs9S9E+4ZyRtiD8+nqZaJZ0s6am4xo2S/i0+npoaR6j5Qxp4EzNVdSoaW346/thU+f8kbXXG110gaW383/4nkg5KW52K3ljfJemAQcdSVaO7cys9AIQqhCEUAMAICHAACBQBDgCBIsABIFAEOAAEqrXZBQDjzcxKkp5VtGhWUdFiSje6e3nUJwIpR4AjC/7i0S37MrNDFK0qeICka5tZFNAohlCQKR7dZr5U0pUW6Tazx81sffxxhiSZ2Y/M7KLK88zsLjO7sFl1AyPhRh5Memb2trtPHXLsz5KOlfSWpLK77zaz+ZLudvceMztb0hfd/W/N7ABFd7POd/fiRNcP7A1DKMiqygpybZJuNrMFkkqSjpYkd/9fM/tuPORysaT7CG+kDQGOzDGzoxSF9Q5F4+DbJZ2iaEhx96BTfyTpckWLWH1ugssExkSAI1PMrEvSrZJudnePh0d63b1sZksUbaFVsULRqnKvufumia8WGB0BjizYL975pzKN8EeSKsvs3iLpPjP7pKRVijYYkCS5+3Yz26JoxTwgdXgTE9gLM5uiaP74Qnd/o9n1AEMxjRAYgZlVNpi4ifBGWtGBA0Cg6MABIFAEOAAEigAHgEAR4AAQKAIcAAL1/3jOkxoDZRehAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "LP_tf.plot.line(x=\"Day\",y=\"Count\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "id": "b9006e8d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.000379732639"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LS_Opening[\"LS_loan_amnt_stable\"].min()/10**12\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "b1b45743",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "176808.3794773591"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LS_Opening[\"LS_loan_amnt_stable\"].max()/10**12\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "id": "a91db86f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "12972.839939890237"
      ]
     },
     "execution_count": 74,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LS_Opening[\"LS_loan_amnt_stable\"].mean()/10**12\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "480bc906",
   "metadata": {},
   "outputs": [],
   "source": [
    "PL_State.to_csv(\"PL_State.csv\")\n",
    "LS_State.to_csv(\"LS_State.csv\")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "48398cd6",
   "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>LS_timestamp</th>\n",
       "      <th>LS_contract_id</th>\n",
       "      <th>LS_amnt_stable</th>\n",
       "      <th>LS_principal_stable</th>\n",
       "      <th>LS_current_margin_stable</th>\n",
       "      <th>LS_current_interest_stable</th>\n",
       "      <th>LS_prev_interest_stable</th>\n",
       "      <th>LS_prev_margin_stable</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-08-21 03:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-08-22 03:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-08-23 03:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-08-24 03:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-08-25 03:00:00</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284848</th>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1070043</td>\n",
       "      <td>5.293060e+15</td>\n",
       "      <td>4.787541e+15</td>\n",
       "      <td>1.263798e+14</td>\n",
       "      <td>1.263798e+14</td>\n",
       "      <td>1.263798e+14</td>\n",
       "      <td>1.263798e+14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284849</th>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1070044</td>\n",
       "      <td>4.599959e+10</td>\n",
       "      <td>4.160954e+10</td>\n",
       "      <td>1.097512e+09</td>\n",
       "      <td>1.097512e+09</td>\n",
       "      <td>1.097512e+09</td>\n",
       "      <td>1.097512e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284850</th>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1070045</td>\n",
       "      <td>1.581224e+10</td>\n",
       "      <td>1.430207e+10</td>\n",
       "      <td>3.775410e+08</td>\n",
       "      <td>3.775410e+08</td>\n",
       "      <td>3.775410e+08</td>\n",
       "      <td>3.775410e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284851</th>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1070046</td>\n",
       "      <td>7.241021e+15</td>\n",
       "      <td>6.549962e+15</td>\n",
       "      <td>1.727648e+14</td>\n",
       "      <td>1.727648e+14</td>\n",
       "      <td>1.727648e+14</td>\n",
       "      <td>1.727648e+14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284852</th>\n",
       "      <td>2022-08-21 03:00:00</td>\n",
       "      <td>LScid1070047</td>\n",
       "      <td>1.799345e+10</td>\n",
       "      <td>1.627621e+10</td>\n",
       "      <td>4.293088e+08</td>\n",
       "      <td>4.293088e+08</td>\n",
       "      <td>4.293088e+08</td>\n",
       "      <td>4.293088e+08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>284853 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               LS_timestamp LS_contract_id  LS_amnt_stable  \\\n",
       "0       2020-08-21 03:00:00              0    0.000000e+00   \n",
       "1       2020-08-22 03:00:00              0    0.000000e+00   \n",
       "2       2020-08-23 03:00:00              0    0.000000e+00   \n",
       "3       2020-08-24 03:00:00              0    0.000000e+00   \n",
       "4       2020-08-25 03:00:00              0    0.000000e+00   \n",
       "...                     ...            ...             ...   \n",
       "284848  2022-08-21 03:00:00   LScid1070043    5.293060e+15   \n",
       "284849  2022-08-21 03:00:00   LScid1070044    4.599959e+10   \n",
       "284850  2022-08-21 03:00:00   LScid1070045    1.581224e+10   \n",
       "284851  2022-08-21 03:00:00   LScid1070046    7.241021e+15   \n",
       "284852  2022-08-21 03:00:00   LScid1070047    1.799345e+10   \n",
       "\n",
       "        LS_principal_stable  LS_current_margin_stable  \\\n",
       "0              0.000000e+00              0.000000e+00   \n",
       "1              0.000000e+00              0.000000e+00   \n",
       "2              0.000000e+00              0.000000e+00   \n",
       "3              0.000000e+00              0.000000e+00   \n",
       "4              0.000000e+00              0.000000e+00   \n",
       "...                     ...                       ...   \n",
       "284848         4.787541e+15              1.263798e+14   \n",
       "284849         4.160954e+10              1.097512e+09   \n",
       "284850         1.430207e+10              3.775410e+08   \n",
       "284851         6.549962e+15              1.727648e+14   \n",
       "284852         1.627621e+10              4.293088e+08   \n",
       "\n",
       "        LS_current_interest_stable  LS_prev_interest_stable  \\\n",
       "0                     0.000000e+00             0.000000e+00   \n",
       "1                     0.000000e+00             0.000000e+00   \n",
       "2                     0.000000e+00             0.000000e+00   \n",
       "3                     0.000000e+00             0.000000e+00   \n",
       "4                     0.000000e+00             0.000000e+00   \n",
       "...                            ...                      ...   \n",
       "284848                1.263798e+14             1.263798e+14   \n",
       "284849                1.097512e+09             1.097512e+09   \n",
       "284850                3.775410e+08             3.775410e+08   \n",
       "284851                1.727648e+14             1.727648e+14   \n",
       "284852                4.293088e+08             4.293088e+08   \n",
       "\n",
       "        LS_prev_margin_stable  \n",
       "0                0.000000e+00  \n",
       "1                0.000000e+00  \n",
       "2                0.000000e+00  \n",
       "3                0.000000e+00  \n",
       "4                0.000000e+00  \n",
       "...                       ...  \n",
       "284848           1.263798e+14  \n",
       "284849           1.097512e+09  \n",
       "284850           3.775410e+08  \n",
       "284851           1.727648e+14  \n",
       "284852           4.293088e+08  \n",
       "\n",
       "[284853 rows x 8 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "12d7c0bc",
   "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>LP_timestamp</th>\n",
       "      <th>LP_address_id</th>\n",
       "      <th>SYS_LP_contract_id</th>\n",
       "      <th>LP_Pool_id</th>\n",
       "      <th>LP_withdraw_height</th>\n",
       "      <th>LP_withdraw_idx</th>\n",
       "      <th>LP_amnt_stable</th>\n",
       "      <th>LP_interest</th>\n",
       "      <th>LP_interest_amnt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-08-23 03:00:00</td>\n",
       "      <td>lpaid1000000</td>\n",
       "      <td>lpaid1000000100</td>\n",
       "      <td>pid101</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>14969099758279176</td>\n",
       "      <td>0.000219</td>\n",
       "      <td>3.280899e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-08-24 03:00:00</td>\n",
       "      <td>lpaid1000000</td>\n",
       "      <td>lpaid1000000100</td>\n",
       "      <td>pid101</td>\n",
       "      <td>101</td>\n",
       "      <td>101</td>\n",
       "      <td>14969099758279176</td>\n",
       "      <td>0.000221</td>\n",
       "      <td>3.301341e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-08-25 03:00:00</td>\n",
       "      <td>lpaid1000000</td>\n",
       "      <td>lpaid1000000100</td>\n",
       "      <td>pid101</td>\n",
       "      <td>102</td>\n",
       "      <td>102</td>\n",
       "      <td>14969099758279176</td>\n",
       "      <td>0.000221</td>\n",
       "      <td>3.301351e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-08-26 03:00:00</td>\n",
       "      <td>lpaid1000000</td>\n",
       "      <td>lpaid1000000100</td>\n",
       "      <td>pid101</td>\n",
       "      <td>103</td>\n",
       "      <td>103</td>\n",
       "      <td>14969099758279176</td>\n",
       "      <td>0.000249</td>\n",
       "      <td>3.727658e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-08-27 03:00:00</td>\n",
       "      <td>lpaid1000000</td>\n",
       "      <td>lpaid1000000100</td>\n",
       "      <td>pid101</td>\n",
       "      <td>104</td>\n",
       "      <td>104</td>\n",
       "      <td>14969099758279176</td>\n",
       "      <td>0.000219</td>\n",
       "      <td>3.281054e+12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1918675</th>\n",
       "      <td>2023-02-13 02:00:00</td>\n",
       "      <td>lpaid1007307</td>\n",
       "      <td>lpaid10073077407</td>\n",
       "      <td>pid100</td>\n",
       "      <td>1918775</td>\n",
       "      <td>1918775</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1918676</th>\n",
       "      <td>2023-02-14 02:00:00</td>\n",
       "      <td>lpaid1007307</td>\n",
       "      <td>lpaid10073077407</td>\n",
       "      <td>pid100</td>\n",
       "      <td>1918776</td>\n",
       "      <td>1918776</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1918677</th>\n",
       "      <td>2023-02-15 02:00:00</td>\n",
       "      <td>lpaid1007307</td>\n",
       "      <td>lpaid10073077407</td>\n",
       "      <td>pid100</td>\n",
       "      <td>1918777</td>\n",
       "      <td>1918777</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1918678</th>\n",
       "      <td>2023-02-16 02:00:00</td>\n",
       "      <td>lpaid1007307</td>\n",
       "      <td>lpaid10073077407</td>\n",
       "      <td>pid100</td>\n",
       "      <td>1918778</td>\n",
       "      <td>1918778</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1918679</th>\n",
       "      <td>2023-02-17 02:00:00</td>\n",
       "      <td>lpaid1007307</td>\n",
       "      <td>lpaid10073077407</td>\n",
       "      <td>pid100</td>\n",
       "      <td>1918779</td>\n",
       "      <td>1918779</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1918680 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                LP_timestamp LP_address_id SYS_LP_contract_id LP_Pool_id  \\\n",
       "0        2020-08-23 03:00:00  lpaid1000000    lpaid1000000100     pid101   \n",
       "1        2020-08-24 03:00:00  lpaid1000000    lpaid1000000100     pid101   \n",
       "2        2020-08-25 03:00:00  lpaid1000000    lpaid1000000100     pid101   \n",
       "3        2020-08-26 03:00:00  lpaid1000000    lpaid1000000100     pid101   \n",
       "4        2020-08-27 03:00:00  lpaid1000000    lpaid1000000100     pid101   \n",
       "...                      ...           ...                ...        ...   \n",
       "1918675  2023-02-13 02:00:00  lpaid1007307   lpaid10073077407     pid100   \n",
       "1918676  2023-02-14 02:00:00  lpaid1007307   lpaid10073077407     pid100   \n",
       "1918677  2023-02-15 02:00:00  lpaid1007307   lpaid10073077407     pid100   \n",
       "1918678  2023-02-16 02:00:00  lpaid1007307   lpaid10073077407     pid100   \n",
       "1918679  2023-02-17 02:00:00  lpaid1007307   lpaid10073077407     pid100   \n",
       "\n",
       "         LP_withdraw_height  LP_withdraw_idx     LP_amnt_stable  LP_interest  \\\n",
       "0                       100              100  14969099758279176     0.000219   \n",
       "1                       101              101  14969099758279176     0.000221   \n",
       "2                       102              102  14969099758279176     0.000221   \n",
       "3                       103              103  14969099758279176     0.000249   \n",
       "4                       104              104  14969099758279176     0.000219   \n",
       "...                     ...              ...                ...          ...   \n",
       "1918675             1918775          1918775                  0     0.000000   \n",
       "1918676             1918776          1918776                  0     0.000000   \n",
       "1918677             1918777          1918777                  0     0.000000   \n",
       "1918678             1918778          1918778                  0     0.000000   \n",
       "1918679             1918779          1918779                  0     0.000000   \n",
       "\n",
       "         LP_interest_amnt  \n",
       "0            3.280899e+12  \n",
       "1            3.301341e+12  \n",
       "2            3.301351e+12  \n",
       "3            3.727658e+12  \n",
       "4            3.281054e+12  \n",
       "...                   ...  \n",
       "1918675      0.000000e+00  \n",
       "1918676      0.000000e+00  \n",
       "1918677      0.000000e+00  \n",
       "1918678      0.000000e+00  \n",
       "1918679      0.000000e+00  \n",
       "\n",
       "[1918680 rows x 9 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "SYS_LP_Withdraw"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "cd985dc0",
   "metadata": {},
   "outputs": [],
   "source": [
    "TR_PROFIT(PER_TIMESTAMP) = args[\"LS_swap_prc\"]*LS_Opening.loc[timestamp == timestamp,\"LS_loan_amnt_stable\"].sum()\n",
    "+ PL_State[\"PL_LS_count_open\"](timest)*(args[\"LS_tr_per_month\"]/30)*args[\"tr_price\"]+\n",
    "PL_State[\"PL_LP_count_open\"](timest)*(args[\"LP_tr_per_month\"]/30)*args[\"tr_price\"]+\n",
    "args[\"treasury_interest\"]#from LP_interest_calculate\n",
    "#"
   ]
  }
 ],
 "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.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}