flipside

    Blocks Stats
    SocioCryptoBlocks Stats
    Updated 2024-04-28
    SELECT
    date_trunc('{{interval}}',a.block_timestamp) as date,
    count(DISTINCT a.block_id) as n_blocks,
    sum(n_blocks)over(order by date) as cum_n_blocks,
    avg(datediff(millisecond, a.block_timestamp,b.block_timestamp)) as avg_time_diff
    FROM axelar.core.fact_blocks a, axelar.core.fact_blocks b
    WHERE a.block_id = b.block_id -1
    --AND date between current_date-30 and CURRENT_DATE-1
    GROUP BY 1
    order by date DESC
    QueryRunArchived: QueryRun has been archived