{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "5873f971",
   "metadata": {},
   "source": [
    "![title](https://raw.githubusercontent.com/messari/messari-python-api/feature/demo_notebooks/examples/notebooks/images/defillama_messari_python.PNG)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b650d739",
   "metadata": {},
   "source": [
    "# DeFi Llama Python API Tutorial"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "90d1e1be",
   "metadata": {},
   "source": [
    "This tutorial aims to be a quick guide to get you started using the DeFi Llama API integrated into messari's python library."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "4f68f0a5",
   "metadata": {},
   "outputs": [],
   "source": [
    "from messari.defillama import DeFiLlama\n",
    "dl = DeFiLlama()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ea4f2e3b",
   "metadata": {},
   "source": [
    "## API Structure"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "22c173a4",
   "metadata": {},
   "source": [
    "The Messari Python client contains a number of functions that wrap all of DeFi Llama's API endpoints. These include:\n",
    "\n",
    "* get_protocol_tvl_timeseries\n",
    "* get_global_tvl_timeseries\n",
    "* get_chain_tvl_timeseries\n",
    "* get_current_tvl\n",
    "* get_protocols\n",
    "\n",
    "Below are a few examples to showcase the functionality and types of data each function generates."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d7e1db6b",
   "metadata": {},
   "source": [
    "## Get protocol tvl timeseries"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5ccbe798",
   "metadata": {},
   "source": [
    "This function returns a timeseries of a protocol's TVL broken down by token amounts as a pandas DataFrame. The DataFrame uses a multiindex to group relevant data together following a convenient **df[protocol][chain][asset]** pattern. For example, the following code returns Aave's aggregate TVL and token amounts across all chains:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "6f8031a0",
   "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>totalLiquidityUSD</th>\n",
       "      <th>ENJ</th>\n",
       "      <th>CRV</th>\n",
       "      <th>USDT</th>\n",
       "      <th>LEND</th>\n",
       "      <th>AAVE</th>\n",
       "      <th>UNI</th>\n",
       "      <th>WBTC</th>\n",
       "      <th>SUSD</th>\n",
       "      <th>LINK</th>\n",
       "      <th>...</th>\n",
       "      <th>RENFIL_usd</th>\n",
       "      <th>UNKNOWN (0x1985365e9f78359a9B6AD760e32412f4a445E862)_usd</th>\n",
       "      <th>RAI_usd</th>\n",
       "      <th>AMPL_usd</th>\n",
       "      <th>PAX_usd</th>\n",
       "      <th>DPI_usd</th>\n",
       "      <th>USDP_usd</th>\n",
       "      <th>FRAX_usd</th>\n",
       "      <th>FEI_usd</th>\n",
       "      <th>WAVAX_usd</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-10-01</th>\n",
       "      <td>1.370234e+10</td>\n",
       "      <td>1.046651e+07</td>\n",
       "      <td>6.311565e+06</td>\n",
       "      <td>2.455208e+08</td>\n",
       "      <td>174907.299479</td>\n",
       "      <td>1.910542e+06</td>\n",
       "      <td>3.918288e+06</td>\n",
       "      <td>41781.707197</td>\n",
       "      <td>2.544456e+07</td>\n",
       "      <td>2.200474e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>4.142907e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.369684e+07</td>\n",
       "      <td>1.067524e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.856352e+07</td>\n",
       "      <td>2.990423e+06</td>\n",
       "      <td>1.601764e+06</td>\n",
       "      <td>4.276806e+06</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-02</th>\n",
       "      <td>1.419310e+10</td>\n",
       "      <td>1.057785e+07</td>\n",
       "      <td>6.935109e+06</td>\n",
       "      <td>2.275302e+08</td>\n",
       "      <td>174907.299479</td>\n",
       "      <td>1.912798e+06</td>\n",
       "      <td>4.063942e+06</td>\n",
       "      <td>42631.168237</td>\n",
       "      <td>2.483117e+07</td>\n",
       "      <td>2.211693e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>4.275809e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.513579e+07</td>\n",
       "      <td>1.651881e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.688960e+07</td>\n",
       "      <td>2.970062e+06</td>\n",
       "      <td>3.600939e+06</td>\n",
       "      <td>4.036727e+06</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-03</th>\n",
       "      <td>1.431644e+10</td>\n",
       "      <td>1.063210e+07</td>\n",
       "      <td>7.733310e+06</td>\n",
       "      <td>3.273912e+08</td>\n",
       "      <td>174907.299479</td>\n",
       "      <td>1.910459e+06</td>\n",
       "      <td>4.060696e+06</td>\n",
       "      <td>43108.704933</td>\n",
       "      <td>2.256727e+07</td>\n",
       "      <td>2.216695e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>4.120871e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.513579e+07</td>\n",
       "      <td>2.528140e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.588331e+07</td>\n",
       "      <td>2.931041e+06</td>\n",
       "      <td>2.859444e+06</td>\n",
       "      <td>5.071526e+06</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-04</th>\n",
       "      <td>1.481314e+10</td>\n",
       "      <td>1.062416e+07</td>\n",
       "      <td>7.951371e+06</td>\n",
       "      <td>3.380871e+08</td>\n",
       "      <td>174907.299479</td>\n",
       "      <td>2.024898e+06</td>\n",
       "      <td>4.119227e+06</td>\n",
       "      <td>44953.703369</td>\n",
       "      <td>2.232785e+07</td>\n",
       "      <td>2.216039e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>4.092038e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.536486e+07</td>\n",
       "      <td>3.413756e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.441723e+07</td>\n",
       "      <td>2.931041e+06</td>\n",
       "      <td>1.647494e+06</td>\n",
       "      <td>5.114161e+06</td>\n",
       "      <td>8.102013e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-05</th>\n",
       "      <td>1.562776e+10</td>\n",
       "      <td>1.060164e+07</td>\n",
       "      <td>8.145123e+06</td>\n",
       "      <td>3.916334e+08</td>\n",
       "      <td>174296.741465</td>\n",
       "      <td>2.081462e+06</td>\n",
       "      <td>4.122575e+06</td>\n",
       "      <td>45576.912796</td>\n",
       "      <td>1.488648e+07</td>\n",
       "      <td>2.214311e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>4.184423e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.481286e+07</td>\n",
       "      <td>1.000055e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.478705e+07</td>\n",
       "      <td>2.931041e+06</td>\n",
       "      <td>1.834846e+06</td>\n",
       "      <td>5.018526e+06</td>\n",
       "      <td>8.322869e+07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 77 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            totalLiquidityUSD           ENJ           CRV          USDT  \\\n",
       "2021-10-01       1.370234e+10  1.046651e+07  6.311565e+06  2.455208e+08   \n",
       "2021-10-02       1.419310e+10  1.057785e+07  6.935109e+06  2.275302e+08   \n",
       "2021-10-03       1.431644e+10  1.063210e+07  7.733310e+06  3.273912e+08   \n",
       "2021-10-04       1.481314e+10  1.062416e+07  7.951371e+06  3.380871e+08   \n",
       "2021-10-05       1.562776e+10  1.060164e+07  8.145123e+06  3.916334e+08   \n",
       "\n",
       "                     LEND          AAVE           UNI          WBTC  \\\n",
       "2021-10-01  174907.299479  1.910542e+06  3.918288e+06  41781.707197   \n",
       "2021-10-02  174907.299479  1.912798e+06  4.063942e+06  42631.168237   \n",
       "2021-10-03  174907.299479  1.910459e+06  4.060696e+06  43108.704933   \n",
       "2021-10-04  174907.299479  2.024898e+06  4.119227e+06  44953.703369   \n",
       "2021-10-05  174296.741465  2.081462e+06  4.122575e+06  45576.912796   \n",
       "\n",
       "                    SUSD          LINK  ...    RENFIL_usd  \\\n",
       "2021-10-01  2.544456e+07  2.200474e+07  ...  4.142907e+06   \n",
       "2021-10-02  2.483117e+07  2.211693e+07  ...  4.275809e+06   \n",
       "2021-10-03  2.256727e+07  2.216695e+07  ...  4.120871e+06   \n",
       "2021-10-04  2.232785e+07  2.216039e+07  ...  4.092038e+06   \n",
       "2021-10-05  1.488648e+07  2.214311e+07  ...  4.184423e+06   \n",
       "\n",
       "            UNKNOWN (0x1985365e9f78359a9B6AD760e32412f4a445E862)_usd  \\\n",
       "2021-10-01                                                NaN          \n",
       "2021-10-02                                                NaN          \n",
       "2021-10-03                                                NaN          \n",
       "2021-10-04                                                NaN          \n",
       "2021-10-05                                                NaN          \n",
       "\n",
       "                 RAI_usd      AMPL_usd  PAX_usd       DPI_usd      USDP_usd  \\\n",
       "2021-10-01  1.369684e+07  1.067524e+06      NaN  5.856352e+07  2.990423e+06   \n",
       "2021-10-02  1.513579e+07  1.651881e+05      NaN  4.688960e+07  2.970062e+06   \n",
       "2021-10-03  1.513579e+07  2.528140e+05      NaN  4.588331e+07  2.931041e+06   \n",
       "2021-10-04  1.536486e+07  3.413756e+05      NaN  4.441723e+07  2.931041e+06   \n",
       "2021-10-05  1.481286e+07  1.000055e+06      NaN  4.478705e+07  2.931041e+06   \n",
       "\n",
       "                FRAX_usd       FEI_usd     WAVAX_usd  \n",
       "2021-10-01  1.601764e+06  4.276806e+06           NaN  \n",
       "2021-10-02  3.600939e+06  4.036727e+06           NaN  \n",
       "2021-10-03  2.859444e+06  5.071526e+06           NaN  \n",
       "2021-10-04  1.647494e+06  5.114161e+06  8.102013e+07  \n",
       "2021-10-05  1.834846e+06  5.018526e+06  8.322869e+07  \n",
       "\n",
       "[5 rows x 77 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "protocols = ['aave']\n",
    "protocol_tvls = dl.get_protocol_tvl_timeseries(protocols, start_date=\"2021-10-01\", end_date=\"2021-10-10\")\n",
    "protocol_tvls['aave']['all'].head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "053e0785",
   "metadata": {},
   "source": [
    "We could narrow down our search by passing other supported chains as follows:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "ca2fffb1",
   "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>totalLiquidityUSD</th>\n",
       "      <th>ENJ</th>\n",
       "      <th>CRV</th>\n",
       "      <th>USDT</th>\n",
       "      <th>LEND</th>\n",
       "      <th>AAVE</th>\n",
       "      <th>UNI</th>\n",
       "      <th>WBTC</th>\n",
       "      <th>SUSD</th>\n",
       "      <th>LINK</th>\n",
       "      <th>...</th>\n",
       "      <th>XSUSHI_usd</th>\n",
       "      <th>RENFIL_usd</th>\n",
       "      <th>UNKNOWN (0x1985365e9f78359a9B6AD760e32412f4a445E862)_usd</th>\n",
       "      <th>RAI_usd</th>\n",
       "      <th>AMPL_usd</th>\n",
       "      <th>PAX_usd</th>\n",
       "      <th>DPI_usd</th>\n",
       "      <th>USDP_usd</th>\n",
       "      <th>FRAX_usd</th>\n",
       "      <th>FEI_usd</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-10-01</th>\n",
       "      <td>1.176457e+10</td>\n",
       "      <td>1.046651e+07</td>\n",
       "      <td>6.311565e+06</td>\n",
       "      <td>2.097273e+08</td>\n",
       "      <td>174907.299479</td>\n",
       "      <td>1.719256e+06</td>\n",
       "      <td>3.918288e+06</td>\n",
       "      <td>33783.716382</td>\n",
       "      <td>2.544456e+07</td>\n",
       "      <td>2.200474e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.552155e+08</td>\n",
       "      <td>4.142907e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.369684e+07</td>\n",
       "      <td>1.067524e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5.856352e+07</td>\n",
       "      <td>2.990423e+06</td>\n",
       "      <td>1.601764e+06</td>\n",
       "      <td>4.276806e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-02</th>\n",
       "      <td>1.220245e+10</td>\n",
       "      <td>1.057785e+07</td>\n",
       "      <td>6.935109e+06</td>\n",
       "      <td>1.905787e+08</td>\n",
       "      <td>174907.299479</td>\n",
       "      <td>1.721987e+06</td>\n",
       "      <td>4.063942e+06</td>\n",
       "      <td>34580.139148</td>\n",
       "      <td>2.483117e+07</td>\n",
       "      <td>2.211693e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.610315e+08</td>\n",
       "      <td>4.275809e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.513579e+07</td>\n",
       "      <td>1.651881e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.688960e+07</td>\n",
       "      <td>2.970062e+06</td>\n",
       "      <td>3.600939e+06</td>\n",
       "      <td>4.036727e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-03</th>\n",
       "      <td>1.232623e+10</td>\n",
       "      <td>1.063210e+07</td>\n",
       "      <td>7.733310e+06</td>\n",
       "      <td>2.923815e+08</td>\n",
       "      <td>174907.299479</td>\n",
       "      <td>1.719631e+06</td>\n",
       "      <td>4.060696e+06</td>\n",
       "      <td>35020.173599</td>\n",
       "      <td>2.256727e+07</td>\n",
       "      <td>2.216695e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.563189e+08</td>\n",
       "      <td>4.120871e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.513579e+07</td>\n",
       "      <td>2.528140e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.588331e+07</td>\n",
       "      <td>2.931041e+06</td>\n",
       "      <td>2.859444e+06</td>\n",
       "      <td>5.071526e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-04</th>\n",
       "      <td>1.220784e+10</td>\n",
       "      <td>1.062416e+07</td>\n",
       "      <td>7.951371e+06</td>\n",
       "      <td>2.719606e+08</td>\n",
       "      <td>174907.299479</td>\n",
       "      <td>1.699531e+06</td>\n",
       "      <td>4.119227e+06</td>\n",
       "      <td>34959.163570</td>\n",
       "      <td>2.232785e+07</td>\n",
       "      <td>2.216039e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.579955e+08</td>\n",
       "      <td>4.092038e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.536486e+07</td>\n",
       "      <td>3.413756e+05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.441723e+07</td>\n",
       "      <td>2.931041e+06</td>\n",
       "      <td>1.647494e+06</td>\n",
       "      <td>5.114161e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-05</th>\n",
       "      <td>1.249159e+10</td>\n",
       "      <td>1.060164e+07</td>\n",
       "      <td>8.145123e+06</td>\n",
       "      <td>2.402593e+08</td>\n",
       "      <td>174296.741465</td>\n",
       "      <td>1.694906e+06</td>\n",
       "      <td>4.122575e+06</td>\n",
       "      <td>34650.687732</td>\n",
       "      <td>1.488648e+07</td>\n",
       "      <td>2.214311e+07</td>\n",
       "      <td>...</td>\n",
       "      <td>1.633028e+08</td>\n",
       "      <td>4.184423e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.481286e+07</td>\n",
       "      <td>1.000055e+06</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.478705e+07</td>\n",
       "      <td>2.931041e+06</td>\n",
       "      <td>1.834846e+06</td>\n",
       "      <td>5.018526e+06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 73 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            totalLiquidityUSD           ENJ           CRV          USDT  \\\n",
       "2021-10-01       1.176457e+10  1.046651e+07  6.311565e+06  2.097273e+08   \n",
       "2021-10-02       1.220245e+10  1.057785e+07  6.935109e+06  1.905787e+08   \n",
       "2021-10-03       1.232623e+10  1.063210e+07  7.733310e+06  2.923815e+08   \n",
       "2021-10-04       1.220784e+10  1.062416e+07  7.951371e+06  2.719606e+08   \n",
       "2021-10-05       1.249159e+10  1.060164e+07  8.145123e+06  2.402593e+08   \n",
       "\n",
       "                     LEND          AAVE           UNI          WBTC  \\\n",
       "2021-10-01  174907.299479  1.719256e+06  3.918288e+06  33783.716382   \n",
       "2021-10-02  174907.299479  1.721987e+06  4.063942e+06  34580.139148   \n",
       "2021-10-03  174907.299479  1.719631e+06  4.060696e+06  35020.173599   \n",
       "2021-10-04  174907.299479  1.699531e+06  4.119227e+06  34959.163570   \n",
       "2021-10-05  174296.741465  1.694906e+06  4.122575e+06  34650.687732   \n",
       "\n",
       "                    SUSD          LINK  ...    XSUSHI_usd    RENFIL_usd  \\\n",
       "2021-10-01  2.544456e+07  2.200474e+07  ...  1.552155e+08  4.142907e+06   \n",
       "2021-10-02  2.483117e+07  2.211693e+07  ...  1.610315e+08  4.275809e+06   \n",
       "2021-10-03  2.256727e+07  2.216695e+07  ...  1.563189e+08  4.120871e+06   \n",
       "2021-10-04  2.232785e+07  2.216039e+07  ...  1.579955e+08  4.092038e+06   \n",
       "2021-10-05  1.488648e+07  2.214311e+07  ...  1.633028e+08  4.184423e+06   \n",
       "\n",
       "            UNKNOWN (0x1985365e9f78359a9B6AD760e32412f4a445E862)_usd  \\\n",
       "2021-10-01                                                NaN          \n",
       "2021-10-02                                                NaN          \n",
       "2021-10-03                                                NaN          \n",
       "2021-10-04                                                NaN          \n",
       "2021-10-05                                                NaN          \n",
       "\n",
       "                 RAI_usd      AMPL_usd  PAX_usd       DPI_usd      USDP_usd  \\\n",
       "2021-10-01  1.369684e+07  1.067524e+06      NaN  5.856352e+07  2.990423e+06   \n",
       "2021-10-02  1.513579e+07  1.651881e+05      NaN  4.688960e+07  2.970062e+06   \n",
       "2021-10-03  1.513579e+07  2.528140e+05      NaN  4.588331e+07  2.931041e+06   \n",
       "2021-10-04  1.536486e+07  3.413756e+05      NaN  4.441723e+07  2.931041e+06   \n",
       "2021-10-05  1.481286e+07  1.000055e+06      NaN  4.478705e+07  2.931041e+06   \n",
       "\n",
       "                FRAX_usd       FEI_usd  \n",
       "2021-10-01  1.601764e+06  4.276806e+06  \n",
       "2021-10-02  3.600939e+06  4.036727e+06  \n",
       "2021-10-03  2.859444e+06  5.071526e+06  \n",
       "2021-10-04  1.647494e+06  5.114161e+06  \n",
       "2021-10-05  1.834846e+06  5.018526e+06  \n",
       "\n",
       "[5 rows x 73 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "protocol_tvls['aave']['Ethereum'].head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "7ae6bab7",
   "metadata": {},
   "source": [
    "To look at a protocol's aggregate TVL across all tokens of one specific chain, pass 'totalLiquidityUSD' as the asset index. For example, if we wanted to know Aave's total TVL in Ethereum, we would run:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "4c19665b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2021-10-01    1.176457e+10\n",
       "2021-10-02    1.220245e+10\n",
       "2021-10-03    1.232623e+10\n",
       "2021-10-04    1.220784e+10\n",
       "2021-10-05    1.249159e+10\n",
       "2021-10-06    1.248139e+10\n",
       "2021-10-07    1.249473e+10\n",
       "2021-10-08    1.199861e+10\n",
       "2021-10-09    1.144368e+10\n",
       "2021-10-10    1.132894e+10\n",
       "Name: totalLiquidityUSD, dtype: float64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "protocol_tvls['aave']['Ethereum']['totalLiquidityUSD']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "15679fd7",
   "metadata": {},
   "source": [
    "## Get global tvl timeseries"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2634f698",
   "metadata": {},
   "source": [
    "This function returns a timeseries of aggregate TVL across all supported protocols in DeFi Llama as a pandas DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "29537de4",
   "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>totalLiquidityUSD</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-10-01</th>\n",
       "      <td>1.931929e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-02</th>\n",
       "      <td>1.975269e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-03</th>\n",
       "      <td>2.000398e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-04</th>\n",
       "      <td>2.010004e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-05</th>\n",
       "      <td>2.052809e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-06</th>\n",
       "      <td>2.050247e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-07</th>\n",
       "      <td>2.074607e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-08</th>\n",
       "      <td>2.110497e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-09</th>\n",
       "      <td>2.116465e+11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-10</th>\n",
       "      <td>2.129363e+11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            totalLiquidityUSD\n",
       "2021-10-01       1.931929e+11\n",
       "2021-10-02       1.975269e+11\n",
       "2021-10-03       2.000398e+11\n",
       "2021-10-04       2.010004e+11\n",
       "2021-10-05       2.052809e+11\n",
       "2021-10-06       2.050247e+11\n",
       "2021-10-07       2.074607e+11\n",
       "2021-10-08       2.110497e+11\n",
       "2021-10-09       2.116465e+11\n",
       "2021-10-10       2.129363e+11"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "global_tvl = dl.get_global_tvl_timeseries(start_date=\"2021-10-01\", end_date=\"2021-10-10\")\n",
    "global_tvl"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "45251120",
   "metadata": {},
   "source": [
    "## Get chain tvl timeseries"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "df853435",
   "metadata": {},
   "source": [
    "This function retrives timeseries TVL for a given chain or list of chains as a pandas DataFrame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "7730b74d",
   "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>Avalanche</th>\n",
       "      <th>Harmony</th>\n",
       "      <th>Polygon</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2021-10-01</th>\n",
       "      <td>3.880313e+09</td>\n",
       "      <td>1.350100e+08</td>\n",
       "      <td>4.504783e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-02</th>\n",
       "      <td>4.066595e+09</td>\n",
       "      <td>1.399944e+08</td>\n",
       "      <td>4.580609e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-03</th>\n",
       "      <td>4.075295e+09</td>\n",
       "      <td>1.500492e+08</td>\n",
       "      <td>4.687820e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-04</th>\n",
       "      <td>3.984976e+09</td>\n",
       "      <td>1.497508e+08</td>\n",
       "      <td>4.663548e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-05</th>\n",
       "      <td>4.470707e+09</td>\n",
       "      <td>1.553020e+08</td>\n",
       "      <td>4.762029e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-06</th>\n",
       "      <td>4.528760e+09</td>\n",
       "      <td>1.534946e+08</td>\n",
       "      <td>4.724335e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-07</th>\n",
       "      <td>4.483351e+09</td>\n",
       "      <td>1.577545e+08</td>\n",
       "      <td>4.696261e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-08</th>\n",
       "      <td>4.560892e+09</td>\n",
       "      <td>1.645999e+08</td>\n",
       "      <td>4.651345e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-09</th>\n",
       "      <td>5.069958e+09</td>\n",
       "      <td>1.935887e+08</td>\n",
       "      <td>4.486516e+09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2021-10-10</th>\n",
       "      <td>5.131014e+09</td>\n",
       "      <td>1.875108e+08</td>\n",
       "      <td>4.455768e+09</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Avalanche       Harmony       Polygon\n",
       "2021-10-01  3.880313e+09  1.350100e+08  4.504783e+09\n",
       "2021-10-02  4.066595e+09  1.399944e+08  4.580609e+09\n",
       "2021-10-03  4.075295e+09  1.500492e+08  4.687820e+09\n",
       "2021-10-04  3.984976e+09  1.497508e+08  4.663548e+09\n",
       "2021-10-05  4.470707e+09  1.553020e+08  4.762029e+09\n",
       "2021-10-06  4.528760e+09  1.534946e+08  4.724335e+09\n",
       "2021-10-07  4.483351e+09  1.577545e+08  4.696261e+09\n",
       "2021-10-08  4.560892e+09  1.645999e+08  4.651345e+09\n",
       "2021-10-09  5.069958e+09  1.935887e+08  4.486516e+09\n",
       "2021-10-10  5.131014e+09  1.875108e+08  4.455768e+09"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "chains = [\"Avalanche\", \"Harmony\", \"Polygon\"]\n",
    "chain_tvls = dl.get_chain_tvl_timeseries(chains, start_date=\"2021-10-01\", end_date=\"2021-10-10\")\n",
    "chain_tvls"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9b4d6ef3",
   "metadata": {},
   "source": [
    "## Get current tvl"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "31e6bad8",
   "metadata": {},
   "source": [
    "The function retrives the current protocol tvl as a pandas DataFrame for an asset or list of assets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "b47f7d00",
   "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>tvl</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>uniswap</th>\n",
       "      <td>1.040976e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>curve</th>\n",
       "      <td>2.041504e+10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>aave</th>\n",
       "      <td>1.541991e+10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  tvl\n",
       "uniswap  1.040976e+10\n",
       "curve    2.041504e+10\n",
       "aave     1.541991e+10"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "protocols = [\"uniswap\", \"curve\", \"aave\"]\n",
    "current_tvl = dl.get_current_tvl(protocols)\n",
    "current_tvl"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fe248c35",
   "metadata": {},
   "source": [
    "## Get protocols"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d7c6dfcd",
   "metadata": {},
   "source": [
    "The function returns basic information on all DeFi Llama listed protocols."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "cd30a18b",
   "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>curve</th>\n",
       "      <th>makerdao</th>\n",
       "      <th>aave</th>\n",
       "      <th>convex-finance</th>\n",
       "      <th>wbtc</th>\n",
       "      <th>instadapp</th>\n",
       "      <th>compound</th>\n",
       "      <th>uniswap</th>\n",
       "      <th>polygon-bridge-&amp;-staking</th>\n",
       "      <th>lido</th>\n",
       "      <th>...</th>\n",
       "      <th>oraichain</th>\n",
       "      <th>bacondao</th>\n",
       "      <th>yel-finance</th>\n",
       "      <th>smartcoin</th>\n",
       "      <th>billion-happiness</th>\n",
       "      <th>decubate</th>\n",
       "      <th>nasdex</th>\n",
       "      <th>potluck-protocol</th>\n",
       "      <th>atmossoft</th>\n",
       "      <th>zigzag</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <td>3</td>\n",
       "      <td>118</td>\n",
       "      <td>111</td>\n",
       "      <td>319</td>\n",
       "      <td>2</td>\n",
       "      <td>120</td>\n",
       "      <td>114</td>\n",
       "      <td>1</td>\n",
       "      <td>240</td>\n",
       "      <td>182</td>\n",
       "      <td>...</td>\n",
       "      <td>681</td>\n",
       "      <td>682</td>\n",
       "      <td>686</td>\n",
       "      <td>715</td>\n",
       "      <td>716</td>\n",
       "      <td>717</td>\n",
       "      <td>720</td>\n",
       "      <td>723</td>\n",
       "      <td>783</td>\n",
       "      <td>800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>name</th>\n",
       "      <td>Curve</td>\n",
       "      <td>MakerDAO</td>\n",
       "      <td>AAVE</td>\n",
       "      <td>Convex Finance</td>\n",
       "      <td>WBTC</td>\n",
       "      <td>Instadapp</td>\n",
       "      <td>Compound</td>\n",
       "      <td>Uniswap</td>\n",
       "      <td>Polygon Bridge &amp; Staking</td>\n",
       "      <td>Lido</td>\n",
       "      <td>...</td>\n",
       "      <td>OraiChain</td>\n",
       "      <td>BaconDAO</td>\n",
       "      <td>YEL Finance</td>\n",
       "      <td>SmartCoin</td>\n",
       "      <td>Billion Happiness</td>\n",
       "      <td>Decubate</td>\n",
       "      <td>Nasdex</td>\n",
       "      <td>Potluck Protocol</td>\n",
       "      <td>AtmosSoft</td>\n",
       "      <td>ZigZag</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>address</th>\n",
       "      <td>0xD533a949740bb3306d119CC777fa900bA034cd52</td>\n",
       "      <td>0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2</td>\n",
       "      <td>0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9</td>\n",
       "      <td>0x4e3fbd56cd56c3e72c1403e103b45db9da5b9d2b</td>\n",
       "      <td>0x2260fac5e5542a773aa44fbcfedf7c193bc2c599</td>\n",
       "      <td>0x6f40d4a6237c257fff2db00fa0510deeecd303eb</td>\n",
       "      <td>0xc00e94cb662c3520282e6f5717214004a7f26888</td>\n",
       "      <td>0x1f9840a85d5af5bf1d1762f925bdaddc4201f984</td>\n",
       "      <td>0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0</td>\n",
       "      <td>0x5a98fcbea516cf06857215779fd812ca3bef1b32</td>\n",
       "      <td>...</td>\n",
       "      <td>0x4c11249814f11b9346808179cf06e71ac328c1b5</td>\n",
       "      <td>bsc:0x0615dbba33fe61a31c7ed131bda6655ed76748b1</td>\n",
       "      <td>0x7815bda662050d84718b988735218cffd32f75ea</td>\n",
       "      <td>avax:0xCC2f1d827b18321254223dF4e84dE399D9Ff116c</td>\n",
       "      <td>bsc:0x6fd7c98458a943f469E1Cf4eA85B173f5Cd342F4</td>\n",
       "      <td>bsc:0xEAc9873291dDAcA754EA5642114151f3035c67A2</td>\n",
       "      <td>polygon:0xE8d17b127BA8b9899a160D9a07b69bCa8E08...</td>\n",
       "      <td>fantom:0x49894fcc07233957c35462cfc3418ef0cc26129f</td>\n",
       "      <td>bsc:0xC53C65C4A925039cC149fA99fD011490D40270a3</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>symbol</th>\n",
       "      <td>CRV</td>\n",
       "      <td>MKR</td>\n",
       "      <td>AAVE</td>\n",
       "      <td>CVX</td>\n",
       "      <td>WBTC</td>\n",
       "      <td>INST</td>\n",
       "      <td>COMP</td>\n",
       "      <td>UNI</td>\n",
       "      <td>MATIC</td>\n",
       "      <td>LDO</td>\n",
       "      <td>...</td>\n",
       "      <td>ORAI</td>\n",
       "      <td>BACON</td>\n",
       "      <td>YEL</td>\n",
       "      <td>SMRT</td>\n",
       "      <td>BHC</td>\n",
       "      <td>DCB</td>\n",
       "      <td>NSDX</td>\n",
       "      <td>FANG</td>\n",
       "      <td>ATMSSFT</td>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>url</th>\n",
       "      <td>https://curve.fi</td>\n",
       "      <td>https://makerdao.com/</td>\n",
       "      <td>https://aave.com\\r\\n</td>\n",
       "      <td>https://www.convexfinance.com/</td>\n",
       "      <td>https://wbtc.network/</td>\n",
       "      <td>https://instadapp.io/</td>\n",
       "      <td>https://compound.finance</td>\n",
       "      <td>https://info.uniswap.org/</td>\n",
       "      <td>https://polygon.technology/</td>\n",
       "      <td>https://lido.fi/</td>\n",
       "      <td>...</td>\n",
       "      <td>https://orai.io</td>\n",
       "      <td>https://app.bacondao.com/</td>\n",
       "      <td>https://yel.finance</td>\n",
       "      <td>https://smartcoin.farm</td>\n",
       "      <td>https://billionhappiness.finance/</td>\n",
       "      <td>https://platform.decubate.com/</td>\n",
       "      <td>https://www.nasdex.xyz</td>\n",
       "      <td>http://fantom.potluckprotocol.com</td>\n",
       "      <td>https://www.atmossoftdefi.app</td>\n",
       "      <td>https://trade.zigzag.exchange</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>description</th>\n",
       "      <td>Curve is a decentralized exchange liquidity po...</td>\n",
       "      <td>Builders of Dai, a digital currency that can b...</td>\n",
       "      <td>Aave is an Open Source and Non-Custodial proto...</td>\n",
       "      <td>Convex simplifies your Curve-boosting experien...</td>\n",
       "      <td>Wrapped Bitcoin (WBTC) is the first ERC20 toke...</td>\n",
       "      <td>Aims to drive interoperability between protoco...</td>\n",
       "      <td>Compound is an algorithmic, autonomous interes...</td>\n",
       "      <td>A fully decentralized protocol for automated l...</td>\n",
       "      <td>Ethereum sidechain\\r\\n</td>\n",
       "      <td>Liquidity for staked assets. Daily rewards, no...</td>\n",
       "      <td>...</td>\n",
       "      <td>Oraichain is a data oracle platform that aggre...</td>\n",
       "      <td>BaconDAO (BACON) is a Decentralized Autonomous...</td>\n",
       "      <td>YEL aggregates multiple projects across severa...</td>\n",
       "      <td>SmartCoin is a yield farming protocol on Avala...</td>\n",
       "      <td>Billion Happiness is a blockchain community-ba...</td>\n",
       "      <td>Decubate is a community-powered investment pla...</td>\n",
       "      <td>NASDEX is a decentralised app on polygon, that...</td>\n",
       "      <td>Defi AMM with gamified products and features.</td>\n",
       "      <td>Atmosphere Software(AtmosSoft) is a next gener...</td>\n",
       "      <td>A Layer 2 decentralized exchange (DEX) on zkSync</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>chain</th>\n",
       "      <td>Multi-Chain</td>\n",
       "      <td>Ethereum</td>\n",
       "      <td>Multi-Chain</td>\n",
       "      <td>Ethereum</td>\n",
       "      <td>Ethereum</td>\n",
       "      <td>Ethereum</td>\n",
       "      <td>Ethereum</td>\n",
       "      <td>Ethereum</td>\n",
       "      <td>Polygon</td>\n",
       "      <td>Multi-Chain</td>\n",
       "      <td>...</td>\n",
       "      <td>Multi-Chain</td>\n",
       "      <td>Multi-Chain</td>\n",
       "      <td>Multi-Chain</td>\n",
       "      <td>Avalanche</td>\n",
       "      <td>Binance</td>\n",
       "      <td>Binance</td>\n",
       "      <td>Polygon</td>\n",
       "      <td>Fantom</td>\n",
       "      <td>Multi-Chain</td>\n",
       "      <td>zkSync</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>logo</th>\n",
       "      <td>https://icons.llama.fi/curve.png</td>\n",
       "      <td>https://icons.llama.fi/makerdao.jpg</td>\n",
       "      <td>https://icons.llama.fi/aave.png</td>\n",
       "      <td>https://icons.llama.fi/convex-finance.jpg</td>\n",
       "      <td>https://icons.llama.fi/wbtc.png</td>\n",
       "      <td>https://icons.llama.fi/instadapp.jpg</td>\n",
       "      <td>https://icons.llama.fi/compound.png</td>\n",
       "      <td>https://icons.llama.fi/uniswap.png</td>\n",
       "      <td>https://icons.llama.fi/polygon.jpg</td>\n",
       "      <td>https://icons.llama.fi/lido.png</td>\n",
       "      <td>...</td>\n",
       "      <td>https://icons.llama.fi/oraichain.jpg</td>\n",
       "      <td>https://icons.llama.fi/bacondao.png</td>\n",
       "      <td>https://icons.llama.fi/yel-finance.png</td>\n",
       "      <td>https://icons.llama.fi/smrt.png</td>\n",
       "      <td>https://icons.llama.fi/billion-happiness.png</td>\n",
       "      <td>https://icons.llama.fi/decubate.png</td>\n",
       "      <td>https://icons.llama.fi/nasdex.png</td>\n",
       "      <td>https://icons.llama.fi/potluck-protocol.png</td>\n",
       "      <td>https://icons.llama.fi/atmossoft.jpg</td>\n",
       "      <td>https://icons.llama.fi/zigzag.jpg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>audits</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>None</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>audit_note</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>gecko_id</th>\n",
       "      <td>curve-dao-token</td>\n",
       "      <td>maker</td>\n",
       "      <td>aave</td>\n",
       "      <td>convex-finance</td>\n",
       "      <td>wrapped-bitcoin</td>\n",
       "      <td>instadapp</td>\n",
       "      <td>compound-governance-token</td>\n",
       "      <td>uniswap</td>\n",
       "      <td>matic-network</td>\n",
       "      <td>lido-dao</td>\n",
       "      <td>...</td>\n",
       "      <td>oraichain-token</td>\n",
       "      <td>bacondao</td>\n",
       "      <td>yel-finance</td>\n",
       "      <td>smartcoin-2</td>\n",
       "      <td>billionhappiness</td>\n",
       "      <td>decubate</td>\n",
       "      <td>nasdex-token</td>\n",
       "      <td>fang-token</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cmcId</th>\n",
       "      <td>6538</td>\n",
       "      <td>1518</td>\n",
       "      <td>7278</td>\n",
       "      <td>9903</td>\n",
       "      <td>3717</td>\n",
       "      <td>10508</td>\n",
       "      <td>5692</td>\n",
       "      <td>7083</td>\n",
       "      <td>3890</td>\n",
       "      <td>8000</td>\n",
       "      <td>...</td>\n",
       "      <td>7533</td>\n",
       "      <td>10501</td>\n",
       "      <td>11301</td>\n",
       "      <td>12917</td>\n",
       "      <td>7182</td>\n",
       "      <td>10563</td>\n",
       "      <td>12312</td>\n",
       "      <td>12671</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>category</th>\n",
       "      <td>Dexes</td>\n",
       "      <td>Minting</td>\n",
       "      <td>Lending</td>\n",
       "      <td>Yield</td>\n",
       "      <td>Assets</td>\n",
       "      <td>Services</td>\n",
       "      <td>Lending</td>\n",
       "      <td>Dexes</td>\n",
       "      <td>Chain</td>\n",
       "      <td>Staking</td>\n",
       "      <td>...</td>\n",
       "      <td>Yield</td>\n",
       "      <td>Yield</td>\n",
       "      <td>Yield</td>\n",
       "      <td>Yield</td>\n",
       "      <td>Yield</td>\n",
       "      <td>Launchpad</td>\n",
       "      <td>Dexes</td>\n",
       "      <td>Staking</td>\n",
       "      <td>Gaming</td>\n",
       "      <td>Dexes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>chains</th>\n",
       "      <td>[Avalanche, Harmony, Ethereum, xDai, Polygon, ...</td>\n",
       "      <td>[Ethereum]</td>\n",
       "      <td>[Ethereum, Polygon, Avalanche]</td>\n",
       "      <td>[Ethereum]</td>\n",
       "      <td>[Ethereum]</td>\n",
       "      <td>[Ethereum]</td>\n",
       "      <td>[Ethereum]</td>\n",
       "      <td>[Optimism, Ethereum, Arbitrum]</td>\n",
       "      <td>[Polygon]</td>\n",
       "      <td>[Ethereum, Solana, Terra]</td>\n",
       "      <td>...</td>\n",
       "      <td>[Ethereum]</td>\n",
       "      <td>[Binance, Ethereum]</td>\n",
       "      <td>[Ethereum]</td>\n",
       "      <td>[Avalanche]</td>\n",
       "      <td>[Binance]</td>\n",
       "      <td>[Binance]</td>\n",
       "      <td>[Polygon]</td>\n",
       "      <td>[Fantom]</td>\n",
       "      <td>[Fantom]</td>\n",
       "      <td>[zkSync]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>module</th>\n",
       "      <td>curve.js</td>\n",
       "      <td>maker/index.js</td>\n",
       "      <td>aave/index.js</td>\n",
       "      <td>convex/index.js</td>\n",
       "      <td>wbtc.js</td>\n",
       "      <td>instadapp.js</td>\n",
       "      <td>compound-onchain/index.js</td>\n",
       "      <td>uniswap/index.js</td>\n",
       "      <td>polygon/index.js</td>\n",
       "      <td>lido/index.js</td>\n",
       "      <td>...</td>\n",
       "      <td>oraichain.js</td>\n",
       "      <td>bacondao/index.js</td>\n",
       "      <td>yel/index.js</td>\n",
       "      <td>smartcoin/index.js</td>\n",
       "      <td>billion-happiness/index.js</td>\n",
       "      <td>decubate/index.js</td>\n",
       "      <td>nasdex/index.js</td>\n",
       "      <td>potluckprotocol/index.js</td>\n",
       "      <td>atmossoft.js</td>\n",
       "      <td>zigzag/index.js</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>twitter</th>\n",
       "      <td>CurveFinance</td>\n",
       "      <td>MakerDAO</td>\n",
       "      <td>AaveAave</td>\n",
       "      <td>ConvexFinance</td>\n",
       "      <td>WrappedBTC</td>\n",
       "      <td>Instadapp</td>\n",
       "      <td>compoundfinance</td>\n",
       "      <td>Uniswap</td>\n",
       "      <td>0xPolygon</td>\n",
       "      <td>LidoFinance</td>\n",
       "      <td>...</td>\n",
       "      <td>oraichain</td>\n",
       "      <td>BaconDAO_</td>\n",
       "      <td>yel_finance</td>\n",
       "      <td>0xSmartCoin</td>\n",
       "      <td>BHC_Happiness</td>\n",
       "      <td>decubate</td>\n",
       "      <td>nasdex_xyz</td>\n",
       "      <td>PotluckProtocol</td>\n",
       "      <td>AtmosSoft</td>\n",
       "      <td>ZigZagExchange</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>audit_links</th>\n",
       "      <td>[https://curve.fi/audits]</td>\n",
       "      <td>[https://security.makerdao.com/]</td>\n",
       "      <td>[https://aave.com/security]</td>\n",
       "      <td>[https://github.com/convex-eth/platform/blob/m...</td>\n",
       "      <td>[https://wbtc.network/dashboard/audit]</td>\n",
       "      <td>[https://github.com/Instadapp/dsa-contracts/bl...</td>\n",
       "      <td>[https://compound.finance/docs/security]</td>\n",
       "      <td>[https://github.com/Uniswap/uniswap-v3-core/tr...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[https://github.com/lidofinance/audits]</td>\n",
       "      <td>...</td>\n",
       "      <td>[https://github.com/oraichain/audits]</td>\n",
       "      <td>[https://drive.google.com/file/d/1AVc_YuSKoaoj...</td>\n",
       "      <td>[https://yield-enhancement-labs.gitbook.io/yie...</td>\n",
       "      <td>[https://paladinsec.co/pld/assets/20211018_Pal...</td>\n",
       "      <td>[https://www.certik.org/projects/billionhappin...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[https://dessertswap.finance/audits/Potluck%20...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oracles</th>\n",
       "      <td>[Chainlink]</td>\n",
       "      <td>[Maker]</td>\n",
       "      <td>[Chainlink]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Chainlink]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Chainlink]</td>\n",
       "      <td>[Uniswap]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Internal]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>slug</th>\n",
       "      <td>curve</td>\n",
       "      <td>makerdao</td>\n",
       "      <td>aave</td>\n",
       "      <td>convex-finance</td>\n",
       "      <td>wbtc</td>\n",
       "      <td>instadapp</td>\n",
       "      <td>compound</td>\n",
       "      <td>uniswap</td>\n",
       "      <td>polygon-bridge-&amp;-staking</td>\n",
       "      <td>lido</td>\n",
       "      <td>...</td>\n",
       "      <td>oraichain</td>\n",
       "      <td>bacondao</td>\n",
       "      <td>yel-finance</td>\n",
       "      <td>smartcoin</td>\n",
       "      <td>billion-happiness</td>\n",
       "      <td>decubate</td>\n",
       "      <td>nasdex</td>\n",
       "      <td>potluck-protocol</td>\n",
       "      <td>atmossoft</td>\n",
       "      <td>zigzag</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tvl</th>\n",
       "      <td>20415038798.327824</td>\n",
       "      <td>17969496759.492355</td>\n",
       "      <td>15419913267.352034</td>\n",
       "      <td>15131073490.628565</td>\n",
       "      <td>14449256853.309999</td>\n",
       "      <td>12102460033</td>\n",
       "      <td>11922059387.8978</td>\n",
       "      <td>10409755599.486263</td>\n",
       "      <td>9710159190.366772</td>\n",
       "      <td>9485282686.237036</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>chainTvls</th>\n",
       "      <td>{'Avalanche': 936811028.2676972, 'Harmony': 12...</td>\n",
       "      <td>{'Ethereum': 17969496759.492355}</td>\n",
       "      <td>{'Ethereum': 10471743116.25161, 'Polygon': 182...</td>\n",
       "      <td>{'Ethereum': 15131073490.628565}</td>\n",
       "      <td>{'Ethereum': 14449256853.31}</td>\n",
       "      <td>{'Ethereum': 12102460033}</td>\n",
       "      <td>{'Ethereum': 11922059387.897799}</td>\n",
       "      <td>{'Optimism': 40914299.193099, 'Ethereum': 1030...</td>\n",
       "      <td>{'Polygon': 9710159190.366772}</td>\n",
       "      <td>{'Ethereum': 6288679048.837508, 'Solana': 2258...</td>\n",
       "      <td>...</td>\n",
       "      <td>{'Binance-staking': 2069241.2442397017, 'Ether...</td>\n",
       "      <td>{'pool2': 221923.15863504808, 'Binance-pool2':...</td>\n",
       "      <td>{'pool2': 6445303.662442322, 'Fantom-staking':...</td>\n",
       "      <td>{'Avalanche': 0, 'pool2': 96739.95349781934, '...</td>\n",
       "      <td>{'Binance': 0, 'Binance-staking': 4712925.0535...</td>\n",
       "      <td>{'Binance': 0, 'Binance-staking': 2304569.8020...</td>\n",
       "      <td>{'pool2': 169532.88870213774, 'staking': 92538...</td>\n",
       "      <td>{'Fantom-staking': 142474.83638762677, 'stakin...</td>\n",
       "      <td>{'pool2': 19304.101388327308, 'Fantom-pool2': ...</td>\n",
       "      <td>{'Zksync': 0, 'offers': 1636467.8193695154, 'Z...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>change_1h</th>\n",
       "      <td>-0.44896</td>\n",
       "      <td>-0.548806</td>\n",
       "      <td>-0.572617</td>\n",
       "      <td>-0.197715</td>\n",
       "      <td>-0.743818</td>\n",
       "      <td>0</td>\n",
       "      <td>0.359498</td>\n",
       "      <td>-0.219655</td>\n",
       "      <td>-0.675755</td>\n",
       "      <td>-0.964538</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>-100</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>change_1d</th>\n",
       "      <td>-3.131439</td>\n",
       "      <td>-5.297916</td>\n",
       "      <td>-5.013928</td>\n",
       "      <td>-4.886415</td>\n",
       "      <td>-5.450934</td>\n",
       "      <td>-5.518304</td>\n",
       "      <td>-4.320109</td>\n",
       "      <td>-0.608482</td>\n",
       "      <td>-5.742343</td>\n",
       "      <td>-8.011128</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>-100</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>change_7d</th>\n",
       "      <td>-2.475693</td>\n",
       "      <td>-9.598398</td>\n",
       "      <td>-6.84128</td>\n",
       "      <td>None</td>\n",
       "      <td>-8.440936</td>\n",
       "      <td>-3.395067</td>\n",
       "      <td>-7.09348</td>\n",
       "      <td>None</td>\n",
       "      <td>-7.491259</td>\n",
       "      <td>-11.422413</td>\n",
       "      <td>...</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>-100</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fdv</th>\n",
       "      <td>12301661224</td>\n",
       "      <td>2840314296</td>\n",
       "      <td>4491341668</td>\n",
       "      <td>2485404838</td>\n",
       "      <td>14483125559</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3153251980</td>\n",
       "      <td>21834450907</td>\n",
       "      <td>15778573102</td>\n",
       "      <td>3872965400</td>\n",
       "      <td>...</td>\n",
       "      <td>297401311</td>\n",
       "      <td>10616405</td>\n",
       "      <td>44201792</td>\n",
       "      <td>16121682</td>\n",
       "      <td>NaN</td>\n",
       "      <td>57017539</td>\n",
       "      <td>NaN</td>\n",
       "      <td>184351117</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mcap</th>\n",
       "      <td>1459791560</td>\n",
       "      <td>2545808395</td>\n",
       "      <td>3719606083</td>\n",
       "      <td>913173794</td>\n",
       "      <td>14483125559</td>\n",
       "      <td>73522897</td>\n",
       "      <td>1940052879</td>\n",
       "      <td>9888225317</td>\n",
       "      <td>10844439988</td>\n",
       "      <td>235584083</td>\n",
       "      <td>...</td>\n",
       "      <td>33371283</td>\n",
       "      <td>0</td>\n",
       "      <td>27646000</td>\n",
       "      <td>0</td>\n",
       "      <td>10244171</td>\n",
       "      <td>3644403</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>staking</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1276237472.239922</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4812640.377482</td>\n",
       "      <td>121803.487761</td>\n",
       "      <td>11131451.1693</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4712925.053547</td>\n",
       "      <td>2304569.802009</td>\n",
       "      <td>925380.492968</td>\n",
       "      <td>142474.836388</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>forkedFrom</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Pantherswap, Pancakeswap]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>pool2</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>221923.158635</td>\n",
       "      <td>6445303.662442</td>\n",
       "      <td>96739.953498</td>\n",
       "      <td>211307.874648</td>\n",
       "      <td>NaN</td>\n",
       "      <td>169532.888702</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19304.101388</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>listedAt</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1634551713</td>\n",
       "      <td>1634577126</td>\n",
       "      <td>1634674060</td>\n",
       "      <td>1635279168</td>\n",
       "      <td>1635296377</td>\n",
       "      <td>1635383289</td>\n",
       "      <td>1635463716</td>\n",
       "      <td>1635465731</td>\n",
       "      <td>1636043958</td>\n",
       "      <td>1636305888</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>30 rows × 704 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                         curve  \\\n",
       "id                                                           3   \n",
       "name                                                     Curve   \n",
       "address             0xD533a949740bb3306d119CC777fa900bA034cd52   \n",
       "symbol                                                     CRV   \n",
       "url                                           https://curve.fi   \n",
       "description  Curve is a decentralized exchange liquidity po...   \n",
       "chain                                              Multi-Chain   \n",
       "logo                          https://icons.llama.fi/curve.png   \n",
       "audits                                                       2   \n",
       "audit_note                                                None   \n",
       "gecko_id                                       curve-dao-token   \n",
       "cmcId                                                     6538   \n",
       "category                                                 Dexes   \n",
       "chains       [Avalanche, Harmony, Ethereum, xDai, Polygon, ...   \n",
       "module                                                curve.js   \n",
       "twitter                                           CurveFinance   \n",
       "audit_links                          [https://curve.fi/audits]   \n",
       "oracles                                            [Chainlink]   \n",
       "slug                                                     curve   \n",
       "tvl                                         20415038798.327824   \n",
       "chainTvls    {'Avalanche': 936811028.2676972, 'Harmony': 12...   \n",
       "change_1h                                             -0.44896   \n",
       "change_1d                                            -3.131439   \n",
       "change_7d                                            -2.475693   \n",
       "fdv                                                12301661224   \n",
       "mcap                                                1459791560   \n",
       "staking                                                    NaN   \n",
       "forkedFrom                                                 NaN   \n",
       "pool2                                                      NaN   \n",
       "listedAt                                                   NaN   \n",
       "\n",
       "                                                      makerdao  \\\n",
       "id                                                         118   \n",
       "name                                                  MakerDAO   \n",
       "address             0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2   \n",
       "symbol                                                     MKR   \n",
       "url                                      https://makerdao.com/   \n",
       "description  Builders of Dai, a digital currency that can b...   \n",
       "chain                                                 Ethereum   \n",
       "logo                       https://icons.llama.fi/makerdao.jpg   \n",
       "audits                                                       2   \n",
       "audit_note                                                None   \n",
       "gecko_id                                                 maker   \n",
       "cmcId                                                     1518   \n",
       "category                                               Minting   \n",
       "chains                                              [Ethereum]   \n",
       "module                                          maker/index.js   \n",
       "twitter                                               MakerDAO   \n",
       "audit_links                   [https://security.makerdao.com/]   \n",
       "oracles                                                [Maker]   \n",
       "slug                                                  makerdao   \n",
       "tvl                                         17969496759.492355   \n",
       "chainTvls                     {'Ethereum': 17969496759.492355}   \n",
       "change_1h                                            -0.548806   \n",
       "change_1d                                            -5.297916   \n",
       "change_7d                                            -9.598398   \n",
       "fdv                                                 2840314296   \n",
       "mcap                                                2545808395   \n",
       "staking                                                    NaN   \n",
       "forkedFrom                                                 NaN   \n",
       "pool2                                                      NaN   \n",
       "listedAt                                                   NaN   \n",
       "\n",
       "                                                          aave  \\\n",
       "id                                                         111   \n",
       "name                                                      AAVE   \n",
       "address             0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9   \n",
       "symbol                                                    AAVE   \n",
       "url                                       https://aave.com\\r\\n   \n",
       "description  Aave is an Open Source and Non-Custodial proto...   \n",
       "chain                                              Multi-Chain   \n",
       "logo                           https://icons.llama.fi/aave.png   \n",
       "audits                                                       2   \n",
       "audit_note                                                None   \n",
       "gecko_id                                                  aave   \n",
       "cmcId                                                     7278   \n",
       "category                                               Lending   \n",
       "chains                          [Ethereum, Polygon, Avalanche]   \n",
       "module                                           aave/index.js   \n",
       "twitter                                               AaveAave   \n",
       "audit_links                        [https://aave.com/security]   \n",
       "oracles                                            [Chainlink]   \n",
       "slug                                                      aave   \n",
       "tvl                                         15419913267.352034   \n",
       "chainTvls    {'Ethereum': 10471743116.25161, 'Polygon': 182...   \n",
       "change_1h                                            -0.572617   \n",
       "change_1d                                            -5.013928   \n",
       "change_7d                                             -6.84128   \n",
       "fdv                                                 4491341668   \n",
       "mcap                                                3719606083   \n",
       "staking                                      1276237472.239922   \n",
       "forkedFrom                                                 NaN   \n",
       "pool2                                                      NaN   \n",
       "listedAt                                                   NaN   \n",
       "\n",
       "                                                convex-finance  \\\n",
       "id                                                         319   \n",
       "name                                            Convex Finance   \n",
       "address             0x4e3fbd56cd56c3e72c1403e103b45db9da5b9d2b   \n",
       "symbol                                                     CVX   \n",
       "url                             https://www.convexfinance.com/   \n",
       "description  Convex simplifies your Curve-boosting experien...   \n",
       "chain                                                 Ethereum   \n",
       "logo                 https://icons.llama.fi/convex-finance.jpg   \n",
       "audits                                                       2   \n",
       "audit_note                                                None   \n",
       "gecko_id                                        convex-finance   \n",
       "cmcId                                                     9903   \n",
       "category                                                 Yield   \n",
       "chains                                              [Ethereum]   \n",
       "module                                         convex/index.js   \n",
       "twitter                                          ConvexFinance   \n",
       "audit_links  [https://github.com/convex-eth/platform/blob/m...   \n",
       "oracles                                                    NaN   \n",
       "slug                                            convex-finance   \n",
       "tvl                                         15131073490.628565   \n",
       "chainTvls                     {'Ethereum': 15131073490.628565}   \n",
       "change_1h                                            -0.197715   \n",
       "change_1d                                            -4.886415   \n",
       "change_7d                                                 None   \n",
       "fdv                                                 2485404838   \n",
       "mcap                                                 913173794   \n",
       "staking                                                    NaN   \n",
       "forkedFrom                                                 NaN   \n",
       "pool2                                                      NaN   \n",
       "listedAt                                                   NaN   \n",
       "\n",
       "                                                          wbtc  \\\n",
       "id                                                           2   \n",
       "name                                                      WBTC   \n",
       "address             0x2260fac5e5542a773aa44fbcfedf7c193bc2c599   \n",
       "symbol                                                    WBTC   \n",
       "url                                      https://wbtc.network/   \n",
       "description  Wrapped Bitcoin (WBTC) is the first ERC20 toke...   \n",
       "chain                                                 Ethereum   \n",
       "logo                           https://icons.llama.fi/wbtc.png   \n",
       "audits                                                       2   \n",
       "audit_note                                                None   \n",
       "gecko_id                                       wrapped-bitcoin   \n",
       "cmcId                                                     3717   \n",
       "category                                                Assets   \n",
       "chains                                              [Ethereum]   \n",
       "module                                                 wbtc.js   \n",
       "twitter                                             WrappedBTC   \n",
       "audit_links             [https://wbtc.network/dashboard/audit]   \n",
       "oracles                                            [Chainlink]   \n",
       "slug                                                      wbtc   \n",
       "tvl                                         14449256853.309999   \n",
       "chainTvls                         {'Ethereum': 14449256853.31}   \n",
       "change_1h                                            -0.743818   \n",
       "change_1d                                            -5.450934   \n",
       "change_7d                                            -8.440936   \n",
       "fdv                                                14483125559   \n",
       "mcap                                               14483125559   \n",
       "staking                                                    NaN   \n",
       "forkedFrom                                                 NaN   \n",
       "pool2                                                      NaN   \n",
       "listedAt                                                   NaN   \n",
       "\n",
       "                                                     instadapp  \\\n",
       "id                                                         120   \n",
       "name                                                 Instadapp   \n",
       "address             0x6f40d4a6237c257fff2db00fa0510deeecd303eb   \n",
       "symbol                                                    INST   \n",
       "url                                      https://instadapp.io/   \n",
       "description  Aims to drive interoperability between protoco...   \n",
       "chain                                                 Ethereum   \n",
       "logo                      https://icons.llama.fi/instadapp.jpg   \n",
       "audits                                                    None   \n",
       "audit_note                                                None   \n",
       "gecko_id                                             instadapp   \n",
       "cmcId                                                    10508   \n",
       "category                                              Services   \n",
       "chains                                              [Ethereum]   \n",
       "module                                            instadapp.js   \n",
       "twitter                                              Instadapp   \n",
       "audit_links  [https://github.com/Instadapp/dsa-contracts/bl...   \n",
       "oracles                                                    NaN   \n",
       "slug                                                 instadapp   \n",
       "tvl                                                12102460033   \n",
       "chainTvls                            {'Ethereum': 12102460033}   \n",
       "change_1h                                                    0   \n",
       "change_1d                                            -5.518304   \n",
       "change_7d                                            -3.395067   \n",
       "fdv                                                        NaN   \n",
       "mcap                                                  73522897   \n",
       "staking                                                    NaN   \n",
       "forkedFrom                                                 NaN   \n",
       "pool2                                                      NaN   \n",
       "listedAt                                                   NaN   \n",
       "\n",
       "                                                      compound  \\\n",
       "id                                                         114   \n",
       "name                                                  Compound   \n",
       "address             0xc00e94cb662c3520282e6f5717214004a7f26888   \n",
       "symbol                                                    COMP   \n",
       "url                                   https://compound.finance   \n",
       "description  Compound is an algorithmic, autonomous interes...   \n",
       "chain                                                 Ethereum   \n",
       "logo                       https://icons.llama.fi/compound.png   \n",
       "audits                                                       2   \n",
       "audit_note                                                None   \n",
       "gecko_id                             compound-governance-token   \n",
       "cmcId                                                     5692   \n",
       "category                                               Lending   \n",
       "chains                                              [Ethereum]   \n",
       "module                               compound-onchain/index.js   \n",
       "twitter                                        compoundfinance   \n",
       "audit_links           [https://compound.finance/docs/security]   \n",
       "oracles                                            [Chainlink]   \n",
       "slug                                                  compound   \n",
       "tvl                                           11922059387.8978   \n",
       "chainTvls                     {'Ethereum': 11922059387.897799}   \n",
       "change_1h                                             0.359498   \n",
       "change_1d                                            -4.320109   \n",
       "change_7d                                             -7.09348   \n",
       "fdv                                                 3153251980   \n",
       "mcap                                                1940052879   \n",
       "staking                                                    NaN   \n",
       "forkedFrom                                                 NaN   \n",
       "pool2                                                      NaN   \n",
       "listedAt                                                   NaN   \n",
       "\n",
       "                                                       uniswap  \\\n",
       "id                                                           1   \n",
       "name                                                   Uniswap   \n",
       "address             0x1f9840a85d5af5bf1d1762f925bdaddc4201f984   \n",
       "symbol                                                     UNI   \n",
       "url                                  https://info.uniswap.org/   \n",
       "description  A fully decentralized protocol for automated l...   \n",
       "chain                                                 Ethereum   \n",
       "logo                        https://icons.llama.fi/uniswap.png   \n",
       "audits                                                       2   \n",
       "audit_note                                                None   \n",
       "gecko_id                                               uniswap   \n",
       "cmcId                                                     7083   \n",
       "category                                                 Dexes   \n",
       "chains                          [Optimism, Ethereum, Arbitrum]   \n",
       "module                                        uniswap/index.js   \n",
       "twitter                                                Uniswap   \n",
       "audit_links  [https://github.com/Uniswap/uniswap-v3-core/tr...   \n",
       "oracles                                              [Uniswap]   \n",
       "slug                                                   uniswap   \n",
       "tvl                                         10409755599.486263   \n",
       "chainTvls    {'Optimism': 40914299.193099, 'Ethereum': 1030...   \n",
       "change_1h                                            -0.219655   \n",
       "change_1d                                            -0.608482   \n",
       "change_7d                                                 None   \n",
       "fdv                                                21834450907   \n",
       "mcap                                                9888225317   \n",
       "staking                                                    NaN   \n",
       "forkedFrom                                                 NaN   \n",
       "pool2                                                      NaN   \n",
       "listedAt                                                   NaN   \n",
       "\n",
       "                               polygon-bridge-&-staking  \\\n",
       "id                                                  240   \n",
       "name                           Polygon Bridge & Staking   \n",
       "address      0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0   \n",
       "symbol                                            MATIC   \n",
       "url                         https://polygon.technology/   \n",
       "description                      Ethereum sidechain\\r\\n   \n",
       "chain                                           Polygon   \n",
       "logo                 https://icons.llama.fi/polygon.jpg   \n",
       "audits                                                0   \n",
       "audit_note                                         None   \n",
       "gecko_id                                  matic-network   \n",
       "cmcId                                              3890   \n",
       "category                                          Chain   \n",
       "chains                                        [Polygon]   \n",
       "module                                 polygon/index.js   \n",
       "twitter                                       0xPolygon   \n",
       "audit_links                                         NaN   \n",
       "oracles                                             NaN   \n",
       "slug                           polygon-bridge-&-staking   \n",
       "tvl                                   9710159190.366772   \n",
       "chainTvls                {'Polygon': 9710159190.366772}   \n",
       "change_1h                                     -0.675755   \n",
       "change_1d                                     -5.742343   \n",
       "change_7d                                     -7.491259   \n",
       "fdv                                         15778573102   \n",
       "mcap                                        10844439988   \n",
       "staking                                             NaN   \n",
       "forkedFrom                                          NaN   \n",
       "pool2                                               NaN   \n",
       "listedAt                                            NaN   \n",
       "\n",
       "                                                          lido  ...  \\\n",
       "id                                                         182  ...   \n",
       "name                                                      Lido  ...   \n",
       "address             0x5a98fcbea516cf06857215779fd812ca3bef1b32  ...   \n",
       "symbol                                                     LDO  ...   \n",
       "url                                           https://lido.fi/  ...   \n",
       "description  Liquidity for staked assets. Daily rewards, no...  ...   \n",
       "chain                                              Multi-Chain  ...   \n",
       "logo                           https://icons.llama.fi/lido.png  ...   \n",
       "audits                                                       2  ...   \n",
       "audit_note                                                None  ...   \n",
       "gecko_id                                              lido-dao  ...   \n",
       "cmcId                                                     8000  ...   \n",
       "category                                               Staking  ...   \n",
       "chains                               [Ethereum, Solana, Terra]  ...   \n",
       "module                                           lido/index.js  ...   \n",
       "twitter                                            LidoFinance  ...   \n",
       "audit_links            [https://github.com/lidofinance/audits]  ...   \n",
       "oracles                                                    NaN  ...   \n",
       "slug                                                      lido  ...   \n",
       "tvl                                          9485282686.237036  ...   \n",
       "chainTvls    {'Ethereum': 6288679048.837508, 'Solana': 2258...  ...   \n",
       "change_1h                                            -0.964538  ...   \n",
       "change_1d                                            -8.011128  ...   \n",
       "change_7d                                           -11.422413  ...   \n",
       "fdv                                                 3872965400  ...   \n",
       "mcap                                                 235584083  ...   \n",
       "staking                                                    NaN  ...   \n",
       "forkedFrom                                                 NaN  ...   \n",
       "pool2                                                      NaN  ...   \n",
       "listedAt                                                   NaN  ...   \n",
       "\n",
       "                                                     oraichain  \\\n",
       "id                                                         681   \n",
       "name                                                 OraiChain   \n",
       "address             0x4c11249814f11b9346808179cf06e71ac328c1b5   \n",
       "symbol                                                    ORAI   \n",
       "url                                            https://orai.io   \n",
       "description  Oraichain is a data oracle platform that aggre...   \n",
       "chain                                              Multi-Chain   \n",
       "logo                      https://icons.llama.fi/oraichain.jpg   \n",
       "audits                                                       2   \n",
       "audit_note                                                None   \n",
       "gecko_id                                       oraichain-token   \n",
       "cmcId                                                     7533   \n",
       "category                                                 Yield   \n",
       "chains                                              [Ethereum]   \n",
       "module                                            oraichain.js   \n",
       "twitter                                              oraichain   \n",
       "audit_links              [https://github.com/oraichain/audits]   \n",
       "oracles                                                    NaN   \n",
       "slug                                                 oraichain   \n",
       "tvl                                                          0   \n",
       "chainTvls    {'Binance-staking': 2069241.2442397017, 'Ether...   \n",
       "change_1h                                                 None   \n",
       "change_1d                                                 None   \n",
       "change_7d                                                 None   \n",
       "fdv                                                  297401311   \n",
       "mcap                                                  33371283   \n",
       "staking                                         4812640.377482   \n",
       "forkedFrom                                                 NaN   \n",
       "pool2                                                      NaN   \n",
       "listedAt                                            1634551713   \n",
       "\n",
       "                                                      bacondao  \\\n",
       "id                                                         682   \n",
       "name                                                  BaconDAO   \n",
       "address         bsc:0x0615dbba33fe61a31c7ed131bda6655ed76748b1   \n",
       "symbol                                                   BACON   \n",
       "url                                  https://app.bacondao.com/   \n",
       "description  BaconDAO (BACON) is a Decentralized Autonomous...   \n",
       "chain                                              Multi-Chain   \n",
       "logo                       https://icons.llama.fi/bacondao.png   \n",
       "audits                                                       2   \n",
       "audit_note                                                None   \n",
       "gecko_id                                              bacondao   \n",
       "cmcId                                                    10501   \n",
       "category                                                 Yield   \n",
       "chains                                     [Binance, Ethereum]   \n",
       "module                                       bacondao/index.js   \n",
       "twitter                                              BaconDAO_   \n",
       "audit_links  [https://drive.google.com/file/d/1AVc_YuSKoaoj...   \n",
       "oracles                                                    NaN   \n",
       "slug                                                  bacondao   \n",
       "tvl                                                          0   \n",
       "chainTvls    {'pool2': 221923.15863504808, 'Binance-pool2':...   \n",
       "change_1h                                                 None   \n",
       "change_1d                                                 None   \n",
       "change_7d                                                 None   \n",
       "fdv                                                   10616405   \n",
       "mcap                                                         0   \n",
       "staking                                          121803.487761   \n",
       "forkedFrom                                                 NaN   \n",
       "pool2                                            221923.158635   \n",
       "listedAt                                            1634577126   \n",
       "\n",
       "                                                   yel-finance  \\\n",
       "id                                                         686   \n",
       "name                                               YEL Finance   \n",
       "address             0x7815bda662050d84718b988735218cffd32f75ea   \n",
       "symbol                                                     YEL   \n",
       "url                                        https://yel.finance   \n",
       "description  YEL aggregates multiple projects across severa...   \n",
       "chain                                              Multi-Chain   \n",
       "logo                    https://icons.llama.fi/yel-finance.png   \n",
       "audits                                                       2   \n",
       "audit_note                                                None   \n",
       "gecko_id                                           yel-finance   \n",
       "cmcId                                                    11301   \n",
       "category                                                 Yield   \n",
       "chains                                              [Ethereum]   \n",
       "module                                            yel/index.js   \n",
       "twitter                                            yel_finance   \n",
       "audit_links  [https://yield-enhancement-labs.gitbook.io/yie...   \n",
       "oracles                                                    NaN   \n",
       "slug                                               yel-finance   \n",
       "tvl                                                          0   \n",
       "chainTvls    {'pool2': 6445303.662442322, 'Fantom-staking':...   \n",
       "change_1h                                                 None   \n",
       "change_1d                                                 None   \n",
       "change_7d                                                 None   \n",
       "fdv                                                   44201792   \n",
       "mcap                                                  27646000   \n",
       "staking                                          11131451.1693   \n",
       "forkedFrom                                                 NaN   \n",
       "pool2                                           6445303.662442   \n",
       "listedAt                                            1634674060   \n",
       "\n",
       "                                                     smartcoin  \\\n",
       "id                                                         715   \n",
       "name                                                 SmartCoin   \n",
       "address        avax:0xCC2f1d827b18321254223dF4e84dE399D9Ff116c   \n",
       "symbol                                                    SMRT   \n",
       "url                                     https://smartcoin.farm   \n",
       "description  SmartCoin is a yield farming protocol on Avala...   \n",
       "chain                                                Avalanche   \n",
       "logo                           https://icons.llama.fi/smrt.png   \n",
       "audits                                                       2   \n",
       "audit_note                                                None   \n",
       "gecko_id                                           smartcoin-2   \n",
       "cmcId                                                    12917   \n",
       "category                                                 Yield   \n",
       "chains                                             [Avalanche]   \n",
       "module                                      smartcoin/index.js   \n",
       "twitter                                            0xSmartCoin   \n",
       "audit_links  [https://paladinsec.co/pld/assets/20211018_Pal...   \n",
       "oracles                                                    NaN   \n",
       "slug                                                 smartcoin   \n",
       "tvl                                                          0   \n",
       "chainTvls    {'Avalanche': 0, 'pool2': 96739.95349781934, '...   \n",
       "change_1h                                                 None   \n",
       "change_1d                                                 None   \n",
       "change_7d                                                 None   \n",
       "fdv                                                   16121682   \n",
       "mcap                                                         0   \n",
       "staking                                                    NaN   \n",
       "forkedFrom                                                 NaN   \n",
       "pool2                                             96739.953498   \n",
       "listedAt                                            1635279168   \n",
       "\n",
       "                                             billion-happiness  \\\n",
       "id                                                         716   \n",
       "name                                         Billion Happiness   \n",
       "address         bsc:0x6fd7c98458a943f469E1Cf4eA85B173f5Cd342F4   \n",
       "symbol                                                     BHC   \n",
       "url                          https://billionhappiness.finance/   \n",
       "description  Billion Happiness is a blockchain community-ba...   \n",
       "chain                                                  Binance   \n",
       "logo              https://icons.llama.fi/billion-happiness.png   \n",
       "audits                                                       2   \n",
       "audit_note                                                None   \n",
       "gecko_id                                      billionhappiness   \n",
       "cmcId                                                     7182   \n",
       "category                                                 Yield   \n",
       "chains                                               [Binance]   \n",
       "module                              billion-happiness/index.js   \n",
       "twitter                                          BHC_Happiness   \n",
       "audit_links  [https://www.certik.org/projects/billionhappin...   \n",
       "oracles                                                    NaN   \n",
       "slug                                         billion-happiness   \n",
       "tvl                                                          0   \n",
       "chainTvls    {'Binance': 0, 'Binance-staking': 4712925.0535...   \n",
       "change_1h                                                 None   \n",
       "change_1d                                                 None   \n",
       "change_7d                                                 None   \n",
       "fdv                                                        NaN   \n",
       "mcap                                                  10244171   \n",
       "staking                                         4712925.053547   \n",
       "forkedFrom                                                 NaN   \n",
       "pool2                                            211307.874648   \n",
       "listedAt                                            1635296377   \n",
       "\n",
       "                                                      decubate  \\\n",
       "id                                                         717   \n",
       "name                                                  Decubate   \n",
       "address         bsc:0xEAc9873291dDAcA754EA5642114151f3035c67A2   \n",
       "symbol                                                     DCB   \n",
       "url                             https://platform.decubate.com/   \n",
       "description  Decubate is a community-powered investment pla...   \n",
       "chain                                                  Binance   \n",
       "logo                       https://icons.llama.fi/decubate.png   \n",
       "audits                                                       0   \n",
       "audit_note                                                None   \n",
       "gecko_id                                              decubate   \n",
       "cmcId                                                    10563   \n",
       "category                                             Launchpad   \n",
       "chains                                               [Binance]   \n",
       "module                                       decubate/index.js   \n",
       "twitter                                               decubate   \n",
       "audit_links                                                NaN   \n",
       "oracles                                                    NaN   \n",
       "slug                                                  decubate   \n",
       "tvl                                                          0   \n",
       "chainTvls    {'Binance': 0, 'Binance-staking': 2304569.8020...   \n",
       "change_1h                                                 None   \n",
       "change_1d                                                 None   \n",
       "change_7d                                                 None   \n",
       "fdv                                                   57017539   \n",
       "mcap                                                   3644403   \n",
       "staking                                         2304569.802009   \n",
       "forkedFrom                                                 NaN   \n",
       "pool2                                                      NaN   \n",
       "listedAt                                            1635383289   \n",
       "\n",
       "                                                        nasdex  \\\n",
       "id                                                         720   \n",
       "name                                                    Nasdex   \n",
       "address      polygon:0xE8d17b127BA8b9899a160D9a07b69bCa8E08...   \n",
       "symbol                                                    NSDX   \n",
       "url                                     https://www.nasdex.xyz   \n",
       "description  NASDEX is a decentralised app on polygon, that...   \n",
       "chain                                                  Polygon   \n",
       "logo                         https://icons.llama.fi/nasdex.png   \n",
       "audits                                                       0   \n",
       "audit_note                                                None   \n",
       "gecko_id                                          nasdex-token   \n",
       "cmcId                                                    12312   \n",
       "category                                                 Dexes   \n",
       "chains                                               [Polygon]   \n",
       "module                                         nasdex/index.js   \n",
       "twitter                                             nasdex_xyz   \n",
       "audit_links                                                NaN   \n",
       "oracles                                                    NaN   \n",
       "slug                                                    nasdex   \n",
       "tvl                                                          0   \n",
       "chainTvls    {'pool2': 169532.88870213774, 'staking': 92538...   \n",
       "change_1h                                                 None   \n",
       "change_1d                                                 None   \n",
       "change_7d                                                 None   \n",
       "fdv                                                        NaN   \n",
       "mcap                                                         0   \n",
       "staking                                          925380.492968   \n",
       "forkedFrom                                                 NaN   \n",
       "pool2                                            169532.888702   \n",
       "listedAt                                            1635463716   \n",
       "\n",
       "                                              potluck-protocol  \\\n",
       "id                                                         723   \n",
       "name                                          Potluck Protocol   \n",
       "address      fantom:0x49894fcc07233957c35462cfc3418ef0cc26129f   \n",
       "symbol                                                    FANG   \n",
       "url                          http://fantom.potluckprotocol.com   \n",
       "description      Defi AMM with gamified products and features.   \n",
       "chain                                                   Fantom   \n",
       "logo               https://icons.llama.fi/potluck-protocol.png   \n",
       "audits                                                       2   \n",
       "audit_note                                                None   \n",
       "gecko_id                                            fang-token   \n",
       "cmcId                                                    12671   \n",
       "category                                               Staking   \n",
       "chains                                                [Fantom]   \n",
       "module                                potluckprotocol/index.js   \n",
       "twitter                                        PotluckProtocol   \n",
       "audit_links  [https://dessertswap.finance/audits/Potluck%20...   \n",
       "oracles                                             [Internal]   \n",
       "slug                                          potluck-protocol   \n",
       "tvl                                                          0   \n",
       "chainTvls    {'Fantom-staking': 142474.83638762677, 'stakin...   \n",
       "change_1h                                                 -100   \n",
       "change_1d                                                 -100   \n",
       "change_7d                                                 -100   \n",
       "fdv                                                  184351117   \n",
       "mcap                                                         0   \n",
       "staking                                          142474.836388   \n",
       "forkedFrom                          [Pantherswap, Pancakeswap]   \n",
       "pool2                                                      NaN   \n",
       "listedAt                                            1635465731   \n",
       "\n",
       "                                                     atmossoft  \\\n",
       "id                                                         783   \n",
       "name                                                 AtmosSoft   \n",
       "address         bsc:0xC53C65C4A925039cC149fA99fD011490D40270a3   \n",
       "symbol                                                 ATMSSFT   \n",
       "url                              https://www.atmossoftdefi.app   \n",
       "description  Atmosphere Software(AtmosSoft) is a next gener...   \n",
       "chain                                              Multi-Chain   \n",
       "logo                      https://icons.llama.fi/atmossoft.jpg   \n",
       "audits                                                       0   \n",
       "audit_note                                                None   \n",
       "gecko_id                                                  None   \n",
       "cmcId                                                     None   \n",
       "category                                                Gaming   \n",
       "chains                                                [Fantom]   \n",
       "module                                            atmossoft.js   \n",
       "twitter                                              AtmosSoft   \n",
       "audit_links                                                NaN   \n",
       "oracles                                                    NaN   \n",
       "slug                                                 atmossoft   \n",
       "tvl                                                          0   \n",
       "chainTvls    {'pool2': 19304.101388327308, 'Fantom-pool2': ...   \n",
       "change_1h                                                 None   \n",
       "change_1d                                                 None   \n",
       "change_7d                                                 None   \n",
       "fdv                                                        NaN   \n",
       "mcap                                                       NaN   \n",
       "staking                                                    NaN   \n",
       "forkedFrom                                                 NaN   \n",
       "pool2                                             19304.101388   \n",
       "listedAt                                            1636043958   \n",
       "\n",
       "                                                        zigzag  \n",
       "id                                                         800  \n",
       "name                                                    ZigZag  \n",
       "address                                                   None  \n",
       "symbol                                                       -  \n",
       "url                              https://trade.zigzag.exchange  \n",
       "description  A Layer 2 decentralized exchange (DEX) on zkSync   \n",
       "chain                                                   zkSync  \n",
       "logo                         https://icons.llama.fi/zigzag.jpg  \n",
       "audits                                                       0  \n",
       "audit_note                                                None  \n",
       "gecko_id                                                  None  \n",
       "cmcId                                                     None  \n",
       "category                                                 Dexes  \n",
       "chains                                                [zkSync]  \n",
       "module                                         zigzag/index.js  \n",
       "twitter                                         ZigZagExchange  \n",
       "audit_links                                                NaN  \n",
       "oracles                                                    NaN  \n",
       "slug                                                    zigzag  \n",
       "tvl                                                          0  \n",
       "chainTvls    {'Zksync': 0, 'offers': 1636467.8193695154, 'Z...  \n",
       "change_1h                                                 None  \n",
       "change_1d                                                 None  \n",
       "change_7d                                                 None  \n",
       "fdv                                                        NaN  \n",
       "mcap                                                       NaN  \n",
       "staking                                                    NaN  \n",
       "forkedFrom                                                 NaN  \n",
       "pool2                                                      NaN  \n",
       "listedAt                                            1636305888  \n",
       "\n",
       "[30 rows x 704 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "protocols = dl.get_protocols()\n",
    "protocols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2442991d",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}