(SELECT

a.BLOCK_TIMESTAMP,

a.ORIGIN_FROM_ADDRESS,

CAST(ethereum.public.udf_hex_to_int(data) AS NUMERIC) / 1e18 AS amount,

a.tx_hash,

a.ORIGIN_FUNCTION_SIGNATURE

from monad.testnet.fact_event_logs a

where

a.TX_SUCCEEDED = 'TRUE'

and ORIGIN_FUNCTION_SIGNATURE in ('0xd0e30db0','0x2e1a7d4d')

and a.ORIGIN_TO_ADDRESS = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'

and a.CONTRACT_ADDRESS = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701')

select

date_trunc('day',block_timestamp) as date,

count(distinct tx_hash) as transactions,

sum(amount) as "WMON",

case

when ORIGIN_FUNCTION_SIGNATURE = '0xd0e30db0' then 'wrapped'

when ORIGIN_FUNCTION_SIGNATURE = '0x2e1a7d4d' then 'unwrapped'

end as action

from actions

where block_timestamp::date >= '2025-02-19 04:00:00'

group by all