Fungible Balances 🌱

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 Name	Description
address	The wallet address holding the balance.
currency	The currency/token identifier.
token_name	The name of the token.
token_symbol	The symbol of the token.
raw_balance_str	The raw balance as a string.
raw_balance	The raw balance as a float.
balance_str	The normalized balance as a string.
balance	The normalized balance as a float.
usd_balance	The USD value of the balance.
usd_exchange_rate	The USD exchange rate for the token.
event_index	The index of the event within the transaction.
transaction_hash	The hash of the transaction.
transaction_index	The index of the transaction within the block.
block_timestamp	The timestamp when the block was created.
block_height	The sequential number of the block in the blockchain.
block_hash	The hash of the block.
block_event_kind	The 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_index	The index of the block event.
block_event_type	The type of the block event.
unique_id	A unique identifier for this record.
_address_short	A shortened version of the address for indexing.
_currency_short	A shortened version of the currency for indexing.
_pseudo_global_order	A pseudo-global ordering field for consistent sorting.
_created_at	The timestamp when the entry was created.
_updated_at	The timestamp when the entry was updated.

Event Attributes Overview

⌘I

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns