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)SELECTDATE_TRUNC('day', s.block_time) AS day,s.project,SUM(COALESCE(s.amount_usd, 0)) AS deposit_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.transaction_type = 'deposit'AND s.blockchain IN ('ethereum','arbitrum','optimism','base','polygon','scroll','zksync','linea')GROUP BY 1, 2ORDER BY 1 ASC, deposit_usd DESC