Query editor
SELECT CAST(block_time AS date) AS block_date,SUM(CASE WHEN project LIKE 'aave%' THEN amount_usd ELSE 0 END) AS aave_borrow,SUM(CASE WHEN project LIKE 'morpho%' THEN amount_usd ELSE 0 END) AS morpho_borrow,SUM(CASE WHEN project LIKE 'euler%' THEN amount_usd ELSE 0 END) AS euler_borrow,SUM(CASE WHEN project LIKE 'spark%' OR project LIKE 'maker%' OR project LIKE 'sky%' THEN amount_usd ELSE 0 END) AS sky_maker_borrowFROM lending.borrowWHERE block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '90' DAY)AND block_time >= CURRENT_DATE - INTERVAL '90' DAYAND transaction_type = 'borrow'AND (project LIKE 'aave%' OR project LIKE 'morpho%' OR project LIKE 'euler%' OR project LIKE 'spark%' OR project LIKE 'maker%' OR project LIKE 'sky%')AND amount_usd IS NOT NULL AND amount_usd > 0 AND amount_usd < 1e10GROUP BY 1 ORDER BY 1