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("to" = 0xf1b0Cd330EE95d343af932Eda8f97BC26614A294, amount, 0)) AS in_amount,-SUM(IF("from" = 0xf1b0Cd330EE95d343af932Eda8f97BC26614A294, amount, 0)) AS out_amountFROM tokens.transfersWHERE block_time >= current_date - INTERVAL '90' DAYAND blockchain = 'polygon'AND contract_address = 0x714db550b574b3e927af3d93e26127d15721d4c2AND (("from" != 0x0000000000000000000000000000000000000000AND "from" != 0x8b31d6018D2Ee253379E98475C59C934549e62b0AND "to" = 0xf1b0Cd330EE95d343af932Eda8f97BC26614A294)OR ("from" = 0xf1b0Cd330EE95d343af932Eda8f97BC26614A294AND "to" != 0x8b31d6018D2Ee253379E98475C59C934549e62b0AND "to" != 0xFf8138EA647E78EC1e613213D7850C38B4D4d348))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;