Query editor
WITH base AS (SELECTtaker,CASEWHEN token_bought_symbol IN ('ETH','WETH') OR token_sold_symbol IN ('ETH','WETH') THEN 'ETH'WHEN token_bought_symbol IN ('BTC','WBTC','CBBTC','TBTC') OR token_sold_symbol IN ('BTC','WBTC','CBBTC','TBTC') THEN 'BTC'END AS asset,amount_usd,CASEWHEN token_bought_symbol IN ('ETH','WETH','BTC','WBTC','CBBTC','TBTC') THEN amount_usdWHEN token_sold_symbol IN ('ETH','WETH','BTC','WBTC','CBBTC','TBTC') THEN -amount_usdELSE 0END AS signed_usdFROM dex.tradesWHERE blockchain = 'ethereum'AND block_month >= date_trunc('month', CURRENT_DATE - INTERVAL '7' DAY)AND block_date >= CURRENT_DATE - INTERVAL '7' DAYAND amount_usd IS NOT NULLAND (token_bought_symbol IN ('ETH','WETH','BTC','WBTC','CBBTC','TBTC')OR token_sold_symbol IN ('ETH','WETH','BTC','WBTC','CBBTC','TBTC'))),agg AS (SELECTCONCAT('0x', lower(to_hex(taker))) AS address,asset,SUM(amount_usd) AS gross_usd_7d,SUM(signed_usd) AS net_usd_7d,COUNT(*) AS trades_7dFROM baseWHERE asset IS NOT NULLGROUP BY 1,2)SELECTaddress,asset,gross_usd_7d,net_usd_7d,trades_7dFROM aggWHERE gross_usd_7d >= 5000000ORDER BY gross_usd_7d DESCLIMIT 200