jackguyaxlUSDC Holdings by wallet on Sei copy
Updated 2024-01-30
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 HolderBalances AS (
WITH Inbound AS (
SELECT
RECEIVER AS WALLET,
SUM(AMOUNT) AS INBOUND_AMOUNT
FROM
sei.core.fact_transfers
WHERE
CURRENCY = 'ibc/F082B65C88E4B6D5EF1DB243CDA1D331D002759E938A0F5CD3FFDC5D53B3E349'
AND
TX_SUCCEEDED = true
GROUP BY
RECEIVER
),
Outbound AS (
SELECT
SENDER AS WALLET,
SUM(AMOUNT) AS OUTBOUND_AMOUNT
FROM
sei.core.fact_transfers
WHERE
CURRENCY = 'ibc/F082B65C88E4B6D5EF1DB243CDA1D331D002759E938A0F5CD3FFDC5D53B3E349'
AND
TX_SUCCEEDED = true
GROUP BY
SENDER
)
SELECT
COALESCE(i.WALLET, o.WALLET) AS WALLET1,
(COALESCE(INBOUND_AMOUNT, 0) - COALESCE(OUTBOUND_AMOUNT, 0)) / power(10, 6) AS NET_BALANCE
FROM
Inbound i
FULL OUTER JOIN
Outbound o