SELECT

FROM_ADDRESS,

TO_ADDRESS,

AMOUNT

FROM kaia.core.ez_token_transfers

WHERE CONTRACT_ADDRESS = LOWER('0x42952b873ed6f7f0a7e4992e2a9818e3a9001995')

),

balances AS (

SELECT

address,

SUM(balance_change) as balance

FROM (

SELECT TO_ADDRESS as address, AMOUNT as balance_change FROM token_transfers

UNION ALL

SELECT FROM_ADDRESS as address, -AMOUNT as balance_change FROM token_transfers

)

GROUP BY address

SELECT

CASE

WHEN balance > 100000 THEN '> 100,000'

WHEN balance > 10000 THEN '10,000 - 100,000'

WHEN balance > 1000 THEN '1,000 - 10,000'

WHEN balance > 100 THEN '100 - 1,000'

WHEN balance >= 1 THEN '1 - 100'

ELSE '< 1'

END as balance_range,

COUNT(DISTINCT address) as number_of_holders

FROM balances

WHERE balance > 0

GROUP BY 1

ORDER BY

CASE balance_range

WHEN '> 100,000' THEN 1

WHEN '10,000 - 100,000' THEN 2