COUNT(*) AS total_liquidations,

COUNT(DISTINCT BORROWER) AS total_liquidated_borrowers,

SUM(AMOUNT_USD) AS total_liquidated_amount_usd,

platform,

collateral_token_symbol,

debt_token_symbol,

'Optimism' AS blockchain

optimism.defi.ez_lending_liquidations

BLOCK_TIMESTAMP BETWEEN '2024-01-01 00:00:00' AND '2024-12-31 23:59:59'

GROUP BY

platform,

collateral_token_symbol,

debt_token_symbol

ORDER BY

total_liquidations DESC;