SELECT

DATE_TRUNC('{{Time_Frame}}', CREATED_AT) AS Date,

lower(CALL:chain) AS srcchain,

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

COUNT(id) AS gmp_txs

FROM

axelar.axelscan.fact_gmp

GROUP BY

1,

2

),

token_transfer_data AS (

SELECT

DATE_TRUNC('{{Time_Frame}}', CREATED_AT) AS Date,

lower(SOURCE_CHAIN) as 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

)

GROUP BY

1,

2