Query editor
SELECT DATE_TRUNC('day', block_time) AS "day",COUNT(DISTINCT tx_from) OVER (PARTITION BY DATE_TRUNC('day', block_time)) AS daily_unique_traders,COUNT(DISTINCT tx_from) OVER (ORDER BY DATE_TRUNC('day', block_time)) AS total_unique_tradersFROM dex.tradesWHERE 1=1AND blockchain = 'hyperevm'AND project = 'prjx'ORDER BY "day" DESC