count(distinct voter) as members,

date_trunc('day', block_timestamp::date) as TIME,

sum(members) over (order by TIME) as cumulative_members

from solana.core.fact_proposal_votes

where governance_platform = 'realms'

group by TIME