MeirStakeDAO Snapshot
Updated 2024-04-17
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
›
⌄
SELECT
PROPOSAL_ID,
PROPOSAL_START_TIME,
PROPOSAL_END_TIME,
PROPOSAL_TITLE,
PROPOSAL_AUTHOR,
VOTE_OPTION,
VOTING_POWER,
VOTE_TIMESTAMP,
QUORUM,
CHOICES,
VOTING_PERIOD,
NETWORK,
SPACE_ID,
VOTER,
ADDRESS_NAME,
LABEL_TYPE,
LABEL_SUBTYPE,
LABEL
FROM external.snapshot.ez_snapshot as SNAPSHOT
LEFT JOIN ethereum.core.dim_labels LABELS
ON SNAPSHOT.VOTER = LABELS.ADDRESS
WHERE SPACE_ID = 'sdcrv.eth'
-- AND PROPOSAL_TITLE LIKE 'Gauge Weight%'
AND VOTE_TIMESTAMP > '2022-12-20 00:00:00.000'
LIMIT 10000
QueryRunArchived: QueryRun has been archived