--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,

TOKEN_NAME,

sum(sales_amount) as sales_volume,

median(sales_amount) as median_price,

count(DISTINCT tx_id) as sales

FROM solana.core.fact_nft_sales

LEFT outer JOIN solana.core.dim_nft_metadata

ON solana.core.fact_nft_sales.mint = solana.core.dim_nft_metadata.mint

WHERE marketplace in ('opensea', 'magic eden v1', 'solana monkey business marketplace', 'magic eden v1')

GROUP BY 1

having NOT token_name is NULl

ORDER by 2 DESC

LIMIT 30