SELECT

LOWER('0x' || SUBSTR(topics[1], 27)) AS from_address,

LOWER('0x' || SUBSTR(topics[2], 27)) AS to_address,

CAST(ethereum.public.udf_hex_to_int(SUBSTRING(data, 3, 64)) AS FLOAT) / POWER(10, 8) AS amount

FROM avalanche.core.ez_decoded_event_logs

WHERE event_name = 'Transfer'

AND contract_address = LOWER('0x7c6a937943f135283a2561938de2200994a8f7a7')

),

address_balances AS (

SELECT

address,

SUM(CASE WHEN direction = 'in' THEN amount ELSE -amount END) AS balance

FROM (

SELECT to_address AS address, amount, 'in' AS direction

FROM transfers

WHERE to_address != '0x0000000000000000000000000000000000000000'

UNION ALL

SELECT from_address AS address, amount, 'out' AS direction

FROM transfers

WHERE from_address != '0x0000000000000000000000000000000000000000'

) t

GROUP BY address

HAVING balance > 0

SELECT

COUNT(DISTINCT address) AS "Total Note Holders"

FROM address_balances;