SELECT date(block_timestamp) as date4, COUNT(DISTINCT tx_id) as sale_volume_heat,
sum(sale_volume_heat) over (order by date4) as cum_sales
FROM flow.core.fact_nft_sales
WHERE nft_id IN (SELECT distinct nft_id FROM flow.core.dim_topshot_metadata WHERE nft_collection LIKE '%TopShot%' AND team = 'Miami Heat')
AND date4 BETWEEN '2022-05-01' AND '2022-05-31'
GROUP by date4