notebooks/defillama_api_stablecoins.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "7b0c3fd5-3eb2-4ae1-b882-f43cfc15e542",
   "metadata": {},
   "outputs": [],
   "source": [
    "from defillama2 import DefiLlama\n",
    "import pandas as pd\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": "markdown",
   "id": "67b52858-1942-46fa-92e1-2077af038d7a",
   "metadata": {},
   "source": [
    "## Create a DefiLlama instance"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "9ec6cbc9-201f-4422-b72f-f8ea85f70179",
   "metadata": {},
   "outputs": [],
   "source": [
    "obj = DefiLlama()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9d737207-8e0f-4d11-9096-13fbe355b66d",
   "metadata": {
    "tags": []
   },
   "source": [
    "## Get all stablecoins along with their circulating amounts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "05d45f9a-03ea-4bee-aadb-19b45c6b33fb",
   "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>name</th>\n",
       "      <th>symbol</th>\n",
       "      <th>gecko_id</th>\n",
       "      <th>pegType</th>\n",
       "      <th>priceSource</th>\n",
       "      <th>pegMechanism</th>\n",
       "      <th>circulating</th>\n",
       "      <th>circulatingPrevDay</th>\n",
       "      <th>circulatingPrevWeek</th>\n",
       "      <th>circulatingPrevMonth</th>\n",
       "      <th>delisted</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Tether</td>\n",
       "      <td>USDT</td>\n",
       "      <td>tether</td>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>chainlink</td>\n",
       "      <td>fiat-backed</td>\n",
       "      <td>66,247,817,799.1612</td>\n",
       "      <td>66,240,295,405.0680</td>\n",
       "      <td>66,237,845,405.0763</td>\n",
       "      <td>65,352,829,102.7940</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>USD Coin</td>\n",
       "      <td>USDC</td>\n",
       "      <td>usd-coin</td>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>chainlink</td>\n",
       "      <td>fiat-backed</td>\n",
       "      <td>44,025,354,434.8006</td>\n",
       "      <td>43,750,700,426.7066</td>\n",
       "      <td>43,812,952,434.3878</td>\n",
       "      <td>43,326,356,104.0751</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>TerraClassicUSD</td>\n",
       "      <td>USTC</td>\n",
       "      <td>terrausd</td>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>chainlink</td>\n",
       "      <td>algorithmic</td>\n",
       "      <td>9,804,476,083.2330</td>\n",
       "      <td>9,804,473,371.7661</td>\n",
       "      <td>9,804,987,647.1193</td>\n",
       "      <td>9,806,349,150.9481</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Binance USD</td>\n",
       "      <td>BUSD</td>\n",
       "      <td>binance-usd</td>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>chainlink</td>\n",
       "      <td>fiat-backed</td>\n",
       "      <td>17,040,976,660.9900</td>\n",
       "      <td>17,199,954,761.2700</td>\n",
       "      <td>18,031,715,419.5600</td>\n",
       "      <td>22,383,281,483.8000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Dai</td>\n",
       "      <td>DAI</td>\n",
       "      <td>dai</td>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>chainlink</td>\n",
       "      <td>crypto-backed</td>\n",
       "      <td>5,078,344,516.6003</td>\n",
       "      <td>5,118,062,999.3735</td>\n",
       "      <td>5,173,951,384.5302</td>\n",
       "      <td>5,185,386,287.2362</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>USDi</td>\n",
       "      <td>USDI</td>\n",
       "      <td>bank-of-chain</td>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>None</td>\n",
       "      <td>crypto-backed</td>\n",
       "      <td>9,129.9648</td>\n",
       "      <td>312,682.1360</td>\n",
       "      <td>313,532.1360</td>\n",
       "      <td>314,242.9467</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>iUSD</td>\n",
       "      <td>IUSD</td>\n",
       "      <td>iusd</td>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>None</td>\n",
       "      <td>crypto-backed</td>\n",
       "      <td>2,723,692.1537</td>\n",
       "      <td>2,715,680.3446</td>\n",
       "      <td>2,651,598.1707</td>\n",
       "      <td>1,756,157.5709</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>XAI</td>\n",
       "      <td>XAI</td>\n",
       "      <td>xai</td>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>uniswap</td>\n",
       "      <td>crypto-backed</td>\n",
       "      <td>3,380,634.6845</td>\n",
       "      <td>3,380,634.6845</td>\n",
       "      <td>3,317,839.3266</td>\n",
       "      <td>1,486,627.4170</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Redeemable USD</td>\n",
       "      <td>RUSD</td>\n",
       "      <td>redeemable</td>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>None</td>\n",
       "      <td>fiat-backed</td>\n",
       "      <td>38,670.4780</td>\n",
       "      <td>38,670.4780</td>\n",
       "      <td>38,670.4780</td>\n",
       "      <td>40,772.4780</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Iron Bank EURO</td>\n",
       "      <td>IBEUR</td>\n",
       "      <td>iron-bank-euro</td>\n",
       "      <td>peggedEUR</td>\n",
       "      <td>coingecko</td>\n",
       "      <td>crypto-backed</td>\n",
       "      <td>44,768,825.8894</td>\n",
       "      <td>44,768,825.8894</td>\n",
       "      <td>44,768,825.8894</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>91 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               name symbol        gecko_id    pegType priceSource  \\\n",
       "id                                                                  \n",
       "1            Tether   USDT          tether  peggedUSD   chainlink   \n",
       "2          USD Coin   USDC        usd-coin  peggedUSD   chainlink   \n",
       "3   TerraClassicUSD   USTC        terrausd  peggedUSD   chainlink   \n",
       "4       Binance USD   BUSD     binance-usd  peggedUSD   chainlink   \n",
       "5               Dai    DAI             dai  peggedUSD   chainlink   \n",
       "..              ...    ...             ...        ...         ...   \n",
       "87             USDi   USDI   bank-of-chain  peggedUSD        None   \n",
       "88             iUSD   IUSD            iusd  peggedUSD        None   \n",
       "89              XAI    XAI             xai  peggedUSD     uniswap   \n",
       "90   Redeemable USD   RUSD      redeemable  peggedUSD        None   \n",
       "91   Iron Bank EURO  IBEUR  iron-bank-euro  peggedEUR   coingecko   \n",
       "\n",
       "     pegMechanism         circulating  circulatingPrevDay  \\\n",
       "id                                                          \n",
       "1     fiat-backed 66,247,817,799.1612 66,240,295,405.0680   \n",
       "2     fiat-backed 44,025,354,434.8006 43,750,700,426.7066   \n",
       "3     algorithmic  9,804,476,083.2330  9,804,473,371.7661   \n",
       "4     fiat-backed 17,040,976,660.9900 17,199,954,761.2700   \n",
       "5   crypto-backed  5,078,344,516.6003  5,118,062,999.3735   \n",
       "..            ...                 ...                 ...   \n",
       "87  crypto-backed          9,129.9648        312,682.1360   \n",
       "88  crypto-backed      2,723,692.1537      2,715,680.3446   \n",
       "89  crypto-backed      3,380,634.6845      3,380,634.6845   \n",
       "90    fiat-backed         38,670.4780         38,670.4780   \n",
       "91  crypto-backed     44,768,825.8894     44,768,825.8894   \n",
       "\n",
       "    circulatingPrevWeek  circulatingPrevMonth delisted  \n",
       "id                                                      \n",
       "1   66,237,845,405.0763   65,352,829,102.7940      NaN  \n",
       "2   43,812,952,434.3878   43,326,356,104.0751      NaN  \n",
       "3    9,804,987,647.1193    9,806,349,150.9481      NaN  \n",
       "4   18,031,715,419.5600   22,383,281,483.8000      NaN  \n",
       "5    5,173,951,384.5302    5,185,386,287.2362      NaN  \n",
       "..                  ...                   ...      ...  \n",
       "87         313,532.1360          314,242.9467      NaN  \n",
       "88       2,651,598.1707        1,756,157.5709      NaN  \n",
       "89       3,317,839.3266        1,486,627.4170      NaN  \n",
       "90          38,670.4780           40,772.4780      NaN  \n",
       "91      44,768,825.8894                0.0000      NaN  \n",
       "\n",
       "[91 rows x 11 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "obj.get_stablecoins_circulating()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "73d6672b-4c6b-4adb-ae56-d91188209275",
   "metadata": {},
   "outputs": [],
   "source": [
    "dd = obj.get_stablecoins_circulating_by_chain()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "81335faa-8739-4c32-a958-3bf10137293f",
   "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>type</th>\n",
       "      <th>current</th>\n",
       "      <th>circulatingPrevDay</th>\n",
       "      <th>circulatingPrevWeek</th>\n",
       "      <th>circulatingPrevMonth</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>chain</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Optimism</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>127,065,266.8205</td>\n",
       "      <td>127,042,876.0433</td>\n",
       "      <td>120,056,896.5781</td>\n",
       "      <td>99,509,597.8409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Statemine</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>3,490,005.0000</td>\n",
       "      <td>3,490,005.0000</td>\n",
       "      <td>3,490,005.0000</td>\n",
       "      <td>3,490,005.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Harmony</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BSC</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>3,179,744,100.3967</td>\n",
       "      <td>3,179,739,805.1821</td>\n",
       "      <td>3,179,752,145.4860</td>\n",
       "      <td>4,479,765,842.2971</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dogechain</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>360,271.6605</td>\n",
       "      <td>360,271.6605</td>\n",
       "      <td>360,271.6605</td>\n",
       "      <td>494,886.0037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Theta</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>132.4231</td>\n",
       "      <td>132.4231</td>\n",
       "      <td>132.4231</td>\n",
       "      <td>132.4231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NEO</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>5,856,926.0000</td>\n",
       "      <td>5,856,926.0000</td>\n",
       "      <td>6,855,446.0000</td>\n",
       "      <td>6,855,446.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Syscoin</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>84,863.3280</td>\n",
       "      <td>84,863.3280</td>\n",
       "      <td>84,863.3280</td>\n",
       "      <td>84,782.6868</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Solana</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>798,201,433.2764</td>\n",
       "      <td>798,183,856.7949</td>\n",
       "      <td>800,174,038.7217</td>\n",
       "      <td>800,300,773.8662</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Everscale</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>880,002.1300</td>\n",
       "      <td>951,238.0220</td>\n",
       "      <td>1,035,191.7874</td>\n",
       "      <td>1,571,268.8103</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                type            current  circulatingPrevDay  \\\n",
       "chain                                                         \n",
       "Optimism   peggedUSD   127,065,266.8205    127,042,876.0433   \n",
       "Statemine  peggedUSD     3,490,005.0000      3,490,005.0000   \n",
       "Harmony    peggedUSD             0.0000              0.0000   \n",
       "BSC        peggedUSD 3,179,744,100.3967  3,179,739,805.1821   \n",
       "Dogechain  peggedUSD       360,271.6605        360,271.6605   \n",
       "...              ...                ...                 ...   \n",
       "Theta      peggedUSD           132.4231            132.4231   \n",
       "NEO        peggedUSD     5,856,926.0000      5,856,926.0000   \n",
       "Syscoin    peggedUSD        84,863.3280         84,863.3280   \n",
       "Solana     peggedUSD   798,201,433.2764    798,183,856.7949   \n",
       "Everscale  peggedUSD       880,002.1300        951,238.0220   \n",
       "\n",
       "           circulatingPrevWeek  circulatingPrevMonth  \n",
       "chain                                                 \n",
       "Optimism      120,056,896.5781       99,509,597.8409  \n",
       "Statemine       3,490,005.0000        3,490,005.0000  \n",
       "Harmony                 0.0000                0.0000  \n",
       "BSC         3,179,752,145.4860    4,479,765,842.2971  \n",
       "Dogechain         360,271.6605          494,886.0037  \n",
       "...                        ...                   ...  \n",
       "Theta                 132.4231              132.4231  \n",
       "NEO             6,855,446.0000        6,855,446.0000  \n",
       "Syscoin            84,863.3280           84,782.6868  \n",
       "Solana        800,174,038.7217      800,300,773.8662  \n",
       "Everscale       1,035,191.7874        1,571,268.8103  \n",
       "\n",
       "[61 rows x 5 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dd['USDT']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "fb330c7f-c5ff-4984-803b-83dfe4bfbc5a",
   "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>type</th>\n",
       "      <th>current</th>\n",
       "      <th>circulatingPrevDay</th>\n",
       "      <th>circulatingPrevWeek</th>\n",
       "      <th>circulatingPrevMonth</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>chain</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Optimism</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>269,753,727.9282</td>\n",
       "      <td>271,357,512.5059</td>\n",
       "      <td>275,716,914.4591</td>\n",
       "      <td>291,052,379.3769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DFK</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>2,806,731.7566</td>\n",
       "      <td>2,841,867.8544</td>\n",
       "      <td>2,873,372.8043</td>\n",
       "      <td>3,584,697.7289</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kadena</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BSC</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>881,978,432.0586</td>\n",
       "      <td>881,978,906.8691</td>\n",
       "      <td>882,000,129.7985</td>\n",
       "      <td>881,990,518.6057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Flow</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>12,917,662.0000</td>\n",
       "      <td>11,950,502.0000</td>\n",
       "      <td>12,289,237.0000</td>\n",
       "      <td>13,055,308.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Syscoin</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>479,602.0793</td>\n",
       "      <td>486,126.2893</td>\n",
       "      <td>486,126.2893</td>\n",
       "      <td>503,299.3693</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Solana</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>1,011,927,729.6296</td>\n",
       "      <td>998,063,857.8678</td>\n",
       "      <td>1,001,525,143.3265</td>\n",
       "      <td>1,172,337,133.6302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ronin</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>32,945,939.6023</td>\n",
       "      <td>32,945,939.6023</td>\n",
       "      <td>32,945,939.6023</td>\n",
       "      <td>32,945,939.6023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Elrond</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>36,839,351.5246</td>\n",
       "      <td>37,135,898.5246</td>\n",
       "      <td>38,758,915.7803</td>\n",
       "      <td>38,972,551.4862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Everscale</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>1,608.7478</td>\n",
       "      <td>1,608.7478</td>\n",
       "      <td>1,587.7478</td>\n",
       "      <td>18,991.7916</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>59 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                type            current  circulatingPrevDay  \\\n",
       "chain                                                         \n",
       "Optimism   peggedUSD   269,753,727.9282    271,357,512.5059   \n",
       "DFK        peggedUSD     2,806,731.7566      2,841,867.8544   \n",
       "Kadena     peggedUSD             0.0000              0.0000   \n",
       "BSC        peggedUSD   881,978,432.0586    881,978,906.8691   \n",
       "Flow       peggedUSD    12,917,662.0000     11,950,502.0000   \n",
       "...              ...                ...                 ...   \n",
       "Syscoin    peggedUSD       479,602.0793        486,126.2893   \n",
       "Solana     peggedUSD 1,011,927,729.6296    998,063,857.8678   \n",
       "Ronin      peggedUSD    32,945,939.6023     32,945,939.6023   \n",
       "Elrond     peggedUSD    36,839,351.5246     37,135,898.5246   \n",
       "Everscale  peggedUSD         1,608.7478          1,608.7478   \n",
       "\n",
       "           circulatingPrevWeek  circulatingPrevMonth  \n",
       "chain                                                 \n",
       "Optimism      275,716,914.4591      291,052,379.3769  \n",
       "DFK             2,873,372.8043        3,584,697.7289  \n",
       "Kadena                  0.0000                0.0000  \n",
       "BSC           882,000,129.7985      881,990,518.6057  \n",
       "Flow           12,289,237.0000       13,055,308.0000  \n",
       "...                        ...                   ...  \n",
       "Syscoin           486,126.2893          503,299.3693  \n",
       "Solana      1,001,525,143.3265    1,172,337,133.6302  \n",
       "Ronin          32,945,939.6023       32,945,939.6023  \n",
       "Elrond         38,758,915.7803       38,972,551.4862  \n",
       "Everscale           1,587.7478           18,991.7916  \n",
       "\n",
       "[59 rows x 5 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dd['USDC']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "ba971891-38a8-437f-abd8-9969ef03ae2f",
   "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>type</th>\n",
       "      <th>current</th>\n",
       "      <th>circulatingPrevDay</th>\n",
       "      <th>circulatingPrevWeek</th>\n",
       "      <th>circulatingPrevMonth</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>chain</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Ethereum</th>\n",
       "      <td>peggedEUR</td>\n",
       "      <td>5010</td>\n",
       "      <td>5010</td>\n",
       "      <td>5010</td>\n",
       "      <td>5010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tezos</th>\n",
       "      <td>peggedEUR</td>\n",
       "      <td>4250000</td>\n",
       "      <td>4250000</td>\n",
       "      <td>4450000</td>\n",
       "      <td>5255000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               type  current  circulatingPrevDay  circulatingPrevWeek  \\\n",
       "chain                                                                   \n",
       "Ethereum  peggedEUR     5010                5010                 5010   \n",
       "Tezos     peggedEUR  4250000             4250000              4450000   \n",
       "\n",
       "          circulatingPrevMonth  \n",
       "chain                           \n",
       "Ethereum                  5010  \n",
       "Tezos                  5255000  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dd['EURL']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "04f7a8df-d7c4-48ab-956e-fc2fb2abe5be",
   "metadata": {
    "tags": []
   },
   "source": [
    "## Get all available historical mcaps of a stablecoin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "d76f3837-99d2-460c-8904-d77cf25d1b61",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "id\n",
       "1              Tether\n",
       "2            USD Coin\n",
       "3     TerraClassicUSD\n",
       "4         Binance USD\n",
       "5                 Dai\n",
       "           ...       \n",
       "87               USDi\n",
       "88               iUSD\n",
       "89                XAI\n",
       "90     Redeemable USD\n",
       "91     Iron Bank EURO\n",
       "Name: name, Length: 91, dtype: object"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# get stablecoin ids\n",
    "df = obj.get_stablecoins_circulating()\n",
    "ss = df.loc[:, 'name']\n",
    "ss"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "b4e83e13-4f66-4967-b70e-2197fdeacd5c",
   "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>totalCirculating</th>\n",
       "      <th>totalUnreleased</th>\n",
       "      <th>totalCirculatingUSD</th>\n",
       "      <th>totalMintedUSD</th>\n",
       "      <th>totalBridgedToUSD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-12-31 00:00:00+00:00</th>\n",
       "      <td>20,920,738,588.9900</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>20,953,468,827.6900</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-01 00:00:00+00:00</th>\n",
       "      <td>20,934,027,063.0400</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>20,935,116,985.4900</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-02 00:00:00+00:00</th>\n",
       "      <td>21,123,644,615.3900</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>21,165,735,737.9300</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-03 00:00:00+00:00</th>\n",
       "      <td>21,202,977,966.9700</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>21,269,142,057.2400</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-04 00:00:00+00:00</th>\n",
       "      <td>21,350,523,809.2800</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>21,365,921,518.0800</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-25 00:00:00+00:00</th>\n",
       "      <td>66,237,795,405.0700</td>\n",
       "      <td>7,015,982,829.8900</td>\n",
       "      <td>66,237,795,405.0700</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-26 00:00:00+00:00</th>\n",
       "      <td>66,237,795,405.0700</td>\n",
       "      <td>7,015,982,829.8900</td>\n",
       "      <td>66,237,795,405.0700</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-27 00:00:00+00:00</th>\n",
       "      <td>66,240,295,405.0700</td>\n",
       "      <td>7,013,482,829.8900</td>\n",
       "      <td>66,240,744,514.2700</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-28 00:00:00+00:00</th>\n",
       "      <td>66,240,295,405.0700</td>\n",
       "      <td>7,013,482,829.8900</td>\n",
       "      <td>66,220,423,316.4500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-29 00:00:00+00:00</th>\n",
       "      <td>66,247,817,799.1600</td>\n",
       "      <td>7,005,960,435.8000</td>\n",
       "      <td>66,221,318,672.0400</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>729 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             totalCirculating    totalUnreleased  \\\n",
       "date                                                               \n",
       "2020-12-31 00:00:00+00:00 20,920,738,588.9900             0.0000   \n",
       "2021-01-01 00:00:00+00:00 20,934,027,063.0400             0.0000   \n",
       "2021-01-02 00:00:00+00:00 21,123,644,615.3900             0.0000   \n",
       "2021-01-03 00:00:00+00:00 21,202,977,966.9700             0.0000   \n",
       "2021-01-04 00:00:00+00:00 21,350,523,809.2800             0.0000   \n",
       "...                                       ...                ...   \n",
       "2022-12-25 00:00:00+00:00 66,237,795,405.0700 7,015,982,829.8900   \n",
       "2022-12-26 00:00:00+00:00 66,237,795,405.0700 7,015,982,829.8900   \n",
       "2022-12-27 00:00:00+00:00 66,240,295,405.0700 7,013,482,829.8900   \n",
       "2022-12-28 00:00:00+00:00 66,240,295,405.0700 7,013,482,829.8900   \n",
       "2022-12-29 00:00:00+00:00 66,247,817,799.1600 7,005,960,435.8000   \n",
       "\n",
       "                           totalCirculatingUSD  totalMintedUSD  \\\n",
       "date                                                             \n",
       "2020-12-31 00:00:00+00:00  20,953,468,827.6900               0   \n",
       "2021-01-01 00:00:00+00:00  20,935,116,985.4900               0   \n",
       "2021-01-02 00:00:00+00:00  21,165,735,737.9300               0   \n",
       "2021-01-03 00:00:00+00:00  21,269,142,057.2400               0   \n",
       "2021-01-04 00:00:00+00:00  21,365,921,518.0800               0   \n",
       "...                                        ...             ...   \n",
       "2022-12-25 00:00:00+00:00  66,237,795,405.0700               0   \n",
       "2022-12-26 00:00:00+00:00  66,237,795,405.0700               0   \n",
       "2022-12-27 00:00:00+00:00  66,240,744,514.2700               0   \n",
       "2022-12-28 00:00:00+00:00  66,220,423,316.4500               0   \n",
       "2022-12-29 00:00:00+00:00  66,221,318,672.0400               0   \n",
       "\n",
       "                           totalBridgedToUSD  \n",
       "date                                          \n",
       "2020-12-31 00:00:00+00:00                  0  \n",
       "2021-01-01 00:00:00+00:00                  0  \n",
       "2021-01-02 00:00:00+00:00                  0  \n",
       "2021-01-03 00:00:00+00:00                  0  \n",
       "2021-01-04 00:00:00+00:00                  0  \n",
       "...                                      ...  \n",
       "2022-12-25 00:00:00+00:00                  0  \n",
       "2022-12-26 00:00:00+00:00                  0  \n",
       "2022-12-27 00:00:00+00:00                  0  \n",
       "2022-12-28 00:00:00+00:00                  0  \n",
       "2022-12-29 00:00:00+00:00                  0  \n",
       "\n",
       "[729 rows x 5 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "obj.get_stablecoin_hist_mcap(1) # USDT"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "c194e651-c0b9-4c10-b854-b06cbefa875c",
   "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>totalCirculating</th>\n",
       "      <th>totalUnreleased</th>\n",
       "      <th>totalCirculatingUSD</th>\n",
       "      <th>totalMintedUSD</th>\n",
       "      <th>totalBridgedToUSD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-12-31 00:00:00+00:00</th>\n",
       "      <td>3,705,248,341.6800</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>3,707,668,173.7100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-01 00:00:00+00:00</th>\n",
       "      <td>3,925,840,105.2100</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>3,931,691,995.7100</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-02 00:00:00+00:00</th>\n",
       "      <td>4,123,724,902.2300</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>4,121,592,025.5800</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-03 00:00:00+00:00</th>\n",
       "      <td>4,128,120,369.1500</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>4,138,858,681.0700</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-04 00:00:00+00:00</th>\n",
       "      <td>4,227,905,606.0200</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>4,213,378,134.3500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-25 00:00:00+00:00</th>\n",
       "      <td>43,824,498,694.7400</td>\n",
       "      <td>4,436,080,302.2300</td>\n",
       "      <td>43,827,409,517.9500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-26 00:00:00+00:00</th>\n",
       "      <td>43,932,373,714.1500</td>\n",
       "      <td>4,458,224,616.0000</td>\n",
       "      <td>43,949,199,813.2900</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-27 00:00:00+00:00</th>\n",
       "      <td>44,029,716,308.8600</td>\n",
       "      <td>4,480,670,487.8700</td>\n",
       "      <td>44,034,361,884.2300</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-28 00:00:00+00:00</th>\n",
       "      <td>43,733,866,515.4700</td>\n",
       "      <td>4,504,184,362.7900</td>\n",
       "      <td>43,734,867,583.6800</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-29 00:00:00+00:00</th>\n",
       "      <td>44,025,354,434.8000</td>\n",
       "      <td>4,461,029,188.7300</td>\n",
       "      <td>44,022,687,819.0800</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>729 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             totalCirculating    totalUnreleased  \\\n",
       "date                                                               \n",
       "2020-12-31 00:00:00+00:00  3,705,248,341.6800             0.0000   \n",
       "2021-01-01 00:00:00+00:00  3,925,840,105.2100             0.0000   \n",
       "2021-01-02 00:00:00+00:00  4,123,724,902.2300             0.0000   \n",
       "2021-01-03 00:00:00+00:00  4,128,120,369.1500             0.0000   \n",
       "2021-01-04 00:00:00+00:00  4,227,905,606.0200             0.0000   \n",
       "...                                       ...                ...   \n",
       "2022-12-25 00:00:00+00:00 43,824,498,694.7400 4,436,080,302.2300   \n",
       "2022-12-26 00:00:00+00:00 43,932,373,714.1500 4,458,224,616.0000   \n",
       "2022-12-27 00:00:00+00:00 44,029,716,308.8600 4,480,670,487.8700   \n",
       "2022-12-28 00:00:00+00:00 43,733,866,515.4700 4,504,184,362.7900   \n",
       "2022-12-29 00:00:00+00:00 44,025,354,434.8000 4,461,029,188.7300   \n",
       "\n",
       "                           totalCirculatingUSD  totalMintedUSD  \\\n",
       "date                                                             \n",
       "2020-12-31 00:00:00+00:00   3,707,668,173.7100               0   \n",
       "2021-01-01 00:00:00+00:00   3,931,691,995.7100               0   \n",
       "2021-01-02 00:00:00+00:00   4,121,592,025.5800               0   \n",
       "2021-01-03 00:00:00+00:00   4,138,858,681.0700               0   \n",
       "2021-01-04 00:00:00+00:00   4,213,378,134.3500               0   \n",
       "...                                        ...             ...   \n",
       "2022-12-25 00:00:00+00:00  43,827,409,517.9500               0   \n",
       "2022-12-26 00:00:00+00:00  43,949,199,813.2900               0   \n",
       "2022-12-27 00:00:00+00:00  44,034,361,884.2300               0   \n",
       "2022-12-28 00:00:00+00:00  43,734,867,583.6800               0   \n",
       "2022-12-29 00:00:00+00:00  44,022,687,819.0800               0   \n",
       "\n",
       "                           totalBridgedToUSD  \n",
       "date                                          \n",
       "2020-12-31 00:00:00+00:00                  0  \n",
       "2021-01-01 00:00:00+00:00                  0  \n",
       "2021-01-02 00:00:00+00:00                  0  \n",
       "2021-01-03 00:00:00+00:00                  0  \n",
       "2021-01-04 00:00:00+00:00                  0  \n",
       "...                                      ...  \n",
       "2022-12-25 00:00:00+00:00                  0  \n",
       "2022-12-26 00:00:00+00:00                  0  \n",
       "2022-12-27 00:00:00+00:00                  0  \n",
       "2022-12-28 00:00:00+00:00                  0  \n",
       "2022-12-29 00:00:00+00:00                  0  \n",
       "\n",
       "[729 rows x 5 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "obj.get_stablecoin_hist_mcap(2) # USDC"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "39eaa109-2f70-47fb-9a55-414cf3508f77",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Frax id: 6\n"
     ]
    },
    {
     "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>totalCirculating</th>\n",
       "      <th>totalUnreleased</th>\n",
       "      <th>totalCirculatingUSD</th>\n",
       "      <th>totalMintedUSD</th>\n",
       "      <th>totalBridgedToUSD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-12-31 00:00:00+00:00</th>\n",
       "      <td>56,528,801.3100</td>\n",
       "      <td>0</td>\n",
       "      <td>56,913,397.5200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-01 00:00:00+00:00</th>\n",
       "      <td>57,389,050.4700</td>\n",
       "      <td>0</td>\n",
       "      <td>57,182,625.2800</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-02 00:00:00+00:00</th>\n",
       "      <td>71,772,627.9200</td>\n",
       "      <td>0</td>\n",
       "      <td>72,715,225.4600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-03 00:00:00+00:00</th>\n",
       "      <td>78,289,715.7600</td>\n",
       "      <td>0</td>\n",
       "      <td>79,285,756.9200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-04 00:00:00+00:00</th>\n",
       "      <td>78,876,977.8700</td>\n",
       "      <td>0</td>\n",
       "      <td>79,385,984.5500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-25 00:00:00+00:00</th>\n",
       "      <td>1,018,393,133.2600</td>\n",
       "      <td>0</td>\n",
       "      <td>1,017,741,035.7700</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-26 00:00:00+00:00</th>\n",
       "      <td>1,018,393,133.2600</td>\n",
       "      <td>0</td>\n",
       "      <td>1,017,468,432.2900</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-27 00:00:00+00:00</th>\n",
       "      <td>1,018,393,133.2600</td>\n",
       "      <td>0</td>\n",
       "      <td>1,017,775,518.5600</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-28 00:00:00+00:00</th>\n",
       "      <td>1,018,393,133.2600</td>\n",
       "      <td>0</td>\n",
       "      <td>1,017,365,421.8300</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-29 00:00:00+00:00</th>\n",
       "      <td>1,018,393,133.2600</td>\n",
       "      <td>0</td>\n",
       "      <td>1,018,042,164.4300</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>729 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            totalCirculating  totalUnreleased  \\\n",
       "date                                                            \n",
       "2020-12-31 00:00:00+00:00    56,528,801.3100                0   \n",
       "2021-01-01 00:00:00+00:00    57,389,050.4700                0   \n",
       "2021-01-02 00:00:00+00:00    71,772,627.9200                0   \n",
       "2021-01-03 00:00:00+00:00    78,289,715.7600                0   \n",
       "2021-01-04 00:00:00+00:00    78,876,977.8700                0   \n",
       "...                                      ...              ...   \n",
       "2022-12-25 00:00:00+00:00 1,018,393,133.2600                0   \n",
       "2022-12-26 00:00:00+00:00 1,018,393,133.2600                0   \n",
       "2022-12-27 00:00:00+00:00 1,018,393,133.2600                0   \n",
       "2022-12-28 00:00:00+00:00 1,018,393,133.2600                0   \n",
       "2022-12-29 00:00:00+00:00 1,018,393,133.2600                0   \n",
       "\n",
       "                           totalCirculatingUSD  totalMintedUSD  \\\n",
       "date                                                             \n",
       "2020-12-31 00:00:00+00:00      56,913,397.5200               0   \n",
       "2021-01-01 00:00:00+00:00      57,182,625.2800               0   \n",
       "2021-01-02 00:00:00+00:00      72,715,225.4600               0   \n",
       "2021-01-03 00:00:00+00:00      79,285,756.9200               0   \n",
       "2021-01-04 00:00:00+00:00      79,385,984.5500               0   \n",
       "...                                        ...             ...   \n",
       "2022-12-25 00:00:00+00:00   1,017,741,035.7700               0   \n",
       "2022-12-26 00:00:00+00:00   1,017,468,432.2900               0   \n",
       "2022-12-27 00:00:00+00:00   1,017,775,518.5600               0   \n",
       "2022-12-28 00:00:00+00:00   1,017,365,421.8300               0   \n",
       "2022-12-29 00:00:00+00:00   1,018,042,164.4300               0   \n",
       "\n",
       "                           totalBridgedToUSD  \n",
       "date                                          \n",
       "2020-12-31 00:00:00+00:00                  0  \n",
       "2021-01-01 00:00:00+00:00                  0  \n",
       "2021-01-02 00:00:00+00:00                  0  \n",
       "2021-01-03 00:00:00+00:00                  0  \n",
       "2021-01-04 00:00:00+00:00                  0  \n",
       "...                                      ...  \n",
       "2022-12-25 00:00:00+00:00                  0  \n",
       "2022-12-26 00:00:00+00:00                  0  \n",
       "2022-12-27 00:00:00+00:00                  0  \n",
       "2022-12-28 00:00:00+00:00                  0  \n",
       "2022-12-29 00:00:00+00:00                  0  \n",
       "\n",
       "[729 rows x 5 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "frax_id = ss.index[ss == 'Frax'].values[0]\n",
    "print('Frax id:', frax_id)\n",
    "obj.get_stablecoin_hist_mcap(frax_id) # Frax"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bce33ee0-730a-45c9-82d7-3d3efa365bab",
   "metadata": {
    "tags": []
   },
   "source": [
    "## Get all available historical mcaps of a stablecoin on a particular chain"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "2c96edfb-a0b7-4f7b-a763-e7b512715158",
   "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>totalCirculating</th>\n",
       "      <th>totalUnreleased</th>\n",
       "      <th>totalCirculatingUSD</th>\n",
       "      <th>totalMintedUSD</th>\n",
       "      <th>totalBridgedToUSD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-12-31 00:00:00+00:00</th>\n",
       "      <td>12,962,834,369.9600</td>\n",
       "      <td>35,442,117.5700</td>\n",
       "      <td>12,983,114,565.2000</td>\n",
       "      <td>13,227,232,922.6700</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-01 00:00:00+00:00</th>\n",
       "      <td>13,127,933,832.9700</td>\n",
       "      <td>159,742,117.5700</td>\n",
       "      <td>13,128,617,334.0400</td>\n",
       "      <td>13,382,968,146.8900</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-02 00:00:00+00:00</th>\n",
       "      <td>13,118,372,135.7200</td>\n",
       "      <td>164,742,117.5800</td>\n",
       "      <td>13,144,511,896.1200</td>\n",
       "      <td>13,403,927,048.7200</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-03 00:00:00+00:00</th>\n",
       "      <td>13,126,053,611.9300</td>\n",
       "      <td>146,742,117.5800</td>\n",
       "      <td>13,167,013,584.5100</td>\n",
       "      <td>13,437,071,473.0300</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-04 00:00:00+00:00</th>\n",
       "      <td>13,266,134,880.8600</td>\n",
       "      <td>35,742,117.5800</td>\n",
       "      <td>13,275,702,237.7900</td>\n",
       "      <td>13,516,011,943.9500</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-25 00:00:00+00:00</th>\n",
       "      <td>27,995,409,611.5600</td>\n",
       "      <td>1,562,016,547.9600</td>\n",
       "      <td>27,995,409,611.5600</td>\n",
       "      <td>30,735,349,974.0300</td>\n",
       "      <td>68,675.4400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-26 00:00:00+00:00</th>\n",
       "      <td>27,992,275,925.0300</td>\n",
       "      <td>1,562,016,547.9600</td>\n",
       "      <td>27,992,275,925.0300</td>\n",
       "      <td>30,735,349,974.0300</td>\n",
       "      <td>68,675.4400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-27 00:00:00+00:00</th>\n",
       "      <td>27,992,732,989.5600</td>\n",
       "      <td>1,560,216,547.9600</td>\n",
       "      <td>27,992,922,780.2900</td>\n",
       "      <td>30,737,358,371.9100</td>\n",
       "      <td>68,675.9000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-28 00:00:00+00:00</th>\n",
       "      <td>27,992,336,462.4700</td>\n",
       "      <td>1,560,216,547.9600</td>\n",
       "      <td>27,983,938,761.5400</td>\n",
       "      <td>30,727,928,829.0400</td>\n",
       "      <td>68,654.8300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-29 00:00:00+00:00</th>\n",
       "      <td>27,983,055,209.4300</td>\n",
       "      <td>1,572,694,153.8600</td>\n",
       "      <td>27,971,861,987.3500</td>\n",
       "      <td>30,712,382,499.1900</td>\n",
       "      <td>68,647.9700</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>729 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             totalCirculating    totalUnreleased  \\\n",
       "date                                                               \n",
       "2020-12-31 00:00:00+00:00 12,962,834,369.9600    35,442,117.5700   \n",
       "2021-01-01 00:00:00+00:00 13,127,933,832.9700   159,742,117.5700   \n",
       "2021-01-02 00:00:00+00:00 13,118,372,135.7200   164,742,117.5800   \n",
       "2021-01-03 00:00:00+00:00 13,126,053,611.9300   146,742,117.5800   \n",
       "2021-01-04 00:00:00+00:00 13,266,134,880.8600    35,742,117.5800   \n",
       "...                                       ...                ...   \n",
       "2022-12-25 00:00:00+00:00 27,995,409,611.5600 1,562,016,547.9600   \n",
       "2022-12-26 00:00:00+00:00 27,992,275,925.0300 1,562,016,547.9600   \n",
       "2022-12-27 00:00:00+00:00 27,992,732,989.5600 1,560,216,547.9600   \n",
       "2022-12-28 00:00:00+00:00 27,992,336,462.4700 1,560,216,547.9600   \n",
       "2022-12-29 00:00:00+00:00 27,983,055,209.4300 1,572,694,153.8600   \n",
       "\n",
       "                           totalCirculatingUSD      totalMintedUSD  \\\n",
       "date                                                                 \n",
       "2020-12-31 00:00:00+00:00  12,983,114,565.2000 13,227,232,922.6700   \n",
       "2021-01-01 00:00:00+00:00  13,128,617,334.0400 13,382,968,146.8900   \n",
       "2021-01-02 00:00:00+00:00  13,144,511,896.1200 13,403,927,048.7200   \n",
       "2021-01-03 00:00:00+00:00  13,167,013,584.5100 13,437,071,473.0300   \n",
       "2021-01-04 00:00:00+00:00  13,275,702,237.7900 13,516,011,943.9500   \n",
       "...                                        ...                 ...   \n",
       "2022-12-25 00:00:00+00:00  27,995,409,611.5600 30,735,349,974.0300   \n",
       "2022-12-26 00:00:00+00:00  27,992,275,925.0300 30,735,349,974.0300   \n",
       "2022-12-27 00:00:00+00:00  27,992,922,780.2900 30,737,358,371.9100   \n",
       "2022-12-28 00:00:00+00:00  27,983,938,761.5400 30,727,928,829.0400   \n",
       "2022-12-29 00:00:00+00:00  27,971,861,987.3500 30,712,382,499.1900   \n",
       "\n",
       "                           totalBridgedToUSD  \n",
       "date                                          \n",
       "2020-12-31 00:00:00+00:00             0.0000  \n",
       "2021-01-01 00:00:00+00:00             0.0000  \n",
       "2021-01-02 00:00:00+00:00             0.0000  \n",
       "2021-01-03 00:00:00+00:00             0.0000  \n",
       "2021-01-04 00:00:00+00:00             0.0000  \n",
       "...                                      ...  \n",
       "2022-12-25 00:00:00+00:00        68,675.4400  \n",
       "2022-12-26 00:00:00+00:00        68,675.4400  \n",
       "2022-12-27 00:00:00+00:00        68,675.9000  \n",
       "2022-12-28 00:00:00+00:00        68,654.8300  \n",
       "2022-12-29 00:00:00+00:00        68,647.9700  \n",
       "\n",
       "[729 rows x 5 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "obj.get_stablecoin_hist_mcap_on_a_chain(1, 'ethereum') # USDT on ethereum"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "2d637adc-808d-47e2-80b6-8ccd72cc6444",
   "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>totalCirculating</th>\n",
       "      <th>totalUnreleased</th>\n",
       "      <th>totalCirculatingUSD</th>\n",
       "      <th>totalMintedUSD</th>\n",
       "      <th>totalBridgedToUSD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-12-31 00:00:00+00:00</th>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-01 00:00:00+00:00</th>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-02 00:00:00+00:00</th>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-03 00:00:00+00:00</th>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-01-04 00:00:00+00:00</th>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-25 00:00:00+00:00</th>\n",
       "      <td>638,051,391.4400</td>\n",
       "      <td>0</td>\n",
       "      <td>638,093,770.8200</td>\n",
       "      <td>0</td>\n",
       "      <td>638,093,770.8200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-26 00:00:00+00:00</th>\n",
       "      <td>638,119,738.7700</td>\n",
       "      <td>0</td>\n",
       "      <td>638,364,138.6300</td>\n",
       "      <td>0</td>\n",
       "      <td>638,364,138.6300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-27 00:00:00+00:00</th>\n",
       "      <td>640,200,062.0700</td>\n",
       "      <td>0</td>\n",
       "      <td>640,267,609.5800</td>\n",
       "      <td>0</td>\n",
       "      <td>640,267,609.5800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-28 00:00:00+00:00</th>\n",
       "      <td>640,256,481.1400</td>\n",
       "      <td>0</td>\n",
       "      <td>640,271,136.6200</td>\n",
       "      <td>0</td>\n",
       "      <td>640,271,136.6200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-29 00:00:00+00:00</th>\n",
       "      <td>630,515,114.5500</td>\n",
       "      <td>0</td>\n",
       "      <td>630,476,924.2500</td>\n",
       "      <td>0</td>\n",
       "      <td>630,476,924.2500</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>729 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           totalCirculating  totalUnreleased  \\\n",
       "date                                                           \n",
       "2020-12-31 00:00:00+00:00            0.0000                0   \n",
       "2021-01-01 00:00:00+00:00            0.0000                0   \n",
       "2021-01-02 00:00:00+00:00            0.0000                0   \n",
       "2021-01-03 00:00:00+00:00            0.0000                0   \n",
       "2021-01-04 00:00:00+00:00            0.0000                0   \n",
       "...                                     ...              ...   \n",
       "2022-12-25 00:00:00+00:00  638,051,391.4400                0   \n",
       "2022-12-26 00:00:00+00:00  638,119,738.7700                0   \n",
       "2022-12-27 00:00:00+00:00  640,200,062.0700                0   \n",
       "2022-12-28 00:00:00+00:00  640,256,481.1400                0   \n",
       "2022-12-29 00:00:00+00:00  630,515,114.5500                0   \n",
       "\n",
       "                           totalCirculatingUSD  totalMintedUSD  \\\n",
       "date                                                             \n",
       "2020-12-31 00:00:00+00:00               0.0000               0   \n",
       "2021-01-01 00:00:00+00:00               0.0000               0   \n",
       "2021-01-02 00:00:00+00:00               0.0000               0   \n",
       "2021-01-03 00:00:00+00:00               0.0000               0   \n",
       "2021-01-04 00:00:00+00:00               0.0000               0   \n",
       "...                                        ...             ...   \n",
       "2022-12-25 00:00:00+00:00     638,093,770.8200               0   \n",
       "2022-12-26 00:00:00+00:00     638,364,138.6300               0   \n",
       "2022-12-27 00:00:00+00:00     640,267,609.5800               0   \n",
       "2022-12-28 00:00:00+00:00     640,271,136.6200               0   \n",
       "2022-12-29 00:00:00+00:00     630,476,924.2500               0   \n",
       "\n",
       "                           totalBridgedToUSD  \n",
       "date                                          \n",
       "2020-12-31 00:00:00+00:00             0.0000  \n",
       "2021-01-01 00:00:00+00:00             0.0000  \n",
       "2021-01-02 00:00:00+00:00             0.0000  \n",
       "2021-01-03 00:00:00+00:00             0.0000  \n",
       "2021-01-04 00:00:00+00:00             0.0000  \n",
       "...                                      ...  \n",
       "2022-12-25 00:00:00+00:00   638,093,770.8200  \n",
       "2022-12-26 00:00:00+00:00   638,364,138.6300  \n",
       "2022-12-27 00:00:00+00:00   640,267,609.5800  \n",
       "2022-12-28 00:00:00+00:00   640,271,136.6200  \n",
       "2022-12-29 00:00:00+00:00   630,476,924.2500  \n",
       "\n",
       "[729 rows x 5 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "obj.get_stablecoin_hist_mcap_on_a_chain(2, 'arbitrum') # USDC on arbitrum"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8fe74abb-affa-4d0b-b13f-1eab65cd8f22",
   "metadata": {
    "tags": []
   },
   "source": [
    "## Get current total mcap of all stablecoins on each chain."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "d48a142e-2694-4627-a1ea-7d797048155d",
   "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>type</th>\n",
       "      <th>totalCirculatingUSD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>chain</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Optimism</th>\n",
       "      <td>peggedEUR</td>\n",
       "      <td>869,407.6775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Optimism</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>532,093,990.6032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Optimism</th>\n",
       "      <td>peggedVAR</td>\n",
       "      <td>46,527.9036</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>DFK</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>2,806,576.6581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kadena</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>384.1072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mixin</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Kujira</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>685,447.5360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EthereumPoW</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>1,339.4384</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cardano</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>2,762,362.6317</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>smartBCH</th>\n",
       "      <td>peggedUSD</td>\n",
       "      <td>25,530,583.7234</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>106 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  type  totalCirculatingUSD\n",
       "chain                                      \n",
       "Optimism     peggedEUR         869,407.6775\n",
       "Optimism     peggedUSD     532,093,990.6032\n",
       "Optimism     peggedVAR          46,527.9036\n",
       "DFK          peggedUSD       2,806,576.6581\n",
       "Kadena       peggedUSD             384.1072\n",
       "...                ...                  ...\n",
       "Mixin        peggedUSD               0.0000\n",
       "Kujira       peggedUSD         685,447.5360\n",
       "EthereumPoW  peggedUSD           1,339.4384\n",
       "Cardano      peggedUSD       2,762,362.6317\n",
       "smartBCH     peggedUSD      25,530,583.7234\n",
       "\n",
       "[106 rows x 2 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "obj.get_stablecoins_curr_mcap_by_chain()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2d7ba96e-a86a-4e26-9950-c8488491b0c5",
   "metadata": {
    "tags": []
   },
   "source": [
    "## Get historical prices of all stablecoins"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "756b1bb5-c7ec-4088-9104-fb475b38651a",
   "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>stablecoin</th>\n",
       "      <th>prices</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>date</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2020-12-30 00:00:00+00:00</th>\n",
       "      <td>binance-usd</td>\n",
       "      <td>1.0035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-30 00:00:00+00:00</th>\n",
       "      <td>celo-dollar</td>\n",
       "      <td>1.0035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-30 00:00:00+00:00</th>\n",
       "      <td>dai</td>\n",
       "      <td>1.0043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-30 00:00:00+00:00</th>\n",
       "      <td>frax</td>\n",
       "      <td>1.0275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2020-12-30 00:00:00+00:00</th>\n",
       "      <td>gemini-dollar</td>\n",
       "      <td>1.0078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-29 00:00:00+00:00</th>\n",
       "      <td>xai</td>\n",
       "      <td>1.0009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-29 00:00:00+00:00</th>\n",
       "      <td>youves-uusd</td>\n",
       "      <td>1.0020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-29 00:00:00+00:00</th>\n",
       "      <td>yusd-stablecoin</td>\n",
       "      <td>0.9995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-29 00:00:00+00:00</th>\n",
       "      <td>zunami-protocol</td>\n",
       "      <td>0.9889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2022-12-29 00:00:00+00:00</th>\n",
       "      <td>zusd</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>31622 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                stablecoin  prices\n",
       "date                                              \n",
       "2020-12-30 00:00:00+00:00      binance-usd  1.0035\n",
       "2020-12-30 00:00:00+00:00      celo-dollar  1.0035\n",
       "2020-12-30 00:00:00+00:00              dai  1.0043\n",
       "2020-12-30 00:00:00+00:00             frax  1.0275\n",
       "2020-12-30 00:00:00+00:00    gemini-dollar  1.0078\n",
       "...                                    ...     ...\n",
       "2022-12-29 00:00:00+00:00              xai  1.0009\n",
       "2022-12-29 00:00:00+00:00      youves-uusd  1.0020\n",
       "2022-12-29 00:00:00+00:00  yusd-stablecoin  0.9995\n",
       "2022-12-29 00:00:00+00:00  zunami-protocol  0.9889\n",
       "2022-12-29 00:00:00+00:00             zusd     NaN\n",
       "\n",
       "[31622 rows x 2 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "obj.get_stablecoins_prices()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e927d1d2-0184-4975-8f4b-f3c242e69332",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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
}