Skip to main content
The stablecoins_evm.balances table contains daily stablecoin balances per address across 37 supported EVM chains. One row represents one address-token balance snapshot for a specific day. Coverage is ERC20 stablecoin balances.

Upgrade to the enriched dataset

Skip manual reconstruction. The enriched version packages attribution and methodology so you can move from raw data to insights faster.

​
Table schema

ColumnTypeDescription
blockchainVARCHARChain name
dayDATEBalance date
addressVARBINARYHolder address
token_symbolVARCHARToken symbol
token_addressVARBINARYToken contract address
token_standardVARCHARToken standard (erc20)
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
    , b.token_symbol
    , SUM(b.balance_usd) AS total_supply_usd
FROM stablecoins_evm.balances AS b
WHERE b.day = CURRENT_DATE
    AND b.balance > 0
GROUP BY b.blockchain, b.token_symbol
ORDER BY total_supply_usd DESC

​
Notes

  • Balances are forward-filled by day.
  • For best performance, filter by blockchain and day.
  • For multichain aggregate balances, see stablecoins_multichain.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.
  • We will continue to work toward a more reliable total supply measure.