js699Olas staking
Updated 2025-01-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH weekly_metrics AS (
SELECT
DATE_TRUNC('week', BLOCK_TIMESTAMP) AS week,
COUNT(DISTINCT TX_HASH) AS weekly_transactions,
COUNT(DISTINCT STAKER_ADDRESS) AS active_stakers,
SUM(AMOUNT) AS total_staked_amount,
SUM(AMOUNT_USD) AS total_staked_amount_usd,
AVG(AMOUNT) AS avg_stake_per_transaction,
AVG(AMOUNT_USD) AS avg_stake_usd_per_transaction
FROM
crosschain.olas.ez_olas_staking
GROUP BY
DATE_TRUNC('week', BLOCK_TIMESTAMP)
),
cumulative_metrics AS (
SELECT
week,
SUM(total_staked_amount) OVER (ORDER BY week ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_staked_amount,
SUM(total_staked_amount_usd) OVER (ORDER BY week ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_staked_amount_usd
FROM
weekly_metrics
)
SELECT
wm.week,
wm.weekly_transactions,
wm.active_stakers,
wm.total_staked_amount,
wm.total_staked_amount_usd,
wm.avg_stake_per_transaction,
wm.avg_stake_usd_per_transaction,
cm.cumulative_staked_amount,
cm.cumulative_staked_amount_usd
FROM
weekly_metrics wm
QueryRunArchived: QueryRun has been archived