LS_Repayment.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "4de42111",
   "metadata": {},
   "outputs": [],
   "source": [
    "import json\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import random\n",
    "import modules.gnrl as gnrl\n",
    "import modules.LP_Pool_State as lpps\n",
    "import datetime\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "3685c8df",
   "metadata": {},
   "outputs": [],
   "source": [
    "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)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "b3a5dddc",
   "metadata": {},
   "outputs": [],
   "source": [
    "#def timestamps(LS_Opening,args):\n",
    "#    return\n",
    "#    dates = LS_Opening['LS_timestamp'].astype(\"datetime64\").tolist()\n",
    "##    time = LS_Opening[\"SYS_LS_expected_payment\"] + LS_Opening[\"SYS_LS_expected_penalty\"]\n",
    "#    timestamp = pd.DataFrame({\"Dates\":[]})\n",
    "#    print(len(time))\n",
    "#    i=0\n",
    "#    for i in range(len(time)):\n",
    "#        s = pd.date_range(start=dates[i],end=dates[i]+pd.Timedelta(days=time[i]*30),freq=\"M\")\n",
    "#        s = pd.DataFrame(s)\n",
    "#        s = s.explode(0)\n",
    "#        print(s)\n",
    "#        timestamp = pd.concat([timestamp,s],ignore_index=True)\n",
    "#        i+=1\n",
    "#    print(timestamp)\n",
    "#    return timestamp\n",
    "#timestamp = timestamps(LS_Opening,args)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "c628e79c",
   "metadata": {},
   "outputs": [],
   "source": [
    "def lsr_timestamp(LS_Opening,args):\n",
    "    month = 2592000\n",
    "    duration = LS_Opening[\"SYS_LS_expected_payment\"] + LS_Opening[\"SYS_LS_expected_penalty\"]\n",
    "    timestamp = pd.DataFrame({\"LS_timestamp\":LS_Opening[\"LS_timestamp\"],\"LS_contract_id\":LS_Opening[\"LS_contract_id\"]})\n",
    "    timestamp[\"LS_timestamp\"] = LS_Opening[\"LS_timestamp\"].astype(\"datetime64\").apply(lambda x:datetime.datetime.timestamp(x)).astype(\"uint64\")\n",
    "    timestamp[\"LP_Pool_id\"] = LS_Opening[\"LP_Pool_id\"]\n",
    "    \n",
    "    timestamp = pd.DataFrame(np.repeat(timestamp.values, duration, axis=0))\n",
    "    timestamp = pd.DataFrame({\"LS_timestamp\":timestamp[0],\"LS_contract_id\":timestamp[1],\"LP_Pool_id\":timestamp[2]})\n",
    "    timestamp[\"LS_timestamp\"] = timestamp[\"LS_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\"]*month\n",
    "    timestamp[\"LS_timestamp\"] = timestamp[\"LS_timestamp\"]+timestamp[\"Duration\"]\n",
    "    timestamp[\"LS_timestamp\"] = timestamp[\"LS_timestamp\"].apply(datetime.datetime.fromtimestamp)\n",
    "    timestamp = timestamp.drop(\"Duration\",axis=1)\n",
    "    \n",
    "    return timestamp\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "16f9b689",
   "metadata": {},
   "outputs": [],
   "source": [
    "def LS_Repayment_generate(LS_Opening,pool_id,args):#WRONG  witthout penalty add column flag if 1  =  payment if 2 penalty \n",
    "     \n",
    "\n",
    "    LS_Repayment = pd.DataFrame(lsr_timestamp(LS_Opening,args))\n",
    "    lp_dep_h = [s for s in range(100,100+len(LS_Repayment))]\n",
    "    lp_dep_idx = lp_dep_h\n",
    "    LS_Repayment[\"LS_repayment_height\"] = lp_dep_h\n",
    "    LS_Repayment[\"LS_repayment_idx\"] = lp_dep_idx\n",
    "    LS_Repayment = pd.merge(LS_Repayment,pool_id,on=\"LP_Pool_id\",how='left')\n",
    "    LS_Repayment = LS_Repayment.rename(columns={\"LP_symbol\":\"LS_symbol\"})\n",
    "    LS_Repayment = LS_Repayment.drop(\"LP_Pool_id\",axis=1)\n",
    "    LS_Repayment[\"LS_amnt_stable\"] = 0\n",
    "    LS_Repayment[\"LS_principal_stable\"] = 0\n",
    "    LS_Repayment[\"LS_current_margin_stable\"] = 0\n",
    "    LS_Repayment[\"LS_current_interest_stable\"] = 0\n",
    "    LS_Repayment[\"LS_prev_interest_stable\"] = 0\n",
    "    LS_Repayment[\"LS_prev_margin_stable\"] = 0\n",
    "\n",
    "    \n",
    "    return LS_Repayment\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "fb259053",
   "metadata": {},
   "outputs": [],
   "source": [
    "pool_id = lpps.LP_pool_gen(args)\n",
    "LS_Repayment = LS_Repayment_generate(LS_Opening,pool_id,args)\n",
    "#LS_Repayment.sample(20)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "a228c763",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "477f49f6",
   "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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-11-20 02:00:00</td>\n",
       "      <td>LScid1000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-10-21 03:00:00</td>\n",
       "      <td>LScid1000001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-12-20 02:00:00</td>\n",
       "      <td>LScid1000002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-10-21 03:00:00</td>\n",
       "      <td>LScid1000003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-09-16 03:00:00</td>\n",
       "      <td>LScid1000004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73043</th>\n",
       "      <td>2022-09-20 03:00:00</td>\n",
       "      <td>LScid1073043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73044</th>\n",
       "      <td>2022-09-20 03:00:00</td>\n",
       "      <td>LScid1073044</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73045</th>\n",
       "      <td>2023-01-18 02:00:00</td>\n",
       "      <td>LScid1073045</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73046</th>\n",
       "      <td>2023-02-17 02:00:00</td>\n",
       "      <td>LScid1073046</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73047</th>\n",
       "      <td>2023-03-19 02:00:00</td>\n",
       "      <td>LScid1073047</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>73048 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             LS_timestamp LS_contract_id\n",
       "0     2020-11-20 02:00:00   LScid1000000\n",
       "1     2020-10-21 03:00:00   LScid1000001\n",
       "2     2020-12-20 02:00:00   LScid1000002\n",
       "3     2020-10-21 03:00:00   LScid1000003\n",
       "4     2021-09-16 03:00:00   LScid1000004\n",
       "...                   ...            ...\n",
       "73043 2022-09-20 03:00:00   LScid1073043\n",
       "73044 2022-09-20 03:00:00   LScid1073044\n",
       "73045 2023-01-18 02:00:00   LScid1073045\n",
       "73046 2023-02-17 02:00:00   LScid1073046\n",
       "73047 2023-03-19 02:00:00   LScid1073047\n",
       "\n",
       "[73048 rows x 2 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "close"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "26a8fbf1",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/tmp/ipykernel_20779/2261401898.py:4: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  LS_Liquidation[\"LS_transaction_type\"] = 1\n"
     ]
    }
   ],
   "source": [
    "def LS_Liquidation_generate(LS_Opening,LS_Repayment,args):#WRONG form it ONLY from customers with penalty! \n",
    "    contracts = LS_Opening.loc[LS_Opening[\"SYS_LS_expected_penalty\"]>=1][\"LS_contract_id\"]\n",
    "    LS_Liquidation = LS_Repayment.loc[LS_Repayment[\"LS_contract_id\"].isin(contracts)]\n",
    "    LS_Liquidation[\"LS_transaction_type\"] = 1\n",
    "    LS_Liquidation=LS_Liquidation.drop([\"LS_repayment_height\",\"LS_repayment_idx\"],axis=1)\n",
    "    lp_dep_h = [s for s in range(100,100+len(LS_Liquidation))]\n",
    "    lp_dep_idx = lp_dep_h\n",
    "    LS_Liquidation[\"LS_liquidation_height\"] = lp_dep_h\n",
    "    LS_Liquidation[\"LS_liquidation_idx\"] = lp_dep_idx\n",
    "    LS_Liquidation[\"LS_amnt_stable\"] = 0\n",
    "    LS_Liquidation[\"LS_principal_stable\"] = 0\n",
    "    LS_Liquidation[\"LS_current_margin_stable\"] = 0\n",
    "    LS_Liquidation[\"LS_current_interest_stable\"] = 0\n",
    "    LS_Liquidation[\"LS_prev_interest_stable\"] = 0\n",
    "    LS_Liquidation[\"LS_prev_margin_stable\"] = 0\n",
    "    return LS_Liquidation\n",
    "liq = LS_Liquidation_generate(LS_Opening,LS_Repayment,args)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "ddb8856d",
   "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_symbol</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",
       "      <th>LS_transaction_type</th>\n",
       "      <th>LS_liquidation_height</th>\n",
       "      <th>LS_liquidation_idx</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2020-09-21 03:00:00</td>\n",
       "      <td>LScid1000002</td>\n",
       "      <td>usd-coin</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2020-10-21 03:00:00</td>\n",
       "      <td>LScid1000002</td>\n",
       "      <td>usd-coin</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>101</td>\n",
       "      <td>101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2020-11-20 02:00:00</td>\n",
       "      <td>LScid1000002</td>\n",
       "      <td>usd-coin</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>102</td>\n",
       "      <td>102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2020-12-20 02:00:00</td>\n",
       "      <td>LScid1000002</td>\n",
       "      <td>usd-coin</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>103</td>\n",
       "      <td>103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2020-09-21 03:00:00</td>\n",
       "      <td>LScid1000004</td>\n",
       "      <td>tether</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>104</td>\n",
       "      <td>104</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391236</th>\n",
       "      <td>2023-12-21 02:00:00</td>\n",
       "      <td>LScid1067650</td>\n",
       "      <td>tether</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>234811</td>\n",
       "      <td>234811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>397083</th>\n",
       "      <td>2022-08-11 03:00:00</td>\n",
       "      <td>LScid1069038</td>\n",
       "      <td>usd-coin</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>234812</td>\n",
       "      <td>234812</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>397084</th>\n",
       "      <td>2022-09-10 03:00:00</td>\n",
       "      <td>LScid1069038</td>\n",
       "      <td>usd-coin</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>234813</td>\n",
       "      <td>234813</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>397085</th>\n",
       "      <td>2022-10-10 03:00:00</td>\n",
       "      <td>LScid1069038</td>\n",
       "      <td>usd-coin</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>234814</td>\n",
       "      <td>234814</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>397086</th>\n",
       "      <td>2022-11-09 02:00:00</td>\n",
       "      <td>LScid1069038</td>\n",
       "      <td>usd-coin</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>234815</td>\n",
       "      <td>234815</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>234716 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              LS_timestamp LS_contract_id LS_symbol  LS_amnt_stable  \\\n",
       "5      2020-09-21 03:00:00   LScid1000002  usd-coin               0   \n",
       "6      2020-10-21 03:00:00   LScid1000002  usd-coin               0   \n",
       "7      2020-11-20 02:00:00   LScid1000002  usd-coin               0   \n",
       "8      2020-12-20 02:00:00   LScid1000002  usd-coin               0   \n",
       "11     2020-09-21 03:00:00   LScid1000004    tether               0   \n",
       "...                    ...            ...       ...             ...   \n",
       "391236 2023-12-21 02:00:00   LScid1067650    tether               0   \n",
       "397083 2022-08-11 03:00:00   LScid1069038  usd-coin               0   \n",
       "397084 2022-09-10 03:00:00   LScid1069038  usd-coin               0   \n",
       "397085 2022-10-10 03:00:00   LScid1069038  usd-coin               0   \n",
       "397086 2022-11-09 02:00:00   LScid1069038  usd-coin               0   \n",
       "\n",
       "        LS_principal_stable  LS_current_margin_stable  \\\n",
       "5                         0                         0   \n",
       "6                         0                         0   \n",
       "7                         0                         0   \n",
       "8                         0                         0   \n",
       "11                        0                         0   \n",
       "...                     ...                       ...   \n",
       "391236                    0                         0   \n",
       "397083                    0                         0   \n",
       "397084                    0                         0   \n",
       "397085                    0                         0   \n",
       "397086                    0                         0   \n",
       "\n",
       "        LS_current_interest_stable  LS_prev_interest_stable  \\\n",
       "5                                0                        0   \n",
       "6                                0                        0   \n",
       "7                                0                        0   \n",
       "8                                0                        0   \n",
       "11                               0                        0   \n",
       "...                            ...                      ...   \n",
       "391236                           0                        0   \n",
       "397083                           0                        0   \n",
       "397084                           0                        0   \n",
       "397085                           0                        0   \n",
       "397086                           0                        0   \n",
       "\n",
       "        LS_prev_margin_stable  LS_transaction_type  LS_liquidation_height  \\\n",
       "5                           0                    1                    100   \n",
       "6                           0                    1                    101   \n",
       "7                           0                    1                    102   \n",
       "8                           0                    1                    103   \n",
       "11                          0                    1                    104   \n",
       "...                       ...                  ...                    ...   \n",
       "391236                      0                    1                 234811   \n",
       "397083                      0                    1                 234812   \n",
       "397084                      0                    1                 234813   \n",
       "397085                      0                    1                 234814   \n",
       "397086                      0                    1                 234815   \n",
       "\n",
       "        LS_liquidation_idx  \n",
       "5                      100  \n",
       "6                      101  \n",
       "7                      102  \n",
       "8                      103  \n",
       "11                     104  \n",
       "...                    ...  \n",
       "391236              234811  \n",
       "397083              234812  \n",
       "397084              234813  \n",
       "397085              234814  \n",
       "397086              234815  \n",
       "\n",
       "[234716 rows x 12 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "liq"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "f18e59ef",
   "metadata": {},
   "outputs": [],
   "source": [
    "liq.to_csv(\"LS_Liquidation\")\n",
    "close.to_csv(\"LS_Closing\")\n",
    "LS_Repayment.to_csv(\"LS_Repayment\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2c9c4d0b",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "ee0a1759",
   "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": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LS_Opening\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "bb8f4c04",
   "metadata": {},
   "outputs": [],
   "source": [
    "contracts = LS_Opening.loc[LS_Opening[\"SYS_LS_expected_penalty\"]<1][\"LS_contract_id\"]\n",
    "LS_Liquidation = LS_Repayment.loc[LS_Repayment[\"LS_contract_id\"].isin(contracts)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "b7c77a91",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "LS_timestamp         LS_contract_id  LS_repayment_height  LS_repayment_idx  LS_symbol\n",
       "2020-08-05 03:00:00  LScid1000002    113                  113               tether       1\n",
       "2022-04-26 03:00:00  LScid1067504    461980               461980            usd-coin     1\n",
       "                     LScid1067534    462135               462135            usd-coin     1\n",
       "                     LScid1067535    462142               462142            tether       1\n",
       "                     LScid1067536    462147               462147            tether       1\n",
       "                                                                                        ..\n",
       "2021-07-06 03:00:00  LScid1029071    202167               202167            usd-coin     1\n",
       "                     LScid1029072    202173               202173            tether       1\n",
       "                     LScid1029073    202179               202179            usd-coin     1\n",
       "                     LScid1029074    202184               202184            usd-coin     1\n",
       "2023-07-27 03:00:00  LScid1077202    510325               510325            tether       1\n",
       "Length: 231390, dtype: int64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LS_Repayment.loc[LS_Repayment[\"LS_contract_id\"].isin(contracts)].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "7dac21a2",
   "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_repayment_height</th>\n",
       "      <th>LS_repayment_idx</th>\n",
       "      <th>LS_symbol</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2020-08-05 03:00:00</td>\n",
       "      <td>LScid1000000</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2020-09-04 03:00:00</td>\n",
       "      <td>LScid1000000</td>\n",
       "      <td>101</td>\n",
       "      <td>101</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2020-10-04 03:00:00</td>\n",
       "      <td>LScid1000000</td>\n",
       "      <td>102</td>\n",
       "      <td>102</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2020-11-03 02:00:00</td>\n",
       "      <td>LScid1000000</td>\n",
       "      <td>103</td>\n",
       "      <td>103</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2020-12-03 02:00:00</td>\n",
       "      <td>LScid1000000</td>\n",
       "      <td>104</td>\n",
       "      <td>104</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511576</th>\n",
       "      <td>2022-09-03 03:00:00</td>\n",
       "      <td>LScid1077542</td>\n",
       "      <td>511676</td>\n",
       "      <td>511676</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511577</th>\n",
       "      <td>2022-10-03 03:00:00</td>\n",
       "      <td>LScid1077542</td>\n",
       "      <td>511677</td>\n",
       "      <td>511677</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511578</th>\n",
       "      <td>2022-11-02 02:00:00</td>\n",
       "      <td>LScid1077542</td>\n",
       "      <td>511678</td>\n",
       "      <td>511678</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511579</th>\n",
       "      <td>2022-12-02 02:00:00</td>\n",
       "      <td>LScid1077542</td>\n",
       "      <td>511679</td>\n",
       "      <td>511679</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511580</th>\n",
       "      <td>2023-01-01 02:00:00</td>\n",
       "      <td>LScid1077542</td>\n",
       "      <td>511680</td>\n",
       "      <td>511680</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>511581 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              LS_timestamp LS_contract_id  LS_repayment_height  \\\n",
       "0      2020-08-05 03:00:00   LScid1000000                  100   \n",
       "1      2020-09-04 03:00:00   LScid1000000                  101   \n",
       "2      2020-10-04 03:00:00   LScid1000000                  102   \n",
       "3      2020-11-03 02:00:00   LScid1000000                  103   \n",
       "4      2020-12-03 02:00:00   LScid1000000                  104   \n",
       "...                    ...            ...                  ...   \n",
       "511576 2022-09-03 03:00:00   LScid1077542               511676   \n",
       "511577 2022-10-03 03:00:00   LScid1077542               511677   \n",
       "511578 2022-11-02 02:00:00   LScid1077542               511678   \n",
       "511579 2022-12-02 02:00:00   LScid1077542               511679   \n",
       "511580 2023-01-01 02:00:00   LScid1077542               511680   \n",
       "\n",
       "        LS_repayment_idx LS_symbol  \n",
       "0                    100  usd-coin  \n",
       "1                    101  usd-coin  \n",
       "2                    102  usd-coin  \n",
       "3                    103  usd-coin  \n",
       "4                    104  usd-coin  \n",
       "...                  ...       ...  \n",
       "511576            511676  usd-coin  \n",
       "511577            511677  usd-coin  \n",
       "511578            511678  usd-coin  \n",
       "511579            511679  usd-coin  \n",
       "511580            511680  usd-coin  \n",
       "\n",
       "[511581 rows x 5 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LS_Repayment"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "4a5335b6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "231390"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "511581 - 280191"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "4fadadba",
   "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_repayment_height</th>\n",
       "      <th>LS_repayment_idx</th>\n",
       "      <th>LS_symbol</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2020-08-05 03:00:00</td>\n",
       "      <td>LScid1000002</td>\n",
       "      <td>113</td>\n",
       "      <td>113</td>\n",
       "      <td>tether</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2020-09-04 03:00:00</td>\n",
       "      <td>LScid1000002</td>\n",
       "      <td>114</td>\n",
       "      <td>114</td>\n",
       "      <td>tether</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2020-10-04 03:00:00</td>\n",
       "      <td>LScid1000002</td>\n",
       "      <td>115</td>\n",
       "      <td>115</td>\n",
       "      <td>tether</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>2020-08-05 03:00:00</td>\n",
       "      <td>LScid1000010</td>\n",
       "      <td>165</td>\n",
       "      <td>165</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>2020-09-04 03:00:00</td>\n",
       "      <td>LScid1000010</td>\n",
       "      <td>166</td>\n",
       "      <td>166</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511576</th>\n",
       "      <td>2022-09-03 03:00:00</td>\n",
       "      <td>LScid1077542</td>\n",
       "      <td>511676</td>\n",
       "      <td>511676</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511577</th>\n",
       "      <td>2022-10-03 03:00:00</td>\n",
       "      <td>LScid1077542</td>\n",
       "      <td>511677</td>\n",
       "      <td>511677</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511578</th>\n",
       "      <td>2022-11-02 02:00:00</td>\n",
       "      <td>LScid1077542</td>\n",
       "      <td>511678</td>\n",
       "      <td>511678</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511579</th>\n",
       "      <td>2022-12-02 02:00:00</td>\n",
       "      <td>LScid1077542</td>\n",
       "      <td>511679</td>\n",
       "      <td>511679</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511580</th>\n",
       "      <td>2023-01-01 02:00:00</td>\n",
       "      <td>LScid1077542</td>\n",
       "      <td>511680</td>\n",
       "      <td>511680</td>\n",
       "      <td>usd-coin</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>231390 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              LS_timestamp LS_contract_id  LS_repayment_height  \\\n",
       "13     2020-08-05 03:00:00   LScid1000002                  113   \n",
       "14     2020-09-04 03:00:00   LScid1000002                  114   \n",
       "15     2020-10-04 03:00:00   LScid1000002                  115   \n",
       "65     2020-08-05 03:00:00   LScid1000010                  165   \n",
       "66     2020-09-04 03:00:00   LScid1000010                  166   \n",
       "...                    ...            ...                  ...   \n",
       "511576 2022-09-03 03:00:00   LScid1077542               511676   \n",
       "511577 2022-10-03 03:00:00   LScid1077542               511677   \n",
       "511578 2022-11-02 02:00:00   LScid1077542               511678   \n",
       "511579 2022-12-02 02:00:00   LScid1077542               511679   \n",
       "511580 2023-01-01 02:00:00   LScid1077542               511680   \n",
       "\n",
       "        LS_repayment_idx LS_symbol  \n",
       "13                   113    tether  \n",
       "14                   114    tether  \n",
       "15                   115    tether  \n",
       "65                   165  usd-coin  \n",
       "66                   166  usd-coin  \n",
       "...                  ...       ...  \n",
       "511576            511676  usd-coin  \n",
       "511577            511677  usd-coin  \n",
       "511578            511678  usd-coin  \n",
       "511579            511679  usd-coin  \n",
       "511580            511680  usd-coin  \n",
       "\n",
       "[231390 rows x 5 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LS_Liquidation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f35f9a0f",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}