SELECT

TX_HASH,

AMOUNT_USD,

SOURCE_CHAIN,

DESTINATION_CHAIN,

BLOCK_TIMESTAMP,

CASE

WHEN direction = 'inbound' THEN destination_address

ELSE source_address

END AS user_address

FROM

near.defi.ez_bridge_activity

WHERE

platform = 'rainbow'

SOURCE_CHAIN || ' -> ' || DESTINATION_CHAIN AS route,

COUNT(DISTINCT TX_HASH) AS bridge_tx,

SUM(AMOUNT_USD) AS volume_tf,

COUNT(DISTINCT user_address) AS users

data

GROUP BY

route

ORDER BY

volume_tf DESC;