PapasotYieldly staking pools actions
Updated 2023-01-03
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
›
⌄
select
date_trunc('day',block_timestamp) as block_day,
count(tx_id) as application_actions,
count(distinct(sender)) as Stakers,
case
when app_id = '717256390' then 'ALCH'
when app_id = '710518651' then 'COSG'
when app_id = '625053603' then 'NURD'
when app_id = '593270704' then 'TINY'
when app_id = '591414576' then 'DEFLY'
when app_id = '511597182' then 'AKITA'
when app_id = '596950925' then 'HDL'
else 'other' end as pool
--try_base64_decode_string(tx_message:txn:apaa[0]::string) as note
from algorand.application_call_transaction
where
block_timestamp > '2022-01-01'
and app_id = 717256390
or app_id = 710518651
or app_id = 625053603
or app_id = 593270704
or app_id = 591414576
or app_id = 511597182
or app_id = 596950925
group BY
block_day,pool
order by
block_day
Run a query to Download Data