SUBSTRING(sender, 0, charindex('1',sender) - 1 ) as sender_chain,

SUBSTRING(receiver, 0, charindex('1',receiver) - 1 ) as receiver_Chain,

lower(split(currency,'-')[0]) as token

FROM axelar.core.fact_transfers

WHERE transfer_type in ('IBC_TRANSFER_OUT')

AND sender ilike 'axelar%'

AND TX_SUCCEEDED = 'TRUE')

SELECT

sender_chain,

receiver_chain,

sum(amount) as volume

FROM table1

WHERE token = 'uaxl'

GROUP BY 1,2 ORDER BY 3 DESC

limit 10