where 1=1

and block_timestamp >= current_date() - interval ' 7 days'

and contract_address ='0x7a233f0e957a9ff4726c738e9d790b9956f4c894'

and tx_hash not in

select tx_hash FROM ethereum.core.fact_event_logs

WHERE 1=1

AND block_timestamp >= current_date - interval '7 days'--'2024-04-01' -- date : Apr-01-2024

AND contract_address = ('0xacd2c239012d17beb128b0944d49015104113650') -- token address of Karrat

-- AND TX_HASH='0x2b7c6df0f9d320ab23d6669368bc521b9c8629bbc879a0c2f3d7ad6b9ad8796e'

AND origin_to_address!=contract_address

and origin_to_address='0x3fc91a3afd70395cd496c647d5a6cc9d4b2b7fad'