rahoUntitled Query
Updated 2022-10-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with ss_ss as (
select
date(proposal_end_time) as "date",
proposal_title,
proposal_id,
voter,
vote_option,
voting_power,
choices,
space_id
from ethereum.core.ez_snapshot
where space_id = 'sushigov.eth'
),
group_proposals as (
select
"date" as end_date,
proposal_title,
voter,
voting_power
from ss_ss
group by 1, 2, 3, 4
),
total_nums as (
select
end_date,
count(voter) as total_voters,
sum(all voting_power) as total_vp,
proposal_title
from group_proposals
group by 1, 4
),
vclose as (
select
Run a query to Download Data