CASE

WHEN lb.balance > 1000 THEN '+1k mSOL (Whales)' -- Extremely large holders

WHEN lb.balance BETWEEN 100 AND 1000 THEN '100-1k mSOL (Dolphins)' -- Large holders

WHEN lb.balance BETWEEN 10 AND 100 THEN '10-100 mSOL (Fish)' -- Medium holders

WHEN lb.balance BETWEEN 1 AND 10 THEN '1-10 mSOL (Shrimps)' -- Small holders

ELSE 'Less Than 1 mSOL (Plankton)' -- Very small or negligible balances

END AS wallet_segment,

COUNT(DISTINCT bw.PROVIDER_ADDRESS) AS num_wallets,

SUM(bw.burned_mSOL) AS total_burned_mSOL,

100 * SUM(bw.burned_mSOL) / SUM(SUM(bw.burned_mSOL)) OVER () AS mSOL_burn_Share

FROM

(

SELECT

PROVIDER_ADDRESS,

SUM(msol_burned) AS burned_mSOL

FROM

solana.marinade.ez_liquid_staking_actions

WHERE

ACTION_TYPE = 'orderUnstake'

AND block_timestamp >= DATEADD(MONTH, -1, CURRENT_DATE)

GROUP BY

PROVIDER_ADDRESS

) bw

LEFT JOIN

(

SELECT

ACCOUNT_ADDRESS,

balance

FROM

solana.core.fact_token_balances

WHERE

mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'

AND SUCCEEDED

AND balance > 0

AND BLOCK_TIMESTAMP = (