distinct contract_address as Pool_address,

count (distinct tx_hash) as swap_count,

case

when contract_address = '0x1e31a2c6e6614273d740358affb46bef180efb7b' then 'USDC - WETH'

when contract_address = '0x7086622e6db990385b102d79cb1218947fb549a9' then 'USDC - WETH'

when contract_address = '0x249c5a2b55522295500848910550d0539e1d673d' then 'DAI - WETH'

when contract_address = '0xc3fafa11dc8555d1404e7a1046019ff892bda2b7' then 'USDC - WETH'

when contract_address = '0x67a381d449750056f3250c73161da1365dce8781' then 'USDC - DAI'

when contract_address = '0x11b072c5259ebd68e888a79c49bfff0bcf742983' then 'USDC - WETH'

when contract_address = '0xf5484ad6c3a69c0ff33dfed4fdf5a4c7eea13634' then 'USDC - WETH'

when contract_address = '0xaa1513ab4622ed52deee4bd2cd984fe52f336a63' then 'OP - WETH'

when contract_address = '0x5231c20af03fd827005e652afee1b6576589f968' then 'USDC - DAI'

when contract_address = '0xae8bf5a9ca4e980637526ba1e5b68462d3880d49' then 'OP - WETH'

else 'Other Pools'

end as pools

from optimism.core.fact_event_logs

where origin_to_address = '0xbe811a0d44e2553d25d11cb8dc0d3f0d0e6430e6'

and event_name = 'Swap'

group by pool_address, pools

order by swap_count DESC

limit 10