MLDZMNsnap1
Updated 2023-07-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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