MLDZMNOGB7
    Updated 2022-11-24
    select
    BLOCK_TIMESTAMP::date as day,
    proposal_id,
    case
    when proposal_id = '362' then 'Proposal no.362'
    else 'Other Proposals'
    end as gp,
    count (distinct tx_id) as votes,
    count (distinct voter) as voters
    from osmosis.core.fact_governance_votes
    where proposal_id::numeric >= '340'
    and tx_status = 'SUCCEEDED'
    group by 1,2,3
    Run a query to Download Data