Query editor
SELECTb.project,b.blockchain,COUNT(*) AS liquidation_count,COUNT(DISTINCT b.borrower) AS liquidated_borrowers,ABS(SUM(COALESCE(b.amount_usd, 0))) AS liquidated_usdFROM lending.borrow bWHERE b.block_month >= DATE_TRUNC('month', CURRENT_DATE - INTERVAL '1' MONTH)AND b.block_time >= CURRENT_DATE - INTERVAL '30' DAYAND b.liquidator IS NOT NULLAND b.blockchain IN ('ethereum','arbitrum','optimism','base','polygon','scroll','zksync','linea')GROUP BY b.project, b.blockchainORDER BY liquidated_usd DESCLIMIT 30