mohamadreza221166Degods Nft Sale Prices Over Time
    Updated 2023-03-27
    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



    Run a query to Download Data