select

'Osmosis' as chain,

sum(amount/pow(10,DECIMAL)) as axl_amoun,

avg(amount/pow(10,DECIMAL)) as avg_axl_amoun,

median(amount/pow(10,DECIMAL)) as median_axl_amoun,

count(distinct TX_ID) as txns,

count(distinct sender) as senders,

count(distinct receiver) as receivers

from

osmosis.core.fact_transfers

where currency = 'ibc/903A61A498756EA560B85A85132D3AEE21B5DEDD41213725D22ABF276EA6945E'

and TX_STATUS = 'SUCCEEDED'

and BLOCK_TIMESTAMP::date >= CURRENT_DATE - {{days_back}}

union all

select

'Axelar' as chain,

sum(amount/pow(10,DECIMAL)) as axl_amoun,

avg(amount/pow(10,DECIMAL)) as avg_axl_amoun,

median(amount/pow(10,DECIMAL)) as median_axl_amoun,

count(distinct TX_ID) as txns,

count(distinct sender) as senders,

count(distinct receiver) as receivers

from

axelar.core.fact_transfers

where currency = 'uaxl'

and TX_SUCCEEDED = 'TRUE'

and BLOCK_TIMESTAMP::date >= CURRENT_DATE - {{days_back}}