Query editor
SELECTSUM(CASEWHEN block_time > NOW() - INTERVAL '24' hourTHEN amount_usdEND) AS volume_24h,SUM(CASEWHEN block_time > NOW() - INTERVAL '7' dayTHEN amount_usdEND) AS volume_7d,SUM(CASEWHEN block_time > NOW() - INTERVAL '30' dayTHEN amount_usdEND) AS volume_30d,SUM(CASEWHEN block_time > NOW() - INTERVAL '90' dayTHEN amount_usdEND) AS volume_90dFROM dex.tradesWHERE blockchain = 'mantle';