Skip to main content
The stablecoins_multichain.balances table is a normalized multichain balance view across:

Use the prepackaged enriched versions

Skip manual reconstruction. The enriched version packages attribution and methodology so you can move from raw data to insights faster.
  • EVM stablecoin balances
  • Solana stablecoin balances
  • Tron stablecoin balances
It standardizes address and token_address fields as VARCHAR for cross-chain analysis. One row represents one address-token balance snapshot for a specific day after cross-chain normalization.

​
Table schema

ColumnTypeDescription
blockchainVARCHARChain name
dayDATEBalance date
addressVARCHARHolder address (normalized)
token_symbolVARCHARToken symbol
token_addressVARCHARToken contract/mint address (normalized)
token_standardVARCHARToken standard
token_idVARCHARToken id (typically NULL)
balance_rawUINT256Raw balance
balanceDOUBLEDecimals-adjusted balance
balance_usdDOUBLEUSD value
currencyVARCHARISO 4217 currency code
last_updatedTIMESTAMPLast balance update time

​
Sample Queries

SELECT
    b.blockchain
    , SUM(b.balance_usd) AS total_supply_usd
FROM stablecoins_multichain.balances AS b
WHERE b.day = CURRENT_DATE
    AND b.balance > 0
GROUP BY b.blockchain
ORDER BY total_supply_usd DESC

​
Notes

  • This is currently the stablecoin multichain aggregate table.
  • For chain-specific analysis, use stablecoins_evm.balances, stablecoins_solana.balances, and stablecoins_tron.balances.

Interpreting balances vs circulating supply

  • This table represents onchain balances, which is different from circulating supply.
  • Bridge-locked funds are intentionally included in balances. For example, more than $4B USDT can appear in the Tether USDT0Adapter contract on Ethereum while representing circulating USDT0 on other chains.
  • We are not subtracting bridge balances at this stage because exclusions are not objective across bridge designs, and some bridge-held balances represent liquidity for chains not covered elsewhere.
  • Excluding only selected bridges would also be incomplete in practice: some bridge-held balances represent liquidity for chains not covered elsewhere (for example Lighter and Hyperliquid bridge balances).
  • We will continue to work toward a more reliable total supply measure.