Query editor
1SELECT2project,3 4 COUNT(DISTINCT taker) AS daily_unique_taker5FROM dex.trades6WHERE blockchain = 'sei'7 AND block_time >= CURRENT_TIMESTAMP - INTERVAL '30' day8GROUP BY project9ORDER BY daily_unique_taker desc;
SELECT
project,
COUNT(DISTINCT taker) AS daily_unique_taker
FROM dex.trades
WHERE blockchain = 'sei'
AND block_time >= CURRENT_TIMESTAMP - INTERVAL '30' day
GROUP BY project
ORDER BY daily_unique_taker desc;