rezarwzsource chain metrics Transfers
    Updated 2025-03-07
    WITH total_Data AS (
    SELECT
    CREATED_AT,
    CAST(DESTINATION_CHAIN AS STRING) AS DESTINATION_CHAIN,
    CAST(SOURCE_CHAIN AS STRING) AS SOURCE_CHAIN,
    CONCAT(
    CAST(SOURCE_CHAIN AS STRING),
    ' -> ',
    CAST(DESTINATION_CHAIN AS STRING)
    ) AS path,
    COALESCE(CAST(send:value AS FLOAT), 0) AS volume,
    CAST(id AS STRING) AS id,
    lower(CAST(SENDER_ADDRESS AS STRING)) AS user_address,
    CAST(DATA:time_spent.total AS FLOAT) AS TIME_SPENT
    FROM axelar.axelscan.fact_transfers
    WHERE
    NOT (
    (
    TYPEOF(link:price) = 'ARRAY'
    AND ARRAY_SIZE(link:price) = 0
    )
    OR (
    TYPEOF(SEND_AMOUNT) = 'ARRAY'
    AND ARRAY_SIZE(SEND_AMOUNT) = 0
    )
    )
    OR send:value IS NULL
    ),
    total_metrics AS (
    SELECT
    SOURCE_CHAIN,
    COUNT(id) AS "Total Transactions",
    SUM(VOLUME) AS "Total Volume",
    COUNT(DISTINCT user_Address) AS "Total Users"
    FROM total_Data
    WHERE SOURCE_CHAIN IS NOT NULL
    QueryRunArchived: QueryRun has been archived