count(distinct tx_id) as no_of_txs,

round(sum(sales_amount),2) as tot_volume,

round(avg(sales_amount),2) as avg_volume,

count(distinct purchaser) as no_of_buyers,

sum(no_of_txs) over (order by week) as cum_txs,

sum(tot_volume) over (order by week) as cum_volume,

sum(no_of_buyers) over (order by week) as cum_buyers

from solana.core.fact_nft_sales

where marketplace = 'hadeswap'

and succeeded = True

group by 1

order by 1 desc