messariterra - anchor history collapse
Updated 2022-05-10
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
35
36
›
⌄
-- old query
-- '/61ef8e66-1b59-4c68-b451-524aee171182'
WITH borrows AS (
SELECT
TRUNC(block_timestamp,'hour') as date,
COUNT(DISTINCT tx_id) AS n_tx,
SUM(msg_value:execute_msg:borrow_stable:borrow_amount) / 1e6 AS total_borrowed,
COUNT(DISTINCT msg_value:sender) AS borrowers
FROM terra.msgs
WHERE
msg_value:contract = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s' AND
msg_value:execute_msg:borrow_stable IS NOT NULL AND
tx_status = 'SUCCEEDED'
GROUP BY
date
),
repayments AS (
SELECT
TRUNC(block_timestamp,'hour') as date,
COUNT(DISTINCT tx_id) AS n_tx,
SUM(msg_value:coins[0]:amount) / 1e6 AS total_repaid,
COUNT(DISTINCT msg_value:sender) AS repayers
FROM terra.msgs
WHERE
msg_value:contract = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s' AND
msg_value:coins[0]:denom = 'uusd' AND
msg_value:execute_msg:repay_stable IS NOT NULL AND
tx_status = 'SUCCEEDED'
GROUP BY
date
),
Run a query to Download Data