FROM_ADDRESS ,

min (BLOCK_TIMESTAMP) min_date

from base.core.fact_transactions

group by 1 having min_date >= current_date - 30

),

swaps as (

select

count (DISTINCT tx_hash) num_transactions ,

count (DISTINCT sender ) num_accounts

from base.defi.ez_dex_swaps

where SENDER in (select FROM_ADDRESS from new_accounts )

),

nft_sales as (

select

count (DISTINCT tx_hash) num_transactions ,

count (DISTINCT ORIGIN_FROM_ADDRESS) num_accounts

from base.nft.ez_nft_sales

where ORIGIN_FROM_ADDRESS in (select FROM_ADDRESS from new_accounts )

select 'swap' type , num_transactions , num_accounts from swaps

select 'NFT sale' type , num_transactions , num_accounts from nft_sales