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'

),

supply AS (

SELECT

COALESCE(m.total_minted, 0) - COALESCE(b.total_burned, 0) AS current_supply

FROM mints m, burns b

),

latest_price AS (

SELECT price

FROM ronin.price.ez_prices_hourly

WHERE token_address = '0x656fe582b4c6dc95c598ea54dc820eb36152e2f7'

ORDER BY hour DESC

LIMIT 1

SELECT

s.current_supply AS "Current CGX Supply",

lp.price AS "Latest Price",

(s.current_supply * lp.price) AS "Market Cap"

FROM supply s, latest_price lp;