SELECT

SELLER_ADDRESS,

BUYER_ADDRESS

FROM

base.nft.ez_nft_sales;

WHERE

BLOCK_TIMESTAMP >= DATEADD(DAY, -30, CURRENT_TIMESTAMP())

AND BLOCK_TIMESTAMP < CURRENT_TIMESTAMP()

COUNT(DISTINCT SELLER_ADDRESS) AS total_unique_sellers,

COUNT(DISTINCT BUYER_ADDRESS) AS total_unique_buyers

FROM

Recent_Sales;