freemartianOther Pools Mint Count
Updated 2022-05-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
with liquidity_action as (
select
try_base64_decode_string(tx_message:txn:apaa[0]::string) as apaa, date_trunc('day', block_timestamp) as DATE, tx_id,
(case
when array_size(tx_message:txn:apas) = 2 then tx_message:txn:apas[1]
when array_size(tx_message:txn:apas) = 3 then tx_message:txn:apas[2]
end) as liquidity_action
from algorand.application_call_transaction
where try_base64_decode_string(tx_message:txn:apaa[0]::string) in ('mint', 'burn')
and app_id in (552635992)
and block_timestamp >= '2022-02-10'
)
select la.DATE, la.apaa, count(la.tx_id) as mint_count,
(case
when aa.address = 'KX6S647W6BEN6XHEJVMXK3UYLVNGT2Q6PHQSF5AA2JSSDFSOX7R4MESXRY' then 'Yieldly-ALGO'
when aa.address = '5XQEBPFLVR5WOGZNVSLHVKELRDP2LVVLB44OWZ7WA3JKQ72SYTD6MVZTWI' then 'PLANET-ALGO'
when aa.address = 'XLNMBK3GMC4YEF562DMEOZEYTNDWJLQRN2GFQ3MGLVNIJTOTVGVD75DVKM' then 'Defly Token-ALGO'
else 'others'
end) as pool
from algorand.account_asset aa
join liquidity_action la on aa.asset_id = la.liquidity_action
where pool!= 'others'
and la.apaa = 'mint'
group by 1,2, pool
Run a query to Download Data