Query editor
WITH family_rows AS (SELECTCASE WHEN strategy LIKE 'DODO%' THEN 'DODO / secondary-pool arbitrage'ELSE 'Uniswap V4 / V3 arbitrage' END AS strategy_family,transactions, borrowed_usd, gross_profit_usd, gas_cost_usd,estimated_net_profit_usd AS net_profit_usd,avg_net_profit_usd, median_net_profit_usd, p95_net_profit_usd,profitable_tx_pctFROM "query_8700050"UNION ALLSELECT 'Kyber-routed arbitrage' AS strategy_family,transactions, borrowed_usd, gross_profit_usd, gas_cost_usd,conservative_net_profit_usd AS net_profit_usd,avg_net_profit_usd, median_net_profit_usd, p95_net_profit_usd,profitable_tx_pctFROM "query_8700071"),family_summary AS (SELECT strategy_family,SUM(transactions) AS transactions,SUM(borrowed_usd) AS borrowed_usd,SUM(gross_profit_usd) AS gross_profit_usd,SUM(gas_cost_usd) AS gas_cost_usd,SUM(net_profit_usd) AS verified_net_profit_usd,SUM(net_profit_usd) / SUM(transactions) AS avg_net_profit_usd,SUM(transactions * median_net_profit_usd) / SUM(transactions) AS weighted_median_indicator_usd,SUM(transactions * p95_net_profit_usd) / SUM(transactions) AS weighted_p95_indicator_usd,SUM(transactions * profitable_tx_pct) / SUM(transactions) AS profitable_tx_pctFROM family_rowsGROUP BY 1),total AS (SELECT 'TOTAL — verified lower bound' AS strategy_family,SUM(transactions), SUM(borrowed_usd), SUM(gross_profit_usd), SUM(gas_cost_usd),SUM(verified_net_profit_usd), SUM(verified_net_profit_usd) / SUM(transactions),SUM(transactions * weighted_median_indicator_usd) / SUM(transactions),SUM(transactions * weighted_p95_indicator_usd) / SUM(transactions),SUM(transactions * profitable_tx_pct) / SUM(transactions)FROM family_summary)SELECT * FROM family_summaryUNION ALL SELECT * FROM totalORDER BY CASE WHEN strategy_family LIKE 'TOTAL%' THEN 2 ELSE 1 END, verified_net_profit_usd DESC