SELECT

DISTINCT seller_address AS trader_address,

platform_name,

DATE_TRUNC('day', block_timestamp) AS SaleDate

FROM aptos.nft.ez_nft_sales

WHERE seller_address IS NOT NULL

AND block_timestamp >= current_timestamp - INTERVAL '1 month'

AND seller_address NOT IN (

SELECT DISTINCT buyer_address

FROM aptos.nft.ez_nft_sales

WHERE buyer_address IS NOT NULL

AND block_timestamp >= current_timestamp - INTERVAL '1 month'

)

UNION

SELECT

DISTINCT buyer_address AS trader_address,

platform_name,

DATE_TRUNC('day', block_timestamp) AS SaleDate

FROM aptos.nft.ez_nft_sales

WHERE buyer_address IS NOT NULL

AND block_timestamp >= current_timestamp - INTERVAL '1 month'

AND buyer_address NOT IN (

SELECT DISTINCT seller_address

FROM aptos.nft.ez_nft_sales

WHERE seller_address IS NOT NULL

AND block_timestamp >= current_timestamp - INTERVAL '1 month'

)

SELECT

platform_name,

SaleDate,

COUNT(DISTINCT trader_address) AS DailyTraders

FROM UniqueTraders

GROUP BY platform_name, SaleDate

ORDER BY SaleDate DESC, platform_name;