CryptoIciclePolygon Block Performance - Polygon - Most difference
Updated 2022-07-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
›
⌄
-- Polygon Block Performance
-- What is the average time between blocks on Polygon?
-- Payout 75 USDC
-- Grand Prize 225 USDC
-- Payout Network Ethereum
-- Level Beginner
-- What is the average time between blocks on Polygon?
-- What was the maximum and minimum recorded time between two blocks?
-- How many transactions are done in a block on average?
-- How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
with tpb as (
select
block_timestamp,
block_number,
count(distinct tx_hash) as n_txns_block,
datediff('second', lag(block_timestamp,1) ignore nulls over (order by block_timestamp asc), block_timestamp) as diff_sec
from polygon.core.fact_transactions
where block_timestamp >= CURRENT_DATE - {{n_days}}
group by 1, 2
)
select * from tpb
order by diff_sec desc
limit 10
Run a query to Download Data