sarathpolygon block 6
Updated 2022-07-26
9
1
2
3
4
5
6
7
›
⌄
select avg(tx_count) as avg_tx_count, avg(difference) as avg_difference, max(difference) as max_difference, min(difference) as min_difference from (select block_number,
block_timestamp, tx_count,
timestampdiff(second, lag(block_timestamp) over (order by block_number asc), block_timestamp) as difference
from polygon.core.fact_blocks
where block_timestamp::date >= current_date - 60 and block_timestamp is not null and block_number is not null
limit 5000
offset 1)
Run a query to Download Data