princefarzamAnchor collateral
Updated 2022-02-05
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
›
⌄
WITH provide_bETH as(
SELECT
BLOCK_TIMESTAMP,
EVENT_ATTRIBUTES:collaterals[0]:amount::INT/POW(10,6) AS bETH_AMOUNT
FROM terra.msg_events
WHERE EVENT_ATTRIBUTES:"0_action"::string = 'lock_collateral'
AND EVENT_ATTRIBUTES:collaterals[0]:denom::string='terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun'
and tx_status = 'SUCCEEDED'
and BLOCK_TIMESTAMP >= '2021-11-03' --90 days ago
GROUP BY 1,2
ORDER by 1 ASC
),
SUM_bETH AS(
SELECT
SUM(bETH_AMOUNT) AS SUM_bETH,
(SELECT
avg(price_usd)
from terra.oracle_prices
where symbol= 'mETH'
and BLOCK_TIMESTAMP >= '2021-11-03') * SUM_bETH AS SUM_bETH_IN_UST
FROM provide_bETH
),
provide_bLUNA as(
SELECT
BLOCK_TIMESTAMP,
EVENT_ATTRIBUTES:collaterals[0]:amount::INT/POW(10,6) AS bLUNA_AMOUNT
FROM terra.msg_events
WHERE EVENT_ATTRIBUTES:"0_action"::string = 'lock_collateral'
AND EVENT_ATTRIBUTES:collaterals[0]:denom::string='terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp'
and tx_status = 'SUCCEEDED'
and BLOCK_TIMESTAMP >= '2021-11-03' --90 days ago
GROUP BY 1,2
ORDER by 1 ASC
),
SUM_bLUNA AS(
SELECT
Run a query to Download Data