with new_users as (

select distinct from_address from ethereum.core.fact_transactions

where block_timestamp::date >='2023-01-01'

and nonce=0

),

new_users_transactions AS (

select ft.* from ethereum.core.fact_transactions ft

inner join new_users nu

on ft.from_address=nu.from_address

),

swapper as

select distinct origin_from_address from ethereum.defi.ez_dex_swaps

where block_timestamp::date >='2023-01-01'

),

nft_minter as

select distinct nft_to_address from ethereum.nft.ez_nft_mints

where block_timestamp::date >='2023-01-01'

),

nft_buyer as

select distinct buyer_address from ethereum.nft.ez_nft_sales

where block_timestamp::date >='2023-01-01'

),

nft_seller as

select distinct seller_address from ethereum.nft.ez_nft_sales

where block_timestamp::date >='2023-01-01'

select 'swaps' as type, count(distinct nu.from_address) as number_of_swaps