select

block_number as "Block Number",

TX_COUNT as "TX count",

date_trunc('day', block_timestamp) as "Day",

block_timestamp as "current block time",

lag(block_timestamp,1) over(order by block_number) as "previous block time",

DATEDIFF(second , "previous block time" , "current block time" ) as "Block Age"

from arbitrum.core.fact_blocks

), block_info as (

select

min("Block Age") as "Min Block Time",

max("Block Age") as "Max Block Time",

avg("Block Age") as "Average Block Time"

from blocktage_diff

where "Block Age" is not null

) select "Day","Min Block Time","Max Block Time","Average Block Time",avg("Block Age") as "Daily Block Age"

from blocktage_diff,block_info

group by "Day","Min Block Time","Max Block Time","Average Block Time"