Query editor
WITH user_day AS (SELECT taker, date_trunc('day', block_time) AS tx_dateFROM dex.tradesWHERE block_time >= DATE '2025-08-13'AND block_time < DATE '2025-11-12'AND project='uniswap' AND blockchain='ethereum'),first_tx AS (SELECT taker, MIN(tx_date) AS cohort_dateFROM user_day GROUP BY taker)SELECTCAST(date_trunc('week', cohort_date) AS DATE) AS week_start,COUNT(*) AS new_usersFROM first_txGROUP BY 1ORDER BY 1