permaryTotal staked sol 2024
    Updated 2025-04-23
    with staking_platforms as (
    select *
    from (values
    ('6iQKfEyhr3bZMotVkW6beNZz5CPAkiwvgV2CTje9pVSS', 'jitoSOL', 'Jito'),
    ('6WecYymEARvjG5ZyqkrVQ6YkhPfujNzWpSPwNKXHCbV2', 'bSOL', 'BlazeStake'),
    ('AzZRvyyMHBm8EHEksWxq4ozFL7JxLMydCDMGhqM6BVck', 'scnSOL', 'Socean'),
    ('3b7XQeZ8nSMyjcQGTFJS5kBw4pXS2SqtB9ooHCnF2xV9', 'LST', 'Marginfi')
    ) as t(authority, token_symbol, platform_name)
    ),

    recent_staking_actions as (
    select
    stake_account,
    post_tx_staked_balance,
    token_symbol,
    platform_name
    from solana.gov.ez_staking_lp_actions actions
    join staking_platforms ON actions.stake_authority = staking_platforms.authority
    or actions.withdraw_authority = staking_platforms.authority
    where succeeded
    and block_timestamp >= '2024-01-01'
    )

    select
    platform_name,
    token_symbol,
    sum(post_tx_staked_balance) / 1e9 as total_staked_amount,
    COUNT(distinct stake_account) as unique_stakers
    from recent_staking_actions
    group by platform_name, token_symbol
    order by total_staked_amount desc;

    Last run: about 1 month ago
    PLATFORM_NAME
    TOKEN_SYMBOL
    TOTAL_STAKED_AMOUNT
    UNIQUE_STAKERS
    1
    JitojitoSOL38404824844.207407723
    2
    BlazeStakebSOL15351328121.563555327932
    3
    MarginfiLST5917087911.15979838084
    4
    SoceanscnSOL174786674.01964801
    4
    174B
    4s