Query editor
SELECTSUM(CASE WHEN transaction_type = 'borrow' THEN COALESCE(amount_usd, 0) ELSE 0 END) AS total_borrow_volume_30d,COUNT(DISTINCT CASE WHEN transaction_type = 'borrow' THEN borrower END) AS unique_borrowers_30d,ABS(SUM(CASE WHEN liquidator IS NOT NULL THEN COALESCE(amount_usd, 0) ELSE 0 END)) AS total_liquidation_volume_30d,COUNT(CASE WHEN liquidator IS NOT NULL THEN 1 END) AS liquidation_events_30dFROM lending.borrowWHERE 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')