date_trunc('day', block_timestamp) "Date",

upper(marketplace) "Platform",

count(distinct tx_id) "Transaction Count",

sum(sales_amount) "Sales Amount",

avg(sales_amount) "Average Sales Amount",

median(sales_amount) "Median Sales Amount",

max(sales_amount) "Maximum Sales Amount",

min(sales_amount) "Minimum Sales Amount",

count(distinct seller) "Unique Sellers",

count(distinct purchaser) "Unique Purchasers"

from solana.core.fact_nft_sales

where 1 = 1

and succeeded = 1

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

group by 1, 2

order by 1, 3 desc