Block Time | |
|---|---|
1 | 2 |
Mrftiexact-rose
Updated 19 hours 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: about 19 hours agoAuto-refreshes every 12 hours
1
5B
2s