date_trunc('day',a.block_timestamp) as date,

avg(datediff(millisecond, a.block_timestamp,b.block_timestamp)) as avg_time_diff

FROM axelar.core.fact_blocks a, axelar.core.fact_blocks b

WHERE a.block_id = b.block_id -1

AND date between current_date-30 and CURRENT_DATE-1

GROUP BY 1