Skip to main content

Table Details

PropertyValue
Table Namemonad_testnet.assets.native_balances
Table StatusProduction-Ready
Unique Keyblock_timestamp, unique_id

Table Columns

Column NameData TypeDescription
token_typeVARCHAR(16777216)Identifies whether the balance record is for a native or erc20 token
addressVARCHAR(42)The wallet address holding the tokens
token_addressVARCHAR(42)Contract address of the token
token_nameVARCHAR(16777216)Name of the token
token_symbolVARCHAR(16777216)Symbol of the token
raw_balance_strVARCHAR(16777216)Token balance, unnormalized, as string to retain precision
raw_balanceFLOATToken balance, unnormalized
balance_strVARCHAR(16777216)Token balance as string to retain precision
balanceFLOATToken balance, normalized
usd_balanceFLOATToken balance, normalized, in USD
usd_exchange_rateFLOATExchange rate used for USD conversion
block_timestampTIMESTAMP_NTZ(9)Timestamp of the block
block_numberNUMBER(38,0)Number of the block
block_hashVARCHAR(16777216)Hash of the block
unique_idVARCHAR(16777216)Unique identifier combining block, address, token address
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated