flipside

    Blockchain Data Status
    piperBlockchain Data Status
    Updated 19 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 19 hours agoAuto-refreshes every 12 hours
    Blockchain
    Data Lag
    Data Status
    Update Period
    Last Dashboard Refresh
    Last Block Timestamp Available
    Last Block Number
    1
    		Arbitrum00:57🟢 Data is up to date!1h2025-05-23 21:30:03.0002025-05-23 20:33:47.000339804268
    2
    		Aurora00:26🟢 Data is up to date!1h2025-05-23 21:30:03.0002025-05-23 21:04:18.000148015713
    3
    		Avalanche00:51🟢 Data is up to date!1h2025-05-23 21:30:03.0002025-05-23 20:39:52.00062594517
    4
    		Axelar00:59🟢 Data is up to date!1h2025-05-23 21:30:03.0002025-05-23 20:31:13.43718203570
    5
    		BSC00:46🟢 Data is up to date!1h2025-05-23 21:30:03.0002025-05-23 20:44:56.00050193083
    6
    		Base00:47🟢 Data is up to date!1h2025-05-23 21:30:03.0002025-05-23 20:43:39.00030621836
    7
    		Bitcoin01:05🟢 Data is up to date!1h2025-05-23 21:30:03.0002025-05-23 20:25:50.000898056
    8
    		Cosmos04:20🟢 Data is up to date!24h2025-05-23 21:30:03.0002025-05-23 17:10:03.91325854228
    9
    		Ethereum01:02🟡 Slightly out of date!1h2025-05-23 21:30:03.0002025-05-23 20:28:59.00022547950
    10
    		Flow00:39🟢 Data is up to date!1h2025-05-23 21:30:03.0002025-05-23 20:51:18.839114050388
    11
    		Gnosis00:39🟢 Data is up to date!2h2025-05-23 21:30:03.0002025-05-23 20:51:15.00040214226
    12
    		Near00:50🟢 Data is up to date!12h2025-05-23 21:30:03.0002025-05-23 20:40:40.050148013371
    13
    		Optimism00:42🟢 Data is up to date!1h2025-05-23 21:30:03.0002025-05-23 20:48:51.000136217277
    14
    		Osmosis17:29🔴 Data is out of date!12h2025-05-23 21:30:03.0002025-05-23 04:01:13.92936194634
    15
    		Polygon00:44🟢 Data is up to date!1h2025-05-23 21:30:03.0002025-05-23 20:46:29.00071881868
    16
    		Sei01:09🟡 Slightly out of date!1h2025-05-23 21:30:03.0002025-05-23 20:21:17.897148745690
    17
    		Solana00:59🟢 Data is up to date!1h2025-05-23 21:30:03.0002025-05-23 20:31:21.000341999995
    18
    		Terra20:16🟢 Data is up to date!6h2025-05-23 21:30:03.0002025-05-23 01:14:37.57315725774
    19
    		Thorchain01:38🟢 Data is up to date!12h2025-05-23 21:30:03.0002025-05-23 19:52:57.55321222096
    19
    2KB
    226s