dan-smithWithdrawals: Full vs Partial (in ETH) WIP
Updated 2024-04-11
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
›
⌄
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