BaseMinter List
    Updated 2024-09-13

    WITH
    mint_data AS (
    SELECT
    NFT_TO_ADDRESS AS minter_address,
    COUNT(TOKENID) AS minted_count
    FROM
    base.nft.ez_nft_transfers
    WHERE
    EVENT_TYPE = 'mint' AND
    NFT_ADDRESS = LOWER('0xbdb1a8772409a0c5eeb347060cbf4b41dd7b2c62') AND
    NFT_FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
    GROUP BY
    NFT_TO_ADDRESS
    ),

    current_holders AS (
    WITH a AS (
    SELECT
    nft_to_address AS wallets,
    '1' AS flag
    FROM base.nft.ez_nft_transfers
    WHERE nft_address = LOWER('0xbdb1a8772409a0c5eeb347060cbf4b41dd7b2c62')
    UNION ALL
    SELECT
    nft_from_address AS wallets,
    '-1' AS flag
    FROM base.nft.ez_nft_transfers
    WHERE nft_address = LOWER('0xbdb1a8772409a0c5eeb347060cbf4b41dd7b2c62')
    )
    SELECT
    wallets AS holder_address,
    SUM(flag) AS nfts
    FROM
    QueryRunArchived: QueryRun has been archived