Query editor
with actions as (selectblock_date, action, amount/1e6 as volumefrom tokens_solana.transfers-- where block_date >= date('2025-03-01')where token_mint_address = 'AUDDttiEpCydTm7joUMbYddm72jAWXZnCpPZtDoxqBSw' -- AUDD in Solanaand action in ('mint', 'burn')),mints_burns as (SELECTblock_date as day,sum(case when action = 'mint' then volume else 0 end) as "Mint volume",sum(case when action = 'burn' then -volume else 0 end) as "Burn volume",sum(case when action = 'mint' then volume else 0 end) +sum(case when action = 'burn' then -volume else 0 end) as "Net",sum(sum(case when action = 'mint' then volume else 0 end) +sum(case when action = 'burn' then -volume else 0 end)) over ( order by block_date) as total_supplyfrom actionsgroup by 1order by 1 desc),-- Get date seriesgenerateDates AS(SELECT * FROM UNNEST(sequence(CAST('2021-09-15' AS TIMESTAMP),CAST(NOW() AS TIMESTAMP), interval '1' day)) as t(date)),-- First mintcalendar_1 AS (SELECT MIN(block_date) as datefrom tokens_solana.transferswhere token_mint_address = 'AUDDttiEpCydTm7joUMbYddm72jAWXZnCpPZtDoxqBSw' -- AUDD in Solanaand action in ('mint', 'burn'))selecta."date" as day, COALESCE(b."Mint volume", 0) AS "Mint volume", COALESCE(b."Burn volume", 0) AS "Burn volume", COALESCE(b."Net", 0) as "Net", SUM(COALESCE(b."Mint volume",0) + COALESCE(b."Burn volume",0)) OVER (ORDER BY a."date") AS total_supplyfrom generateDates aleft join mints_burns bon a."date" = b."day"where a."date" >= (select date from calendar_1) -- Date of first mintorder by 1 desc