Fungible Balances

The fungible balances table contains historical native token (e.g. ETH, MATIC, AVAX) and ERC20 tokens the balance of all addresses, at block height that has a balance change for the particularly address.

Sample Query

Query wallet Balance of a wallet by token address.

select * from ethereum.assets_fungible_balances 
where address = '0xa27cef8af2b6575903b676e5644657fae96f491f'
and token_address = '0x0000000000000000000000000000000000000000' -- ETH

Table Columns

Last updated