select contract_address,
address_name,
count (distinct tx_hash) as Swaps_Count,
count (distinct origin_from_address) as Swappers_Count
from optimism.core.fact_event_logs full outer join optimism.core.dim_labels on contract_address = address
where origin_to_address =lower('0xE6Df0BB08e5A97b40B21950a0A51b94c4DbA0Ff6')
and origin_from_address = event_inputs:from and event_name ='Transfer'
--and tx_hash = '0x30767ff76bd27d6c64fd1e81b9e34df0ee46634f86ed07aed0ed2540036ccade'
group by 1,2
order by 4 DESC
limit 10