adambalaSnapshot
Updated 2023-04-13Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
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