SELECT

date_trunc('day', block_timestamp) as date,

CASE

WHEN marketplace ilike '%magic eden%' then 'Magic Eden'

ELSE INITCAP(MARKETPLACE)

END AS marketplace,

COUNT(DISTINCT tx_id) as sales,

COUNT(DISTINCT purchaser) as buyers,

COUNT(DISTINCT seller) as sellers,

SUM(sales_amount) as volume,

--AVG(sales_amount) as "Average Price",

COUNT(DISTINCT nft_collection_name) as "Traded NFTs"

solana.nft.fact_nft_sales s

LEFT JOIN solana.nft.dim_nft_metadata m ON s.mint=m.mint

block_timestamp :: date >= current_date - 31

AND block_timestamp :: date < current_date

AND succeeded = 'True'

GROUP BY 1, 2