Alir3zaUntitled Query
Updated 2022-07-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select
max(maximum) as average,
min(minimum) as minimum,
avg(average) as maximum
from (select date(mx) as dt,
max(maxmin) as maximum,
min(maxmin) as minimum,
avg(maxmin) as average
from(
select block_number,mx, maxmin from (
select
block_number,
block_timestamp as mx,
lead(block_timestamp,1) over (order by block_timestamp asc ) as mn,
datediff('second', mx,mn) as maxmin
from polygon.core.fact_blocks))
group by 1)
Run a query to Download Data