select

BLOCK_TIMESTAMP

,TX_HASH

,from_address

,to_address

,transfer_value/1e18 as transfer_value

,EVENT_INDEX

,CONTRACT_ADDRESS

from

(

select

BLOCK_NUMBER

,BLOCK_TIMESTAMP

,TX_HASH

,EVENT_INDEX

,CONTRACT_ADDRESS

,TOPICS

,'0x' || RIGHT(TOPICS[1], 40) as from_address

,'0x' || RIGHT(TOPICS[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(DATA, 3))) AS transfer_value

from monad.testnet.fact_event_logs

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

and TX_SUCCEEDED

-- and TX_HASH='0x11376bfba87753d01faa55b94da60c098cb8353dc050e7474f3f1c8061282d6d'

and TOPICS[0]='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'