bachiAnchor borrows
Updated 2021-12-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
select date(block_timestamp) as date, sender, sum(borrow_amount) as tot_bor_amt, avg(borrow_amount) as avg_bor_amt from
(
SELECT
block_id,
block_timestamp,
tx_id,
msg_value:sender::string as sender,
msg_value:execute_msg:borrow_stable:borrow_amount / POW(10,6) as borrow_amount,
msg_value:contract::string as contract_address,
c.address_name
FROM terra.msgs
LEFT OUTER JOIN terra.labels c
ON msg_value:contract::string = c.address
WHERE msg_value:contract = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s'
AND msg_value:execute_msg:borrow_stable IS NOT NULL
AND block_timestamp >= DATEADD(month, -1, getdate()))
--ORDER BY block_timestamp DESC)
group by date, sender order by date desc
limit 50000
Run a query to Download Data