Query editor
WITH calendar AS (SELECT dayFROM UNNEST(sequence(current_date - INTERVAL '90' DAY,current_date,INTERVAL '1' DAY)) AS t(day)),first_in_all_time AS (SELECT"from" AS sender,MIN(block_time) AS first_timeFROM tokens.transfersWHERE block_time >= DATE '2024-12-02'AND blockchain = 'polygon'AND contract_address = 0x714db550b574b3e927af3d93e26127d15721d4c2AND "to" = 0xe43d186D9Fd6b35eeB546da2e09361905EA22560AND "from" != 0x0000000000000000000000000000000000000000AND "from" != 0x8b31d6018D2Ee253379E98475C59C934549e62b0GROUP BY 1),daily_counts AS (SELECTCAST(date_trunc('day', first_time) AS DATE) AS day,COUNT(*) AS new_depositersFROM first_in_all_timeWHERE first_time >= current_date - INTERVAL '90' DAYGROUP BY 1)SELECTc.day,COALESCE(d.new_depositers, 0) AS new_depositersFROM calendar cLEFT JOIN daily_counts dON c.day = d.dayORDER BY 1;