notebooks/defillama_api_bridges.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "7b0c3fd5-3eb2-4ae1-b882-f43cfc15e542",
   "metadata": {},
   "outputs": [],
   "source": [
    "from defillama2 import DefiLlama\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "pd.set_option('display.max_columns', 15)\n",
    "pd.set_option('display.max_rows', 50)\n",
    "pd.options.display.float_format = '{:,.4f}'.format"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "9ec6cbc9-201f-4422-b72f-f8ea85f70179",
   "metadata": {},
   "outputs": [],
   "source": [
    "obj = DefiLlama()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "id": "9d737207-8e0f-4d11-9096-13fbe355b66d",
   "metadata": {
    "tags": []
   },
   "source": [
    "\n",
    "## Get volume summary of all bridges"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "76b9d726-04ed-4d33-8373-02fd6c706866",
   "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>id</th>\n",
       "      <th>displayName</th>\n",
       "      <th>volumePrevDay</th>\n",
       "      <th>volumePrev2Day</th>\n",
       "      <th>lastHourlyVolume</th>\n",
       "      <th>currentDayVolume</th>\n",
       "      <th>lastDailyVolume</th>\n",
       "      <th>dayBeforeLastVolume</th>\n",
       "      <th>weeklyVolume</th>\n",
       "      <th>monthlyVolume</th>\n",
       "      <th>chainsCnt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5</td>\n",
       "      <td>Multichain</td>\n",
       "      <td>34,630,033.7486</td>\n",
       "      <td>28,983,816.5663</td>\n",
       "      <td>53,549.4158</td>\n",
       "      <td>1,729,717.8213</td>\n",
       "      <td>34,630,033.7486</td>\n",
       "      <td>28,983,816.5663</td>\n",
       "      <td>212,361,113.3672</td>\n",
       "      <td>806,857,792.9381</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Arbitrum Bridge</td>\n",
       "      <td>8,435,105.2498</td>\n",
       "      <td>52,319,773.6589</td>\n",
       "      <td>401,220.8498</td>\n",
       "      <td>766,588.7568</td>\n",
       "      <td>8,435,105.2498</td>\n",
       "      <td>52,319,773.6589</td>\n",
       "      <td>98,176,129.2728</td>\n",
       "      <td>644,212,539.3241</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "      <td>Polygon PoS Bridge</td>\n",
       "      <td>7,399,139.3694</td>\n",
       "      <td>9,248,095.6382</td>\n",
       "      <td>39,727.3198</td>\n",
       "      <td>5,975,641.0363</td>\n",
       "      <td>7,399,139.3694</td>\n",
       "      <td>9,248,095.6382</td>\n",
       "      <td>80,850,539.1209</td>\n",
       "      <td>469,622,562.5225</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Avalanche Bridge</td>\n",
       "      <td>5,735,424.6679</td>\n",
       "      <td>5,429,579.7382</td>\n",
       "      <td>127,971.2431</td>\n",
       "      <td>363,885.5100</td>\n",
       "      <td>5,735,424.6679</td>\n",
       "      <td>5,429,579.7382</td>\n",
       "      <td>32,354,785.5946</td>\n",
       "      <td>147,632,426.2688</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Optimism Gateway</td>\n",
       "      <td>1,747,054.2529</td>\n",
       "      <td>5,876,501.7951</td>\n",
       "      <td>17,474.3271</td>\n",
       "      <td>36,175.5377</td>\n",
       "      <td>1,747,054.2529</td>\n",
       "      <td>5,876,501.7951</td>\n",
       "      <td>34,328,346.8339</td>\n",
       "      <td>232,196,201.7527</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id         displayName   volumePrevDay  volumePrev2Day  lastHourlyVolume  \\\n",
       "0   5          Multichain 34,630,033.7486 28,983,816.5663       53,549.4158   \n",
       "1   2     Arbitrum Bridge  8,435,105.2498 52,319,773.6589      401,220.8498   \n",
       "2   1  Polygon PoS Bridge  7,399,139.3694  9,248,095.6382       39,727.3198   \n",
       "3   3    Avalanche Bridge  5,735,424.6679  5,429,579.7382      127,971.2431   \n",
       "4   4    Optimism Gateway  1,747,054.2529  5,876,501.7951       17,474.3271   \n",
       "\n",
       "   currentDayVolume  lastDailyVolume  dayBeforeLastVolume     weeklyVolume  \\\n",
       "0    1,729,717.8213  34,630,033.7486      28,983,816.5663 212,361,113.3672   \n",
       "1      766,588.7568   8,435,105.2498      52,319,773.6589  98,176,129.2728   \n",
       "2    5,975,641.0363   7,399,139.3694       9,248,095.6382  80,850,539.1209   \n",
       "3      363,885.5100   5,735,424.6679       5,429,579.7382  32,354,785.5946   \n",
       "4       36,175.5377   1,747,054.2529       5,876,501.7951  34,328,346.8339   \n",
       "\n",
       "     monthlyVolume  chainsCnt  \n",
       "0 806,857,792.9381          9  \n",
       "1 644,212,539.3241          2  \n",
       "2 469,622,562.5225          2  \n",
       "3 147,632,426.2688          2  \n",
       "4 232,196,201.7527          2  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = obj.get_bridges_volumes()\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "1c666a77",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "9d5b2511",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['summary', 'summary_by_chain', 'deposits_withdraws_by_chain'])"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dd = obj.get_bridge_volume(bridge_id=1)\n",
    "dd.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "883159ee",
   "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>displayName</th>\n",
       "      <th>lastHourlyVolume</th>\n",
       "      <th>currentDayVolume</th>\n",
       "      <th>lastDailyVolume</th>\n",
       "      <th>dayBeforeLastVolume</th>\n",
       "      <th>weeklyVolume</th>\n",
       "      <th>monthlyVolume</th>\n",
       "      <th>lastHourlyTxs</th>\n",
       "      <th>currentDayTxs</th>\n",
       "      <th>prevDayTxs</th>\n",
       "      <th>dayBeforeLastTxs</th>\n",
       "      <th>weeklyTxs</th>\n",
       "      <th>monthlyTxs</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Polygon PoS Bridge</td>\n",
       "      <td>0</td>\n",
       "      <td>5,975,641.0363</td>\n",
       "      <td>7,399,139.3694</td>\n",
       "      <td>9,248,095.6382</td>\n",
       "      <td>102,315,205.2258</td>\n",
       "      <td>469,622,562.5225</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>180.0000</td>\n",
       "      <td>1,132.0000</td>\n",
       "      <td>1,101.0000</td>\n",
       "      <td>9,354.0000</td>\n",
       "      <td>45,674.0000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          displayName  lastHourlyVolume  currentDayVolume  lastDailyVolume  \\\n",
       "0  Polygon PoS Bridge                 0    5,975,641.0363   7,399,139.3694   \n",
       "\n",
       "   dayBeforeLastVolume     weeklyVolume    monthlyVolume  lastHourlyTxs  \\\n",
       "0       9,248,095.6382 102,315,205.2258 469,622,562.5225         0.0000   \n",
       "\n",
       "   currentDayTxs  prevDayTxs  dayBeforeLastTxs  weeklyTxs  monthlyTxs  \n",
       "0       180.0000  1,132.0000        1,101.0000 9,354.0000 45,674.0000  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dd['summary']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "d6b48cf7",
   "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>chain</th>\n",
       "      <th>lastHourlyVolume</th>\n",
       "      <th>currentDayVolume</th>\n",
       "      <th>lastDailyVolume</th>\n",
       "      <th>dayBeforeLastVolume</th>\n",
       "      <th>weeklyVolume</th>\n",
       "      <th>monthlyVolume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ethereum</td>\n",
       "      <td>0</td>\n",
       "      <td>2,987,820.5181</td>\n",
       "      <td>3,699,569.6847</td>\n",
       "      <td>4,624,047.8191</td>\n",
       "      <td>51,157,602.6129</td>\n",
       "      <td>234,811,281.2613</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Polygon</td>\n",
       "      <td>0</td>\n",
       "      <td>2,987,820.5181</td>\n",
       "      <td>3,699,569.6847</td>\n",
       "      <td>4,624,047.8191</td>\n",
       "      <td>51,157,602.6129</td>\n",
       "      <td>234,811,281.2613</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      chain  lastHourlyVolume  currentDayVolume  lastDailyVolume  \\\n",
       "0  Ethereum                 0    2,987,820.5181   3,699,569.6847   \n",
       "1   Polygon                 0    2,987,820.5181   3,699,569.6847   \n",
       "\n",
       "   dayBeforeLastVolume    weeklyVolume    monthlyVolume  \n",
       "0       4,624,047.8191 51,157,602.6129 234,811,281.2613  \n",
       "1       4,624,047.8191 51,157,602.6129 234,811,281.2613  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dd['summary_by_chain']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "5d290082",
   "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>chain</th>\n",
       "      <th>txType</th>\n",
       "      <th>lastHourlyTxs</th>\n",
       "      <th>currentDayTxs</th>\n",
       "      <th>prevDayTxs</th>\n",
       "      <th>dayBeforeLastTxs</th>\n",
       "      <th>weeklyTxs</th>\n",
       "      <th>monthlyTxs</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ethereum</td>\n",
       "      <td>deposits</td>\n",
       "      <td>0</td>\n",
       "      <td>126</td>\n",
       "      <td>745</td>\n",
       "      <td>726</td>\n",
       "      <td>6573</td>\n",
       "      <td>32998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ethereum</td>\n",
       "      <td>withdrawals</td>\n",
       "      <td>0</td>\n",
       "      <td>54</td>\n",
       "      <td>387</td>\n",
       "      <td>375</td>\n",
       "      <td>2781</td>\n",
       "      <td>12676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Polygon</td>\n",
       "      <td>deposits</td>\n",
       "      <td>0</td>\n",
       "      <td>54</td>\n",
       "      <td>387</td>\n",
       "      <td>375</td>\n",
       "      <td>2781</td>\n",
       "      <td>12676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Polygon</td>\n",
       "      <td>withdrawals</td>\n",
       "      <td>0</td>\n",
       "      <td>126</td>\n",
       "      <td>745</td>\n",
       "      <td>726</td>\n",
       "      <td>6573</td>\n",
       "      <td>32998</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      chain       txType  lastHourlyTxs  currentDayTxs  prevDayTxs  \\\n",
       "0  Ethereum     deposits              0            126         745   \n",
       "1  Ethereum  withdrawals              0             54         387   \n",
       "2   Polygon     deposits              0             54         387   \n",
       "3   Polygon  withdrawals              0            126         745   \n",
       "\n",
       "   dayBeforeLastTxs  weeklyTxs  monthlyTxs  \n",
       "0               726       6573       32998  \n",
       "1               375       2781       12676  \n",
       "2               375       2781       12676  \n",
       "3               726       6573       32998  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dd['deposits_withdraws_by_chain']"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "id": "8faa2da4",
   "metadata": {},
   "source": [
    "## Get daily volumes from a particular bridge"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "162dbd37",
   "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>depositUSD</th>\n",
       "      <th>withdrawUSD</th>\n",
       "      <th>depositTxs</th>\n",
       "      <th>withdrawTxs</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2022-09-01 00:00:00+00:00</th>\n",
       "      <td>26,913,837.4464</td>\n",
       "      <td>29,735,340.1374</td>\n",
       "      <td>2806</td>\n",
       "      <td>2590</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-02 00:00:00+00:00</th>\n",
       "      <td>39,286,336.5884</td>\n",
       "      <td>43,214,576.7587</td>\n",
       "      <td>2785</td>\n",
       "      <td>2709</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-03 00:00:00+00:00</th>\n",
       "      <td>37,001,903.8771</td>\n",
       "      <td>36,758,187.6804</td>\n",
       "      <td>2400</td>\n",
       "      <td>2381</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-04 00:00:00+00:00</th>\n",
       "      <td>28,691,939.8860</td>\n",
       "      <td>45,164,333.4297</td>\n",
       "      <td>2524</td>\n",
       "      <td>2576</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-05 00:00:00+00:00</th>\n",
       "      <td>58,983,401.1159</td>\n",
       "      <td>58,935,825.8395</td>\n",
       "      <td>3171</td>\n",
       "      <td>3096</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               depositUSD     withdrawUSD  depositTxs  \\\n",
       "date                                                                    \n",
       "2022-09-01 00:00:00+00:00 26,913,837.4464 29,735,340.1374        2806   \n",
       "2022-09-02 00:00:00+00:00 39,286,336.5884 43,214,576.7587        2785   \n",
       "2022-09-03 00:00:00+00:00 37,001,903.8771 36,758,187.6804        2400   \n",
       "2022-09-04 00:00:00+00:00 28,691,939.8860 45,164,333.4297        2524   \n",
       "2022-09-05 00:00:00+00:00 58,983,401.1159 58,935,825.8395        3171   \n",
       "\n",
       "                           withdrawTxs  \n",
       "date                                    \n",
       "2022-09-01 00:00:00+00:00         2590  \n",
       "2022-09-02 00:00:00+00:00         2709  \n",
       "2022-09-03 00:00:00+00:00         2381  \n",
       "2022-09-04 00:00:00+00:00         2576  \n",
       "2022-09-05 00:00:00+00:00         3096  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# on all chains\n",
    "df = obj.get_daily_volume_this_bridge(bridge_id=5, chain='all')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "c468557e",
   "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>depositUSD</th>\n",
       "      <th>withdrawUSD</th>\n",
       "      <th>depositTxs</th>\n",
       "      <th>withdrawTxs</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2022-09-01 00:00:00+00:00</th>\n",
       "      <td>7,399,628.7693</td>\n",
       "      <td>10,805,446.9631</td>\n",
       "      <td>547</td>\n",
       "      <td>465</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-02 00:00:00+00:00</th>\n",
       "      <td>12,421,985.6609</td>\n",
       "      <td>11,612,565.9071</td>\n",
       "      <td>588</td>\n",
       "      <td>476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-03 00:00:00+00:00</th>\n",
       "      <td>5,604,725.6731</td>\n",
       "      <td>6,814,770.2775</td>\n",
       "      <td>546</td>\n",
       "      <td>338</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-04 00:00:00+00:00</th>\n",
       "      <td>7,224,908.8936</td>\n",
       "      <td>16,464,749.8037</td>\n",
       "      <td>544</td>\n",
       "      <td>419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-09-05 00:00:00+00:00</th>\n",
       "      <td>8,225,943.3939</td>\n",
       "      <td>15,686,139.3990</td>\n",
       "      <td>607</td>\n",
       "      <td>635</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                               depositUSD     withdrawUSD  depositTxs  \\\n",
       "date                                                                    \n",
       "2022-09-01 00:00:00+00:00  7,399,628.7693 10,805,446.9631         547   \n",
       "2022-09-02 00:00:00+00:00 12,421,985.6609 11,612,565.9071         588   \n",
       "2022-09-03 00:00:00+00:00  5,604,725.6731  6,814,770.2775         546   \n",
       "2022-09-04 00:00:00+00:00  7,224,908.8936 16,464,749.8037         544   \n",
       "2022-09-05 00:00:00+00:00  8,225,943.3939 15,686,139.3990         607   \n",
       "\n",
       "                           withdrawTxs  \n",
       "date                                    \n",
       "2022-09-01 00:00:00+00:00          465  \n",
       "2022-09-02 00:00:00+00:00          476  \n",
       "2022-09-03 00:00:00+00:00          338  \n",
       "2022-09-04 00:00:00+00:00          419  \n",
       "2022-09-05 00:00:00+00:00          635  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# on ethereum\n",
    "df = obj.get_daily_volume_this_bridge(bridge_id=5, chain='ethereum')\n",
    "df.head()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "id": "95f04ebf",
   "metadata": {},
   "source": [
    "## Get 24hr token and volume breakdown for a bridge. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "aa247c4c",
   "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>symbol</th>\n",
       "      <th>TokensDeposited_usdValue</th>\n",
       "      <th>TokensWithdrawn_usdValue</th>\n",
       "      <th>AddressDeposited_usdValue</th>\n",
       "      <th>AddressDeposited_txs</th>\n",
       "      <th>AddressWithdrawn_usdValue</th>\n",
       "      <th>AddressWithdrawn_txs</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>USDT</td>\n",
       "      <td>3,931,620.6695</td>\n",
       "      <td>9,795,198.7199</td>\n",
       "      <td>3,503,489.9900</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>8,795,760.1880</td>\n",
       "      <td>6.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>USDC</td>\n",
       "      <td>874,672.8780</td>\n",
       "      <td>1,359,680.7559</td>\n",
       "      <td>326,755.2288</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>475,464.1204</td>\n",
       "      <td>3.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>WETH</td>\n",
       "      <td>360,474.7623</td>\n",
       "      <td>498,015.4675</td>\n",
       "      <td>288,086.2260</td>\n",
       "      <td>3.0000</td>\n",
       "      <td>310,774.1161</td>\n",
       "      <td>4.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>WBTC</td>\n",
       "      <td>154,985.9763</td>\n",
       "      <td>46,653.7167</td>\n",
       "      <td>127,492.8492</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>299,225.5676</td>\n",
       "      <td>2.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ICE</td>\n",
       "      <td>98,471.0538</td>\n",
       "      <td>117,030.6303</td>\n",
       "      <td>104,162.3858</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>242,908.9689</td>\n",
       "      <td>3.0000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  symbol TokensDeposited_usdValue TokensWithdrawn_usdValue  \\\n",
       "0   USDT           3,931,620.6695           9,795,198.7199   \n",
       "1   USDC             874,672.8780           1,359,680.7559   \n",
       "2   WETH             360,474.7623             498,015.4675   \n",
       "3   WBTC             154,985.9763              46,653.7167   \n",
       "4    ICE              98,471.0538             117,030.6303   \n",
       "\n",
       "   AddressDeposited_usdValue  AddressDeposited_txs  AddressWithdrawn_usdValue  \\\n",
       "0             3,503,489.9900                1.0000             8,795,760.1880   \n",
       "1               326,755.2288                3.0000               475,464.1204   \n",
       "2               288,086.2260                3.0000               310,774.1161   \n",
       "3               127,492.8492                1.0000               299,225.5676   \n",
       "4               104,162.3858                1.0000               242,908.9689   \n",
       "\n",
       "   AddressWithdrawn_txs  \n",
       "0                6.0000  \n",
       "1                3.0000  \n",
       "2                4.0000  \n",
       "3                2.0000  \n",
       "4                3.0000  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get token and volume breakdown for bridge 5 on Ethereum\n",
    "# 24hr since 2022-12-22 UTC 00:00 \n",
    "df = obj.get_24h_token_volume_this_bridge(\n",
    "    bridge_id=5, chain='ethereum', date='2022-12-22')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "b2b907eb",
   "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>symbol</th>\n",
       "      <th>TokensDeposited_usdValue</th>\n",
       "      <th>TokensWithdrawn_usdValue</th>\n",
       "      <th>AddressDeposited_usdValue</th>\n",
       "      <th>AddressDeposited_txs</th>\n",
       "      <th>AddressWithdrawn_usdValue</th>\n",
       "      <th>AddressWithdrawn_txs</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>USDC</td>\n",
       "      <td>5,246,330.1939</td>\n",
       "      <td>105,580.6504</td>\n",
       "      <td>5,004,874.3054</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>153,807.8307</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>WETH</td>\n",
       "      <td>1,947,580.4076</td>\n",
       "      <td>200,657.2063</td>\n",
       "      <td>1,782,946.1299</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>97,321.5912</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>USDT</td>\n",
       "      <td>72,470.1628</td>\n",
       "      <td>164,246.7936</td>\n",
       "      <td>90,641.6864</td>\n",
       "      <td>2.0000</td>\n",
       "      <td>84,774.6858</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>WBTC</td>\n",
       "      <td>34,397.4106</td>\n",
       "      <td>114,208.4068</td>\n",
       "      <td>90,626.2929</td>\n",
       "      <td>4.0000</td>\n",
       "      <td>77,962.3649</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>MNW</td>\n",
       "      <td>22,144.3191</td>\n",
       "      <td>73,670.5440</td>\n",
       "      <td>69,323.9470</td>\n",
       "      <td>1.0000</td>\n",
       "      <td>74,285.3601</td>\n",
       "      <td>1.0000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  symbol TokensDeposited_usdValue TokensWithdrawn_usdValue  \\\n",
       "0   USDC           5,246,330.1939             105,580.6504   \n",
       "1   WETH           1,947,580.4076             200,657.2063   \n",
       "2   USDT              72,470.1628             164,246.7936   \n",
       "3   WBTC              34,397.4106             114,208.4068   \n",
       "4    MNW              22,144.3191              73,670.5440   \n",
       "\n",
       "   AddressDeposited_usdValue  AddressDeposited_txs  AddressWithdrawn_usdValue  \\\n",
       "0             5,004,874.3054                1.0000               153,807.8307   \n",
       "1             1,782,946.1299                1.0000                97,321.5912   \n",
       "2                90,641.6864                2.0000                84,774.6858   \n",
       "3                90,626.2929                4.0000                77,962.3649   \n",
       "4                69,323.9470                1.0000                74,285.3601   \n",
       "\n",
       "   AddressWithdrawn_txs  \n",
       "0                1.0000  \n",
       "1                1.0000  \n",
       "2                1.0000  \n",
       "3                1.0000  \n",
       "4                1.0000  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get token and volume breakdown for bridge 1 (Polygon PoS) on Polygon\n",
    "# 24hr since 2022-12-25 UTC 00:00 \n",
    "df = obj.get_24h_token_volume_this_bridge(\n",
    "    bridge_id=1, chain='polygon', date='2022-12-25')\n",
    "df.head()"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "id": "db5e950d",
   "metadata": {},
   "source": [
    "## Get all tx (upto 6000 of them) for a bridge within a date range"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "654971eb",
   "metadata": {},
   "outputs": [],
   "source": [
    "fromToAddrs_chains = {\n",
    "    '0x69b4B4390Bd1f0aE84E090Fe8af7AbAd2d95Cc8E':'ethereum',\n",
    "}\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "b836e335",
   "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>tx_hash</th>\n",
       "      <th>ts</th>\n",
       "      <th>tx_block</th>\n",
       "      <th>tx_from</th>\n",
       "      <th>tx_to</th>\n",
       "      <th>token</th>\n",
       "      <th>amount</th>\n",
       "      <th>chain</th>\n",
       "      <th>bridge_name</th>\n",
       "      <th>usd_value</th>\n",
       "      <th>sourceChain</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0x7a7e54dce4a9f2447742c25b9090f504909e63769318...</td>\n",
       "      <td>2022-11-01T21:03:35.000Z</td>\n",
       "      <td>15877738</td>\n",
       "      <td>0x8484Ef722627bf18ca5Ae6BcF031c23E6e922B30</td>\n",
       "      <td>0x69b4B4390Bd1f0aE84E090Fe8af7AbAd2d95Cc8E</td>\n",
       "      <td>0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2</td>\n",
       "      <td>1890000000000000000</td>\n",
       "      <td>ethereum</td>\n",
       "      <td>polygon</td>\n",
       "      <td>None</td>\n",
       "      <td>polygon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0xa75697c79ff728d9f912b5e95987bfe4b4b99252289b...</td>\n",
       "      <td>2022-11-01T20:03:35.000Z</td>\n",
       "      <td>15877442</td>\n",
       "      <td>0x8484Ef722627bf18ca5Ae6BcF031c23E6e922B30</td>\n",
       "      <td>0x69b4B4390Bd1f0aE84E090Fe8af7AbAd2d95Cc8E</td>\n",
       "      <td>0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2</td>\n",
       "      <td>10000000000000000</td>\n",
       "      <td>ethereum</td>\n",
       "      <td>polygon</td>\n",
       "      <td>None</td>\n",
       "      <td>polygon</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             tx_hash  \\\n",
       "0  0x7a7e54dce4a9f2447742c25b9090f504909e63769318...   \n",
       "1  0xa75697c79ff728d9f912b5e95987bfe4b4b99252289b...   \n",
       "\n",
       "                         ts  tx_block  \\\n",
       "0  2022-11-01T21:03:35.000Z  15877738   \n",
       "1  2022-11-01T20:03:35.000Z  15877442   \n",
       "\n",
       "                                      tx_from  \\\n",
       "0  0x8484Ef722627bf18ca5Ae6BcF031c23E6e922B30   \n",
       "1  0x8484Ef722627bf18ca5Ae6BcF031c23E6e922B30   \n",
       "\n",
       "                                        tx_to  \\\n",
       "0  0x69b4B4390Bd1f0aE84E090Fe8af7AbAd2d95Cc8E   \n",
       "1  0x69b4B4390Bd1f0aE84E090Fe8af7AbAd2d95Cc8E   \n",
       "\n",
       "                                        token               amount     chain  \\\n",
       "0  0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2  1890000000000000000  ethereum   \n",
       "1  0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2    10000000000000000  ethereum   \n",
       "\n",
       "  bridge_name usd_value sourceChain  \n",
       "0     polygon      None     polygon  \n",
       "1     polygon      None     polygon  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = obj.get_tx_this_bridge(\n",
    "    bridge_id=1, sourcechain='polygon', \n",
    "    start='2022-11-01', end='2022-11-02', \n",
    "    fromToAddrs_chains=fromToAddrs_chains, limit=200)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ccb90447",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.10.8 64-bit ('3.10.8')",
   "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.10.8"
  },
  "vscode": {
   "interpreter": {
    "hash": "cd871bcb4a3c3b6367e380cf91a83c5d0ddf61f244736b190bbda87038e56a9c"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}