Pmisha-bmlMdxstaking.8
Updated 2022-05-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with t2 as (
select *,
TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) as type
from algorand.application_call_transaction
where type in ('d', 'r')
and app_id='686501760'
and block_timestamp>= CURRENT_DATE-90)
select
date_trunc('day',block_timestamp) as dt,
case when type='d' then 'mint'
when type='r' then 'burn'
end as actions,
count(distinct tx_id) as total_mint
from t2
group by 1,2 having actions is not null
Run a query to Download Data