SELECT

to_address AS address,

SUM(raw_amount * 1e-18) AS balance,

MAX(SYMBOL) AS symbol

FROM optimism.core.ez_token_transfers

WHERE CONTRACT_ADDRESS = '0xf1a0da3367bc7aa04f8d94ba57b862ff37ced174'

GROUP BY 1

),

outgoing AS (

SELECT

from_address AS address,

SUM(raw_amount * -1e-18) AS balance,

MAX(SYMBOL) AS symbol

FROM optimism.core.ez_token_transfers

WHERE CONTRACT_ADDRESS = '0xf1a0da3367bc7aa04f8d94ba57b862ff37ced174'

GROUP BY 1

),

unioned AS (

SELECT * FROM incoming

UNION ALL

SELECT * FROM outgoing

),

totals AS (

SELECT address, SUM(balance) AS balance, MAX(symbol) AS symbol

FROM unioned

GROUP BY 1

),

formatted_totals AS (

SELECT

address,

TO_CHAR(ROUND(balance), '999,999,999') AS formatted_balance,

balance,

symbol

FROM totals