balance of an address on multiple chains
Returns balance updates on Ethereum, BNB Chain, Base and Arbitrum, where balance update address is 0xcf1D…35f6, sorted by balance, highest first: currency name, smart contract, sum of balance update amount and sum of balance update amount in USD.
What it returns
- currency name
- smart contract
- sum of balance update amount
- sum of balance update amount in USD
Filters
- balance update address is 0xcf1D…35f6
The query
query MyQuery {
eth: EVM(dataset: archive, network: eth) {
BalanceUpdates(
where: {BalanceUpdate: {Address: {is: "0xcf1DC766Fc2c62bef0b67A8De666c8e67aCf35f6"}}}
orderBy: {descendingByField: "balance"}
) {
Currency {
Name
SmartContract
}
balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
balanceInUSD: sum(of: BalanceUpdate_AmountInUSD, selectWhere: {gt: "0"})
}
}
bsc: EVM(dataset: archive, network: bsc) {
BalanceUpdates(
where: {BalanceUpdate: {Address: {is: "0xcf1DC766Fc2c62bef0b67A8De666c8e67aCf35f6"}}}
orderBy: {descendingByField: "balance"}
) {
Currency {
Name
SmartContract
}
balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
balanceInUSD: sum(of: BalanceUpdate_AmountInUSD, selectWhere: {gt: "0"})
}
}
base: EVM(dataset: archive, network: base) {
BalanceUpdates(
where: {BalanceUpdate: {Address: {is: "0xcf1DC766Fc2c62bef0b67A8De666c8e67aCf35f6"}}}
orderBy: {descendingByField: "balance"}
) {
Currency {
Name
SmartContract
}
balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
balanceInUSD: sum(of: BalanceUpdate_AmountInUSD, selectWhere: {gt: "0"})
}
}
arbitrum: EVM(dataset: archive, network: arbitrum) {
BalanceUpdates(
where: {BalanceUpdate: {Address: {is: "0xcf1DC766Fc2c62bef0b67A8De666c8e67aCf35f6"}}}
orderBy: {descendingByField: "balance"}
) {
Currency {
Name
SmartContract
}
balance: sum(of: BalanceUpdate_Amount, selectWhere: {gt: "0"})
balanceInUSD: sum(of: BalanceUpdate_AmountInUSD, selectWhere: {gt: "0"})
}
}
}
Similar queries
- eth balance · Ethereum · BalanceUpdates
- Ethereum balance view · Ethereum · BalanceUpdates
- Balance update API explanation · Ethereum · BalanceUpdates
- MyQuery EVM · BNB Chain · BalanceUpdates
- usdt_holder_balance_update_ · Ethereum · BalanceUpdates