AVG(avg_votes_changed) OVER (ORDER BY day ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS day_moving_avg

FROM (

SELECT a.VALIDATOR, a.PROPOSAL_ID, a.CREATED_AT, COUNT(*) AS num_votes_changed

FROM osmosis.core.fact_governance_validator_votes a

LEFT JOIN osmosis.core.fact_governance_validator_votes b ON a.PROPOSAL_ID = b.PROPOSAL_ID AND a.CREATED_AT > b.CREATED_AT AND a.VALIDATOR != b.VALIDATOR

WHERE b.PROPOSAL_ID IS NOT NULL

GROUP BY a.VALIDATOR, a.PROPOSAL_ID, a.CREATED_AT

) AS votes_changed

GROUP BY day

ORDER BY day;