COUNT (DISTINCT proposal) as proposal_count,

date_trunc(week, block_timestamp) as date

From solana.core.fact_proposal_votes

where governance_platform ='realms'

AND succeeded='TRUE'

group by date

order by date