datavortexholders category
    Updated 2025-03-26
    WITH mints AS (
    SELECT
    SUM(CAST(decoded_log:value AS FLOAT) / 1e18) AS total_minted
    FROM ronin.core.ez_decoded_event_logs
    WHERE contract_address = LOWER('0x656fe582b4c6dc95c598ea54dc820eb36152e2f7')
    AND event_name = 'Transfer'
    AND decoded_log:from = '0x0000000000000000000000000000000000000000'
    ),
    burns AS (
    SELECT
    SUM(CAST(decoded_log:value AS FLOAT) / 1e18) AS total_burned
    FROM ronin.core.ez_decoded_event_logs
    WHERE contract_address = LOWER('0x656fe582b4c6dc95c598ea54dc820eb36152e2f7')
    AND event_name = 'Transfer'
    AND decoded_log:to = '0x0000000000000000000000000000000000000000'
    ),
    transfers AS (
    SELECT
    from_address,
    to_address,
    CAST(amount AS FLOAT) AS amount
    FROM ronin.core.ez_token_transfers
    WHERE contract_address = LOWER('0x656fe582b4c6dc95c598ea54dc820eb36152e2f7')
    ),
    balances AS (
    SELECT
    address,
    SUM(CASE WHEN direction = 'in' THEN amount ELSE -amount END) AS balance
    FROM (
    SELECT to_address AS address, amount, 'in' AS direction FROM transfers
    WHERE to_address != '0x0000000000000000000000000000000000000000'
    UNION ALL
    SELECT from_address AS address, amount, 'out' AS direction FROM transfers
    WHERE from_address != '0x0000000000000000000000000000000000000000'
    ) t
    GROUP BY address
    Last run: about 2 months ago
    Balance Range
    Total Holders
    Total CGX Held
    Percentage of Supply
    1
    0-1000 CGX131794224062.682.6286%
    2
    1000-5000 CGX40986790359.944.2255%
    3
    10000-50000 CGX681375551.340.856%
    4
    100000-1000000 CGX185544429.593.4502%
    5
    1000000+ CGX10140165028.2587.2222%
    6
    5000-10000 CGX2231715915.631.0678%
    7
    50000-100000 CGX12883509.420.5498%
    7
    309B
    6s