chispaslotus rewards to delegators GOOD QUERY
    Updated 2025-02-08
    SELECT
    epoch_earned,
    COUNT(DISTINCT stake_pubkey) as num_reward_recipients,
    SUM(reward_amount_sol) as total_rewards_sol
    FROM SOLANA.gov.fact_rewards_staking
    WHERE epoch_earned >= 730
    AND stake_pubkey IN (
    SELECT DISTINCT stake_pubkey
    FROM SOLANA.gov.fact_stake_accounts
    WHERE vote_pubkey = 'gangtRyGPTvYWb8K3xS2feJQaCks4iJ7rytFUPtVqSY'
    AND epoch >= 730
    )
    GROUP BY epoch_earned
    ORDER BY epoch_earned DESC;
    QueryRunArchived: QueryRun has been archived