Transaction_Date,

Transaction_Count,

avg(Transaction_Count) OVER (ORDER BY Transaction_Date) AS Cum_Transaction_Count

from

select

date(BLOCK_TIMESTAMP) as Transaction_Date, count(*) as Transaction_Count

from flow.core.fact_nft_sales

where NFT_COLLECTION like '%TopShot%'

group by

date(BLOCK_TIMESTAMP)

order by

date(BLOCK_TIMESTAMP)

) tbl