DATE_TRUNC('week', block_timestamp) AS activity_week,

nft_collection,

COUNT(DISTINCT buyer) AS daily_active_nft_buyers

FROM flow.NFT.ez_nft_sales

WHERE nft_collection IN (

'A.0b2a3299cc857e29.TopShot',

'A.e4cf4bdc1751c65d.AllDay',

'A.329feb3ab062d289.UFC_NFT',

'A.4eded0de73020ca5.CricketMoments'

GROUP BY activity_week, nft_collection

ORDER BY activity_week ASC;