block_timestamp::date as day,

proposal_id,

count(distinct tx_id) as votes_count,

count(distinct voter) as voters_count,

sum(votes_count) over (order by day) as cumulative_votes_count,

sum(voters_count) over (order by day) as cumulative_voters_count

from terra.core.fact_governance_votes

where proposal_id >= 3619

group by day, proposal_id

order by day, proposal_id