source_chain,

COUNT(*) AS transaction_count

FROM

AXELAR.defi.ez_bridge_squid

WHERE block_timestamp::date = current_date - 1

GROUP BY

source_chain

ORDER BY

transaction_count DESC;