hessVoting Timeline
Updated 2023-05-11
9
1
2
3
4
5
6
›
⌄
select trunc(BLOCK_TIMESTAMP,'week') as date, ACCOUNT_ADDRESS,validator, count(DISTINCT(a.proposal_id)) as total_proposal,
count(DISTINCT(tx_id)) as votes, avg(VOTING_POWER) as avg_power
from osmosis.core.fact_governance_validator_votes a join osmosis.core.fact_validators b on a.validator_address = b.address
join osmosis.core.fact_governance_votes c on b.ACCOUNT_ADDRESS = c.voter
where validator_address in ('{{Validator_1}}','{{Validator_2}}','{{Validator_3}}','{{Validator_4}}')
group by 1,2,3
Run a query to Download Data