get_thegraph_df.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "d742da20-d5f9-43f8-abdd-103b4692dee4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "started...\n",
      "df: 3000\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>symbols</th>\n",
       "      <th>pairAddr</th>\n",
       "      <th>price0</th>\n",
       "      <th>price1</th>\n",
       "      <th>reserve0</th>\n",
       "      <th>reserve1</th>\n",
       "      <th>reserveETH</th>\n",
       "      <th>reserveUSD</th>\n",
       "      <th>trackedReserveETH</th>\n",
       "      <th>txCount</th>\n",
       "      <th>untrackedVolumeUSD</th>\n",
       "      <th>volumeUSD</th>\n",
       "      <th>decimal0</th>\n",
       "      <th>decimal1</th>\n",
       "      <th>address0</th>\n",
       "      <th>address1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>USDC/miMATIC</td>\n",
       "      <td>0x160532d2536175d65c03b97b0630a9802c274dad</td>\n",
       "      <td>0.991700</td>\n",
       "      <td>1.008369</td>\n",
       "      <td>8.399169e+06</td>\n",
       "      <td>8.469463e+06</td>\n",
       "      <td>4045.535993</td>\n",
       "      <td>1.679834e+07</td>\n",
       "      <td>4045.535994</td>\n",
       "      <td>802017</td>\n",
       "      <td>4.571194e+08</td>\n",
       "      <td>4.570801e+08</td>\n",
       "      <td>6</td>\n",
       "      <td>18</td>\n",
       "      <td>0x2791bca1f2de4661ed88a30c99a7a9449aa84174</td>\n",
       "      <td>0xa3fa99a148fa48d14ed51d610c367c61876997f1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>WMATIC/QUICK</td>\n",
       "      <td>0x019ba0325f1988213d448b3472fa1cf8d07618d7</td>\n",
       "      <td>243.771603</td>\n",
       "      <td>0.004102</td>\n",
       "      <td>4.511018e+06</td>\n",
       "      <td>1.850510e+04</td>\n",
       "      <td>3637.156280</td>\n",
       "      <td>1.510220e+07</td>\n",
       "      <td>3637.156280</td>\n",
       "      <td>4015859</td>\n",
       "      <td>1.135818e+09</td>\n",
       "      <td>1.135818e+09</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270</td>\n",
       "      <td>0x831753dd7087cac61ab5644b308642cc1c33dc13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>WETH/QUICK</td>\n",
       "      <td>0x1bd06b96dd42ada85fdd0795f3b4a79db914add5</td>\n",
       "      <td>0.098358</td>\n",
       "      <td>10.166986</td>\n",
       "      <td>1.160485e+03</td>\n",
       "      <td>1.179863e+04</td>\n",
       "      <td>2320.350438</td>\n",
       "      <td>9.634560e+06</td>\n",
       "      <td>2320.350438</td>\n",
       "      <td>2413779</td>\n",
       "      <td>6.444822e+08</td>\n",
       "      <td>6.444822e+08</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>0x7ceb23fd6bc0add59e62ac25578270cff1b9f619</td>\n",
       "      <td>0x831753dd7087cac61ab5644b308642cc1c33dc13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>USDC/GHST</td>\n",
       "      <td>0x096c5ccb33cfc5732bcd1f3195c13dbefc4c82f4</td>\n",
       "      <td>1.887829</td>\n",
       "      <td>0.529709</td>\n",
       "      <td>3.024324e+06</td>\n",
       "      <td>1.602012e+06</td>\n",
       "      <td>1461.506227</td>\n",
       "      <td>6.068472e+06</td>\n",
       "      <td>1456.731770</td>\n",
       "      <td>367496</td>\n",
       "      <td>2.378322e+08</td>\n",
       "      <td>2.378534e+08</td>\n",
       "      <td>6</td>\n",
       "      <td>18</td>\n",
       "      <td>0x2791bca1f2de4661ed88a30c99a7a9449aa84174</td>\n",
       "      <td>0x385eeac5cb85a38a9a07a70c73e0a3271cfb54a7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>USDC/QUICK</td>\n",
       "      <td>0x1f1e4c845183ef6d50e9609f16f6f9cae43bc9cb</td>\n",
       "      <td>407.070104</td>\n",
       "      <td>0.002457</td>\n",
       "      <td>2.307571e+06</td>\n",
       "      <td>5.668732e+03</td>\n",
       "      <td>1112.992411</td>\n",
       "      <td>4.621374e+06</td>\n",
       "      <td>1112.992411</td>\n",
       "      <td>2142838</td>\n",
       "      <td>1.081548e+09</td>\n",
       "      <td>1.081548e+09</td>\n",
       "      <td>6</td>\n",
       "      <td>18</td>\n",
       "      <td>0x2791bca1f2de4661ed88a30c99a7a9449aa84174</td>\n",
       "      <td>0x831753dd7087cac61ab5644b308642cc1c33dc13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>NEXO/WETH</td>\n",
       "      <td>0x10062ec62c0be26cc9e2f50a1cf784a89ded075f</td>\n",
       "      <td>1539.525118</td>\n",
       "      <td>0.000650</td>\n",
       "      <td>6.555790e+05</td>\n",
       "      <td>4.258320e+02</td>\n",
       "      <td>851.662522</td>\n",
       "      <td>3.533491e+06</td>\n",
       "      <td>851.663967</td>\n",
       "      <td>37449</td>\n",
       "      <td>9.654010e+06</td>\n",
       "      <td>9.651758e+06</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>0x41b3966b4ff7b427969ddf5da3627d6aeae9a48e</td>\n",
       "      <td>0x7ceb23fd6bc0add59e62ac25578270cff1b9f619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>GFARM2/DAI</td>\n",
       "      <td>0x0c7ad41d3e0dbc1cfdcdd717afb0a72a65cdf069</td>\n",
       "      <td>0.001640</td>\n",
       "      <td>609.740613</td>\n",
       "      <td>1.448947e+03</td>\n",
       "      <td>8.834815e+05</td>\n",
       "      <td>427.950928</td>\n",
       "      <td>1.776941e+06</td>\n",
       "      <td>426.108702</td>\n",
       "      <td>40728</td>\n",
       "      <td>3.306061e+07</td>\n",
       "      <td>3.301471e+07</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>0x7075cab6bcca06613e2d071bd918d1a0241379e2</td>\n",
       "      <td>0x8f3cf7ad23cd3cadbd9735aff958023239c6a063</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>UCO/WETH</td>\n",
       "      <td>0x25bae75f6760ac30554cc62f9282307c3038c3a0</td>\n",
       "      <td>15952.135065</td>\n",
       "      <td>0.000063</td>\n",
       "      <td>2.258481e+06</td>\n",
       "      <td>1.415786e+02</td>\n",
       "      <td>283.157201</td>\n",
       "      <td>1.174296e+06</td>\n",
       "      <td>283.157201</td>\n",
       "      <td>578</td>\n",
       "      <td>2.687269e+05</td>\n",
       "      <td>2.676818e+05</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>0x3c720206bfacb2d16fa3ac0ed87d2048dbc401fc</td>\n",
       "      <td>0x7ceb23fd6bc0add59e62ac25578270cff1b9f619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>TECH/WETH</td>\n",
       "      <td>0x204a7adc76db7fe8c5e5f499cb3c4cff6d7282c2</td>\n",
       "      <td>69392.044470</td>\n",
       "      <td>0.000014</td>\n",
       "      <td>8.883457e+06</td>\n",
       "      <td>1.280184e+02</td>\n",
       "      <td>256.082490</td>\n",
       "      <td>1.064116e+06</td>\n",
       "      <td>256.036766</td>\n",
       "      <td>19528</td>\n",
       "      <td>4.203815e+11</td>\n",
       "      <td>5.983447e+06</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>0x6286a9e6f7e745a6d884561d88f94542d6715698</td>\n",
       "      <td>0x7ceb23fd6bc0add59e62ac25578270cff1b9f619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>USDC/MASK</td>\n",
       "      <td>0x253d637068fbf11b18d0f2a1bf3b167d37802687</td>\n",
       "      <td>9.488262</td>\n",
       "      <td>0.105393</td>\n",
       "      <td>5.227030e+05</td>\n",
       "      <td>5.508943e+04</td>\n",
       "      <td>251.674066</td>\n",
       "      <td>1.045406e+06</td>\n",
       "      <td>251.674066</td>\n",
       "      <td>16346</td>\n",
       "      <td>5.781570e+06</td>\n",
       "      <td>5.780554e+06</td>\n",
       "      <td>6</td>\n",
       "      <td>18</td>\n",
       "      <td>0x2791bca1f2de4661ed88a30c99a7a9449aa84174</td>\n",
       "      <td>0x2b9e7ccdf0f4e5b24757c1e1a80e311e34cb10c7</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        symbols                                    pairAddr        price0  \\\n",
       "0  USDC/miMATIC  0x160532d2536175d65c03b97b0630a9802c274dad      0.991700   \n",
       "1  WMATIC/QUICK  0x019ba0325f1988213d448b3472fa1cf8d07618d7    243.771603   \n",
       "2    WETH/QUICK  0x1bd06b96dd42ada85fdd0795f3b4a79db914add5      0.098358   \n",
       "3     USDC/GHST  0x096c5ccb33cfc5732bcd1f3195c13dbefc4c82f4      1.887829   \n",
       "4    USDC/QUICK  0x1f1e4c845183ef6d50e9609f16f6f9cae43bc9cb    407.070104   \n",
       "5     NEXO/WETH  0x10062ec62c0be26cc9e2f50a1cf784a89ded075f   1539.525118   \n",
       "6    GFARM2/DAI  0x0c7ad41d3e0dbc1cfdcdd717afb0a72a65cdf069      0.001640   \n",
       "7      UCO/WETH  0x25bae75f6760ac30554cc62f9282307c3038c3a0  15952.135065   \n",
       "8     TECH/WETH  0x204a7adc76db7fe8c5e5f499cb3c4cff6d7282c2  69392.044470   \n",
       "9     USDC/MASK  0x253d637068fbf11b18d0f2a1bf3b167d37802687      9.488262   \n",
       "\n",
       "       price1      reserve0      reserve1   reserveETH    reserveUSD  \\\n",
       "0    1.008369  8.399169e+06  8.469463e+06  4045.535993  1.679834e+07   \n",
       "1    0.004102  4.511018e+06  1.850510e+04  3637.156280  1.510220e+07   \n",
       "2   10.166986  1.160485e+03  1.179863e+04  2320.350438  9.634560e+06   \n",
       "3    0.529709  3.024324e+06  1.602012e+06  1461.506227  6.068472e+06   \n",
       "4    0.002457  2.307571e+06  5.668732e+03  1112.992411  4.621374e+06   \n",
       "5    0.000650  6.555790e+05  4.258320e+02   851.662522  3.533491e+06   \n",
       "6  609.740613  1.448947e+03  8.834815e+05   427.950928  1.776941e+06   \n",
       "7    0.000063  2.258481e+06  1.415786e+02   283.157201  1.174296e+06   \n",
       "8    0.000014  8.883457e+06  1.280184e+02   256.082490  1.064116e+06   \n",
       "9    0.105393  5.227030e+05  5.508943e+04   251.674066  1.045406e+06   \n",
       "\n",
       "   trackedReserveETH  txCount  untrackedVolumeUSD     volumeUSD  decimal0  \\\n",
       "0        4045.535994   802017        4.571194e+08  4.570801e+08         6   \n",
       "1        3637.156280  4015859        1.135818e+09  1.135818e+09        18   \n",
       "2        2320.350438  2413779        6.444822e+08  6.444822e+08        18   \n",
       "3        1456.731770   367496        2.378322e+08  2.378534e+08         6   \n",
       "4        1112.992411  2142838        1.081548e+09  1.081548e+09         6   \n",
       "5         851.663967    37449        9.654010e+06  9.651758e+06        18   \n",
       "6         426.108702    40728        3.306061e+07  3.301471e+07        18   \n",
       "7         283.157201      578        2.687269e+05  2.676818e+05        18   \n",
       "8         256.036766    19528        4.203815e+11  5.983447e+06        18   \n",
       "9         251.674066    16346        5.781570e+06  5.780554e+06         6   \n",
       "\n",
       "   decimal1                                    address0  \\\n",
       "0        18  0x2791bca1f2de4661ed88a30c99a7a9449aa84174   \n",
       "1        18  0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270   \n",
       "2        18  0x7ceb23fd6bc0add59e62ac25578270cff1b9f619   \n",
       "3        18  0x2791bca1f2de4661ed88a30c99a7a9449aa84174   \n",
       "4        18  0x2791bca1f2de4661ed88a30c99a7a9449aa84174   \n",
       "5        18  0x41b3966b4ff7b427969ddf5da3627d6aeae9a48e   \n",
       "6        18  0x7075cab6bcca06613e2d071bd918d1a0241379e2   \n",
       "7        18  0x3c720206bfacb2d16fa3ac0ed87d2048dbc401fc   \n",
       "8        18  0x6286a9e6f7e745a6d884561d88f94542d6715698   \n",
       "9        18  0x2791bca1f2de4661ed88a30c99a7a9449aa84174   \n",
       "\n",
       "                                     address1  \n",
       "0  0xa3fa99a148fa48d14ed51d610c367c61876997f1  \n",
       "1  0x831753dd7087cac61ab5644b308642cc1c33dc13  \n",
       "2  0x831753dd7087cac61ab5644b308642cc1c33dc13  \n",
       "3  0x385eeac5cb85a38a9a07a70c73e0a3271cfb54a7  \n",
       "4  0x831753dd7087cac61ab5644b308642cc1c33dc13  \n",
       "5  0x7ceb23fd6bc0add59e62ac25578270cff1b9f619  \n",
       "6  0x8f3cf7ad23cd3cadbd9735aff958023239c6a063  \n",
       "7  0x7ceb23fd6bc0add59e62ac25578270cff1b9f619  \n",
       "8  0x7ceb23fd6bc0add59e62ac25578270cff1b9f619  \n",
       "9  0x2b9e7ccdf0f4e5b24757c1e1a80e311e34cb10c7  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import time\n",
    "import json\n",
    "import pandas as pd\n",
    "from web3 import Web3\n",
    "import httpx\n",
    "\n",
    "pd.set_option('display.max_rows', None)\n",
    "pd.set_option('display.max_columns', None)\n",
    "pd.set_option('display.width', None)\n",
    "pd.set_option('display.max_colwidth', None)\n",
    "# pd.set_option('display.float_format', lambda x: '%.18f' % x)\n",
    "print('started...')\n",
    "\n",
    "\n",
    "thegraph_url = \"https://api.thegraph.com/subgraphs/name/proy24/quickswap-polygon\"\n",
    "\n",
    "def get_uniswap_graphql(payload) -> pd.DataFrame:\n",
    "    try:\n",
    "        r = httpx.post(\n",
    "            thegraph_url,\n",
    "            data=json.dumps(payload),\n",
    "            timeout=3600\n",
    "        ).json()\n",
    "        if r.get('data'):\n",
    "            return pd.DataFrame(r['data']['pairs'])\n",
    "        else:\n",
    "            raise ValueError('shitty service gonna shit the bed again')\n",
    "    except Exception as e:\n",
    "        print(f\"doh!: {e}\")\n",
    "\n",
    "\n",
    "graphql_payload_1st1000 = {\n",
    "    \"operationName\":\"pairs\",\n",
    "    \"variables\":{},\n",
    "    \"query\":\"query pairs {\\n pairs(first: 1000) {\\n id token0 {\\n symbol\\n name\\n id\\n decimals\\n \\n}\\n token1 {\\n symbol\\n name\\n id\\n decimals\\n \\n}\\n reserve0 reserve1 token0Price token1Price reserveUSD reserveETH trackedReserveETH volumeUSD untrackedVolumeUSD txCount \\n} \\n}\\n\"\n",
    "}\n",
    "graphql_payload_2nd1000 = {\n",
    "    \"operationName\":\"pairs\",\n",
    "    \"variables\":{},\n",
    "    \"query\":\"query pairs {\\n pairs(first: 1000, skip:1000) {\\n id token0 {\\n symbol\\n name\\n id\\n decimals\\n \\n}\\n token1 {\\n symbol\\n name\\n id\\n decimals\\n \\n}\\n reserve0 reserve1 token0Price token1Price reserveUSD reserveETH trackedReserveETH volumeUSD untrackedVolumeUSD txCount \\n} \\n}\\n\"\n",
    "}\n",
    "graphql_payload_3rd1000 = {\n",
    "    \"operationName\":\"pairs\",\n",
    "    \"variables\":{},\n",
    "    \"query\":\"query pairs {\\n pairs(first: 1000, skip:2000) {\\n id token0 {\\n symbol\\n name\\n id\\n decimals\\n \\n}\\n token1 {\\n symbol\\n name\\n id\\n decimals\\n \\n}\\n reserve0 reserve1 token0Price token1Price reserveUSD reserveETH trackedReserveETH volumeUSD untrackedVolumeUSD txCount \\n} \\n}\\n\"\n",
    "}\n",
    "\n",
    "\n",
    "df1 = get_uniswap_graphql(graphql_payload_1st1000)\n",
    "assert len(df1.index) > 0, 'df1 empty'\n",
    "df2 = get_uniswap_graphql(graphql_payload_2nd1000)\n",
    "assert len(df2.index) > 0, 'df2 empty'\n",
    "df3 = get_uniswap_graphql(graphql_payload_3rd1000)\n",
    "assert len(df3.index) > 0, 'df3 empty'\n",
    "df = pd.concat([df1, df2, df3])\n",
    "print(f\"df: {len(df)}\")\n",
    "\n",
    "# flatten thegraph token dict\n",
    "df['symbols'] = [f\"{x['symbol']}/{y['symbol']}\" for x, y in zip(df['token0'], df['token1'])]\n",
    "df['name0'] = [x['name'] for x in df['token0']]\n",
    "df['name1'] = [x['name'] for x in df['token1']]\n",
    "df['decimal0'] = [x['decimals'] for x in df['token0']]\n",
    "df['decimal1'] = [x['decimals'] for x in df['token1']]\n",
    "df['address0'] = [x['id'] for x in df['token0']]\n",
    "df['address1'] = [x['id'] for x in df['token1']]\n",
    "\n",
    "mung_cols = ['reserve0', 'reserve1', 'reserveETH', 'trackedReserveETH', 'volumeUSD', 'untrackedVolumeUSD', \\\n",
    "             'txCount', 'reserveUSD', 'token0Price', 'token1Price', 'decimal0', 'decimal1']\n",
    "df[mung_cols] = df[mung_cols].apply(pd.to_numeric, errors='coerce')\n",
    "df = df.rename(columns={'id':'pairAddr', 'token0Price': 'price0', 'token1Price': 'price1'})\n",
    "df = df[['symbols', 'pairAddr', 'price0', 'price1', 'reserve0', 'reserve1', 'reserveETH', 'reserveUSD',\\\n",
    "         'trackedReserveETH', 'txCount', 'untrackedVolumeUSD', 'volumeUSD', 'decimal0', 'decimal1', 'address0', 'address1']]\n",
    "df = df.sort_values('reserveUSD',  ascending=False)\n",
    "df = df.reset_index()\n",
    "del df['index']\n",
    "df = df.copy()\n",
    "#assert df.isnull().values.any(), 'NaN cells'\n",
    "df.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "eca48b3c-f8fa-4245-80d2-06f53102bcbf",
   "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>symbols</th>\n",
       "      <th>pairAddr</th>\n",
       "      <th>price0</th>\n",
       "      <th>price1</th>\n",
       "      <th>reserve0</th>\n",
       "      <th>reserve1</th>\n",
       "      <th>reserveETH</th>\n",
       "      <th>reserveUSD</th>\n",
       "      <th>trackedReserveETH</th>\n",
       "      <th>txCount</th>\n",
       "      <th>untrackedVolumeUSD</th>\n",
       "      <th>volumeUSD</th>\n",
       "      <th>decimal0</th>\n",
       "      <th>decimal1</th>\n",
       "      <th>address0</th>\n",
       "      <th>address1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2995</th>\n",
       "      <td>WMATIC/BALL</td>\n",
       "      <td>0x1d579674616af54595b33feb6ad9d24f550ce20a</td>\n",
       "      <td>1.000000e-04</td>\n",
       "      <td>1.000000e+04</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000e-13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270</td>\n",
       "      <td>0xeb131eddb1e8334ed8ac9f2e4a149076fdf543e1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2996</th>\n",
       "      <td>WMATIC/TES</td>\n",
       "      <td>0x1d597b609fd91da75a8fd6f57225f1adcb85cec6</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18</td>\n",
       "      <td>9</td>\n",
       "      <td>0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270</td>\n",
       "      <td>0x971e130c2236b2e5965501a2e2a2b43109a0c3b1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2997</th>\n",
       "      <td>BALL/BURN</td>\n",
       "      <td>0x1d6045c58d21937f135e878c84f89f896ebb3418</td>\n",
       "      <td>1.973739e+03</td>\n",
       "      <td>5.066526e-04</td>\n",
       "      <td>4.530000e-14</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>0x00c39b2930fe947ac8e7cd4a514ae9738b989196</td>\n",
       "      <td>0x41859e7de5b4ca7fda4ba3da4ef93a5a21d3d7f7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2998</th>\n",
       "      <td>CHI/CZR</td>\n",
       "      <td>0x1d68a332f46481276b82ee00b3390b8cbaf856fa</td>\n",
       "      <td>3.993900e-12</td>\n",
       "      <td>2.503756e+11</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>5.007511e+11</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>0x0000000000004946c0e9f43f4dee607b0ef1fa1c</td>\n",
       "      <td>0xd422089785ada2762343b209b43bc48dd7ad4ae9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2999</th>\n",
       "      <td>WMATIC/PLYTF</td>\n",
       "      <td>0x1e7d0b49c5c00f56ef0a9c82d811c2b4d0299bd9</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270</td>\n",
       "      <td>0xb848d02d94fe22d4e3c58368ebf8e22b0393e98d</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           symbols                                    pairAddr        price0  \\\n",
       "2995   WMATIC/BALL  0x1d579674616af54595b33feb6ad9d24f550ce20a  1.000000e-04   \n",
       "2996    WMATIC/TES  0x1d597b609fd91da75a8fd6f57225f1adcb85cec6  0.000000e+00   \n",
       "2997     BALL/BURN  0x1d6045c58d21937f135e878c84f89f896ebb3418  1.973739e+03   \n",
       "2998       CHI/CZR  0x1d68a332f46481276b82ee00b3390b8cbaf856fa  3.993900e-12   \n",
       "2999  WMATIC/PLYTF  0x1e7d0b49c5c00f56ef0a9c82d811c2b4d0299bd9  0.000000e+00   \n",
       "\n",
       "            price1      reserve0      reserve1  reserveETH  reserveUSD  \\\n",
       "2995  1.000000e+04  0.000000e+00  1.000000e-13         0.0         0.0   \n",
       "2996  0.000000e+00  0.000000e+00  0.000000e+00         0.0         0.0   \n",
       "2997  5.066526e-04  4.530000e-14  0.000000e+00         0.0         0.0   \n",
       "2998  2.503756e+11  2.000000e+00  5.007511e+11         0.0         0.0   \n",
       "2999  0.000000e+00  0.000000e+00  0.000000e+00         0.0         0.0   \n",
       "\n",
       "      trackedReserveETH  txCount  untrackedVolumeUSD  volumeUSD  decimal0  \\\n",
       "2995                0.0        2                 0.0        0.0        18   \n",
       "2996                0.0        0                 0.0        0.0        18   \n",
       "2997                0.0        2                 0.0        0.0        18   \n",
       "2998                0.0        2                 0.0        0.0         0   \n",
       "2999                0.0        0                 0.0        0.0        18   \n",
       "\n",
       "      decimal1                                    address0  \\\n",
       "2995        18  0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270   \n",
       "2996         9  0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270   \n",
       "2997        18  0x00c39b2930fe947ac8e7cd4a514ae9738b989196   \n",
       "2998        18  0x0000000000004946c0e9f43f4dee607b0ef1fa1c   \n",
       "2999        18  0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270   \n",
       "\n",
       "                                        address1  \n",
       "2995  0xeb131eddb1e8334ed8ac9f2e4a149076fdf543e1  \n",
       "2996  0x971e130c2236b2e5965501a2e2a2b43109a0c3b1  \n",
       "2997  0x41859e7de5b4ca7fda4ba3da4ef93a5a21d3d7f7  \n",
       "2998  0xd422089785ada2762343b209b43bc48dd7ad4ae9  \n",
       "2999  0xb848d02d94fe22d4e3c58368ebf8e22b0393e98d  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.tail()"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}