SELECT

t1.ID,

t1.CREATED_AT,

t1.SEND_AMOUNT,

t1.SEND_AMOUNT_RECEIVED,

t1.SEND_FEE,

t1.SEND_DENOM,

t1.SOURCE_CHAIN,

t1.DESTINATION_CHAIN,

t1.SENDER_ADDRESS,

t1.RECIPIENT_ADDRESS,

t1.LINK,

t2.BLOCK_TIMESTAMP,

t2.TX_HASH,

t2.SENDER,

t2.TOKEN_SYMBOL,

t2.AMOUNT,

t2.RECEIVER,

t2.EZ_BRIDGE_SQUID_ID

FROM

axelar.axelscan.fact_transfers t1

JOIN

axelar.core.fact_transfers t2

ON

t1.LINK = t2.TX_HASH

AND t1.SENDER_ADDRESS = t2.SENDER

AND t1.RECIPIENT_ADDRESS = t2.RECEIVER

AND t1.SOURCE_CHAIN = t2.SOURCE_CHAIN

AND t1.DESTINATION_CHAIN = t2.DESTINATION_CHAIN

WHERE

t2.EZ_BRIDGE_SQUID_ID IS NOT NULL

),

TransactionMetrics AS (

SELECT