shahdadi-9ptm8YUntitled Query
Updated 2022-07-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select * from flipside_prod_db.algorand.transactions where tx_group_id='5Nt6lqW2DJ14KlvN/l68gTR6jtW+3reoN54745h0q1Y='
select
block_timestamp::date as date,
CASE WHEN TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) = 'd' THEN 'Deposit'
WHEN TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) = 'r' THEN 'Redeem'
end AS action,
count(distinct tx_group_id) as tx_count,
count(distinct sender) as users_count
from flipside_prod_db.algorand.APPLICATION_CALL_TRANSACTION
where TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) IN ('d','r') and app_id in( 686498781,686500029)
and date <= '2022-05-20' and TRY_BASE64_DECODE_STRING(tx_message :txn :apaa [0] :: STRING) = 'l'
group by 1,2
order by 1,2
Run a query to Download Data