ERC20 Balances Latest

The assets.erc20_balances_latest table contains the current balances of erc20 tokens across all addresses. This table is derived from the assets.erc20_balances table, by selecting the most recent balance update for each unique address-asset combination.

Sample Query

Getting the latest balance of USDC of a wallet.

select * from ethereum.assets.erc20_balances_latest
where address = '0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459' -- Pranksy
and token_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' -- USDC Token Address

Table Columns

Unique Key: unique_id

Column Name	Data Type	Description
address	VARCHAR	Address of the account
token_address	VARCHAR	Address of the token
token_name	VARCHAR	Name of the token
token_symbol	VARCHAR	Symbol of the token
raw_balance	FLOAT	Balance of ERC20 token unnormalized
raw_balance_str	VARCHAR	Balance of ERC20 token unnormalized in string format
balance_str	VARCHAR	Balance of ERC20 token in string format
balance	FLOAT	Balance of ERC20 token normalized
usd_balance_current	FLOAT	USD balance of ERC20 token at the current timestamp
usd_balance_at_block_timestamp	FLOAT	USD balance of ERC20 token at the timestamp of the last activity that resulted in balance change
usd_exchange_rate_current	FLOAT	USD exchange rate of ERC20 token at the current timestamp
usd_exchange_rate_at_block_timestamp	FLOAT	USD exchange rate of ERC20 token at the timestamp of the last activity that resulted in balance update
last_activity_block_timestamp	TIMESTAMP_NTZ(9)	The last timestamp of the block that resulted in the balance update
last_activity_block_number	BIGINT	The last block number that resulted in the balance update
last_activity_block_hash	VARCHAR	The last hash of the block that resulted in the balance update
_updated_at__usd_exchange_rate_current	TIMESTAMP_NTZ(9)	Timestamp of the current USD exchange rate
unique_id	VARCHAR	Unique ID of the balance
_updated_at	TIMESTAMP_NTZ(9)	Timestamp of the balance update

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Sample Query

Table Columns

​Sample Query

​Table Columns

Sample Query

Table Columns