DATASET | ADDRESS_OR_LABEL | NEW_VOTES_TOKEN | PCT_SHARE | |
|---|---|---|---|---|
1 | STATS | TOTAL_VOTE_WEIGHT | 329076994.143704 | |
2 | STATS | NB_DELEGATES | 1665 | |
3 | PIE | 0x09da12f0977ed3534124a4f593d9c1a243bea598 | 25001124.5914 | 7.597344637074 |
4 | PIE | 0xbc66065e9640df94338c6956297ca90ec116651d | 25000126.983063 | 7.597041483737 |
5 | PIE | 0x8c1b9df70e6cf13f8387dc2870afb3c7091f3ad5 | 25000038.1 | 7.597014473942 |
6 | PIE | 0xf23d8514b671262ac91a9f46b97901fa8833ab73 | 25000030.891243 | 7.597012283344 |
7 | PIE | 0xb3a3db8885c6c02afc412222010f698788b4a203 | 25000020.47961 | 7.597009119456 |
8 | PIE | 0x7705d8798a8f2069c966c85ede7588c4c9340349 | 25000001.1 | 7.597003230378 |
9 | PIE | 0x75c53632fb3ed2d97f4427df9b14e844ce9b6520 | 25000000 | 7.59700289611 |
10 | PIE | 0xf87095925339f7ffdde266258f62947567de6aeb | 20000000.1 | 6.077602347276 |
11 | PIE | 0xdc026e9f31239c30ee58c29ab98b36259e33832e | 15026904.26134 | 4.566377407718 |
12 | PIE | 0x9e2d6306fcb916b52c90d7d4a8dd13b088c517f4 | 15000105.26489 | 4.558233725573 |
13 | PIE | 0x49750bf362dcb896235b5f0f8ac3df07989b7a00 | 15000018.439133 | 4.558207340952 |
14 | PIE | 0x0fc50e81b946e80916fc9981e53f9e1c3c3d0eae | 15000000.1 | 4.558201768054 |
15 | PIE | 0xa06458989bb415b51a56323fddcfc199af954609 | 15000000.1 | 4.558201768054 |
16 | PIE | 0x4b7e4f0effc2436b91bcb680fa36b91cc11df5f9 | 15000000 | 4.558201737666 |
17 | PIE | 0x1cc1eb810bcba8d623f42432b7c7dfcf0ae3e2c5 | 12000000.2 | 3.646561450909 |
18 | PIE | 0xdb5afaef93662e01ec9555961df85268a57d0279 | 10000000.1 | 3.038801188832 |
19 | PIE | 0xa1d7f2d5a89772de29824250f96df64558fcfc36 | 10000000.1 | 3.038801188832 |
20 | PIE | 0xbaa80e00fe979660be08f5b18c8d18879238f162 | 3000001.4372 | 0.91164078427 |
10BlockchainRequête de base : Distribution du Vote Weight (L1)
Updated 2025-02-27
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_events AS (
SELECT
block_timestamp,
(decoded_log:delegate)::string AS delegate,
CAST((decoded_log:newBalance)::string AS NUMERIC)/1e18 AS new_votes_token
FROM ethereum.core.ez_decoded_event_logs
WHERE contract_address = LOWER('0x3c3a81e81dc49a522a592e7622a7e711c06bf354')
AND event_name = 'DelegateVotesChanged'
),
---------------------------------------------------------------------
-- RANK: on garde la plus récente occurrence pour chaque delegate
---------------------------------------------------------------------
ranked AS (
SELECT
delegate,
new_votes_token,
block_timestamp,
ROW_NUMBER() OVER (
PARTITION BY delegate
ORDER BY block_timestamp DESC
) AS rn
FROM raw_events
),
latest_votes AS (
SELECT
delegate,
new_votes_token
FROM ranked
WHERE rn = 1
),
---------------------------------------------------------------------
-- STATS: calcul big numbers (ex. total votes, nb delegates)
---------------------------------------------------------------------
stats AS (
SELECT
COUNT(*) AS nb_delegates,
Last run: about 2 months ago
...
300
22KB
19s