ERC20 Balances
Historical ERC20 balances of all addresses at every block height.
We only use CEX USD prices to estimate the usd_amount. This has the benefit of excluding scam tokens, but some defi tokens might not be covered.
ERC20 balances table contains the ERC20 balances of all addresses, at every block height. Use this table to easily plot the change in the balance of ERC20 tokens for an address or a group of addresses over time.
Sample Query
Getting the ERC20 Balances of USDC Token from an address over time.
Table Columns
Column Name | Description | Example |
---|---|---|
address | Address of the account. |
|
token_address | Token address of the ERC20 token. |
|
token_name | Name of the ERC20 token. |
|
token_symbol | Token symbol of this token. |
|
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 | Balance of tokens (unnormalized) |
|
usd_amount | The amount of tokens, in $USD. |
|
usd_exchange_rate | The exchange rate used to calculate the |
|
block_timestamp | The timestamp of the block that that resulted in the |
|
block_number | The number of the block that resulted in the |
|
block_hash | The hash of the block that resulted in the |
|
Last updated