bitquery get liquidity pool
Returns balance updates on BNB Chain, where balance update address is 0x472e…78d2 and currency smart contract is 0xbb4c…095c, sorted by balance, highest first: currency name, smart contract, currency symbol, sum of balance update amount in USD, balance update address, balance update amount and amount in USD.
What it returns
- currency name
- smart contract
- currency symbol
- sum of balance update amount in USD
- balance update address
- balance update amount
- amount in USD
Filters
- balance update address is 0x472e…78d2
- currency smart contract is 0xbb4c…095c
The query
query MyQuery {
EVM(dataset: combined, network: bsc) {
BalanceUpdates(
where: {BalanceUpdate: {Address: {is: "0x472e71c0e729cbe32b883502f833e6e8f2cd78d2"}}, Currency: {SmartContract: {is: "0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c"}}}
orderBy: {descendingByField: "balance"}
) {
Currency {
Name
SmartContract
Symbol
}
balance: sum(of: BalanceUpdate_AmountInUSD, selectWhere: {gt: "0"})
BalanceUpdate {
Address
Amount
AmountInUSD
}
}
}
}
Similar queries
- MyQuery EVM · BNB Chain · BalanceUpdates
- Top 10 holders of a token on BSC · BNB Chain · BalanceUpdates
- token holder balance update · BNB Chain · BalanceUpdates
- balance updates on a given transaction · BNB Chain · BalanceUpdates
- wrong top holders list · BNB Chain · BalanceUpdates