with

raw as (

select

VOTER ,

PROPOSAL_START_TIME ,

PROPOSAL_ID ,

ID

from external.snapshot.ez_snapshot

where SPACE_ID = 'toshibase.eth'

SELECT

PROPOSAL_START_TIME as "Date",

COUNT(DISTINCT id) as "Votes",

SUM("Votes") OVER (ORDER BY "Date" ASC) as "Total Votes"

FROM raw

GROUP BY 1

ORDER BY 1 DESC