destination_chain,

SUM(amount) AS total_value_transferred

FROM

axelar.defi.ez_bridge_squid

WHERE block_timestamp::date = current_date - 1

GROUP BY

destination_chain

ORDER BY

total_value_transferred DESC;