select block_timestamp::date as day,
count(distinct(voter)) as count_of_voters,
count(distinct(tx_id)) as count_of_vote,
count(distinct(proposal)) as count_of_proposal
from solana.core.fact_proposal_votes
where succeeded = 'TRUE' and realms_id ilike '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn'
and governance_platform = 'realms' group by 1