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 base.assets_fungible_balances 
where address = '0xb5a0bb236466fdb3282d0dff3eb7e4fb33b53f13'
and token_address = '0x0000000000000000000000000000000000000000' -- ETH

Table Columns

Last updated