date(block_timestamp) as dates,

count(distinct(tx_id)) as TopShot_sales,

sum(TopShot_sales) over (order by dates) as cum_TopShot_sales

from flow.core.fact_nft_sales

where block_timestamp >= '2022-04-16'

and SPLIT(NFT_COLLECTION, '.')[2] = 'TopShot'

group by dates

order by dates desc