mboveiriPolygon Block Performance 1
Updated 2022-07-25
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 daily as (select
t1.block_timestamp::date as date,
avg(datediff(second, t1.block_timestamp, t2.block_timestamp)) as average_between_blocks,
max(datediff(second, t1.block_timestamp, t2.block_timestamp)) as max_between_blocks,
min(datediff(second, t1.block_timestamp, t2.block_timestamp)) as min_between_blocks
from polygon.core.fact_blocks t1 join polygon.core.fact_blocks t2
on t1.block_number = t2.block_number - 1
group by date) ,
all_time as (
select
avg(datediff(second, t1.block_timestamp, t2.block_timestamp)) as average_all_time,
max(datediff(second, t1.block_timestamp, t2.block_timestamp)) as max_all_time,
min(datediff(second, t1.block_timestamp, t2.block_timestamp)) as min_all_time
from polygon.core.fact_blocks t1 join polygon.core.fact_blocks t2
on t1.block_number = t2.block_number - 1
),
tpb as (
select
block_timestamp::date as date,
min(tpb) as min_transacation_per_block,
avg(tpb) as average_transacation_per_block,
max(tpb) as max_transacation_per_block
from polygon.core.fact_blocks join (select block_number, count(*) as tpb from polygon.core.fact_transactions group by 1) tr_count
on tr_count.block_number = polygon.core.fact_blocks.block_number
group by 1
),
avg_tpb_alltime as (
select
avg(tpb) as average_transacation_per_block_alltime
from polygon.core.fact_blocks join (select block_number, count(*) as tpb from polygon.core.fact_transactions group by 1) tr_count
on tr_count.block_number = polygon.core.fact_blocks.block_number
Run a query to Download Data