SELECT
FOREIGN_CHAIN,
COUNT(DISTINCT SENDER) ACTIVE_USERS
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 2 DESC
LIMIT 10