Updated 2025-02-26
    with table1 as (select block_timestamp, source_address as user
    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',
    '0x0555e30da8f98308edb960aa94c0db47230d2b9c')
    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