Query editor
/*Table(s): dex.tradesReason: Based on general keywordsTable(s): perpetual.tradesReason: Curated dataset recommendationsTable(s): derpdex_base.Pair_evt_Swap, perp_gnosis.Amm_evt_SwapInput, perp_gnosis.ClearingHouse_evt_PositionChanged, derpdex_v1_zksync.UniswapV3Pair_evt_Swap, perp_gnosis.Amm_evt_SwapOutputReason: Based on contract addresses or possible project names*/SELECTproject,SUM(volume_usd) AS total_volume_usdFROM perpetual.tradesGROUP BYprojectORDER BYtotal_volume_usd DESC