Fungible Balances Latest - Allium Documentation Hub

The 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 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

​Table Columns

Table Columns