mboveiriL2 and Polygon Vs Solana - Daily
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 solana as (
select
t1.block_timestamp::date as date,
avg(datediff(second, t1.block_timestamp, t2.block_timestamp)) as average_time_between_block
from solana.core.fact_blocks t1 join solana.core.fact_blocks t2
on t1.block_id = t2.block_id - 1
where t1.block_timestamp >= '2022-06-06'
group by date
),
polygon as (
select
t1.block_timestamp::date as date,
avg(datediff(second, t1.block_timestamp, t2.block_timestamp)) as average_time_between_block
from polygon.core.fact_blocks t1 join polygon.core.fact_blocks t2
on t1.block_number = t2.block_number - 1
group by date
),
opti as (
select
t1.block_timestamp::date as date,
avg(datediff(second, t1.block_timestamp, t2.block_timestamp)) as average_time_between_block
from optimism.core.fact_blocks t1 join optimism.core.fact_blocks t2
on t1.block_number = t2.block_number - 1
where t1.block_timestamp >= '2022-06-06'
and t1.network = 'mainnet'
group by date
),
arbi as (
select
t1.block_timestamp::date as date,
avg(datediff(second, t1.block_timestamp, t2.block_timestamp)) as average_time_between_block
from arbitrum.core.fact_blocks t1 join arbitrum.core.fact_blocks t2
on t1.block_number = t2.block_number - 1
Run a query to Download Data