select count(distinct buyer) as buyer_count, count(distinct seller) as seller_count , trunc(block_timestamp, 'DAY') as dt from flow.core.fact_nft_sales inner join flow.core.dim_topshot_metadata
on flow.core.dim_topshot_metadata.nft_id=flow.core.fact_nft_sales.nft_id
where play_type='3 Pointer'
group by 3