feyikemiAll-TIme Stakers
Updated 2024-12-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH Stake_stats AS (
SELECT
block_timestamp,
delegator AS User,
iff(action IN ('DelegatorTokensCommitted', 'TokensCommitted'), 'Stake', 'Unstake') as action
FROM flow.gov.ez_staking_actions
WHERE tx_succeeded = 1
)
SELECT
COUNT(DISTINCT User) AS Stakers
--Stakers / COUNT(DISTINCT block_timestamp::date) as daily_average_stakers
FROM Stake_stats
WHERE action = 'Stake'
QueryRunArchived: QueryRun has been archived