Query editor
WITH latest AS (SELECT MAX(day) AS dFROM stablecoins_multichain.balancesWHERE blockchain IN ('ethereum','tron','solana','base','arbitrum','optimism','bnb')AND token_symbol IN ('USDT','USDC')),chain_supply AS (SELECTb.blockchain,SUM(b.balance_usd) AS supply_usdFROM stablecoins_multichain.balances bCROSS JOIN latest lWHERE b.day = l.dAND b.blockchain IN ('ethereum','tron','solana','base','arbitrum','optimism','bnb')AND b.token_symbol IN ('USDT','USDC')GROUP BY 1),total AS (SELECT SUM(supply_usd) AS total_usd FROM chain_supply)SELECTc.blockchain,c.supply_usd,100.0 * c.supply_usd / NULLIF(t.total_usd, 0) AS share_pctFROM chain_supply cCROSS JOIN total tORDER BY c.supply_usd DESC