DATE_TRUNC('week', block_timestamp) AS "week",

COUNT(DISTINCT CASE WHEN action = 'delegate' THEN tx_id END) AS "Total Stakes",

COUNT(DISTINCT CASE WHEN action = 'undelegate' THEN tx_id END) AS "Total unstakes",

COUNT(DISTINCT CASE WHEN action = 'redelegate' THEN tx_id END) AS "Total restakes",

COUNT(DISTINCT delegator_address) AS "Total delegators",

COUNT(DISTINCT validator_address) AS "Total validators",

SUM(CASE WHEN action = 'delegate' THEN amount ELSE 0 END) / POWER(10, 6) AS "Staked Volume in SEI",

SUM(CASE WHEN action = 'redelegate' THEN amount ELSE 0 END) / POWER(10, 6) AS "Restaked Volume in SEI",

SUM(CASE WHEN action = 'undelegate' THEN amount ELSE 0 END) / POWER(10, 6) AS "Unstaked Volume in SEI"

FROM

sei.gov.fact_staking

GROUP BY

"week"

ORDER BY

"week";