select distinct(from_address) as from_address from (

select distinct(from_address) as from_address from ethereum.core.fact_transactions

where block_timestamp >= '2023-01-01'

union

select distinct(from_address) as from_address from arbitrum.core.fact_transactions

where block_timestamp >= '2023-01-01'

union

select distinct(from_address) as from_address from optimism.core.fact_transactions

where block_timestamp >= '2023-01-01'

union

select distinct(from_address) as from_address from polygon.core.fact_transactions

where block_timestamp >= '2023-01-01'

union

select distinct(from_address) as from_address from bsc.core.fact_transactions

where block_timestamp >= '2023-01-01'

union

select distinct(from_address) as from_address from avalanche.core.fact_transactions

where block_timestamp >= '2023-01-01'

)

),

wrapped_symbols AS (

select * from

(select 'eth' as chain, to_address, symbols from (

select to_address, ARRAY_UNIQUE_AGG(symbol) as symbols from

(select * from ethereum.core.ez_token_transfers where block_timestamp >= CURRENT_DATE - interval '30 day' and symbol REGEXP '[A-Z]+')

group by to_address, symbol

having count(distinct(from_address)) = 1 and count(distinct(origin_function_signature)) = 1

and min(origin_function_signature) = '0xa9059cbb'

and count(distinct(tx_hash)) <= 6

) where not ARRAY_CONTAINS('USDT'::VARIANT, symbols) and not ARRAY_CONTAINS('USDC'::VARIANT, symbols)

select 'arb' as chain, to_address, symbols from (

select to_address, ARRAY_UNIQUE_AGG(symbol) as symbols from

(select * from arbitrum.core.ez_token_transfers where block_timestamp >= CURRENT_DATE - interval '30 day' and symbol REGEXP '[A-Z]+')

group by to_address