shahdadi-9ptm8YUntitled Query
Updated 2022-05-21
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
26
›
⌄
with LP as (
select
CASE
when array_size(tx_message:txn:apas) = 3 then tx_message:txn:apas[2]
when array_size(tx_message:txn:apas) = 2 then tx_message:txn:apas[1]
END as lp_token,
sum(1) as count
from algorand.application_call_transaction
WHERE
block_timestamp::date >= '2022-01-01'
and try_base64_decode_string(tx_message:txn:apaa[0]::string) IN ('mint', 'burn')
and app_id IN (552635992)
group by 1
order by 2 desc
)
select asset.asset_name as lp_name, LP.count as count
from LP as lp, algorand.asset as asset
where lp.lp_token = asset.asset_id and lp_name like '%btc'
order by count desc
Run a query to Download Data