kingharald-ethRealms Information
    Updated 2022-09-01
    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