Native Balances Latest

The assets.native_balances_latest table contains the latest balance of native tokens of all addresses. This table is derived from the assets.native_balances table, by selecting the most recent balance update for each unique address-asset combination.

Sample Query

Getting the latest native token balance of an address.

select * from ethereum.assets.native_balances_latest
where address = '0xd387a6e4e84a6c86bd90c158c6028a58cc8ac459' -- Pranksy

Table Columns

Unique Key: unique_id

Column Name	Data Type	Description
address	VARCHAR	Address of the account
token_address	VARCHAR	Address of the native token, which is represented as null address (0x0000000000000000000000000000000000000000)
token_name	VARCHAR	Name of the native token
token_symbol	VARCHAR	Symbol of the token
raw_balance	FLOAT	Raw balance of native token in wei
raw_balance_str	VARCHAR	Raw balance of native token in wei and in string format
balance	FLOAT	Balance of native token normalized
balance_str	VARCHAR	Balance of native token normalized and in string format
usd_balance_current	FLOAT	USD balance of ETH at the current timestamp
usd_balance_at_block_timestamp	FLOAT	USD balance of ETH at the timestamp of the last activity that resulted in balance change
usd_exchange_rate_current	FLOAT	USD exchange rate of ETH at the current timestamp
usd_exchange_rate_at_block_timestamp	FLOAT	USD exchange rate of ETH 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

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