SELECT DATE_TRUNC('day', CREATED_AT) AS day, AVG(num_votes_changed) AS avg_votes_changed,

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

and

(a.VALIDATOR ='{{validator_1}}'

or a.VALIDATOR ='{{validator_2}}'

or a.VALIDATOR ='{{validator_3}}')

and

(b.VALIDATOR ='{{validator_1}}'

or b.VALIDATOR ='{{validator_2}}'

or b.VALIDATOR ='{{validator_3}}')

AND a.CREATED_AT >= '{{start_date}}'

AND a.CREATED_AT <= '{{end_date}}'

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

) AS votes_changed

GROUP BY day

ORDER BY day;