Query editor
WITH ranked AS (SELECT projectFROM lending.supplyWHERE block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '1' MONTH)AND block_time >= CURRENT_DATE - INTERVAL '30' DAYAND blockchain IN ('ethereum','arbitrum','optimism','base','polygon','scroll','zksync','linea')AND transaction_type = 'deposit'GROUP BY projectORDER BY SUM(COALESCE(amount_usd, 0)) DESCLIMIT 5)SELECTs.project,s.blockchain,SUM(CASE WHEN s.transaction_type = 'deposit' THEN COALESCE(s.amount_usd, 0) ELSE 0 END) AS deposit_usd,SUM(CASE WHEN s.transaction_type = 'withdraw' THEN COALESCE(s.amount_usd, 0) ELSE 0 END) AS withdraw_usd,SUM(CASE WHEN s.transaction_type = 'deposit' THEN COALESCE(s.amount_usd, 0)WHEN s.transaction_type = 'withdraw' THEN -COALESCE(s.amount_usd, 0)ELSE 0 END) AS net_supply_usdFROM lending.supply sJOIN ranked r ON s.project = r.projectWHERE s.block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '1' MONTH)AND s.block_time >= CURRENT_DATE - INTERVAL '30' DAYAND s.blockchain IN ('ethereum','arbitrum','optimism','base','polygon','scroll','zksync','linea')GROUP BY s.project, s.blockchainORDER BY deposit_usd DESC