t1.CONTRACT_ADDRESS as Swap_From_Token,

case when split(address_name,':')[1] ilike '%l2%'

then split( split(address_name,':')[1],'l')[0]

else split(address_name,':')[1]

end as token,

count(distinct t1.tx_hash) as Swaps_Count

from optimism.core.fact_event_logs t1

full outer

join optimism.core.dim_labels t3 on t1.contract_address = t3.address

where t1.origin_to_address = lower('0x6352a56caadc4f1e25cd6c75970fa768a3304e64')

and t1.event_inputs:to = t1.origin_from_address

and event_name ='Transfer'

and token is not null

group by 1,2

order by 3 DESC