Query editor
WITH calendar AS (SELECT dayFROM UNNEST(sequence(current_date - INTERVAL '90' DAY,current_date,INTERVAL '1' DAY)) AS t(day)),daily AS (SELECTCAST(date_trunc('day', block_time) AS DATE) AS block_day,SUM(IF(action = 'mint'AND to_owner = 'STEPNwUmvdCWRm4yzH4rtCuPUeKuEapFvFKHKteiGH5',amount / POWER(10, 9),0)) AS mint_amount,-SUM(IF(action = 'burn'AND from_owner = 'STEPNwUmvdCWRm4yzH4rtCuPUeKuEapFvFKHKteiGH5',amount / POWER(10, 9),0)) AS burn_amountFROM tokens_solana.transfersWHERE block_time >= current_date - INTERVAL '90' DAYAND token_mint_address = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB'AND action IN ('mint', 'burn')AND ((action = 'mint'AND to_owner = 'STEPNwUmvdCWRm4yzH4rtCuPUeKuEapFvFKHKteiGH5')OR (action = 'burn'AND from_owner = 'STEPNwUmvdCWRm4yzH4rtCuPUeKuEapFvFKHKteiGH5'))GROUP BY 1)SELECTc.day AS block_day,COALESCE(d.mint_amount, 0) AS mint_amount,COALESCE(d.burn_amount, 0) AS burn_amount,COALESCE(d.mint_amount, 0) + COALESCE(d.burn_amount, 0) AS net_supply_changeFROM calendar cLEFT JOIN daily dON c.day = d.block_dayORDER BY 1;