boomer77polygon block performance
Updated 2022-07-27
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with brah as (select block_number, block_timestamp, tx_count, lag(block_timestamp) OVER (ORDER BY block_number asc) as prev, timediff(second, prev, block_timestamp) as block_time
from polygon.core.fact_blocks
order by block_number desc)
select date_trunc('day', block_timestamp) as dt,
avg(block_time) as average_bt, max(block_time) as max_bt, min(block_time) as min_bt,
avg(tx_count) as average_tx, max(tx_count) as max_tx, min(tx_count) as min_tx,
count(distinct block_number) as daily_blocks,
sum(tx_count) as daily_tx
from brah
group by 1
Run a query to Download Data