Skip to main content

Table Details

PropertyValue
Table Namelitecoin.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 token’s raw 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 LTC protocol in litoshi. One litoshi = 1e-8 LTC.
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.
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 time of the last activity.
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.