Destination_chain,

COUNT(tx_hash) AS transactions

FROM

aptos.defi.ez_bridge_activity

WHERE

block_timestamp >= '2024-01-01'

AND token_address = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT'

AND direction = 'outbound'

GROUP BY

Destination_chain

ORDER BY

transactions DESC;