Avg Daily blocks | |
|---|---|
1 | 42695.785714 |
Mrfti2024-07-25 12:40 AM copy
Updated 1 day ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- forked from 2024-07-25 12:40 AM @ https://flipsidecrypto.xyz/studio/queries/e0f95acb-083f-460b-b2f3-0ee063bbb547
with tbl AS
(
SELECT date_trunc (day, block_timestamp) as date,
count (DISTINCT block_number) as "Block count"
FROM swell.core.fact_blocks
group by 1
)
SELECT sum ("Block count")/count (DISTINCT date) as "Avg Daily blocks"
from tbl
Last run: 1 day agoAuto-refreshes every 12 hours
1
16B
5s