ACTION

,case

when CURRENCY='uosmo' then 'OSMO'

when CURRENCY='ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2' then 'ATOM'

when CURRENCY='ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858' then 'AXLUSDC' end as token_name

,sum(AMOUNT/1e6) as volume

,count(distinct SENDER) as actor

,count(distinct TX_ID) as action_count

from osmosis.mars.ez_redbank_actions

where TX_SUCCEEDED='TRUE'

group by 1,2