Balances

The base.assets.balances table contains all changes in the balances of assets across all Base wallets. Includes Native Ether and ERC20.

Asset-specific balances table are also available:

Table Name	Description
base.assets.eth_balances	Block-level ETH balances
base.assets.erc20_balances	Block-level ERC20 balances

Table Columns

Column Name	Description
address	Address of the account.
token_address	Token address of the asset. Note: Native ETH does not have a contract address, but for convention, it is labelled as: 0x0000000000000000000000000000000000000000
token_name	Name of the token.
token_symbol	Token symbol of the token.
token_id	Unique token ID of the asset. Only applicable for ERC721 and ERC1155 tokens.
raw_balance	Balance of tokens (unnormalized)
balance	Normalized token balance.
usd_balance	The amount of tokens, in $USD.
usd_exchange_rate	The exchange rate used to calculate the usd_value.
block_timestamp	The timestamp of the block that that resulted in the balance.
block_number	The number of the block that resulted in the balance.
block_hash	The hash of the block that resulted in the balance.
token_type	Token type of asset. Includes ETH, ERC20, ERC721 and ERC1155.