SELECT

Delegator_id

MIN(block_timestamp) AS first_delegation_date,

SUM(amount) AS initial_staked_amount

FROM

flow.gov.ez_staking_actions

WHERE

action = 'DelegatorTokensCommitted'

GROUP BY

delegator_id

),

new_delegators AS (

SELECT

DATE_TRUNC('day', first_delegation_date) AS date,

COUNT(delegator_id) AS new_delegators,

SUM(initial_staked_amount) AS new_delegators_staked_amount

FROM

first_delegations

GROUP BY

DATE_TRUNC('day', first_delegation_date)

),

delegations AS (

SELECT

delegator_id,

DATE_TRUNC('day', block_timestamp) AS delegation_date,

amount,

ROW_NUMBER() OVER (PARTITION BY delegator_id ORDER BY block_timestamp) AS delegation_rank

FROM

flow.gov.ez_staking_actions

WHERE

action = 'DelegatorTokensCommitted'

),

returning_delegators AS (

SELECT