source_chain,

SUM(amount) AS total_value_transferred

FROM

AXELAR.defi.ez_bridge_squid

WHERE block_timestamp::date = current_date - 1

GROUP BY

source_chain

ORDER BY

total_value_transferred DESC;