with avg_block_time as (select datediff('minute' , min(block_timestamp), max(block_timestamp))/count(*) from polygon.core.fact_blocks)
, avg_block_time_overtime as (select datediff('minute' , min(block_timestamp), max(block_timestamp))/count(*), block_timestamp::date
from polygon.core.fact_blocks
group by block_timestamp::date )
, avg_tx as (select avg(tx_count) from polygon.core.fact_blocks)
, avg_tx_overtime as (select avg(tx_count),block_timestamp::date from polygon.core.fact_blocks
group by block_timestamp::date)
select * from avg_block_time_overtime