nitsAnchor Borrows stats
    Updated 2022-02-21
    with sell_details as
    (SELECT *,msg_value:sender as sender, msg_value:execute_msg:send:amount/pow(10,6) as amt from terra.msgs
    where msg_value:contract = 'terra14z56l0fp2lsf86zy3hty2z47ezkhnthtr9yq76'
    and msg_value:execute_msg:send:msg:swap is not NULL
    and msg_value:execute_msg:send:contract = 'terra1gm5p3ner9x9xpwugn9sp6gvhd0lwrtkyrecdn3')

    SELECT count(DISTINCT addr) as total_borrowers, avg(amt_total) as avg_amt_borrowed,
    max(amt_total) as max_amt_borrowed,
    avg(times_borrowed_repayed) as avg_times_borrowed_repayed from
    (SELECT addr, sum(amt) as amt_total,count(*) as times_borrowed_repayed from
    (
    SELECT block_timestamp as bt, sender as addr,amount as amt from anchor.borrows
    UNION ALL
    SELECT block_timestamp as bt, sender as addr,amount*(-1) as amt from anchor.repay)
    where bt::date > CURRENT_DATE -90
    GROUP by 1 )
    where amt_total > '0'
    limit 100

    Run a query to Download Data