0-MIDBorrower and Lender Growth On Red Bank
    Updated 2023-03-14
    select BLOCK_TIMESTAMP::date as date
    ,count(distinct case when action='borrow' then SENDER end) as BORROWERS
    ,count(distinct case when action='deposit' then SENDER end) as LENDERS
    ,sum(BORROWERS)over(order by date)as borrower_growth
    ,sum(LENDERS)over(order by date)as lender_growth
    from osmosis.mars.ez_redbank_actions
    where TX_SUCCEEDED='TRUE'
    group by 1
    Run a query to Download Data