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

near.defi.ez_bridge_activity

platform = 'rainbow'

AND BLOCK_TIMESTAMP > CURRENT_DATE - INTERVAL '{{trading_period}} days';