Skip to main content

Table Details

PropertyValue
Table Namedogecoin.assets.balances_latest
Table StatusProduction-Ready
Unique Keytoken_address, address

Table Columns

Column NameData TypeDescription
addressVARCHAR(16777216)Address of the account.
token_addressVARCHAR(16777216)Token address of the asset, 0x0000000000000000000000000000000000000000 for native token.
token_nameVARCHAR(16777216)Name of the token.
token_symbolVARCHAR(16777216)Token symbol of this token.
token_decimalsNUMBER(38,0)Number of decimal places used to normalize the raw balance into the token balance.
raw_balance_strVARCHAR(16777216)Balance of tokens (unnormalized) in string.
raw_balanceFLOATBalance of tokens (unnormalized).
balance_strVARCHAR(16777216)Balance of this token, normalized by the decimal points defined in the token contract.
balanceFLOATBalance of the token, normalized by the decimal points defined by the DOGE protocol. One DOGE = 1e8 of the smallest unit.
usd_balance_currentFLOATThe amount of tokens, in $USD at the current time.
usd_balance_at_last_activityFLOATThe amount of tokens, in $USD at the price evaluated at the time of the last activity block.
usd_exchange_rate_currentFLOATThe exchange rate used to calculate the usd_value at current time.
usd_exchange_rate_at_last_activityFLOATThe exchange rate used to calculate the usd_value at the last activity block timestamp.
last_activity_block_timestampTIMESTAMP_NTZ(9)The latest timestamp of the block that resulted in change in balance.
last_activity_block_numberNUMBER(38,0)The number of the latest block that resulted in change in balance.
last_activity_block_hashVARCHAR(16777216)The hash of the latest block that resulted in change in balance.
last_activity_transaction_hashVARCHAR(16777216)Hash of the last activity transaction.
last_activity_transaction_indexNUMBER(38,0)Index of the last activity transaction.
unique_idVARCHAR(16777216)Unique ID of the balances entry.
_updated_at__usd_exchange_rate_currentTIMESTAMP_NTZ(9)Time the usd exchange rate was calculated.
_updated_at__historicalTIMESTAMP_NTZ(9)Time the raw balance was calculated.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated in the database.