Last Dashboard Refresh | Last Block Timestamp Available | Data Lag (HH:MM) | BLOCK_ID | |
---|---|---|---|---|
1 | 2025-02-02 10:54:02.000 | 2025-02-02 10:38:10.000 | 00:16 | 317972045 |
marquBANX TGE - Data Freshness
Updated 2024-03-29
99
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
›
⌄
with
block_info as (
select
block_id
, block_timestamp
, floor(datediff('minute',block_timestamp, current_timestamp()) / 60) 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
from solanaUpdate.core.fact_events
where block_timestamp > current_date() - 1
order by block_timestamp desc nulls last
limit 1
)
select
current_timestamp(0) as "Last Dashboard Refresh"
, block_timestamp as "Last Block Timestamp Available"
, lag as "Data Lag (HH:MM)"
, block_id
from block_info
Last run: 21 days ago
1
73B
3s