INFO | CATEGORY | TOTAL_L1 | TOTAL_L2 | TOTAL_L1_L2 | |
|---|---|---|---|---|---|
1 | Overall Supply | 991958987.061437 | 4008041010.93857 | 4999999998.00001 | |
2 | Distribution by Category | UNCLASSIFIED | 86222039.061437 | 4008041010.93857 | 4094263050 |
3 | Distribution by Category | Mantle Treasury | 905736948 | 0 | 905736948 |
10Blockchainliberal-azure
Updated 2025-02-27
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
›
⌄
⌄
WITH address_categories AS (
/* Exemples de classification :
- Mantle Treasury
- Core Contributor
- Community
- etc.
*/
SELECT LOWER('0x00354d59E829fB79e2Ff7D8a022553728520cB6A') AS addr, 'Mantle Treasury' AS category
UNION ALL
SELECT LOWER('0x18d336d33a5be54cC62C9034e3a66e3220AA268a'), 'Mantle Treasury'
UNION ALL
SELECT LOWER('0xfB7e8892fBDa0205f6BbdbCd90dD9b0bDD321D16'), 'Mantle Treasury'
/* ... plus d'adresses ici si besoin */
UNION ALL
SELECT LOWER('0xabc...'), 'Core Contributor'
/* etc. */
),
/* 1) L1 excluding adapter */
l1_excluding_adapter AS (
SELECT
f.user_address,
f.balance,
ROW_NUMBER() OVER(
PARTITION BY f.user_address
ORDER BY f.block_timestamp DESC
) AS rn
FROM ethereum.core.fact_token_balances f
WHERE f.contract_address = LOWER('0x9F0C013016E8656bC256f948CD4B79ab25c7b94D')
AND LOWER(f.user_address) <> LOWER('0xC14459931cF666DCcAd582D63288AefB9f0bDca9')
),
/* 2) Snapshot final L1 */
l1_snapshot_final AS (
SELECT
LOWER(l.user_address) AS addr,
Last run: about 1 month ago
3
231B
9s