DATE_TRUNC('day', block_timestamp) AS day,

-- DATE_TRUNC('week', block_timestamp) AS week,

-- DATE_TRUNC('month', block_timestamp) AS month,

-- DATE_TRUNC('year', block_timestamp) AS year,

SUM(s.price) AS total_sales_price,

AVG(s.price) AS avg_price,

MAX(s.price) AS max_price,

MIN(s.price) AS min_price,

COUNT(DISTINCT s.tx_id) AS nft_sales

-- CASE --dr simon

-- WHEN '{{date}}' = 'day' THEN DATE_TRUNC('day', block_timestamp)

-- WHEN '{{date}}' = 'week' THEN DATE_TRUNC('week', block_timestamp)

-- WHEN '{{date}}' = 'month' THEN DATE_TRUNC('month', block_timestamp)

-- WHEN '{{date}}' = 'year' THEN DATE_TRUNC('year', block_timestamp)

-- ELSE NULL

FROM flow.core.ez_nft_sales s

JOIN flow.core.dim_contract_labels c ON s.NFT_COLLECTION = c.EVENT_CONTRACT

WHERE s.MARKETPLACE LIKE 'Gigantik Primary Market'

AND s.price IS NOT NULL --dr simon

-- AND nft_sales >= 1

AND s.tx_succeeded = 'true'

GROUP BY 1

ORDER BY nft_sales DESC