date_trunc('week', block_timestamp) as "Day",

case

when currency in ('ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4','terra1uc3r74qg44csdrl8hrm5muzlue9gf7umgkyv569pgazh7tudpr4qdtgqh6') then 'axlUSDC'

when currency in ('ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF','terra1rcmvfsn77pd6m04ctqj3wcu66pvrw9p265cdl72w4zarfup2rv7qjxhkzl') then 'axlUSDT'

end as stablecoins,

-- case

-- when message_value:receiver ilike '%kujira%' then 'Kujira'

-- when message_value:receiver ilike '%osmo%' then 'Osmosis'

-- when message_value:receiver ilike '%axelar%' then 'Axelar'

-- when message_value:receiver ilike '%evmos%' then 'Evmos'

-- when message_value:receiver ilike '%secret%' then 'Secret'

-- when message_value:receiver ilike '%juno%' then 'Juno'

-- when message_value:receiver ilike '%cre%' then 'Cre'

-- when message_value:receiver ilike '%gravity%' then 'Gravity'

-- when message_value:receiver ilike '%sif%' then 'Sif'

-- when message_value:receiver ilike '%stride%' then 'Stride'

-- else message_value:receiver

-- end as "Destination chain",

count(distinct tx_id) as "tx count",

count(distinct sender) as "Unique wallet",

sum(amount::number/1e6) as "Volume",

avg(amount::number/1e6) as "AVG volume"

from terra.core.ez_transfers

where tx_succeeded = 'TRUE' and

transfer_type = 'IBC_Transfer_Off' and

currency in ('ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4','terra1uc3r74qg44csdrl8hrm5muzlue9gf7umgkyv569pgazh7tudpr4qdtgqh6' --usdc

,'ibc/CBF67A2BCF6CAE343FDF251E510C8E18C361FC02B23430C121116E0811835DEF','terra1rcmvfsn77pd6m04ctqj3wcu66pvrw9p265cdl72w4zarfup2rv7qjxhkzl') --usdt

group by 1, 2

order by 1