DrsimonUntitled Query
    Updated 2022-09-10
    with summary as (
    select 'ethereum' as chain ,
    block_number as block_no,
    datediff('second', lag(block_timestamp) over (order by block_timestamp asc),
    block_timestamp) as interval_time,
    tx_count
    from ethereum.core.fact_blocks
    union
    select 'polygon' ,
    block_number as block_no,
    datediff('second', lag(block_timestamp) over (order by block_timestamp asc),
    block_timestamp) as interval_time,
    tx_count
    from polygon.core.fact_blocks
    union
    select 'arbitrum',
    block_number as block_no,
    datediff('second', lag(block_timestamp) over (order by block_timestamp asc),
    block_timestamp) as interval_time,
    tx_count
    from arbitrum.core.fact_blocks
    union
    select 'solana',
    block_id as block_no,
    datediff('second', lag(block_timestamp) over (order by block_timestamp asc),
    block_timestamp) as interval_time,
    tx_count
    from solana.core.fact_blocks
    union
    select 'optimism',
    block_number as block_no,
    datediff('second', lag(block_timestamp) over (order by block_timestamp asc),
    block_timestamp) as interval_time,
    tx_count
    from optimism.core.fact_blocks
    )
    Run a query to Download Data