SELECT

'realms' AS platform,

date_trunc('week', BLOCK_TIMESTAMP) as day,

count(DISTINCT voter) as voters,

count(*) as votes,

COUNT(DISTINCT PROPOSAL) as proposals

FROM solana.core.fact_proposal_votes

where GOVERNANCE_PLATFORM='realms'

GROUP BY 1,2