flipside

    Blockchain Data Status
    piperBlockchain Data Status
    Updated 18 hours ago
    -- Thanks to @marqu, forked from https://flipsidecrypto.xyz/marqu/q/enMpSjzqEmLn/solana-nfts---last-update-info. and modified it!

    WITH arbitrum_info AS (
    SELECT
    'Arbitrum' AS blockchain,
    BLOCK_NUMBER,
    BLOCK_TIMESTAMP,
    FLOOR(DATEDIFF('minute', BLOCK_TIMESTAMP, CURRENT_TIMESTAMP()) / 60.0) AS hours,
    MOD(DATEDIFF('minute', BLOCK_TIMESTAMP, CURRENT_TIMESTAMP()), 60.0) AS minutes,
    CONCAT(IFF(hours < 10, CONCAT('0', hours::STRING), hours::STRING), ':', IFF(minutes < 10, CONCAT('0', minutes::STRING), minutes::STRING)) AS lag,
    (hours*60+minutes) AS lag_minutes,
    CASE
    WHEN lag_minutes <= 60 THEN '🟢 Data is up to date!'
    WHEN (lag_minutes > 60 AND lag_minutes <= 90) THEN '🟡 Slightly out of date!'
    WHEN lag_minutes > 90 THEN '🔴 Data is out of date!'
    END AS status,
    '1h' AS update_period
    FROM
    arbitrum.core.fact_blocks
    INNER JOIN arbitrum.core.fact_event_logs USING(BLOCK_NUMBER, BLOCK_TIMESTAMP)
    WHERE
    BLOCK_TIMESTAMP > CURRENT_DATE() - 3
    ORDER BY
    BLOCK_TIMESTAMP DESC NULLS LAST
    LIMIT 1
    ),
    avalanche_info AS (
    SELECT
    'Avalanche' AS blockchain,
    BLOCK_NUMBER,
    BLOCK_TIMESTAMP,
    FLOOR(DATEDIFF('minute', BLOCK_TIMESTAMP, CURRENT_TIMESTAMP()) / 60.0) AS hours,
    MOD(DATEDIFF('minute', BLOCK_TIMESTAMP, CURRENT_TIMESTAMP()), 60.0) AS minutes,
    CONCAT(IFF(hours < 10, CONCAT('0', hours::STRING), hours::STRING), ':', IFF(minutes < 10, CONCAT('0', minutes::STRING), minutes::STRING)) AS lag,
    (hours*60+minutes) AS lag_minutes,
    CASE
    Last run: about 18 hours agoAuto-refreshes every 12 hours
    Blockchain
    Data Lag
    Data Status
    Update Period
    Last Dashboard Refresh
    Last Block Timestamp Available
    Last Block Number
    1
    		Arbitrum01:57🔴 Data is out of date!1h2025-04-07 09:30:03.0002025-04-07 07:33:35.000323798449
    2
    		Aurora01:34🔴 Data is out of date!1h2025-04-07 09:30:03.0002025-04-07 07:56:44.000143649794
    3
    		Avalanche01:21🟡 Slightly out of date!1h2025-04-07 09:30:03.0002025-04-07 08:09:08.00059836118
    4
    		Axelar01:29🟡 Slightly out of date!1h2025-04-07 09:30:03.0002025-04-07 08:01:24.18817515229
    5
    		BSC00:47🟢 Data is up to date!1h2025-04-07 09:30:03.0002025-04-07 08:43:40.00048144533
    6
    		Base01:17🟡 Slightly out of date!1h2025-04-07 09:30:03.0002025-04-07 08:13:17.00028612125
    7
    		Bitcoin01:10🟢 Data is up to date!1h2025-04-07 09:30:03.0002025-04-07 08:20:36.000891316
    8
    		Cosmos04:20🟢 Data is up to date!24h2025-04-07 09:30:03.0002025-04-07 05:10:05.08725173875
    9
    		Ethereum01:32🔴 Data is out of date!1h2025-04-07 09:30:03.0002025-04-07 07:58:35.00022215684
    10
    		Flow02:17🔴 Data is out of date!1h2025-04-07 09:30:03.0002025-04-07 07:13:27.762109024799
    11
    		Gnosis01:39🟢 Data is up to date!2h2025-04-07 09:30:03.0002025-04-07 07:51:05.00039433163
    12
    		Near02:50🟢 Data is up to date!12h2025-04-07 09:30:03.0002025-04-07 06:40:56.399143645773
    13
    		Optimism01:42🔴 Data is out of date!1h2025-04-07 09:30:03.0002025-04-07 07:48:13.000134206658
    14
    		Osmosis06:59🟢 Data is up to date!12h2025-04-07 09:30:03.0002025-04-07 02:31:19.18633090588
    15
    		Polygon01:45🔴 Data is out of date!1h2025-04-07 09:30:03.0002025-04-07 07:45:39.00069999460
    16
    		Sei01:39🔴 Data is out of date!1h2025-04-07 09:30:03.0002025-04-07 07:51:56.903140777636
    17
    		Solana01:45🔴 Data is out of date!1h2025-04-07 09:30:03.0002025-04-07 07:45:37.000331846876
    18
    		Terra08:16🟢 Data is up to date!6h2025-04-07 09:30:03.0002025-04-07 01:14:33.28415051613
    19
    		Thorchain01:50🟢 Data is up to date!12h2025-04-07 09:30:03.0002025-04-07 07:40:49.07220595998
    19
    2KB
    154s