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 in_amount,-SUM(IF(action != 'burn'AND from_owner = 'STEPNwUmvdCWRm4yzH4rtCuPUeKuEapFvFKHKteiGH5',amount / POWER(10, 9),0)) AS out_amountFROM tokens_solana.transfersWHERE block_time >= current_date - INTERVAL '90' DAYAND token_mint_address = 'AFbX8oGjGpmVFywbVouvhQSRmiW2aR1mohfahi4Y2AdB'AND ((action != 'mint'AND to_owner = 'STEPNwUmvdCWRm4yzH4rtCuPUeKuEapFvFKHKteiGH5')OR (action != 'burn'AND from_owner = 'STEPNwUmvdCWRm4yzH4rtCuPUeKuEapFvFKHKteiGH5'))GROUP BY 1)SELECTc.day AS block_day,COALESCE(d.in_amount, 0) AS in_amount,COALESCE(d.out_amount, 0) AS out_amount,COALESCE(d.in_amount, 0) + COALESCE(d.out_amount, 0) AS net_changeFROM calendar cLEFT JOIN daily dON c.day = d.block_dayORDER BY 1;