SELECT

BLOCK_TIMESTAMP,

ORIGIN_FROM_ADDRESS,

tx_hash,

data,

ORIGIN_FUNCTION_SIGNATURE

from monad.testnet.fact_event_logs

where ORIGIN_FUNCTION_SIGNATURE in ('0x3a4b66f1','0x30af6b2e')

and TX_SUCCEEDED = 'TRUE'

and CONTRACT_ADDRESS = '0x07aabd925866e8353407e67c1d157836f7ad923e'

),

lst_deposit_action_dim as

select

BLOCK_TIMESTAMP

,tx_hash

,value as stake_amount

from monad.testnet.fact_traces

where tx_hash in (select tx_hash from event_logs_dim group by 1)

and ORIGIN_FUNCTION_SIGNATURE='0x3a4b66f1'

and value>0

),

lst_redeem_action_dim as

select

BLOCK_TIMESTAMP

,tx_hash

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

from event_logs_dim

where ORIGIN_FUNCTION_SIGNATURE='0x30af6b2e'