strawbettyAlgofi goBTC
Updated 2022-05-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
-- Algofi:
select
block_timestamp::date as date,
case when TRY_BASE64_DECODE_STRING(tx_message:txn:note::string) = 'Market: mt' then 'mt'
when TRY_BASE64_DECODE_STRING(tx_message:txn:note::string) = 'Market: rcu' then 'rcu' 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[0] IN ('386192725', '465818554') -- goBTC
and (
try_base64_decode_string(tx_message:txn:note::string) = 'Market: mt'
or
try_base64_decode_string(tx_message:txn:note::string) = 'Market: rcu'
)
group by 1,2
Run a query to Download Data