The balances latest table contains the latest balances of every type of token of any address. This includes Native Ether and ERC20 currently.

  • usd_balance_current which reflects the current USD value of the asset.

  • usd_balance_at_block_timestamp which reflects the USD value of the asset at the last transaction activity.

Table Name Description
base.assets.eth_balances_latestLatest ETH balances
base.assets.erc20_balances_latestLatest ERC20 balances

​
Table Columns

Column NameDescription
addressAddress of the account.
token_address

Address of the token.

For Ether it is represented as nulll address.

token_nameName of the token.
token_symbolSymbol of the token.
token_idToken ID of a ERC721 token or ERC1155 token.
raw_balanceRaw balance amount of the token (not divided by the number of decimals)
raw_balance_strRaw balance amount of the token (not divided by the number of decimals) in string.
balanceraw_balance divided by the number of decimals of this token. This value will be the same as raw_balance for erc721 and erc1155 tokens.
balance_strBalance of token normalized and in string format.
usd_balance_currentUSD balance of token at the current timestamp.
usd_balance_at_block_timestampUSD balance of token at the timestamp of the last activity that resulted in balance change.
usd_exchange_rate_currentUSD exchange rate of token at the current timestamp.
usd_exchange_rate_at_block_timestampUSD exchange rate of token at the timestamp of the last activity that resulted in balance update.
transaction_hashThe transaction hash that resulted in the balance update.
last_activity_block_timestampThe last timestamp of the block that that resulted in the balance update.
last_activity_block_numberThe last block number that resulted in the balance update.
last_activity_block_hashThe block hash of the last activity that resulted in this balance.
_updated_at__usd_exchange_rate_currentTimestamp of the current USD exchange.
unique_idUnique ID of the balance.
_updated_atTimestamp of the balance update.