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-16 21:30:02.000 | 2025-02-16 21:06:13.000 | 306781841 |
2 | Aurora | 00:32 | 🟢 Data is up to date! | 1h | 2025-02-16 21:30:02.000 | 2025-02-16 20:58:14.000 | 139898397 |
3 | Avalanche | 00:22 | 🟢 Data is up to date! | 1h | 2025-02-16 21:30:02.000 | 2025-02-16 21:08:18.000 | 57422570 |
4 | Axelar | 00:59 | 🟢 Data is up to date! | 1h | 2025-02-16 21:30:02.000 | 2025-02-16 20:31:13.860 | 16781874 |
5 | BSC | 00:44 | 🟢 Data is up to date! | 1h | 2025-02-16 21:30:02.000 | 2025-02-16 20:46:03.000 | 46719092 |
6 | Base | 01:17 | 🟡 Slightly out of date! | 1h | 2025-02-16 21:30:02.000 | 2025-02-16 20:13:05.000 | 26473719 |
7 | Bitcoin | 00:48 | 🟢 Data is up to date! | 1h | 2025-02-16 21:30:02.000 | 2025-02-16 20:42:24.000 | 884086 |
8 | Cosmos | 04:21 | 🟢 Data is up to date! | 24h | 2025-02-16 21:30:02.000 | 2025-02-16 17:09:58.083 | 24446354 |
9 | Ethereum | 00:28 | 🟢 Data is up to date! | 1h | 2025-02-16 21:30:02.000 | 2025-02-16 21:02:23.000 | 21861511 |
10 | Flow | 00:40 | 🟢 Data is up to date! | 1h | 2025-02-16 21:30:02.000 | 2025-02-16 20:50:08.151 | 103761949 |
11 | Gnosis | 00:29 | 🟢 Data is up to date! | 2h | 2025-02-16 21:30:02.000 | 2025-02-16 21:01:05.000 | 38597627 |
12 | Near | 01:32 | 🟢 Data is up to date! | 12h | 2025-02-16 21:30:02.000 | 2025-02-16 19:58:32.730 | 139895174 |
13 | Optimism | 01:09 | 🟡 Slightly out of date! | 1h | 2025-02-16 21:30:02.000 | 2025-02-16 20:21:25.000 | 132069254 |
14 | Osmosis | 11:12 | 🟢 Data is up to date! | 12h | 2025-02-16 21:30:02.000 | 2025-02-16 10:18:01.574 | 29729370 |
15 | Polygon | 00:37 | 🟢 Data is up to date! | 1h | 2025-02-16 21:30:02.000 | 2025-02-16 20:53:10.000 | 68007465 |
16 | Sei | 00:39 | 🟢 Data is up to date! | 1h | 2025-02-16 21:30:02.000 | 2025-02-16 20:51:32.731 | 132038927 |
17 | Solana | 01:40 | 🔴 Data is out of date! | 1h | 2025-02-16 21:30:02.000 | 2025-02-16 19:50:09.000 | 321100596 |
18 | Terra | 20:15 | 🟢 Data is up to date! | 6h | 2025-02-16 21:30:02.000 | 2025-02-16 01:15:09.601 | 14321845 |
19 | Thorchain | 00:43 | 🟢 Data is up to date! | 12h | 2025-02-16 21:30:02.000 | 2025-02-16 20:47:50.845 | 19898307 |
piperBlockchain Data Status
Updated 14 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 14 hours agoAuto-refreshes every 12 hours
19
2KB
279s