SELECT
token_address,
symbol,
SUM(COALESCE(amount_usd, 0)) AS total_outflow
FROM
near.defi.ez_bridge_activity
WHERE
LOWER(source_chain) = 'near'
AND block_timestamp BETWEEN '2023-01-01' AND '2024-12-31'
GROUP BY
token_address, symbol
ORDER BY
total_outflow DESC
LIMIT 10;