(d.symbol) as symbol,

sum(f.raw_amount_precise) as total_amount

FROM base.core.ez_token_transfers d

JOIN base.core.fact_token_transfers f on d.tx_hash = f.tx_hash

GROUP BY symbol

ORDER BY total_amount DESC