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 = '0xe1d2439b75fb9746e7bc6cb777ae10aa7f7ef9c5'

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

SELECT

holder as "Holder",

TO_VARCHAR(SUM(balance) , '999,999,999,999.00')

AS "Current Balance",

FROM balances

GROUP BY all