datavortexRelayer Life SPan Activity
Updated 2024-12-08
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
30
31
32
33
34
35
36
›
⌄
SELECT
predecessor_id AS relayer,
MIN(block_timestamp) AS "first activity",
MAX(block_timestamp) AS "last activity",
DATEDIFF(
'day',
MIN(block_timestamp),
MAX(block_timestamp)
) AS "relayer lifespan days",
CASE
WHEN DATEDIFF(
'day',
MIN(block_timestamp),
MAX(block_timestamp)
) <= 30 THEN '1-30 Days'
WHEN DATEDIFF(
'day',
MIN(block_timestamp),
MAX(block_timestamp)
) BETWEEN 31
AND 60 THEN '31-60 Days'
WHEN DATEDIFF(
'day',
MIN(block_timestamp),
MAX(block_timestamp)
) BETWEEN 61
AND 90 THEN '61-90 Days'
WHEN DATEDIFF(
'day',
MIN(block_timestamp),
MAX(block_timestamp)
) BETWEEN 91
AND 180 THEN '91-180 Days'
WHEN DATEDIFF(
'day',
MIN(block_timestamp),
QueryRunArchived: QueryRun has been archived