Date_trunc('day', Block_timestamp) AS Date,

COUNT(DISTINCT user) AS total_unique_users

FROM

(

SELECT

Block_timestamp,

buyer AS user

FROM flow.nft.ez_nft_sales

WHERE BLOCK_TIMESTAMP :: Date >= '2024-01-01'

AND marketplace IN (

'A.4eb8a10cb9f87357.NFTStorefront',

'A.4eb8a10cb9f87357.NFTStorefrontV2'

)

UNION ALL

SELECT

Block_timestamp,

seller AS user

FROM flow.nft.ez_nft_sales

WHERE BLOCK_TIMESTAMP :: Date >= '2024-01-01'

AND marketplace IN (

'A.4eb8a10cb9f87357.NFTStorefront',

'A.4eb8a10cb9f87357.NFTStorefrontV2'

)

) AS all_users

GROUP BY 1