pool_name,

contract_address,

count(distinct tx_hash) as transactions,

sum(amount_in_usd) as volume_usd

from ethereum.core.ez_dex_swaps

where platform = 'sushiswap'

and block_timestamp > current_date - interval '6 months'

group by 1, 2

order by 3 desc

limit 5