NuveveCryptoArchivedFinal Votes On Prop 3619
    Updated 2023-01-24
    with votes as (
    select
    max(block_timestamp) as block_time,
    voter,
    vote_option_text
    from terra.core.fact_governance_votes
    where proposal_id = '3619'
    and tx_succeeded = 'TRUE'
    group by voter, vote_option_text
    )

    select
    vote_option_text as vote_option,
    count(distinct voter) as votes
    from votes
    group by vote_option_text

    Run a query to Download Data