iff(currency ilike 'u%', substring(currency, 2), currency) as currency,

count(distinct (tx_id)) as tx_count,

sum(amount / pow(10, decimal)) as total_amount,

count(distinct (sender)) as senders_count,

count(distinct (receiver)) as receivers_count

from axelar.core.fact_transfers

where 1 = 1

and (

currency not like 'factory%'

and currency not like 'gravity%'

and tx_succeeded = 1

and transfer_type like 'IBC_TRANSFER_%'

group by currency

having total_amount > 0

order by total_amount desc

limit 10