fungible_balances
table records an entry whenever a transaction alter’s an asset’s balance.
transfer
coinbase
and burn
ibc_transfer
and write_acknowledgement
complete_unbonding
transfer
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. |