Query editor
WITH daily AS (SELECTday,token_symbol,SUM(balance_usd) AS supply_usdFROM stablecoins_multichain.balancesWHERE day >= CURRENT_DATE - INTERVAL '120' DAYAND blockchain IN ('ethereum','tron','solana','base','arbitrum','optimism','bnb')AND token_symbol IN ('USDT','USDC')GROUP BY 1,2)SELECTday,SUM(CASE WHEN token_symbol = 'USDT' THEN supply_usd ELSE 0 END) AS usdt_supply_usd,SUM(CASE WHEN token_symbol = 'USDC' THEN supply_usd ELSE 0 END) AS usdc_supply_usd,SUM(supply_usd) AS total_supply_usdFROM dailyGROUP BY 1ORDER BY 1