Query editor
SELECT destination_chain_key, source_chain_key, destination_contract, source_contract, project, count(*) AS msgs, max(ts_destination) AS last_ts, sum(coalesce(usd_value,0)) AS usd_value FROM layerzero.messages WHERE lower(destination_chain_key) LIKE '%aptos%' OR lower(source_chain_key) LIKE '%aptos%' GROUP BY 1,2,3,4,5 ORDER BY msgs DESC LIMIT 100