cypherLUNA BURN
Updated 2022-07-07
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
›
⌄
select
date(date_trunc('day', block_timestamp)) as blocktime,
sum(mint_luna) as "Luna minted",
sum(burn_luna) as "Luna burned",
sum(burn_luna) - sum(mint_luna) as "Net burned"
from(
(
select
block_timestamp,
0 as mint_luna,
msg_value:execute_msg:assert_limit_order:offer_coin:amount::float/1e6 as burn_luna
from
terra.msgs
where
msg_value:contract::string = 'terra1vs9jr7pxuqwct3j29lez3pfetuu8xmq7tk3lzk'
and
msg_value:execute_msg:assert_limit_order:offer_coin:denom::string = 'uluna'
and
tx_status = 'SUCCEEDED'
)
union all
(
select
block_timestamp,
msg_value:execute_msg:assert_limit_order:minimum_receive::float/1e6 as mint_luna,
0 as burn_luna
from
terra.msgs
where
msg_value:contract::string = 'terra1vs9jr7pxuqwct3j29lez3pfetuu8xmq7tk3lzk'
and
msg_value:execute_msg:assert_limit_order:ask_denom::string = 'uluna'
and
tx_status = 'SUCCEEDED'
)
)
Run a query to Download Data