SELECT

delegator_address,

MIN(block_timestamp) AS first_stake_date

FROM

axelar.gov.fact_staking

WHERE

action = 'delegate'

AND tx_succeeded = TRUE

GROUP BY

delegator_address

),

weekly_stakes AS (

SELECT

DATE_TRUNC('week', block_timestamp) AS week,

delegator_address,

COUNT(*) AS transactions

FROM

axelar.gov.fact_staking

WHERE

action = 'delegate'

AND tx_succeeded = TRUE

GROUP BY

DATE_TRUNC('week', block_timestamp),

delegator_address

),

staker_status AS (

SELECT

ws.week,

ws.delegator_address,

CASE

WHEN ws.week = DATE_TRUNC('week', fs.first_stake_date) THEN 'New Staker'

ELSE 'Returning Staker'

END AS staker_type,

ws.transactions

FROM