MarcoVPolygon Block Performance Daily
    Updated 2022-07-27
    with time1 as (select timediff(seconds, lag(BLOCK_TIMESTAMP) over(order by block_number asc), block_timestamp) as diff, *
    from polygon.core.fact_blocks
    where date_trunc('day', block_timestamp)>='2022-06-23' and date_trunc('day', block_timestamp)<='2022-07-23'),

    time2 as (select timediff(seconds, lag(BLOCK_TIMESTAMP) over(order by block_height asc), block_timestamp) as diff, *
    from flow.core.fact_blocks
    where date_trunc('day', block_timestamp)>='2022-06-23' and date_trunc('day', block_timestamp)<='2022-07-23')
    ,

    time3 as (select timediff(seconds, lag(BLOCK_TIMESTAMP) over(order by block_id asc), block_timestamp) as diff, *
    from solana.core.fact_blocks
    where date_trunc('day', block_timestamp)>='2022-06-23' and date_trunc('day', block_timestamp)<='2022-07-23')


    select date_trunc('day', block_timestamp) as day, 'Polygon' as chain , avg(diff) as avg_time, max(diff) as max_time, min(diff) as min_time, avg(tx_count) as avg_tx_block, count(*) as blocks, sum(tx_count) as txs
    from time1
    group by day
    -- union all
    -- select date_trunc('day', block_timestamp) as day, 'Flow' as chain ,avg(diff) as avg_time, max(diff) as max_time, min(diff) as min_time , avg(tx_count) as tx_count, count(*) as blocks, sum(tx_count) as txs
    -- from time2
    -- group by day
    -- union all
    -- select date_trunc('day', block_timestamp) as day, 'Solana' as chain, avg(diff) as avg_time, max(diff) as max_time, min(diff) as min_time, avg(tx_count) as tx_count, count(*) as blocks,sum(tx_count) as txs
    -- from time3
    -- group by day



    Run a query to Download Data