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 polygon.core.fact_blocks

)

select

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

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

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

round(min("TX count"),2) as "Min TX count per block",

round(max("TX count"),2) as "Max TX count per block",

round(avg("TX count"),2) as "Average TX count per block"

from blocktage_diff

where "Block Age" is not null -- first row have null age becuse we don't have prev