Query editor
SELECTDATE_TRUNC('day', block_time) AS day,project AS protocol,SUM(amount_usd) AS volume_usd,COUNT(*) AS trade_count,COUNT(DISTINCT taker) AS unique_tradersFROM dex.tradesWHEREblockchain = 'ethereum'AND block_time >= NOW() - INTERVAL '30' DAYAND amount_usd IS NOT NULLAND amount_usd > 0GROUP BY 1, 2ORDER BY 1 DESC, 3 DESC