SELECT

DISTINCT COALESCE(seller_address, buyer_address) AS trader,

MIN(block_timestamp) OVER (PARTITION BY COALESCE(seller_address, buyer_address)) AS min_date

FROM near.nft.ez_nft_sales

WHERE platform_name IN ('{{platform_name}}')

AND block_timestamp::date >= '{{Start_Date}}'

AND block_timestamp::date <= '{{End_Date}}'

),

weekly_traders AS (

SELECT

DATE_TRUNC('week', block_timestamp) AS week_start,

COUNT(DISTINCT COALESCE(seller_address, buyer_address)) AS n_traders

FROM near.nft.ez_nft_sales

WHERE platform_name IN ('{{platform_name}}')

AND block_timestamp::date >= '{{Start_Date}}'

AND block_timestamp::date <= '{{End_Date}}'

GROUP BY DATE_TRUNC('week', block_timestamp)

wt.week_start,

wt.n_traders,

COALESCE(nu.num_new_users, 0) AS num_new_users

weekly_traders wt

LEFT JOIN (

SELECT

DATE_TRUNC('week', min_date)::DATE AS week_start,

COUNT(DISTINCT trader) AS num_new_users

FROM new_users

GROUP BY DATE_TRUNC('week', min_date)::DATE

) nu

ON wt.week_start = nu.week_start

ORDER BY wt.week_start;