Pmisha-bmlMdxstaking.5
    Updated 2022-05-23
    with t2 as (
    select *,
    try_base64_decode_string(tx_message:txn:note::string) as message,
    tx_message:txn:apid as app_id
    from algorand.application_call_transaction
    where try_base64_decode_string(tx_message:txn:note::string) in ('Market: mt', 'Market: rcu')
    and app_id='465814222'
    and block_timestamp>= CURRENT_DATE-90)

    select
    date_trunc('day',block_timestamp) as dt,
    case when message = 'Market: mt' then 'Mint'
    when message = 'Market: rcu' then 'Burn'
    end as actions,
    count(distinct tx_id) as no_mint
    from t2
    group by 1,2 having actions is not null
    Run a query to Download Data