SELECT
blockchain
, destination_chain
, count(DISTINCT tx_hash) AS txs
, sum(amount_usd) AS volume
, count(DISTINCT source_address) AS source_address
FROM
crosschain.defi.ez_bridge_activity
WHERE 1=1
AND platform = 'stargate'
GROUP BY
1
, 2
ORDER BY
3 DESC