SELECT

tx_hash,

ORIGIN_FUNCTION_SIGNATURE

from monad.testnet.fact_event_logs

where TX_SUCCEEDED

-- and ORIGIN_FUNCTION_SIGNATURE = '0xd5575982'

-- and ORIGIN_TO_ADDRESS = '0x2c9c959516e9aaedb2c748224a41249202ca8be7'

and CONTRACT_ADDRESS = '0x2c9c959516e9aaedb2c748224a41249202ca8be7'

-- and tx_hash='0xc6e725af3da23a9d76daf6d14fb017dc6b527d27e651e20a5f35bcdb818171d3'

group by 1,2

),

lst_deposit_action_dim as

select

BLOCK_TIMESTAMP

,FROM_ADDRESS

,TO_ADDRESS

,tx_hash

,value as stake_amount

from monad.testnet.fact_traces

where tx_hash in (select tx_hash from stake_event_logs_dim where ORIGIN_FUNCTION_SIGNATURE='0xd5575982')

and TO_ADDRESS='0x2c9c959516e9aaedb2c748224a41249202ca8be7'

and value>0

),

lst_redeem_action_dim as

select

BLOCK_TIMESTAMP

,FROM_ADDRESS

,TO_ADDRESS