-- SQL credits to Ali3n from Bonk Holders(https://flipsidecrypto.xyz/Ali3N/q/untitled-query-8cTLZA) WITH sol_users AS ( SELECT DISTINCT tx_from AS wallets FROM solana.core.fact_transfers WHERE tx_to = 'RBHdGVfDfMjfU6iUfCb1LczMJcQLx7hGnxbzRsoDNvx' GROUP BY 1 UNION SELECT DISTINCT tx_to AS wallets FROM solana.core.fact_transfers WHERE tx_from = 'RBHdGVfDfMjfU6iUfCb1LczMJcQLx7hGnxbzRsoDNvx' GROUP BY 1 ), wallets AS ( SELECT * FROM sol_users ), balances AS ( SELECT block_timestamp::date AS date, tx_from AS User1, sum (amount)*-1 AS Volume FROM solana.core.fact_transfers WHERE mint = 'RLBxxFkseAZ4RgJH3Sqn8jXxhmGoz9jWxDNJMh8pL7a' GROUP BY 1,2 UNION ALL SELECT block_timestamp::Date AS date, tx_to AS User1, sum (amount) AS Volume FROM solana.core.fact_transfers WHERE mint = 'RLBxxFkseAZ4RgJH3Sqn8jXxhmGoz9jWxDNJMh8pL7a' GROUP BY 1,2 ), balance_table AS ( SELECT date, User1, sum (Volume) AS balance, sum (balance) over (partition BY User1 ORDER BY date rows BETWEEN unbounded preceding AND current row) AS User_balance FROM balances WHERE User1 IN (SELECT wallets FROM wallets) GROUP BY 1,2 ) SELECT CASE WHEN balance < 0.1 THEN 'Plankton<0.1' WHEN balance >= 0.1 AND balance < 1 THEN 'Shrimp<1' WHEN balance >= 1 AND balance < 10 THEN 'Crab<10' WHEN balance >= 10 AND balance < 50 THEN 'Fish<50' WHEN balance >= 50 AND balance < 100 THEN 'Octopuses<100' WHEN balance >= 100 AND balance < 500 THEN 'Dolphins<500' WHEN balance >= 500 AND balance < 1000 THEN 'Sharks<1000' WHEN balance >= 10000 THEN 'Whales>1000' END AS distribution, count (DISTINCT user1) AS Users_Count FROM balance_table WHERE balance > 0 AND date >= '2023-01-01' GROUP BY 1 HAVING distribution IS NOT null ORDER BY 2 DESC -- LIMIT 100 -- source [What is a Dolphine?](https://cryptowallet.com/glossary/dolphin/#:~:text=While%20those%20with%20really%20large,the%20planktons%20and%20the%20whales.)

Rolling with Rollbit