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 (SELECTfrom_owner AS sender,MIN(block_time) AS first_timeFROM tokens_solana.transfersWHERE block_time >= DATE '2022-03-02'AND token_mint_address = '7i5KKsX2weiTkry7jA4ZwSuXGhs5eJBEjY8vVxR4pfRx'AND (to_owner = 'STEPNwUmvdCWRm4yzH4rtCuPUeKuEapFvFKHKteiGH5'OR to_owner = 'STEPNq2UGeGSzCyGVr2nMQAzf8xuejwqebd84wcksCK')AND from_owner != 'Dqb8pfMEtnjN2K7cN3fWVhZFXqmaRhZXN6y9b9RDSH55'GROUP 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;