date_trunc('day', block_timestamp) as date,

CASE

when sender like 'juno%' then 'JUNO'

when SENDER like 'stars%' then 'STARS'

when SENDER like 'axelar%' then 'AXL'

when SENDER like 'evmos%' then 'EVMOS'

when SENDER like 'cosmos%' then 'ATOM'

when SENDER like 'stride%' then 'stride'

when SENDER like 'terra%' then 'Terra'

ELSE 'Other Chain' END,

count(distinct tx_id) as transfers,

sum(amount/power(10, decimal)) as volume

from osmosis.core.fact_transfers

where RECEIVER like 'osmo%'

and not SENDER like 'osmo%'

group by 1,2