yasminnew user staking INCRIMENT
Updated 2025-01-27
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
33
34
35
36
›
⌄
WITH staker AS (
SELECT
DATE_TRUNC('week', block_timestamp) AS week,
COUNT(DELEGATOR) AS total_users
FROM flow.core.fact_events
JOIN flow.gov.ez_staking_actions USING(TX_ID)
WHERE EVENT_CONTRACT = 'A.d6f80565193ad727.LiquidStaking'
AND action IN ('DelegatorTokensCommitted', 'TokensCommitted')
AND EVENT_TYPE = 'Stake'
GROUP BY 1
),
user AS (
SELECT
DELEGATOR AS users,
MIN(block_timestamp::date) AS min_date
FROM flow.core.fact_events
JOIN flow.gov.ez_staking_actions USING(TX_ID)
WHERE EVENT_CONTRACT = 'A.d6f80565193ad727.LiquidStaking'
AND action IN ('DelegatorTokensCommitted', 'TokensCommitted')
AND EVENT_TYPE = 'Stake'
GROUP BY users
),
new_user AS (
SELECT
DATE_TRUNC('week', min_date) AS stake_date,
COUNT(users) AS new_staker
FROM user
GROUP BY DATE_TRUNC('week', min_date)
)
SELECT
new_user.stake_date,
new_user.new_staker,
staker.total_users
FROM new_user
JOIN staker ON new_user.stake_date = staker.week
QueryRunArchived: QueryRun has been archived