t1 as (

select

proposal_id

from terra.core.fact_governance_votes

where proposal_id >= 3619

),

t2 as (

select

proposal_id,

tx_id

from terra.core.fact_governance_submit_proposal

where proposal_id in (select proposal_id from t1)

),

t3 as (

select

proposal_id,

a.message_value:content:title as title,

a.message_value:content:description as description

from t2

join terra.core.ez_messages a

using(tx_id)

select

block_timestamp::date as day,

concat(title, ' (Id: ', proposal_id, ')') as proposal,

count(distinct tx_id) as votes_count,

count(distinct voter) as voters_count,

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

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

from terra.core.fact_governance_votes

join t3

using (proposal_id)