Skip to content

Instantly share code, notes, and snippets.

@Evan-Kim2028

Evan-Kim2028/query_reserves.ipynb

Created April 11, 2023 00:42
Show Gist options
  • Save Evan-Kim2028/aa994ae6053acb23358d17e066fc8790 to your computer and use it in GitHub Desktop.
Save Evan-Kim2028/aa994ae6053acb23358d17e066fc8790 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
query_reserves.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"from subgrounds import Subgrounds\n",
"from subgrounds.schema import TypeRef\n",
"from subgrounds.subgraph import SyntheticField\n",
"\n",
"sg = Subgrounds()\n",
"\n",
"# Load\n",
"univ3_sg = sg.load_subgraph('https://api.thegraph.com/subgraphs/name/messari/uniswap-v3-ethereum')\n",
"\n",
"swaps_entity = univ3_sg.Swap\n",
"swaps_fp = univ3_sg.Query.swaps\n",
"\n",
"swaps_qp = univ3_sg.Query.swaps(\n",
" orderBy=univ3_sg.Query.swaps.timestamp,\n",
" orderDirection='desc'\n",
")"
]
},
{
"cell_type": "code",
"execution_count": 16,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[ swaps_pool_inputTokenBalances\n",
" 0 131741304641760\n",
" 1 62290986640001595916956\n",
" 2 558226619294529213055\n",
" 3 32508828793\n",
" 4 70711467277991\n",
" .. ...\n",
" 195 62289418130913845752029\n",
" 196 19748711524486767441797\n",
" 197 31839703019306\n",
" 198 131744304641760\n",
" 199 62289418130913845752029\n",
" \n",
" [200 rows x 1 columns],\n",
" swaps_pool_inputTokens_name\n",
" 0 USD Coin\n",
" 1 Wrapped Ether\n",
" 2 DBXen Token\n",
" 3 USD Coin\n",
" 4 USD Coin\n",
" .. ...\n",
" 195 Wrapped Ether\n",
" 196 Wrapped Ether\n",
" 197 Tether USD\n",
" 198 USD Coin\n",
" 199 Wrapped Ether\n",
" \n",
" [200 rows x 1 columns]]"
]
},
"execution_count": 16,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"\n",
"# https://api.thegraph.com/subgraphs/name/messari/uniswap-v3-ethereum/graphql?query=query+%7B%0A++liquidityPools+%7B%0A++++inputTokens+%7B%0A++++++name%0A++++%7D%0A++++inputTokenBalances%0A++%7D%0A%7D\n",
"# query {\n",
"# liquidityPools {\n",
"# inputTokens {\n",
"# name\n",
"# }\n",
"# inputTokenBalances\n",
"# }\n",
"# }\n",
"\n",
"# \"liquidityPools\": [\n",
"# {\n",
"# \"inputTokens\": [\n",
"# {\n",
"# \"name\": \"BinanceCZ\"\n",
"# },\n",
"# {\n",
"# \"name\": \"Wrapped Ether\"\n",
"# }\n",
"# ],\n",
"# \"inputTokenBalances\": [\n",
"# \"30000999999999999716385\",\n",
"# \"13655515497330990\"\n",
"# ]\n",
"# },\n",
"\n",
"# Query_df incorrectly returns single values instead of lists in the dataframe.\n",
"sg.query_df([\n",
" swaps_qp._select('pool')._select('inputTokenBalances'),\n",
" swaps_qp._select('pool')._select('inputTokens')._select('name')\n",
" # swaps_qp._select('tokenIn')._select('symbol'),\n",
" # swaps_qp._select('tokenOut')._select('symbol'),\n",
" ])"
]
},
{
"cell_type": "code",
"execution_count": 18,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"[{'x9fdac392921bc368': [{'pool': {'inputTokenBalances': [57852190417341938492,\n",
" 295841336449270084886415],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'CheckDot',\n",
" 'id': '0xcdb37a4fbc2da5b78aa4e41a432792f9533e85cc'}]},\n",
" 'id': '0xcabce80e7279c4c919bd7f7c95320b21ec946f50de67666eaecab7154e65fab330000000',\n",
" 'timestamp': '1681172819'},\n",
" {'pool': {'inputTokenBalances': [549029545658919852107631,\n",
" 856074132057685331407],\n",
" 'inputTokens': [{'name': 'Prime',\n",
" 'id': '0xb23d80f5fefcddaa212212f028021b41ded428cf'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0x8243701b4a8c339b020078431e1df18f2fb6127efc6fa1055e1135da344e30cf26000000',\n",
" 'timestamp': '1681172807'},\n",
" {'pool': {'inputTokenBalances': [131777464429751, 62271334068060979928093],\n",
" 'inputTokens': [{'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xf15f84cd3867945f2f6459b3a2663cb982fe25b28064cfc7049f1a6f5b01da3bf1000000',\n",
" 'timestamp': '1681172795'},\n",
" {'pool': {'inputTokenBalances': [57852190417341938492,\n",
" 295841336449270084886415],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'CheckDot',\n",
" 'id': '0xcdb37a4fbc2da5b78aa4e41a432792f9533e85cc'}]},\n",
" 'id': '0x365457de59ee55171624077afaf754c882124476b61ff656b4264de02277259424000000',\n",
" 'timestamp': '1681172783'},\n",
" {'pool': {'inputTokenBalances': [57852190417341938492,\n",
" 295841336449270084886415],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'CheckDot',\n",
" 'id': '0xcdb37a4fbc2da5b78aa4e41a432792f9533e85cc'}]},\n",
" 'id': '0xcf40d0767c4e2ad79af6cb61256a3a7d96d7e4ff2ab1f33b977e88e03974dd5c3e000000',\n",
" 'timestamp': '1681172771'},\n",
" {'pool': {'inputTokenBalances': [4639841954121721600807707,\n",
" 2451962831787132174267],\n",
" 'inputTokens': [{'name': 'Uniswap',\n",
" 'id': '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0x76802531f7d5e589d9352c0ad07c58d12d52c156abe8acfc1308d824771c618f15000000',\n",
" 'timestamp': '1681172759'},\n",
" {'pool': {'inputTokenBalances': [6171218133465254118943,\n",
" 88878000741658415849],\n",
" 'inputTokens': [{'name': 'DBXen Token',\n",
" 'id': '0x80f0c1c49891dcfdd40b6e0f960f84e6042bcb6f'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xdc6c5d1640c94406f573856cf5e7ec384304e82c2b6774c57175fad209c6c04e87000000',\n",
" 'timestamp': '1681172747'},\n",
" {'pool': {'inputTokenBalances': [3869473547671300683329081, 632727889054],\n",
" 'inputTokens': [{'name': 'Blur',\n",
" 'id': '0x5283d291dbcf85356a21ba090e6db59121208b44'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0xfd11356e0c4bd8c5d21cb95c165a9d2960ce17ea756b9155b1d02e12ea61d80d12000000',\n",
" 'timestamp': '1681172735'},\n",
" {'pool': {'inputTokenBalances': [31899776835633489505349,\n",
" 28986059561038618778],\n",
" 'inputTokens': [{'name': 'Render Token',\n",
" 'id': '0x6de037ef9ad2725eb40118bb1702ebb27e4aeb24'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0x928455c66b0e1cf55d7e958d854f248079a4bdf825cb517717d32012ef7b353616000000',\n",
" 'timestamp': '1681172723'},\n",
" {'pool': {'inputTokenBalances': [980676294494115, 547514108791],\n",
" 'inputTokens': [{'name': 'HEX',\n",
" 'id': '0x2b591e99afe9f32eaa6214f7b7629768c40eeb39'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0x6a7d18dd961d0f8fcf4bfc123988f2abe1a3d32c8dcdaff4b5e0e42fcf155f16c6000000',\n",
" 'timestamp': '1681172711'},\n",
" {'pool': {'inputTokenBalances': [13023797278789968217824, 23733197181671],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'Tether USD',\n",
" 'id': '0xdac17f958d2ee523a2206206994597c13d831ec7'}]},\n",
" 'id': '0xc2051a8fc5ca76e273c2a8152a72500a5f9e1b42f86945e7c255c0c8f34fc5f656010000',\n",
" 'timestamp': '1681172699'},\n",
" {'pool': {'inputTokenBalances': [442495414195562535397997,\n",
" 409139632481342291656],\n",
" 'inputTokens': [{'name': 'Render Token',\n",
" 'id': '0x6de037ef9ad2725eb40118bb1702ebb27e4aeb24'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0x74b7b528d708cb850cf41f6243ce42b466bb981230c28c6a51502ed93c3b62bd02000000',\n",
" 'timestamp': '1681172687'},\n",
" {'pool': {'inputTokenBalances': [442495414195562535397997,\n",
" 409139632481342291656],\n",
" 'inputTokens': [{'name': 'Render Token',\n",
" 'id': '0x6de037ef9ad2725eb40118bb1702ebb27e4aeb24'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xd54506f1d42b0537369f4f5350223e7e2d11f88c317afae05964450e94c5169905000000',\n",
" 'timestamp': '1681172675'},\n",
" {'pool': {'inputTokenBalances': [363445065918490238191442, 513112295166],\n",
" 'inputTokens': [{'name': 'Stader',\n",
" 'id': '0x30d20208d987713f46dfd34ef128bb16c404d10f'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0xf956507422f946971fa8293159bcac03e7b2840436a69fba08a4c043713213bd7c000000',\n",
" 'timestamp': '1681172663'},\n",
" {'pool': {'inputTokenBalances': [4639841954121721600807707,\n",
" 2451962831787132174267],\n",
" 'inputTokens': [{'name': 'Uniswap',\n",
" 'id': '0x1f9840a85d5af5bf1d1762f925bdaddc4201f984'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xc5befda96d72254f1e51c9672f8cfb53d0e823fb11569d3c0c1e7c60e6dd32d402000000',\n",
" 'timestamp': '1681172651'},\n",
" {'pool': {'inputTokenBalances': [5518225192579497, 4416026541457],\n",
" 'inputTokens': [{'name': 'HEX',\n",
" 'id': '0x2b591e99afe9f32eaa6214f7b7629768c40eeb39'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0xfccc2b4f5c488dc8f3cbb8878911a2684c28d76a6866fe9e4623fe16875c613391000000',\n",
" 'timestamp': '1681172639'},\n",
" {'pool': {'inputTokenBalances': [131777464429751, 62271334068060979928093],\n",
" 'inputTokens': [{'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xd9849d1a51d70802217221447a113a17345c9fdd864fc0b50d17b5277e26687d8c000000',\n",
" 'timestamp': '1681172615'},\n",
" {'pool': {'inputTokenBalances': [558226619294529213055, 32508828793],\n",
" 'inputTokens': [{'name': 'DBXen Token',\n",
" 'id': '0x80f0c1c49891dcfdd40b6e0f960f84e6042bcb6f'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0xef09d526713d30564c038ea28bd59b6ac93d4a65560bdc06f59554d278b89d349d000000',\n",
" 'timestamp': '1681172603'},\n",
" {'pool': {'inputTokenBalances': [71290764152991, 5525087968431],\n",
" 'inputTokens': [{'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'},\n",
" {'name': 'Tether USD',\n",
" 'id': '0xdac17f958d2ee523a2206206994597c13d831ec7'}]},\n",
" 'id': '0xf8d54bdc84cc346b90c696e4d8a54449a47bdc277ef26fb4ddb5acbbcf4278188e000000',\n",
" 'timestamp': '1681172591'},\n",
" {'pool': {'inputTokenBalances': [71290764152991, 5525087968431],\n",
" 'inputTokens': [{'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'},\n",
" {'name': 'Tether USD',\n",
" 'id': '0xdac17f958d2ee523a2206206994597c13d831ec7'}]},\n",
" 'id': '0xf242f15ffc2fad339c5322f62eacd6f546867a39f50f3421773bc1b9480959023e000000',\n",
" 'timestamp': '1681172579'},\n",
" {'pool': {'inputTokenBalances': [5518225192579497, 4416026541457],\n",
" 'inputTokens': [{'name': 'HEX',\n",
" 'id': '0x2b591e99afe9f32eaa6214f7b7629768c40eeb39'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0xfad4a1913bbc8103b38cee0c78106c9f3b78f1f87b4158862428830f8e2eb412b5000000',\n",
" 'timestamp': '1681172567'},\n",
" {'pool': {'inputTokenBalances': [2425532903506918, 582460144804848772267],\n",
" 'inputTokens': [{'name': 'HEX',\n",
" 'id': '0x2b591e99afe9f32eaa6214f7b7629768c40eeb39'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xdcf08ae82b8fb47822dfb222f5bc2e87a7b37f591d6deef3ff5cae494e86faa487000000',\n",
" 'timestamp': '1681172555'},\n",
" {'pool': {'inputTokenBalances': [2425532903506918, 582460144804848772267],\n",
" 'inputTokens': [{'name': 'HEX',\n",
" 'id': '0x2b591e99afe9f32eaa6214f7b7629768c40eeb39'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xfad4217df1bcc2bc0bcf81243e8a3d8bca1645fefa0767c482fcf0c515338eb3bd010000',\n",
" 'timestamp': '1681172543'},\n",
" {'pool': {'inputTokenBalances': [442495414195562535397997,\n",
" 409139632481342291656],\n",
" 'inputTokens': [{'name': 'Render Token',\n",
" 'id': '0x6de037ef9ad2725eb40118bb1702ebb27e4aeb24'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0x32aa9a1b3f47dcda6ff366f0c9706287f4a002cb572831a4120e9186b38b4b8852000000',\n",
" 'timestamp': '1681172531'},\n",
" {'pool': {'inputTokenBalances': [3880879434810711405999107, 626050239209],\n",
" 'inputTokens': [{'name': 'Blur',\n",
" 'id': '0x5283d291dbcf85356a21ba090e6db59121208b44'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0xe40330bfd847ac8266b33177065efed5b6f6bff0366ea3d38d5b2ccc4f1e983c13000000',\n",
" 'timestamp': '1681172507'},\n",
" {'pool': {'inputTokenBalances': [2425532903506918, 582460144804848772267],\n",
" 'inputTokens': [{'name': 'HEX',\n",
" 'id': '0x2b591e99afe9f32eaa6214f7b7629768c40eeb39'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xcdbac7ea41d90559c591a4f76f9e91c7cc7392981bd041b50606a37f02e0cce699000000',\n",
" 'timestamp': '1681172495'},\n",
" {'pool': {'inputTokenBalances': [442495414195562535397997,\n",
" 409139632481342291656],\n",
" 'inputTokens': [{'name': 'Render Token',\n",
" 'id': '0x6de037ef9ad2725eb40118bb1702ebb27e4aeb24'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0x98ce76a9751d06b1e898a5e19ca533c6784414fbb9292c84699f0eabecfc1e3b2c000000',\n",
" 'timestamp': '1681172483'},\n",
" {'pool': {'inputTokenBalances': [13023797278789968217824, 23733197181671],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'Tether USD',\n",
" 'id': '0xdac17f958d2ee523a2206206994597c13d831ec7'}]},\n",
" 'id': '0x7afae765061039fd73ba20e4a9684660c578346d5d1f119bb37c35643477fff0b6000000',\n",
" 'timestamp': '1681172471'},\n",
" {'pool': {'inputTokenBalances': [131777464429751, 62271334068060979928093],\n",
" 'inputTokens': [{'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0x819a51eabc209c0a873d156f5cb01548c856cd04cb9270cd53131a7c0ff6560237010000',\n",
" 'timestamp': '1681172459'},\n",
" {'pool': {'inputTokenBalances': [157677965173706884614129464413,\n",
" 11481580941680750726],\n",
" 'inputTokens': [{'name': 'Xenlon Mars',\n",
" 'id': '0x36ff4dae0e88113d68b1209e245b0e3af92e9d58'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xcd9d9e284302e26c3860cca857f4cf204aae56223c49e61e39eb5019425ff601c1000000',\n",
" 'timestamp': '1681172447'},\n",
" {'pool': {'inputTokenBalances': [170226326191925587402613, 3653891583],\n",
" 'inputTokens': [{'name': 'IPI Shorter',\n",
" 'id': '0x888888888888f195e27a2e0f98d712952ab9348e'},\n",
" {'name': 'Tether USD',\n",
" 'id': '0xdac17f958d2ee523a2206206994597c13d831ec7'}]},\n",
" 'id': '0xd6f3d652613865728607459bac5f59a7f453da90957f2366e0661079d6c0135810010000',\n",
" 'timestamp': '1681172435'},\n",
" {'pool': {'inputTokenBalances': [59103171015834930428601627103,\n",
" 112053584624],\n",
" 'inputTokens': [{'name': 'XEN Crypto',\n",
" 'id': '0x06450dee7fd2fb8e39061434babcfc05599a6fb8'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0xf32b76cc3bcaeb685626176137ae79569e4c8ab385876dd2fd5db6c24b623a6847000000',\n",
" 'timestamp': '1681172423'},\n",
" {'pool': {'inputTokenBalances': [6280832655010531080040572,\n",
" 517046585486744943040],\n",
" 'inputTokens': [{'name': 'Blur',\n",
" 'id': '0x5283d291dbcf85356a21ba090e6db59121208b44'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xd88c78ba1242d8782744d06ff4a92f795123758ef7579c3d46e0dcd56078829512000000',\n",
" 'timestamp': '1681172411'},\n",
" {'pool': {'inputTokenBalances': [266462122986995512820367, 86749998513],\n",
" 'inputTokens': [{'name': 'Hifi Finance',\n",
" 'id': '0x4b9278b94a1112cad404048903b8d343a810b07e'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0xf8c6a41c91b9064ce2d79e8616bcd578eafb40405d9a45b02fb663de588cb6c62c000000',\n",
" 'timestamp': '1681172399'},\n",
" {'pool': {'inputTokenBalances': [263998782142744478650795449150,\n",
" 213534993347038445967],\n",
" 'inputTokens': [{'name': 'XEN Crypto',\n",
" 'id': '0x06450dee7fd2fb8e39061434babcfc05599a6fb8'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xbf352bafbce0aa1fdc9f5a2cbf8f6723bda1924cc44be0dd6b494b275cc8e36876010000',\n",
" 'timestamp': '1681172387'},\n",
" {'pool': {'inputTokenBalances': [363445065918490238191442, 513112295166],\n",
" 'inputTokens': [{'name': 'Stader',\n",
" 'id': '0x30d20208d987713f46dfd34ef128bb16c404d10f'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0x9e0908c118296b319fe2bfa4443b2af69c73aa6744c7024bf595b08a23772e425a010000',\n",
" 'timestamp': '1681172375'},\n",
" {'pool': {'inputTokenBalances': [68999844787875493285,\n",
" 283799363984725671290350],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'ZigZag', 'id': '0xc91a71a1ffa3d8b22ba615ba1b9c01b2bbbf55ad'}]},\n",
" 'id': '0xdd915c882c70404aaff67b79f9e3cffb18fc606bd09cc3dda3728e3f3f7215ceeb020000',\n",
" 'timestamp': '1681172363'},\n",
" {'pool': {'inputTokenBalances': [3880879434810711405999107, 626050239209],\n",
" 'inputTokens': [{'name': 'Blur',\n",
" 'id': '0x5283d291dbcf85356a21ba090e6db59121208b44'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0xbba1dc230df8a032f97196a25d77f54dd16bcccd6cc80d7fd4ef68dae754321307000000',\n",
" 'timestamp': '1681172351'},\n",
" {'pool': {'inputTokenBalances': [131777464429751, 62271334068060979928093],\n",
" 'inputTokens': [{'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xd9dc60bddf22245f993058fbd2f29d316836b961d1d562a6add7b714ed04646988000000',\n",
" 'timestamp': '1681172339'},\n",
" {'pool': {'inputTokenBalances': [542024599747649088159,\n",
" 289873262510010579520],\n",
" 'inputTokens': [{'name': 'Illuvium',\n",
" 'id': '0x767fe9edc9e0df98e07454847909b5e959d7ca0e'},\n",
" {'name': 'Escrowed Illuvium 2',\n",
" 'id': '0x7e77dcb127f99ece88230a64db8d595f31f1b068'}]},\n",
" 'id': '0x18456574d16306b618dd34a0d2b47c4cd1d21cf7808b138e030fefbd223a7cf962000000',\n",
" 'timestamp': '1681172327'},\n",
" {'pool': {'inputTokenBalances': [7074606880162925852733565998,\n",
" 231015118522927204760],\n",
" 'inputTokens': [{'name': 'XEN Crypto',\n",
" 'id': '0x06450dee7fd2fb8e39061434babcfc05599a6fb8'},\n",
" {'name': 'DBXen Token',\n",
" 'id': '0x80f0c1c49891dcfdd40b6e0f960f84e6042bcb6f'}]},\n",
" 'id': '0x74f35ecb6c77fa67d39faa711c6f3248aa3afb889f0a2e7c94834fc9bb79665d09000000',\n",
" 'timestamp': '1681172315'},\n",
" {'pool': {'inputTokenBalances': [549029545658919852107631,\n",
" 856074132057685331407],\n",
" 'inputTokens': [{'name': 'Prime',\n",
" 'id': '0xb23d80f5fefcddaa212212f028021b41ded428cf'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xfd989e7ce9793662258b6b015b1743a23f9b08785c4b76e7fc17462d9738ae201c000000',\n",
" 'timestamp': '1681172303'},\n",
" {'pool': {'inputTokenBalances': [6171218133465254118943,\n",
" 88878000741658415849],\n",
" 'inputTokens': [{'name': 'DBXen Token',\n",
" 'id': '0x80f0c1c49891dcfdd40b6e0f960f84e6042bcb6f'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xfcf85fcb92b39e5f7b216446ac98998580bdfdfb06032df404be97deee1ef21446010000',\n",
" 'timestamp': '1681172279'},\n",
" {'pool': {'inputTokenBalances': [48921079462063050447, 12807793968],\n",
" 'inputTokens': [{'name': 'UwU Lend',\n",
" 'id': '0x55c08ca52497e2f1534b59e2917bf524d4765257'},\n",
" {'name': 'Tether USD',\n",
" 'id': '0xdac17f958d2ee523a2206206994597c13d831ec7'}]},\n",
" 'id': '0x7101e072daafcd6e093a2a19ae60569b1d5cbdf4d90bed5f3c6e752569ab450692000000',\n",
" 'timestamp': '1681172267'},\n",
" {'pool': {'inputTokenBalances': [5518225192579497, 4416026541457],\n",
" 'inputTokens': [{'name': 'HEX',\n",
" 'id': '0x2b591e99afe9f32eaa6214f7b7629768c40eeb39'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0xcbf71703cae07ee6bd8538712550285670cbcca1275bfbe951cbb0a691a7edfe3c010000',\n",
" 'timestamp': '1681172255'},\n",
" {'pool': {'inputTokenBalances': [24725497739721822240930565,\n",
" 6781146300175452501319],\n",
" 'inputTokens': [{'name': 'BitDAO',\n",
" 'id': '0x1a4b46696b2bb4794eb3d4c26f1c55f9170fa4c5'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xe90212bdf4b4905549130e459abfbe8f54629bc04bce80db6b655892772c525052010000',\n",
" 'timestamp': '1681172243'},\n",
" {'pool': {'inputTokenBalances': [227230715936946341437, 672274298669334],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'Theopetra',\n",
" 'id': '0xfac0403a24229d7e2edd994d50f5940624cbeac2'}]},\n",
" 'id': '0x8b37ff60d109b7b25b863a13af74c22a3e7fa827a6b9af59de03c800627d39ebab000000',\n",
" 'timestamp': '1681172231'},\n",
" {'pool': {'inputTokenBalances': [6163461990152082677041,\n",
" 2809518728012498196416],\n",
" 'inputTokens': [{'name': 'Coinbase Wrapped Staked ETH',\n",
" 'id': '0xbe9895146f7af43049ca1c1ae358b0541ea49704'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xd828b8c4fc422234230c224d66cb401e9e59ac8197ff412413832a5314b8df2544010000',\n",
" 'timestamp': '1681172219'},\n",
" {'pool': {'inputTokenBalances': [59103171015834930428601627103,\n",
" 112053584624],\n",
" 'inputTokens': [{'name': 'XEN Crypto',\n",
" 'id': '0x06450dee7fd2fb8e39061434babcfc05599a6fb8'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0x1d3ce1167b17702128a7a603c7769da434bbe8b6ee75e2605c330c2ae7197077ba000000',\n",
" 'timestamp': '1681172207'},\n",
" {'pool': {'inputTokenBalances': [5153193917004061043,\n",
" 44713837747417336453100],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'Tribe', 'id': '0xc7283b66eb1eb5fb86327f08e1b5816b0720212b'}]},\n",
" 'id': '0xd5264e555cb6c20b496587ad26a091883e49bde8c12190f893388a7832518968ea000000',\n",
" 'timestamp': '1681172195'},\n",
" {'pool': {'inputTokenBalances': [2425532903506918, 582460144804848772267],\n",
" 'inputTokens': [{'name': 'HEX',\n",
" 'id': '0x2b591e99afe9f32eaa6214f7b7629768c40eeb39'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xf3f532de15fda94ff4c9b499904bc065f69ba40c36f15c075ae1a3fd9b7b00d484000000',\n",
" 'timestamp': '1681172183'},\n",
" {'pool': {'inputTokenBalances': [131787464429751, 62266105983708270788644],\n",
" 'inputTokens': [{'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xc5b8a6639060501170077bfc20ca983dc3ef9dfd37855f6c3c2a7c996ff087acbc000000',\n",
" 'timestamp': '1681172171'},\n",
" {'pool': {'inputTokenBalances': [2091330840035564885457725,\n",
" 2112708210591134606176],\n",
" 'inputTokens': [{'name': 'ChainLink Token',\n",
" 'id': '0x514910771af9ca656af840dff83e8264ecf986ca'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xb9108187ba8f70370a84dc2caecf6fc8df32b42d77eec38e45a1efe650e75235db000000',\n",
" 'timestamp': '1681172159'},\n",
" {'pool': {'inputTokenBalances': [142940918078, 22936331734046152299882235],\n",
" 'inputTokens': [{'name': 'Tether USD',\n",
" 'id': '0xdac17f958d2ee523a2206206994597c13d831ec7'},\n",
" {'name': 'SAITO', 'id': '0xfa14fa6958401314851a17d6c5360ca29f74b57b'}]},\n",
" 'id': '0xee903c5b6d0af4583ea9bef7f5ddaa74c989051cc5a4e500ccce3f7d4e84370858000000',\n",
" 'timestamp': '1681172147'},\n",
" {'pool': {'inputTokenBalances': [131787464429751, 62266105983708270788644],\n",
" 'inputTokens': [{'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xb0d6970dbd351f291e67334a10a89b9c543bf0e09107e84ef60d7700942d118605000000',\n",
" 'timestamp': '1681172135'},\n",
" {'pool': {'inputTokenBalances': [1219412240721695049856929, 607597615216],\n",
" 'inputTokens': [{'name': 'Dai Stablecoin',\n",
" 'id': '0x6b175474e89094c44da98b954eedeac495271d0f'},\n",
" {'name': 'Tether USD',\n",
" 'id': '0xdac17f958d2ee523a2206206994597c13d831ec7'}]},\n",
" 'id': '0xaf4d6b2e7f0996ce8a8548d289bfa07fb300b05997a02e168c4d140b321484ca5a000000',\n",
" 'timestamp': '1681172123'},\n",
" {'pool': {'inputTokenBalances': [130245413261, 25355224899447520489880],\n",
" 'inputTokens': [{'name': 'Wrapped BTC',\n",
" 'id': '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xf5612fc443c9d8dd2743d6dca38f4e89b7da054581ac684eeeed64a9e34abedbcb000000',\n",
" 'timestamp': '1681172111'},\n",
" {'pool': {'inputTokenBalances': [363445065918490238191442, 513112295166],\n",
" 'inputTokens': [{'name': 'Stader',\n",
" 'id': '0x30d20208d987713f46dfd34ef128bb16c404d10f'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0xb8c8e81011f46561cbbfaf4776eb071d7a38387fcc68653df8e9b675b3ffd06017000000',\n",
" 'timestamp': '1681172099'},\n",
" {'pool': {'inputTokenBalances': [26004482760272882901,\n",
" 2078944755794968473761045052550],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'PAWSWAP',\n",
" 'id': '0xdc63269ea166b70d4780b3a11f5c825c2b761b01'}]},\n",
" 'id': '0xe536035a8224f8784de11edc62b2e420d0de8b9dbc8400b3424b8ac89eca42f029000000',\n",
" 'timestamp': '1681172087'},\n",
" {'pool': {'inputTokenBalances': [8933249940724387444316481894756,\n",
" 691336768032766548409],\n",
" 'inputTokens': [{'name': 'ShibOriginalVision',\n",
" 'id': '0x2c5bc2ba3614fd27fcc7022ea71d9172e2632c16'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0x84299c9a3355eda20dcd6ced726df87309fdf6656d4755705cc3d4a959ae3a99b3000000',\n",
" 'timestamp': '1681172075'},\n",
" {'pool': {'inputTokenBalances': [819473493784017434596879359, 347821717],\n",
" 'inputTokens': [{'name': 'Xoloitzcuintli',\n",
" 'id': '0x3252d4221f92b7af3774da8312f01600ec84b252'},\n",
" {'name': 'Tether USD',\n",
" 'id': '0xdac17f958d2ee523a2206206994597c13d831ec7'}]},\n",
" 'id': '0x1dd110c29c655d70594746b71b1f6f9a3cea38f6c049ec6d05fd363266c3532df8000000',\n",
" 'timestamp': '1681172063'},\n",
" {'pool': {'inputTokenBalances': [39814644502529019115,\n",
" 4845834200036201021695110],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'THX Network',\n",
" 'id': '0xe632ea2ef2cfd8fc4a2731c76f99078aef6a4b31'}]},\n",
" 'id': '0x12422668c793bf3e6f9e8c37e6e3f7cbd901836aa1ddb6547d5d17a7be1150ed47000000',\n",
" 'timestamp': '1681172051'},\n",
" {'pool': {'inputTokenBalances': [131787464429751, 62266105983708270788644],\n",
" 'inputTokens': [{'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xfa6e51ec83373bec40773b3ca143c9a47d00f271ed8e9ab847dabeba58f7868d04010000',\n",
" 'timestamp': '1681172039'},\n",
" {'pool': {'inputTokenBalances': [142335424691527761809028, 7032948653],\n",
" 'inputTokens': [{'name': 'SpaceY Token',\n",
" 'id': '0x58fad9e3c3ae54c9ba98c3f0e4bf88ab3e8cf3c5'},\n",
" {'name': 'Tether USD',\n",
" 'id': '0xdac17f958d2ee523a2206206994597c13d831ec7'}]},\n",
" 'id': '0xe699b96b527dbee04ed65583f8b895b0caef0fd55d1d98a8e54df4bf90fa335096000000',\n",
" 'timestamp': '1681172027'},\n",
" {'pool': {'inputTokenBalances': [57852190417341938492,\n",
" 295841336449270084886415],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'CheckDot',\n",
" 'id': '0xcdb37a4fbc2da5b78aa4e41a432792f9533e85cc'}]},\n",
" 'id': '0xce0b5f43473d5f6d62ed3979b0133523e39af796abaaa1f0af8b4ea3c3d704da1e000000',\n",
" 'timestamp': '1681172015'},\n",
" {'pool': {'inputTokenBalances': [13023718776302425693502, 23733347181671],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'Tether USD',\n",
" 'id': '0xdac17f958d2ee523a2206206994597c13d831ec7'}]},\n",
" 'id': '0xe3ffc2192e38b8e750a372d094ab19eec6ac2a4cc22f360fcb7161139f83710fdc000000',\n",
" 'timestamp': '1681172003'},\n",
" {'pool': {'inputTokenBalances': [1770758944829262643473231374477,\n",
" 35034565639508588703],\n",
" 'inputTokens': [{'name': 'Astra DAO',\n",
" 'id': '0x7e9c15c43f0d6c4a12e6bdff7c7d55d0f80e3e23'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xee54a2bbf673f323386d78b6960b9739583bce39a9a4143a2cbabdc425a98dee3e000000',\n",
" 'timestamp': '1681171991'},\n",
" {'pool': {'inputTokenBalances': [13753027735402626106, 1309278512342094477],\n",
" 'inputTokens': [{'name': 'Hedron',\n",
" 'id': '0x3819f64f282bf135d62168c1e513280daf905e06'},\n",
" {'name': 'Poly Maximus',\n",
" 'id': '0x9d93692e826a4bd9e903e2a27d7fbd1e116efdad'}]},\n",
" 'id': '0xec0f98caf34cbef6d997d27a813c8d0eb6fd2f7fe6a2eabbde3216c883c52af60d000000',\n",
" 'timestamp': '1681171979'},\n",
" {'pool': {'inputTokenBalances': [1529004743903403106940137,\n",
" 201421304708561863612],\n",
" 'inputTokens': [{'name': 'Pundi X Token',\n",
" 'id': '0x0fd10b9899882a6f2fcb5c371e17e70fdee00c38'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xaf74840e03d5ffb625aa0f8d98a3e57f223058bf748b791aad535afbdfeb3ffb10000000',\n",
" 'timestamp': '1681171967'},\n",
" {'pool': {'inputTokenBalances': [512487769569573115515,\n",
" 236210452362882657372812],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'Rocket Pool Protocol',\n",
" 'id': '0xd33526068d116ce69f19a9ee46f0bd304f21a51f'}]},\n",
" 'id': '0x467b155e82086f061174c2b0b686e58ea9be6ff06c76840baf1c0a237c84281513000000',\n",
" 'timestamp': '1681171955'},\n",
" {'pool': {'inputTokenBalances': [9535712265, 71512312170855558497825],\n",
" 'inputTokens': [{'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'},\n",
" {'name': 'StargateToken',\n",
" 'id': '0xaf5191b0de278c7286d6c7cc6ab6bb8a73ba2cd6'}]},\n",
" 'id': '0xe5530d82364acdb30e0c46f423a448f47222faddd04fadd24f3a44332e5c1e2008000000',\n",
" 'timestamp': '1681171943'},\n",
" {'pool': {'inputTokenBalances': [831136505774443496031224,\n",
" 802185713519069235274],\n",
" 'inputTokens': [{'name': 'ApeCoin',\n",
" 'id': '0x4d224452801aced8b2f0aebe155379bb5d594381'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0x8d7d014a0528a9b9798105820c9cbcab848a8785c1b59923cebf86c3d0c0c4fec2000000',\n",
" 'timestamp': '1681171931'},\n",
" {'pool': {'inputTokenBalances': [5518225192579497, 4416026541457],\n",
" 'inputTokens': [{'name': 'HEX',\n",
" 'id': '0x2b591e99afe9f32eaa6214f7b7629768c40eeb39'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0xd31ae2d1f9fc05d84c06efcab0772ed7b37d841eaba8fe8aa5d1215a06e2830a7a000000',\n",
" 'timestamp': '1681171919'},\n",
" {'pool': {'inputTokenBalances': [131787464429751, 62266105983708270788644],\n",
" 'inputTokens': [{'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xbc6a496efc7e197236edf7a7617099553b80a243f46eacc895f29d80561ca22823000000',\n",
" 'timestamp': '1681171907'},\n",
" {'pool': {'inputTokenBalances': [12766334116850120507156,\n",
" 437755072112032785382],\n",
" 'inputTokens': [{'name': '',\n",
" 'id': '0x9f8f72aa9304c8b593d555f12ef6589cc3a579a2'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xf884a050eaac708894b8dced0ab17a3272cb4901306c79b4bd5c69662d112f730e000000',\n",
" 'timestamp': '1681171895'},\n",
" {'pool': {'inputTokenBalances': [49970390575423079191,\n",
" 1138931218300256319672631],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'Defactor',\n",
" 'id': '0xe0bceef36f3a6efdd5eebfacd591423f8549b9d5'}]},\n",
" 'id': '0xe53ab5d684116dc4b1a202df3c96f16a981647b912f4080b37a13542e1a03d727c000000',\n",
" 'timestamp': '1681171883'},\n",
" {'pool': {'inputTokenBalances': [14122758352394106038,\n",
" 369785226954832675609835],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'CryptoGPT Token',\n",
" 'id': '0xd04e772bc0d591fbd288f2e2a86afa3d3cb647f8'}]},\n",
" 'id': '0x56b2b0b72adcc57c46128536dcc906148c98051d179dd1e2b0454d199a0ef4aa15000000',\n",
" 'timestamp': '1681171871'},\n",
" {'pool': {'inputTokenBalances': [131787464429751, 62266105983708270788644],\n",
" 'inputTokens': [{'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xc87a79a6b6f5878c8d5a9bee80bb56051aea466ca8925eef0f1d9a121aa1016f02000000',\n",
" 'timestamp': '1681171859'},\n",
" {'pool': {'inputTokenBalances': [3880879434810711405999107, 626050239209],\n",
" 'inputTokens': [{'name': 'Blur',\n",
" 'id': '0x5283d291dbcf85356a21ba090e6db59121208b44'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0xee9e143a0f9e46b7cf44d9c6a24e115805f02cefbcb9f4a03146c52e4de13c2e02000000',\n",
" 'timestamp': '1681171847'},\n",
" {'pool': {'inputTokenBalances': [131787464429751, 62266105983708270788644],\n",
" 'inputTokens': [{'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0x90ddd009c43aa5481a3b3918f0efb44ce19a0e310ee4d5de3e64108144c2781006010000',\n",
" 'timestamp': '1681171835'},\n",
" {'pool': {'inputTokenBalances': [13023507912202706971260, 23733750095476],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'Tether USD',\n",
" 'id': '0xdac17f958d2ee523a2206206994597c13d831ec7'}]},\n",
" 'id': '0xa5c5a270568acdef1e3d07d9124afc9daf6fb48c6fa53f1a57d67b0914d0a4647b000000',\n",
" 'timestamp': '1681171823'},\n",
" {'pool': {'inputTokenBalances': [4455344, 1674825420948345280],\n",
" 'inputTokens': [{'name': 'Wrapped BTC',\n",
" 'id': '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xf00d04d7d65b8238dce82150ae48497f5a7b755d1e5140031701af177a7f7d9dd7000000',\n",
" 'timestamp': '1681171811'},\n",
" {'pool': {'inputTokenBalances': [2425532903506918, 582460144804848772267],\n",
" 'inputTokens': [{'name': 'HEX',\n",
" 'id': '0x2b591e99afe9f32eaa6214f7b7629768c40eeb39'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0x7ac4a4461dcd8df5b2122c8b5482cd8e3e8c0c43bf2c6521b6dbc51f29e9ad0cb1000000',\n",
" 'timestamp': '1681171799'},\n",
" {'pool': {'inputTokenBalances': [4202300823181127503960176,\n",
" 3093906356551972214517],\n",
" 'inputTokens': [{'name': 'Lido DAO Token',\n",
" 'id': '0x5a98fcbea516cf06857215779fd812ca3bef1b32'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xd0cfc8d5302d921949f4df56db602056b283ca6212f2b99afa605114c509b4e11e000000',\n",
" 'timestamp': '1681171787'},\n",
" {'pool': {'inputTokenBalances': [52161577818604055532337,\n",
" 435219060435137088143],\n",
" 'inputTokens': [{'name': 'Metis Token',\n",
" 'id': '0x9e32b13ce7f2e80a01932b42553652e053d6ed8e'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xea96ac5281e7452af7acc14f75f0d22f4e2879970c5883406beafc60afebc85b13000000',\n",
" 'timestamp': '1681171775'},\n",
" {'pool': {'inputTokenBalances': [2174491231482540532306502052,\n",
" 935517136217062652352],\n",
" 'inputTokens': [{'name': 'WoofWork.io',\n",
" 'id': '0x6bc08509b36a98e829dffad49fde5e412645d0a3'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xed88873d9bdffcaaee5ca71cc21ee52c043d97f8c8e36dd9fdb9a1875ff1f0740c000000',\n",
" 'timestamp': '1681171763'},\n",
" {'pool': {'inputTokenBalances': [3654762206610196651020,\n",
" 17722944125155540113],\n",
" 'inputTokens': [{'name': 'Numeraire',\n",
" 'id': '0x1776e1f26f98b1a5df9cd347953a26dd3cb46671'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0x7a9d5ddfbeaa304b5a0a6fc87b391c664045cab3266e754a52aa8448ccfb29c21d000000',\n",
" 'timestamp': '1681171751'},\n",
" {'pool': {'inputTokenBalances': [35138288691, 40296778918900852632888],\n",
" 'inputTokens': [{'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'},\n",
" {'name': 'ZigZag', 'id': '0xc91a71a1ffa3d8b22ba615ba1b9c01b2bbbf55ad'}]},\n",
" 'id': '0xfde25e0313ce53d14d2e10b7c362ce5d06bbef73d6c143f5e5187eb7dcd62b0b2c010000',\n",
" 'timestamp': '1681171739'},\n",
" {'pool': {'inputTokenBalances': [75477346977891114780, 422032964463996],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'Alchemy',\n",
" 'id': '0xed04915c23f00a313a544955524eb7dbd823143d'}]},\n",
" 'id': '0xf575943cf0451ff2a08a45860f88889efe6c356daf0e90e81684eb5d506903de41000000',\n",
" 'timestamp': '1681171727'},\n",
" {'pool': {'inputTokenBalances': [42691909742919056882566,\n",
" 14724499956279684315],\n",
" 'inputTokens': [{'name': 'StargateToken',\n",
" 'id': '0xaf5191b0de278c7286d6c7cc6ab6bb8a73ba2cd6'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xe5bbf38a6584f74f657f936ed89150d2bc401125155cb94c1a19e6125de6fcac1b000000',\n",
" 'timestamp': '1681171715'},\n",
" {'pool': {'inputTokenBalances': [57042082479789538142369,\n",
" 6255650014651241126],\n",
" 'inputTokens': [{'name': 'Banana',\n",
" 'id': '0x94e496474f1725f1c1824cb5bdb92d7691a4f03a'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xcdf01e3ec8ec3d6478aa76cefff64492f5370c80fb865bf2cc4eaa0666a78a1780000000',\n",
" 'timestamp': '1681171703'},\n",
" {'pool': {'inputTokenBalances': [4202300823181127503960176,\n",
" 3093906356551972214517],\n",
" 'inputTokens': [{'name': 'Lido DAO Token',\n",
" 'id': '0x5a98fcbea516cf06857215779fd812ca3bef1b32'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xcb3d92c52c5e38afe9b90575e2a5b01a7a4ecb4bb357225c13460ea5794cd0a540000000',\n",
" 'timestamp': '1681171691'},\n",
" {'pool': {'inputTokenBalances': [131787464429751, 62266105983708270788644],\n",
" 'inputTokens': [{'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0x96313bd0d39b91ac12b02a09f071e862121a2c5444639d4bb1bdcc2bdae4b7fdab000000',\n",
" 'timestamp': '1681171679'},\n",
" {'pool': {'inputTokenBalances': [72656359552630948443787568,\n",
" 35999448520616],\n",
" 'inputTokens': [{'name': 'Dai Stablecoin',\n",
" 'id': '0x6b175474e89094c44da98b954eedeac495271d0f'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0xa9378bd4658962d93e55faf0c2fb011ae96aeb34d5ef74879b7577a0a351f3fdee000000',\n",
" 'timestamp': '1681171667'},\n",
" {'pool': {'inputTokenBalances': [13023507912202706971260, 23733750095476],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'Tether USD',\n",
" 'id': '0xdac17f958d2ee523a2206206994597c13d831ec7'}]},\n",
" 'id': '0xc0990d6054b243196b433e58af6f53cc91da5734fc00a3bbf49204d695f18f91f5010000',\n",
" 'timestamp': '1681171655'},\n",
" {'pool': {'inputTokenBalances': [5518225192579497, 4416026541457],\n",
" 'inputTokens': [{'name': 'HEX',\n",
" 'id': '0x2b591e99afe9f32eaa6214f7b7629768c40eeb39'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0xbb18ff2d27c7bbb07b260ae64c263a1c7ee91c8fd9d681a23312d8859f29c8c8d9000000',\n",
" 'timestamp': '1681171643'},\n",
" {'pool': {'inputTokenBalances': [18853253705217915700,\n",
" 62987105387131781288938],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'Euler', 'id': '0xd9fcd98c322942075a5c3860693e9f4f03aae07b'}]},\n",
" 'id': '0xefa87d7d0254af021804f3e2852c36ab98bc3e155421013c8ab900e1183cb92f4e010000',\n",
" 'timestamp': '1681171631'},\n",
" {'pool': {'inputTokenBalances': [3880879434810711405999107, 626050239209],\n",
" 'inputTokens': [{'name': 'Blur',\n",
" 'id': '0x5283d291dbcf85356a21ba090e6db59121208b44'},\n",
" {'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'}]},\n",
" 'id': '0x840a9976af9256e84365add08f209525fbb735159105c0ba09ecc25f99ee7d209d000000',\n",
" 'timestamp': '1681171619'},\n",
" {'pool': {'inputTokenBalances': [42691909742919056882566,\n",
" 14724499956279684315],\n",
" 'inputTokens': [{'name': 'StargateToken',\n",
" 'id': '0xaf5191b0de278c7286d6c7cc6ab6bb8a73ba2cd6'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xb0b83201023ca74f584b618e691226b4afed559a53c830cc64ee6151fcc3832760010000',\n",
" 'timestamp': '1681171607'},\n",
" {'pool': {'inputTokenBalances': [131787464429751, 62266105983708270788644],\n",
" 'inputTokens': [{'name': 'USD Coin',\n",
" 'id': '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'},\n",
" {'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'}]},\n",
" 'id': '0xdd974548927752e03d557fdc4a19070654b68ee142462712174b190a9dc8e77e02000000',\n",
" 'timestamp': '1681171595'}]}]"
]
},
"execution_count": 18,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"json_query = sg.query_json([\n",
" swaps_qp._select('pool')._select('inputTokenBalances'),\n",
" swaps_qp._select('pool')._select('inputTokens')._select('name')\n",
" # swaps_qp._select('tokenIn')._select('symbol'),\n",
" # swaps_qp._select('tokenOut')._select('symbol'),\n",
" ])\n",
"json_query"
]
},
{
"cell_type": "code",
"execution_count": 28,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"<class 'list'>\n"
]
}
],
"source": [
"print(type(json_query))"
]
},
{
"cell_type": "code",
"execution_count": 32,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"dict_keys(['x9fdac392921bc368'])"
]
},
"execution_count": 32,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# why is this the only key?\n",
"json_query[0].keys()"
]
},
{
"cell_type": "code",
"execution_count": 35,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"{'pool': {'inputTokenBalances': [57852190417341938492,\n",
" 295841336449270084886415],\n",
" 'inputTokens': [{'name': 'Wrapped Ether',\n",
" 'id': '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'},\n",
" {'name': 'CheckDot', 'id': '0xcdb37a4fbc2da5b78aa4e41a432792f9533e85cc'}]},\n",
" 'id': '0xcabce80e7279c4c919bd7f7c95320b21ec946f50de67666eaecab7154e65fab330000000',\n",
" 'timestamp': '1681172819'}"
]
},
"execution_count": 35,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"json_query[0]['x9fdac392921bc368']"
]
},
{
"cell_type": "code",
"execution_count": 44,
"metadata": {},
"outputs": [],
"source": [
"# convert json to pandas\n",
"import pandas as pd\n",
"\n",
"df = pd.json_normalize(json_query[0]['x9fdac392921bc368'])"
]
},
{
"cell_type": "code",
"execution_count": 45,
"metadata": {},
"outputs": [],
"source": [
"# sort df by timestamp\n",
"sorted_df = df.sort_values(by='timestamp', ascending=False)"
]
},
{
"cell_type": "code",
"execution_count": 46,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>id</th>\n",
" <th>timestamp</th>\n",
" <th>pool.inputTokenBalances</th>\n",
" <th>pool.inputTokens</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>0xcabce80e7279c4c919bd7f7c95320b21ec946f50de67...</td>\n",
" <td>1681172819</td>\n",
" <td>[57852190417341938492, 295841336449270084886415]</td>\n",
" <td>[{'name': 'Wrapped Ether', 'id': '0xc02aaa39b2...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>0x8243701b4a8c339b020078431e1df18f2fb6127efc6f...</td>\n",
" <td>1681172807</td>\n",
" <td>[549029545658919852107631, 856074132057685331407]</td>\n",
" <td>[{'name': 'Prime', 'id': '0xb23d80f5fefcddaa21...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>0xf15f84cd3867945f2f6459b3a2663cb982fe25b28064...</td>\n",
" <td>1681172795</td>\n",
" <td>[131777464429751, 62271334068060979928093]</td>\n",
" <td>[{'name': 'USD Coin', 'id': '0xa0b86991c6218b3...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>0x365457de59ee55171624077afaf754c882124476b61f...</td>\n",
" <td>1681172783</td>\n",
" <td>[57852190417341938492, 295841336449270084886415]</td>\n",
" <td>[{'name': 'Wrapped Ether', 'id': '0xc02aaa39b2...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>0xcf40d0767c4e2ad79af6cb61256a3a7d96d7e4ff2ab1...</td>\n",
" <td>1681172771</td>\n",
" <td>[57852190417341938492, 295841336449270084886415]</td>\n",
" <td>[{'name': 'Wrapped Ether', 'id': '0xc02aaa39b2...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>95</th>\n",
" <td>0xbb18ff2d27c7bbb07b260ae64c263a1c7ee91c8fd9d6...</td>\n",
" <td>1681171643</td>\n",
" <td>[5518225192579497, 4416026541457]</td>\n",
" <td>[{'name': 'HEX', 'id': '0x2b591e99afe9f32eaa62...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>96</th>\n",
" <td>0xefa87d7d0254af021804f3e2852c36ab98bc3e155421...</td>\n",
" <td>1681171631</td>\n",
" <td>[18853253705217915700, 62987105387131781288938]</td>\n",
" <td>[{'name': 'Wrapped Ether', 'id': '0xc02aaa39b2...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>97</th>\n",
" <td>0x840a9976af9256e84365add08f209525fbb735159105...</td>\n",
" <td>1681171619</td>\n",
" <td>[3880879434810711405999107, 626050239209]</td>\n",
" <td>[{'name': 'Blur', 'id': '0x5283d291dbcf85356a2...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>98</th>\n",
" <td>0xb0b83201023ca74f584b618e691226b4afed559a53c8...</td>\n",
" <td>1681171607</td>\n",
" <td>[42691909742919056882566, 14724499956279684315]</td>\n",
" <td>[{'name': 'StargateToken', 'id': '0xaf5191b0de...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>99</th>\n",
" <td>0xdd974548927752e03d557fdc4a19070654b68ee14246...</td>\n",
" <td>1681171595</td>\n",
" <td>[131787464429751, 62266105983708270788644]</td>\n",
" <td>[{'name': 'USD Coin', 'id': '0xa0b86991c6218b3...</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>100 rows × 4 columns</p>\n",
"</div>"
],
"text/plain": [
" id timestamp \\\n",
"0 0xcabce80e7279c4c919bd7f7c95320b21ec946f50de67... 1681172819 \n",
"1 0x8243701b4a8c339b020078431e1df18f2fb6127efc6f... 1681172807 \n",
"2 0xf15f84cd3867945f2f6459b3a2663cb982fe25b28064... 1681172795 \n",
"3 0x365457de59ee55171624077afaf754c882124476b61f... 1681172783 \n",
"4 0xcf40d0767c4e2ad79af6cb61256a3a7d96d7e4ff2ab1... 1681172771 \n",
".. ... ... \n",
"95 0xbb18ff2d27c7bbb07b260ae64c263a1c7ee91c8fd9d6... 1681171643 \n",
"96 0xefa87d7d0254af021804f3e2852c36ab98bc3e155421... 1681171631 \n",
"97 0x840a9976af9256e84365add08f209525fbb735159105... 1681171619 \n",
"98 0xb0b83201023ca74f584b618e691226b4afed559a53c8... 1681171607 \n",
"99 0xdd974548927752e03d557fdc4a19070654b68ee14246... 1681171595 \n",
"\n",
" pool.inputTokenBalances \\\n",
"0 [57852190417341938492, 295841336449270084886415] \n",
"1 [549029545658919852107631, 856074132057685331407] \n",
"2 [131777464429751, 62271334068060979928093] \n",
"3 [57852190417341938492, 295841336449270084886415] \n",
"4 [57852190417341938492, 295841336449270084886415] \n",
".. ... \n",
"95 [5518225192579497, 4416026541457] \n",
"96 [18853253705217915700, 62987105387131781288938] \n",
"97 [3880879434810711405999107, 626050239209] \n",
"98 [42691909742919056882566, 14724499956279684315] \n",
"99 [131787464429751, 62266105983708270788644] \n",
"\n",
" pool.inputTokens \n",
"0 [{'name': 'Wrapped Ether', 'id': '0xc02aaa39b2... \n",
"1 [{'name': 'Prime', 'id': '0xb23d80f5fefcddaa21... \n",
"2 [{'name': 'USD Coin', 'id': '0xa0b86991c6218b3... \n",
"3 [{'name': 'Wrapped Ether', 'id': '0xc02aaa39b2... \n",
"4 [{'name': 'Wrapped Ether', 'id': '0xc02aaa39b2... \n",
".. ... \n",
"95 [{'name': 'HEX', 'id': '0x2b591e99afe9f32eaa62... \n",
"96 [{'name': 'Wrapped Ether', 'id': '0xc02aaa39b2... \n",
"97 [{'name': 'Blur', 'id': '0x5283d291dbcf85356a2... \n",
"98 [{'name': 'StargateToken', 'id': '0xaf5191b0de... \n",
"99 [{'name': 'USD Coin', 'id': '0xa0b86991c6218b3... \n",
"\n",
"[100 rows x 4 columns]"
]
},
"execution_count": 46,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# this is what query_df output should look like\n",
"sorted_df"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": ".venv",
"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.6"
},
"orig_nbformat": 4
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment