Skip to main content

Table Details

PropertyValue
Table Namebabylon.assets.fungible_balances
Table StatusProduction-Ready
Unique Keyblock_timestamp, unique_id

Table Columns

Column NameData TypeDescription
addressVARCHAR(16777216)The wallet address holding the balance.
currencyVARCHAR(16777216)The currency/token identifier.
token_nameVARCHAR(16777216)The name of the token.
token_symbolVARCHAR(16777216)The symbol of the token.
raw_balance_strVARCHAR(16777216)The raw balance as a string.
raw_balanceFLOATThe raw balance as a float.
balance_strVARCHAR(16777216)The normalized balance as a string.
balanceFLOATThe normalized balance as a float.
usd_balanceFLOATThe USD value of the balance.
usd_exchange_rateFLOATThe USD exchange rate for the token.
event_indexNUMBER(38,0)The index of the event within the transaction.
transaction_hashVARCHAR(66)The hash of the transaction.
transaction_indexNUMBER(38,0)The index of the transaction within the block.
block_timestampTIMESTAMP_NTZ(9)The timestamp when the block was created.
block_heightNUMBER(38,0)The sequential number of the block in the blockchain.
block_hashVARCHAR(66)The hash of the block.
unique_idVARCHAR(16777216)A unique identifier for this record.
_address_shortVARCHAR(16777216)A shortened version of the address for indexing.
_currency_shortVARCHAR(16777216)A shortened version of the currency for indexing.
_pseudo_global_orderNUMBER(38,0)A pseudo-global ordering field for consistent sorting.
_created_atTIMESTAMP_NTZ(9)The timestamp when the entry was created.
_updated_atTIMESTAMP_NTZ(9)The timestamp when the entry was updated.