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 = 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8'

AND SUCCEEDED = 'TRUE'

GROUP BY "date", PROPOSAL