Block Time | |
---|---|
1 | 2 |
Mrftiexact-rose
Updated 2 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with tbl1 as
(
SELECT date_trunc (day, block_timestamp) as date,
count (DISTINCT block_number) as "Block count"
FROM swell.core.fact_blocks
where date = current_date -2
group by 1
order by 1
)
SELECT 24*60*60 /"Block count" as "Block Time"
from tbl1
Last run: 1 day agoAuto-refreshes every 12 hours
1
5B
1s