winnie-fs🧈x👻 Snapshot candidate distribution copy
Updated 2023-04-11
999
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
›
⌄
-- forked from lajarre / 🧈x👻 Snapshot candidate distribution @ https://staging.flipsidecrypto.xyz/lajarre/q/🧈-x-👻-snapshot-voter-distribution-LJQjX6
with
candidate (number, name) as (
select
*
FROM
VALUES
(1, 'Blockworks Research'),
(2, 'ConsenSys'),
(3, 'Curia'),
(4, 'DAOStewards'),
(5, 'Fire Eyes'),
(6, 'Flipside Crypto'),
(7, 'FranklinDAO'),
(8, 'OnChainCoop'),
(9, 'Oxytocin'),
(10, 'Saludiego201.eth'),
(11, 'StableLab'),
(12, 'TokenLogic'),
(13, 'Wallfacer Labs')
),
vote as (
with
ranked_vote as (
select
proposal_author,
quorum,
vote_option,
vote_timestamp,
voter,
voting_period,
voting_power,
voting_type,
row_number() over (
partition by
Run a query to Download Data