CASE

WHEN source_chain = 'polygon' THEN destination_chain

ELSE source_chain

END AS interacting_chain,

COUNT(*) AS transaction_count,

SUM(amount) AS total_volume

FROM

AXELAR.defi.ez_bridge_squid

WHERE

source_chain = 'polygon'

OR destination_chain = 'polygon'

AND BLOCK_TIMESTAMP >= '2024-01-01'

AND BLOCK_TIMESTAMP < CURRENT_DATE

GROUP BY

interacting_chain

ORDER BY

transaction_count DESC;