DELEGATE | VOTING_POWER | NUMBER_OF_DELEGATORS | TOTAL_VOTING_POWER | TOTAL_DELEGATORS | |
|---|---|---|---|---|---|
1 | 0xe1e7ede7ece5c89ebf7ff74f0e7400cc1900433f | 1008777.68896978 | 1 | 8651998.29960005 | 146 |
2 | 0x157c75f7982cba78096619ef8129bb8533481cf6 | 833307.5431 | 2 | 7643220.61063027 | 145 |
3 | 0x7b5da006d1e4a655f9f7b2001461f2f8adebaba9 | 680417.92954205 | 7 | 6809913.06753027 | 143 |
4 | 0x9669f9fd55cd8bba575b0da8c6478582fefa9352 | 656160.744525512 | 13 | 6129495.13798822 | 136 |
5 | 0x608798e4360fd6e27f5574a0422637026f1335e5 | 589684.888316817 | 14 | 5473334.39346271 | 123 |
6 | 0x5b9708dd3b8644ec4ca206c34af69a4bca560798 | 331855.130902778 | 1 | 4883649.50514589 | 109 |
7 | 0xf02f69b71ca3dc8953d73e6ef91f52742ce45cb2 | 323592.330993981 | 1 | 4551794.37424312 | 108 |
8 | 0x6af30c26ecd6cf5053c980729f96e4891684fb2d | 275291.059837963 | 1 | 4228202.04324914 | 107 |
9 | 0x2b34831a2c48172c9bcfd91cd3b8eb8f9cc0ad68 | 233483.186462892 | 2 | 3952910.98341117 | 106 |
10 | 0x23d731cfbaf141908049b42cf1d33d64b92126d8 | 228730.094562996 | 1 | 3719427.79694828 | 104 |
11 | 0x12f8c380f0e236b5631eb79804c1e4ec8ec57846 | 183882.826960065 | 1 | 3490697.70238528 | 103 |
12 | 0xc1aa2929d75aaa07c1c395c2c50496df550eccf2 | 176752.458530398 | 2 | 3306814.87542522 | 102 |
13 | 0xb47f7765debc32e7eb82abe788150332707c29c2 | 172501.542473386 | 1 | 3130062.41689482 | 100 |
14 | 0x424e606f2e5a43bde549a1ec18dfc441342d0aa0 | 165467.4596885 | 1 | 2957560.87442143 | 99 |
15 | 0x42db45e2af27c05519254d958f3585f52b46ba83 | 150000.215532407 | 1 | 2792093.41473293 | 98 |
16 | 0x9fb61a893a3888cd82aff539781301f296f5cf78 | 141584.535554724 | 1 | 2642093.19920053 | 97 |
17 | 0x5eaf671f5ae1ecd383abd1ea475a70acb003cace | 129600.235949563 | 1 | 2500508.6636458 | 96 |
18 | 0xc2a07fad53f0dfee14ae260c8dacd6519e7b7418 | 128636.125520833 | 1 | 2370908.42769624 | 95 |
19 | 0xa94e497c4d7d59f572e8e27d53916f23635d6acd | 122971.767302694 | 1 | 2242272.30217541 | 94 |
20 | 0x5ed1d20d30e33bad8914f3065c460b58ce4bdabd | 121452.714521272 | 1 | 2119300.53487271 | 93 |
Sandeshvotes_delegated
Updated 2025-02-07
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
›
⌄
⌄
/*
Analyzes delegation patterns and voting power distribution in winvote governance system.
Tracks:
- Vote delegation events and power changes
- Delegation relationships
- Cumulative voting power distribution
- Delegator counts per delegate
*/
-- CTE 1: Capture direct delegate votes changed events
WITH DelegateVotesChanged AS (
SELECT
block_number,
block_timestamp,
tx_hash,
origin_from_address AS user,
decoded_log:"delegate" AS delegate,
decoded_log:"newVotes" AS votes
FROM ethereum.core.ez_decoded_event_logs
WHERE origin_to_address = lower('0xacd2c239012d17beb128b0944d49015104113650')
AND event_name = 'DelegateVotesChanged'
),
-- CTE 2: Capture delegation change events without vote changes
delegate AS (
SELECT
block_number,
block_timestamp,
tx_hash,
origin_from_address AS user,
decoded_log:"toDelegate" AS delegate
FROM ethereum.core.ez_decoded_event_logs
WHERE origin_to_address = lower('0xacd2c239012d17beb128b0944d49015104113650')
AND event_name = 'DelegateChanged'
Last run: 2 months ago
86
7KB
41s