No Data to Display
kamilclBCUT MD
Updated 2025-03-26
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
›
⌄
--get list of BCUT addresses (depostis to the warm wallet)
-- warm 0xc2ec978a6b2bcff1c31e0d3a7a37493c7df7b8b0
WITH bcut_addresses AS (
SELECT DISTINCT FROM_ADDRESS
FROM polygon.core.ez_token_transfers
WHERE TO_ADDRESS = '0xc2ec978a6b2bcff1c31e0d3a7a37493c7df7b8b0'
AND contract_address = lower('0x3fb83A9A2c4408909c058b0BfE5B4823f54fAfE2')
AND block_timestamp::date >= '2025-03-13' --polygon gas tank is a contract creator, can try to get more addresses using it 0x6931ca47238dbae78489fa02cbfe666405173cfe
),
transfers_in AS (
SELECT
TO_ADDRESS,
SUM(COALESCE(amount, 0)) AS sum_tin -- Added COALESCE for NULL handling
FROM polygon.core.ez_token_transfers
WHERE TO_ADDRESS IN (SELECT FROM_ADDRESS FROM bcut_addresses)
AND contract_address = lower('0x3fb83a9a2c4408909c058b0bfe5b4823f54fafe2')
AND block_timestamp::date >= '2025-03-13'
GROUP BY TO_ADDRESS
),
transfers_out AS (
SELECT
FROM_ADDRESS ,
SUM(COALESCE(amount, 0)) AS sum_tout -- Added COALESCE for NULL handling
FROM polygon.core.ez_token_transfers
WHERE FROM_ADDRESS IN (SELECT FROM_ADDRESS FROM bcut_addresses)
AND contract_address = lower('0x3fb83a9a2c4408909c058b0bfe5b4823f54fafe2')
AND block_timestamp::date >= '2025-03-13'
GROUP BY FROM_ADDRESS
)
SELECT
tin.TO_ADDRESS AS address,
sum_tin - COALESCE(sum_tout, 0) AS balance
Last run: about 1 month ago
0
2B
3s