flipside

    Voting Overview
    hessVoting Overview
    Updated 2023-01-26
    with final as ( select voter, count(DISTINCT(tx_id)) as total_vote, count(DISTINCT(proposal_id)) as total_proposal, sum(VOTE_WEIGHT) as vote_power
    from terra.core.fact_governance_votes
    where TX_SUCCEEDED = 'TRUE'
    group by 1)

    select count(DISTINCT(voter)) as total_voter, sum(total_vote) as votes, sum(total_proposal) as total_pros,sum(vote_power) as total_power,
    avg(total_vote) as avg_vote_per_user
    from final
    Run a query to Download Data