WITH token_transfers AS (

SELECT

'0x'||SUBSTRING(TOPICS[1], 27) AS sender,

'0x'||SUBSTRING(TOPICS[2], 27) AS receiver,

CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) / 1e18 as amountx

from monad.testnet.fact_event_logs

WHERE

topics[0] = '0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'

and CONTRACT_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'

and TX_SUCCEEDED = 'TRUE'

),

balances AS (

SELECT

receiver AS holder,

SUM(amountx) AS balance

FROM token_transfers

GROUP BY receiver

UNION ALL

SELECT

sender AS holder,

-SUM(amountx) AS balance

FROM token_transfers

GROUP BY sender

),

holds as (SELECT

holder as "Holder",

SUM(balance) as bal

FROM balances