nsa2000 Overall View
Updated 2022-11-10
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
SLOT_TIMESTAMP::date as date,
COUNT(DISTINCT PUBKEY) as "Validator public key",
COUNT(DISTINCT SIGNATURE) as "Validator Signature",
sum(DEPOSIT_AMOUNT) as "Deposite Amount",
avg(DEPOSIT_AMOUNT) as "Avg Deposite Amount",
sum("Validator Signature") over (order by date) as "Cum Validator Signature",
sum("Deposite Amount") over (order by date) as "Cum Deposite Amount"
FROM ethereum.beacon_chain.fact_deposits
WHERE SLOT_TIMESTAMP::date >= '2022-09-15'
GROUP by 1
ORDER by 1
Run a query to Download Data