kamilclAVAX USDT
Updated 2025-02-11
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 avalanche.core.ez_token_transfers
WHERE TO_ADDRESS IN (SELECT ADDRESS FROM eth_addresses)
AND CONTRACT_ADDRESS = lower('0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7') -- USDT
GROUP BY TO_ADDRESS
),
transfers_out AS (
SELECT
FROM_ADDRESS,
SUM(COALESCE(amount, 0)) AS sum_tout -- Added COALESCE for NULL handling
FROM avalanche.core.ez_token_transfers
WHERE FROM_ADDRESS IN (SELECT ADDRESS FROM eth_addresses)
AND CONTRACT_ADDRESS = lower('0x9702230a8ea53601f5cd2dc00fdbc13d4df4a8c7') -- USDT
GROUP BY FROM_ADDRESS
)
SELECT
tin.TO_ADDRESS AS address,
QueryRunArchived: QueryRun has been archived