Skip to main content
The Fungible Balances Latest table contains the latest balance of fungible tokens (ERC20 and native (gas) tokens) of all addresses. This table is derived from the Fungible Balances table, by selecting the most recent balance update for each unique address-asset combination.

Table Columns

Unique Key: unique_id
Column NameData TypeDescription
token_typeVARCHARType of the token (e.g., ERC20, native).
addressVARCHARAddress of the account
token_addressVARCHARAddress of the native token, which is represented as null address (0x0000000000000000000000000000000000000000)
token_nameVARCHARName of the native token
token_symbolVARCHARSymbol of the token
raw_balanceNUMERICRaw balance of native token in wei
raw_balance_strVARCHARRaw balance of native token in wei and in string format
balanceFLOATBalance of native token normalized
balance_strVARCHARBalance of native token normalized and in string format
usd_balance_currentFLOATThe current USD value of the balance, based on the latest available exchange rate.
usd_balance_at_block_timestampFLOATThe USD value of the balance at the time of the block that resulted in the balance update.
usd_exchange_rate_currentFLOATThe current USD exchange rate of the token, based on the latest available rate.
usd_exchange_rate_at_block_timestampFLOATThe USD exchange rate of the token at the time of the block that resulted in the balance update.
last_activity_block_timestampTIMESTAMP_NTZ(9)The last timestamp of the block that resulted in the balance update
last_activity_block_numberINTEGERThe last block number that resulted in the balance update
last_activity_block_hashVARCHARThe last hash of the block that resulted in the balance update
_updated_at__usd_exchange_rate_currentTIMESTAMP_NTZ(9)Timestamp of the current USD exchange
unique_idVARCHARUnique ID of the balance
_updated_at__historicalTIMESTAMP_NTZ(9)Timestamp of the historical balance row update.
_created_at__onchain_lakeTIMESTAMP_NTZ(9)Timestamp when the balance row was first created in the onchain data lake.
_updated_atTIMESTAMP_NTZ(9)Timestamp of the balance update