Stablecoin Balances (Multichain)

Normalized daily stablecoin balances across EVM, Solana, and Tron

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

Column	Type	Description
blockchain	VARCHAR	Chain name
day	DATE	Balance date
address	VARCHAR	Holder address (normalized)
token_symbol	VARCHAR	Token symbol
token_address	VARCHAR	Token contract/mint address (normalized)
token_standard	VARCHAR	Token standard
token_id	VARCHAR	Token id (typically NULL)
balance_raw	UINT256	Raw balance
balance	DOUBLE	Decimals-adjusted balance
balance_usd	DOUBLE	USD value
currency	VARCHAR	ISO 4217 currency code
last_updated	TIMESTAMP	Last 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.