Pmisha-bmlMdxstaking.5
Updated 2022-05-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
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