Query editor
WITH first_trade AS (SELECTtx_from,MIN(block_date) AS first_dayFROM dex.tradesWHERE blockchain = 'mantle'GROUP BY tx_from),daily_traders AS (SELECTblock_date AS day,tx_fromFROM dex.tradesWHERE blockchain = 'mantle'AND block_time >= NOW() - INTERVAL '90' dayGROUP BY block_date, tx_from)SELECTd.day,COUNT(DISTINCT d.tx_from) AS total_traders,COUNT(DISTINCT CASEWHEN f.first_day = d.day THEN d.tx_fromEND) AS new_traders,COUNT(DISTINCT CASEWHEN f.first_day < d.day THEN d.tx_fromEND) AS returning_tradersFROM daily_traders dJOIN first_trade fON d.tx_from = f.tx_fromGROUP BY d.dayORDER BY d.day;