dan-smithTotal Rewards
Updated 2024-04-11
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
ROUND(SUM(rewards),2) AS total_rewards
,total_rewards / 120000000 * 100 AS inflation
FROM (
SELECT
date_trunc('hour',slot_timestamp) AS dt
,withdrawal_amount
,CASE WHEN withdrawal_amount >= 32 THEN withdrawal_amount - 32
ELSE withdrawal_amount
END AS rewards
FROM ethereum.beacon_chain.fact_withdrawals
)
QueryRunArchived: QueryRun has been archived