Query editor
--GOAL IS TO COMBINE DEX PERFORMANCES ON ETHEREUM OVER THE LAST ONE YEARWITH dex_metrics AS(SELECTproject,COUNT (*) AS num_trades,SUM(amount_usd) AS total_volume_usd,AVG(amount_usd) AS avg_trade_volume_usd,COUNT(DISTINCT token_pair) AS num_token_pairsFROM dex.tradesWHERE block_time >= CURRENT_DATE - INTERVAL '365' DAYAND blockchain = 'ethereum'GROUP BY project)SELECTproject,num_trades,total_volume_usd,avg_trade_volume_usd,num_token_pairsFROM dex_metricsORDER BY total_volume_usd DESCLIMIT 10