--trunc(block_timestamp,'day') as date,

distinct contract_address,

case when contract_address='0x85149247691df622eaf1a8bd0cafd40bc45154a9' then 'Genesis WETH/USDC pool'

when contract_address = '0x47029bc8f5cbe3b464004e87ef9c9419a48018cd' then 'VolatileV1 AMM - OP/USDC'

when contract_address = '0x36b18618c4131d8564a714fb6b4d2b1edadc0042' then 'vETH/vUSD Uniswap pool'

when contract_address = '0x79c912fef520be002c2b6e57ec4324e260f38e50' then 'VolatileV1 AMM - WETH/USDC'

when contract_address = '0xe8537b6ff1039cb9ed0b71713f697ddbadbb717d' then 'VolatileV1 AMM - VELO/USDC'

when contract_address = '0x68f5c0a2de713a54991e01858fd27a3832401849' then 'wETH/OP Uniswap pool'

when contract_address = '0x86f03c6e26b0488b6e39b34d7f10d843ae8e3d1b' then 'vPERP/vUSD Uniswap pool'

when contract_address = '0x6f59c163ad6cc896145af7d5922d1eae174a1bcc' then 'vMATIC/vUSD Uniswap pool'

when contract_address = '0x6c0bc93a4208eb1648af4ed44cb3b4df9547b42b' then 'vAAVE/vUSD Uniswap pool'

else 'Balancer v2 pools' end as pool,

count(distinct tx_hash) as counts

from optimism.core.fact_event_logs

--join optimism.core.dim_contracts y on x.contract_address=y.address --where event_name ='Swap' limit 10

where block_timestamp>=CURRENT_DATE- INTERVAL '1 MONTH' and event_name ='Swap'

group by 1,2 order by 3 desc limit 10