Updated 2023-10-04
    SELECT

    Project_name,
    CASE WHEN NFT_FROM_ADDRESS ='0x0000000000000000000000000000000000000000'
    THEN 'Mint'
    ELSE null
    END AS type,
    COUNT(DISTINCT nft_to_address)wallets_minting,
    COUNT(nft_to_address)tokens,
    DATE_TRUNC('month', block_timestamp) AS date


    FROM ethereum.nft.ez_nft_mints


    WHERE NFT_ADDRESS ='0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205'

    GROUP BY project_name,type,date

    ORDER BY date DESC
    Run a query to Download Data