Skip to main content

Table Details

PropertyValue
Table Namehyperevm.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, 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_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_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)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
_changed_since_full_refreshBOOLEANIndicates if the record has changed since the last full data refresh.