CoinConversePolygon Block Performance table 3
Updated 2022-07-27
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
30
31
32
33
34
35
36
›
⌄
with polygon_time as (select avg(tx_count) as avg_tx_count, avg(difference) as avg_time_difference, max(difference) as max_time_difference, min(difference) as min_time_difference, 'Polygon' as network
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 - 30 and block_timestamp is not null and block_number is not null
limit 500000000
offset 1)),
ethereum_time as (select avg(tx_count) as avg_tx_count, avg(difference) as avg_time_difference, max(difference) as max_time_difference, min(difference) as min_time_difference,'Ethereum' as network
from (select block_number,
block_timestamp, tx_count,
timestampdiff(second, lag(block_timestamp) over (order by block_number asc), block_timestamp) as difference
from ethereum.core.fact_blocks
where block_timestamp::date >= current_date - 30 and block_timestamp is not null and block_number is not null
limit 500000000
offset 1)),
flow_time as (select avg(tx_count) as avg_tx_count, avg(difference) as avg_time_difference, max(difference) as max_time_difference, min(difference) as min_time_difference,'Flow' as network
from (select block_height,
block_timestamp, tx_count,
timestampdiff(second, lag(block_timestamp) over (order by block_height asc), block_timestamp) as difference
from flow.core.fact_blocks
where block_timestamp::date >= current_date - 30 and block_timestamp is not null and block_height is not null
limit 500000000
offset 1)),
solana_time as (select avg(tx_count) as avg_tx_count, avg(difference) as avg_time_difference, max(difference) as max_time_difference, min(difference) as min_time_difference,'Solana' as network
from (select block_id,
block_timestamp, tx_count,
timestampdiff(second, lag(block_timestamp) over (order by block_id asc), block_timestamp) as difference
from solana.core.fact_blocks
where block_timestamp::date >= current_date - 30 and block_timestamp is not null and block_id is not null
limit 500000000
offset 1))
Run a query to Download Data