date(block_timestamp) as "Date",

marketplace as "Marketplace",

count (distinct tx_id) as "Number of Sales",

sum("Number of Sales") over (partition by "Marketplace" order by "Date") as "Cumulative Number of Sales",

count (distinct purchaser) as "Number of Buyers",

sum("Number of Buyers") over (partition by "Marketplace" order by "Date") as "Cumulative Number of Buyers",

count (distinct seller) as "Number of Sellers",

sum("Number of Sellers") over (partition by "Marketplace" order by "Date") as "Cumulative Number of Sellers",

count (distinct mint) as "Number of NFTs",

sum("Number of NFTs") over (partition by "Marketplace" order by "Date") as "Cumulative Number of NFTs",

sum (sales_amount) as "Sales Volume (SOL)",

sum("Sales Volume (SOL)") over (partition by "Marketplace" order by "Date") as "Cumulative Sales Volume (SOL)",

AVG (sales_amount) as "Average SOL Volume per Sale",

Median (sales_amount) as "Median SOL Volume per Sale",

Min (sales_amount) as "Minimum SOL Volume per Sale",

Max (sales_amount) as "Maximum SOL Volume per Sale",

("Number of Sales"/"Number of Buyers") as "Average Sales per Buyer",

("Number of Sales"/"Number of Sellers") as "Average Sales per Seller",

("Sales Volume (SOL)"/"Number of Buyers") as "Average SOL per Buyer",

("Sales Volume (SOL)"/"Number of Sellers") as "Average SOL per Seller",

("Sales Volume (SOL)"/"Number of Sales") as "Average SOL per Sale",

("Number of Sales"/"Number of NFTs") as "Average Sales per NFT",

("Sales Volume (SOL)"/"Number of NFTs") as "Average SOL per NFT"

from solana.core.fact_nft_sales

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

and succeeded = TRUE

group by 1,2

order by 1 , 2