Query editor
-- first_tx_90d_fixed (UTC: 2025-08-13 ~ 2025-11-11)WITH user_day AS (SELECTtaker,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')SELECTtaker,MIN(tx_date) AS cohort_dateFROM user_dayGROUP BY taker