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("from" = 0x0000000000000000000000000000000000000000AND "to" = 0xe43d186D9Fd6b35eeB546da2e09361905EA22560,amount,0)) AS mint_amount,-SUM(IF("from" = 0xe43d186D9Fd6b35eeB546da2e09361905EA22560AND "to" = 0x0000000000000000000000000000000000000000,amount,0)) AS burn_amountFROM tokens.transfersWHERE block_time >= current_date - INTERVAL '90' DAYAND blockchain = 'polygon'AND contract_address = 0xc289a1684a04faaf926204235588f5fc1d5e458eAND (("from" = 0x0000000000000000000000000000000000000000AND "to" = 0xe43d186D9Fd6b35eeB546da2e09361905EA22560)OR ("from" = 0xe43d186D9Fd6b35eeB546da2e09361905EA22560AND "to" = 0x0000000000000000000000000000000000000000))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;