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
andburn
- cross-chain briding related transfers with event_type of
ibc_transfer
andwrite_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. |