Query editor
WITH first_trade AS (SELECTtx_from,MIN(block_time) AS first_timeFROM dex.tradesWHERE project = 'uniswap'GROUP BY tx_from)SELECTdate_trunc('day', first_time) AS day,COUNT(*) AS new_usersFROM first_tradeWHERE first_time >= now() - interval '30' dayGROUP BY 1ORDER BY 1