dan-smithTotal Rewards
    Updated 2024-04-11
    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