yasminTop Sources by transactions
    Updated 2024-11-25
    SELECT
    "sourceChain",
    "TXs Count"
    FROM (
    SELECT
    CAST(DATA:confirm:sourceChain AS VARCHAR) AS "sourceChain",
    COUNT(DISTINCT call:transactionHash) AS "TXs Count"
    FROM
    axelar.axelscan.fact_gmp
    GROUP BY
    DATA:confirm:sourceChain
    UNION ALL
    SELECT
    CAST(source_chain AS VARCHAR) AS "sourceChain",
    COUNT(DISTINCT SEND:txhash) AS "TXs Count"
    FROM
    axelar.axelscan.fact_transfers
    GROUP BY
    source_chain
    ) AS combined
    ORDER BY
    "TXs Count" DESC
    LIMIT
    5;



    QueryRunArchived: QueryRun has been archived