MLDZMNswap pair
Updated 2022-06-24
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
27
28
29
30
›
⌄
with tb1 as (select
BASE64_DECODE_BINARY(tx_message:txn:apaa[1]::String)::string,BASE64_DECODE_string(tx_message:txn:note::String),
*
from algorand.application_call_transaction
where BASE64_DECODE_BINARY(tx_message:txn:apaa[1]::String)::string = '03'
and BASE64_DECODE_string(tx_message:txn:note::String) = 'Reach 0.1.10'
),
tb2 as (select
APP_ID,
count(distinct TX_GROUP_ID) as no_use
from algorand.application_call_transaction
where TX_GROUP_ID in (select TX_GROUP_ID from tb1)
group by 1
order by 2 desc
limit 5)
select
case
when APP_ID=711293358 then 'TINY to Vestige'
when APP_ID=777747637 then 'ALGO to Vestige'
when APP_ID=777628254 then 'USDC to ALGO'
when APP_ID=773172535 then 'ALGO to Chips'
when APP_ID=779142716 then 'goMINT to ALGO'
end as swap_pairs,
no_use as swap_count
from tb2
Run a query to Download Data