Query editor
SELECTproject AS dex,SUM(CASE WHEN block_time > NOW() - INTERVAL '24' hourTHEN amount_usd END) AS volume_24h,SUM(CASE WHEN block_time > NOW() - INTERVAL '7' dayTHEN amount_usd END) AS volume_7d,SUM(CASE WHEN block_time > NOW() - INTERVAL '30' dayTHEN amount_usd END) AS volume_30d,SUM(CASE WHEN block_time > NOW() - INTERVAL '90' dayTHEN amount_usd END) AS volume_90dFROM dex.tradesWHERE blockchain = 'mantle'GROUP BY projectORDER BY volume_24h DESC;