Query editor
1SELECT2 block_date AS day,3 COUNT(DISTINCT tx_from) AS daily_active_traders4FROM dex.trades5WHERE blockchain = 'mantle'6 AND block_time >= NOW() - INTERVAL '90' day7GROUP BY block_date8ORDER BY day;9
SELECT
block_date AS day,
COUNT(DISTINCT tx_from) AS daily_active_traders
FROM dex.trades
WHERE blockchain = 'mantle'
AND block_time >= NOW() - INTERVAL '90' day
GROUP BY block_date
ORDER BY day;