rajsrealms
    Updated 2022-08-30
    SELECT
    proposal,
    count(distinct tx_id) as no_of_votes,
    count(distinct voter) as no_of_voters
    -- count(distinct proposal) as no_of_proposals,
    -- count(distinct realms_id) as no_of_daos
    from solana.core.fact_proposal_votes
    where governance_platform = 'realms'
    and succeeded
    and block_timestamp >= '2022-01-01'
    group by 1
    order by 2 desc
    Run a query to Download Data