SELECT

address AS "Trader Address",

MIN(block_timestamp) AS "First Transaction Date"

FROM (

SELECT

buyer_address AS address,

block_timestamp

FROM

arbitrum.nft.ez_nft_sales

UNION ALL

SELECT

seller_address AS address,

block_timestamp

FROM

arbitrum.nft.ez_nft_sales

) AS transactions

GROUP BY

address

),

NewTraders AS (

SELECT

ft."Trader Address"

FROM

FirstTransaction ft

WHERE

ft."First Transaction Date" >= DATEADD(day, -30, CURRENT_DATE())

),

NFTProjectTrades AS (

SELECT

n.project_name AS "Project Name",

COUNT(DISTINCT n.tx_hash) AS "Trade Count"