SELECT DATE '2024-11-06' AS epoch_start, DATE '2024-11-13' AS epoch_end

UNION ALL

SELECT DATE '2024-11-13', DATE '2024-11-20'

UNION ALL

SELECT DATE '2024-11-20', DATE '2024-11-27'

UNION ALL

SELECT DATE '2024-11-27', DATE '2024-12-04'

),

epoch_data AS (

SELECT

a.node_id,

a.delegator_id

FROM

flow.gov.ez_staking_actions a

JOIN

epoch_boundaries eb

ON

a.block_timestamp >= eb.epoch_start

AND a.block_timestamp < eb.epoch_end

WHERE

a.tx_succeeded = TRUE

AND a.action IN ('TokensCommitted', 'DelegatorTokensCommitted', 'TokensStaked')

),

categorized_data AS (

SELECT

ed.node_id,

ed.delegator_id,

l.project_name

FROM

epoch_data ed

JOIN

flow.gov.dim_validator_labels l

ON

ed.node_id = l.node_id