Count(tx_hash) AS total_sales_count,

Count(DISTINCT buyer_address) AS unique_buyers,

Count(DISTINCT seller_address) AS unique_sellers,

project_name AS nft_collection,

Sum(price_usd) AS total_sales_volume,

Avg(price_usd) AS average_sales_volume,

Min(price_usd) AS nft_floor_price

FROM optimism.core.ez_nft_sales s

JOIN optimism.core.dim_labels m

ON s.nft_address = m.address

WHERE project_name = {{nft_collection}}

AND DATE(block_timestamp) < CURRENT_DATE

AND DATE(block_timestamp) >= CURRENT_DATE - {{date_range}}

AND price_usd > 0

group by project_name