binhachonRedemption Arc - Method #2
Updated 2022-04-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 UST_mint_transaction as (
select
tx_id -- Burn LUNA mint UST
from terra.msgs
where block_timestamp > getdate() - interval'180 days'
and msg_value:contract::string = 'terra1vs9jr7pxuqwct3j29lez3pfetuu8xmq7tk3lzk'
and msg_value:execute_msg:assert_limit_order:ask_denom::string = 'uusd'
and msg_value:execute_msg:assert_limit_order:offer_coin:denom::string = 'uluna'
and tx_status = 'SUCCEEDED'
and msg_index = 0
),
UST_burn_transaction as (
select
tx_id -- Burn UST mint LUNA
from terra.msgs
where block_timestamp > getdate() - interval'180 days'
and msg_value:contract::string = 'terra1vs9jr7pxuqwct3j29lez3pfetuu8xmq7tk3lzk'
and msg_value:execute_msg:assert_limit_order:offer_coin:denom::string = 'uusd'
and msg_value:execute_msg:assert_limit_order:ask_denom::string = 'uluna'
and tx_status = 'SUCCEEDED'
and msg_index = 0
),
UST_mint_fee as (
select
date_trunc('hour', block_timestamp) as time,
sum(UST_mint_amount)/1e6 as UST_mint_amount,
sum(UST_fee_amount) / (sum(UST_mint_amount) + sum(UST_fee_amount)) * 100 as UST_mint_fee_perc
from (
select
block_timestamp,
event_attributes:"1_amount"[0]:amount as UST_mint_amount,
event_attributes:"2_amount"[0]:amount as UST_fee_amount,
UST_fee_amount/(UST_mint_amount+UST_fee_amount)*100 as UST_fee_perc
from terra.msg_events
where tx_id in (select tx_id from UST_mint_transaction)
and event_type = 'transfer'
Run a query to Download Data