Blockchain | Data Lag | Data Status | Update Period | Last Dashboard Refresh | Last Block Timestamp Available | Last Block Number | |
---|---|---|---|---|---|---|---|
1 | Arbitrum | 00:24 | 🟢 Data is up to date! | 1h | 2025-02-12 21:30:03.000 | 2025-02-12 21:06:41.000 | 305411543 |
2 | Aurora | 00:33 | 🟢 Data is up to date! | 1h | 2025-02-12 21:30:03.000 | 2025-02-12 20:57:58.000 | 139587409 |
3 | Avalanche | 00:22 | 🟢 Data is up to date! | 1h | 2025-02-12 21:30:03.000 | 2025-02-12 21:08:59.000 | 57228293 |
4 | Axelar | 00:58 | 🟢 Data is up to date! | 1h | 2025-02-12 21:30:03.000 | 2025-02-12 20:32:21.240 | 16722814 |
5 | BSC | 00:44 | 🟢 Data is up to date! | 1h | 2025-02-12 21:30:03.000 | 2025-02-12 20:46:05.000 | 46603914 |
6 | Base | 01:17 | 🟡 Slightly out of date! | 1h | 2025-02-12 21:30:03.000 | 2025-02-12 20:13:23.000 | 26300928 |
7 | Bitcoin | 01:09 | 🟢 Data is up to date! | 1h | 2025-02-12 21:30:03.000 | 2025-02-12 20:21:43.000 | 883472 |
8 | Cosmos | 06:31 | 🟢 Data is up to date! | 24h | 2025-02-12 21:30:03.000 | 2025-02-12 14:59:49.404 | 24386059 |
9 | Ethereum | 00:28 | 🟢 Data is up to date! | 1h | 2025-02-12 21:30:03.000 | 2025-02-12 21:02:35.000 | 21832961 |
10 | Flow | 00:40 | 🟢 Data is up to date! | 1h | 2025-02-12 21:30:03.000 | 2025-02-12 20:50:28.961 | 103331156 |
11 | Gnosis | 00:29 | 🟢 Data is up to date! | 2h | 2025-02-12 21:30:03.000 | 2025-02-12 21:01:15.000 | 38530723 |
12 | Near | 01:31 | 🟢 Data is up to date! | 12h | 2025-02-12 21:30:03.000 | 2025-02-12 19:59:05.010 | 139584241 |
13 | Optimism | 01:09 | 🟡 Slightly out of date! | 1h | 2025-02-12 21:30:03.000 | 2025-02-12 20:21:33.000 | 131896458 |
14 | Osmosis | 11:17 | 🟢 Data is up to date! | 12h | 2025-02-12 21:30:03.000 | 2025-02-12 10:13:50.389 | 29468485 |
15 | Polygon | 00:37 | 🟢 Data is up to date! | 1h | 2025-02-12 21:30:03.000 | 2025-02-12 20:53:18.000 | 67847976 |
16 | Sei | 00:39 | 🟢 Data is up to date! | 1h | 2025-02-12 21:30:03.000 | 2025-02-12 20:51:46.555 | 131311528 |
17 | Solana | 00:23 | 🟢 Data is up to date! | 1h | 2025-02-12 21:30:03.000 | 2025-02-12 21:07:13.000 | 320240356 |
18 | Terra | 20:15 | 🟢 Data is up to date! | 6h | 2025-02-12 21:30:03.000 | 2025-02-12 01:15:24.864 | 14263333 |
19 | Thorchain | 00:43 | 🟢 Data is up to date! | 12h | 2025-02-12 21:30:03.000 | 2025-02-12 20:47:44.677 | 19841548 |
piperBlockchain Data Status
Updated 19 hours ago
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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
19
2KB
321s