Query editor
SELECTtx_from,SUM(amount_usd) AS volumeFROM dex.tradesWHERE block_time >= now() - interval '7' dayGROUP BY tx_fromHAVING SUM(amount_usd) > 1000000ORDER BY volume DESCLIMIT 20
Query editor
1SELECT2tx_from,3SUM(amount_usd) AS volume4FROM dex.trades5WHERE block_time >= now() - interval '7' day6GROUP BY tx_from7HAVING SUM(amount_usd) > 10000008ORDER BY volume DESC9LIMIT 20