Query editor
SELECTCASEWHEN project_contract_address =from_hex('88e6a0c2ddd26feeb64f039a2c41296fcb3f5640')THEN '0.05%'WHEN project_contract_address =from_hex('8ad599c3a0ff1de082011efddc58f1908eb6e6d8')THEN '0.3%'END AS fee_tier,ROUND(SUM(amount_usd), 2) AS volume,COUNT(*) AS trades,ROUND(AVG(amount_usd), 2) AS avg_trade_size,ROUND(SUM(amount_usd) * 0.0005,2) AS estimated_fee_005,ROUND(SUM(amount_usd) * 0.003,2) AS estimated_fee_03FROM dex.tradesWHERE block_time >= now() - interval '7' dayAND project = 'uniswap'AND project_contract_address IN (from_hex('88e6a0c2ddd26feeb64f039a2c41296fcb3f5640'),from_hex('8ad599c3a0ff1de082011efddc58f1908eb6e6d8'))GROUP BY 1ORDER BY volume DESC