j-hackworthanchor suply?
Updated 2022-03-23
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 mint as(
SELECT
DATE(block_timestamp) as "Date",
SUM(msg_value:coins[0].amount::float/POW(10,6)) as luna_mint
FROM terra.msgs
WHERE msg_value:contract = 'terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts'
and msg_value:execute_msg:bond IS NOT NULL
GROUP BY 1
ORDER BY 1 DESC
),
reg_burn as (
SELECT
DATE(block_timestamp) as "Date Burn",
SUM(msg_value:execute_msg:send:amount::float/POW(10,6)) as luna_reg_burn
FROM terra.msgs
WHERE
msg_value:contract = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp' -- Contract for BLUNA
AND
(msg_value:execute_msg:send:msg::string='{"unbond":{}}'
OR msg_value:execute_msg:send:msg = 'eyJ1bmJvbmQiOnt9fQ==')-- msg emitted during unbonding
GROUP BY 1
ORDER BY 1 DESC),
instant_burn as (
SELECT
DATE(block_timestamp) as "Date Burn",
SUM(msg_value:coins[0]:amount::float/POW(10,6)) as luna_inst_burn
FROM terra.msgs
WHERE
msg_module='wasm'
AND
msg_value:contract::string='terra1jxazgm67et0ce260kvrpfv50acuushpjsz2y0p' -- swap contract for bLuna to LUNA
GROUP BY 1
ORDER BY 1 DESC),
Run a query to Download Data