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