with dates as (
select
proposal,
min(block_timestamp::date) as creation_date
from solana.core.fact_proposal_votes
where governance_platform = 'realms'
group by proposal)
select
count(proposal) as proposals,
date_trunc('day', creation_date) as TIME,
sum(proposals) over (order by TIME) as cummulative_proposals
from dates
group by TIME