-- 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",

transfer_type,

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

currency in ('ibc/B3504E092456BA618CC28AC671A71FB08C6CA0FD0BE7C8A5B5A3E2DD933CC9E4','terra1uc3r74qg44csdrl8hrm5muzlue9gf7umgkyv569pgazh7tudpr4qdtgqh6') and

message_value:receiver is not null

group by 1, 2