kiichiUntitled Query
    Updated 2022-07-28
    with tab1 as (
    SELECT*
    from arbitrum.core.fact_blocks),
    tab2 as (
    SELECT
    avg(abs(DATEDIFF('second',b.block_timestamp , a.block_timestamp))) as avg_time_between_block
    from tab1 b left join arbitrum.core.fact_blocks a
    on (b.block_number +1 =a.block_number)
    )
    SELECT
    avg_time_between_block from tab2
    Run a query to Download Data