moonshot21Total ezEIGEN and eEIGEN
Updated 2024-11-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
WITH SUPPLY_ezEIGEN AS (
SELECT
SUM(CURRENT_BAL) AS SUPPLY_ezEIGEN
FROM ethereum.core.ez_current_balances
WHERE CONTRACT_ADDRESS = LOWER('0xd4fcde9bb1d746Dd7e5463b01Dd819EE06aF25db')
),
SUPPLY_eEIGEN AS (
SELECT
SUM(CURRENT_BAL) AS SUPPLY_eEIGEN
FROM ethereum.core.ez_current_balances
WHERE CONTRACT_ADDRESS = LOWER('0xE77076518A813616315EaAba6cA8e595E845EeE9')
)
SELECT
SUPPLY_ezEIGEN.SUPPLY_ezEIGEN,
SUPPLY_eEIGEN.SUPPLY_eEIGEN,
(SUPPLY_ezEIGEN.SUPPLY_ezEIGEN + SUPPLY_eEIGEN.SUPPLY_eEIGEN) AS TOTAL_SUPPLY
FROM SUPPLY_ezEIGEN, SUPPLY_eEIGEN;
QueryRunArchived: QueryRun has been archived