i_danRONKE: Holders List
    Updated 2025-04-02
    WITH nft_count AS (
    SELECT
    to_address
    , from_address
    , COUNT(tx_hash) AS amount
    FROM
    ronin.nft.ez_nft_transfers
    WHERE
    contract_address = lower('0x810b6d1374ac7ba0e83612e7d49f49a13f1de019')
    GROUP BY 1, 2
    ),

    nft_transfers AS (
    SELECT
    to_address AS address,
    SUM(amount) AS amount
    FROM
    nft_count
    GROUP BY 1

    UNION ALL

    SELECT
    from_address AS address,
    SUM(- amount) AS amount
    FROM
    nft_count
    GROUP BY 1
    )

    SELECT
    address AS "Address",
    SUM(amount) AS "Balance"
    FROM
    nft_transfers
    GROUP BY
    Last run: about 1 month ago
    Address
    Balance
    1
    0x6a0f683e2c6bb04ad859298daaafe08ea41c7aba202
    2
    0x9f8bc9c10d6c344fd089ac27ec1cab694dd864f8124
    3
    0x4dbb38f4384c01aff149e0b915c58e3401c37a69120
    4
    0x288c1bb2125a1310bdf25699b33d4108836d01c9101
    5
    0x71e8902ea29f4b8465a0b04ea4a0b7238cc5d77097
    6
    0x749b1260c5443227275b68bba60bc9f6a10b128896
    7
    0x466e70f677b3ebd99ff027ec13cc040f19978abc51
    8
    0xbea522c63406affc691342817bb2fb365d4299a851
    9
    0x7aadd939a6d3418863a83fb95d30180977da467b50
    10
    0xcac3d7ddc8948c18b7f64f7a1273d472624bb00845
    11
    0x0532707fc39c463c3f70a4dc4d001503966f04d341
    12
    0x6390cad1db0388d97fd546ab8514a07ea1234c8737
    13
    0xf17ff67192ad3da0791f11dfdc208e6299f21bb436
    14
    0x949e9da76e917dd5548ee9125c1facd49867d7c536
    15
    0x1d45856c85f2f4425f57c848ea503d5ff4e1f85735
    16
    0xe5e4d0f016565599961b08e28ee6af26a843ea4534
    17
    0x0e734bb56bb955198787dd046e46eae53f2a8e0e34
    18
    0x3af5a99248a16e7cc3f0d0463b775ea4976d7e1a33
    19
    0x5aa36704e79dff3615d84e88928d33e175600e0932
    20
    0x27f4cea185af16f6cf784359e203e0125bea4ffb31
    ...
    2748
    132KB
    1s