from crosschain.defi.ez_bridge_activity

where platform in ('layerzero','layerzero-v2','stargate') and block_timestamp::date>='2024-01-01'

and source_chain in ('blast', 'arbitrum', 'Optimism', 'bsc', 'avalanche', 'base', 'ethereum', 'polygon')),

table2 as (select block_timestamp, sender as user

from aptos.defi.ez_bridge_activity

where source_chain in ('Aptos','aptos') and platform in ('layerzero')

and block_timestamp::date>='2024-01-01'),

table3 as (select block_timestamp, origin_from_address as user

from sei.core_evm.ez_token_transfers

where origin_to_address in ('0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae',

'0x45d417612e177672958dc0537c45a8f8d754ac2e',

and symbol in ('USDC','WETH','WBTC') and block_timestamp::date>='2024-01-01'),

table4 as (select block_timestamp, from_address as user

from mantle.core.fact_transactions

where origin_function_signature='0x64e4ac27'

and to_address='0x41b491285a4f888f9f636cec8a363ab9770a0aef'

and block_timestamp::date>='2024-01-01'

and tx_succeeded='TRUE'

union all

select block_timestamp, origin_from_address as user

from mantle.core.ez_token_transfers

where origin_function_signature='0xc7c7f5b3'

and origin_to_address='0xb715b85682b731db9d5063187c450095c91c57fc'

and block_timestamp::date>='2024-01-01'),

table5 as (select block_timestamp, tx_from as user