-- forked from Kruys-Collins / axelar Total Interchain Transfer Volume @ https://flipsidecrypto.xyz/Kruys-Collins/q/oD5VwLBac8yL/axelar-total-interchain-transfer-volume
SELECT
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'