case when DESTINATION_CHAIN is null then 'unknown' else DESTINATION_CHAIN end as DESTINATION_CHAIN,

SUM(AMOUNT_IN_USD) AS total_volume,

COUNT(DISTINCT TX_HASH) AS total_transactions,

COUNT(DISTINCT CASE WHEN direction = 'inbound' THEN RECEIVER ELSE SENDER END) AS unique_users

FROM aptos.defi.ez_bridge_activity

WHERE direction = 'inbound'

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

GROUP BY DESTINATION_CHAIN

ORDER BY total_volume DESC;