Skip to main content

Table Details

PropertyValue
Table Namecelo.assets.fungible_balances_latest
Table StatusProduction-Ready
Unique Keytoken_address, address

Table Columns

Column NameData TypeDescription
token_typeVARCHAR(6)Type of the token (e.g., ERC20, ERC721, native).
addressVARCHAR(16777216)Address of the account
token_addressVARCHAR(16777216)Address of the native token, which is represented as null address (0x0000000000000000000000000000000000000000)
token_nameVARCHAR(16777216)Name of the native token
token_symbolVARCHAR(16777216)Symbol of the token
raw_balance_strVARCHAR(16777216)Raw balance of native token in wei and in string format
raw_balanceFLOATRaw balance of native token in wei
balance_strVARCHAR(16777216)Balance of native token normalized and in string format
balanceFLOATBalance of native token normalized
usd_balance_currentFLOATUSD balance at current timestamp.
usd_balance_at_block_timestampFLOATUSD balance at the time of the block.
usd_exchange_rate_currentFLOATCurrent USD exchange rate.
usd_exchange_rate_at_block_timestampFLOATUSD exchange rate at block time.
last_activity_block_timestampTIMESTAMP_NTZ(9)The last timestamp of the block that resulted in the balance update
last_activity_block_numberNUMBER(38,0)The last block number that resulted in the balance update
last_activity_block_hashVARCHAR(16777216)The last hash of the block that resulted in the balance update
unique_idVARCHAR(107)Unique ID of the balance
_updated_at__usd_exchange_rate_currentTIMESTAMP_NTZ(9)Timestamp of the current USD exchange
_updated_at__historicalTIMESTAMP_NTZ(9)[TODO: Add description for _updated_at__historical]
_created_at__onchain_lakeTIMESTAMP_NTZ(9)[TODO: Add description for _created_at__onchain_lake]
_updated_atTIMESTAMP_NTZ(9)Timestamp of the balance update
_changed_since_full_refreshBOOLEANIndicates if the record changed since last full refresh.