The balances table contains all changes in the balances of assets across all Ethereum wallets.
This includes Native Ether, ERC20, ERC721 and ERC1155 tokens. Includes USD value where applicable. Token-specific balance tables are available for query.
balancestables can be used to easily plot the change in the balance of an address or a group of addresses over time.
Getting the ETH Balances across bridges on Ethereum
sum(balance) as eth
from ( -- Find last balance entry for each bridge address weekly
date_trunc('week', block_timestamp) as date,
from ethereum.assets.balances balances
inner join common.identity.entities on balances.address = entities.address and category = 'bridge' and chain = 'ethereum'
where block_timestamp > '2021-05-01' and token_type = 'ETH'
qualify row_number() over (partition by balances.address, date order by block_timestamp desc) = 1
group by 1,2