feyikemistakers over time
    Updated 2025-04-21
    WITH msol_minting AS (
    SELECT
    PROVIDER_ADDRESS AS wallet,
    SUM(DEPOSIT_AMOUNT) AS total_sol_staked,
    SUM(MSOL_MINTED) AS total_msol_minted,
    FROM solana.marinade.ez_liquid_staking_actions
    WHERE action_type IN ('deposit', 'depositStakeAccount')
    GROUP BY wallet
    )

    SELECT wallet AS provider_address,
    total_SOL_staked,
    total_msol_minted
    FROM msol_minting
    WHERE total_SOL_staked IS NOT NULL
    ORDER BY total_SOL_staked DESC

    Last run: about 1 month ago
    PROVIDER_ADDRESS
    TOTAL_SOL_STAKED
    TOTAL_MSOL_MINTED
    1
    75jTZDE78xpBJokeB2BcimRNY5BZ7U45bWhpgUrTzWZC3058646.36381294594570.95390536
    2
    DYG1ooTxkLS5iHDkte2XK4QBrpHziDR6EEZg5VsqNpVo21000002077369.29936579
    3
    8fTzG3pZ2PYkxHuJnQN1dVJhFfM6AADNYmp3JR4dvJcF1126187.58092611895420.570850426
    4
    QM3ACFu3VD9N6z6dmBseezxrNRP1T4MruGhpJX8B3nC1000000.011198732.94105716
    5
    CYgeQ2GF5ggUA9BBYTZ5i2cwHZ59fuPjGKSx3soZ8iNq813721.414602743661894.435864532
    6
    3KNZ9i1dLNNqpBTKEkTgUQs6TNCd3bzuy6HwfoXACaRs799539.083248857705552.272431967
    7
    KMhcqNpDomyUVSK9WDr8uve29oeSoA4TZPGV34EA3JB707018458525.732139291
    8
    DoUsjrgNUokJV7Eu4YSVht6TKDYx1XC1nmrkQffgefND599620.8560038.703072234
    9
    CuieVDEDtLo7FypA9SbLM9saXFdb1dsshEkyErMqkRQq545498.99794072530078.53923483
    10
    ByiAbN9MJhfQKGK5WJrfgko6XS88qqERQVRLWZTsvyTf513530.65299135443103.316718471
    11
    TZ7g3id6KocGgfL7gmGPkDF4AE3NZJNnvdZz2rppkBB492515.119929409301522.377606176
    12
    585B7BBbcmYLksPNH7uH3L9wujpgb1MRcKfEEocXQi9W458124.541863508378193.03134549
    13
    4W1ReexzfpqngdDAhQM9z3H3Uoy7XfveWxcKimfSyFLC450016.051973194376356.321167328
    14
    Bx2T1nwfsNFM9vd3VXj9fozT8YJTFWgNd7imUDA6XzVZ450000385252.034980648
    15
    DUKvfQS2jmZNMXBK4Z8uEABXq6hAjakNSdrRyRk4e78J431398.107336238543901.740689555
    16
    9nnLbotNTcUhvbrsA6Mdkx45Sm82G35zo28AqUvjExn8366633.607018815294018.739028671
    17
    CapuXNQoDviLvU1PxFiizLgPNQCxrsag1uMeyk6zLVps332631.513964048265536.792971586
    18
    FoRRGSPyyQ1VSXhk4Eye3tTk4HXVwihLwG1VZHosqaZj328763.710541282133776.081605223
    19
    8DR41d11jXq2wmopnvPhKrcJy3hHZ6LiPss7Rszh31bJ319399100551.7655831
    20
    2MFoS3MPtvyQ4Wh4M9pdfPjz6UhVoNbFbGJAskCPCj3h307477.70140732246621.388857134
    ...
    100000
    6MB
    6s