glxyresearchGovernance
Updated 2024-12-17
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
›
⌄
--select count(*) from external.snapshot.ez_snapshot where proposal_id = LOWER('0xa502cf80451192672313911ce558e74799626da3b3b66130e21c6cd19707e584')
select
sum(voting_power) AS ldo_voted,
count(distinct proposal_id) as proposals,
sum(voting_power) / count(distinct proposal_id) as power_per_proposal,
count(distinct voter) as distinct_voters,
count(distinct voter) / count(distinct proposal_id) as avg
FROM
external.snapshot.ez_snapshot
WHERE
proposal_id IN (
LOWER('0xeedef9fea3d782f192410768cabaf6974da40ef36e1d22c7f8fff5fd4cfc7a59'),
LOWER('0x2f745cb0147791cf656ab292f872f8277ff9df5c9585dbc6622dbda88362d402'),
LOWER('0x8fb167fd8b923fb50627d959a603a95135ca05e18da9fd105d17079c14fba702'),
LOWER('0x89bf9f39d623ae2e6d1f876f345f59aaecb2cc4c6eec613e3385a5342dc08fa5'),
LOWER('0x7fd7879a945ebf95709bb0f5d0679370a06d6d0289b832ef8a100f983373e242'),
LOWER('0x7cdf1af7cfeb472ae202c45fb6d7e952bb34bfcbc82113549986b2bc2d5f54c5'),
LOWER('0x2676108832842e60ca27aa7060b9ca6c09c6d2a9fe308b0ee0decc7a6728e137'),
LOWER('0xcfb3473f8b91f368cc90218823d490c2a75ef4849bd76e000941d46b263f129c'),
LOWER('0xac55c2cd8610c3b72cb769cec6b97891b5880f2f1f458eda2eb17218332cef6f'),
LOWER('0xd0d7bfd68f2241524dbb14ae6fe0e8414b9fe3e0dcfc50641a8d28f0067d6693'),
LOWER('0x44bc7db53129ab4048c7f6f5cdc03407ec73444cbb5976c9579cb19bd3b57f7e'),
LOWER('0x185d0f90a82fd60c292bd6af34c136556859cc168b373cdf9c769b26f8e42b7b'),
LOWER('0xa478fa5518769096eda2b7403a1d4104ca47de3102e8a9abab8640ef1b50650c'),
LOWER('0xd8222e979e92ef049b7f0a1984192781b065b24b6dc82aa9f889cbb2308fae5a'),
LOWER('0x6bc51c2b07a9345a03a0bc0acb72ccc9f63879c981f3a6954164d110c5d330b2'),
LOWER('0xcc52cdc83273b42a056cfc632889355595821a2cc9a59ba8adff66b30e9718f9'),
LOWER('0x5667528b50af1668ea246bde5bbf136f202629dee50747bbcc0839f48bf396b1'),
LOWER('0xffb4042d3bfceef33c66f78c092a76fa8e1db198559d93798cc9db3fb4d722e7'),
LOWER('0xa502cf80451192672313911ce558e74799626da3b3b66130e21c6cd19707e584'),
LOWER('0x6e8abf874e9d4e9aab0f0311c251f36c685fd53f3f214d66884e30fa2bfce61c'),
LOWER('0xdfb6a16a991379cd62222bb20792db7ce1dc0e2a0db17e8d7422717802f50145'),
LOWER('0x93e5ae25e42308ba73f4010366e78e37eadbba16ed41c853f9f99c2006de64e4'),
LOWER('0x2baf3275d15a8494ff94fef58d93bedd2fc28bfea8519f7e86474fc72dc25076'),
LOWER('0xb1a3c33a4911712770c351504bac0499611ceb0faff248eacb1e96354f8e21e8'),
QueryRunArchived: QueryRun has been archived