SELECT

delegator

FROM

flow.gov.ez_staking_actions

WHERE

action = 'DelegatorTokensCommitted'

AND block_timestamp >= '2024-11-06'

AND block_timestamp < '2024-11-13'

GROUP BY

delegator

),

tracked_new_stakes AS (

SELECT

CASE

WHEN block_timestamp >= '2024-11-13' AND block_timestamp < '2024-11-20' THEN 'Epoch 1: 13-20th Nov'

WHEN block_timestamp >= '2024-11-20' AND block_timestamp < '2024-11-27' THEN 'Epoch 2: 20-27th Nov'

WHEN block_timestamp >= '2024-11-27' AND block_timestamp < '2024-12-04' THEN 'Epoch 3: 27th Nov-4th Dec'

END AS epoch,

COUNT(DISTINCT delegator) AS total_delegators_with_new_stakes,

SUM(amount) AS total_new_stake_amount

FROM

flow.gov.ez_staking_actions

WHERE

action = 'DelegatorTokensCommitted'

AND delegator IN (SELECT delegator FROM first_epoch_delegators)

AND (

(block_timestamp >= '2024-11-13' AND block_timestamp < '2024-11-20') OR

(block_timestamp >= '2024-11-20' AND block_timestamp < '2024-11-27') OR

(block_timestamp >= '2024-11-27' AND block_timestamp < '2024-12-04')

)

GROUP BY

epoch

ORDER BY

epoch