MLDZMNsnap1
    Updated 2023-07-03
    select
    Date_trunc('hour',VOTE_TIMESTAMP) as date,
    Count(*) as "Total votes",
    count(distinct voter) as "voters",
    sum(VOTING_POWER) as "Voting power",
    avg(VOTING_POWER) as "Average voting power",
    median(VOTING_POWER) as "Median voting power",
    sum("voters") over (order by date) as "Total voters",
    sum("Voting power") over (order by date) as "Total voting power"
    from ethereum.core.ez_snapshot
    where NETWORK = 'Avalanche C-Chain'
    and SPACE_ID = 'steakhut.eth'
    and PROPOSAL_TITLE = 'xSTEAK Vesting Schedule'
    group by 1
    order by 1
    Run a query to Download Data