rezarwzsource chain metrics Total
    Updated 2025-03-07
    WITH total_Data AS (
    SELECT
    CREATED_AT,
    CAST(CALL:returnValues:destinationChain AS STRING) AS DESTINATION_CHAIN,
    CAST(CALL:chain AS STRING) AS SOURCE_CHAIN,
    CONCAT(
    CAST(CALL:chain AS STRING),
    ' -> ',
    CAST(CALL:returnValues:destinationChain AS STRING)
    ) AS path,
    COALESCE(CAST(data:value AS FLOAT), 0) AS volume,
    CAST(id AS STRING) AS id,
    lower(COALESCE(CAST(CALL:receipt:from AS STRING),CAST(call:transaction:from as STRING))) as user_address,
    CAST(TIME_SPENT:total AS FLOAT) AS TIME_SPENT
    FROM axelar.axelscan.fact_gmp
    UNION ALL
    SELECT
    CREATED_AT AS Date,
    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
    )
    QueryRunArchived: QueryRun has been archived