💡WETH Pool Balances
In this example, we'll use the LiveQuery table function tf_latest_token_balance
to retrieve the real-time balance of Uniswap Pools.
If you'd like to follow along in your own Flipside Studio Account please make sure you've added the QuickNode integration to your account. QuickNode instructions here.
Let's start with a simple example, retrieve the balance of WETH and USDC on the WETH/USDC pool.
Pool Address: 0x88e6a0c2ddd26feeb64f039a2c41296fcb3f5640
WETH Token Address: 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2
USDC Token Address: 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48
Note you must wrap the call to the function in TABLE()
since this function returns a table structure.
This function will always return a table with the following columns:
The function supports a few overloads. An overload means the function can take different combinations of inputs. Here are a few overload examples:
Query a Pool's Balance for a Single Token
Query Multiple Pool Balances Simultaneously using Dynamic Inputs
In this example, we'll pull the latest WETH balance for all WETH pools that have done greater than $10 million in volume over the past week.
We will first fetch the pools using Flipside's ethereum.core.ez_dex_swaps
table and then use the table function ethereum_mainnet.tf_latest_token_balance()
to retrieve the balance for each pool involving WETH.
The above query will return the WETH balance for every pool that has had over $10 million in trading volume over the past week.
Last updated