sinahosseinzadehUntitled Query
Updated 2022-08-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
date(VOTE_TIMESTAMP) as days,
NETWORK,
SPACE_ID,
PROPOSAL_TITLE,
count(distinct PROPOSAL_ID) as proposals,
count(distinct VOTER) as voters,
count(distinct id) as votes,
sum(votes)over(order by days)as votes_growth,
votes/voters as votes_per_voter
from ethereum.core.ez_snapshot
where days >= CURRENT_DATE-75 and days < CURRENT_DATE
and network is not null
group by 1,2,3,4
Run a query to Download Data