a.currency,

token_name,

symbol,

count(*) as events

FROM sei.core.fact_transfers as a

left outer JOIN sei.core.dim_tokens as b

on a.CURRENCY = b.CURRENCY

GROUP BY 1,2,3

ORDER BY 4 DESC

LIMIT 500