BlockTrackeraverage block_time
    Updated 2025-05-10
    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





    QueryRunArchived: QueryRun has been archived