ADDRESS | BALANCE | |
|---|---|---|
1 | axelar1m9y9k98vs46jfksu4rdue84uneaj3rzka3amhj | 198500000 |
2 | axelar1ul0d4h9rz8pupxhmzehx2958sawdyve0unv5mk | 50601883 |
3 | axelar1nfn3yuq3vq72asashy6keat9p5glfxv4hf8ke3 | 20000000 |
kamilclAXL 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 axl addresses (depostis to the warm wallet)
-- warm axelar1gl8rsl285qzpr9clnep6u6kyffnnfavc0f5zd5
WITH axl_addresses AS (
SELECT DISTINCT SENDER
FROM axelar.core.fact_transfers
WHERE RECEIVER = 'axelar1gl8rsl285qzpr9clnep6u6kyffnnfavc0f5zd5'
),
transfers_in AS (
SELECT
RECEIVER,
SUM(COALESCE(amount, 0)) AS sum_tin -- Added COALESCE for NULL handling
FROM axelar.core.fact_transfers
WHERE RECEIVER IN (SELECT SENDER FROM axl_addresses)
AND block_timestamp::date > '2024-03-01'
GROUP BY RECEIVER
),
transfers_out AS (
SELECT
SENDER,
SUM(COALESCE(amount, 0)) AS sum_tout -- Added COALESCE for NULL handling
FROM axelar.core.fact_transfers
WHERE SENDER IN (SELECT SENDER FROM axl_addresses)
AND block_timestamp::date > '2024-03-01'
GROUP BY SENDER
)
SELECT
tin.RECEIVER AS address,
sum_tin - COALESCE(sum_tout, 0) AS balance
FROM transfers_in tin
LEFT JOIN transfers_out tout
ON tin.RECEIVER = tout.SENDER
WHERE sum_tin > COALESCE(sum_tout, 0)
Last run: about 1 month ago
3
179B
7s