ADDRESS | BALANCE | |
|---|---|---|
1 | 0x03388458138ddac25a868e3e210e8237aff16b6c | 7.019641 |
2 | 0xac00130d5a896f736d84124261270d8ddb6945ff | 0.1 |
kamilclBase USDT
Updated 2025-03-14
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 eth_addresses AS (
SELECT DISTINCT -- Added DISTINCT to avoid duplicates
d.ADDRESS
FROM ethereum.core.ez_decoded_traces tr
JOIN ethereum.core.dim_contracts d
ON d.CREATED_TX_HASH = tr.TX_HASH
WHERE FROM_ADDRESS = '0xd2c82f2e5fa236e114a81173e375a73664610998'
AND TO_ADDRESS = '0xffa397285ce46fb78c588a9e993286aac68c37cd'
AND TYPE = 'CALL'
AND IDENTIFIER = 'CALL_ORIGIN'
AND TRACE_STATUS = 'SUCCESS'
AND FUNCTION_NAME = 'createForwarder'
),
transfers_in AS (
SELECT
TO_ADDRESS,
SUM(COALESCE(amount, 0)) AS sum_tin -- Added COALESCE for NULL handling
FROM base.core.ez_token_transfers
WHERE TO_ADDRESS IN (SELECT ADDRESS FROM eth_addresses)
AND CONTRACT_ADDRESS = lower('0xfde4C96c8593536E31F229EA8f37b2ADa2699bb2') -- USDT
GROUP BY TO_ADDRESS
),
transfers_out AS (
SELECT
FROM_ADDRESS,
SUM(COALESCE(amount, 0)) AS sum_tout -- Added COALESCE for NULL handling
FROM base.core.ez_token_transfers
WHERE FROM_ADDRESS IN (SELECT ADDRESS FROM eth_addresses)
AND CONTRACT_ADDRESS = lower('0xfde4C96c8593536E31F229EA8f37b2ADa2699bb2') -- USDT
GROUP BY FROM_ADDRESS
)
SELECT
tin.TO_ADDRESS AS address,
Last run: about 1 month ago
2
108B
79s