adambalaSnapshot
    Updated 2023-04-13
    with raw as (
    select VOTER ,PROPOSAL_START_TIME ,PROPOSAL_ID ,ID
    from ethereum.core.ez_snapshot
    where SPACE_ID = 'ocm.eth'

    )

    , first_votes as (
    SELECT VOTER, MIN(PROPOSAL_START_TIME) as first_vote
    FROM raw
    GROUP BY 1
    )
    SELECT first_vote, COUNT(DISTINCT VOTER) as daily_new_voter,
    SUM(daily_new_voter) OVER (ORDER BY first_vote ASC) as total_new_voter
    FROM first_votes
    GROUP BY 1
    ORDER BY 1 DESC

    Run a query to Download Data