SELECT

date_trunc('month', block_timestamp) as month,

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