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.

select * from ethereum.assets.erc20_balances_latest
where address = '0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459' -- Pranksy
and token_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' -- USDC Token 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