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

BLOCK_TIMESTAMP :: DATE >= '2024-01-01'

AND TX_SUCCEEDED = TRUE;

AND transfer_type != 'AXELAR'

AND foreign_chain IS NOT NULL

GROUP BY 1

ORDER BY 3 DESC

LIMIT 10