Query editor
SELECTproject_contract_address AS pool,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 ((token_sold_symbol = 'ETH'AND token_bought_symbol = 'USDC')OR(token_sold_symbol = 'USDC'AND token_bought_symbol = 'ETH'))GROUP BY 1ORDER BY volume DESC