SELECT

DIRECTION,

COUNT(TX_HASH) AS TRANSACTION_COUNT,

SUM(AMOUNT_USD) AS TOTAL_VOLUME_USD

FROM

near.defi.ez_bridge_activity

WHERE

RECEIPT_SUCCEEDED = TRUE AND AMOUNT_USD IS NOT NULL

GROUP BY

DIRECTION

),

netflow_summary AS (

SELECT

SUM(CASE WHEN DIRECTION = 'inbound' THEN TOTAL_VOLUME_USD ELSE 0 END) AS INFLOW_USD,

SUM(CASE WHEN DIRECTION = 'outbound' THEN TOTAL_VOLUME_USD ELSE 0 END) AS OUTFLOW_USD

FROM

inflow_outflow

SELECT

INFLOW_USD,

OUTFLOW_USD,

INFLOW_USD - OUTFLOW_USD AS NETFLOW_USD

FROM

netflow_summary