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.

PSQL

select * from arbitrum.assets_fungible_balances 
where address = '0xd7e62fdd9e0e4aeb50b1148d3a2dc4d0085823c5'
and token_address = '0x0000000000000000000000000000000000000000' -- ETH

API (cURL)

curl 'https://api.allium.so/api/v1/developer/arbitrum/address/0xd7e62fdd9e0e4aeb50b1148d3a2dc4d0085823c5/balances/fungible?page=1&size=10&token_address=0x0000000000000000000000000000000000000000' \
  -X GET \
  -H 'X-API-KEY: <API KEY>'

Table Columns

Column Name	Type	Description	Example
address	varchar	Address of the account.	0xd7e62fdd9e0e4aeb50b1148d3a2dc4d0085823c5
token_address	varchar	Token address. Native ETH is represented as 0x0000000000000000000000000000000000000000	0x0000000000000000000000000000000000000000
raw_balance	numeric(512)	Unormalized token balance. For ETH, balance of eth in wei.	575273824313730050
block_timestamp	timestamp	The timestamp of the block that that resulted in the balance.	2023-10-10T01:01:00
block_number	bigint	The number of the block that resulted in the balance.	139189673
block_hash	varchar	The hash of the block that resulted in the balance.	0x02081a6a84f5430760204f4b65a76298057861f87036aef5dc7f1fc3dfdae5b6