flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Show how many stake actions a day are occurring.
iboo-jbj2MV
Show how many stake actions a day are occurring.
Updated 2022-04-28
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
select
block_timestamp
::
date
as
date
,
count
(
DISTINCT
tx_group_id
)
as
num_staking_actions
from
algorand
.
application_call_transaction
where
TRY_BASE64_DECODE_STRING
(
tx_message
:
txn
:
apaa
[
0
]
::
STRING
)
=
'S'
and
app_id
=
710543830
group
by
1
Results