METRIC_NAME | METRIC_VALUE | |
|---|---|---|
1 | CIRCULATING_SUPPLY_EST | -14690655535 |
2 | LOCKED_SUPPLY_ETH_GATEWAY | |
3 | TOTAL_MINTED_ON_L2 | -3.67364631e-7 |
4 | TOTAL_SUPPLY | 5000000000 |
5 | TREASURY_BALANCE_L1 | 17822790436 |
6 | TREASURY_BALANCE_L2 | 1867865099 |
10BlockchainRequête SQL : Union de plusieurs CTE
Updated 2025-02-25
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
›
⌄
-- Exemple de requête pour récupérer :
-- 1) TOTAL_SUPPLY (valeur fixe)
-- 2) LOCKED_SUPPLY_ETH_GATEWAY
-- 3) TREASURY_BALANCE_L1 (Core/Eco/Rewards)
-- 4) TREASURY_BALANCE_L2 (Core/Eco/Contributor)
-- 5) TOTAL_MINTED_ON_L2
-- 6) CIRCULATING_SUPPLY_EST = total_supply - locked - treasury(L1+L2), etc.
WITH
------------------------------------------------------------------------
-- (A) TOTAL_SUPPLY (valeur fixe du whitepaper = 5,000,000,000)
------------------------------------------------------------------------
cte_total_supply AS (
SELECT
5000000000::NUMERIC AS total_supply
),
------------------------------------------------------------------------
-- (B) LOCKED_SUPPLY_ETH_GATEWAY : Tokens bloqués sur Gateway (Ethereum)
-- REMPLACEZ PAR LA VRAIE ADRESSE DU CONTRAT GATEWAY L1
------------------------------------------------------------------------
cte_locked_gateway AS (
SELECT
SUM(balance) / 1e18 AS locked_supply
FROM ethereum.core.fact_token_balances
WHERE contract_address = LOWER('0x9F0C013016E8656bC256f948CD4B79ab25c7b94D')
AND user_address = LOWER('0x1111111111111111111111111111111111111111') -- <== EXEMPLE GATEWAY
),
------------------------------------------------------------------------
-- (C) TREASURY_BALANCE_L1 : Somme des soldes sur ETH (Core/Eco/Rewards)
-- (selon vos 3 adresses L1 : MPTreasuryL1-Core, -Eco, -Rewards)
------------------------------------------------------------------------
cte_treasury_l1 AS (
SELECT
SUM(balance)/1e18 AS treasury_balance_l1
Last run: 2 months ago
6
213B
7s