tomwanhhlast_update_status
Updated 2024-07-07
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
›
⌄
with
balance as (
select *,
ROW_NUMBER() OVER(ORDER BY block_number asc) as index
from (
select distinct block_number
from ethereum.beacon_chain.fact_validators) a
),
day as (
select date_day as day,
ROW_NUMBER() OVER(ORDER BY date_day asc) as index
from ethereum.core.dim_dates
where date_day>=date('2022-09-15')
and date_day<=date(current_date())
)
select
TIMEDIFF('hour',max(day),current_timestamp())
-- cast(last_update as timestamp) as last_update from (
as time_lag
from balance a
left join day b
on a.index=b.index
QueryRunArchived: QueryRun has been archived