SELECT owner AS wallet, balance

FROM solana.core.fact_token_balances

WHERE mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'

AND balance >= 10000

SELECT

tx.PROVIDER_ADDRESS AS wallet,

SUM(CASE WHEN tx.action_type IN ('deposit', 'depositStakeAccount') THEN tx.MSOL_MINTED ELSE 0 END) AS msol_minted,

SUM(CASE WHEN tx.action_type = 'orderUnstake' THEN tx.MSOL_BURNED ELSE 0 END) AS msol_burned,

SUM(w.balance) AS Current_holding

FROM solana.marinade.ez_liquid_staking_actions tx

JOIN whale_addresses w ON tx.PROVIDER_ADDRESS = w.wallet -- Faster than IN (SELECT ...)

WHERE tx.block_timestamp >= CURRENT_DATE - INTERVAL '60 days'

GROUP BY tx.PROVIDER_ADDRESS

HAVING SUM(CASE WHEN tx.action_type IN ('deposit', 'depositStakeAccount') THEN tx.MSOL_MINTED ELSE 0 END) >= 10000

ORDER BY msol_minted DESC;