count(DISTINCT tx_id) as total_vote,

date_trunc(month, block_timestamp) as date

from solana.core.fact_proposal_votes

where governance_platform='realms'

AND succeeded='TRUE'

group by date