SELECT
MIN(p.block_timestamp) AS date,
p.proposal AS proposal,
SUM(p.vote_weight) AS total_voting_power,
COUNT(DISTINCT p.voter) AS unique_voters
FROM
solana.core.fact_proposal_votes p
WHERE
p.realms_id = 'HgcYAkXFT1ENpUCjBZWc1TjAAFacUwdGZRNhTHx9cuo'
GROUP BY
proposal;