select

proposal_id,

min(block_timestamp) as date_N

from cosmos.core.fact_governance_votes

group by 1 )

, table2 as (

select

date_trunc('week', date_N) as date_N ,

count(*) as count1

from table1

group by 1 )

select

date_N,

sum(count1) over (order by date_N )

from table2