SELECT

delegator_address,

SUM(CASE WHEN action = 'delegate' THEN amount / 1000000 ELSE 0 END) -

SUM(CASE WHEN action = 'undelegate' THEN amount / 1000000 ELSE 0 END) AS active_staked,

DATE_TRUNC('week', block_timestamp) AS week

FROM sei.gov.fact_staking

GROUP BY delegator_address, DATE_TRUNC('week', block_timestamp)

HAVING active_staked > 1

SELECT

ad.week,

COUNT(DISTINCT ad.delegator_address) AS "Weekly Active Delegators",

SUM(ad.active_staked) AS "Weekly Volume Staked (SEI)",

SUM(SUM(ad.active_staked)) OVER (ORDER BY ad.week) AS "Cumulative Volume Staked (SEI)"

FROM active_delegators ad

GROUP BY ad.week

ORDER BY ad.week;