SELECT

token_address,

ANY_VALUE(symbol) AS symbol,

COUNT(DISTINCT tx_hash) AS "Bridges From Aptos Count"

FROM

aptos.defi.ez_bridge_activity

WHERE

DATE_TRUNC('month', block_timestamp) = DATE_TRUNC('month', CURRENT_DATE)

AND source_chain = 'Aptos'

GROUP BY

token_address

token_address,

symbol,

"Bridges From Aptos Count"

top_tokens_from_aptos

ORDER BY

"Bridges From Aptos Count" DESC

5;