Fungible Balances Daily

The Fungible Balances Daily table provides one row per (address, token, date) capturing the closing balance for each day. Use this table for day-over-day balance analysis, point-in-time portfolio views, and time-series charts. For per-block balance changes, use the fungible_balances table instead.

Table Columns

Column Name	Data Type	Description
date	TIMESTAMP_NTZ(9)	The UTC date this daily balance snapshot covers
address	VARCHAR	The wallet address holding the tokens
token_address	VARCHAR	Contract address of the token (or sentinel address for native token)
token_name	VARCHAR	Name of the token
token_symbol	VARCHAR	Symbol of the token
token_decimals	INTEGER	Decimal precision of the token
raw_balance_str	VARCHAR	Token balance, unnormalized, as string to retain precision
raw_balance	FLOAT	Token balance, unnormalized
balance_str	VARCHAR	Token balance, normalized, as string to retain precision
balance	FLOAT	Token balance, normalized
usd_exchange_rate	FLOAT	Exchange rate used for USD conversion
usd_balance	FLOAT	Token balance, normalized, in USD
last_activity_block_timestamp	TIMESTAMP_NTZ(9)	Block timestamp of the most recent balance-changing activity
last_activity_block_number	INTEGER	Block number of the most recent balance-changing activity
last_activity_block_hash	VARCHAR	Block hash of the most recent balance-changing activity

ERC1155 Balances ERC1155 Balances Daily

⌘I

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

​Table Columns

Table Columns