Legend Label | Distribution Range | Number of Delegates | Cumulative Delegated Tokens | Voting Power (%) | |
|---|---|---|---|---|---|
1 | Mega Whale (10M+) – 17 delegates | Mega Whale (10M+) | 17 | 317028370.810679 | 96.338654465071 |
2 | Huge (100K-10M) – 10 delegates | Huge (100K-10M) | 10 | 12020276.892685 | 3.652724515404 |
3 | Large (1K-100K) – 1 delegates | Large (1K-100K) | 1 | 15966.03835 | 0.004851763417 |
4 | Small (10-100) – 423 delegates | Small (10-100) | 423 | 8239.117907 | 0.00250370505 |
5 | Medium (100-1K) – 14 delegates | Medium (100-1K) | 14 | 3440.370596 | 0.00104546061 |
6 | Tiny (<10 COOK) – 1200 delegates | Tiny (<10 COOK) | 1200 | 724.267078 | 0.000220090447 |
10BlockchainPouvoir de vote
Updated 2025-02-25
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 raw_votes AS (
/* 1) Grab the latest newBalance value for each delegate */
SELECT
(decoded_log:delegate)::string AS delegate,
CAST((decoded_log:newBalance)::string AS NUMERIC)/1e18 AS new_votes_token,
block_timestamp,
ROW_NUMBER() OVER (
PARTITION BY (decoded_log:delegate)::string
ORDER BY block_timestamp DESC
) AS rn
FROM ethereum.core.ez_decoded_event_logs
WHERE contract_address = LOWER('0x3c3a81e81dc49a522a592e7622a7e711c06bf354')
AND event_name = 'DelegateVotesChanged'
),
latest_vote AS (
/* 2) Keep only the most recent occurrence (rn=1) */
SELECT
delegate,
new_votes_token
FROM raw_votes
WHERE rn = 1
),
/* 3) Bin the delegates into ranges. */
binned AS (
SELECT
CASE
WHEN new_votes_token < 10 THEN 'Tiny (<10 COOK)'
WHEN new_votes_token < 100 THEN 'Small (10-100)'
WHEN new_votes_token < 1e3 THEN 'Medium (100-1K)'
WHEN new_votes_token < 1e5 THEN 'Large (1K-100K)'
WHEN new_votes_token < 1e7 THEN 'Huge (100K-10M)'
ELSE 'Mega Whale (10M+)'
END AS distribution_range,
COUNT(*) AS delegates_count,
SUM(new_votes_token) AS total_delegated
Last run: 2 months ago
6
524B
20s