ERC20 Balances Latest
The current ERC20 balance of all addresses.
Last updated
The current ERC20 balance of all addresses.
Last updated
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.
Getting the latest ERC20 Balances of USDC Token from an address.
| 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