to_date(block_timestamp) as date,

marketplace,

count(distinct tx_id) as number_of_sales,

sum(number_of_sales) over (partition by marketplace order by date) as cummulative_no_of_sales,

sum(sales_amount) as sales_amount_volume,

sum(sales_amount_volume) over (order by date) as cummulative_sales_amount_volume,

avg(sales_amount) as average_sales_amount_volume

from solana.core.fact_nft_sales

where marketplace in ('hyperspace','coral cube')

and succeeded = 'TRUE' and date >= CURRENT_DATE-INTERVAL '2 MONTH'

group by date, marketplace

order by date asc, marketplace

select * from sales