adriaparcerisasosmoval1
Updated 2023-05-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- 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