datavortexCGX mints and burns
    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'
    )

    SELECT
    COALESCE(m.total_minted, 0) AS "Total CGX Minted",
    COALESCE(b.total_burned, 0) AS "Total CGX Burned",
    COALESCE(m.total_minted, 0) - COALESCE(b.total_burned, 0) AS "Current CGX Supply"
    FROM mints m, burns b;

    Last run: about 2 months ago
    Total CGX Minted
    Total CGX Burned
    Current CGX Supply
    1
    160942118.917056243262.068389347160698856.848666
    1
    54B
    6s