Mrftiexact-rose
    Updated 19 hours ago
    with tbl1 as
    (
    SELECT date_trunc (day, block_timestamp) as date,
    count (DISTINCT block_number) as "Block count"
    FROM swell.core.fact_blocks
    where date = current_date -2
    group by 1
    order by 1
    )

    SELECT 24*60*60 /"Block count" as "Block Time"
    from tbl1
    Last run: about 19 hours agoAuto-refreshes every 12 hours
    Block Time
    1
    2
    1
    5B
    2s