mohamadreza221166top_50_bigger_holders
    Updated 2022-06-21
    WITH nft_transfers AS(
    SELECT *
    FROM ethereum.core.ez_nft_transfers
    WHERE nft_address = lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')
    ),
    transfers AS(
    SELECT NFT_FROM_ADDRESS AS ADDRESS, sum(1) AS AMOUNT, -1 AS flag
    FROM nft_transfers
    GROUP BY NFT_FROM_ADDRESS
    UNION
    SELECT NFT_TO_ADDRESS AS ADDRESS, sum(1) AS AMOUNT, 1 AS flag
    FROM nft_transfers
    GROUP BY NFT_TO_ADDRESS
    )

    SELECT T1.ADDRESS, sum(T1.Amount * flag) holded_amount
    FROM transfers T1
    GROUP BY T1.ADDRESS
    ORDER BY 2 DESC
    LIMIT 50
    Run a query to Download Data