feyikemiAxelar 2024 users
    Updated 2024-07-25
    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
    QueryRunArchived: QueryRun has been archived