SELECT *

FROM solana.core.fact_nft_sales s

JOIN solana.core.dim_labels l

ON l.address = s.mint

WHERE succeeded = TRUE

AND l.label = 'sharx by sharky.fi'

)

SELECT date_trunc("day", BLOCK_TIMESTAMP) as day, MIN(sales_amount) as lowest, MAX(sales_amount) as highest, AVG(sales_amount) as avg

FROM sales

WHERE date(BLOCK_TIMESTAMP) > current_date() - INTERVAL '200 DAYS'

GROUP BY 1

ORDER BY 1 desc