SELECT
COUNT(DISTINCT TX_ID) txn_count,
COUNT(DISTINCT SENDER) ACTIVE_USERS,
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'