SELECT
date_trunc('{{granularity}}', a.block_timestamp) as date,
avg(datediff(second, a.block_timestamp,b.block_timestamp)) as avg_time_diff
FROM core.core.fact_blocks a, core.core.fact_blocks b
WHERE a.block_number = b.block_number-1
AND date < CURRENT_DATE
AND date >= dateadd(day, -{{past_days}}, current_date())
GROUP BY date