SELECT date_trunc('day', b.BLOCK_TIMESTAMP) AS days, AVG(SALES_AMOUNT) AS AMOUNT_SOL
FROM solana.fact_nft_sales b
JOIN solana.core.dim_nft_metadata a ON a.mint = b.mint
WHERE lower(CONTRACT_NAME) LIKE '%degods%'
AND SUCCEEDED = TRUE
AND SALES_AMOUNT > 0
GROUP BY 1
ORDER BY 1