select min(BLOCK_TIMESTAMP::date)as date

,SENDER

,case

when ACTION='borrow' then 'NEW BORROWER'

when ACTION='deposit' then 'NEW LENDER' 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

from osmosis.mars.ez_redbank_actions

where TX_SUCCEEDED='TRUE'

and CURRENCY='uosmo'

group by 2,3)

select date,action_type

,count(distinct SENDER) as new_users

,sum(new_users)over(order by date)as new_user_Growth

from tab1

where action_type is not null

group by 1,2