WITH sales as (
SELECT *
FROM solana.core.fact_nft_sales s
JOIN solana.core.dim_labels l
ON l.address = s.mint
WHERE succeeded
AND l.label in ('genopets terraform seeds')
)
SELECT date_trunc("week", BLOCK_TIMESTAMP) as week, LABEL, SUM(SALES_AMOUNT) as Volume_SOL
FROM sales
--WHERE date(BLOCK_TIMESTAMP) > current_date() - 180
GROUP BY 1, 2