SELECT

tx_from AS holder,

-amount AS amt

FROM solana.core.fact_transfers

WHERE mint = 'GxdTh6udNstGmLLk9ztBb6bkrms7oLbrJp5yzUaVpump'

UNION ALL

SELECT

tx_to AS holder,

amount AS amt

FROM solana.core.fact_transfers

WHERE mint = 'GxdTh6udNstGmLLk9ztBb6bkrms7oLbrJp5yzUaVpump'

),

holder_balances AS (

SELECT

holder,

SUM(amt) AS total_balance

FROM token_transfers

GROUP BY holder

HAVING SUM(amt) > 0.01

),

price_data AS (

SELECT

"Current Price (USD)" AS current_price

FROM $query('02f73dcb-57ce-49d6-bdae-fd408369ba33')

SELECT

CASE

WHEN total_balance * price_data.current_price >= 100000 THEN '$100k+'

WHEN total_balance * price_data.current_price >= 50000 THEN '$50k-$100k'

WHEN total_balance * price_data.current_price >= 10000 THEN '$10k-$50k'

WHEN total_balance * price_data.current_price >= 1000 THEN '$1k-$9.9k'

WHEN total_balance * price_data.current_price >= 500 THEN '$500-$999'

WHEN total_balance * price_data.current_price >= 100 THEN '$100-$499'

ELSE 'Under $100'

END AS balance_range,