0xaimanAnchor Borrow and Deposit full
Updated 2021-12-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
›
⌄
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