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

)