Skip to content

Instantly share code, notes, and snippets.

@cvauclair

cvauclair/curve_pools.ipynb

Created April 29, 2022 19:23
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save cvauclair/2bf2290f1f15d46bd7ea4d718ae9cedd to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save cvauclair/2bf2290f1f15d46bd7ea4d718ae9cedd to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
curve_pools.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"id": "f3e84760",
"metadata": {},
"outputs": [],
"source": [
"from subgrounds.subgrounds import Subgrounds\n",
"sg = Subgrounds()\n",
"\n",
"curve = sg.load_subgraph('https://api.thegraph.com/subgraphs/name/gvladika/curve')\n",
"curve_pools = curve.Query.pools(first = 10)"
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "436663d8",
"metadata": {},
"outputs": [],
"source": [
"[names, balances] = sg.query_df([\n",
" curve_pools.id,\n",
" curve_pools.coins.name,\n",
" curve_pools.balances\n",
"])\n"
]
},
{
"cell_type": "code",
"execution_count": 3,
"id": "d1879247",
"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>pools_id</th>\n",
" <th>pools_coins_name</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0x071c661b4deefb59e2a3ddb20db036821eee8f4b</td>\n",
" <td>Curve.fi renBTC/wBTC/sBTC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>0x071c661b4deefb59e2a3ddb20db036821eee8f4b</td>\n",
" <td>Binance Wrapped BTC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>0x0ce6a5ff5217e38315f87032cf90686c96627caa</td>\n",
" <td>Synth sEUR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>0x0ce6a5ff5217e38315f87032cf90686c96627caa</td>\n",
" <td>STASIS EURS Token</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf</td>\n",
" <td>Yearn Tether USD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf</td>\n",
" <td>Yearn USD Coin</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf</td>\n",
" <td>Yearn Dai Stablecoin</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>0x36965b1a6b97c1b33416e5d53fb5621ade1f1e80</td>\n",
" <td>USDP Stablecoin</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>0x36965b1a6b97c1b33416e5d53fb5621ade1f1e80</td>\n",
" <td>Curve.fi DAI/USDC/USDT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>0x42d7025938bec20b69cbae5a77421082407f053a</td>\n",
" <td>USDP Stablecoin</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>0x42d7025938bec20b69cbae5a77421082407f053a</td>\n",
" <td>Curve.fi DAI/USDC/USDT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>0x43b4fdfd4ff969587185cdb6f0bd875c5fc83f8c</td>\n",
" <td>Curve.fi DAI/USDC/USDT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>0x43b4fdfd4ff969587185cdb6f0bd875c5fc83f8c</td>\n",
" <td>Alchemix USD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>0x4807862aa8b2bf68830e4c8dc86d0e9a998e085a</td>\n",
" <td>Binance USD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>0x4807862aa8b2bf68830e4c8dc86d0e9a998e085a</td>\n",
" <td>Curve.fi DAI/USDC/USDT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>0x5a6a4d54456819380173272a5e8e9b9904bdf41b</td>\n",
" <td>Curve.fi DAI/USDC/USDT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>0x5a6a4d54456819380173272a5e8e9b9904bdf41b</td>\n",
" <td>Magic Internet Money</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>0x618788357d0ebd8a37e763adab3bc575d54c2c7d</td>\n",
" <td>Rai Reflex Index</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>0x618788357d0ebd8a37e763adab3bc575d54c2c7d</td>\n",
" <td>Curve.fi DAI/USDC/USDT</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>0x7f55dde206dbad629c080068923b36fe9d6bdbef</td>\n",
" <td>Curve.fi renBTC/wBTC/sBTC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>0x7f55dde206dbad629c080068923b36fe9d6bdbef</td>\n",
" <td>pTokens BTC</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" pools_id pools_coins_name\n",
"0 0x071c661b4deefb59e2a3ddb20db036821eee8f4b Curve.fi renBTC/wBTC/sBTC\n",
"1 0x071c661b4deefb59e2a3ddb20db036821eee8f4b Binance Wrapped BTC\n",
"2 0x0ce6a5ff5217e38315f87032cf90686c96627caa Synth sEUR\n",
"3 0x0ce6a5ff5217e38315f87032cf90686c96627caa STASIS EURS Token\n",
"4 0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf Yearn Tether USD\n",
"5 0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf Yearn USD Coin\n",
"6 0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf Yearn Dai Stablecoin\n",
"7 0x36965b1a6b97c1b33416e5d53fb5621ade1f1e80 USDP Stablecoin\n",
"8 0x36965b1a6b97c1b33416e5d53fb5621ade1f1e80 Curve.fi DAI/USDC/USDT\n",
"9 0x42d7025938bec20b69cbae5a77421082407f053a USDP Stablecoin\n",
"10 0x42d7025938bec20b69cbae5a77421082407f053a Curve.fi DAI/USDC/USDT\n",
"11 0x43b4fdfd4ff969587185cdb6f0bd875c5fc83f8c Curve.fi DAI/USDC/USDT\n",
"12 0x43b4fdfd4ff969587185cdb6f0bd875c5fc83f8c Alchemix USD\n",
"13 0x4807862aa8b2bf68830e4c8dc86d0e9a998e085a Binance USD\n",
"14 0x4807862aa8b2bf68830e4c8dc86d0e9a998e085a Curve.fi DAI/USDC/USDT\n",
"15 0x5a6a4d54456819380173272a5e8e9b9904bdf41b Curve.fi DAI/USDC/USDT\n",
"16 0x5a6a4d54456819380173272a5e8e9b9904bdf41b Magic Internet Money\n",
"17 0x618788357d0ebd8a37e763adab3bc575d54c2c7d Rai Reflex Index\n",
"18 0x618788357d0ebd8a37e763adab3bc575d54c2c7d Curve.fi DAI/USDC/USDT\n",
"19 0x7f55dde206dbad629c080068923b36fe9d6bdbef Curve.fi renBTC/wBTC/sBTC\n",
"20 0x7f55dde206dbad629c080068923b36fe9d6bdbef pTokens BTC"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"names"
]
},
{
"cell_type": "code",
"execution_count": 4,
"id": "01367249",
"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>pools_id</th>\n",
" <th>pools_balances</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0x071c661b4deefb59e2a3ddb20db036821eee8f4b</td>\n",
" <td>90175905</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>0x071c661b4deefb59e2a3ddb20db036821eee8f4b</td>\n",
" <td>911885899208018333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>0x0ce6a5ff5217e38315f87032cf90686c96627caa</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>0x0ce6a5ff5217e38315f87032cf90686c96627caa</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>0x36965b1a6b97c1b33416e5d53fb5621ade1f1e80</td>\n",
" <td>28656805327790606088633</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>0x36965b1a6b97c1b33416e5d53fb5621ade1f1e80</td>\n",
" <td>32923334360955792137601</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>0x42d7025938bec20b69cbae5a77421082407f053a</td>\n",
" <td>41596309615787378790744</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>0x42d7025938bec20b69cbae5a77421082407f053a</td>\n",
" <td>63938646010778145643004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>0x43b4fdfd4ff969587185cdb6f0bd875c5fc83f8c</td>\n",
" <td>211768902251462388944777936</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>0x43b4fdfd4ff969587185cdb6f0bd875c5fc83f8c</td>\n",
" <td>225583404747754201414373932</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>0x4807862aa8b2bf68830e4c8dc86d0e9a998e085a</td>\n",
" <td>20130646203839915762244747</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>0x4807862aa8b2bf68830e4c8dc86d0e9a998e085a</td>\n",
" <td>15001383672000769704639533</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>0x5a6a4d54456819380173272a5e8e9b9904bdf41b</td>\n",
" <td>90571708427005920452018849</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>0x5a6a4d54456819380173272a5e8e9b9904bdf41b</td>\n",
" <td>106815621871700857705428652</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>0x618788357d0ebd8a37e763adab3bc575d54c2c7d</td>\n",
" <td>10155649850367734716250231</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>0x618788357d0ebd8a37e763adab3bc575d54c2c7d</td>\n",
" <td>34692984175345702153037811</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>0x7f55dde206dbad629c080068923b36fe9d6bdbef</td>\n",
" <td>7453247992761154</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>0x7f55dde206dbad629c080068923b36fe9d6bdbef</td>\n",
" <td>589035150455165</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" pools_id pools_balances\n",
"0 0x071c661b4deefb59e2a3ddb20db036821eee8f4b 90175905\n",
"1 0x071c661b4deefb59e2a3ddb20db036821eee8f4b 911885899208018333\n",
"2 0x0ce6a5ff5217e38315f87032cf90686c96627caa 0\n",
"3 0x0ce6a5ff5217e38315f87032cf90686c96627caa 0\n",
"4 0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf 0\n",
"5 0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf 0\n",
"6 0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf 0\n",
"7 0x36965b1a6b97c1b33416e5d53fb5621ade1f1e80 28656805327790606088633\n",
"8 0x36965b1a6b97c1b33416e5d53fb5621ade1f1e80 32923334360955792137601\n",
"9 0x42d7025938bec20b69cbae5a77421082407f053a 41596309615787378790744\n",
"10 0x42d7025938bec20b69cbae5a77421082407f053a 63938646010778145643004\n",
"11 0x43b4fdfd4ff969587185cdb6f0bd875c5fc83f8c 211768902251462388944777936\n",
"12 0x43b4fdfd4ff969587185cdb6f0bd875c5fc83f8c 225583404747754201414373932\n",
"13 0x4807862aa8b2bf68830e4c8dc86d0e9a998e085a 20130646203839915762244747\n",
"14 0x4807862aa8b2bf68830e4c8dc86d0e9a998e085a 15001383672000769704639533\n",
"15 0x5a6a4d54456819380173272a5e8e9b9904bdf41b 90571708427005920452018849\n",
"16 0x5a6a4d54456819380173272a5e8e9b9904bdf41b 106815621871700857705428652\n",
"17 0x618788357d0ebd8a37e763adab3bc575d54c2c7d 10155649850367734716250231\n",
"18 0x618788357d0ebd8a37e763adab3bc575d54c2c7d 34692984175345702153037811\n",
"19 0x7f55dde206dbad629c080068923b36fe9d6bdbef 7453247992761154\n",
"20 0x7f55dde206dbad629c080068923b36fe9d6bdbef 589035150455165"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"balances"
]
},
{
"cell_type": "code",
"execution_count": 5,
"id": "0740dc78",
"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>pools_coins_name</th>\n",
" <th>pools_balances</th>\n",
" </tr>\n",
" <tr>\n",
" <th>pools_id</th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0x071c661b4deefb59e2a3ddb20db036821eee8f4b</th>\n",
" <td>Curve.fi renBTC/wBTC/sBTC</td>\n",
" <td>90175905</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x071c661b4deefb59e2a3ddb20db036821eee8f4b</th>\n",
" <td>Binance Wrapped BTC</td>\n",
" <td>911885899208018333</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x0ce6a5ff5217e38315f87032cf90686c96627caa</th>\n",
" <td>Synth sEUR</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x0ce6a5ff5217e38315f87032cf90686c96627caa</th>\n",
" <td>STASIS EURS Token</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf</th>\n",
" <td>Yearn Tether USD</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf</th>\n",
" <td>Yearn USD Coin</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf</th>\n",
" <td>Yearn Dai Stablecoin</td>\n",
" <td>0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x36965b1a6b97c1b33416e5d53fb5621ade1f1e80</th>\n",
" <td>USDP Stablecoin</td>\n",
" <td>28656805327790606088633</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x36965b1a6b97c1b33416e5d53fb5621ade1f1e80</th>\n",
" <td>Curve.fi DAI/USDC/USDT</td>\n",
" <td>32923334360955792137601</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x42d7025938bec20b69cbae5a77421082407f053a</th>\n",
" <td>USDP Stablecoin</td>\n",
" <td>41596309615787378790744</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x42d7025938bec20b69cbae5a77421082407f053a</th>\n",
" <td>Curve.fi DAI/USDC/USDT</td>\n",
" <td>63938646010778145643004</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x43b4fdfd4ff969587185cdb6f0bd875c5fc83f8c</th>\n",
" <td>Curve.fi DAI/USDC/USDT</td>\n",
" <td>211768902251462388944777936</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x43b4fdfd4ff969587185cdb6f0bd875c5fc83f8c</th>\n",
" <td>Alchemix USD</td>\n",
" <td>225583404747754201414373932</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x4807862aa8b2bf68830e4c8dc86d0e9a998e085a</th>\n",
" <td>Binance USD</td>\n",
" <td>20130646203839915762244747</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x4807862aa8b2bf68830e4c8dc86d0e9a998e085a</th>\n",
" <td>Curve.fi DAI/USDC/USDT</td>\n",
" <td>15001383672000769704639533</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x5a6a4d54456819380173272a5e8e9b9904bdf41b</th>\n",
" <td>Curve.fi DAI/USDC/USDT</td>\n",
" <td>90571708427005920452018849</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x5a6a4d54456819380173272a5e8e9b9904bdf41b</th>\n",
" <td>Magic Internet Money</td>\n",
" <td>106815621871700857705428652</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x618788357d0ebd8a37e763adab3bc575d54c2c7d</th>\n",
" <td>Rai Reflex Index</td>\n",
" <td>10155649850367734716250231</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x618788357d0ebd8a37e763adab3bc575d54c2c7d</th>\n",
" <td>Curve.fi DAI/USDC/USDT</td>\n",
" <td>34692984175345702153037811</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x7f55dde206dbad629c080068923b36fe9d6bdbef</th>\n",
" <td>Curve.fi renBTC/wBTC/sBTC</td>\n",
" <td>7453247992761154</td>\n",
" </tr>\n",
" <tr>\n",
" <th>0x7f55dde206dbad629c080068923b36fe9d6bdbef</th>\n",
" <td>pTokens BTC</td>\n",
" <td>589035150455165</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" pools_coins_name \\\n",
"pools_id \n",
"0x071c661b4deefb59e2a3ddb20db036821eee8f4b Curve.fi renBTC/wBTC/sBTC \n",
"0x071c661b4deefb59e2a3ddb20db036821eee8f4b Binance Wrapped BTC \n",
"0x0ce6a5ff5217e38315f87032cf90686c96627caa Synth sEUR \n",
"0x0ce6a5ff5217e38315f87032cf90686c96627caa STASIS EURS Token \n",
"0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf Yearn Tether USD \n",
"0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf Yearn USD Coin \n",
"0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf Yearn Dai Stablecoin \n",
"0x36965b1a6b97c1b33416e5d53fb5621ade1f1e80 USDP Stablecoin \n",
"0x36965b1a6b97c1b33416e5d53fb5621ade1f1e80 Curve.fi DAI/USDC/USDT \n",
"0x42d7025938bec20b69cbae5a77421082407f053a USDP Stablecoin \n",
"0x42d7025938bec20b69cbae5a77421082407f053a Curve.fi DAI/USDC/USDT \n",
"0x43b4fdfd4ff969587185cdb6f0bd875c5fc83f8c Curve.fi DAI/USDC/USDT \n",
"0x43b4fdfd4ff969587185cdb6f0bd875c5fc83f8c Alchemix USD \n",
"0x4807862aa8b2bf68830e4c8dc86d0e9a998e085a Binance USD \n",
"0x4807862aa8b2bf68830e4c8dc86d0e9a998e085a Curve.fi DAI/USDC/USDT \n",
"0x5a6a4d54456819380173272a5e8e9b9904bdf41b Curve.fi DAI/USDC/USDT \n",
"0x5a6a4d54456819380173272a5e8e9b9904bdf41b Magic Internet Money \n",
"0x618788357d0ebd8a37e763adab3bc575d54c2c7d Rai Reflex Index \n",
"0x618788357d0ebd8a37e763adab3bc575d54c2c7d Curve.fi DAI/USDC/USDT \n",
"0x7f55dde206dbad629c080068923b36fe9d6bdbef Curve.fi renBTC/wBTC/sBTC \n",
"0x7f55dde206dbad629c080068923b36fe9d6bdbef pTokens BTC \n",
"\n",
" pools_balances \n",
"pools_id \n",
"0x071c661b4deefb59e2a3ddb20db036821eee8f4b 90175905 \n",
"0x071c661b4deefb59e2a3ddb20db036821eee8f4b 911885899208018333 \n",
"0x0ce6a5ff5217e38315f87032cf90686c96627caa 0 \n",
"0x0ce6a5ff5217e38315f87032cf90686c96627caa 0 \n",
"0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf 0 \n",
"0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf 0 \n",
"0x2dded6da1bf5dbdf597c45fcfaa3194e53ecfeaf 0 \n",
"0x36965b1a6b97c1b33416e5d53fb5621ade1f1e80 28656805327790606088633 \n",
"0x36965b1a6b97c1b33416e5d53fb5621ade1f1e80 32923334360955792137601 \n",
"0x42d7025938bec20b69cbae5a77421082407f053a 41596309615787378790744 \n",
"0x42d7025938bec20b69cbae5a77421082407f053a 63938646010778145643004 \n",
"0x43b4fdfd4ff969587185cdb6f0bd875c5fc83f8c 211768902251462388944777936 \n",
"0x43b4fdfd4ff969587185cdb6f0bd875c5fc83f8c 225583404747754201414373932 \n",
"0x4807862aa8b2bf68830e4c8dc86d0e9a998e085a 20130646203839915762244747 \n",
"0x4807862aa8b2bf68830e4c8dc86d0e9a998e085a 15001383672000769704639533 \n",
"0x5a6a4d54456819380173272a5e8e9b9904bdf41b 90571708427005920452018849 \n",
"0x5a6a4d54456819380173272a5e8e9b9904bdf41b 106815621871700857705428652 \n",
"0x618788357d0ebd8a37e763adab3bc575d54c2c7d 10155649850367734716250231 \n",
"0x618788357d0ebd8a37e763adab3bc575d54c2c7d 34692984175345702153037811 \n",
"0x7f55dde206dbad629c080068923b36fe9d6bdbef 7453247992761154 \n",
"0x7f55dde206dbad629c080068923b36fe9d6bdbef 589035150455165 "
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"import pandas as pd\n",
"\n",
"pd.concat([\n",
" names.set_index('pools_id'),\n",
" balances.set_index('pools_id'),\n",
"], axis=1)"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "eedffe4b",
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"interpreter": {
"hash": "732252afc0d488e8d8aac2da345b99ad2056e80cf21cebe5aebe874c4f60b44a"
},
"kernelspec": {
"display_name": "subgrounds",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.10.4"
}
},
"nbformat": 4,
"nbformat_minor": 5
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment