WITH weekly_delegators AS (

SELECT

validator_address,

DATE_TRUNC('week', block_timestamp) AS week_start,

COUNT(DISTINCT delegator_address) AS active_delegators

FROM

sei.gov.fact_staking

WHERE

action = 'delegate'

GROUP BY

validator_address,

DATE_TRUNC('week', block_timestamp)

),

validator_names AS (

SELECT

'seivaloper16znh8ktn33dwnxxc9q0jmxmjf6hsz4tl0s6vxh' AS validator_address, 'Flipside' AS validator_name UNION ALL

SELECT 'seivaloper1wuj3xg3yrw4ryxn9vygwuz0necs4klj7j9nay6', 'Hype Infra' UNION ALL

SELECT 'seivaloper1ummny4p645xraxc4m7nphf7vxawfzt3p5hn47t', 'Everstake' UNION ALL

SELECT 'seivaloper146m089lq8mkqw6w0mmlhxz6247g2taha89at74', 'Rhino' UNION ALL

SELECT 'seivaloper1xm0pjt3qsdlc6u4n7fjpycqd5h7zwla7tz8m37', 'Anchorage Digital' UNION ALL

SELECT 'seivaloper16pj5gljqnqs0ajxakccfjhu05yczp98743ctgy', 'Chorus One' UNION ALL

SELECT 'seivaloper1d3ar2psa9ca55q45jg3q6f3ltmpr0ndqqlty87', 'Sei 1' UNION ALL

SELECT 'seivaloper1xhxnad3c86q3d8ggsyu24j7r0y5k3ef4uhh9e2', 'Sei 0' UNION ALL

SELECT 'seivaloper1vjj609rued3hxztj6gauca3w7fzu96g4yp6y39', 'Open Zeppelin' UNION ALL

SELECT 'seivaloper1w6jrkym8v0nc63kud6erdlt06c2eawhr85hec0', 'Vertex by Sec 3' UNION ALL

SELECT 'seivaloper10c6rrz55ukkaf7rjeerhpxwpqel4tllzs8vgfq', 'Zellic' UNION ALL

SELECT 'seivaloper1s2qd4usk9sfavnlzkyvkq7e7tsds7z8ldvkhca', 'Peckshield' UNION ALL

SELECT 'seivaloper1wwfpmcvehq6yqdxfccs5rdr745q3kmy06l9d0d', 'King Nodes' UNION ALL

SELECT 'seivaloper1y82m5y3wevjneamzg0pmx87dzanyxzht0kepvn', 'Figment' UNION ALL

SELECT 'seivaloper1mpe9rdk7ycujge7r9ncjt4ekamgrdcygvzwqe8', 'Polkachu.com' UNION ALL

SELECT 'seivaloper1mm5p6ak2w94cwry0n42px3ssajgytxnwfvd4w8', 'Crosnet' UNION ALL

SELECT 'seivaloper10plkkmv757pfydyqc97s87zgqt84vry6dx6q9k', 'Staked' UNION ALL

SELECT 'seivaloper18tpdet22kpvswxayekwn55ry0r5acx4kaauupk', 'A41' UNION ALL

SELECT 'seivaloper14u38cl6knqxs6vs7lj7vzfvap42yyc3runtrwc', 'Blockscope.net' UNION ALL