tx_hash,

sender,

platform,

symbol,

TO_CHAR(amount_in_usd, '$999,999,999') AS Amount,

source_chain,

destination_chain,

block_timestamp AS bridged_date,

CASE

WHEN DATEDIFF(DAY, block_timestamp::DATE, CURRENT_DATE) = 0 THEN 'Today'

WHEN DATEDIFF(DAY, block_timestamp::DATE, CURRENT_DATE) = 1 THEN 'Yesterday'

ELSE TO_CHAR(DATEDIFF(DAY, block_timestamp::DATE, CURRENT_DATE)) || ' days ago'

END AS days_ago

FROM

aptos.defi.ez_bridge_activity

WHERE

block_timestamp >= current_date - 7

AND (LOWER(source_chain) = 'aptos' OR LOWER(destination_chain) = 'aptos') -- To/From Aptos

AND amount_in_usd is not null

ORDER BY

amount_in_usd DESC -- Sort by the largest amounts

LIMIT 5;