permary--5. Service Staking Analysis
Updated 2024-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
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