address_name as swap_from,

count(distinct a.tx_hash) as swap_count

from optimism.core.fact_event_logs a

inner join optimism.core.dim_labels b

on a.contract_address = b.address

where a.origin_to_address IN ('0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45',

'0xe592427a0aece92de3edee1f18e0157c05861564') -- UniSwap Contracts

and a.event_inputs:to = a.origin_from_address

and event_name = 'Transfer' -- 'Swap' results in 0 rows - every swap can be treated as a transfer too.

and tx_status = 'SUCCESS'

group by swap_from

order by swap_count DESC

limit 10