SELECT

e.event_name,

e.decoded_log,

e.DECODED_LOG:"token"::TEXT AS token_address,

COALESCE(l.ADDRESS_NAME, 'Unknown Token') AS token_name, -- Assign token name if available

SUM(

CASE

WHEN e.DECODED_LOG:"amount"::NUMBER IS NOT NULL THEN e.DECODED_LOG:"amount"::NUMBER

ELSE e.DECODED_LOG:"amountIn"::NUMBER

END

) / 1e18 AS total_bridged_in

FROM ink.core.ez_decoded_event_logs e

LEFT JOIN ink.core.dim_labels l

ON e.DECODED_LOG:"token"::TEXT = l.ADDRESS

WHERE e.event_name ILIKE '%Bridge%'

GROUP BY 1, 2, 3, 4

ORDER BY total_bridged_in DESC;