ADDRESS_CALC | NET_BALANCE | |
|---|---|---|
1 | 0x18d336d33a5be54cc62c9034e3a66e3220aa268a | 2.980232239e-8 |
2 | 0x00354d59e829fb79e2ff7d8a022553728520cb6a | 905736947.999999 |
10BlockchainA jetter
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
›
⌄
-- Exemple pour reconstituer net_balance sur ETH
WITH inflows AS (
SELECT
LOWER(to_address) AS addr,
SUM(raw_amount)/1e18 AS sum_in
FROM ethereum.core.fact_token_transfers
WHERE contract_address = LOWER('0x9F0C013016E8656bC256f948CD4B79ab25c7b94D')
GROUP BY 1
),
outflows AS (
SELECT
LOWER(from_address) AS addr,
SUM(raw_amount)/1e18 AS sum_out
FROM ethereum.core.fact_token_transfers
WHERE contract_address = LOWER('0x9F0C013016E8656bC256f948CD4B79ab25c7b94D')
GROUP BY 1
)
SELECT
COALESCE(i.addr, o.addr) AS address_calc,
(COALESCE(i.sum_in,0) - COALESCE(o.sum_out,0)) AS net_balance
FROM inflows i
FULL JOIN outflows o
ON i.addr = o.addr
WHERE COALESCE(i.addr, o.addr) IN (
LOWER('0x00354d59E829fB79e2Ff7D8a022553728520cB6A'), -- L1-Core
LOWER('0x18d336d33a5be54cC62C9034e3a66e3220AA268a'), -- L1-Eco
LOWER('0xfB7e8892fBDa0205f6BbdbCd90dD9b0bDD321D16') -- L1-Rewards
);
Last run: 2 months ago
2
127B
5s