select split_part(nft_collection, '.', 3) as collection, sum(price) as volume, count(distinct buyer) as total_unique_buyer,
count(distinct seller) as total_unique_seller
from flow.core.fact_nft_sales
where split_part(nft_collection, '.', 3) in ('TopShot', 'AllDay')
group by 1