The fungible_balances table records an entry whenever a transaction alter’s an asset’s balance.
Fungible Balances for Cosmos SDK chains is currently in Beta mode.The dataset is derived by calculating the net effect of all token transfers for each account, specifically by summing all incoming transfers (credits) and subtracting all outgoing transfers (debits).As Cosmos SDK chains do not have a standardised approach to recording token transfers, there are chain-specific nuances and edge cases which aren’t captured. This may result in discrepancies in balances for some addresses.Currently, the following transfers are accounted for:
  • standard transfers with event_type of transfer
  • mints and burns with event_type of coinbase and burn
  • cross-chain briding related transfers with event_type of ibc_transfer and write_acknowledgement
  • unbonding of tokens as part of staking, with block_event_type of complete_unbonding
  • transfers which are only surfaced in the block_events with block_event_type of transfer

Table Columns

Unique Key: block_timestamp::date, _address_short, _currency_short, address, currency, block_height, unique_id
Column NameDescription
addressThe wallet address holding the balance.
currencyThe currency/token identifier.
token_nameThe name of the token.
token_symbolThe symbol of the token.
raw_balance_strThe raw balance as a string.
raw_balanceThe raw balance as a float.
balance_strThe normalized balance as a string.
balanceThe normalized balance as a float.
usd_balanceThe USD value of the balance.
usd_exchange_rateThe USD exchange rate for the token.
event_indexThe index of the event within the transaction.
transaction_hashThe hash of the transaction.
transaction_indexThe index of the transaction within the block.
block_timestampThe timestamp when the block was created.
block_heightThe sequential number of the block in the blockchain.
block_hashThe hash of the block.
block_event_kindThe phase in which the block event was emitted. Possible values are: begin (before transactions are processed), end (after all transactions are processed), finalize (immediately before block commit)
block_event_indexThe index of the block event.
block_event_typeThe type of the block event.
unique_idA unique identifier for this record.
_address_shortA shortened version of the address for indexing.
_currency_shortA shortened version of the currency for indexing.
_pseudo_global_orderA pseudo-global ordering field for consistent sorting.
_created_atThe timestamp when the entry was created.
_updated_atThe timestamp when the entry was updated.