Query editor
WITH creation AS (SELECTDATE_TRUNC('day', block_date) AS week,COUNT(DISTINCT token_mint_address) AS tokens_createdFROM tokens_solana.transfersWHEREaction = 'mint'AND outer_executing_account = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P' /* pumpfun ca */AND block_date >= CURRENT_DATE - INTERVAL '22' DAYAND block_date <= CURRENT_DATEGROUP BYDATE_TRUNC('day', block_date)), graduates AS (SELECTDATE_TRUNC('day', block_date) AS week,COUNT(DISTINCT tx_id) AS graduatesFROM tokens_solana.transfersWHEREaction = 'burn'AND outer_executing_account = '6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P'AND block_date >= CURRENT_DATE - INTERVAL '22' DAYAND block_date <= CURRENT_DATEGROUP BYDATE_TRUNC('day', block_date))SELECTCOALESCE(c.week, g.week) AS week,COALESCE(c.tokens_created, 0) AS tokens_created,COALESCE(g.graduates, 0) AS graduates,CASEWHEN COALESCE(c.tokens_created, 0) = 0THEN NULLELSE ROUND(TRY_CAST(g.graduates AS DOUBLE) / TRY_CAST(c.tokens_created AS DOUBLE) * 100, 2)END AS graduation_rateFROM creation AS cFULL OUTER JOIN graduates AS gON c.week = g.weekWHERECOALESCE(c.week, g.week) BETWEEN (CURRENT_DATE - INTERVAL '22' DAY) AND CURRENT_DATEORDER BYweek DESC