DATE_TRUNC('week', block_timestamp) AS week,

COUNT(DISTINCT buyer_address) AS weekly_buyers,

COUNT(DISTINCT seller_address) AS weekly_sellers,

(COUNT(DISTINCT buyer_address) + COUNT(DISTINCT seller_address)) AS weekly_total_traders

FROM

sei.nft.ez_nft_sales

platform_name = 'pallet'

GROUP BY

DATE_TRUNC('week', block_timestamp)

ORDER BY

week;