date_trunc('day', block_timestamp) as date1,

count(*) as Total_Sales,

count(distinct buyer) as Unique_Buyers,

count(distinct seller) as Unique_Sellers

from flow.core.ez_nft_sales left outer join flow.core.dim_allday_metadata

on flow.core.ez_nft_sales.nft_id = flow.core.dim_allday_metadata.nft_id

where team is not null

group by 1