piperBlockchain Data Status
    Updated 14 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 14 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:24🟢 Data is up to date!1h2025-02-16 21:30:02.0002025-02-16 21:06:13.000306781841
    2
    Aurora00:32🟢 Data is up to date!1h2025-02-16 21:30:02.0002025-02-16 20:58:14.000139898397
    3
    Avalanche00:22🟢 Data is up to date!1h2025-02-16 21:30:02.0002025-02-16 21:08:18.00057422570
    4
    Axelar00:59🟢 Data is up to date!1h2025-02-16 21:30:02.0002025-02-16 20:31:13.86016781874
    5
    BSC00:44🟢 Data is up to date!1h2025-02-16 21:30:02.0002025-02-16 20:46:03.00046719092
    6
    Base01:17🟡 Slightly out of date!1h2025-02-16 21:30:02.0002025-02-16 20:13:05.00026473719
    7
    Bitcoin00:48🟢 Data is up to date!1h2025-02-16 21:30:02.0002025-02-16 20:42:24.000884086
    8
    Cosmos04:21🟢 Data is up to date!24h2025-02-16 21:30:02.0002025-02-16 17:09:58.08324446354
    9
    Ethereum00:28🟢 Data is up to date!1h2025-02-16 21:30:02.0002025-02-16 21:02:23.00021861511
    10
    Flow00:40🟢 Data is up to date!1h2025-02-16 21:30:02.0002025-02-16 20:50:08.151103761949
    11
    Gnosis00:29🟢 Data is up to date!2h2025-02-16 21:30:02.0002025-02-16 21:01:05.00038597627
    12
    Near01:32🟢 Data is up to date!12h2025-02-16 21:30:02.0002025-02-16 19:58:32.730139895174
    13
    Optimism01:09🟡 Slightly out of date!1h2025-02-16 21:30:02.0002025-02-16 20:21:25.000132069254
    14
    Osmosis11:12🟢 Data is up to date!12h2025-02-16 21:30:02.0002025-02-16 10:18:01.57429729370
    15
    Polygon00:37🟢 Data is up to date!1h2025-02-16 21:30:02.0002025-02-16 20:53:10.00068007465
    16
    Sei00:39🟢 Data is up to date!1h2025-02-16 21:30:02.0002025-02-16 20:51:32.731132038927
    17
    Solana01:40🔴 Data is out of date!1h2025-02-16 21:30:02.0002025-02-16 19:50:09.000321100596
    18
    Terra20:15🟢 Data is up to date!6h2025-02-16 21:30:02.0002025-02-16 01:15:09.60114321845
    19
    Thorchain00:43🟢 Data is up to date!12h2025-02-16 21:30:02.0002025-02-16 20:47:50.84519898307
    19
    2KB
    279s