crypto_gosthatchy nfts mint
    Updated 2024-12-17
    SELECT
    project_name,
    COUNT(DISTINCT nft_to_address) AS total_minters,
    COUNT(*) AS total_minted_transactions
    FROM
    AVALANCHE.nft.ez_nft_transfers
    WHERE
    project_name IN ('HatchyPocket Gen2 Eggs',
    'HatchyPocket Gen2',
    'HatchyPocket')
    AND event_type = 'mint'
    GROUP BY
    project_name
    ORDER BY
    total_minted_transactions DESC;

    Last run: 2 months ago
    PROJECT_NAME
    TOTAL_MINTERS
    TOTAL_MINTED_TRANSACTIONS
    1
    HatchyPocket Gen2417087655
    2
    HatchyPocket215228358
    3
    HatchyPocket Gen2 Eggs602227365
    3
    100B
    4s