kiichiUntitled Query
Updated 2022-07-28
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with tab1 as (
SELECT*
from arbitrum.core.fact_blocks),
tab2 as (
SELECT
avg(abs(DATEDIFF('second',b.block_timestamp , a.block_timestamp))) as avg_time_between_block
from tab1 b left join arbitrum.core.fact_blocks a
on (b.block_number +1 =a.block_number)
)
SELECT
avg_time_between_block from tab2
Run a query to Download Data