*,

avg(validator_address) OVER(ORDER BY day

ROWS BETWEEN 7 PRECEDING AND CURRENT ROW )

FROM (

SELECT

date_trunc('day', block_timestamp) as day,

count(DISTINCT raw_metadata[0]['account_address']) as validator_address

FROM osmosis.core.fact_staking

LEFT outer JOIN osmosis.core.dim_labels

ON address = validator_address

GROUP BY 1