select data:executed:receipt:logs[1]:address as token, data:value as amount_usd

from axelar.axelscan.fact_gmp

where (call ilike '%0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c%')

and data:interchain_transfer:event='InterchainTransfer'

and event='ContractCall'

and status = 'executed'

and simplified_status = 'received'

and data:executed:receipt:logs[1]:address is not null

and created_at::date between '{{Start_Date}}' and '{{End_Date}}'),

tab2 as (select address, name, symbol

from crosschain.core.dim_contracts)

select name, symbol, sum(amount_usd) as "Transfers Volume"

from tab1 left join tab2 on tab1.token=tab2.address

where name is not null and amount_usd is not null

group by 1 ,2

order by 3 desc

limit 10