Updated 2023-05-10
    -- calculate total number of proposals voted on by each validator during the selected time period
    SELECT
    v.VALIDATOR,
    COUNT(DISTINCT v.PROPOSAL_ID) AS TOTAL_PROPOSALS_VOTED_ON
    FROM osmosis.core.fact_governance_validator_votes v
    WHERE
    (v.VALIDATOR ='{{validator_1}}'
    or v.VALIDATOR ='{{validator_2}}'
    or v.VALIDATOR ='{{validator_3}}')
    AND v.CREATED_AT >= '{{start_date}}'
    AND v.CREATED_AT <= '{{end_date}}'
    GROUP BY
    1
    Run a query to Download Data