nitsAnchor Borrows stats
Updated 2022-02-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
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