SocioCryptoBlock Time
    Updated 2023-05-20
    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
    Run a query to Download Data