with acquired_users as (

select distinct from_address from optimism.core.fact_transactions

where block_timestamp::date >='2023-01-01' and block_timestamp::date < '2024-01-01'

and nonce=1

),

acquired_users_transactions AS (

select ft.* from optimism.core.fact_transactions ft

inner join acquired_users nu

on ft.from_address=nu.from_address

),

swapper as

select distinct origin_from_address from optimism.defi.ez_dex_swaps

where block_timestamp::date >='2023-01-01' and block_timestamp::date < '2024-01-01'

),

nft_buyer as

select distinct buyer_address from optimism.nft.ez_nft_sales

where block_timestamp::date >='2023-01-01' and block_timestamp::date < '2024-01-01'

),

nft_seller as

select distinct seller_address from optimism.nft.ez_nft_sales

where block_timestamp::date >='2023-01-01' and block_timestamp::date < '2024-01-01'

select 'DEX swappers' as type, count(distinct nu.from_address) as number_of_users