robel91Chainhead Health - Avalanche (blocks > current date - 1)
Updated 2023-04-13
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
›
⌄
WITH totals AS (
SELECT
MAX(block_number) AS max_block,
MIN(block_number) AS min_block,
MAX(block_number) - MIN(block_number) AS block_range
FROM
avalanche.core.fact_blocks
WHERE
block_timestamp > CURRENT_DATE() - 1
),
missing AS (
SELECT
block_number,
LAG(
block_number,
1
) over (
ORDER BY
block_number ASC
) AS prev_block_number
FROM
(
SELECT
DISTINCT block_number
FROM
avalanche.core.fact_blocks
)
),
gaps AS (
SELECT
DATE_TRUNC(
'd',
b.block_timestamp
) AS _date,
A.block_number,
A.prev_block_number,
Run a query to Download Data