destination_chain,

SUM(amount_usd) AS volume

FROM

avalanche.defi.ez_bridge_activity

WHERE

DATE(block_timestamp) >= '2024-07-01'

AND DATE(block_timestamp) < '2024-08-01'

AND amount_usd IS NOT NULL

GROUP BY

destination_chain

ORDER BY

2 DESC

LIMIT 20;