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

Last updated