select

BLOCK_TIMESTAMP

,TX_HASH

,from_address

,to_address

,depoist_value

,EVENT_INDEX

,CONTRACT_ADDRESS

from (

select

BLOCK_NUMBER

,BLOCK_TIMESTAMP

,TX_HASH

,EVENT_INDEX

,CONTRACT_ADDRESS

,TOPICS

,'0x' || RIGHT(TOPIC_1, 40) as from_address

,'0x' || RIGHT(TOPIC_2, 40) as to_address

,TOPIC_0

,TOPIC_1

,TOPIC_2

,TOPIC_3

,DATA as block_data

,ORIGIN_FROM_ADDRESS

,ORIGIN_TO_ADDRESS

,ORIGIN_FUNCTION_SIGNATURE

,TX_SUCCEEDED

,TRY_TO_NUMBER(utils.udf_hex_to_int(SUBSTR(LEFT(DATA, 66),3)))/1e18 AS depoist_value

from monad.testnet.fact_event_logs

where CONTRACT_ADDRESS in (lower('0xb2f82D0f38dc453D596Ad40A37799446Cc89274A'),lower('0x08c49b39B1e369f924F6A579Fcbf45765E882454'))

and TX_SUCCEEDED

and TOPICS[0]='0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7'

and BLOCK_TIMESTAMP>='2025-02-18 00:00:00.000'

)

),