Updated 2022-11-09
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select slot_timestamp::date as date,
count (distinct slot_number) as "Num Slots",
count (attestation_signature) as "Attestations",
sum ("Num Slots") over (order by date) as "Cumulative Slots",
sum ("Attestations") over (order by date) as "Cumulative Attestations",
round((select count (distinct slot_number)/count (distinct slot_timestamp::date) from ethereum.beacon_chain.fact_attestations where slot_timestamp::date != CURRENT_DATE),0) as "Avg Slots per day"
from ethereum.beacon_chain.fact_attestations
where slot_timestamp::date != CURRENT_DATE
group by 1
order by 1
Run a query to Download Data