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

ON