select
date_trunc('day',block_timestamp) as date,
split_part(nft_collection, '.', -1) as collections,
sum(price) as total_volume
from flow.core.fact_nft_sales where nft_collection = 'A.0b2a3299cc857e29.TopShot' and date >= '2022-01-01'
GROUP BY date,2
order by date