zakkisyedCopy of Luna burn and mint[Elite] Burn, Baby, Burn (Elite Edition)
    Updated 2022-07-07
    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