superflyavg daily (polygon)
Updated 2022-07-27Copy Reference Fork
9
1
2
3
4
5
6
7
›
⌄
with tabel1 as (select BLOCK_NUMBER, block_timestamp,datediff (second, lag(block_timestamp, 1) over (order by block_timestamp asc), block_timestamp) as block_time
from polygon.core.fact_blocks----- i us general tabel polygon
where block_timestamp > '2022-01-01' order by block_number)---- average time between blocks on Polygon is daily
select date_trunc ('day', block_timestamp) as times, avg (block_time) as "Avg blocktime"----average tim blocks on polygon
from tabel1
group by 1
order by 1
Run a query to Download Data