SELECT

direction,

token_address,

SUM(CASE WHEN direction = 'inbound' THEN amount_unadj ELSE 0 END) AS usdt_received,

SUM(CASE WHEN direction = 'outbound' THEN amount_unadj ELSE 0 END) AS usdt_sent

FROM aptos.defi.fact_bridge_activity

WHERE token_address = '0x4ecaba5870353805a9f068101a40e0f32ed605c6'

GROUP BY direction, token_address

SUM(usdt_received) AS total_usdt_inbound,

SUM(usdt_sent) AS total_usdt_outbound,

SUM(usdt_received) - SUM(usdt_sent) AS net_usdt_flow

FROM usdt_bridge;