Query editor
SELECT DISTINCT DATE_TRUNC('day' ,block_time) AS "day",COUNT(DISTINCT VARBINARY_LTRIM(topic2)) OVER (PARTITION BY DATE_TRUNC('day' ,block_time)) AS unique_lp_count,COUNT(DISTINCT VARBINARY_LTRIM(topic2)) OVER (ORDER BY DATE_TRUNC('day' ,block_time)) AS total_unique_lpFROM hyperevm.logsWHERE 1=1AND contract_address = 0xead19ae861c29bbb2101e834922b2feee69b9091AND topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3efAND VARBINARY_LTRIM(topic2) != 0xORDER BY 1 DESC