Query editor
SELECTproject_contract_address,SUM(amount_usd) AS volume_usd,SUM(amount_usd) * 1.0 /SUM(SUM(amount_usd)) OVER () AS dominance_ratioFROM dex.tradesWHERE block_time > NOW() - INTERVAL '30' dayGROUP BY 1ORDER BY volume_usd DESC;
Query editor
1SELECT2project_contract_address,3SUM(amount_usd) AS volume_usd,4SUM(amount_usd) * 1.0 /5SUM(SUM(amount_usd)) OVER () AS dominance_ratio6FROM dex.trades7WHERE block_time > NOW() - INTERVAL '30' day8GROUP BY 19ORDER BY volume_usd DESC;10