0xaimanAnchor Borrow and Deposit full
    Updated 2021-12-24
    with depo as (select date_trunc('day',t) as date, avg(deposit) as avg_deposit, sum(deposit) as sum_deposit,
    sum(sum_deposit) OVER(ORDER BY date asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS total_deposited

    from (select block_timestamp as t, msg_value:coins[0]:amount/1000000 as deposit
    from terra.msgs
    where --tx_id='5862E7F55901A662E17B4489AF8F5F27439C4D2F99D9D41247305AD838E2A0CC' and
    msg_value:contract='terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s' and
    msg_value:execute_msg:borrow_stable:borrow_amount is null and
    msg_value:coins[0]:amount is not null

    )

    group by 1 order by 1),


    borrow as (
    select date_trunc('day',t) as date1, avg(borrow) as avg_borrow, sum(borrow) as sum_borrow,
    sum(sum_borrow) OVER(ORDER BY date1 asc ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS total_borrowed

    from (select block_timestamp as t, msg_value:execute_msg:borrow_stable:borrow_amount/1000000 as borrow
    from terra.msgs
    where -- tx_id='41D9FDE26341AD0A320FFEB2CEB623B91675496FA8CF42457C3BFFE28C618956' and
    msg_value:contract='terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s' and
    msg_value:execute_msg:borrow_stable:borrow_amount is not null
    )

    group by 1 order by 1

    )

    select date, avg_borrow, total_borrowed, avg_deposit, total_deposited
    from depo
    inner join borrow on depo.date=borrow.date1
    Run a query to Download Data