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