nitspNetwork Bridge
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
31
32
33
34
35
36
›
⌄
with pUSDC as
(SELECT sender, amt, 'pUSDC' as type
from
(select *, base64_decode_string(tx_message:txn:apaa[0]::String ) as action_
,tx_message:dt:itx[0]:txn:aamt / pow(10,6) as amt,
case when action_ = 'withdraw' then amt*(-1) else amt end as amt_net
from algorand.application_call_transaction where app_id = 770102986
and (action_ = 'withdraw' or action_ = 'swap') and tx_message:dt:itx[0]:txn:xaid = '748211185'
)order by 2 desc limit 10 ),
pUSDT as
(SELECT sender, amt, 'USDT' as type
from
(select *, base64_decode_string(tx_message:txn:apaa[0]::String ) as action_
,tx_message:dt:itx[0]:txn:aamt / pow(10,6) as amt,
case when action_ = 'withdraw' then amt*(-1) else amt end as amt_net
from algorand.application_call_transaction
where app_id = 770102986
and (action_ = 'withdraw' or action_ = 'swap') and tx_message:dt:itx[0]:txn:xaid = '748208047')
order by 2 desc limit 10 )
,
pBTC as
(SELECT sender, amt , 'pBTC' as type from
(select *, base64_decode_string(tx_message:txn:apaa[0]::String ) as action_
,tx_message:dt:itx[0]:txn:aamt*21000 / pow(10,8) as amt,
case when action_ = 'withdraw' then amt*(-1) else amt end as amt_net
from algorand.application_call_transaction
where app_id = 770103640
and (action_ = 'withdraw' or action_ ilike 'Issue')and tx_message:dt:itx[0]:txn:xaid = '744665252')
)
SELECT * from pBTC
UNION ALL
SELECT * from pUSDC
Run a query to Download Data