Fungible balances

The aptos.assets.fungible_balances_daily table contains daily fungible balances forward-filled from end-of-day snapshots, including FA store addresses and USD prices.

Table Columns

Column Name	Description
date	Daily timestamp of the balance snapshot.
token_standard	Token standard (coin or fungible_asset).
address	Wallet address holding the balance.
fa_store_address	FungibleStore address for FA balances.
token_address	Token address or FA metadata address.
token_name	Token name.
token_symbol	Token symbol.
token_decimals	Token decimals.
raw_balance_str	Raw balance as a string.
raw_balance	Raw balance cast to float.
balance_str	Normalized balance as a string.
balance	Normalized balance as a float.
usd_exchange_rate	USD exchange rate at the daily timestamp.
usd_balance	USD balance at the daily timestamp.
is_frozen	Whether the FA store is frozen.
last_activity_block_timestamp	Block timestamp of the last activity used to forward fill.
last_activity_block_height	Block height of the last activity used to forward fill.
last_activity_global_change_index	Global change index of the last activity.

The aptos.assets.fungible_balances_eod table contains end-of-day fungible balances (coin and fungible asset standards) for each address and token, hydrated with token metadata and USD prices.

Table Columns

Column Name	Description
token_standard	Token standard (coin or fungible_asset).
address	Wallet address holding the balance.
fa_store_address	FungibleStore address for FA balances.
token_address	Token address or FA metadata address.
token_name	Token name.
token_symbol	Token symbol.
token_decimals	Token decimals.
raw_balance_str	Raw balance as a string.
raw_balance	Raw balance cast to float.
balance_str	Normalized balance as a string.
balance	Normalized balance as a float.
usd_balance	USD balance using hourly prices.
usd_exchange_rate	USD exchange rate used for balance.
is_frozen	Whether the FA store is frozen.
transaction_version	Transaction version of the balance update.
transaction_index	Transaction index in the block.
change_index	Change index within the transaction.
block_timestamp	Block timestamp of the balance update.
block_height	Block height of the balance update.
global_change_index	Global order of the change.
unique_id	Deterministic unique identifier.
_created_at	Row creation timestamp.
_updated_at	Row update timestamp.

The aptos.assets.fungible_balances_latest table contains the latest fungible balances with current and historical USD pricing.

Table Columns

Column Name	Description
token_standard	Token standard (coin or fungible_asset).
address	Wallet address holding the balance.
fa_store_address	FungibleStore address for FA balances.
token_address	Token address or FA metadata address.
token_name	Token name.
token_symbol	Token symbol.
token_decimals	Token decimals.
raw_balance_str	Raw balance as a string.
raw_balance	Raw balance cast to float.
balance_str	Normalized balance as a string.
balance	Normalized balance as a float.
usd_balance_current	USD balance using latest prices.
usd_balance_at_block_timestamp	USD balance using historical prices at last activity.
usd_exchange_rate_current	Latest USD exchange rate.
usd_exchange_rate_at_block_timestamp	Historical USD exchange rate at last activity.
last_activity_block_timestamp	Block timestamp of the last activity.
last_activity_block_height	Block height of the last activity.
unique_id	Deterministic unique identifier.
_updated_at__usd_exchange_rate_current	Timestamp of the latest USD exchange rate.
_updated_at__historical	Timestamp of the historical balance row update.
_created_at__onchain_lake	Timestamp when the onchain balance row was created.
_updated_at	Row update timestamp.
_changed_since_full_refresh	Whether the row changed since last full refresh.

Sample Query 1

Finding distribution of balances at a given point of time.

select * from aptos.assets.fungible_balances_eod 
where date(block_timestamp) <= '2026-01-01' -- Date of interest
and token_address = '0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b' -- USDC Token Address
and token_standard = 'fungible_asset' 
qualify row_number() over (partition by address, fa_store_address order by global_change_index desc) = 1 

Overview

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Table Columns

Table Columns

Table Columns

Sample Query 1

​Table Columns

​Table Columns

​Table Columns

​Sample Query 1

Table Columns

Table Columns

Table Columns

Sample Query 1