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

API (cURL)

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

Table Columns