permarylabour-pink
    Updated 2025-03-20
    WITH nft_count AS (
    SELECT
    to_address
    , from_address
    , COUNT(tx_hash) AS amount
    FROM
    ronin.nft.ez_nft_transfers
    WHERE
    contract_address = lower('0xf083289535052e8449d69e6dc41c0ae064d8e3f6')
    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
    ),
    combine AS (
    SELECT
    address,
    SUM(amount) AS balance
    FROM
    nft_transfers
    GROUP BY
    Last run: 25 days ago
    Total Holders
    Total Supply
    Cummulative Holders
    Current Supply
    1
    970181785226965
    1
    24B
    4s