flipsidecryptoOsmosis Latency - Historical Avg
    Updated 2023-12-14
    -- forked from Cosmos Latency - Historical Avg @ https://flipsidecrypto.xyz/edit/queries/635301c5-0d7d-4a5b-b2b7-4c9514f288d6

    -- forked from Axelar Latency - Historical Avg @ https://flipsidecrypto.xyz/edit/queries/6e8adfb9-839e-4df3-b6a2-d9722a70a652

    -- forked from Ethereum Latency - Historical Avg @ https://flipsidecrypto.xyz/edit/queries/34d1c0f5-32c0-4526-b857-47c6dd7924bd

    -- forked from BSC Latency - Historical Avg+ @ https://flipsidecrypto.xyz/edit/queries/7856c112-a52c-4870-97c1-d484d5c7b9cf

    -- forked from Avalanche Latency - Historical Avg @ https://flipsidecrypto.xyz/edit/queries/88bc0fe2-de85-4e7b-bd57-0cd695de597b

    -- forked from Arbitrum Latency - Historical Avg @ https://flipsidecrypto.xyz/edit/queries/169619c9-09b8-4074-8ad8-d9ca8b2581fb

    select
    lower(table_name) as table_name,
    avg(seconds_behind / 60) / 60 as mins_behind -- keeping same col name for vizzes
    from bi_analytics.core.fact_data_latency
    where recorded_timestamp::DATE >= current_date - 3
    and chain = 'osmosis'
    group by 1
    order by 1







    Run a query to Download Data