CONCAT(source_chain_name, ' -> ', destination_chain_name) AS Bridging_Pathway,

COUNT(*) AS Number_of_Transactions

FROM

aptos.defi.fact_bridge_activity

WHERE

block_timestamp >= DATE_TRUNC('week', CURRENT_DATE) - INTERVAL '1 week'

AND block_timestamp < DATE_TRUNC('week', CURRENT_DATE)

AND source_chain_name ilike ('Aptos')

GROUP BY

source_chain_name, destination_chain_name

ORDER BY

Number_of_Transactions DESC

LIMIT 10;