SELECT
date_trunc('day', block_timestamp) as day,
CASE WHEN marketplace in ('yawww', 'solanart', 'hadeswap', 'solport', 'coral cube') THEN '0% Marketplace'
WHEN marketplace in ('opensea', 'magic eden v1', 'solana monkey business marketplace', 'magic eden v1') THEN 'Royalty Marketplace' END marketplace_type,
sum(sales_amount) as sales_volume,
median(sales_amount) as median_price,
count(DISTINCT tx_id) as sales
FROM solana.core.fact_nft_sales
--WHERE marketplace in ('yawww', 'solanart', 'hadeswap', 'solport', 'coral cube')
GROUP BY 1,2
having NOT marketplace_type is NULL