Skip to main content
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 NameDescription
dateDaily timestamp of the balance snapshot.
token_standardToken standard (coin or fungible_asset).
addressWallet address holding the balance.
fa_store_addressFungibleStore address for FA balances.
token_addressToken address or FA metadata address.
token_nameToken name.
token_symbolToken symbol.
token_decimalsToken decimals.
raw_balance_strRaw balance as a string.
raw_balanceRaw balance cast to float.
balance_strNormalized balance as a string.
balanceNormalized balance as a float.
usd_exchange_rateUSD exchange rate at the daily timestamp.
usd_balanceUSD balance at the daily timestamp.
is_frozenWhether the FA store is frozen.
last_activity_block_timestampBlock timestamp of the last activity used to forward fill.
last_activity_block_heightBlock height of the last activity used to forward fill.
last_activity_global_change_indexGlobal 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 NameDescription
token_standardToken standard (coin or fungible_asset).
addressWallet address holding the balance.
fa_store_addressFungibleStore address for FA balances.
token_addressToken address or FA metadata address.
token_nameToken name.
token_symbolToken symbol.
token_decimalsToken decimals.
raw_balance_strRaw balance as a string.
raw_balanceRaw balance cast to float.
balance_strNormalized balance as a string.
balanceNormalized balance as a float.
usd_balanceUSD balance using hourly prices.
usd_exchange_rateUSD exchange rate used for balance.
is_frozenWhether the FA store is frozen.
transaction_versionTransaction version of the balance update.
transaction_indexTransaction index in the block.
change_indexChange index within the transaction.
block_timestampBlock timestamp of the balance update.
block_heightBlock height of the balance update.
global_change_indexGlobal order of the change.
unique_idDeterministic unique identifier.
_created_atRow creation timestamp.
_updated_atRow update timestamp.
The aptos.assets.fungible_balances_latest table contains the latest fungible balances with current and historical USD pricing.

​
Table Columns

Column NameDescription
token_standardToken standard (coin or fungible_asset).
addressWallet address holding the balance.
fa_store_addressFungibleStore address for FA balances.
token_addressToken address or FA metadata address.
token_nameToken name.
token_symbolToken symbol.
token_decimalsToken decimals.
raw_balance_strRaw balance as a string.
raw_balanceRaw balance cast to float.
balance_strNormalized balance as a string.
balanceNormalized balance as a float.
usd_balance_currentUSD balance using latest prices.
usd_balance_at_block_timestampUSD balance using historical prices at last activity.
usd_exchange_rate_currentLatest USD exchange rate.
usd_exchange_rate_at_block_timestampHistorical USD exchange rate at last activity.
last_activity_block_timestampBlock timestamp of the last activity.
last_activity_block_heightBlock height of the last activity.
unique_idDeterministic unique identifier.
_updated_at__usd_exchange_rate_currentTimestamp of the latest USD exchange rate.
_updated_at__historicalTimestamp of the historical balance row update.
_created_at__onchain_lakeTimestamp when the onchain balance row was created.
_updated_atRow update timestamp.
_changed_since_full_refreshWhether 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