WITH sales AS (
SELECT block_timestamp::date AS days
,COUNT(DISTINCT tx_id) as number_of_sales
,COUNT(DISTINCT t1.MINT) unique_nft
,COUNT(DISTINCT purchaser) AS unique_wallets
FROM solana.fact_nft_sales t1
-- JOIN solana.core.dim_nft_metadata t2 ON t2.MINT = t1.MINT
JOIN solana.core.dim_labels t2 ON t2.ADDRESS = t1.MINT
-- WHERE lower(t2.CONTRACT_NAME) LIKE '%degods%'
WHERE lower(t2.ADDRESS_NAME) LIKE '%degods%'
AND SUCCEEDED = TRUE
GROUP BY 1
ORDER BY 1
)
SELECT * from sales