SELECT

owner,

balance,

ROW_NUMBER() OVER (PARTITION BY owner ORDER BY BLOCK_TIMESTAMP DESC) AS rn

FROM solana.core.fact_token_balances

WHERE MINT = 'cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij'

),

price AS (

SELECT

price

FROM crosschain.price.ez_prices_hourly

WHERE 1 = 1

AND token_address = 'cbbtcf3aa214zXHbiAZQwf4122FBYbraNdFqgw4iMij'

ORDER BY hour DESC

LIMIT 1

SELECT

usd_value_range,

COUNT(*) AS holder_count

FROM (

SELECT

owner,

round(balance, 6) AS amount,

(amount * p.price) AS amount_usd,

CASE

WHEN (amount * p.price) BETWEEN 1 AND 10 THEN '1 - $10'

WHEN (amount * p.price) BETWEEN 10 AND 100 THEN '$10 - $100'

WHEN (amount * p.price) BETWEEN 100 AND 1000 THEN '$100 - $1,000'

WHEN (amount * p.price) BETWEEN 1000 AND 10000 THEN '$1,000 - $10,000'

WHEN (amount * p.price) BETWEEN 10000 AND 100000 THEN '$10,000 - $100,000'

ELSE 'Above $100,000'

END AS usd_value_range

FROM Latest_Transactions

CROSS JOIN price p