BLOCK_TIMESTAMP,

'0x' || substr(topics[1],27,40) as token0,

'0x' || substr(topics[2],27,40) as token1,

'0x' || substr(data,27,40) as pair_address,

ORIGIN_FROM_ADDRESS,

ORIGIN_TO_ADDRESS,

CONTRACT_ADDRESS,

ORIGIN_FUNCTION_SIGNATURE,

TX_HASH

from blast.core.fact_event_logs

where CONTRACT_ADDRESS IN

('0x44889b52b71e60de6ed7de82e2939fcc52fb2b4e',

'0xb4a7d971d0adea1c73198c97d7ab3f9ce4aafa13')

and topics[0] = '0x0d3648bd0f6ba80134a33ba9275ac585d9d315f0ad8355cddefde31afa28d0e9'

and TX_STATUS = 'SUCCESS'