kitlunaThe Imperium of Rain/Tracking Realms DAOs
    Updated 2022-08-17
    SELECT
    BLOCK_TIMESTAMP::date AS "date",
    COUNT(DISTINCT VOTER) AS Voters,
    COUNT(DISTINCT TX_ID) AS Votes,
    PROPOSAL
    FROM solana.core.fact_proposal_votes
    WHERE GOVERNANCE_PLATFORM = 'realms'
    AND REALMS_ID = '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn'
    AND SUCCEEDED = 'TRUE'
    GROUP BY "date", PROPOSAL
    Run a query to Download Data