with transfers as (

SELECT

address

, sum(amount) as balance

FROM (

SELECT

FROM_ADDRESS as address

, -sum(RAW_AMOUNT) as amount

FROM arbitrum.core.fact_token_transfers

WHERE CONTRACT_ADDRESS = '0x1509706a6c66CA549ff0cB464de88231DDBe213B'

GROUP BY 1

UNION ALL

SELECT

TO_ADDRESS as address

, sum(RAW_AMOUNT) as amount

FROM arbitrum.core.fact_token_transfers

WHERE CONTRACT_ADDRESS = '0x1509706a6c66CA549ff0cB464de88231DDBe213B'

GROUP BY 1

)

GROUP BY 1

SELECT

tr.address as holder

, l.ADDRESS_NAME

, balance as current_balance

from transfers tr

LEFT join arbitrum.core.dim_labels l ON tr.address = l.address

WHERE balance > 0

ORDER BY 3 DESC

LIMIT 100