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:24🟢 Data is up to date!1h2025-02-12 21:30:03.0002025-02-12 21:06:41.000305411543
    2
    Aurora00:33🟢 Data is up to date!1h2025-02-12 21:30:03.0002025-02-12 20:57:58.000139587409
    3
    Avalanche00:22🟢 Data is up to date!1h2025-02-12 21:30:03.0002025-02-12 21:08:59.00057228293
    4
    Axelar00:58🟢 Data is up to date!1h2025-02-12 21:30:03.0002025-02-12 20:32:21.24016722814
    5
    BSC00:44🟢 Data is up to date!1h2025-02-12 21:30:03.0002025-02-12 20:46:05.00046603914
    6
    Base01:17🟡 Slightly out of date!1h2025-02-12 21:30:03.0002025-02-12 20:13:23.00026300928
    7
    Bitcoin01:09🟢 Data is up to date!1h2025-02-12 21:30:03.0002025-02-12 20:21:43.000883472
    8
    Cosmos06:31🟢 Data is up to date!24h2025-02-12 21:30:03.0002025-02-12 14:59:49.40424386059
    9
    Ethereum00:28🟢 Data is up to date!1h2025-02-12 21:30:03.0002025-02-12 21:02:35.00021832961
    10
    Flow00:40🟢 Data is up to date!1h2025-02-12 21:30:03.0002025-02-12 20:50:28.961103331156
    11
    Gnosis00:29🟢 Data is up to date!2h2025-02-12 21:30:03.0002025-02-12 21:01:15.00038530723
    12
    Near01:31🟢 Data is up to date!12h2025-02-12 21:30:03.0002025-02-12 19:59:05.010139584241
    13
    Optimism01:09🟡 Slightly out of date!1h2025-02-12 21:30:03.0002025-02-12 20:21:33.000131896458
    14
    Osmosis11:17🟢 Data is up to date!12h2025-02-12 21:30:03.0002025-02-12 10:13:50.38929468485
    15
    Polygon00:37🟢 Data is up to date!1h2025-02-12 21:30:03.0002025-02-12 20:53:18.00067847976
    16
    Sei00:39🟢 Data is up to date!1h2025-02-12 21:30:03.0002025-02-12 20:51:46.555131311528
    17
    Solana00:23🟢 Data is up to date!1h2025-02-12 21:30:03.0002025-02-12 21:07:13.000320240356
    18
    Terra20:15🟢 Data is up to date!6h2025-02-12 21:30:03.0002025-02-12 01:15:24.86414263333
    19
    Thorchain00:43🟢 Data is up to date!12h2025-02-12 21:30:03.0002025-02-12 20:47:44.67719841548
    19
    2KB
    321s