SELECT

DATE_TRUNC('day', CREATED_AT) AS Date,

CALL:chain AS srcchain,

SUM(COALESCE(data:value, 0)) AS Gmp_volume,

COUNT(id) AS gmp_txs

FROM

axelar.axelscan.fact_gmp

WHERE

CREATED_AT >= DATEADD(DAY, -90, CURRENT_DATE)

GROUP BY

1,

2

),

token_transfer_data AS (

SELECT

DATE_TRUNC('day', CREATED_AT) AS Date,

SOURCE_CHAIN,

SUM(COALESCE(send:value, 0)) AS token_transfer_USD,

COUNT(id) AS token_transfer_txs

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 link:price IS NULL

OR SEND_AMOUNT IS NULL

)

and CREATED_AT >= DATEADD(DAY, -90, CURRENT_DATE)