flipside

    Blockchain Data Status
    piperBlockchain Data Status
    Updated 2025-04-10
    -- 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: 17 days agoAuto-refreshes every 12 hours
    Blockchain
    Data Lag
    Data Status
    Update Period
    Last Dashboard Refresh
    Last Block Timestamp Available
    Last Block Number
    1
    		Arbitrum00:27🟢 Data is up to date!1h2025-04-10 09:30:03.0002025-04-10 09:03:24.000324854280
    2
    		Aurora00:33🟢 Data is up to date!1h2025-04-10 09:30:03.0002025-04-10 08:57:13.000143882544
    3
    		Avalanche00:21🟢 Data is up to date!1h2025-04-10 09:30:03.0002025-04-10 09:09:27.00060010697
    4
    		Axelar00:59🟢 Data is up to date!1h2025-04-10 09:30:03.0002025-04-10 08:31:15.65517560027
    5
    		BSC00:47🟢 Data is up to date!1h2025-04-10 09:30:03.0002025-04-10 08:43:17.00048230925
    6
    		Base01:17🟡 Slightly out of date!1h2025-04-10 09:30:03.0002025-04-10 08:13:17.00028741725
    7
    		Bitcoin00:54🟢 Data is up to date!1h2025-04-10 09:30:03.0002025-04-10 08:36:48.000891759
    8
    		Cosmos04:21🟢 Data is up to date!24h2025-04-10 09:30:03.0002025-04-10 05:09:56.80125218202
    9
    		Ethereum00:31🟢 Data is up to date!1h2025-04-10 09:30:03.0002025-04-10 08:59:23.00022237486
    10
    		Flow00:54🟢 Data is up to date!1h2025-04-10 09:30:03.0002025-04-10 08:36:18.573109354801
    11
    		Gnosis00:39🟢 Data is up to date!2h2025-04-10 09:30:03.0002025-04-10 08:51:05.00039484735
    12
    		Near01:18🟢 Data is up to date!12h2025-04-10 09:30:03.0002025-04-10 08:12:23.142143880167
    13
    		Optimism01:12🟡 Slightly out of date!1h2025-04-10 09:30:03.0002025-04-10 08:18:41.000134337172
    14
    		Osmosis10:38🟢 Data is up to date!12h2025-04-10 09:30:03.0002025-04-09 22:52:17.89933275864
    15
    		Polygon00:44🟢 Data is up to date!1h2025-04-10 09:30:03.0002025-04-10 08:46:13.00070122389
    16
    		Sei01:09🟡 Slightly out of date!1h2025-04-10 09:30:03.0002025-04-10 08:21:22.238141307534
    17
    		Solana00:33🟢 Data is up to date!1h2025-04-10 09:30:03.0002025-04-10 08:57:24.000332508770
    18
    		Terra08:15🟢 Data is up to date!6h2025-04-10 09:30:03.0002025-04-10 01:15:12.94415095578
    19
    		Thorchain00:51🟢 Data is up to date!12h2025-04-10 09:30:03.0002025-04-10 08:39:51.30520639334
    19
    2KB
    158s