Skip to main content
The stablecoins_multichain.balances table is a normalized multichain balance view across:
  • 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.