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 ('genesis genopets habitats', 'genopets habitats')

)

SELECT date_trunc("week", BLOCK_TIMESTAMP) as week, LABEL, SUM(SALES_AMOUNT) as Volume_SOL

FROM sales

GROUP BY 1, 2