SELECT
date_trunc('day',a.block_timestamp) as date,
avg(datediff(second, a.block_timestamp,b.block_timestamp)) as avg_time_diff
FROM near.core.fact_blocks a, near.core.fact_blocks b
WHERE a.block_id = b.block_id -1
AND date <= CURRENT_DATE-1
GROUP BY date
ORDER BY date