Balances
The balances table contains all changes in the balances of assets across all Ethereum wallets.
This includes Native Ether, ERC20, ERC721 and ERC1155 tokens. Includes USD value where applicable. Token-specific balance tables are available for query.
For
balances tables can be used to easily plot the change in the balance of an address or a group of addresses over time. Getting the ETH Balances across bridges on Ethereum
select
date,
project,
sum(balance) as eth
from ( -- Find last balance entry for each bridge address weekly
select
date_trunc('week', block_timestamp) as date,
project,
balances.address,
balance
from ethereum.assets.balances balances
inner join common.identity.entities on balances.address = entities.address and category = 'bridge' and chain = 'ethereum'
where block_timestamp > '2021-05-01' and token_type = 'ETH'
qualify row_number() over (partition by balances.address, date order by block_timestamp desc) = 1
)
group by 1,2
Column Name | Description | Example |
|---|---|---|
address | Address of the account. | 0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459 |
token_address | Token address of the asset.
Note: Native ETH does not have a contract address, but for convention, it is labelled as: 0x0000000000000000000000000000000000000000 | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 |
token_name | Name of the ERC20 token. | USD Coin |
token_symbol | Token symbol of this token. | USDC |
token_id | Unique token ID of the asset.
Only applicable for ERC721 and ERC1155 tokens. | |
raw_balance | Balance of tokens (unnormalized) | 10000000 |
balance | Balance of this ERC20 token, normalized by the decimal points defined in the ERC20 token contract. For example, USDC has 6 decimals, so this value is the raw_balance divided by 10^6. | 10 |
usd_balance | The amount of tokens, in $USD. | 10 |
usd_exchange_rate | The exchange rate used to calculate the usd_value. | 1 |
block_timestamp | The timestamp of the block that that resulted in the balance. | 2022-09-15 13:51:47 |
block_number | The number of the block that resulted in the balance. | 15539508 |
block_hash | The hash of the block that resulted in the balance. | 0x25680259dfb40b4ee724ae22fda01a34e6d598c5f2fc25b6d871cb56c488de70 |
token_type | Token type of asset. Includes ETH, ERC20, ERC721 and ERC1155. | ERC20 |
Last modified 2mo ago