Fungible Balances Latest

The assets.fungible_balances_latest table contains the latest balance of fungible tokens (erc20 and native (gas) tokens) of all addresses. This table is derived from the assets.fungible_balances table, by selecting the most recent balance update for each unique address-asset combination.

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	NUMERIC	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
last_activity_block_timestamp	TIMESTAMP_NTZ(9)	The last timestamp of the block that resulted in the balance update
last_activity_block_number	INTEGER	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
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

Table Columns

​Table Columns

Table Columns