with vip3 as ( select DISTINCT nft_to_address as address from ethereum.nft.ez_nft_transfers where NFT_ADDRESS = '0xabe292b291a18699b09608de86888d77ad6baf23' ), before_collab as (with vip3 as ( select DISTINCT nft_to_address as address from ethereum.nft.ez_nft_transfers where NFT_ADDRESS = '0xabe292b291a18699b09608de86888d77ad6baf23' ) select TX_HASH, ETH_FROM_ADDRESS as address, 'eth' as token, amount, 'arb' as chain from arbitrum.core.ez_eth_transfers where ETH_FROM_ADDRESS in (select address from vip3) and ETH_TO_ADDRESS= '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP<'2023-09-27' union all select TX_HASH, FROM_ADDRESS as address , CONTRACT_ADDRESS as token, amount, 'arb' as chain from arbitrum.core.ez_token_transfers where FROM_ADDRESS in (select address from vip3) and TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP<'2023-09-27' union all select TX_HASH, ETH_FROM_ADDRESS as address, '0x' as token, amount, 'base' as chain from base.core.ez_eth_transfers where ETH_FROM_ADDRESS in (select address from vip3) and ETH_TO_ADDRESS= '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP<'2023-09-27' union all select TX_HASH, FROM_ADDRESS as address , CONTRACT_ADDRESS as token, amount, 'base' as chain from base.core.ez_token_transfers where FROM_ADDRESS in (select address from vip3) and TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP<'2023-09-27' union all select TX_HASH, ETH_FROM_ADDRESS as address, 'eth' as token, amount, 'eth' as chain from ethereum.core.ez_eth_transfers where ETH_FROM_ADDRESS in (select address from vip3) and ETH_TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP<'2023-09-27' union all select TX_HASH, FROM_ADDRESS as address , CONTRACT_ADDRESS as token, amount, 'eth' as chain from ethereum.core.ez_token_transfers where FROM_ADDRESS in (select address from vip3) and TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP<'2023-09-27' union all select TX_HASH, ETH_FROM_ADDRESS as address, 'eth' as token, amount, 'op' as chain from optimism.core.ez_eth_transfers where ETH_FROM_ADDRESS in (select address from vip3) and ETH_TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP<'2023-09-27' union all select TX_HASH, FROM_ADDRESS as address , CONTRACT_ADDRESS as token, amount, 'op' as chain from optimism.core.ez_token_transfers where FROM_ADDRESS in (select address from vip3) and TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP<'2023-09-27' union all select TX_HASH, MATIC_FROM_ADDRESS as address, 'matic' as token, amount, 'polygon' as chain from polygon.core.ez_matic_transfers where MATIC_FROM_ADDRESS in (select address from vip3) and MATIC_TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP<'2023-09-27' union all select TX_HASH, FROM_ADDRESS as address , CONTRACT_ADDRESS as token, amount, 'polygon' as chain from polygon.core.ez_token_transfers where FROM_ADDRESS in (select address from vip3) and TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP<'2023-09-27' union all select TX_HASH, BNB_FROM_ADDRESS as address, 'bnb' as token, amount, 'bnb' as chain from bsc.core.ez_bnb_transfers where BNB_FROM_ADDRESS in (select address from vip3) and BNB_TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP<'2023-09-27' union all select TX_HASH, FROM_ADDRESS as address , CONTRACT_ADDRESS as token, amount, 'bnb' as chain from polygon.core.ez_token_transfers where FROM_ADDRESS in (select address from vip3) and TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP<'2023-09-27' ), after_collab as (select TX_HASH, ETH_FROM_ADDRESS as address, 'eth' as token, amount, 'arb' as chain from arbitrum.core.ez_eth_transfers where ETH_FROM_ADDRESS in (select address from vip3) and ETH_TO_ADDRESS= '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP>='2023-09-27' union all select TX_HASH, FROM_ADDRESS as address , CONTRACT_ADDRESS as token, amount, 'arb' as chain from arbitrum.core.ez_token_transfers where FROM_ADDRESS in (select address from vip3) and TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP>='2023-09-27' union all select TX_HASH, ETH_FROM_ADDRESS as address, '0x' as token, amount, 'base' as chain from base.core.ez_eth_transfers where ETH_FROM_ADDRESS in (select address from vip3) and ETH_TO_ADDRESS= '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP>='2023-09-27' union all select TX_HASH, FROM_ADDRESS as address , CONTRACT_ADDRESS as token, amount, 'base' as chain from base.core.ez_token_transfers where FROM_ADDRESS in (select address from vip3) and TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP>='2023-09-27' union all select TX_HASH, ETH_FROM_ADDRESS as address, 'eth' as token, amount, 'eth' as chain from ethereum.core.ez_eth_transfers where ETH_FROM_ADDRESS in (select address from vip3) and ETH_TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP>='2023-09-27' union all select TX_HASH, FROM_ADDRESS as address , CONTRACT_ADDRESS as token, amount, 'eth' as chain from ethereum.core.ez_token_transfers where FROM_ADDRESS in (select address from vip3) and TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP>='2023-09-27' union all select TX_HASH, ETH_FROM_ADDRESS as address, 'eth' as token, amount, 'op' as chain from optimism.core.ez_eth_transfers where ETH_FROM_ADDRESS in (select address from vip3) and ETH_TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP>='2023-09-27' union all select TX_HASH, FROM_ADDRESS as address , CONTRACT_ADDRESS as token, amount, 'op' as chain from optimism.core.ez_token_transfers where FROM_ADDRESS in (select address from vip3) and TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP>='2023-09-27' union all select TX_HASH, MATIC_FROM_ADDRESS as address, 'matic' as token, amount, 'polygon' as chain from polygon.core.ez_matic_transfers where MATIC_FROM_ADDRESS in (select address from vip3) and MATIC_TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP>='2023-09-27' union all select TX_HASH, FROM_ADDRESS as address , CONTRACT_ADDRESS as token, amount, 'polygon' as chain from polygon.core.ez_token_transfers where FROM_ADDRESS in (select address from vip3) and TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP>='2023-09-27' union all select TX_HASH, BNB_FROM_ADDRESS as address, 'bnb' as token, amount, 'bnb' as chain from bsc.core.ez_bnb_transfers where BNB_FROM_ADDRESS in (select address from vip3) and BNB_TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP>='2023-09-27' union all select TX_HASH, FROM_ADDRESS as address , CONTRACT_ADDRESS as token, amount, 'bnb' as chain from polygon.core.ez_token_transfers where FROM_ADDRESS in (select address from vip3) and TO_ADDRESS = '0x1a8f43e01b78979eb4ef7febec60f32c9a72f58e' and BLOCK_TIMESTAMP>='2023-09-27'), alltrans as (select *,'old' as flag from before_collab union all select * ,'new' as flag from after_collab ) select count(distinct t.address) from after_collab t where address not in (select address from before_collab group by address)

Query	Creator	Created
TokenPocket ethereum polygon nft evm	0x69	Oct 26, 2023
Owlto_all arbitrum base ethereum optimism nft	0x69	Oct 26, 2023
TokenPoket_all ethereum polygon nft evm	0x69	Oct 26, 2023
Owlto arbitrum base ethereum optimism nft	0x69	Oct 26, 2023
Owlto_group arbitrum base ethereum optimism nft	0x69	Oct 26, 2023
bitget bsc arbitrum base ethereum nft	0x69	Oct 29, 2023

0x69