FROM_ADDRESS ,

min (BLOCK_TIMESTAMP) min_date

from base.core.fact_transactions

group by 1 having min_date >= current_date - 30

),

swaps as (

select

sender account

from base.defi.ez_dex_swaps

where SENDER in (select FROM_ADDRESS from new_accounts )

),

nft_sales as (

select

ORIGIN_FROM_ADDRESS account

from base.nft.ez_nft_sales

where ORIGIN_FROM_ADDRESS in (select FROM_ADDRESS from new_accounts )

select 'Swapped and traded NFTs' type , count (DISTINCT account) num_accounts from swaps join nft_sales using (account)

select 'Only swapped tokens' type , count (DISTINCT account) num_accounts from swaps left join nft_sales n using (account) where n.account is NULL

select 'Only traded NFTs' type , count (DISTINCT account) num_accounts from nft_sales left join swaps s using (account) where s.account is NULL

select 'Not swapped and not traded NFTs' type ,

count (DISTINCT FROM_ADDRESS ) num_accounts from new_accounts

where FROM_ADDRESS not in (select * from swaps )

and FROM_ADDRESS not in (select * from nft_sales )