flipside

    ice blue 4.2
    aureasarsanedesice blue 4.2
    Updated 2025-02-11
    WITH mints AS (
    SELECT
    NFT_TO_ADDRESS AS holder,
    SUM(NFT_COUNT) AS total_mints
    FROM
    aptos.nft.ez_nft_mints
    WHERE
    PROJECT_NAME = 'Ice Blue'
    GROUP BY
    holder
    ),
    buys AS (
    SELECT
    BUYER_ADDRESS AS holder,
    COUNT(distinct tokenid) AS total_buys
    FROM
    aptos.nft.ez_nft_sales
    WHERE
    PROJECT_NAME = 'Ice Blue'
    GROUP BY
    holder
    ),
    sells AS (
    SELECT
    SELLER_ADDRESS AS holder,
    COUNT(distinct tokenid) AS total_sells
    FROM
    aptos.nft.ez_nft_sales
    WHERE
    PROJECT_NAME = 'Ice Blue'
    GROUP BY
    holder
    ),
    holder_nfts AS (
    SELECT
    COALESCE(mints.holder, buys.holder, sells.holder) AS holder,
    Last run: 2 months ago
    NFT_RANGE
    HOLDER_COUNT
    1
    		1 NFT1285
    2
    		2 NFTs130
    3
    		3-5 NFTs56
    4
    		6-10 NFTs26
    5
    		11-25 NFTs15
    6
    		More than 25 NFTs7
    6
    106B
    5s