SELECT

ADDRESS AS Validator,

BALANCE,

DATE

FROM near.gov.fact_staking_pool_daily_balances

WHERE DATE >= current_date - 30

),

Total_Stakes AS (

SELECT

DATE,

SUM(BALANCE) AS Total_Stake

FROM near.gov.fact_staking_pool_daily_balances

WHERE DATE >= current_date - 30

GROUP BY DATE

),

Validator_Stakes AS (

SELECT

d.DATE,

d.Validator,

ROUND(d.BALANCE, 2) AS Balance,

ROUND(d.BALANCE / t.Total_Stake * 100, 2) AS Share_Percentage

FROM Daily_Stakes d

JOIN Total_Stakes t

ON d.DATE = t.DATE

),

Ranked_Validators AS (

SELECT

DATE,

Validator,

Balance,

Share_Percentage,

ROW_NUMBER() OVER (PARTITION BY DATE ORDER BY Balance DESC) AS Rank

FROM Validator_Stakes