Balances Latest

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_latest	Latest ETH balances
base.assets.erc20_balances_latest	Latest ERC20 balances

Table Columns

Column Name	Description
address	Address of the account.
token_address	Address of the token. For Ether it is represented as nulll address.
token_name	Name of the token.
token_symbol	Symbol of the token.
token_id	Token ID of a ERC721 token or ERC1155 token.
raw_balance	Raw balance amount of the token (not divided by the number of decimals)
raw_balance_str	Raw balance amount of the token (not divided by the number of decimals) in string.
balance	raw_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_str	Balance of token normalized and in string format.
usd_balance_current	USD balance of token at the current timestamp.
usd_balance_at_block_timestamp	USD balance of token at the timestamp of the last activity that resulted in balance change.
usd_exchange_rate_current	USD exchange rate of token at the current timestamp.
usd_exchange_rate_at_block_timestamp	USD exchange rate of token at the timestamp of the last activity that resulted in balance update.
transaction_hash	The transaction hash that resulted in the balance update.
last_activity_block_timestamp	The last timestamp of the block that that resulted in the balance update.
last_activity_block_number	The last block number that resulted in the balance update.
last_activity_block_hash	The block hash of the last activity that resulted in this balance.
_updated_at__usd_exchange_rate_current	Timestamp of the current USD exchange.
unique_id	Unique ID of the balance.
_updated_at	Timestamp of the balance update.