select

distinct m.tx_hash

from monad.testnet.fact_event_logs m

join monad.testnet.fact_transactions t

on m.tx_hash = t.tx_hash

-- join private_mint pm

-- on m.origin_from_address = pm.mint_address

where (m.contract_address = '0xe8f0635591190fb626f9d13c49b60626561ed145'

or (m.contract_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701' and m.origin_to_address = '0x224ecb4eae96d31372d1090c3b0233c8310dbbab'))

and m.block_timestamp >= '2025-02-19 16:00:00'

and t.tx_succeeded = TRUE

),

transfers as

select

m.block_timestamp,

m.tx_hash,

m.contract_address AS nft_contract,

m.origin_from_address,

m.origin_to_address,

m.topic_0,

m.topic_1,

m.topic_2,

CASE

when topic_3 = NULL

then 0

else TO_NUMERIC(utils.udf_hex_to_int(topic_3)) -- convert tokenid to numeric

END as token_id,

CASE

when m.contract_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'

then TO_NUMERIC(utils.udf_hex_to_int(REPLACE(m.data, '0x0000000000000000000000000000000000000000000000', ''))) / POWER(10,18) -- make the hex WMON value numeric

else 0

END as data_converted,