select top 10

concat(source_chain,'=>',destination_chain) as route

,count(DISTINCT tx_hash) as transactions

,count(sender) as wallets

from axelar.defi.ez_bridge_satellite

where block_timestamp>=current_date-30

group by 1

order by transactions desc

select

date_trunc(day,block_timestamp)::date as date

,concat(source_chain,'=>',destination_chain) as route

,count(DISTINCT tx_hash) as transactions

,count(DISTINCT sender) as wallets

from axelar.defi.ez_bridge_satellite

where route in(select route from lst_top)

and date>=current_date-30

group by 1,2

order by 1