dan-smithWithdrawals: Full vs Partial (in ETH) WIP
    Updated 2024-04-11
    SELECT
    dt
    ,ROUND(SUM(withdrawal_amount),2) AS "Total ETH Withdrawn"
    ,ROUND(SUM(CASE WHEN type = 'full' THEN withdrawal_amount_new ELSE 0 END),2) AS "Full"
    ,ROUND(SUM(CASE WHEN type = 'partial' THEN withdrawal_amount_new ELSE 0 END),2) AS "Partial"
    ,ROUND(SUM(CASE WHEN type = 'full' THEN withdrawal_amount_new ELSE 0 END) / SUM(withdrawal_amount) * 100,2) AS "Full %"
    ,ROUND(SUM(CASE WHEN type = 'partial' THEN withdrawal_amount_new ELSE 0 END) / SUM(withdrawal_amount) * 100,2) AS "Partial %"
    FROM (
    SELECT
    date_trunc('hour',slot_timestamp) AS dt
    ,withdrawal_amount
    ,CASE WHEN withdrawal_amount >= 32 THEN 'full'
    ELSE 'partial'
    END AS type
    ,CASE
    WHEN type = 'full' AND withdrawal_amount >= 32 THEN 32
    WHEN type = 'full' AND withdrawal_amount < 32 THEN withdrawal_amount
    ELSE withdrawal_amount
    END AS withdrawal_amount_new
    FROM ethereum.beacon_chain.fact_withdrawals
    )
    GROUP BY 1


    QueryRunArchived: QueryRun has been archived