js699flow vs sei evm blocks 2
Updated 2025-01-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH flow_evm_blocks AS (
SELECT
block_number,
block_timestamp::date AS block_date,
DATEDIFF('second', LAG(block_timestamp) OVER (ORDER BY block_number), block_timestamp) AS seconds_between_blocks
FROM
flow.core_evm.fact_blocks
),
sei_evm_blocks AS (
SELECT
block_number,
block_timestamp::date AS block_date,
DATEDIFF('second', LAG(block_timestamp) OVER (ORDER BY block_number), block_timestamp) AS seconds_between_blocks
FROM
sei.core_evm.fact_blocks
)
select 'Flow' as net,block_date, avg(seconds_between_blocks) as avg_seconds_between_blocks from flow_evm_blocks group by 1,2
UNION select 'Sei' as net, block_date, avg(seconds_between_blocks) as avg_seconds_between_blocks from sei_evm_blocks group by 1,2
QueryRunArchived: QueryRun has been archived