SELECT

project_name,

buyer_address AS trader_address,

DATE(block_timestamp) AS trade_date

FROM

aptos.nft.fact_nft_sales

WHERE

block_timestamp >= current_timestamp - INTERVAL '1 month'

AND project_name IS NOT NULL

AND project_name <> ''

UNION

SELECT

project_name,

seller_address AS trader_address,

DATE(block_timestamp) AS trade_date

FROM

aptos.nft.fact_nft_sales

WHERE

block_timestamp >= current_timestamp - INTERVAL '1 month'

AND project_name IS NOT NULL

AND project_name <> ''

),

TraderFirstTrade AS (

SELECT

trader_address,

MIN(trade_date) AS first_trade_date

FROM

TraderData

GROUP BY

trader_address

),

NewReturningTraders AS (

SELECT

td.project_name,

td.trade_date,