Balances Latest
ERC20 Balances Latest
Balances Latest
ERC20 Balances Latest
The current ERC20 balance of all addresses.
Note that the USD prices of any given latest balance might lag more than you expect them to. Check the _updated_at__usd_exchange_rate_current column to ensure the price is fresh enough for your use case.
Also keep in mind 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 latest contains the current ERC20 balances of all addresses. It is otherwise identical to ERC20 Balances.
Sample Query
Getting the latest ERC20 Balances of USDC Token from an address.
Table Columns
| Column Name | Description | Example |
|---|---|---|
| address | Address of the account. | 0x4b805632240e35b06d93e42af2aee45417f9af6b |
| token_address | Addres of the token. | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 |
| token_name | Name of the token. | USD Coin |
| token_symbol | Symbol of the token. | USDC |
| raw_balance | Balance of ERC20 token unnormalized. | 84,005 |
| raw_balance_str | Balance of ERC20 token unnormalized in string. | 84005 |
| balance_str | Balance of ERC20 token in string. | 0.084005 |
| balance | Balance of ERC20 token. | 0.084005 |
| usd_balance_current | USD balance of ERC20 token at the current timestamp. | 0.0839797985 |
| usd_balance_at_block_timestamp | USD balance of ERC20 token at the timestamp of the last activity that resulted in balance change. | 0.083920995 |
| usd_exchange_rate_current | USD exchange rate of ERC20 token at the current timestamp. | 0.9997 |
| usd_exchange_rate_at_block_timestamp | USD exchange rate of ERC20 token at the timestamp of the last activity that resulted in balance update. | 0.999 |
| last_activity_block_timestamp | The last timestamp of the block that that resulted in the balance update. | 2020-08-01 13:12:58 |
| last_activity_block_number | The last block number that resulted in the balance update. | 10,574,102 |
| last_activity_block_hash | The last hash of the block that resulted in the balance update. | 0x1e8003f10add525ff56b7bc28c65f5011a8d6d098aa086ecba0f87c881ffb7ae |
| _updated_at__usd_exchange_rate_current | Timestamp of the current USD exchange. | 2023-03-10 22:00:00 |
| unique_id | Unique ID of the balance | block-10574102_address-0x4b805632240e35b06d93e42af2aee45417f9af6b_token_address-0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48_erc20 |
| _updated_at | Timestamp of the balance update. | 2023-03-10 10:18:08 |