mucrypto2023-07-19 07:51 PM
Updated 2023-07-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select
date_trunc('month', proposal_start_time) as month,
count(voter) as votes,
-- sum(voter) as s_votes,
sum(votes) over (order by month asc) as c_votes
from ethereum.core.ez_snapshot
where space_id = 'gal.eth'
or space_id = 'project-galaxy.eth'
group by 1
-- select *
-- -- distinct proposal_title,
-- -- proposal_start_time
-- from ethereum.core.ez_snapshot
-- -- where space_id = 'gal.eth'
-- -- or space_id = 'project-galaxy.eth'
-- where proposal_title = '[Test] Project Galaxy Plugin'
-- or proposal_title = '[Test]: Project Galaxy Plugin'
Run a query to Download Data