sunslingerNet Deposits vs. Withdrawals (Pedro)
Updated 2022-05-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
⌄
SELECT
-- Withdrawals
(SELECT SUM(AMOUNT) FROM terra.transfer_events
WHERE SENDER = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s' AND CURRENT_ACTION != 'borrow_stable' AND BLOCK_TIMESTAMP > '2022-05-05'
) -
-- Deposits
(SELECT SUM(AMOUNT) FROM terra.transfer_events
WHERE RECIPIENT = 'terra1sepfj7s0aeg5967uxnfk4thzlerrsktkpelm5s' AND CURRENT_ACTION != 'repay_stable' AND CURRENCY = 'UST' AND BLOCK_TIMESTAMP > '2022-05-05'
)
AS NET_ANCHOR_UST_CHANGE;
---Method Two---
SELECT
-- Withdrawals
(SELECT SUM(AMOUNT) FROM anchor.redeem
WHERE BLOCK_TIMESTAMP > '2022-05-05')
-
-- Deposits
(SELECT SUM(DEPOSIT_AMOUNT) FROM anchor.deposits
WHERE BLOCK_TIMESTAMP > '2022-05-05')
AS NET_ANCHOR_UST_CHANGE;
Run a query to Download Data