platform,

event_name,

tx_hash,

collateral_token_symbol,

debt_token_symbol,

SUM(amount_usd) total_liquidated_asset_volume

FROM avalanche.defi.ez_lending_liquidations

WHERE date(block_timestamp) >= '2024-05-01'

AND amount_usd IS NOT NULL

GROUP BY 1, 2, 3, 4, 5, 6

ORDER BY total_liquidated_asset_volume DESC

LIMIT 1000