select date_trunc('month', block_timestamp) as month,
count(distinct(voter)) as total_users,
count(distinct(tx_id)) as total_votes,
count(distinct(voter)) as total_voters,
count(distinct(proposal)) as total_proposals,
count(distinct(program_name)) as total_daos
from solana.core.fact_proposal_votes
where governance_platform = 'realms'
group by month
order by month