Query editor
-- Total Ethereum DEX Volume, Daily, All Protocols, Historical-- Sygnum Bank AG, Digital Asset ResearchSELECTDATE_TRUNC('day', block_time) AS day,SUM(amount_usd) AS daily_volume_usd,COUNT(*) AS trade_count,COUNT(DISTINCT taker) AS unique_takers,COUNT(DISTINCT project) AS active_protocolsFROM dex.tradesWHERE blockchain = 'ethereum'AND block_time >= TIMESTAMP '2020-01-01'AND amount_usd > 0AND amount_usd < 100000000GROUP BY 1ORDER BY 1 DESC