strawbettyPact.fi (Add & Remove liquidity goBTC)
Updated 2022-05-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- Pact.fi (Add & Remove liquidity)
select
block_timestamp::date as date,
case when TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) = 'ADDLIQ' then 'Add liquidity'
when TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) = 'REMLIQ' then 'Remove liquidity' end as action,
count(distinct sender) as users,
count(distinct tx_group_id) as transactions
from flipside_prod_db.algorand.transactions
where
tx_message:txn:apas[1] = '386192725' -- goBTC
and
(
TRY_BASE64_DECODE_STRING(tx_message :txn :apaa [0] :: STRING) = 'ADDLIQ'
or
TRY_BASE64_DECODE_STRING(tx_message :txn :apaa [0] :: STRING) = 'REMLIQ'
)
group by 1,2
Run a query to Download Data