SELECT

TX_HASH,

AMOUNT_USD,

SOURCE_CHAIN,

DESTINATION_CHAIN,

CASE

WHEN direction = 'inbound' THEN destination_address

ELSE source_address

END AS user_address,

DATE_TRUNC('{{granularity }}', BLOCK_TIMESTAMP) AS date

FROM

near.defi.ez_bridge_activity

WHERE

platform = 'rainbow'

AND BLOCK_TIMESTAMP > CURRENT_DATE - INTERVAL '{{trading_period}} days';

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

date,

COUNT(DISTINCT tx_hash) AS bridge_tx,

COUNT(DISTINCT user_address) AS users,

SUM(amount_usd) AS volume_tf,

data

GROUP BY

route, date

ORDER BY

date DESC, volume_tf DESC;