tx as (

select distinct tx_hash, origin_function_signature

from ethereum.core.fact_transactions

where block_timestamp>='2023-11-01'

and (to_address = lower('0x7915f087685fffD71608E5d118f3B70c27D9eF4e') or to_address = lower('0x3263bc4976C8c180bd5EB90a57ED1A2f1CFcAC67'))

and origin_function_signature in ('0x8bf122da', '0x6614eb71', '0xccba8aac')

and status='SUCCESS'

select distinct tx_hash, origin_function_signature

from base.core.fact_transactions

where block_timestamp>='2023-11-01'

and (to_address = lower('0xeF0D482Daa16fa86776Bc582Aff3dFce8d9b8396') or to_address= lower('0x9Bb4D44e6963260A1850926E8f6bEB8d5803836F') or to_address = lower('0x131642c019AF815Ae5F9926272A70C84AE5C37ab'))

and origin_function_signature in ('0x8bf122da', '0x6614eb71', '0xccba8aac','0x1d7f10ac')

and status='SUCCESS'

select distinct tx_hash, origin_function_signature

from polygon.core.fact_transactions

where block_timestamp>='2023-11-01'

and (to_address = lower('0x551c6791c2f01c3Cd48CD35291Ac4339F206430d') or to_address= lower('0x7f52269092F2a5EF06C36C91e46F9196deb90336') or to_address=lower('0xe63fb3a3cd48df6a336560a91f78ac6013557f7d'))

and origin_function_signature in ('0x8bf122da', '0x6614eb71', '0xccba8aac','0x1d7f10ac','0x04e0fc36')

and from_address not in ('0x7e8ae5dee408ac8bdff1822a90571a5d145681e2','0xAed9b3431ca657234fe01c8855b2c2354dec17ba','0x863cdf3433791faf89d197ad042746ff737f3178','0x076bd177a24ff462d92c904639d88a527ac7f630','0xe00a7135e073a0606aa6b5eb895e996ada364ddd')

and status='SUCCESS'

),

tx_events as (

select

*, 'Ethereum' as chain from ethereum.core.ez_decoded_event_logs where tx_hash in (select tx_hash from tx)

select

*, 'Base' as chain from base.core.ez_decoded_event_logs where tx_hash in (select tx_hash from tx)

select

*, 'Polygon' as chain from polygon.core.ez_decoded_event_logs where tx_hash in (select tx_hash from tx)

), --select * from tx_1_events

tx_decoded as (