DATE_TRUNC('day', block_timestamp) AS date,

CASE

WHEN destination_chain = 'near' THEN 'To Near'

ELSE 'From Near'

END AS direction,

COUNT(DISTINCT tx_hash) AS bridge_tx,

SUM(

CASE

WHEN destination_chain = 'near' THEN amount_usd

ELSE -amount_usd

END

) AS total_value_tf,

COUNT(DISTINCT CASE

WHEN destination_chain = 'near' THEN destination_address

ELSE source_address

END) AS unique_users

near.defi.ez_bridge_activity

WHERE

platform = 'rainbow'

AND block_timestamp > CURRENT_DATE - INTERVAL '{{trading_period}} days'

GROUP BY

DATE_TRUNC('day', block_timestamp),

CASE

WHEN destination_chain = 'near' THEN 'To Near'

ELSE 'From Near'

END

ORDER BY

date ASC, direction;