Balances Latest
Last updated
Last updated
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 |
|---|---|
| Column Name | Description |
|---|---|
base.assets.eth_balances_latest
Latest ETH balances
base.assets.erc20_balances_latest
Latest ERC20 balances
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.