binhachonRedemption Arc - Method #2
    Updated 2022-04-05
    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