stablecoins.core.balances_latest table gives the current balance of every address that has held a tracked stablecoin. For daily history, use stablecoins.core.balances_daily.
Unique Key: chain, address, token_address, token_account
Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Current stablecoin balance for every holder address.
stablecoins.core.balances_latest table gives the current balance of every address that has held a tracked stablecoin. For daily history, use stablecoins.core.balances_daily.
Unique Key: chain, address, token_address, token_account
select
address,
balance,
usd_balance
from stablecoins.core.balances_latest
where chain = 'base'
and product_id = 'usdc'
and balance > 0
order by balance desc
limit 20
| Column Name | Description |
|---|---|
chain | Blockchain of the balance. |
address | Holder address. |
token_account | Token account holding the balance, on chains that use one (e.g. Solana). Null elsewhere. |
product_id | Identifier of the stablecoin product. Join key to stablecoins.registry.catalog. |
token_address | Contract or mint address of the stablecoin. |
currency | Currency the stablecoin is pegged to. |
token_name | Name of the token. |
token_symbol | Symbol of the token. |
token_decimals | Decimals of the token. |
raw_balance_str | Raw balance, as a string. |
raw_balance | Raw balance. |
balance_str | Normalized balance, as a string. |
balance | Normalized balance. |
multiplier | Rebase factor for rebasing tokens. 1 otherwise. |
usd_balance | Balance in USD. |
usd_exchange_rate | USD price used for usd_balance. |
price_source | Source of the price. |
is_circulating | True if the balance counts toward circulating supply. |
block_date | Date of the last activity that changed this balance. |
last_activity_block_timestamp | Timestamp of the last activity that changed this balance. |
last_activity_block_number | Block number of the last activity that changed this balance. |
last_activity_block_hash | Block hash of the last activity that changed this balance. |
unique_id | Unique identifier for the row. |
_created_at | Timestamp this row was first created. |
_updated_at | Timestamp this row was last updated. |
Was this page helpful?