test.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2022-07-10 08:17:00.622000\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "from datetime import datetime\n",
    "E = '1657441020622'\n",
    "# print(E)\n",
    "E = pd.to_datetime(E, unit='ms')\n",
    "# DateFormat = '%d%m%H%M%S'\n",
    "# datetime.strptime(E,DateFormat)# E = pd.to_datetime(E).astype(float)\n",
    "print(E)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "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>A</th>\n",
       "      <th>B</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     A    B\n",
       "0  2.0  1.0\n",
       "1  3.0  NaN\n",
       "2  1.0  0.0"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "import numpy as np\n",
    "df = pd.DataFrame([[2.0, 1.0],\n",
    "                   [3.0, np.nan],\n",
    "                   [1.0, 0.0]],\n",
    "                   columns=list('AB'))\n",
    "df.head()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "# df1 = df.cumsum(axis=['A'])\n",
    "# df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "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>.EVOL7D</th>\n",
       "      <th>.BADAXBT</th>\n",
       "      <th>.BADAXBT30M</th>\n",
       "      <th>.BBCHXBT</th>\n",
       "      <th>.BBCHXBT30M</th>\n",
       "      <th>.BEOSXBT</th>\n",
       "      <th>.BEOSXBT30M</th>\n",
       "      <th>.BXRPXBT</th>\n",
       "      <th>.BXRPXBT30M</th>\n",
       "      <th>.BXRP</th>\n",
       "      <th>...</th>\n",
       "      <th>ETH/BTC:BTC</th>\n",
       "      <th>ETH/USDT:USDT</th>\n",
       "      <th>ETHUSD_ETH</th>\n",
       "      <th>ETH/USD:GWEI-220930</th>\n",
       "      <th>ETH/BTC:BTC-220930</th>\n",
       "      <th>ETH/USD:BTC-220930</th>\n",
       "      <th>ETH/USDT:USDT-220930</th>\n",
       "      <th>ETH_USDT</th>\n",
       "      <th>LTC/USD:BTC</th>\n",
       "      <th>LTC/USDT:USDT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <td>.EVOL7D</td>\n",
       "      <td>.BADAXBT</td>\n",
       "      <td>.BADAXBT30M</td>\n",
       "      <td>.BBCHXBT</td>\n",
       "      <td>.BBCHXBT30M</td>\n",
       "      <td>.BEOSXBT</td>\n",
       "      <td>.BEOSXBT30M</td>\n",
       "      <td>.BXRPXBT</td>\n",
       "      <td>.BXRPXBT30M</td>\n",
       "      <td>.BXRP</td>\n",
       "      <td>...</td>\n",
       "      <td>ETH/BTC:BTC</td>\n",
       "      <td>ETH/USDT:USDT</td>\n",
       "      <td>ETHUSD_ETH</td>\n",
       "      <td>ETH/USD:GWEI-220930</td>\n",
       "      <td>ETH/BTC:BTC-220930</td>\n",
       "      <td>ETH/USD:BTC-220930</td>\n",
       "      <td>ETH/USDT:USDT-220930</td>\n",
       "      <td>ETH_USDT</td>\n",
       "      <td>LTC/USD:BTC</td>\n",
       "      <td>LTC/USDT:USDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>timestamp</th>\n",
       "      <td>1658742000000</td>\n",
       "      <td>1658742780000</td>\n",
       "      <td>1658736000000</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>1658736000000</td>\n",
       "      <td>1658742775000</td>\n",
       "      <td>1658736000000</td>\n",
       "      <td>1658742760000</td>\n",
       "      <td>1658736000000</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>...</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>1658571976677</td>\n",
       "      <td>1658742825000</td>\n",
       "      <td>1658742830000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>datetime</th>\n",
       "      <td>2022-07-25T09:40:00.000Z</td>\n",
       "      <td>2022-07-25T09:53:00.000Z</td>\n",
       "      <td>2022-07-25T08:00:00.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>2022-07-25T08:00:00.000Z</td>\n",
       "      <td>2022-07-25T09:52:55.000Z</td>\n",
       "      <td>2022-07-25T08:00:00.000Z</td>\n",
       "      <td>2022-07-25T09:52:40.000Z</td>\n",
       "      <td>2022-07-25T08:00:00.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>2022-07-23T10:26:16.677Z</td>\n",
       "      <td>2022-07-25T09:53:45.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>high</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>0.07253</td>\n",
       "      <td>1642.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0.074</td>\n",
       "      <td>1690.8</td>\n",
       "      <td>1688.25</td>\n",
       "      <td>None</td>\n",
       "      <td>59.7</td>\n",
       "      <td>59.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>low</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>0.06834</td>\n",
       "      <td>1470.85</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0.07084</td>\n",
       "      <td>1559.25</td>\n",
       "      <td>1557.15</td>\n",
       "      <td>None</td>\n",
       "      <td>56.0</td>\n",
       "      <td>55.48</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 498 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            .EVOL7D                  .BADAXBT  \\\n",
       "symbol                      .EVOL7D                  .BADAXBT   \n",
       "timestamp             1658742000000             1658742780000   \n",
       "datetime   2022-07-25T09:40:00.000Z  2022-07-25T09:53:00.000Z   \n",
       "high                           None                      None   \n",
       "low                            None                      None   \n",
       "\n",
       "                        .BADAXBT30M                  .BBCHXBT  \\\n",
       "symbol                  .BADAXBT30M                  .BBCHXBT   \n",
       "timestamp             1658736000000             1658742830000   \n",
       "datetime   2022-07-25T08:00:00.000Z  2022-07-25T09:53:50.000Z   \n",
       "high                           None                      None   \n",
       "low                            None                      None   \n",
       "\n",
       "                        .BBCHXBT30M                  .BEOSXBT  \\\n",
       "symbol                  .BBCHXBT30M                  .BEOSXBT   \n",
       "timestamp             1658736000000             1658742775000   \n",
       "datetime   2022-07-25T08:00:00.000Z  2022-07-25T09:52:55.000Z   \n",
       "high                           None                      None   \n",
       "low                            None                      None   \n",
       "\n",
       "                        .BEOSXBT30M                  .BXRPXBT  \\\n",
       "symbol                  .BEOSXBT30M                  .BXRPXBT   \n",
       "timestamp             1658736000000             1658742760000   \n",
       "datetime   2022-07-25T08:00:00.000Z  2022-07-25T09:52:40.000Z   \n",
       "high                           None                      None   \n",
       "low                            None                      None   \n",
       "\n",
       "                        .BXRPXBT30M                     .BXRP  ...  \\\n",
       "symbol                  .BXRPXBT30M                     .BXRP  ...   \n",
       "timestamp             1658736000000             1658742830000  ...   \n",
       "datetime   2022-07-25T08:00:00.000Z  2022-07-25T09:53:50.000Z  ...   \n",
       "high                           None                      None  ...   \n",
       "low                            None                      None  ...   \n",
       "\n",
       "                        ETH/BTC:BTC             ETH/USDT:USDT  \\\n",
       "symbol                  ETH/BTC:BTC             ETH/USDT:USDT   \n",
       "timestamp             1658742830000             1658742830000   \n",
       "datetime   2022-07-25T09:53:50.000Z  2022-07-25T09:53:50.000Z   \n",
       "high                        0.07253                    1642.0   \n",
       "low                         0.06834                   1470.85   \n",
       "\n",
       "                         ETHUSD_ETH       ETH/USD:GWEI-220930  \\\n",
       "symbol                   ETHUSD_ETH       ETH/USD:GWEI-220930   \n",
       "timestamp             1658742830000             1658742830000   \n",
       "datetime   2022-07-25T09:53:50.000Z  2022-07-25T09:53:50.000Z   \n",
       "high                           None                      None   \n",
       "low                            None                      None   \n",
       "\n",
       "                 ETH/BTC:BTC-220930        ETH/USD:BTC-220930  \\\n",
       "symbol           ETH/BTC:BTC-220930        ETH/USD:BTC-220930   \n",
       "timestamp             1658742830000             1658742830000   \n",
       "datetime   2022-07-25T09:53:50.000Z  2022-07-25T09:53:50.000Z   \n",
       "high                          0.074                    1690.8   \n",
       "low                         0.07084                   1559.25   \n",
       "\n",
       "               ETH/USDT:USDT-220930                  ETH_USDT  \\\n",
       "symbol         ETH/USDT:USDT-220930                  ETH_USDT   \n",
       "timestamp             1658742830000             1658571976677   \n",
       "datetime   2022-07-25T09:53:50.000Z  2022-07-23T10:26:16.677Z   \n",
       "high                        1688.25                      None   \n",
       "low                         1557.15                      None   \n",
       "\n",
       "                        LTC/USD:BTC             LTC/USDT:USDT  \n",
       "symbol                  LTC/USD:BTC             LTC/USDT:USDT  \n",
       "timestamp             1658742825000             1658742830000  \n",
       "datetime   2022-07-25T09:53:45.000Z  2022-07-25T09:53:50.000Z  \n",
       "high                           59.7                     59.43  \n",
       "low                            56.0                     55.48  \n",
       "\n",
       "[5 rows x 498 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import ccxt\n",
    "# import streamlit as st\n",
    "import pandas as pd\n",
    "exchange = ccxt.bitmex({\n",
    "    'apiKey': 'NOAb2TuyuLgWkYbXOQGH-x9b',\n",
    "    'secret': '_fAxf57mItdpX-A5KTxXRzJZY3zkeSKdCGlStwa95FAH81Gd',\n",
    "})\n",
    "if 'test' in exchange.urls:\n",
    "    exchange.urls['api'] = exchange.urls['test'] # ←----- switch the base URL to testnet\n",
    "\n",
    "\n",
    "\n",
    "exchange.fetchTickers = exchange.fetchTickers()\n",
    "x = pd.DataFrame(exchange.fetchTickers)\n",
    "x.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "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>.EVOL7D</th>\n",
       "      <th>.BADAXBT</th>\n",
       "      <th>.BADAXBT30M</th>\n",
       "      <th>.BBCHXBT</th>\n",
       "      <th>.BBCHXBT30M</th>\n",
       "      <th>.BEOSXBT</th>\n",
       "      <th>.BEOSXBT30M</th>\n",
       "      <th>.BXRPXBT</th>\n",
       "      <th>.BXRPXBT30M</th>\n",
       "      <th>.BXRP</th>\n",
       "      <th>...</th>\n",
       "      <th>ETH/BTC:BTC</th>\n",
       "      <th>ETH/USDT:USDT</th>\n",
       "      <th>ETHUSD_ETH</th>\n",
       "      <th>ETH/USD:GWEI-220930</th>\n",
       "      <th>ETH/BTC:BTC-220930</th>\n",
       "      <th>ETH/USD:BTC-220930</th>\n",
       "      <th>ETH/USDT:USDT-220930</th>\n",
       "      <th>ETH_USDT</th>\n",
       "      <th>LTC/USD:BTC</th>\n",
       "      <th>LTC/USDT:USDT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <td>.EVOL7D</td>\n",
       "      <td>.BADAXBT</td>\n",
       "      <td>.BADAXBT30M</td>\n",
       "      <td>.BBCHXBT</td>\n",
       "      <td>.BBCHXBT30M</td>\n",
       "      <td>.BEOSXBT</td>\n",
       "      <td>.BEOSXBT30M</td>\n",
       "      <td>.BXRPXBT</td>\n",
       "      <td>.BXRPXBT30M</td>\n",
       "      <td>.BXRP</td>\n",
       "      <td>...</td>\n",
       "      <td>ETHXBT</td>\n",
       "      <td>ETHUSDT</td>\n",
       "      <td>ETHUSD_ETH</td>\n",
       "      <td>ETHUSDU22_ETH</td>\n",
       "      <td>ETHU22</td>\n",
       "      <td>ETHUSDU22</td>\n",
       "      <td>ETHUSDTU22</td>\n",
       "      <td>ETH_USDT</td>\n",
       "      <td>LTCUSD</td>\n",
       "      <td>LTCUSDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <td>.EVOL7D</td>\n",
       "      <td>.BADAXBT</td>\n",
       "      <td>.BADAXBT30M</td>\n",
       "      <td>.BBCHXBT</td>\n",
       "      <td>.BBCHXBT30M</td>\n",
       "      <td>.BEOSXBT</td>\n",
       "      <td>.BEOSXBT30M</td>\n",
       "      <td>.BXRPXBT</td>\n",
       "      <td>.BXRPXBT30M</td>\n",
       "      <td>.BXRP</td>\n",
       "      <td>...</td>\n",
       "      <td>ETH/BTC:BTC</td>\n",
       "      <td>ETH/USDT:USDT</td>\n",
       "      <td>ETHUSD_ETH</td>\n",
       "      <td>ETH/USD:GWEI-220930</td>\n",
       "      <td>ETH/BTC:BTC-220930</td>\n",
       "      <td>ETH/USD:BTC-220930</td>\n",
       "      <td>ETH/USDT:USDT-220930</td>\n",
       "      <td>ETH_USDT</td>\n",
       "      <td>LTC/USD:BTC</td>\n",
       "      <td>LTC/USDT:USDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>base</th>\n",
       "      <td>ETH</td>\n",
       "      <td>ADA</td>\n",
       "      <td>ADA</td>\n",
       "      <td>BCH</td>\n",
       "      <td>BCH</td>\n",
       "      <td>EOS</td>\n",
       "      <td>EOS</td>\n",
       "      <td>XRP</td>\n",
       "      <td>XRP</td>\n",
       "      <td>XRP</td>\n",
       "      <td>...</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>LTC</td>\n",
       "      <td>LTC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>quote</th>\n",
       "      <td>XXX</td>\n",
       "      <td>BTC</td>\n",
       "      <td>BTC</td>\n",
       "      <td>BTC</td>\n",
       "      <td>BTC</td>\n",
       "      <td>BTC</td>\n",
       "      <td>BTC</td>\n",
       "      <td>BTC</td>\n",
       "      <td>BTC</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>BTC</td>\n",
       "      <td>USDT</td>\n",
       "      <td>USD</td>\n",
       "      <td>USD</td>\n",
       "      <td>BTC</td>\n",
       "      <td>USD</td>\n",
       "      <td>USDT</td>\n",
       "      <td>USDT</td>\n",
       "      <td>USD</td>\n",
       "      <td>USDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>baseId</th>\n",
       "      <td>ETH</td>\n",
       "      <td>ADA</td>\n",
       "      <td>ADA</td>\n",
       "      <td>BCH</td>\n",
       "      <td>BCH</td>\n",
       "      <td>EOS</td>\n",
       "      <td>EOS</td>\n",
       "      <td>XRP</td>\n",
       "      <td>XRP</td>\n",
       "      <td>XRP</td>\n",
       "      <td>...</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>LTC</td>\n",
       "      <td>LTC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>quoteId</th>\n",
       "      <td>XXX</td>\n",
       "      <td>XBT</td>\n",
       "      <td>XBT</td>\n",
       "      <td>XBT</td>\n",
       "      <td>XBT</td>\n",
       "      <td>XBT</td>\n",
       "      <td>XBT</td>\n",
       "      <td>XBT</td>\n",
       "      <td>XBT</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>XBT</td>\n",
       "      <td>USDT</td>\n",
       "      <td>USD</td>\n",
       "      <td>USD</td>\n",
       "      <td>XBT</td>\n",
       "      <td>USD</td>\n",
       "      <td>USDT</td>\n",
       "      <td>USDT</td>\n",
       "      <td>USD</td>\n",
       "      <td>USDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>active</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>type</th>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>...</td>\n",
       "      <td>swap</td>\n",
       "      <td>swap</td>\n",
       "      <td>index</td>\n",
       "      <td>future</td>\n",
       "      <td>future</td>\n",
       "      <td>future</td>\n",
       "      <td>future</td>\n",
       "      <td>index</td>\n",
       "      <td>swap</td>\n",
       "      <td>swap</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>linear</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>inverse</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>spot</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>swap</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>future</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>option</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>margin</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>contract</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>contractSize</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>100000000.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>-1000000000.0</td>\n",
       "      <td>-1000000000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>expiry</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1664539200000</td>\n",
       "      <td>1664539200000</td>\n",
       "      <td>1664539200000</td>\n",
       "      <td>1664539200000</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>expiryDatetime</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>2022-09-30T12:00:00.000Z</td>\n",
       "      <td>2022-09-30T12:00:00.000Z</td>\n",
       "      <td>2022-09-30T12:00:00.000Z</td>\n",
       "      <td>2022-09-30T12:00:00.000Z</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>optionType</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>strike</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>settle</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>BTC</td>\n",
       "      <td>USDT</td>\n",
       "      <td>GWEI</td>\n",
       "      <td>GWEI</td>\n",
       "      <td>BTC</td>\n",
       "      <td>BTC</td>\n",
       "      <td>USDT</td>\n",
       "      <td></td>\n",
       "      <td>BTC</td>\n",
       "      <td>USDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>settleId</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>XBt</td>\n",
       "      <td>USDt</td>\n",
       "      <td>Gwei</td>\n",
       "      <td>Gwei</td>\n",
       "      <td>XBt</td>\n",
       "      <td>XBt</td>\n",
       "      <td>USDt</td>\n",
       "      <td></td>\n",
       "      <td>XBt</td>\n",
       "      <td>USDt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>precision</th>\n",
       "      <td>{'amount': None, 'price': 0.01}</td>\n",
       "      <td>{'amount': None, 'price': 1e-08}</td>\n",
       "      <td>{'amount': None, 'price': 1e-08}</td>\n",
       "      <td>{'amount': None, 'price': 1e-06}</td>\n",
       "      <td>{'amount': None, 'price': 1e-06}</td>\n",
       "      <td>{'amount': None, 'price': 1e-08}</td>\n",
       "      <td>{'amount': None, 'price': 1e-08}</td>\n",
       "      <td>{'amount': None, 'price': 1e-08}</td>\n",
       "      <td>{'amount': None, 'price': 1e-08}</td>\n",
       "      <td>{'amount': None, 'price': 1e-05}</td>\n",
       "      <td>...</td>\n",
       "      <td>{'amount': 1.0, 'price': 1e-05}</td>\n",
       "      <td>{'amount': 1000.0, 'price': 0.05}</td>\n",
       "      <td>{'amount': 1.0, 'price': 0.05}</td>\n",
       "      <td>{'amount': 1.0, 'price': 0.05}</td>\n",
       "      <td>{'amount': 1000.0, 'price': 1e-05}</td>\n",
       "      <td>{'amount': 1.0, 'price': 0.05}</td>\n",
       "      <td>{'amount': 1000.0, 'price': 0.05}</td>\n",
       "      <td>{'amount': 1000000.0, 'price': 0.05}</td>\n",
       "      <td>{'amount': 1.0, 'price': 0.01}</td>\n",
       "      <td>{'amount': 1000.0, 'price': 0.01}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>limits</th>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>...</td>\n",
       "      <td>{'amount': {'min': None, 'max': 100000000.0}, ...</td>\n",
       "      <td>{'amount': {'min': None, 'max': 1000000000.0},...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': 1000000000.0},...</td>\n",
       "      <td>{'amount': {'min': None, 'max': 10000000.0}, '...</td>\n",
       "      <td>{'amount': {'min': None, 'max': 1000000000.0},...</td>\n",
       "      <td>{'amount': {'min': None, 'max': 10000000000000...</td>\n",
       "      <td>{'amount': {'min': None, 'max': 100000000.0}, ...</td>\n",
       "      <td>{'amount': {'min': None, 'max': 1000000000.0},...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>info</th>\n",
       "      <td>{'symbol': '.EVOL7D', 'rootSymbol': 'EVOL', 's...</td>\n",
       "      <td>{'symbol': '.BADAXBT', 'rootSymbol': 'ADA', 's...</td>\n",
       "      <td>{'symbol': '.BADAXBT30M', 'rootSymbol': 'ADA',...</td>\n",
       "      <td>{'symbol': '.BBCHXBT', 'rootSymbol': 'BCH', 's...</td>\n",
       "      <td>{'symbol': '.BBCHXBT30M', 'rootSymbol': 'BCH',...</td>\n",
       "      <td>{'symbol': '.BEOSXBT', 'rootSymbol': 'EOS', 's...</td>\n",
       "      <td>{'symbol': '.BEOSXBT30M', 'rootSymbol': 'EOS',...</td>\n",
       "      <td>{'symbol': '.BXRPXBT', 'rootSymbol': 'XRP', 's...</td>\n",
       "      <td>{'symbol': '.BXRPXBT30M', 'rootSymbol': 'XRP',...</td>\n",
       "      <td>{'symbol': '.BXRP', 'rootSymbol': 'XRP', 'stat...</td>\n",
       "      <td>...</td>\n",
       "      <td>{'symbol': 'ETHXBT', 'rootSymbol': 'ETH', 'sta...</td>\n",
       "      <td>{'symbol': 'ETHUSDT', 'rootSymbol': 'ETH', 'st...</td>\n",
       "      <td>{'symbol': 'ETHUSD_ETH', 'rootSymbol': 'ETH', ...</td>\n",
       "      <td>{'symbol': 'ETHUSDU22_ETH', 'rootSymbol': 'ETH...</td>\n",
       "      <td>{'symbol': 'ETHU22', 'rootSymbol': 'ETH', 'sta...</td>\n",
       "      <td>{'symbol': 'ETHUSDU22', 'rootSymbol': 'ETH', '...</td>\n",
       "      <td>{'symbol': 'ETHUSDTU22', 'rootSymbol': 'ETH', ...</td>\n",
       "      <td>{'symbol': 'ETH_USDT', 'rootSymbol': 'ETH', 's...</td>\n",
       "      <td>{'symbol': 'LTCUSD', 'rootSymbol': 'LTC', 'sta...</td>\n",
       "      <td>{'symbol': 'LTCUSDT', 'rootSymbol': 'LTC', 'st...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>percentage</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>prediction</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>taker</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00075</td>\n",
       "      <td>0.00075</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>0.00075</td>\n",
       "      <td>0.00075</td>\n",
       "      <td>0.00075</td>\n",
       "      <td>0.00075</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0.00075</td>\n",
       "      <td>0.00075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>maker</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>0.001</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0001</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>31 rows × 498 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                          .EVOL7D  \\\n",
       "id                                                        .EVOL7D   \n",
       "symbol                                                    .EVOL7D   \n",
       "base                                                          ETH   \n",
       "quote                                                         XXX   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                       XXX   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                         {'amount': None, 'price': 0.01}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.EVOL7D', 'rootSymbol': 'EVOL', 's...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                         .BADAXBT  \\\n",
       "id                                                       .BADAXBT   \n",
       "symbol                                                   .BADAXBT   \n",
       "base                                                          ADA   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        ADA   \n",
       "quoteId                                                       XBT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                        {'amount': None, 'price': 1e-08}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.BADAXBT', 'rootSymbol': 'ADA', 's...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                      .BADAXBT30M  \\\n",
       "id                                                    .BADAXBT30M   \n",
       "symbol                                                .BADAXBT30M   \n",
       "base                                                          ADA   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        ADA   \n",
       "quoteId                                                       XBT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                        {'amount': None, 'price': 1e-08}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.BADAXBT30M', 'rootSymbol': 'ADA',...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                         .BBCHXBT  \\\n",
       "id                                                       .BBCHXBT   \n",
       "symbol                                                   .BBCHXBT   \n",
       "base                                                          BCH   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        BCH   \n",
       "quoteId                                                       XBT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                        {'amount': None, 'price': 1e-06}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.BBCHXBT', 'rootSymbol': 'BCH', 's...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                      .BBCHXBT30M  \\\n",
       "id                                                    .BBCHXBT30M   \n",
       "symbol                                                .BBCHXBT30M   \n",
       "base                                                          BCH   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        BCH   \n",
       "quoteId                                                       XBT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                        {'amount': None, 'price': 1e-06}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.BBCHXBT30M', 'rootSymbol': 'BCH',...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                         .BEOSXBT  \\\n",
       "id                                                       .BEOSXBT   \n",
       "symbol                                                   .BEOSXBT   \n",
       "base                                                          EOS   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        EOS   \n",
       "quoteId                                                       XBT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                        {'amount': None, 'price': 1e-08}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.BEOSXBT', 'rootSymbol': 'EOS', 's...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                      .BEOSXBT30M  \\\n",
       "id                                                    .BEOSXBT30M   \n",
       "symbol                                                .BEOSXBT30M   \n",
       "base                                                          EOS   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        EOS   \n",
       "quoteId                                                       XBT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                        {'amount': None, 'price': 1e-08}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.BEOSXBT30M', 'rootSymbol': 'EOS',...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                         .BXRPXBT  \\\n",
       "id                                                       .BXRPXBT   \n",
       "symbol                                                   .BXRPXBT   \n",
       "base                                                          XRP   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        XRP   \n",
       "quoteId                                                       XBT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                        {'amount': None, 'price': 1e-08}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.BXRPXBT', 'rootSymbol': 'XRP', 's...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                      .BXRPXBT30M  \\\n",
       "id                                                    .BXRPXBT30M   \n",
       "symbol                                                .BXRPXBT30M   \n",
       "base                                                          XRP   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        XRP   \n",
       "quoteId                                                       XBT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                        {'amount': None, 'price': 1e-08}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.BXRPXBT30M', 'rootSymbol': 'XRP',...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                            .BXRP  ...  \\\n",
       "id                                                          .BXRP  ...   \n",
       "symbol                                                      .BXRP  ...   \n",
       "base                                                          XRP  ...   \n",
       "quote                                                         USD  ...   \n",
       "baseId                                                        XRP  ...   \n",
       "quoteId                                                       USD  ...   \n",
       "active                                                      False  ...   \n",
       "type                                                        index  ...   \n",
       "linear                                                       None  ...   \n",
       "inverse                                                      None  ...   \n",
       "spot                                                        False  ...   \n",
       "swap                                                        False  ...   \n",
       "future                                                      False  ...   \n",
       "option                                                      False  ...   \n",
       "margin                                                      False  ...   \n",
       "contract                                                    False  ...   \n",
       "contractSize                                                 None  ...   \n",
       "expiry                                                       None  ...   \n",
       "expiryDatetime                                               None  ...   \n",
       "optionType                                                   None  ...   \n",
       "strike                                                       None  ...   \n",
       "settle                                                             ...   \n",
       "settleId                                                           ...   \n",
       "precision                        {'amount': None, 'price': 1e-05}  ...   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...  ...   \n",
       "info            {'symbol': '.BXRP', 'rootSymbol': 'XRP', 'stat...  ...   \n",
       "percentage                                                   True  ...   \n",
       "prediction                                                  False  ...   \n",
       "index                                                        True  ...   \n",
       "taker                                                        None  ...   \n",
       "maker                                                        None  ...   \n",
       "\n",
       "                                                      ETH/BTC:BTC  \\\n",
       "id                                                         ETHXBT   \n",
       "symbol                                                ETH/BTC:BTC   \n",
       "base                                                          ETH   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                       XBT   \n",
       "active                                                       True   \n",
       "type                                                         swap   \n",
       "linear                                                       True   \n",
       "inverse                                                     False   \n",
       "spot                                                        False   \n",
       "swap                                                         True   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                     True   \n",
       "contractSize                                          100000000.0   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                        BTC   \n",
       "settleId                                                      XBt   \n",
       "precision                         {'amount': 1.0, 'price': 1e-05}   \n",
       "limits          {'amount': {'min': None, 'max': 100000000.0}, ...   \n",
       "info            {'symbol': 'ETHXBT', 'rootSymbol': 'ETH', 'sta...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                       False   \n",
       "taker                                                     0.00075   \n",
       "maker                                                     -0.0001   \n",
       "\n",
       "                                                    ETH/USDT:USDT  \\\n",
       "id                                                        ETHUSDT   \n",
       "symbol                                              ETH/USDT:USDT   \n",
       "base                                                          ETH   \n",
       "quote                                                        USDT   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                      USDT   \n",
       "active                                                       True   \n",
       "type                                                         swap   \n",
       "linear                                                       True   \n",
       "inverse                                                     False   \n",
       "spot                                                        False   \n",
       "swap                                                         True   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                     True   \n",
       "contractSize                                                 10.0   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                       USDT   \n",
       "settleId                                                     USDt   \n",
       "precision                       {'amount': 1000.0, 'price': 0.05}   \n",
       "limits          {'amount': {'min': None, 'max': 1000000000.0},...   \n",
       "info            {'symbol': 'ETHUSDT', 'rootSymbol': 'ETH', 'st...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                       False   \n",
       "taker                                                     0.00075   \n",
       "maker                                                     -0.0001   \n",
       "\n",
       "                                                       ETHUSD_ETH  \\\n",
       "id                                                     ETHUSD_ETH   \n",
       "symbol                                                 ETHUSD_ETH   \n",
       "base                                                          ETH   \n",
       "quote                                                         USD   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                       USD   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                        -1000000000.0   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                       GWEI   \n",
       "settleId                                                     Gwei   \n",
       "precision                          {'amount': 1.0, 'price': 0.05}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': 'ETHUSD_ETH', 'rootSymbol': 'ETH', ...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                      0.0005   \n",
       "maker                                                     -0.0001   \n",
       "\n",
       "                                              ETH/USD:GWEI-220930  \\\n",
       "id                                                  ETHUSDU22_ETH   \n",
       "symbol                                        ETH/USD:GWEI-220930   \n",
       "base                                                          ETH   \n",
       "quote                                                         USD   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                       USD   \n",
       "active                                                       True   \n",
       "type                                                       future   \n",
       "linear                                                      False   \n",
       "inverse                                                      True   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                       True   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                     True   \n",
       "contractSize                                        -1000000000.0   \n",
       "expiry                                              1664539200000   \n",
       "expiryDatetime                           2022-09-30T12:00:00.000Z   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                       GWEI   \n",
       "settleId                                                     Gwei   \n",
       "precision                          {'amount': 1.0, 'price': 0.05}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': 'ETHUSDU22_ETH', 'rootSymbol': 'ETH...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                       False   \n",
       "taker                                                     0.00075   \n",
       "maker                                                     -0.0001   \n",
       "\n",
       "                                               ETH/BTC:BTC-220930  \\\n",
       "id                                                         ETHU22   \n",
       "symbol                                         ETH/BTC:BTC-220930   \n",
       "base                                                          ETH   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                       XBT   \n",
       "active                                                       True   \n",
       "type                                                       future   \n",
       "linear                                                       True   \n",
       "inverse                                                     False   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                       True   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                     True   \n",
       "contractSize                                               1000.0   \n",
       "expiry                                              1664539200000   \n",
       "expiryDatetime                           2022-09-30T12:00:00.000Z   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                        BTC   \n",
       "settleId                                                      XBt   \n",
       "precision                      {'amount': 1000.0, 'price': 1e-05}   \n",
       "limits          {'amount': {'min': None, 'max': 1000000000.0},...   \n",
       "info            {'symbol': 'ETHU22', 'rootSymbol': 'ETH', 'sta...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                       False   \n",
       "taker                                                     0.00075   \n",
       "maker                                                     -0.0001   \n",
       "\n",
       "                                               ETH/USD:BTC-220930  \\\n",
       "id                                                      ETHUSDU22   \n",
       "symbol                                         ETH/USD:BTC-220930   \n",
       "base                                                          ETH   \n",
       "quote                                                         USD   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                       USD   \n",
       "active                                                       True   \n",
       "type                                                       future   \n",
       "linear                                                       True   \n",
       "inverse                                                     False   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                       True   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                     True   \n",
       "contractSize                                                100.0   \n",
       "expiry                                              1664539200000   \n",
       "expiryDatetime                           2022-09-30T12:00:00.000Z   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                        BTC   \n",
       "settleId                                                      XBt   \n",
       "precision                          {'amount': 1.0, 'price': 0.05}   \n",
       "limits          {'amount': {'min': None, 'max': 10000000.0}, '...   \n",
       "info            {'symbol': 'ETHUSDU22', 'rootSymbol': 'ETH', '...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                       False   \n",
       "taker                                                     0.00075   \n",
       "maker                                                     -0.0001   \n",
       "\n",
       "                                             ETH/USDT:USDT-220930  \\\n",
       "id                                                     ETHUSDTU22   \n",
       "symbol                                       ETH/USDT:USDT-220930   \n",
       "base                                                          ETH   \n",
       "quote                                                        USDT   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                      USDT   \n",
       "active                                                       True   \n",
       "type                                                       future   \n",
       "linear                                                       True   \n",
       "inverse                                                     False   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                       True   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                     True   \n",
       "contractSize                                                 10.0   \n",
       "expiry                                              1664539200000   \n",
       "expiryDatetime                           2022-09-30T12:00:00.000Z   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                       USDT   \n",
       "settleId                                                     USDt   \n",
       "precision                       {'amount': 1000.0, 'price': 0.05}   \n",
       "limits          {'amount': {'min': None, 'max': 1000000000.0},...   \n",
       "info            {'symbol': 'ETHUSDTU22', 'rootSymbol': 'ETH', ...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                       False   \n",
       "taker                                                     0.00075   \n",
       "maker                                                     -0.0001   \n",
       "\n",
       "                                                         ETH_USDT  \\\n",
       "id                                                       ETH_USDT   \n",
       "symbol                                                   ETH_USDT   \n",
       "base                                                          ETH   \n",
       "quote                                                        USDT   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                      USDT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                  1.0   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                    {'amount': 1000000.0, 'price': 0.05}   \n",
       "limits          {'amount': {'min': None, 'max': 10000000000000...   \n",
       "info            {'symbol': 'ETH_USDT', 'rootSymbol': 'ETH', 's...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                       0.001   \n",
       "maker                                                       0.001   \n",
       "\n",
       "                                                      LTC/USD:BTC  \\\n",
       "id                                                         LTCUSD   \n",
       "symbol                                                LTC/USD:BTC   \n",
       "base                                                          LTC   \n",
       "quote                                                         USD   \n",
       "baseId                                                        LTC   \n",
       "quoteId                                                       USD   \n",
       "active                                                       True   \n",
       "type                                                         swap   \n",
       "linear                                                       True   \n",
       "inverse                                                     False   \n",
       "spot                                                        False   \n",
       "swap                                                         True   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                     True   \n",
       "contractSize                                                200.0   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                        BTC   \n",
       "settleId                                                      XBt   \n",
       "precision                          {'amount': 1.0, 'price': 0.01}   \n",
       "limits          {'amount': {'min': None, 'max': 100000000.0}, ...   \n",
       "info            {'symbol': 'LTCUSD', 'rootSymbol': 'LTC', 'sta...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                       False   \n",
       "taker                                                     0.00075   \n",
       "maker                                                     -0.0001   \n",
       "\n",
       "                                                    LTC/USDT:USDT  \n",
       "id                                                        LTCUSDT  \n",
       "symbol                                              LTC/USDT:USDT  \n",
       "base                                                          LTC  \n",
       "quote                                                        USDT  \n",
       "baseId                                                        LTC  \n",
       "quoteId                                                      USDT  \n",
       "active                                                       True  \n",
       "type                                                         swap  \n",
       "linear                                                       True  \n",
       "inverse                                                     False  \n",
       "spot                                                        False  \n",
       "swap                                                         True  \n",
       "future                                                      False  \n",
       "option                                                      False  \n",
       "margin                                                      False  \n",
       "contract                                                     True  \n",
       "contractSize                                                100.0  \n",
       "expiry                                                       None  \n",
       "expiryDatetime                                               None  \n",
       "optionType                                                   None  \n",
       "strike                                                       None  \n",
       "settle                                                       USDT  \n",
       "settleId                                                     USDt  \n",
       "precision                       {'amount': 1000.0, 'price': 0.01}  \n",
       "limits          {'amount': {'min': None, 'max': 1000000000.0},...  \n",
       "info            {'symbol': 'LTCUSDT', 'rootSymbol': 'LTC', 'st...  \n",
       "percentage                                                   True  \n",
       "prediction                                                  False  \n",
       "index                                                       False  \n",
       "taker                                                     0.00075  \n",
       "maker                                                     -0.0001  \n",
       "\n",
       "[31 rows x 498 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(exchange.load_markets())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "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>.EVOL7D</th>\n",
       "      <th>.BADAXBT</th>\n",
       "      <th>.BADAXBT30M</th>\n",
       "      <th>.BBCHXBT</th>\n",
       "      <th>.BBCHXBT30M</th>\n",
       "      <th>.BEOSXBT</th>\n",
       "      <th>.BEOSXBT30M</th>\n",
       "      <th>.BXRPXBT</th>\n",
       "      <th>.BXRPXBT30M</th>\n",
       "      <th>.BXRP</th>\n",
       "      <th>...</th>\n",
       "      <th>ETH/BTC:BTC</th>\n",
       "      <th>ETH/USDT:USDT</th>\n",
       "      <th>ETHUSD_ETH</th>\n",
       "      <th>ETH/USD:GWEI-220930</th>\n",
       "      <th>ETH/BTC:BTC-220930</th>\n",
       "      <th>ETH/USD:BTC-220930</th>\n",
       "      <th>ETH/USDT:USDT-220930</th>\n",
       "      <th>ETH_USDT</th>\n",
       "      <th>LTC/USD:BTC</th>\n",
       "      <th>LTC/USDT:USDT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <td>.EVOL7D</td>\n",
       "      <td>.BADAXBT</td>\n",
       "      <td>.BADAXBT30M</td>\n",
       "      <td>.BBCHXBT</td>\n",
       "      <td>.BBCHXBT30M</td>\n",
       "      <td>.BEOSXBT</td>\n",
       "      <td>.BEOSXBT30M</td>\n",
       "      <td>.BXRPXBT</td>\n",
       "      <td>.BXRPXBT30M</td>\n",
       "      <td>.BXRP</td>\n",
       "      <td>...</td>\n",
       "      <td>ETH/BTC:BTC</td>\n",
       "      <td>ETH/USDT:USDT</td>\n",
       "      <td>ETHUSD_ETH</td>\n",
       "      <td>ETH/USD:GWEI-220930</td>\n",
       "      <td>ETH/BTC:BTC-220930</td>\n",
       "      <td>ETH/USD:BTC-220930</td>\n",
       "      <td>ETH/USDT:USDT-220930</td>\n",
       "      <td>ETH_USDT</td>\n",
       "      <td>LTC/USD:BTC</td>\n",
       "      <td>LTC/USDT:USDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>timestamp</th>\n",
       "      <td>1658742000000</td>\n",
       "      <td>1658742780000</td>\n",
       "      <td>1658736000000</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>1658736000000</td>\n",
       "      <td>1658742775000</td>\n",
       "      <td>1658736000000</td>\n",
       "      <td>1658742760000</td>\n",
       "      <td>1658736000000</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>...</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>1658742830000</td>\n",
       "      <td>1658571976677</td>\n",
       "      <td>1658742825000</td>\n",
       "      <td>1658742830000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>datetime</th>\n",
       "      <td>2022-07-25T09:40:00.000Z</td>\n",
       "      <td>2022-07-25T09:53:00.000Z</td>\n",
       "      <td>2022-07-25T08:00:00.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>2022-07-25T08:00:00.000Z</td>\n",
       "      <td>2022-07-25T09:52:55.000Z</td>\n",
       "      <td>2022-07-25T08:00:00.000Z</td>\n",
       "      <td>2022-07-25T09:52:40.000Z</td>\n",
       "      <td>2022-07-25T08:00:00.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>...</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "      <td>2022-07-23T10:26:16.677Z</td>\n",
       "      <td>2022-07-25T09:53:45.000Z</td>\n",
       "      <td>2022-07-25T09:53:50.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>high</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>0.07253</td>\n",
       "      <td>1642.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0.074</td>\n",
       "      <td>1690.8</td>\n",
       "      <td>1688.25</td>\n",
       "      <td>None</td>\n",
       "      <td>59.7</td>\n",
       "      <td>59.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>low</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>0.06834</td>\n",
       "      <td>1470.85</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>0.07084</td>\n",
       "      <td>1559.25</td>\n",
       "      <td>1557.15</td>\n",
       "      <td>None</td>\n",
       "      <td>56.0</td>\n",
       "      <td>55.48</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 498 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            .EVOL7D                  .BADAXBT  \\\n",
       "symbol                      .EVOL7D                  .BADAXBT   \n",
       "timestamp             1658742000000             1658742780000   \n",
       "datetime   2022-07-25T09:40:00.000Z  2022-07-25T09:53:00.000Z   \n",
       "high                           None                      None   \n",
       "low                            None                      None   \n",
       "\n",
       "                        .BADAXBT30M                  .BBCHXBT  \\\n",
       "symbol                  .BADAXBT30M                  .BBCHXBT   \n",
       "timestamp             1658736000000             1658742830000   \n",
       "datetime   2022-07-25T08:00:00.000Z  2022-07-25T09:53:50.000Z   \n",
       "high                           None                      None   \n",
       "low                            None                      None   \n",
       "\n",
       "                        .BBCHXBT30M                  .BEOSXBT  \\\n",
       "symbol                  .BBCHXBT30M                  .BEOSXBT   \n",
       "timestamp             1658736000000             1658742775000   \n",
       "datetime   2022-07-25T08:00:00.000Z  2022-07-25T09:52:55.000Z   \n",
       "high                           None                      None   \n",
       "low                            None                      None   \n",
       "\n",
       "                        .BEOSXBT30M                  .BXRPXBT  \\\n",
       "symbol                  .BEOSXBT30M                  .BXRPXBT   \n",
       "timestamp             1658736000000             1658742760000   \n",
       "datetime   2022-07-25T08:00:00.000Z  2022-07-25T09:52:40.000Z   \n",
       "high                           None                      None   \n",
       "low                            None                      None   \n",
       "\n",
       "                        .BXRPXBT30M                     .BXRP  ...  \\\n",
       "symbol                  .BXRPXBT30M                     .BXRP  ...   \n",
       "timestamp             1658736000000             1658742830000  ...   \n",
       "datetime   2022-07-25T08:00:00.000Z  2022-07-25T09:53:50.000Z  ...   \n",
       "high                           None                      None  ...   \n",
       "low                            None                      None  ...   \n",
       "\n",
       "                        ETH/BTC:BTC             ETH/USDT:USDT  \\\n",
       "symbol                  ETH/BTC:BTC             ETH/USDT:USDT   \n",
       "timestamp             1658742830000             1658742830000   \n",
       "datetime   2022-07-25T09:53:50.000Z  2022-07-25T09:53:50.000Z   \n",
       "high                        0.07253                    1642.0   \n",
       "low                         0.06834                   1470.85   \n",
       "\n",
       "                         ETHUSD_ETH       ETH/USD:GWEI-220930  \\\n",
       "symbol                   ETHUSD_ETH       ETH/USD:GWEI-220930   \n",
       "timestamp             1658742830000             1658742830000   \n",
       "datetime   2022-07-25T09:53:50.000Z  2022-07-25T09:53:50.000Z   \n",
       "high                           None                      None   \n",
       "low                            None                      None   \n",
       "\n",
       "                 ETH/BTC:BTC-220930        ETH/USD:BTC-220930  \\\n",
       "symbol           ETH/BTC:BTC-220930        ETH/USD:BTC-220930   \n",
       "timestamp             1658742830000             1658742830000   \n",
       "datetime   2022-07-25T09:53:50.000Z  2022-07-25T09:53:50.000Z   \n",
       "high                          0.074                    1690.8   \n",
       "low                         0.07084                   1559.25   \n",
       "\n",
       "               ETH/USDT:USDT-220930                  ETH_USDT  \\\n",
       "symbol         ETH/USDT:USDT-220930                  ETH_USDT   \n",
       "timestamp             1658742830000             1658571976677   \n",
       "datetime   2022-07-25T09:53:50.000Z  2022-07-23T10:26:16.677Z   \n",
       "high                        1688.25                      None   \n",
       "low                         1557.15                      None   \n",
       "\n",
       "                        LTC/USD:BTC             LTC/USDT:USDT  \n",
       "symbol                  LTC/USD:BTC             LTC/USDT:USDT  \n",
       "timestamp             1658742825000             1658742830000  \n",
       "datetime   2022-07-25T09:53:45.000Z  2022-07-25T09:53:50.000Z  \n",
       "high                           59.7                     59.43  \n",
       "low                            56.0                     55.48  \n",
       "\n",
       "[5 rows x 498 columns]"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(exchange.fetchTickers).head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "# pd.DataFrame(exchange.fetchCurrencies).head()\n",
    "# # col = pd.DataFrame(exchange.load_markets()).collums\n",
    "# print(pd.DataFrame(exchange.load_markets()).columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                  bids\n",
      "0     [19886.5, 100.0]\n",
      "1     [19883.5, 100.0]\n",
      "2   [19792.5, 40900.0]\n",
      "3    [19773.5, 9000.0]\n",
      "4   [19772.5, 52900.0]\n",
      "5   [19752.5, 52800.0]\n",
      "6   [19733.0, 52800.0]\n",
      "7     [19722.0, 200.0]\n",
      "8    [19720.0, 5800.0]\n",
      "9   [19713.5, 52700.0]\n",
      "10   [19696.0, 1000.0]\n",
      "11  [19693.5, 52700.0]\n",
      "12  [19674.0, 52600.0]\n",
      "13  [19654.5, 40700.0]\n",
      "14    [19642.5, 500.0]\n",
      "15    [19632.5, 300.0]\n",
      "16    [19566.5, 100.0]\n",
      "17   [19502.0, 4900.0]\n",
      "18   [19500.5, 6000.0]\n",
      "19   [19462.0, 3000.0]\n",
      "20   [19417.0, 3000.0]\n",
      "21    [19295.5, 800.0]\n",
      "22    [19253.0, 100.0]\n",
      "23   [19232.0, 5000.0]\n",
      "24    [19190.0, 100.0]                   asks\n",
      "0     [19898.5, 100.0]\n",
      "1   [19953.0, 20900.0]\n",
      "2   [19961.0, 59000.0]\n",
      "3   [19983.0, 59100.0]\n",
      "4    [19999.0, 2100.0]\n",
      "5     [20000.0, 100.0]\n",
      "6    [20002.0, 2000.0]\n",
      "7   [20051.5, 53600.0]\n",
      "8   [20071.5, 53700.0]\n",
      "9     [20082.5, 600.0]\n",
      "10  [20091.5, 53700.0]\n",
      "11  [20111.5, 53800.0]\n",
      "12    [20119.0, 100.0]\n",
      "13  [20131.5, 53800.0]\n",
      "14  [20135.0, 10000.0]\n",
      "15  [20152.0, 53900.0]\n",
      "16  [20172.0, 54000.0]\n",
      "17  [20192.0, 54000.0]\n",
      "18  [20212.5, 54100.0]\n",
      "19  [20232.5, 54100.0]\n",
      "20   [20294.0, 3000.0]\n",
      "21    [20480.0, 100.0]\n",
      "22   [20516.0, 5000.0]\n",
      "23    [20530.0, 100.0]\n",
      "24   [20563.0, 9100.0]\n"
     ]
    }
   ],
   "source": [
    "# x = pd.read_csv('orderbook.csv')\n",
    "# x = pd.DataFrame(x)\n",
    "# x.head()\n",
    "bids = pd.read_csv('orderbook.csv')[\"bids\"]\n",
    "bids = pd.DataFrame(bids)\n",
    "bids = bids.rename(columns={0: \"price_bid\", 1: \"size_bid\"})\n",
    "asks = pd.read_csv('orderbook.csv')[\"asks\"]\n",
    "asks = pd.DataFrame(asks)\n",
    "asks.reset_index(drop=True, inplace=False)\n",
    "bids.reset_index(drop = True, inplace=False)\n",
    "asks = asks.rename(columns={0: \"price_ask\", 1: \"size_ask\"})\n",
    "asks = pd.DataFrame(asks)\n",
    "bids = pd.DataFrame(bids)\n",
    "print(bids,asks)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'print the '"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"\"\"print the \"\"\"\n",
    "\n",
    "# for i in range(len(bids)):\n",
    "#     # print(\n",
    "#     x = bids.iloc[0]\n",
    "#     y = x[::6]\n",
    "#     print(y)\n",
    "    # print([1])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "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>asks</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[22580.0, 100.0]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[22674.5, 60600.0]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[22697.0, 60900.0]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[22714.5, 300.0]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[22720.0, 60900.0]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 asks\n",
       "0    [22580.0, 100.0]\n",
       "1  [22674.5, 60600.0]\n",
       "2  [22697.0, 60900.0]\n",
       "3    [22714.5, 300.0]\n",
       "4  [22720.0, 60900.0]"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "x = pd.DataFrame(exchange.fetchOrderBook(symbol='XBTUSD'))\n",
    "bids = pd.DataFrame(x[\"bids\"])\n",
    "# bids = pd.DataFrame(bids)\n",
    "bids = bids.rename(columns={0: \"price_bid\", 1: \"size_bid\"})\n",
    "asks = pd.DataFrame(x[\"asks\"])\n",
    "# asks = pd.DataFrame(asks)\n",
    "asks.reset_index(drop=True, inplace=False)\n",
    "bids.reset_index(drop = True, inplace=False)\n",
    "asks = asks.rename(columns={0: \"price_ask\", 1: \"size_ask\"})\n",
    "asks = pd.DataFrame(asks)\n",
    "bids = pd.DataFrame(bids)\n",
    "asks.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "ETH_USDT\n",
      "{'amount': 1000000.0, 'price': 0.05}\n",
      "1000000.0\n"
     ]
    }
   ],
   "source": [
    "import ccxt\n",
    "# import streamlit as st\n",
    "import pandas as pd\n",
    "from itertools import accumulate\n",
    "import plotly.graph_objects as go\n",
    "from plotly.subplots import make_subplots\n",
    "from itertools import chain\n",
    "import numpy as np\n",
    "import plotly.express as px\n",
    "from datetime import datetime, timedelta\n",
    "exchange = ccxt.bitmex({\n",
    "    'apiKey': 'NOAb2TuyuLgWkYbXOQGH-x9b',\n",
    "    'secret': '_fAxf57mItdpX-A5KTxXRzJZY3zkeSKdCGlStwa95FAH81Gd',\n",
    "})\n",
    "if 'test' in exchange.urls:\n",
    "    exchange.urls['api'] = exchange.urls['test'] # ←----- switch the base URL to testnet\n",
    "x = pd.DataFrame(exchange.load_markets())\n",
    "symbol = \"ETH_USDT\"\n",
    "# st.selectbox(\"pair\", (pd.DataFrame(exchange.load_markets()).columns), index = 494 )\n",
    "print(symbol)\n",
    "# st.write(x.astype(str))\n",
    "precision = (x[symbol]['precision'])\n",
    "precision_amount = precision['amount']\n",
    "print(precision)\n",
    "print(precision_amount)\n",
    "# info = (x[symbol]['info'])\n",
    "# info = pd.DataFrame(info)\n",
    "# st.write(info)\n",
    "data = (exchange.fetchOrderBook(symbol)) \n",
    "\n",
    "bids = data[\"bids\"]\n",
    "bids = pd.DataFrame(bids)\n",
    "bids = bids.rename(columns={0: \"price_bid\", 1: \"size_bid\"})\n",
    "asks = data[\"asks\"]\n",
    "asks = pd.DataFrame(asks)\n",
    "asks.reset_index(drop=True, inplace=False)\n",
    "bids.reset_index(drop = True, inplace=False)\n",
    "asks = asks.rename(columns={0: \"price_ask\", 1: \"size_ask\"})\n",
    "\n",
    "asks['fixed_size_ask'] = asks['size_ask']/precision_amount\n",
    "bids['fixed_size_bid'] = bids['size_bid']/precision_amount\n",
    "\n",
    "asks = asks.drop(columns=['size_ask'])\n",
    "bids = bids.drop(columns=['size_bid'])\n",
    "\n",
    "asks = pd.DataFrame(asks)\n",
    "bids = pd.DataFrame(bids)\n",
    "# st.write(asks_update)\n",
    "# st.write(bids_update)\n",
    "asks['accumulated']  = (list(accumulate(asks['fixed_size_ask'])))\n",
    "asks['accumulated_price']  = (asks['price_ask']) * asks['fixed_size_ask']\n",
    "asks['accumulated_avg_price'] = (list(accumulate(asks['accumulated_price'])))  / asks['accumulated']\n",
    "asks['cash_equivelant'] = asks['accumulated'] * asks['accumulated_avg_price']\n",
    "\n",
    "bids['accumulated']  = (list(accumulate(bids['fixed_size_bid'])))\n",
    "bids['accumulated_price']  = (bids['price_bid']) * bids['fixed_size_bid']\n",
    "bids['accumulated_avg_price'] = (list(accumulate(bids['accumulated_price'])))  / bids['accumulated']\n",
    "bids['cash_equivelant'] = bids['accumulated'] * bids['accumulated_avg_price']                \n",
    "# for i in range(1, 2):\n",
    "#     cols = st.columns(2)\n",
    "#     cols[0].subheader(\"bids\")\n",
    "\n",
    "#     cols[0].write(bids)\n",
    "#     cols[1].subheader(\"asks\")\n",
    "\n",
    "#     cols[1].write(asks)\n",
    "# st.write(asks,bids, use_container_width=True)\n",
    "# st.write(asks_update,bids_update, use_container_width=True)\n",
    "# print(asks)\n",
    "# print(bids)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.random.randint(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "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>.EVOL7D</th>\n",
       "      <th>.BADAXBT</th>\n",
       "      <th>.BADAXBT30M</th>\n",
       "      <th>.BBCHXBT</th>\n",
       "      <th>.BBCHXBT30M</th>\n",
       "      <th>.BEOSXBT</th>\n",
       "      <th>.BEOSXBT30M</th>\n",
       "      <th>.BXRPXBT</th>\n",
       "      <th>.BXRPXBT30M</th>\n",
       "      <th>.BXRP</th>\n",
       "      <th>...</th>\n",
       "      <th>ETH/BTC:BTC</th>\n",
       "      <th>ETH/USDT:USDT</th>\n",
       "      <th>ETHUSD_ETH</th>\n",
       "      <th>ETH/USD:GWEI-220930</th>\n",
       "      <th>ETH/BTC:BTC-220930</th>\n",
       "      <th>ETH/USD:BTC-220930</th>\n",
       "      <th>ETH/USDT:USDT-220930</th>\n",
       "      <th>ETH_USDT</th>\n",
       "      <th>LTC/USD:BTC</th>\n",
       "      <th>LTC/USDT:USDT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <td>.EVOL7D</td>\n",
       "      <td>.BADAXBT</td>\n",
       "      <td>.BADAXBT30M</td>\n",
       "      <td>.BBCHXBT</td>\n",
       "      <td>.BBCHXBT30M</td>\n",
       "      <td>.BEOSXBT</td>\n",
       "      <td>.BEOSXBT30M</td>\n",
       "      <td>.BXRPXBT</td>\n",
       "      <td>.BXRPXBT30M</td>\n",
       "      <td>.BXRP</td>\n",
       "      <td>...</td>\n",
       "      <td>ETHXBT</td>\n",
       "      <td>ETHUSDT</td>\n",
       "      <td>ETHUSD_ETH</td>\n",
       "      <td>ETHUSDU22_ETH</td>\n",
       "      <td>ETHU22</td>\n",
       "      <td>ETHUSDU22</td>\n",
       "      <td>ETHUSDTU22</td>\n",
       "      <td>ETH_USDT</td>\n",
       "      <td>LTCUSD</td>\n",
       "      <td>LTCUSDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <td>.EVOL7D</td>\n",
       "      <td>.BADAXBT</td>\n",
       "      <td>.BADAXBT30M</td>\n",
       "      <td>.BBCHXBT</td>\n",
       "      <td>.BBCHXBT30M</td>\n",
       "      <td>.BEOSXBT</td>\n",
       "      <td>.BEOSXBT30M</td>\n",
       "      <td>.BXRPXBT</td>\n",
       "      <td>.BXRPXBT30M</td>\n",
       "      <td>.BXRP</td>\n",
       "      <td>...</td>\n",
       "      <td>ETH/BTC:BTC</td>\n",
       "      <td>ETH/USDT:USDT</td>\n",
       "      <td>ETHUSD_ETH</td>\n",
       "      <td>ETH/USD:GWEI-220930</td>\n",
       "      <td>ETH/BTC:BTC-220930</td>\n",
       "      <td>ETH/USD:BTC-220930</td>\n",
       "      <td>ETH/USDT:USDT-220930</td>\n",
       "      <td>ETH_USDT</td>\n",
       "      <td>LTC/USD:BTC</td>\n",
       "      <td>LTC/USDT:USDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>base</th>\n",
       "      <td>ETH</td>\n",
       "      <td>ADA</td>\n",
       "      <td>ADA</td>\n",
       "      <td>BCH</td>\n",
       "      <td>BCH</td>\n",
       "      <td>EOS</td>\n",
       "      <td>EOS</td>\n",
       "      <td>XRP</td>\n",
       "      <td>XRP</td>\n",
       "      <td>XRP</td>\n",
       "      <td>...</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>LTC</td>\n",
       "      <td>LTC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>quote</th>\n",
       "      <td>XXX</td>\n",
       "      <td>BTC</td>\n",
       "      <td>BTC</td>\n",
       "      <td>BTC</td>\n",
       "      <td>BTC</td>\n",
       "      <td>BTC</td>\n",
       "      <td>BTC</td>\n",
       "      <td>BTC</td>\n",
       "      <td>BTC</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>BTC</td>\n",
       "      <td>USDT</td>\n",
       "      <td>USD</td>\n",
       "      <td>USD</td>\n",
       "      <td>BTC</td>\n",
       "      <td>USD</td>\n",
       "      <td>USDT</td>\n",
       "      <td>USDT</td>\n",
       "      <td>USD</td>\n",
       "      <td>USDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>baseId</th>\n",
       "      <td>ETH</td>\n",
       "      <td>ADA</td>\n",
       "      <td>ADA</td>\n",
       "      <td>BCH</td>\n",
       "      <td>BCH</td>\n",
       "      <td>EOS</td>\n",
       "      <td>EOS</td>\n",
       "      <td>XRP</td>\n",
       "      <td>XRP</td>\n",
       "      <td>XRP</td>\n",
       "      <td>...</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>ETH</td>\n",
       "      <td>LTC</td>\n",
       "      <td>LTC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>quoteId</th>\n",
       "      <td>XXX</td>\n",
       "      <td>XBT</td>\n",
       "      <td>XBT</td>\n",
       "      <td>XBT</td>\n",
       "      <td>XBT</td>\n",
       "      <td>XBT</td>\n",
       "      <td>XBT</td>\n",
       "      <td>XBT</td>\n",
       "      <td>XBT</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>XBT</td>\n",
       "      <td>USDT</td>\n",
       "      <td>USD</td>\n",
       "      <td>USD</td>\n",
       "      <td>XBT</td>\n",
       "      <td>USD</td>\n",
       "      <td>USDT</td>\n",
       "      <td>USDT</td>\n",
       "      <td>USD</td>\n",
       "      <td>USDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>active</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>type</th>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>index</td>\n",
       "      <td>...</td>\n",
       "      <td>swap</td>\n",
       "      <td>swap</td>\n",
       "      <td>index</td>\n",
       "      <td>future</td>\n",
       "      <td>future</td>\n",
       "      <td>future</td>\n",
       "      <td>future</td>\n",
       "      <td>index</td>\n",
       "      <td>swap</td>\n",
       "      <td>swap</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>linear</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>None</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>inverse</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>None</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>spot</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>swap</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>future</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>option</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>margin</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>contract</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>contractSize</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>100000000.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>-1000000000.0</td>\n",
       "      <td>-1000000000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>expiry</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>1664539200000</td>\n",
       "      <td>1664539200000</td>\n",
       "      <td>1664539200000</td>\n",
       "      <td>1664539200000</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>expiryDatetime</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>2022-09-30T12:00:00.000Z</td>\n",
       "      <td>2022-09-30T12:00:00.000Z</td>\n",
       "      <td>2022-09-30T12:00:00.000Z</td>\n",
       "      <td>2022-09-30T12:00:00.000Z</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>optionType</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>strike</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>settle</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>BTC</td>\n",
       "      <td>USDT</td>\n",
       "      <td>GWEI</td>\n",
       "      <td>GWEI</td>\n",
       "      <td>BTC</td>\n",
       "      <td>BTC</td>\n",
       "      <td>USDT</td>\n",
       "      <td></td>\n",
       "      <td>BTC</td>\n",
       "      <td>USDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>settleId</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>XBt</td>\n",
       "      <td>USDt</td>\n",
       "      <td>Gwei</td>\n",
       "      <td>Gwei</td>\n",
       "      <td>XBt</td>\n",
       "      <td>XBt</td>\n",
       "      <td>USDt</td>\n",
       "      <td></td>\n",
       "      <td>XBt</td>\n",
       "      <td>USDt</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>precision</th>\n",
       "      <td>{'amount': None, 'price': 0.01}</td>\n",
       "      <td>{'amount': None, 'price': 1e-08}</td>\n",
       "      <td>{'amount': None, 'price': 1e-08}</td>\n",
       "      <td>{'amount': None, 'price': 1e-06}</td>\n",
       "      <td>{'amount': None, 'price': 1e-06}</td>\n",
       "      <td>{'amount': None, 'price': 1e-08}</td>\n",
       "      <td>{'amount': None, 'price': 1e-08}</td>\n",
       "      <td>{'amount': None, 'price': 1e-08}</td>\n",
       "      <td>{'amount': None, 'price': 1e-08}</td>\n",
       "      <td>{'amount': None, 'price': 1e-05}</td>\n",
       "      <td>...</td>\n",
       "      <td>{'amount': 1.0, 'price': 1e-05}</td>\n",
       "      <td>{'amount': 1000.0, 'price': 0.05}</td>\n",
       "      <td>{'amount': 1.0, 'price': 0.05}</td>\n",
       "      <td>{'amount': 1.0, 'price': 0.05}</td>\n",
       "      <td>{'amount': 1000.0, 'price': 1e-05}</td>\n",
       "      <td>{'amount': 1.0, 'price': 0.05}</td>\n",
       "      <td>{'amount': 1000.0, 'price': 0.05}</td>\n",
       "      <td>{'amount': 1000000.0, 'price': 0.05}</td>\n",
       "      <td>{'amount': 1.0, 'price': 0.01}</td>\n",
       "      <td>{'amount': 1000.0, 'price': 0.01}</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>limits</th>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>...</td>\n",
       "      <td>{'amount': {'min': None, 'max': 100000000.0}, ...</td>\n",
       "      <td>{'amount': {'min': None, 'max': 1000000000.0},...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': None}, 'price'...</td>\n",
       "      <td>{'amount': {'min': None, 'max': 1000000000.0},...</td>\n",
       "      <td>{'amount': {'min': None, 'max': 10000000.0}, '...</td>\n",
       "      <td>{'amount': {'min': None, 'max': 1000000000.0},...</td>\n",
       "      <td>{'amount': {'min': None, 'max': 10000000000000...</td>\n",
       "      <td>{'amount': {'min': None, 'max': 100000000.0}, ...</td>\n",
       "      <td>{'amount': {'min': None, 'max': 1000000000.0},...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>info</th>\n",
       "      <td>{'symbol': '.EVOL7D', 'rootSymbol': 'EVOL', 's...</td>\n",
       "      <td>{'symbol': '.BADAXBT', 'rootSymbol': 'ADA', 's...</td>\n",
       "      <td>{'symbol': '.BADAXBT30M', 'rootSymbol': 'ADA',...</td>\n",
       "      <td>{'symbol': '.BBCHXBT', 'rootSymbol': 'BCH', 's...</td>\n",
       "      <td>{'symbol': '.BBCHXBT30M', 'rootSymbol': 'BCH',...</td>\n",
       "      <td>{'symbol': '.BEOSXBT', 'rootSymbol': 'EOS', 's...</td>\n",
       "      <td>{'symbol': '.BEOSXBT30M', 'rootSymbol': 'EOS',...</td>\n",
       "      <td>{'symbol': '.BXRPXBT', 'rootSymbol': 'XRP', 's...</td>\n",
       "      <td>{'symbol': '.BXRPXBT30M', 'rootSymbol': 'XRP',...</td>\n",
       "      <td>{'symbol': '.BXRP', 'rootSymbol': 'XRP', 'stat...</td>\n",
       "      <td>...</td>\n",
       "      <td>{'symbol': 'ETHXBT', 'rootSymbol': 'ETH', 'sta...</td>\n",
       "      <td>{'symbol': 'ETHUSDT', 'rootSymbol': 'ETH', 'st...</td>\n",
       "      <td>{'symbol': 'ETHUSD_ETH', 'rootSymbol': 'ETH', ...</td>\n",
       "      <td>{'symbol': 'ETHUSDU22_ETH', 'rootSymbol': 'ETH...</td>\n",
       "      <td>{'symbol': 'ETHU22', 'rootSymbol': 'ETH', 'sta...</td>\n",
       "      <td>{'symbol': 'ETHUSDU22', 'rootSymbol': 'ETH', '...</td>\n",
       "      <td>{'symbol': 'ETHUSDTU22', 'rootSymbol': 'ETH', ...</td>\n",
       "      <td>{'symbol': 'ETH_USDT', 'rootSymbol': 'ETH', 's...</td>\n",
       "      <td>{'symbol': 'LTCUSD', 'rootSymbol': 'LTC', 'sta...</td>\n",
       "      <td>{'symbol': 'LTCUSDT', 'rootSymbol': 'LTC', 'st...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>percentage</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>prediction</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>index</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>taker</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>0.00075</td>\n",
       "      <td>0.00075</td>\n",
       "      <td>0.0005</td>\n",
       "      <td>0.00075</td>\n",
       "      <td>0.00075</td>\n",
       "      <td>0.00075</td>\n",
       "      <td>0.00075</td>\n",
       "      <td>0.001</td>\n",
       "      <td>0.00075</td>\n",
       "      <td>0.00075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>maker</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>0.001</td>\n",
       "      <td>-0.0001</td>\n",
       "      <td>-0.0001</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>31 rows × 498 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                          .EVOL7D  \\\n",
       "id                                                        .EVOL7D   \n",
       "symbol                                                    .EVOL7D   \n",
       "base                                                          ETH   \n",
       "quote                                                         XXX   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                       XXX   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                         {'amount': None, 'price': 0.01}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.EVOL7D', 'rootSymbol': 'EVOL', 's...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                         .BADAXBT  \\\n",
       "id                                                       .BADAXBT   \n",
       "symbol                                                   .BADAXBT   \n",
       "base                                                          ADA   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        ADA   \n",
       "quoteId                                                       XBT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                        {'amount': None, 'price': 1e-08}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.BADAXBT', 'rootSymbol': 'ADA', 's...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                      .BADAXBT30M  \\\n",
       "id                                                    .BADAXBT30M   \n",
       "symbol                                                .BADAXBT30M   \n",
       "base                                                          ADA   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        ADA   \n",
       "quoteId                                                       XBT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                        {'amount': None, 'price': 1e-08}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.BADAXBT30M', 'rootSymbol': 'ADA',...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                         .BBCHXBT  \\\n",
       "id                                                       .BBCHXBT   \n",
       "symbol                                                   .BBCHXBT   \n",
       "base                                                          BCH   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        BCH   \n",
       "quoteId                                                       XBT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                        {'amount': None, 'price': 1e-06}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.BBCHXBT', 'rootSymbol': 'BCH', 's...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                      .BBCHXBT30M  \\\n",
       "id                                                    .BBCHXBT30M   \n",
       "symbol                                                .BBCHXBT30M   \n",
       "base                                                          BCH   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        BCH   \n",
       "quoteId                                                       XBT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                        {'amount': None, 'price': 1e-06}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.BBCHXBT30M', 'rootSymbol': 'BCH',...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                         .BEOSXBT  \\\n",
       "id                                                       .BEOSXBT   \n",
       "symbol                                                   .BEOSXBT   \n",
       "base                                                          EOS   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        EOS   \n",
       "quoteId                                                       XBT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                        {'amount': None, 'price': 1e-08}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.BEOSXBT', 'rootSymbol': 'EOS', 's...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                      .BEOSXBT30M  \\\n",
       "id                                                    .BEOSXBT30M   \n",
       "symbol                                                .BEOSXBT30M   \n",
       "base                                                          EOS   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        EOS   \n",
       "quoteId                                                       XBT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                        {'amount': None, 'price': 1e-08}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.BEOSXBT30M', 'rootSymbol': 'EOS',...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                         .BXRPXBT  \\\n",
       "id                                                       .BXRPXBT   \n",
       "symbol                                                   .BXRPXBT   \n",
       "base                                                          XRP   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        XRP   \n",
       "quoteId                                                       XBT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                        {'amount': None, 'price': 1e-08}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.BXRPXBT', 'rootSymbol': 'XRP', 's...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                      .BXRPXBT30M  \\\n",
       "id                                                    .BXRPXBT30M   \n",
       "symbol                                                .BXRPXBT30M   \n",
       "base                                                          XRP   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        XRP   \n",
       "quoteId                                                       XBT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                 None   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                        {'amount': None, 'price': 1e-08}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': '.BXRPXBT30M', 'rootSymbol': 'XRP',...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                        None   \n",
       "maker                                                        None   \n",
       "\n",
       "                                                            .BXRP  ...  \\\n",
       "id                                                          .BXRP  ...   \n",
       "symbol                                                      .BXRP  ...   \n",
       "base                                                          XRP  ...   \n",
       "quote                                                         USD  ...   \n",
       "baseId                                                        XRP  ...   \n",
       "quoteId                                                       USD  ...   \n",
       "active                                                      False  ...   \n",
       "type                                                        index  ...   \n",
       "linear                                                       None  ...   \n",
       "inverse                                                      None  ...   \n",
       "spot                                                        False  ...   \n",
       "swap                                                        False  ...   \n",
       "future                                                      False  ...   \n",
       "option                                                      False  ...   \n",
       "margin                                                      False  ...   \n",
       "contract                                                    False  ...   \n",
       "contractSize                                                 None  ...   \n",
       "expiry                                                       None  ...   \n",
       "expiryDatetime                                               None  ...   \n",
       "optionType                                                   None  ...   \n",
       "strike                                                       None  ...   \n",
       "settle                                                             ...   \n",
       "settleId                                                           ...   \n",
       "precision                        {'amount': None, 'price': 1e-05}  ...   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...  ...   \n",
       "info            {'symbol': '.BXRP', 'rootSymbol': 'XRP', 'stat...  ...   \n",
       "percentage                                                   True  ...   \n",
       "prediction                                                  False  ...   \n",
       "index                                                        True  ...   \n",
       "taker                                                        None  ...   \n",
       "maker                                                        None  ...   \n",
       "\n",
       "                                                      ETH/BTC:BTC  \\\n",
       "id                                                         ETHXBT   \n",
       "symbol                                                ETH/BTC:BTC   \n",
       "base                                                          ETH   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                       XBT   \n",
       "active                                                       True   \n",
       "type                                                         swap   \n",
       "linear                                                       True   \n",
       "inverse                                                     False   \n",
       "spot                                                        False   \n",
       "swap                                                         True   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                     True   \n",
       "contractSize                                          100000000.0   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                        BTC   \n",
       "settleId                                                      XBt   \n",
       "precision                         {'amount': 1.0, 'price': 1e-05}   \n",
       "limits          {'amount': {'min': None, 'max': 100000000.0}, ...   \n",
       "info            {'symbol': 'ETHXBT', 'rootSymbol': 'ETH', 'sta...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                       False   \n",
       "taker                                                     0.00075   \n",
       "maker                                                     -0.0001   \n",
       "\n",
       "                                                    ETH/USDT:USDT  \\\n",
       "id                                                        ETHUSDT   \n",
       "symbol                                              ETH/USDT:USDT   \n",
       "base                                                          ETH   \n",
       "quote                                                        USDT   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                      USDT   \n",
       "active                                                       True   \n",
       "type                                                         swap   \n",
       "linear                                                       True   \n",
       "inverse                                                     False   \n",
       "spot                                                        False   \n",
       "swap                                                         True   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                     True   \n",
       "contractSize                                                 10.0   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                       USDT   \n",
       "settleId                                                     USDt   \n",
       "precision                       {'amount': 1000.0, 'price': 0.05}   \n",
       "limits          {'amount': {'min': None, 'max': 1000000000.0},...   \n",
       "info            {'symbol': 'ETHUSDT', 'rootSymbol': 'ETH', 'st...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                       False   \n",
       "taker                                                     0.00075   \n",
       "maker                                                     -0.0001   \n",
       "\n",
       "                                                       ETHUSD_ETH  \\\n",
       "id                                                     ETHUSD_ETH   \n",
       "symbol                                                 ETHUSD_ETH   \n",
       "base                                                          ETH   \n",
       "quote                                                         USD   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                       USD   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                        -1000000000.0   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                       GWEI   \n",
       "settleId                                                     Gwei   \n",
       "precision                          {'amount': 1.0, 'price': 0.05}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': 'ETHUSD_ETH', 'rootSymbol': 'ETH', ...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                      0.0005   \n",
       "maker                                                     -0.0001   \n",
       "\n",
       "                                              ETH/USD:GWEI-220930  \\\n",
       "id                                                  ETHUSDU22_ETH   \n",
       "symbol                                        ETH/USD:GWEI-220930   \n",
       "base                                                          ETH   \n",
       "quote                                                         USD   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                       USD   \n",
       "active                                                       True   \n",
       "type                                                       future   \n",
       "linear                                                      False   \n",
       "inverse                                                      True   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                       True   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                     True   \n",
       "contractSize                                        -1000000000.0   \n",
       "expiry                                              1664539200000   \n",
       "expiryDatetime                           2022-09-30T12:00:00.000Z   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                       GWEI   \n",
       "settleId                                                     Gwei   \n",
       "precision                          {'amount': 1.0, 'price': 0.05}   \n",
       "limits          {'amount': {'min': None, 'max': None}, 'price'...   \n",
       "info            {'symbol': 'ETHUSDU22_ETH', 'rootSymbol': 'ETH...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                       False   \n",
       "taker                                                     0.00075   \n",
       "maker                                                     -0.0001   \n",
       "\n",
       "                                               ETH/BTC:BTC-220930  \\\n",
       "id                                                         ETHU22   \n",
       "symbol                                         ETH/BTC:BTC-220930   \n",
       "base                                                          ETH   \n",
       "quote                                                         BTC   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                       XBT   \n",
       "active                                                       True   \n",
       "type                                                       future   \n",
       "linear                                                       True   \n",
       "inverse                                                     False   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                       True   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                     True   \n",
       "contractSize                                               1000.0   \n",
       "expiry                                              1664539200000   \n",
       "expiryDatetime                           2022-09-30T12:00:00.000Z   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                        BTC   \n",
       "settleId                                                      XBt   \n",
       "precision                      {'amount': 1000.0, 'price': 1e-05}   \n",
       "limits          {'amount': {'min': None, 'max': 1000000000.0},...   \n",
       "info            {'symbol': 'ETHU22', 'rootSymbol': 'ETH', 'sta...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                       False   \n",
       "taker                                                     0.00075   \n",
       "maker                                                     -0.0001   \n",
       "\n",
       "                                               ETH/USD:BTC-220930  \\\n",
       "id                                                      ETHUSDU22   \n",
       "symbol                                         ETH/USD:BTC-220930   \n",
       "base                                                          ETH   \n",
       "quote                                                         USD   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                       USD   \n",
       "active                                                       True   \n",
       "type                                                       future   \n",
       "linear                                                       True   \n",
       "inverse                                                     False   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                       True   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                     True   \n",
       "contractSize                                                100.0   \n",
       "expiry                                              1664539200000   \n",
       "expiryDatetime                           2022-09-30T12:00:00.000Z   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                        BTC   \n",
       "settleId                                                      XBt   \n",
       "precision                          {'amount': 1.0, 'price': 0.05}   \n",
       "limits          {'amount': {'min': None, 'max': 10000000.0}, '...   \n",
       "info            {'symbol': 'ETHUSDU22', 'rootSymbol': 'ETH', '...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                       False   \n",
       "taker                                                     0.00075   \n",
       "maker                                                     -0.0001   \n",
       "\n",
       "                                             ETH/USDT:USDT-220930  \\\n",
       "id                                                     ETHUSDTU22   \n",
       "symbol                                       ETH/USDT:USDT-220930   \n",
       "base                                                          ETH   \n",
       "quote                                                        USDT   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                      USDT   \n",
       "active                                                       True   \n",
       "type                                                       future   \n",
       "linear                                                       True   \n",
       "inverse                                                     False   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                       True   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                     True   \n",
       "contractSize                                                 10.0   \n",
       "expiry                                              1664539200000   \n",
       "expiryDatetime                           2022-09-30T12:00:00.000Z   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                       USDT   \n",
       "settleId                                                     USDt   \n",
       "precision                       {'amount': 1000.0, 'price': 0.05}   \n",
       "limits          {'amount': {'min': None, 'max': 1000000000.0},...   \n",
       "info            {'symbol': 'ETHUSDTU22', 'rootSymbol': 'ETH', ...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                       False   \n",
       "taker                                                     0.00075   \n",
       "maker                                                     -0.0001   \n",
       "\n",
       "                                                         ETH_USDT  \\\n",
       "id                                                       ETH_USDT   \n",
       "symbol                                                   ETH_USDT   \n",
       "base                                                          ETH   \n",
       "quote                                                        USDT   \n",
       "baseId                                                        ETH   \n",
       "quoteId                                                      USDT   \n",
       "active                                                      False   \n",
       "type                                                        index   \n",
       "linear                                                       None   \n",
       "inverse                                                      None   \n",
       "spot                                                        False   \n",
       "swap                                                        False   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                    False   \n",
       "contractSize                                                  1.0   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                              \n",
       "settleId                                                            \n",
       "precision                    {'amount': 1000000.0, 'price': 0.05}   \n",
       "limits          {'amount': {'min': None, 'max': 10000000000000...   \n",
       "info            {'symbol': 'ETH_USDT', 'rootSymbol': 'ETH', 's...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                        True   \n",
       "taker                                                       0.001   \n",
       "maker                                                       0.001   \n",
       "\n",
       "                                                      LTC/USD:BTC  \\\n",
       "id                                                         LTCUSD   \n",
       "symbol                                                LTC/USD:BTC   \n",
       "base                                                          LTC   \n",
       "quote                                                         USD   \n",
       "baseId                                                        LTC   \n",
       "quoteId                                                       USD   \n",
       "active                                                       True   \n",
       "type                                                         swap   \n",
       "linear                                                       True   \n",
       "inverse                                                     False   \n",
       "spot                                                        False   \n",
       "swap                                                         True   \n",
       "future                                                      False   \n",
       "option                                                      False   \n",
       "margin                                                      False   \n",
       "contract                                                     True   \n",
       "contractSize                                                200.0   \n",
       "expiry                                                       None   \n",
       "expiryDatetime                                               None   \n",
       "optionType                                                   None   \n",
       "strike                                                       None   \n",
       "settle                                                        BTC   \n",
       "settleId                                                      XBt   \n",
       "precision                          {'amount': 1.0, 'price': 0.01}   \n",
       "limits          {'amount': {'min': None, 'max': 100000000.0}, ...   \n",
       "info            {'symbol': 'LTCUSD', 'rootSymbol': 'LTC', 'sta...   \n",
       "percentage                                                   True   \n",
       "prediction                                                  False   \n",
       "index                                                       False   \n",
       "taker                                                     0.00075   \n",
       "maker                                                     -0.0001   \n",
       "\n",
       "                                                    LTC/USDT:USDT  \n",
       "id                                                        LTCUSDT  \n",
       "symbol                                              LTC/USDT:USDT  \n",
       "base                                                          LTC  \n",
       "quote                                                        USDT  \n",
       "baseId                                                        LTC  \n",
       "quoteId                                                      USDT  \n",
       "active                                                       True  \n",
       "type                                                         swap  \n",
       "linear                                                       True  \n",
       "inverse                                                     False  \n",
       "spot                                                        False  \n",
       "swap                                                         True  \n",
       "future                                                      False  \n",
       "option                                                      False  \n",
       "margin                                                      False  \n",
       "contract                                                     True  \n",
       "contractSize                                                100.0  \n",
       "expiry                                                       None  \n",
       "expiryDatetime                                               None  \n",
       "optionType                                                   None  \n",
       "strike                                                       None  \n",
       "settle                                                       USDT  \n",
       "settleId                                                     USDt  \n",
       "precision                       {'amount': 1000.0, 'price': 0.01}  \n",
       "limits          {'amount': {'min': None, 'max': 1000000000.0},...  \n",
       "info            {'symbol': 'LTCUSDT', 'rootSymbol': 'LTC', 'st...  \n",
       "percentage                                                   True  \n",
       "prediction                                                  False  \n",
       "index                                                       False  \n",
       "taker                                                     0.00075  \n",
       "maker                                                     -0.0001  \n",
       "\n",
       "[31 rows x 498 columns]"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "load_makets_for_data = pd.DataFrame(exchange.load_markets()).astype(str)\n",
    "# load_makets_for_data = load_makets_for_data[load_makets_for_data.active != 'False']\n",
    "# load_makets_for_d = \n",
    "# load_makets_for_data = load_makets_for_data.drop(load_makets_for_data.iloc[:, 1:30], inplace=False, axis=1)\n",
    "# print(load_makets_for_d)\n",
    "# load_makets_for_data = load_makets_for_data.drop(columns=[load_makets_for_d])\n",
    "load_makets_for_data\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [],
   "source": [
    "# asks.head()\n",
    "\n",
    "for i in range(len(asks)):\n",
    "    x = asks['price_ask'].iloc[i]\n",
    "    y = asks['fixed_size_ask'].iloc[i]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "7500.0\n",
      "6006.0\n"
     ]
    }
   ],
   "source": [
    "\n",
    "def arrayz():\n",
    "    for i in range(len(asks)):\n",
    "        x = np.array(asks['price_ask'].iloc[i])\n",
    "        y = np.array(asks['fixed_size_ask'].iloc[i])\n",
    "        return x, y\n",
    "arrayz()\n",
    "print(x)\n",
    "print(y)\n",
    "# a = np.array([x])\n",
    "# print(x)\n",
    "\n",
    "# b = np.random.randint(10, size=(2, 10))\n",
    "# print(b)\n",
    "\n",
    "# arr = np.array([a, a])\n",
    "# print(arr)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "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>price_bid</th>\n",
       "      <th>fixed_size_bid</th>\n",
       "      <th>accumulated</th>\n",
       "      <th>accumulated_price</th>\n",
       "      <th>accumulated_avg_price</th>\n",
       "      <th>cash_equivelant</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1532.4</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1532.4</td>\n",
       "      <td>1532.400000</td>\n",
       "      <td>1532.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1532.2</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3064.4</td>\n",
       "      <td>1532.266667</td>\n",
       "      <td>4596.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1519.8</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3039.6</td>\n",
       "      <td>1527.280000</td>\n",
       "      <td>7636.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1512.9</td>\n",
       "      <td>3.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4538.7</td>\n",
       "      <td>1521.887500</td>\n",
       "      <td>12175.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1250.0</td>\n",
       "      <td>481.0</td>\n",
       "      <td>489.0</td>\n",
       "      <td>601250.0</td>\n",
       "      <td>1254.448057</td>\n",
       "      <td>613425.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   price_bid  fixed_size_bid  accumulated  accumulated_price  \\\n",
       "0     1532.4             1.0          1.0             1532.4   \n",
       "1     1532.2             2.0          3.0             3064.4   \n",
       "2     1519.8             2.0          5.0             3039.6   \n",
       "3     1512.9             3.0          8.0             4538.7   \n",
       "4     1250.0           481.0        489.0           601250.0   \n",
       "\n",
       "   accumulated_avg_price  cash_equivelant  \n",
       "0            1532.400000           1532.4  \n",
       "1            1532.266667           4596.8  \n",
       "2            1527.280000           7636.4  \n",
       "3            1521.887500          12175.1  \n",
       "4            1254.448057         613425.1  "
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# asks.head()\n",
    "bids.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     1.000000e+06\n",
       "1     2.000000e+06\n",
       "2     2.000000e+06\n",
       "3     3.000000e+06\n",
       "4     4.810000e+08\n",
       "5     3.383000e+09\n",
       "6     5.000000e+07\n",
       "7     3.330000e+08\n",
       "8     1.000000e+09\n",
       "9     9.170240e+11\n",
       "10    1.001000e+09\n",
       "11    1.000000e+10\n",
       "Name: mm_bid_size, dtype: float64"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import math\n",
    "\n",
    "pct_expiry_dated = 0.25\n",
    "latest_rateAPY_spot = 0.0088\n",
    "latest_rateAPY_quote = 0.0020\n",
    "\n",
    "holder = 1*((1-(latest_rateAPY_spot*pct_expiry_dated)))\n",
    "alpha = 0\n",
    "apy_to_beat = (((1+latest_rateAPY_quote)*(1+latest_rateAPY_spot)))+alpha-1\n",
    "holder_2 = (1-(holder*apy_to_beat))*holder\n",
    "\n",
    "precision_price = 0.05\n",
    "precision_amount = 1000000\n",
    "\n",
    "\n",
    "\n",
    "bid_new = pd.DataFrame(bids)\n",
    "bid_new.head()\n",
    "bid_new['mm_bid_price']  = round(round(bids['price_bid'] * holder_2 / precision_price) * precision_price, -int(math.floor(math.log10(precision_price))))\n",
    "bid_new['mm_bid_size'] = bids['fixed_size_bid'] * precision_amount\n",
    "#  round(round(bids['fixed_size_bid'] * holder_2 / precision_amount) * precision_amount, -int(math.floor(math.log10(precision_amount))))\n",
    "bid_new = bid_new.drop(columns=['accumulated', 'accumulated_price', 'accumulated_avg_price','cash_equivelant','price_bid','fixed_size_bid'])\n",
    "\n",
    "bid_new['mm_bid_size']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [],
   "source": [
    "# for col_name, data in bid_new.iterrows():\n",
    "#     x = (data['mm_bid_price'])\n",
    "#     y =(data['mm_bid_size'])\n",
    "#     order_init = exchange.createLimitBuyOrder(symbol='ETH_USDT',price=x,amount=y)\n",
    "#     print(order_init)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "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>data</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>orderID</th>\n",
       "      <td>2feea312-3458-4f9f-b659-8927d18c038e</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>clOrdID</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>clOrdLinkID</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>account</th>\n",
       "      <td>403419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <td>ETH_USDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>side</th>\n",
       "      <td>Buy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>simpleOrderQty</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>orderQty</th>\n",
       "      <td>1000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>price</th>\n",
       "      <td>1047.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>displayQty</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stopPx</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pegOffsetValue</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pegPriceType</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currency</th>\n",
       "      <td>USDT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>settlCurrency</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ordType</th>\n",
       "      <td>Limit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>timeInForce</th>\n",
       "      <td>GoodTillCancel</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>execInst</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>contingencyType</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>exDestination</th>\n",
       "      <td>XBME</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ordStatus</th>\n",
       "      <td>New</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>triggered</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>workingIndicator</th>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ordRejReason</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>simpleLeavesQty</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>leavesQty</th>\n",
       "      <td>1000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>simpleCumQty</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cumQty</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>avgPx</th>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>multiLegReportingType</th>\n",
       "      <td>SingleSecurity</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>text</th>\n",
       "      <td>Submitted via API.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>transactTime</th>\n",
       "      <td>2022-07-12T15:49:56.803Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>timestamp</th>\n",
       "      <td>2022-07-12T15:49:56.803Z</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                       data\n",
       "orderID                2feea312-3458-4f9f-b659-8927d18c038e\n",
       "clOrdID                                                    \n",
       "clOrdLinkID                                                \n",
       "account                                              403419\n",
       "symbol                                             ETH_USDT\n",
       "side                                                    Buy\n",
       "simpleOrderQty                                         None\n",
       "orderQty                                            1000000\n",
       "price                                                1047.3\n",
       "displayQty                                             None\n",
       "stopPx                                                 None\n",
       "pegOffsetValue                                         None\n",
       "pegPriceType                                               \n",
       "currency                                               USDT\n",
       "settlCurrency                                              \n",
       "ordType                                               Limit\n",
       "timeInForce                                  GoodTillCancel\n",
       "execInst                                                   \n",
       "contingencyType                                            \n",
       "exDestination                                          XBME\n",
       "ordStatus                                               New\n",
       "triggered                                                  \n",
       "workingIndicator                                       True\n",
       "ordRejReason                                               \n",
       "simpleLeavesQty                                        None\n",
       "leavesQty                                           1000000\n",
       "simpleCumQty                                           None\n",
       "cumQty                                                    0\n",
       "avgPx                                                  None\n",
       "multiLegReportingType                        SingleSecurity\n",
       "text                                     Submitted via API.\n",
       "transactTime                       2022-07-12T15:49:56.803Z\n",
       "timestamp                          2022-07-12T15:49:56.803Z"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = {'info': {'orderID': '2feea312-3458-4f9f-b659-8927d18c038e', 'clOrdID': '', 'clOrdLinkID': '', 'account': '403419', 'symbol': 'ETH_USDT', 'side': 'Buy', 'simpleOrderQty': None, 'orderQty': '1000000', 'price': '1047.3', 'displayQty': None, 'stopPx': None, 'pegOffsetValue': None, 'pegPriceType': '', 'currency': 'USDT', 'settlCurrency': '', 'ordType': 'Limit', 'timeInForce': 'GoodTillCancel', 'execInst': '', 'contingencyType': '', 'exDestination': 'XBME', 'ordStatus': 'New', 'triggered': '', 'workingIndicator': True, 'ordRejReason': '', 'simpleLeavesQty': None, 'leavesQty': '1000000', 'simpleCumQty': None, 'cumQty': '0', 'avgPx': None, 'multiLegReportingType': 'SingleSecurity', 'text': 'Submitted via API.', 'transactTime': '2022-07-12T15:49:56.803Z', 'timestamp': '2022-07-12T15:49:56.803Z'}, 'id': '2feea312-3458-4f9f-b659-8927d18c038e', 'clientOrderId': None, 'timestamp': 1657640996803, 'datetime': '2022-07-12T15:49:56.803Z', 'lastTradeTimestamp': 1657640996803, 'symbol': 'ETH_USDT', 'type': 'limit', 'timeInForce': 'GTC', 'postOnly': None, 'side': 'buy', 'price': 1047.3, 'stopPrice': None, 'amount': 1000000.0, 'cost': 0.0, 'average': None, 'filled': 0.0, 'remaining': 1000000.0, 'status': 'open', 'fee': None, 'trades': [], 'fees': []}\n",
    "# df = pd.DataFrame.from_dict(df)\n",
    "df = df['info']\n",
    "order_id = df['orderID']\n",
    "df = pd.DataFrame.from_dict(df, orient=\"index\")\n",
    "df = df.rename(columns={0: \"data\"})\n",
    "# df = pd.DataFrame(df)\n",
    "df\n",
    "# order_id\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "f0eb3656-9855-4cee-aebc-bdc878a695fb\n",
      "c996e494-fa6e-44fc-b2ac-7067fa0b64c8\n",
      "1b8b48ac-32fe-41eb-b072-23f04c50f386\n",
      "fadbc85e-cb89-4c76-bd71-885ca4489a1c\n",
      "79248a76-abef-44bd-bf2e-50c23bf12f39\n",
      "0fdddfe6-e74b-4478-aa07-84396688537e\n",
      "4848371d-7b0e-4b15-834b-22435400f45b\n",
      "10139265-76aa-404a-9c8d-5336548cc260\n",
      "c1e26101-28d5-4552-b19d-45c27719d434\n",
      "56d4daf1-e1df-43e6-aebd-cd7b36a8f52a\n",
      "56d14114-a3b4-4665-8ea4-934fbd01d745\n",
      "bd60027b-1436-4f98-ac5b-0ca168a355aa\n",
      "d71ed9c6-7139-4b73-bba9-9fae97eac097\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "id = pd.read_csv('file.csv')\n",
    "# id.head()\n",
    "\n",
    "'''iterate over the dataframe and print the order id'''\n",
    "for index, row in id.iterrows():\n",
    "    print(row['id'])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                                 info  \\\n",
      "0   {'orderID': '6a5e61d2-4732-4d03-9284-a15752507...   \n",
      "1   {'orderID': 'd3784d40-ac15-4c26-9844-68633e416...   \n",
      "2   {'orderID': '21b444f3-12c9-4c7d-9744-99545cb75...   \n",
      "3   {'orderID': 'b5e4adea-b30d-46e2-b066-53cbdcef3...   \n",
      "4   {'orderID': 'a863b129-c4a7-4315-b13d-08e656a05...   \n",
      "..                                                ...   \n",
      "95  {'orderID': '279add17-fbf3-486e-9a14-dc4371b8f...   \n",
      "96  {'orderID': '2c4bd695-0865-4524-8fe3-7c85de552...   \n",
      "97  {'orderID': 'f75e369e-f5f4-4695-93cc-8d9a9c7ad...   \n",
      "98  {'orderID': '8abdd6d7-fedd-48c1-a0dd-9ae245686...   \n",
      "99  {'orderID': 'bbe47193-2c9d-40ab-80a2-dd4e112b7...   \n",
      "\n",
      "                                      id clientOrderId      timestamp  \\\n",
      "0   6a5e61d2-4732-4d03-9284-a15752507945          None  1657103726437   \n",
      "1   d3784d40-ac15-4c26-9844-68633e416d94          None  1657103744617   \n",
      "2   21b444f3-12c9-4c7d-9744-99545cb75142          None  1657103755274   \n",
      "3   b5e4adea-b30d-46e2-b066-53cbdcef3ff7          None  1657103766381   \n",
      "4   a863b129-c4a7-4315-b13d-08e656a05a20          None  1657103801853   \n",
      "..                                   ...           ...            ...   \n",
      "95  279add17-fbf3-486e-9a14-dc4371b8faaf          None  1657556452940   \n",
      "96  2c4bd695-0865-4524-8fe3-7c85de552751          None  1657610512287   \n",
      "97  f75e369e-f5f4-4695-93cc-8d9a9c7add51          None  1657611971611   \n",
      "98  8abdd6d7-fedd-48c1-a0dd-9ae245686e7b          None  1657612046539   \n",
      "99  bbe47193-2c9d-40ab-80a2-dd4e112b7acc          None  1657612213470   \n",
      "\n",
      "                    datetime  lastTradeTimestamp         symbol    type  \\\n",
      "0   2022-07-06T10:35:26.437Z       1657103726437  BTC/USDT:USDT  market   \n",
      "1   2022-07-06T10:35:44.617Z       1657103744617  BTC/USDT:USDT  market   \n",
      "2   2022-07-06T10:35:55.274Z       1657103755274  BTC/USDT:USDT  market   \n",
      "3   2022-07-06T10:36:06.381Z       1657103766381  BTC/USDT:USDT  market   \n",
      "4   2022-07-06T10:36:41.853Z       1657103801853  BTC/USDT:USDT  market   \n",
      "..                       ...                 ...            ...     ...   \n",
      "95  2022-07-11T16:20:52.940Z       1657554352072    BTC/USD:BTC   limit   \n",
      "96  2022-07-12T07:21:52.287Z       1657610512287    BTC/USD:BTC  market   \n",
      "97  2022-07-12T07:46:11.611Z       1657611971611    BTC/USD:BTC  market   \n",
      "98  2022-07-12T07:47:26.539Z       1657612046539     ETHUSD_ETH  market   \n",
      "99  2022-07-12T07:50:13.470Z       1657612154389     ETHUSD_ETH   limit   \n",
      "\n",
      "   timeInForce postOnly  ... stopPrice   amount          cost   average  \\\n",
      "0          IOC     None  ...      None  50000.0  1.018926e+09  20378.52   \n",
      "1          IOC     None  ...      None  50000.0  1.020850e+09  20417.00   \n",
      "2          IOC     None  ...      None  50000.0  1.020850e+09  20417.00   \n",
      "3          IOC     None  ...      None  50000.0  1.023089e+09  20461.78   \n",
      "4          IOC     None  ...      None   5000.0  1.017000e+08  20340.00   \n",
      "..         ...      ...  ...       ...      ...           ...       ...   \n",
      "95         GTC     None  ...      None   1000.0  4.066600e+06  20333.00   \n",
      "96         IOC     None  ...      None    100.0  1.965650e+06  19656.50   \n",
      "97         IOC    False  ...      None    100.0  1.969700e+06  19697.00   \n",
      "98         IOC     None  ...      None      1.0  1.700000e+03   1700.00   \n",
      "99         GTC     None  ...      None      1.0  1.500050e+03   1500.05   \n",
      "\n",
      "     filled  remaining    status   fee trades fees  \n",
      "0   50000.0        0.0    closed  None     []   []  \n",
      "1   50000.0        0.0    closed  None     []   []  \n",
      "2   50000.0        0.0    closed  None     []   []  \n",
      "3   50000.0        0.0    closed  None     []   []  \n",
      "4    5000.0        0.0    closed  None     []   []  \n",
      "..      ...        ...       ...   ...    ...  ...  \n",
      "95    200.0      800.0  canceled  None     []   []  \n",
      "96    100.0        0.0    closed  None     []   []  \n",
      "97    100.0        0.0    closed  None     []   []  \n",
      "98      1.0        0.0    closed  None     []   []  \n",
      "99      1.0        0.0    closed  None     []   []  \n",
      "\n",
      "[100 rows x 22 columns]\n"
     ]
    }
   ],
   "source": [
    "import ccxt\n",
    "# import streamlit as st\n",
    "import pandas as pd\n",
    "from itertools import accumulate\n",
    "import plotly.graph_objects as go\n",
    "from plotly.subplots import make_subplots\n",
    "from itertools import chain\n",
    "import numpy as np\n",
    "import plotly.express as px\n",
    "from datetime import datetime, timedelta\n",
    "exchange = ccxt.bitmex({\n",
    "    'apiKey': 'NOAb2TuyuLgWkYbXOQGH-x9b',\n",
    "    'secret': '_fAxf57mItdpX-A5KTxXRzJZY3zkeSKdCGlStwa95FAH81Gd',\n",
    "})\n",
    "if 'test' in exchange.urls:\n",
    "    exchange.urls['api'] = exchange.urls['test'] # ←----- switch the base URL to testnet\n",
    "    x =pd.DataFrame()\n",
    "x = exchange.fetchOrders()\n",
    "x = pd.DataFrame(x)\n",
    "print(x)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'order': {'salt': 1, 'makerAsset': '0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270', 'makingAmount': '9000000000000000000', 'takerAsset': '0x172370d5cd63279efa6d502dab29171933a610af', 'maker': '0x94Bc2a1C732BcAd7343B25af48385Fe76E08734f', 'takingAmount': '111000000000000000000', 'makerAssetData': '0x0', 'takerAssetData': '0x0', 'getMakerAmount': '0xf4a215c30000000000000000000000000000000000000000000000007ce66c50e2840000000000000000000000000000000000000000000000000006046f37e5945c0000', 'getTakerAmount': '0x296637bf0000000000000000000000000000000000000000000000007ce66c50e2840000000000000000000000000000000000000000000000000006046f37e5945c0000', 'predicate': '0x0', 'permit': '0x0', 'interaction': '0x0'}, 'signature': '0x143b7088f811a068e6f495a2ef9c3092eef2218244fe3420c126d5370e8ff49b251eb02c9a77797ef93799d1bf2512bf9bdcb75ced55b358b2c834ffa0975dea1c', 'makingAmount': 1000, 'takingAmount': 0, 'thresholdAmount': 100}\n"
     ]
    }
   ],
   "source": [
    "# to fill 1inch limit order\n",
    "\n",
    "false = False\n",
    "fill_data = [\n",
    "{\n",
    "  \"signature\": \"0x143b7088f811a068e6f495a2ef9c3092eef2218244fe3420c126d5370e8ff49b251eb02c9a77797ef93799d1bf2512bf9bdcb75ced55b358b2c834ffa0975dea1c\",\n",
    "  \"orderHash\": \"0x0b98456f2e212f73b7a3ee3510499902dc8c7836bfb841d673dbd390dfbe8f7d\",\n",
    "  \"createDateTime\": \"2022-04-27T00:03:20.468Z\",\n",
    "  \"remainingMakerAmount\": \"9000000000000000000\",\n",
    "  \"makerBalance\": \"17300000000000000000\",\n",
    "  \"makerAllowance\": \"115792089237316195423570985008687907853269984665640564039457584007913129639935\",\n",
    "  \"data\": {\n",
    "    \"makerAsset\": \"0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270\",\n",
    "    \"takerAsset\": \"0x172370d5cd63279efa6d502dab29171933a610af\",\n",
    "    \"getMakerAmount\": \"0xf4a215c30000000000000000000000000000000000000000000000007ce66c50e2840000000000000000000000000000000000000000000000000006046f37e5945c0000\",\n",
    "    \"getTakerAmount\": \"0x296637bf0000000000000000000000000000000000000000000000007ce66c50e2840000000000000000000000000000000000000000000000000006046f37e5945c0000\",\n",
    "    \"makerAssetData\": \"0x\",\n",
    "    \"takerAssetData\": \"0x\",\n",
    "    \"salt\": \"57113605008\",\n",
    "    \"permit\": \"0x\",\n",
    "    \"predicate\": \"0x961d5b1e000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000000000000000000000000000000000000000000200000000000000000000000094bc2a1c732bcad7343b25af48385fe76e08734f00000000000000000000000094bc2a1c732bcad7343b25af48385fe76e08734f0000000000000000000000000000000000000000000000000000000000000002000000000000000000000000000000000000000000000000000000000000004000000000000000000000000000000000000000000000000000000000000000c00000000000000000000000000000000000000000000000000000000000000044cf6fc6e30000000000000000000000009ef3cef330ebc8dd510d9a9ec54de2f51699a694000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000002463592c2b0000000000000000000000000000000000000000000000000000000067f85c3a00000000000000000000000000000000000000000000000000000000\",\n",
    "    \"interaction\": \"0x\",\n",
    "    \"receiver\": \"0x0000000000000000000000000000000000000000\",\n",
    "    \"allowedSender\": \"0x0000000000000000000000000000000000000000\",\n",
    "    \"makingAmount\": \"9000000000000000000\",\n",
    "    \"takingAmount\": \"111000000000000000000\",\n",
    "    \"maker\": \"0x9ef3cef330ebc8dd510d9a9ec54de2f51699a694\"\n",
    "  },\n",
    "  \"makerRate\": \"12.333333333333333333\",\n",
    "  \"takerRate\": \"0.081081081081081081\",\n",
    "  \"isMakerContract\": false\n",
    "}\n",
    "]\n",
    "\n",
    "salt = fill_data[0]['data']['salt']\n",
    "makerAsset = fill_data[0]['data']['makerAsset']\n",
    "takerAsset = fill_data[0]['data']['takerAsset']\n",
    "getMakerAmount = fill_data[0]['data']['getMakerAmount']\n",
    "getTakerAmount = fill_data[0]['data']['getTakerAmount']\n",
    "makingAmount = fill_data[0]['data']['makingAmount']\n",
    "takingAmount = fill_data[0]['data']['takingAmount']\n",
    "predicate = fill_data[0]['data']['predicate']\n",
    "permit = '0x'\n",
    "\n",
    "interaction = '0x'\n",
    "addy_poly = '0x94Bc2a1C732BcAd7343B25af48385Fe76E08734f'\n",
    "signature = fill_data[0]['signature']\n",
    "predicate = fill_data[0]['data']['predicate']\n",
    "maker = fill_data[0]['data']['maker']\n",
    "receiver = fill_data[0]['data']['receiver']\n",
    "allowedSender = fill_data[0]['data']['allowedSender']\n",
    "\n",
    "\n",
    "# print(getTakerAmount)\n",
    "signature = fill_data[0]['signature']\n",
    "takingAmount_out = 0\n",
    "thresholdAmount = 1000000\n",
    "\n",
    "\n",
    "to_send = {\n",
    "  \"order\": {\n",
    "    # \"allowedSender\": \"0x0000000000000000000000000000000000000000\",\n",
    "    # \"getMakerAmount\": getMakerAmount,\n",
    "    # #  \"0xf4a215c300000000000000000000000000000000000000000000000000000000000f42400000000000000000000000000000000000000000000000000186cc6acd4b0000\",\n",
    "    # \"getTakerAmount\": getTakerAmount,\n",
    "    # # \"0x296637bf00000000000000000000000000000000000000000000000000000000000f42400000000000000000000000000000000000000000000000000186cc6acd4b0000\",\n",
    "    # \"maker\": maker,\n",
    "    #   #  \"0x40f2977836b416d1eb423a7a2f3a9892b69cc40f\",\n",
    "    # \"makerAsset\": makerAsset,\n",
    "    # #  \"0x2791bca1f2de4661ed88a30c99a7a9449aa84174\",\n",
    "\n",
    "    # \"receiver\": receiver,\n",
    "    # \"0x19b0324344781a974051ea2b2e7cc0e17e79e258\",\n",
    "    \"salt\": 1,\n",
    "    \"makerAsset\": makerAsset,\n",
    "    #  \"0x2791bca1f2de4661ed88a30c99a7a9449aa84174\",\n",
    "    \"makingAmount\": makingAmount,\n",
    "      # \"869885392730\",\n",
    "    \"takerAsset\": takerAsset,\n",
    "    #  \"0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270\",\n",
    "    \"maker\": '0x94Bc2a1C732BcAd7343B25af48385Fe76E08734f',\n",
    "      #  \"0x40f2977836b416d1eb423a7a2f3a9892b69cc40f\",\n",
    "    \"makingAmount\": makingAmount,\n",
    "    # \"1000000\",\n",
    "    \"takingAmount\": takingAmount,\n",
    "    \"makerAssetData\": \"0x0\",\n",
    "    \"takerAssetData\": \"0x0\",\n",
    "    \"getMakerAmount\": getMakerAmount,\n",
    "    \"getTakerAmount\": getTakerAmount,\n",
    "    \"predicate\": '0x0',\n",
    "    \"permit\": '0x0',\n",
    "    \"interaction\": '0x0' \n",
    "\n",
    "    # \"110000000000000000\"\n",
    "  },\n",
    "  \"signature\": signature,\n",
    "  \"makingAmount\": 1000,\n",
    "  \"takingAmount\": 0,\n",
    "  \"thresholdAmount\": 100,\n",
    "  #  \"120000000000000000\"\n",
    "}\n",
    "to_send = to_send\n",
    "print(to_send)\n",
    "# print(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [],
   "source": [
    "# data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'order': {'salt': 1,\n",
       "  'makerAsset': '0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270',\n",
       "  'makingAmount': '9000000000000000000',\n",
       "  'takerAsset': '0x172370d5cd63279efa6d502dab29171933a610af',\n",
       "  'maker': '0x94Bc2a1C732BcAd7343B25af48385Fe76E08734f',\n",
       "  'takingAmount': '111000000000000000000',\n",
       "  'makerAssetData': '0x0',\n",
       "  'takerAssetData': '0x0',\n",
       "  'getMakerAmount': '0xf4a215c30000000000000000000000000000000000000000000000007ce66c50e2840000000000000000000000000000000000000000000000000006046f37e5945c0000',\n",
       "  'getTakerAmount': '0x296637bf0000000000000000000000000000000000000000000000007ce66c50e2840000000000000000000000000000000000000000000000000006046f37e5945c0000',\n",
       "  'predicate': '0x0',\n",
       "  'permit': '0x0',\n",
       "  'interaction': '0x0'},\n",
       " 'signature': '0x143b7088f811a068e6f495a2ef9c3092eef2218244fe3420c126d5370e8ff49b251eb02c9a77797ef93799d1bf2512bf9bdcb75ced55b358b2c834ffa0975dea1c',\n",
       " 'makingAmount': 1000,\n",
       " 'takingAmount': 0,\n",
       " 'thresholdAmount': 100}"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "to_send"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'domain' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32mc:\\Users\\massn\\21\\21\\test.ipynb Cell 29\u001b[0m in \u001b[0;36m<cell line: 122>\u001b[1;34m()\u001b[0m\n\u001b[0;32m    <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000026?line=117'>118</a>\u001b[0m chain_id \u001b[39m=\u001b[39m \u001b[39m137\u001b[39m\n\u001b[0;32m    <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000026?line=118'>119</a>\u001b[0m W3 \u001b[39m=\u001b[39m Web3Extension(config)\n\u001b[0;32m    <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000026?line=120'>121</a>\u001b[0m msg \u001b[39m=\u001b[39m { \u001b[39m\"\u001b[39m\u001b[39mtypes\u001b[39m\u001b[39m\"\u001b[39m: \n\u001b[0;32m    <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000026?line=121'>122</a>\u001b[0m { \u001b[39m\"\u001b[39m\u001b[39mEIP712Domain\u001b[39m\u001b[39m\"\u001b[39m: [], \u001b[39m\"\u001b[39m\u001b[39mType\u001b[39m\u001b[39m\"\u001b[39m:  []},\n\u001b[1;32m--> <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000026?line=122'>123</a>\u001b[0m     \u001b[39m\"\u001b[39m\u001b[39mdomain\u001b[39m\u001b[39m\"\u001b[39m:domain,\n\u001b[0;32m    <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000026?line=123'>124</a>\u001b[0m     \u001b[39m\"\u001b[39m\u001b[39mprimaryType\u001b[39m\u001b[39m\"\u001b[39m: \u001b[39m'\u001b[39m\u001b[39mType\u001b[39m\u001b[39m'\u001b[39m,\n\u001b[0;32m    <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000026?line=124'>125</a>\u001b[0m       \u001b[39m\"\u001b[39m\u001b[39mmessage\u001b[39m\u001b[39m\"\u001b[39m:message }\n\u001b[0;32m    <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000026?line=127'>128</a>\u001b[0m encoded_data\u001b[39m=\u001b[39mencode_structured_data(msg)\n\u001b[0;32m    <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000026?line=129'>130</a>\u001b[0m web3\u001b[39m.\u001b[39meth\u001b[39m.\u001b[39maccount\u001b[39m.\u001b[39msign_message(encoded_data,privateKey)\n",
      "\u001b[1;31mNameError\u001b[0m: name 'domain' is not defined"
     ]
    }
   ],
   "source": [
    "\n",
    "\n",
    "import json\n",
    "import requests\n",
    "import logging\n",
    "from web3 import Web3\n",
    "from web3.exceptions import TransactionNotFound\n",
    "from hexbytes import HexBytes\n",
    "from cryptography.fernet import Fernet\n",
    "import requests\n",
    "import json\n",
    "import streamlit as st\n",
    "TIMEOUT = 120\n",
    "POLL_LATENCY = 0.2\n",
    "\n",
    "\n",
    "leg2 = {\n",
    "    \"user_address\": \"\",\n",
    "    \"private_key\": \"\",\n",
    "    \"endpoint\": \"https://rpc-mainnet.matic.quiknode.pro\",\n",
    "}\n",
    "\n",
    "tx_data_to = addy_poly\n",
    "tx_data_data = to_send\n",
    "config = leg2\n",
    "tx_data_gas = 210000\n",
    "tx_data_gasPrice = 40000000000\n",
    "tx_data_value = '0x0'\n",
    "\n",
    "import logging\n",
    "\n",
    "from hexbytes import HexBytes\n",
    "from web3 import Web3\n",
    "from web3.exceptions import TransactionNotFound\n",
    "\n",
    "\n",
    "class Web3Extension:\n",
    "    def __init__(self, config):\n",
    "        self.web3 = Web3(Web3.HTTPProvider(config.get(\"endpoint\")))\n",
    "        self.user_address = self.checksum(config.get(\"user_address\", None))\n",
    "        self.private_key = config.get(\"private_key\", None)\n",
    "\n",
    "    def checksum(self, address):\n",
    "        if not address:\n",
    "            logging.debug(\"Address is None, skipping checksum.\")\n",
    "            return None\n",
    "        if self.web3.isAddress(address):\n",
    "            return self.web3.toChecksumAddress(address)\n",
    "        return address\n",
    "\n",
    "    def to_wei(self, val):\n",
    "        return int(self.web3.toWei(val, \"ether\"))\n",
    "\n",
    "    def from_wei(self, val):\n",
    "        return float(self.web3.fromWei(val, \"ether\"))\n",
    "\n",
    "    def get_provider_uri(self):\n",
    "        return self.web3.provider.endpoint_uri\n",
    "\n",
    "    def get_block(self, identifier):\n",
    "        return self.web3.eth.get_block(identifier)\n",
    "\n",
    "    def get_block_time(self, identifier):\n",
    "        return self.web3.eth.get_block(identifier).timestamp\n",
    "\n",
    "    def get_latest_block(self):\n",
    "        return self.web3.eth.get_block(\"latest\")\n",
    "\n",
    "    def get_address_nonce(self):\n",
    "        assert self.user_address is not None, \"User address not initialized.\"\n",
    "        return self.web3.eth.get_transaction_count(self.user_address)\n",
    "\n",
    "    def get_transaction(self, tx_hash):\n",
    "        return self.web3.eth.get_transaction(tx_hash)\n",
    "\n",
    "    def _sign_transaction(self, transaction, private_key):\n",
    "        return self.web3.eth.account.sign_transaction(transaction, private_key)\n",
    "\n",
    "    def _send_raw_transaction(self, signed_tx):\n",
    "        raw_tx_hash = self.web3.eth.send_raw_transaction(signed_tx.rawTransaction)\n",
    "        return self.web3.toHex(raw_tx_hash)  # tx_hash in hexa\n",
    "\n",
    "    def build_transaction(self, to, value, gas, gas_price, chain_id, data=None):\n",
    "        assert self.user_address is not None, \"User address not initialized.\"\n",
    "        tx = {\n",
    "            \"from\": self.checksum(self.user_address),\n",
    "            \"nonce\": self.get_address_nonce(),\n",
    "            \"to\": self.checksum(to),\n",
    "            \"value\": value,\n",
    "            \"gas\": gas,\n",
    "            \"gasPrice\": gas_price,\n",
    "            \"chainId\": chain_id,\n",
    "        }\n",
    "        if data is not None:\n",
    "            tx.update({\"data\": data})\n",
    "        return tx\n",
    "\n",
    "    def sign_and_send(self, transaction):\n",
    "        assert self.private_key is not None, \"Private key unavailable.\"\n",
    "        signed_tx = self._sign_transaction(transaction, self.private_key)\n",
    "        return self._send_raw_transaction(signed_tx)\n",
    "\n",
    "    def get_transaction_receipt(\n",
    "        self, tx_hash, wait=False, timeout=120, poll_latency=0.2\n",
    "    ):\n",
    "        try:\n",
    "            if wait:\n",
    "                return self.web3.eth.wait_for_transaction_receipt(\n",
    "                    tx_hash, timeout, poll_latency\n",
    "                )\n",
    "            return self.web3.eth.get_transaction_receipt(tx_hash)\n",
    "        except TransactionNotFound:\n",
    "            return {\n",
    "                \"transactionHash\": HexBytes(tx_hash),\n",
    "                \"blockNumber\": -1,\n",
    "                \"status\": -1,\n",
    "            }\n",
    "\n",
    "\n",
    "chain_id = 137\n",
    "W3 = Web3Extension(config)\n",
    "\n",
    "# msg = { \"types\": \n",
    "# { \"EIP712Domain\": [], \"Type\":  []},\n",
    "# \"domain\":domain,\n",
    "# \"primaryType\": 'Type',\n",
    "# \"message\":message }\n",
    "\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'Web3Extension' object has no attribute 'eth'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[1;32mc:\\Users\\massn\\21\\21\\test.ipynb Cell 30\u001b[0m in \u001b[0;36m<cell line: 4>\u001b[1;34m()\u001b[0m\n\u001b[0;32m      <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000031?line=1'>2</a>\u001b[0m \u001b[39mfrom\u001b[39;00m \u001b[39meth_utils\u001b[39;00m\u001b[39m.\u001b[39;00m\u001b[39mcurried\u001b[39;00m \u001b[39mimport\u001b[39;00m to_hex, to_bytes\n\u001b[0;32m      <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000031?line=2'>3</a>\u001b[0m \u001b[39m# message = encode_structured_data(primitive=data)\u001b[39;00m\n\u001b[1;32m----> <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000031?line=3'>4</a>\u001b[0m recovered \u001b[39m=\u001b[39m W3\u001b[39m.\u001b[39;49meth\u001b[39m.\u001b[39maccount\u001b[39m.\u001b[39mrecover_message(message, signature\u001b[39m=\u001b[39msignature)\n",
      "\u001b[1;31mAttributeError\u001b[0m: 'Web3Extension' object has no attribute 'eth'"
     ]
    }
   ],
   "source": [
    "from eth_account.messages import encode_defunct\n",
    "from eth_utils.curried import to_hex, to_bytes\n",
    "# message = encode_structured_data(primitive=data)\n",
    "recovered = W3.account.recover_message(message, signature=signature)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "tx = W3.build_transaction(to=tx_data_to, value=tx_data_value, gas=tx_data_gas, gas_price=tx_data_gasPrice, data=tx_data_data, chain_id=chain_id)\n",
    "print(tx)\n",
    "resp = W3.sign_and_send(transaction=tx)\n",
    "print(resp)\n",
    "result = W3.get_transaction(tx_hash=resp)\n",
    "print(result)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "'Hello World!'\n"
     ]
    }
   ],
   "source": [
    "# !pip install Js2Py\n",
    "import js2py\n",
    "js2py.eval_js('console.log( \"Hello World!\" )')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'domain' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32mc:\\Users\\massn\\21\\21\\test.ipynb Cell 33\u001b[0m in \u001b[0;36m<cell line: 3>\u001b[1;34m()\u001b[0m\n\u001b[0;32m      <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000032?line=0'>1</a>\u001b[0m data \u001b[39m=\u001b[39m {\n\u001b[0;32m      <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000032?line=1'>2</a>\u001b[0m             \u001b[39m\"\u001b[39m\u001b[39mtypes\u001b[39m\u001b[39m\"\u001b[39m: {\n\u001b[1;32m----> <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000032?line=2'>3</a>\u001b[0m                 \u001b[39m\"\u001b[39m\u001b[39mEIP712Domain\u001b[39m\u001b[39m\"\u001b[39m: domain,\n\u001b[0;32m      <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000032?line=3'>4</a>\u001b[0m                 \u001b[39m\"\u001b[39m\u001b[39mPermit\u001b[39m\u001b[39m\"\u001b[39m: permit\n\u001b[0;32m      <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000032?line=4'>5</a>\u001b[0m             },\n\u001b[0;32m      <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000032?line=5'>6</a>\u001b[0m             \u001b[39m\"\u001b[39m\u001b[39mdomain\u001b[39m\u001b[39m\"\u001b[39m: domainData,\n\u001b[0;32m      <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000032?line=6'>7</a>\u001b[0m             \u001b[39m\"\u001b[39m\u001b[39mprimaryType\u001b[39m\u001b[39m\"\u001b[39m: \u001b[39m\"\u001b[39m\u001b[39mPermit\u001b[39m\u001b[39m\"\u001b[39m,\n\u001b[0;32m      <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000032?line=7'>8</a>\u001b[0m             \u001b[39m\"\u001b[39m\u001b[39mmessage\u001b[39m\u001b[39m\"\u001b[39m: message\n\u001b[0;32m      <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000032?line=8'>9</a>\u001b[0m         }\n\u001b[0;32m     <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000032?line=10'>11</a>\u001b[0m encoded_data \u001b[39m=\u001b[39m encode_structured_data(data)\n\u001b[0;32m     <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000032?line=11'>12</a>\u001b[0m signature \u001b[39m=\u001b[39m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mweb3\u001b[39m.\u001b[39meth\u001b[39m.\u001b[39msignTypedData(\u001b[39mself\u001b[39m\u001b[39m.\u001b[39mweb3\u001b[39m.\u001b[39meth\u001b[39m.\u001b[39mdefaultAccount, encoded_data)\n",
      "\u001b[1;31mNameError\u001b[0m: name 'domain' is not defined"
     ]
    }
   ],
   "source": [
    "data = {\n",
    "            \"types\": {\n",
    "                \"EIP712Domain\": domain,\n",
    "                \"Permit\": permit\n",
    "            },\n",
    "            \"domain\": domainData,\n",
    "            \"primaryType\": \"Permit\",\n",
    "            \"message\": message\n",
    "        }\n",
    "\n",
    "encoded_data = encode_structured_data(data)\n",
    "signature = self.web3.eth.signTypedData(self.web3.eth.defaultAccount, encoded_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "Object of type bytes is not JSON serializable",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[1;32mc:\\Users\\massn\\21\\21\\test.ipynb Cell 34\u001b[0m in \u001b[0;36m<cell line: 104>\u001b[1;34m()\u001b[0m\n\u001b[0;32m     <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000033?line=83'>84</a>\u001b[0m     \u001b[39mreturn\u001b[39;00m fixed_data\n\u001b[0;32m     <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000033?line=84'>85</a>\u001b[0m eip712_data \u001b[39m=\u001b[39m {\n\u001b[0;32m     <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000033?line=85'>86</a>\u001b[0m     \u001b[39m\"\u001b[39m\u001b[39mprimaryType\u001b[39m\u001b[39m\"\u001b[39m: \u001b[39m\"\u001b[39m\u001b[39mOrder\u001b[39m\u001b[39m\"\u001b[39m,\n\u001b[0;32m     <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000033?line=86'>87</a>\u001b[0m     \u001b[39m\"\u001b[39m\u001b[39mtypes\u001b[39m\u001b[39m\"\u001b[39m: {\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m    <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000033?line=101'>102</a>\u001b[0m     \u001b[39m\"\u001b[39m\u001b[39mmessage\u001b[39m\u001b[39m\"\u001b[39m: fix_data_types(order_data, order_types),\n\u001b[0;32m    <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000033?line=102'>103</a>\u001b[0m }\n\u001b[1;32m--> <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000033?line=103'>104</a>\u001b[0m encoded_message \u001b[39m=\u001b[39m encode_structured_data(eip712_data)\n\u001b[0;32m    <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000033?line=104'>105</a>\u001b[0m signed_message \u001b[39m=\u001b[39m w3\u001b[39m.\u001b[39meth\u001b[39m.\u001b[39maccount\u001b[39m.\u001b[39msign_message(encoded_message, wallet_key)\n\u001b[0;32m    <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000033?line=105'>106</a>\u001b[0m limit_order \u001b[39m=\u001b[39m {\n\u001b[0;32m    <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000033?line=106'>107</a>\u001b[0m     \u001b[39m\"\u001b[39m\u001b[39morderHash\u001b[39m\u001b[39m\"\u001b[39m: signed_message\u001b[39m.\u001b[39mmessageHash\u001b[39m.\u001b[39mhex(),\n\u001b[0;32m    <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000033?line=107'>108</a>\u001b[0m     \u001b[39m\"\u001b[39m\u001b[39msignature\u001b[39m\u001b[39m\"\u001b[39m: signed_message\u001b[39m.\u001b[39msignature\u001b[39m.\u001b[39mhex(),\n\u001b[0;32m    <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000033?line=108'>109</a>\u001b[0m     \u001b[39m\"\u001b[39m\u001b[39mdata\u001b[39m\u001b[39m\"\u001b[39m: order_data,\n\u001b[0;32m    <a href='vscode-notebook-cell:/c%3A/Users/massn/21/21/test.ipynb#ch0000033?line=109'>110</a>\u001b[0m }\n",
      "File \u001b[1;32mc:\\Users\\massn\\.virtualenvs\\eAEDQwed\\lib\\site-packages\\eth_account\\messages.py:146\u001b[0m, in \u001b[0;36mencode_structured_data\u001b[1;34m(primitive, hexstr, text)\u001b[0m\n\u001b[0;32m    121\u001b[0m \u001b[39m\"\"\"\u001b[39;00m\n\u001b[0;32m    122\u001b[0m \u001b[39mEncode an EIP-712_ message.\u001b[39;00m\n\u001b[0;32m    123\u001b[0m \n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m    143\u001b[0m \u001b[39m.. _EIP-712: https://eips.ethereum.org/EIPS/eip-712\u001b[39;00m\n\u001b[0;32m    144\u001b[0m \u001b[39m\"\"\"\u001b[39;00m\n\u001b[0;32m    145\u001b[0m \u001b[39mif\u001b[39;00m \u001b[39misinstance\u001b[39m(primitive, Mapping):\n\u001b[1;32m--> 146\u001b[0m     message_string \u001b[39m=\u001b[39m json\u001b[39m.\u001b[39;49mdumps(primitive)\n\u001b[0;32m    147\u001b[0m \u001b[39melse\u001b[39;00m:\n\u001b[0;32m    148\u001b[0m     message_string \u001b[39m=\u001b[39m to_text(primitive, hexstr\u001b[39m=\u001b[39mhexstr, text\u001b[39m=\u001b[39mtext)\n",
      "File \u001b[1;32m~\\AppData\\Local\\Programs\\Python\\Python39\\lib\\json\\__init__.py:231\u001b[0m, in \u001b[0;36mdumps\u001b[1;34m(obj, skipkeys, ensure_ascii, check_circular, allow_nan, cls, indent, separators, default, sort_keys, **kw)\u001b[0m\n\u001b[0;32m    226\u001b[0m \u001b[39m# cached encoder\u001b[39;00m\n\u001b[0;32m    227\u001b[0m \u001b[39mif\u001b[39;00m (\u001b[39mnot\u001b[39;00m skipkeys \u001b[39mand\u001b[39;00m ensure_ascii \u001b[39mand\u001b[39;00m\n\u001b[0;32m    228\u001b[0m     check_circular \u001b[39mand\u001b[39;00m allow_nan \u001b[39mand\u001b[39;00m\n\u001b[0;32m    229\u001b[0m     \u001b[39mcls\u001b[39m \u001b[39mis\u001b[39;00m \u001b[39mNone\u001b[39;00m \u001b[39mand\u001b[39;00m indent \u001b[39mis\u001b[39;00m \u001b[39mNone\u001b[39;00m \u001b[39mand\u001b[39;00m separators \u001b[39mis\u001b[39;00m \u001b[39mNone\u001b[39;00m \u001b[39mand\u001b[39;00m\n\u001b[0;32m    230\u001b[0m     default \u001b[39mis\u001b[39;00m \u001b[39mNone\u001b[39;00m \u001b[39mand\u001b[39;00m \u001b[39mnot\u001b[39;00m sort_keys \u001b[39mand\u001b[39;00m \u001b[39mnot\u001b[39;00m kw):\n\u001b[1;32m--> 231\u001b[0m     \u001b[39mreturn\u001b[39;00m _default_encoder\u001b[39m.\u001b[39;49mencode(obj)\n\u001b[0;32m    232\u001b[0m \u001b[39mif\u001b[39;00m \u001b[39mcls\u001b[39m \u001b[39mis\u001b[39;00m \u001b[39mNone\u001b[39;00m:\n\u001b[0;32m    233\u001b[0m     \u001b[39mcls\u001b[39m \u001b[39m=\u001b[39m JSONEncoder\n",
      "File \u001b[1;32m~\\AppData\\Local\\Programs\\Python\\Python39\\lib\\json\\encoder.py:199\u001b[0m, in \u001b[0;36mJSONEncoder.encode\u001b[1;34m(self, o)\u001b[0m\n\u001b[0;32m    195\u001b[0m         \u001b[39mreturn\u001b[39;00m encode_basestring(o)\n\u001b[0;32m    196\u001b[0m \u001b[39m# This doesn't pass the iterator directly to ''.join() because the\u001b[39;00m\n\u001b[0;32m    197\u001b[0m \u001b[39m# exceptions aren't as detailed.  The list call should be roughly\u001b[39;00m\n\u001b[0;32m    198\u001b[0m \u001b[39m# equivalent to the PySequence_Fast that ''.join() would do.\u001b[39;00m\n\u001b[1;32m--> 199\u001b[0m chunks \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49miterencode(o, _one_shot\u001b[39m=\u001b[39;49m\u001b[39mTrue\u001b[39;49;00m)\n\u001b[0;32m    200\u001b[0m \u001b[39mif\u001b[39;00m \u001b[39mnot\u001b[39;00m \u001b[39misinstance\u001b[39m(chunks, (\u001b[39mlist\u001b[39m, \u001b[39mtuple\u001b[39m)):\n\u001b[0;32m    201\u001b[0m     chunks \u001b[39m=\u001b[39m \u001b[39mlist\u001b[39m(chunks)\n",
      "File \u001b[1;32m~\\AppData\\Local\\Programs\\Python\\Python39\\lib\\json\\encoder.py:257\u001b[0m, in \u001b[0;36mJSONEncoder.iterencode\u001b[1;34m(self, o, _one_shot)\u001b[0m\n\u001b[0;32m    252\u001b[0m \u001b[39melse\u001b[39;00m:\n\u001b[0;32m    253\u001b[0m     _iterencode \u001b[39m=\u001b[39m _make_iterencode(\n\u001b[0;32m    254\u001b[0m         markers, \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mdefault, _encoder, \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mindent, floatstr,\n\u001b[0;32m    255\u001b[0m         \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mkey_separator, \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mitem_separator, \u001b[39mself\u001b[39m\u001b[39m.\u001b[39msort_keys,\n\u001b[0;32m    256\u001b[0m         \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mskipkeys, _one_shot)\n\u001b[1;32m--> 257\u001b[0m \u001b[39mreturn\u001b[39;00m _iterencode(o, \u001b[39m0\u001b[39;49m)\n",
      "File \u001b[1;32m~\\AppData\\Local\\Programs\\Python\\Python39\\lib\\json\\encoder.py:179\u001b[0m, in \u001b[0;36mJSONEncoder.default\u001b[1;34m(self, o)\u001b[0m\n\u001b[0;32m    160\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39mdefault\u001b[39m(\u001b[39mself\u001b[39m, o):\n\u001b[0;32m    161\u001b[0m     \u001b[39m\"\"\"Implement this method in a subclass such that it returns\u001b[39;00m\n\u001b[0;32m    162\u001b[0m \u001b[39m    a serializable object for ``o``, or calls the base implementation\u001b[39;00m\n\u001b[0;32m    163\u001b[0m \u001b[39m    (to raise a ``TypeError``).\u001b[39;00m\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m    177\u001b[0m \n\u001b[0;32m    178\u001b[0m \u001b[39m    \"\"\"\u001b[39;00m\n\u001b[1;32m--> 179\u001b[0m     \u001b[39mraise\u001b[39;00m \u001b[39mTypeError\u001b[39;00m(\u001b[39mf\u001b[39m\u001b[39m'\u001b[39m\u001b[39mObject of type \u001b[39m\u001b[39m{\u001b[39;00mo\u001b[39m.\u001b[39m\u001b[39m__class__\u001b[39m\u001b[39m.\u001b[39m\u001b[39m__name__\u001b[39m\u001b[39m}\u001b[39;00m\u001b[39m \u001b[39m\u001b[39m'\u001b[39m\n\u001b[0;32m    180\u001b[0m                     \u001b[39mf\u001b[39m\u001b[39m'\u001b[39m\u001b[39mis not JSON serializable\u001b[39m\u001b[39m'\u001b[39m)\n",
      "\u001b[1;31mTypeError\u001b[0m: Object of type bytes is not JSON serializable"
     ]
    }
   ],
   "source": [
    "from eth_account.messages import encode_structured_data\n",
    "from web3 import Web3\n",
    "import requests\n",
    "w3 = Web3(Web3.HTTPProvider(\"https://cloudflare-eth.com\"))  \n",
    "wallet_key = \"3f3011407279d6f3cc65fe02885048c1024ddc84d48e3df737bbe5a215521634\"\n",
    "\n",
    "# lets build the predicate\n",
    "contract_abi = [{\"anonymous\":\"false\",\"inputs\":[{\"indexed\":\"true\",\"internalType\":\"address\",\"name\":\"maker\",\"type\":\"address\"},{\"indexed\":\"false\",\"internalType\":\"uint256\",\"name\":\"newNonce\",\"type\":\"uint256\"}],\"name\":\"NonceIncreased\",\"type\":\"event\"},{\"anonymous\":\"false\",\"inputs\":[{\"indexed\":\"true\",\"internalType\":\"address\",\"name\":\"maker\",\"type\":\"address\"},{\"indexed\":\"false\",\"internalType\":\"bytes32\",\"name\":\"orderHash\",\"type\":\"bytes32\"},{\"indexed\":\"false\",\"internalType\":\"uint256\",\"name\":\"remainingRaw\",\"type\":\"uint256\"}],\"name\":\"OrderCanceled\",\"type\":\"event\"},{\"anonymous\":\"false\",\"inputs\":[{\"indexed\":\"true\",\"internalType\":\"address\",\"name\":\"maker\",\"type\":\"address\"},{\"indexed\":\"false\",\"internalType\":\"bytes32\",\"name\":\"orderHash\",\"type\":\"bytes32\"},{\"indexed\":\"false\",\"internalType\":\"uint256\",\"name\":\"remaining\",\"type\":\"uint256\"}],\"name\":\"OrderFilled\",\"type\":\"event\"},{\"anonymous\":\"false\",\"inputs\":[{\"indexed\":\"false\",\"internalType\":\"bytes32\",\"name\":\"orderHash\",\"type\":\"bytes32\"},{\"indexed\":\"false\",\"internalType\":\"uint256\",\"name\":\"makingAmount\",\"type\":\"uint256\"}],\"name\":\"OrderFilledRFQ\",\"type\":\"event\"},{\"inputs\":[],\"name\":\"DOMAIN_SEPARATOR\",\"outputs\":[{\"internalType\":\"bytes32\",\"name\":\"\",\"type\":\"bytes32\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[],\"name\":\"LIMIT_ORDER_RFQ_TYPEHASH\",\"outputs\":[{\"internalType\":\"bytes32\",\"name\":\"\",\"type\":\"bytes32\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[],\"name\":\"LIMIT_ORDER_TYPEHASH\",\"outputs\":[{\"internalType\":\"bytes32\",\"name\":\"\",\"type\":\"bytes32\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"uint8\",\"name\":\"amount\",\"type\":\"uint8\"}],\"name\":\"advanceNonce\",\"outputs\":[],\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"address[]\",\"name\":\"targets\",\"type\":\"address[]\"},{\"internalType\":\"bytes[]\",\"name\":\"data\",\"type\":\"bytes[]\"}],\"name\":\"and\",\"outputs\":[{\"internalType\":\"bool\",\"name\":\"\",\"type\":\"bool\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"address\",\"name\":\"target\",\"type\":\"address\"},{\"internalType\":\"bytes\",\"name\":\"data\",\"type\":\"bytes\"}],\"name\":\"arbitraryStaticCall\",\"outputs\":[{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[{\"components\":[{\"internalType\":\"uint256\",\"name\":\"salt\",\"type\":\"uint256\"},{\"internalType\":\"address\",\"name\":\"makerAsset\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"takerAsset\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"maker\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"receiver\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"allowedSender\",\"type\":\"address\"},{\"internalType\":\"uint256\",\"name\":\"makingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"takingAmount\",\"type\":\"uint256\"},{\"internalType\":\"bytes\",\"name\":\"makerAssetData\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"takerAssetData\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"getMakerAmount\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"getTakerAmount\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"predicate\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"permit\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"interaction\",\"type\":\"bytes\"}],\"internalType\":\"struct OrderMixin.Order\",\"name\":\"order\",\"type\":\"tuple\"}],\"name\":\"cancelOrder\",\"outputs\":[],\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"uint256\",\"name\":\"orderInfo\",\"type\":\"uint256\"}],\"name\":\"cancelOrderRFQ\",\"outputs\":[],\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"inputs\":[{\"components\":[{\"internalType\":\"uint256\",\"name\":\"salt\",\"type\":\"uint256\"},{\"internalType\":\"address\",\"name\":\"makerAsset\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"takerAsset\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"maker\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"receiver\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"allowedSender\",\"type\":\"address\"},{\"internalType\":\"uint256\",\"name\":\"makingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"takingAmount\",\"type\":\"uint256\"},{\"internalType\":\"bytes\",\"name\":\"makerAssetData\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"takerAssetData\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"getMakerAmount\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"getTakerAmount\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"predicate\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"permit\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"interaction\",\"type\":\"bytes\"}],\"internalType\":\"struct OrderMixin.Order\",\"name\":\"order\",\"type\":\"tuple\"}],\"name\":\"checkPredicate\",\"outputs\":[{\"internalType\":\"bool\",\"name\":\"\",\"type\":\"bool\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"contract AggregatorV3Interface\",\"name\":\"oracle1\",\"type\":\"address\"},{\"internalType\":\"contract AggregatorV3Interface\",\"name\":\"oracle2\",\"type\":\"address\"},{\"internalType\":\"uint256\",\"name\":\"spread\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"amount\",\"type\":\"uint256\"}],\"name\":\"doublePrice\",\"outputs\":[{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"uint256\",\"name\":\"value\",\"type\":\"uint256\"},{\"internalType\":\"address\",\"name\":\"target\",\"type\":\"address\"},{\"internalType\":\"bytes\",\"name\":\"data\",\"type\":\"bytes\"}],\"name\":\"eq\",\"outputs\":[{\"internalType\":\"bool\",\"name\":\"\",\"type\":\"bool\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[{\"components\":[{\"internalType\":\"uint256\",\"name\":\"salt\",\"type\":\"uint256\"},{\"internalType\":\"address\",\"name\":\"makerAsset\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"takerAsset\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"maker\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"receiver\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"allowedSender\",\"type\":\"address\"},{\"internalType\":\"uint256\",\"name\":\"makingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"takingAmount\",\"type\":\"uint256\"},{\"internalType\":\"bytes\",\"name\":\"makerAssetData\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"takerAssetData\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"getMakerAmount\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"getTakerAmount\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"predicate\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"permit\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"interaction\",\"type\":\"bytes\"}],\"internalType\":\"struct OrderMixin.Order\",\"name\":\"order\",\"type\":\"tuple\"},{\"internalType\":\"bytes\",\"name\":\"signature\",\"type\":\"bytes\"},{\"internalType\":\"uint256\",\"name\":\"makingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"takingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"thresholdAmount\",\"type\":\"uint256\"}],\"name\":\"fillOrder\",\"outputs\":[{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"}],\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"inputs\":[{\"components\":[{\"internalType\":\"uint256\",\"name\":\"info\",\"type\":\"uint256\"},{\"internalType\":\"contract IERC20\",\"name\":\"makerAsset\",\"type\":\"address\"},{\"internalType\":\"contract IERC20\",\"name\":\"takerAsset\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"maker\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"allowedSender\",\"type\":\"address\"},{\"internalType\":\"uint256\",\"name\":\"makingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"takingAmount\",\"type\":\"uint256\"}],\"internalType\":\"struct OrderRFQMixin.OrderRFQ\",\"name\":\"order\",\"type\":\"tuple\"},{\"internalType\":\"bytes\",\"name\":\"signature\",\"type\":\"bytes\"},{\"internalType\":\"uint256\",\"name\":\"makingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"takingAmount\",\"type\":\"uint256\"}],\"name\":\"fillOrderRFQ\",\"outputs\":[{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"}],\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"inputs\":[{\"components\":[{\"internalType\":\"uint256\",\"name\":\"info\",\"type\":\"uint256\"},{\"internalType\":\"contract IERC20\",\"name\":\"makerAsset\",\"type\":\"address\"},{\"internalType\":\"contract IERC20\",\"name\":\"takerAsset\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"maker\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"allowedSender\",\"type\":\"address\"},{\"internalType\":\"uint256\",\"name\":\"makingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"takingAmount\",\"type\":\"uint256\"}],\"internalType\":\"struct OrderRFQMixin.OrderRFQ\",\"name\":\"order\",\"type\":\"tuple\"},{\"internalType\":\"bytes\",\"name\":\"signature\",\"type\":\"bytes\"},{\"internalType\":\"uint256\",\"name\":\"makingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"takingAmount\",\"type\":\"uint256\"},{\"internalType\":\"address\",\"name\":\"target\",\"type\":\"address\"}],\"name\":\"fillOrderRFQTo\",\"outputs\":[{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"}],\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"inputs\":[{\"components\":[{\"internalType\":\"uint256\",\"name\":\"info\",\"type\":\"uint256\"},{\"internalType\":\"contract IERC20\",\"name\":\"makerAsset\",\"type\":\"address\"},{\"internalType\":\"contract IERC20\",\"name\":\"takerAsset\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"maker\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"allowedSender\",\"type\":\"address\"},{\"internalType\":\"uint256\",\"name\":\"makingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"takingAmount\",\"type\":\"uint256\"}],\"internalType\":\"struct OrderRFQMixin.OrderRFQ\",\"name\":\"order\",\"type\":\"tuple\"},{\"internalType\":\"bytes\",\"name\":\"signature\",\"type\":\"bytes\"},{\"internalType\":\"uint256\",\"name\":\"makingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"takingAmount\",\"type\":\"uint256\"},{\"internalType\":\"address\",\"name\":\"target\",\"type\":\"address\"},{\"internalType\":\"bytes\",\"name\":\"permit\",\"type\":\"bytes\"}],\"name\":\"fillOrderRFQToWithPermit\",\"outputs\":[{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"}],\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"inputs\":[{\"components\":[{\"internalType\":\"uint256\",\"name\":\"salt\",\"type\":\"uint256\"},{\"internalType\":\"address\",\"name\":\"makerAsset\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"takerAsset\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"maker\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"receiver\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"allowedSender\",\"type\":\"address\"},{\"internalType\":\"uint256\",\"name\":\"makingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"takingAmount\",\"type\":\"uint256\"},{\"internalType\":\"bytes\",\"name\":\"makerAssetData\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"takerAssetData\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"getMakerAmount\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"getTakerAmount\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"predicate\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"permit\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"interaction\",\"type\":\"bytes\"}],\"internalType\":\"struct OrderMixin.Order\",\"name\":\"order\",\"type\":\"tuple\"},{\"internalType\":\"bytes\",\"name\":\"signature\",\"type\":\"bytes\"},{\"internalType\":\"uint256\",\"name\":\"makingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"takingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"thresholdAmount\",\"type\":\"uint256\"},{\"internalType\":\"address\",\"name\":\"target\",\"type\":\"address\"}],\"name\":\"fillOrderTo\",\"outputs\":[{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"}],\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"inputs\":[{\"components\":[{\"internalType\":\"uint256\",\"name\":\"salt\",\"type\":\"uint256\"},{\"internalType\":\"address\",\"name\":\"makerAsset\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"takerAsset\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"maker\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"receiver\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"allowedSender\",\"type\":\"address\"},{\"internalType\":\"uint256\",\"name\":\"makingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"takingAmount\",\"type\":\"uint256\"},{\"internalType\":\"bytes\",\"name\":\"makerAssetData\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"takerAssetData\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"getMakerAmount\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"getTakerAmount\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"predicate\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"permit\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"interaction\",\"type\":\"bytes\"}],\"internalType\":\"struct OrderMixin.Order\",\"name\":\"order\",\"type\":\"tuple\"},{\"internalType\":\"bytes\",\"name\":\"signature\",\"type\":\"bytes\"},{\"internalType\":\"uint256\",\"name\":\"makingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"takingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"thresholdAmount\",\"type\":\"uint256\"},{\"internalType\":\"address\",\"name\":\"target\",\"type\":\"address\"},{\"internalType\":\"bytes\",\"name\":\"permit\",\"type\":\"bytes\"}],\"name\":\"fillOrderToWithPermit\",\"outputs\":[{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"}],\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"uint256\",\"name\":\"orderMakerAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"orderTakerAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"swapTakerAmount\",\"type\":\"uint256\"}],\"name\":\"getMakerAmount\",\"outputs\":[{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"}],\"stateMutability\":\"pure\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"uint256\",\"name\":\"orderMakerAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"orderTakerAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"swapMakerAmount\",\"type\":\"uint256\"}],\"name\":\"getTakerAmount\",\"outputs\":[{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"}],\"stateMutability\":\"pure\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"uint256\",\"name\":\"value\",\"type\":\"uint256\"},{\"internalType\":\"address\",\"name\":\"target\",\"type\":\"address\"},{\"internalType\":\"bytes\",\"name\":\"data\",\"type\":\"bytes\"}],\"name\":\"gt\",\"outputs\":[{\"internalType\":\"bool\",\"name\":\"\",\"type\":\"bool\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[{\"components\":[{\"internalType\":\"uint256\",\"name\":\"salt\",\"type\":\"uint256\"},{\"internalType\":\"address\",\"name\":\"makerAsset\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"takerAsset\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"maker\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"receiver\",\"type\":\"address\"},{\"internalType\":\"address\",\"name\":\"allowedSender\",\"type\":\"address\"},{\"internalType\":\"uint256\",\"name\":\"makingAmount\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"takingAmount\",\"type\":\"uint256\"},{\"internalType\":\"bytes\",\"name\":\"makerAssetData\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"takerAssetData\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"getMakerAmount\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"getTakerAmount\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"predicate\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"permit\",\"type\":\"bytes\"},{\"internalType\":\"bytes\",\"name\":\"interaction\",\"type\":\"bytes\"}],\"internalType\":\"struct OrderMixin.Order\",\"name\":\"order\",\"type\":\"tuple\"}],\"name\":\"hashOrder\",\"outputs\":[{\"internalType\":\"bytes32\",\"name\":\"\",\"type\":\"bytes32\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[],\"name\":\"increaseNonce\",\"outputs\":[],\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"address\",\"name\":\"maker\",\"type\":\"address\"},{\"internalType\":\"uint256\",\"name\":\"slot\",\"type\":\"uint256\"}],\"name\":\"invalidatorForOrderRFQ\",\"outputs\":[{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"uint256\",\"name\":\"value\",\"type\":\"uint256\"},{\"internalType\":\"address\",\"name\":\"target\",\"type\":\"address\"},{\"internalType\":\"bytes\",\"name\":\"data\",\"type\":\"bytes\"}],\"name\":\"lt\",\"outputs\":[{\"internalType\":\"bool\",\"name\":\"\",\"type\":\"bool\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"address\",\"name\":\"\",\"type\":\"address\"}],\"name\":\"nonce\",\"outputs\":[{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"address\",\"name\":\"makerAddress\",\"type\":\"address\"},{\"internalType\":\"uint256\",\"name\":\"makerNonce\",\"type\":\"uint256\"}],\"name\":\"nonceEquals\",\"outputs\":[{\"internalType\":\"bool\",\"name\":\"\",\"type\":\"bool\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"address[]\",\"name\":\"targets\",\"type\":\"address[]\"},{\"internalType\":\"bytes[]\",\"name\":\"data\",\"type\":\"bytes[]\"}],\"name\":\"or\",\"outputs\":[{\"internalType\":\"bool\",\"name\":\"\",\"type\":\"bool\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"bytes32\",\"name\":\"orderHash\",\"type\":\"bytes32\"}],\"name\":\"remaining\",\"outputs\":[{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"bytes32\",\"name\":\"orderHash\",\"type\":\"bytes32\"}],\"name\":\"remainingRaw\",\"outputs\":[{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"bytes32[]\",\"name\":\"orderHashes\",\"type\":\"bytes32[]\"}],\"name\":\"remainingsRaw\",\"outputs\":[{\"internalType\":\"uint256[]\",\"name\":\"\",\"type\":\"uint256[]\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"address[]\",\"name\":\"targets\",\"type\":\"address[]\"},{\"internalType\":\"bytes[]\",\"name\":\"data\",\"type\":\"bytes[]\"}],\"name\":\"simulateCalls\",\"outputs\":[],\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"contract AggregatorV3Interface\",\"name\":\"oracle\",\"type\":\"address\"},{\"internalType\":\"uint256\",\"name\":\"inverseAndSpread\",\"type\":\"uint256\"},{\"internalType\":\"uint256\",\"name\":\"amount\",\"type\":\"uint256\"}],\"name\":\"singlePrice\",\"outputs\":[{\"internalType\":\"uint256\",\"name\":\"\",\"type\":\"uint256\"}],\"stateMutability\":\"view\",\"type\":\"function\"},{\"inputs\":[{\"internalType\":\"uint256\",\"name\":\"time\",\"type\":\"uint256\"}],\"name\":\"timestampBelow\",\"outputs\":[{\"internalType\":\"bool\",\"name\":\"\",\"type\":\"bool\"}],\"stateMutability\":\"view\",\"type\":\"function\"}]\n",
    "contract = w3.eth.contract(address=\"0x119c71D3BbAC22029622cbaEc24854d3D32D2828\", abi=contract_abi)\n",
    "\n",
    "erc20_abi = [{\"constant\":\"true\",\"inputs\":[],\"name\":\"name\",\"outputs\":[{\"name\":\"\",\"type\":\"string\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"false\",\"inputs\":[{\"name\":\"_upgradedAddress\",\"type\":\"address\"}],\"name\":\"deprecate\",\"outputs\":[],\"payable\":\"false\",\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"constant\":\"false\",\"inputs\":[{\"name\":\"_spender\",\"type\":\"address\"},{\"name\":\"_value\",\"type\":\"uint256\"}],\"name\":\"approve\",\"outputs\":[],\"payable\":\"false\",\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[],\"name\":\"deprecated\",\"outputs\":[{\"name\":\"\",\"type\":\"bool\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"false\",\"inputs\":[{\"name\":\"_evilUser\",\"type\":\"address\"}],\"name\":\"addBlackList\",\"outputs\":[],\"payable\":\"false\",\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[],\"name\":\"totalSupply\",\"outputs\":[{\"name\":\"\",\"type\":\"uint256\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"false\",\"inputs\":[{\"name\":\"_from\",\"type\":\"address\"},{\"name\":\"_to\",\"type\":\"address\"},{\"name\":\"_value\",\"type\":\"uint256\"}],\"name\":\"transferFrom\",\"outputs\":[],\"payable\":\"false\",\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[],\"name\":\"upgradedAddress\",\"outputs\":[{\"name\":\"\",\"type\":\"address\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[{\"name\":\"\",\"type\":\"address\"}],\"name\":\"balances\",\"outputs\":[{\"name\":\"\",\"type\":\"uint256\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[],\"name\":\"decimals\",\"outputs\":[{\"name\":\"\",\"type\":\"uint256\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[],\"name\":\"maximumFee\",\"outputs\":[{\"name\":\"\",\"type\":\"uint256\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[],\"name\":\"_totalSupply\",\"outputs\":[{\"name\":\"\",\"type\":\"uint256\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"false\",\"inputs\":[],\"name\":\"unpause\",\"outputs\":[],\"payable\":\"false\",\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[{\"name\":\"_maker\",\"type\":\"address\"}],\"name\":\"getBlackListStatus\",\"outputs\":[{\"name\":\"\",\"type\":\"bool\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[{\"name\":\"\",\"type\":\"address\"},{\"name\":\"\",\"type\":\"address\"}],\"name\":\"allowed\",\"outputs\":[{\"name\":\"\",\"type\":\"uint256\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[],\"name\":\"paused\",\"outputs\":[{\"name\":\"\",\"type\":\"bool\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[{\"name\":\"who\",\"type\":\"address\"}],\"name\":\"balanceOf\",\"outputs\":[{\"name\":\"\",\"type\":\"uint256\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"false\",\"inputs\":[],\"name\":\"pause\",\"outputs\":[],\"payable\":\"false\",\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[],\"name\":\"getOwner\",\"outputs\":[{\"name\":\"\",\"type\":\"address\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[],\"name\":\"owner\",\"outputs\":[{\"name\":\"\",\"type\":\"address\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[],\"name\":\"symbol\",\"outputs\":[{\"name\":\"\",\"type\":\"string\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"false\",\"inputs\":[{\"name\":\"_to\",\"type\":\"address\"},{\"name\":\"_value\",\"type\":\"uint256\"}],\"name\":\"transfer\",\"outputs\":[],\"payable\":\"false\",\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"constant\":\"false\",\"inputs\":[{\"name\":\"newBasisPoints\",\"type\":\"uint256\"},{\"name\":\"newMaxFee\",\"type\":\"uint256\"}],\"name\":\"setParams\",\"outputs\":[],\"payable\":\"false\",\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"constant\":\"false\",\"inputs\":[{\"name\":\"amount\",\"type\":\"uint256\"}],\"name\":\"issue\",\"outputs\":[],\"payable\":\"false\",\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"constant\":\"false\",\"inputs\":[{\"name\":\"amount\",\"type\":\"uint256\"}],\"name\":\"redeem\",\"outputs\":[],\"payable\":\"false\",\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[{\"name\":\"_owner\",\"type\":\"address\"},{\"name\":\"_spender\",\"type\":\"address\"}],\"name\":\"allowance\",\"outputs\":[{\"name\":\"remaining\",\"type\":\"uint256\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[],\"name\":\"basisPointsRate\",\"outputs\":[{\"name\":\"\",\"type\":\"uint256\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[{\"name\":\"\",\"type\":\"address\"}],\"name\":\"isBlackListed\",\"outputs\":[{\"name\":\"\",\"type\":\"bool\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"false\",\"inputs\":[{\"name\":\"_clearedUser\",\"type\":\"address\"}],\"name\":\"removeBlackList\",\"outputs\":[],\"payable\":\"false\",\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"constant\":\"true\",\"inputs\":[],\"name\":\"MAX_UINT\",\"outputs\":[{\"name\":\"\",\"type\":\"uint256\"}],\"payable\":\"false\",\"stateMutability\":\"view\",\"type\":\"function\"},{\"constant\":\"false\",\"inputs\":[{\"name\":\"newOwner\",\"type\":\"address\"}],\"name\":\"transferOwnership\",\"outputs\":[],\"payable\":\"false\",\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"constant\":\"false\",\"inputs\":[{\"name\":\"_blackListedUser\",\"type\":\"address\"}],\"name\":\"destroyBlackFunds\",\"outputs\":[],\"payable\":\"false\",\"stateMutability\":\"nonpayable\",\"type\":\"function\"},{\"inputs\":[{\"name\":\"_initialSupply\",\"type\":\"uint256\"},{\"name\":\"_name\",\"type\":\"string\"},{\"name\":\"_symbol\",\"type\":\"string\"},{\"name\":\"_decimals\",\"type\":\"uint256\"}],\"payable\":\"false\",\"stateMutability\":\"nonpayable\",\"type\":\"constructor\"},{\"anonymous\":\"false\",\"inputs\":[{\"indexed\":\"false\",\"name\":\"amount\",\"type\":\"uint256\"}],\"name\":\"Issue\",\"type\":\"event\"},{\"anonymous\":\"false\",\"inputs\":[{\"indexed\":\"false\",\"name\":\"amount\",\"type\":\"uint256\"}],\"name\":\"Redeem\",\"type\":\"event\"},{\"anonymous\":\"false\",\"inputs\":[{\"indexed\":\"false\",\"name\":\"newAddress\",\"type\":\"address\"}],\"name\":\"Deprecate\",\"type\":\"event\"},{\"anonymous\":\"false\",\"inputs\":[{\"indexed\":\"false\",\"name\":\"feeBasisPoints\",\"type\":\"uint256\"},{\"indexed\":\"false\",\"name\":\"maxFee\",\"type\":\"uint256\"}],\"name\":\"Params\",\"type\":\"event\"},{\"anonymous\":\"false\",\"inputs\":[{\"indexed\":\"false\",\"name\":\"_blackListedUser\",\"type\":\"address\"},{\"indexed\":\"false\",\"name\":\"_balance\",\"type\":\"uint256\"}],\"name\":\"DestroyedBlackFunds\",\"type\":\"event\"},{\"anonymous\":\"false\",\"inputs\":[{\"indexed\":\"false\",\"name\":\"_user\",\"type\":\"address\"}],\"name\":\"AddedBlackList\",\"type\":\"event\"},{\"anonymous\":\"false\",\"inputs\":[{\"indexed\":\"false\",\"name\":\"_user\",\"type\":\"address\"}],\"name\":\"RemovedBlackList\",\"type\":\"event\"},{\"anonymous\":\"false\",\"inputs\":[{\"indexed\":\"true\",\"name\":\"owner\",\"type\":\"address\"},{\"indexed\":\"true\",\"name\":\"spender\",\"type\":\"address\"},{\"indexed\":\"false\",\"name\":\"value\",\"type\":\"uint256\"}],\"name\":\"Approval\",\"type\":\"event\"},{\"anonymous\":\"false\",\"inputs\":[{\"indexed\":\"true\",\"name\":\"from\",\"type\":\"address\"},{\"indexed\":\"true\",\"name\":\"to\",\"type\":\"address\"},{\"indexed\":\"false\",\"name\":\"value\",\"type\":\"uint256\"}],\"name\":\"Transfer\",\"type\":\"event\"},{\"anonymous\":\"false\",\"inputs\":[],\"name\":\"Pause\",\"type\":\"event\"},{\"anonymous\":\"false\",\"inputs\":[],\"name\":\"Unpause\",\"type\":\"event\"}]\n",
    "\n",
    "makerAddress = Web3.toChecksumAddress(\"0x0000000000000000000000000000000000000000\")\n",
    "takerAddress = \"0x0000000000000000000000000000000000000000\"\n",
    "makerAsset = Web3.toChecksumAddress(\"0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48\")\n",
    "takerAsset = Web3.toChecksumAddress(\"0xdac17f958d2ee523a2206206994597c13d831ec7\")\n",
    "makingAmount = \"100000000\"\n",
    "takingAmount = \"100000000\"\n",
    "\n",
    "# maker asset contract\n",
    "makerAssetContract = w3.eth.contract(address=makerAsset, abi=erc20_abi)\n",
    "# taker asset contract\n",
    "takerAssetContract = w3.eth.contract(address=takerAsset, abi=erc20_abi)\n",
    "\n",
    "makerAssetData = makerAssetContract.encodeABI(fn_name=\"transferFrom\", args=[makerAddress, takerAddress, int(makingAmount)])\n",
    "takerAssetData = takerAssetContract.encodeABI(fn_name=\"transferFrom\", args=[takerAddress, makerAddress, int(takingAmount)])\n",
    "\n",
    "getMakerAmount = contract.encodeABI(fn_name=\"getMakerAmount\", args=[int(makingAmount), int(takingAmount), 0])\n",
    "getMakerAmount = getMakerAmount[:-64]\n",
    "getTakerAmount = contract.encodeABI(fn_name=\"getTakerAmount\", args=[int(makingAmount), int(takingAmount), 0])\n",
    "getTakerAmount = getTakerAmount[:-64]\n",
    "\n",
    "# contract encode abi with the timestamp below function and the current time + 180 seconds\n",
    "predicate = contract.encodeABI(fn_name=\"timestampBelow\", args=[w3.eth.getBlock('latest').timestamp + 180])\n",
    "\n",
    "order_data = {\n",
    "    \"makerAsset\": makerAsset,\n",
    "    \"takerAsset\": takerAsset,\n",
    "    \"maker\": makerAddress,\n",
    "    \"allowedSender\": \"0x0000000000000000000000000000000000000000\",\n",
    "    \"receiver\": \"0x0000000000000000000000000000000000000000\",\n",
    "    \"makingAmount\": makingAmount,\n",
    "    \"takingAmount\": takingAmount,\n",
    "    \"makerAssetData\": \"0x\", #str(makerAssetData),\n",
    "    \"takerAssetData\": \"0x\", #str(takerAssetData),\n",
    "    \"getMakerAmount\": getMakerAmount,\n",
    "    \"getTakerAmount\": getTakerAmount,\n",
    "    \"predicate\": predicate,\n",
    "    \"permit\": \"0x\",\n",
    "    \"interaction\": \"0x\",\n",
    "    \"salt\": \"1\", # random number to make the order unique\n",
    "}\n",
    "\n",
    "order_types = [\n",
    "    {\"name\": \"salt\", \"type\": \"uint256\"},\n",
    "    {\"name\": \"makerAsset\", \"type\": \"address\"},\n",
    "    {\"name\": \"takerAsset\", \"type\": \"address\"},\n",
    "    {\"name\": \"maker\", \"type\": \"address\"},\n",
    "    {\"name\": \"receiver\", \"type\": \"address\"},\n",
    "    {\"name\": \"allowedSender\", \"type\": \"address\"},\n",
    "    {\"name\": \"makingAmount\", \"type\": \"uint256\"},\n",
    "    {\"name\": \"takingAmount\", \"type\": \"uint256\"},\n",
    "    {\"name\": \"makerAssetData\", \"type\": \"bytes\"},\n",
    "    {\"name\": \"takerAssetData\", \"type\": \"bytes\"},\n",
    "    {\"name\": \"getMakerAmount\", \"type\": \"bytes\"},\n",
    "    {\"name\": \"getTakerAmount\", \"type\": \"bytes\"},\n",
    "    {\"name\": \"predicate\", \"type\": \"bytes\"},\n",
    "    {\"name\": \"permit\", \"type\": \"bytes\"},\n",
    "    {\"name\": \"interaction\", \"type\": \"bytes\"},\n",
    "]\n",
    "def fix_data_types(data, types):\n",
    "    \"\"\"\n",
    "    Order data values are all strings as this is what the API expects. This function fixes their types for\n",
    "    encoding purposes.\n",
    "    \"\"\"\n",
    "    fixed_data = {}\n",
    "    for dictionary in types:\n",
    "        if \"bytes\" in dictionary[\"type\"]:\n",
    "            fixed_data[dictionary[\"name\"]] = (Web3.toBytes(hexstr=data[dictionary[\"name\"]]))\n",
    "        elif \"int\" in dictionary[\"type\"]:\n",
    "            fixed_data[dictionary[\"name\"]] = int(data[dictionary[\"name\"]])\n",
    "        else:\n",
    "            fixed_data[dictionary[\"name\"]] = data[dictionary[\"name\"]]\n",
    "    return fixed_data\n",
    "eip712_data = {\n",
    "    \"primaryType\": \"Order\",\n",
    "    \"types\": {\n",
    "        \"EIP712Domain\": [\n",
    "            {\"name\": \"name\", \"type\": \"string\"},\n",
    "            {\"name\": \"version\", \"type\": \"string\"},\n",
    "            {\"name\": \"chainId\", \"type\": \"uint256\"},\n",
    "            {\"name\": \"verifyingContract\", \"type\": \"address\"},\n",
    "        ],\n",
    "        \"Order\": order_types\n",
    "    },\n",
    "    \"domain\": {\n",
    "        \"name\": \"1inch Limit Order Protocol\",\n",
    "        \"version\": \"2\",\n",
    "        \"chainId\": 1,\n",
    "        \"verifyingContract\": \"0x119c71D3BbAC22029622cbaEc24854d3D32D2828\",\n",
    "    },\n",
    "    \"message\": fix_data_types(order_data, order_types),\n",
    "}\n",
    "encoded_message = encode_structured_data(eip712_data)\n",
    "signed_message = w3.eth.account.sign_message(encoded_message, wallet_key)\n",
    "limit_order = {\n",
    "    \"orderHash\": signed_message.messageHash.hex(),\n",
    "    \"signature\": signed_message.signature.hex(),\n",
    "    \"data\": order_data,\n",
    "}\n",
    "\n",
    "limit_order_url = \"https://limit-orders.1inch.io/v2.0/1/limit-order\"\n",
    "response = requests.post(url=limit_order_url,headers={\"accept\": \"application/json, text/plain, */*\", \"content-type\": \"application/json\"}, json=limit_order)\n",
    "# print the full response\n",
    "print(response.text)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[80662446152, -46766118479324977244, 1908032764161309095477689102164590, 13043848071626461752, 201795]\n"
     ]
    }
   ],
   "source": [
    "from eth_abi import decode_single, decode_abi\n",
    "data = '00000000000000000000000000000000000000000000000000000012c7db4048fffffffffffffffffffffffffffffffffffffffffffffffd76fd5f054400e7a40000000000000000000000000000000000005e12c25ea154ac1ed76c593ce26e000000000000000000000000000000000000000000000000b5050eb63d7592380000000000000000000000000000000000000000000000000000000000031443'\n",
    "number = decode_single('(int256,int256,uint160,uint128,int24)',bytearray.fromhex(data))\n",
    "print(list(number))\n",
    "# (index_topic_1 address sender, index_topic_2 address recipient,\n",
    "# int256 amount0, int256 amount1, uint160 sqrtPriceX96, uint128 liquidity, int24 tick)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 102,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1724.8052388110934"
      ]
     },
     "execution_count": 102,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(80662446152/46766118479324977244)*math.pow(10,12)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "24082.759256442234\n"
     ]
    }
   ],
   "source": [
    "import math\n",
    "sqrtRatioX96 = 1908032764161309095477689102164590\n",
    "price = float(sqrtRatioX96) / math.pow(2, 96)\n",
    "print(price)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "ename": "",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31mJupyter cannot be started. Error attempting to locate Jupyter: Running cells with 'Python 3.10.6 64-bit' requires notebook package.\n",
      "\u001b[1;31mRun the following command to install 'jupyter and notebook' into the Python environment. \n",
      "\u001b[1;31mCommand: 'python -m pip install jupyter notebook -U\n",
      "\u001b[1;31mor\n",
      "\u001b[1;31mconda install jupyter notebook -U'\n",
      "Click <a href='https://aka.ms/installJupyterForVSCode'>here</a> for more info."
     ]
    }
   ],
   "source": [
    "from web3.auto import w3\n",
    "acct = w3.eth.account.create('KEYSMASH FJAFJKLDSKF7JKFDJ 1530')\n",
    "acct.address\n",
    "acct.privateKey\n",
    "acct.privateKey.hex()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "ename": "",
     "evalue": "",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31mJupyter cannot be started. Error attempting to locate Jupyter: Running cells with 'Python 3.10.6 64-bit' requires notebook package.\n",
      "\u001b[1;31mRun the following command to install 'jupyter and notebook' into the Python environment. \n",
      "\u001b[1;31mCommand: 'python -m pip install jupyter notebook -U\n",
      "\u001b[1;31mor\n",
      "\u001b[1;31mconda install jupyter notebook -U'\n",
      "Click <a href='https://aka.ms/installJupyterForVSCode'>here</a> for more info."
     ]
    }
   ],
   "source": [
    "from web3.auto import w3\n",
    "acct = w3.eth.account.create('KEYSMASH FJAFJKLDSKF7JKFDJ 1530')\n",
    "acct.address\n",
    "acct.privateKey\n",
    "acct.privateKey.hex()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.9.12 ('base')",
   "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.12"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "23c0c6b682c48f891e2018936fa93f8039486babc2160c750f2f8f0461c2b345"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}