select distinct tx_hash

from avalanche.core.ez_decoded_event_logs t1 join avalanche.core.dim_labels t2 on t1.origin_to_address = t2.address

where event_name ilike 'swap'

and t2.label_type = 'dex'),

arbswaptx as (

select distinct tx_hash

from arbitrum.core.ez_decoded_event_logs t1 join arbitrum.core.dim_labels t2 on t1.origin_to_address = t2.address

where event_name ilike 'swap'

and t2.label_type = 'dex'),

polyswaptx as (

select distinct tx_hash

from polygon.core.ez_decoded_event_logs t1 join polygon.core.dim_labels t2 on t1.origin_to_address = t2.address

where event_name ilike 'swap'

and t2.label_type = 'dex'),

optswaptx as (

select distinct tx_hash

from optimism.core.fact_event_logs t1 join optimism.core.dim_labels t2 on t1.origin_to_address = t2.address

where event_name ilike 'swap'

and t2.label_type = 'dex')

select symbol_out,

count (distinct tx_hash) as TX_Count,

count (distinct origin_from_address) as Users_Count,

sum (amount_in) as Volume

from optimism.core.ez_dex_swaps

where token_in in ('0x7f5c764cbc14f9669b88837ca1490cca17c31607')

and token_out not in ('0x7f5c764cbc14f9669b88837ca1490cca17c31607')

group by 1

order by 2 desc

limit 10