CASE WHEN receiver LIKE 'juno%' THEN 'JUNO'

WHEN receiver LIKE 'stars%' THEN 'STARS'

WHEN receiver LIKE 'axelar%' THEN 'AXL'

WHEN receiver LIKE 'evmos%' THEN 'EVMOS'

WHEN receiver LIKE 'cosmos%' THEN 'ATOM'

WHEN receiver LIKE 'stride%' THEN 'stride'

WHEN receiver LIKE 'terra%' THEN 'Terra'

ELSE 'Other Chain' END as chain,

COUNT(DISTINCT tx_id) as transfers,

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

FROM osmosis.core.fact_transfers

where day>'2022-11-04'

and SENDER LIKE 'osmo%'

AND currency LIKE 'ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858'--axlUSDC

AND not receiver LIKE 'osmo%'

GROUP BY 1,2