FOREIGN_CHAIN,

COUNT(DISTINCT TX_ID) txn_count,

SUM(CAST(AMOUNT AS DECIMAL) / POWER(10, DECIMAL)) AS Total_Transfer_Volume

FROM

axelar.core.fact_transfers

WHERE

TX_SUCCEEDED = TRUE;

AND transfer_type != 'AXELAR'

AND foreign_chain IS NOT NULL

GROUP BY 1

ORDER BY 2 DESC

LIMIT 10