permary--5. Service Staking Analysis
    Updated 2024-11-10

    WITH staking_metrics AS (
    SELECT
    DATE_TRUNC('month', block_timestamp) as month,
    COUNT(DISTINCT service_id) as staked_services,
    COUNT(DISTINCT owner_address) as unique_stakers,
    AVG(reward) as avg_reward,
    SUM(reward) as total_rewards
    FROM crosschain.olas.ez_service_staking
    GROUP BY 1
    ORDER BY 1
    )
    SELECT
    month,
    staked_services,
    unique_stakers,
    avg_reward,
    total_rewards,
    total_rewards / NULLIF(staked_services, 0) as avg_reward_per_service
    FROM staking_metrics;
    QueryRunArchived: QueryRun has been archived