case

when ACTION='borrow' then 'BORROW'

when ACTION='deposit' then 'DEPOSIT' end as action_type

--,case

--when CURRENCY='uosmo' then 'OSMO'

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

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

,case

when AMOUNT/1e6>0 and AMOUNT/1e6<=10 then 'Below 10 $ATOM'

when AMOUNT/1e6>10 and AMOUNT/1e6<=100 then '10 ~100 $ATOM'

when AMOUNT/1e6>100 and AMOUNT/1e6<=1000 then '100 ~1K $ATOM'

when AMOUNT/1e6>1000 and AMOUNT/1e6<=10000 then '1K ~10K $ATOM'

when AMOUNT/1e6>10000 and AMOUNT/1e6<=100000 then '10K ~100K $ATOM'

when AMOUNT/1e6>100000 then 'UP To 100K $ATOM' end as dis_volume

,count(distinct SENDER) as actor

,count(distinct TX_ID) as action_count

from osmosis.mars.ez_redbank_actions

where TX_SUCCEEDED='TRUE'

and CURRENCY='ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2'

and action_type is not null

group by 1,2