sum(amount_usd) as bridged amount,

DIRECTION,

SUM(CASE WHEN DIRECTION = 'inbound' THEN AMOUNT ELSE -AMOUNT END) AS net_value_on_near_chain

FROM near.defi.ez_bridge_activity

GROUP BY DIRECTION;

SELECT *

from near.defi.ez_bridge_activity