ethereum as (

SELECT

AVG(time_difference_seconds) as avg_block_creation_time_in_seconds,

'Ethereum' as network,

dt

FROM

(

SELECT

BLOCK_TIMESTAMP,

BLOCK_NUMBER,

DATE(BLOCK_TIMESTAMP) as dt,

DATEDIFF(

second,

LAG(BLOCK_TIMESTAMP) OVER (

ORDER BY

BLOCK_NUMBER

),

BLOCK_TIMESTAMP

) AS time_difference_seconds

FROM

ethereum.core.fact_blocks

WHERE

BLOCK_TIMESTAMP >= CURRENT_DATE - 15

ORDER BY

BLOCK_NUMBER ASC

)

GROUP BY

2,

3

ORDER BY

3

),

polygon_pos as (

SELECT

AVG(time_difference_seconds) as avg_block_creation_time_in_seconds,