count(DISTINCT TX_HASH) as bridge_tx,

sum(AMOUNT_USD)as total_value_tf,

COUNT(DISTINCT CASE

WHEN direction = 'inbound' THEN destination_address

ELSE source_address

END) AS users

FROM near.defi.ez_bridge_activity

WHERE platform = 'rainbow'