LEAST(debt_token_symbol, collateral_token_symbol) AS token_symbol_1,

GREATEST(debt_token_symbol, collateral_token_symbol) AS token_symbol_2,

SUM(liquidated_amount_usd) AS protocol_to_searcher_collateral_paid,

SUM(debt_to_cover_amount_usd) AS searcher_to_protocol_debt_paid,

SUM(liquidated_amount_usd) - SUM(debt_to_cover_amount_usd) AS searcher_revenue

FROM ethereum.aave.ez_liquidations

WHERE block_timestamp >= '2024-01-01' AND block_timestamp < '2024-10-01'

GROUP BY token_symbol_1, token_symbol_2

ORDER BY searcher_revenue DESC;