time,

space_id,

sum(unique_voters) over (ORDER BY time RANGE UNBOUNDED PRECEDING) as cumulative_voters,

sum(unique_proposals) over (ORDER BY time RANGE UNBOUNDED PRECEDING) as cumulative_proposals

from (

select

date_trunc('day', vote_timestamp) as time,

space_id,

count(distinct voter) as unique_voters,

count(distinct proposal_id) as unique_proposals

from ethereum.core.ez_snapshot

group by 1,2

) a