datavortexclassic-amaranth
Updated 2024-11-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH staking_actions AS (
SELECT
action,
node_id
FROM
flow.gov.ez_staking_actions
WHERE
tx_succeeded = TRUE
AND action IN (
'NewNodeCreated',
'TokensCommitted',
'TokensStaked',
'NodeRemovedAndRefunded',
-- 'NodeTokensRequestedToUnstake',
'DelegatorTokensStaked',
'DelegatorTokensCommitted',
'DelegatorTokensUnstaking'
)
)
SELECT
COUNT(DISTINCT node_id) AS total_nodes
FROM
staking_actions;