token_symbol,

COUNT(*) AS transaction_count

FROM

AXELAR.defi.ez_bridge_squid

WHERE block_timestamp::date = current_date - 1

GROUP BY

token_symbol

ORDER BY

transaction_count DESC;