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