select distinct FROM_ADDRESS as address

from monad.testnet.fact_transactions),

wallets_txs as

(select FROM_ADDRESS as wallet, 'Polygon' as chain, tx_hash, BLOCK_TIMESTAMP

from polygon.core.fact_transactions

where FROM_ADDRESS in (select address from address_array)

union all

select FROM_ADDRESS, 'Optimism' as chain, tx_hash, BLOCK_TIMESTAMP

from optimism.core.fact_transactions

where FROM_ADDRESS in (select address from address_array)

union all

select FROM_ADDRESS, 'Arbitrum', tx_hash, BLOCK_TIMESTAMP

from arbitrum.core.fact_transactions

where FROM_ADDRESS in (select address from address_array)

union all

select FROM_ADDRESS, 'Ethereum', tx_hash, BLOCK_TIMESTAMP

from ethereum.core.fact_transactions

where FROM_ADDRESS in (select address from address_array)

union all

select FROM_ADDRESS, 'Avalanche', tx_hash, BLOCK_TIMESTAMP

from avalanche.core.fact_transactions

where FROM_ADDRESS in (select address from address_array)

union all

select FROM_ADDRESS, 'BSC', tx_hash, BLOCK_TIMESTAMP

from bsc.core.fact_transactions

where FROM_ADDRESS in (select address from address_array)

union all

select FROM_ADDRESS, 'Base', tx_hash, BLOCK_TIMESTAMP

from base.core.fact_transactions

where FROM_ADDRESS in (select address from address_array)

),

chains_users as (

select distinct wallet