sinahosseinzadehUntitled Query
    Updated 2022-08-31
    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