zakkisyedCopy of Luna burn and mint[Elite] Burn, Baby, Burn (Elite Edition)
Updated 2022-07-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select 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'
)
where blocktime > getdate() - interval'90 days'
group by blocktime
order by blocktime desc
Run a query to Download Data