Zanyar_98Number of empty blocks in last 1M blocks
Updated 2022-07-26
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 POLYGON_EMPTY_BLOCKS AS (SELECT COUNT(TX_COUNT) AS CNT, TX_COUNT
FROM polygon.core.fact_blocks WHERE TX_COUNT= 0 AND BLOCK_NUMBER >= (SELECT BLOCK_NUMBER - 1000000
FROM polygon.core.fact_blocks
GROUP BY BLOCK_NUMBER
ORDER BY BLOCK_NUMBER DESC LIMIT 1)GROUP BY TX_COUNT),
Ethereum_EMPTY_BLOCKS AS (SELECT COUNT(TX_COUNT) AS CNT, TX_COUNT
FROM ethereum.core.fact_blocks WHERE TX_COUNT= 0 AND BLOCK_NUMBER >= (SELECT BLOCK_NUMBER - 1000000
FROM ethereum.core.fact_blocks
ORDER BY BLOCK_NUMBER DESC LIMIT 1)GROUP BY TX_COUNT),
Solana_EMPTY_BLOCKS AS (SELECT COUNT(TX_COUNT) AS CNT, TX_COUNT
FROM solana.core.fact_blocks WHERE TX_COUNT= 0 AND BLOCK_ID >= (SELECT BLOCK_ID - 1000000
FROM solana.core.fact_blocks
ORDER BY BLOCK_ID DESC LIMIT 1)GROUP BY TX_COUNT),
--BSC_EMPTY_BLOCKS AS (SELECT COUNT(TX_COUNT) AS CNT, TX_COUNT
-- FROM bsc.core.fact_blocks WHERE TX_COUNT= 0 AND BLOCK_NUMBER >= (SELECT BLOCK_NUMBER - 1000000
--FROM bsc.core.fact_blocks
--ORDER BY BLOCK_NUMBER DESC LIMIT 1)GROUP BY TX_COUNT),
Avalanche_EMPTY_BLOCKS AS (SELECT COUNT(TX_COUNT) AS CNT, TX_COUNT
FROM avalanche.core.fact_blocks WHERE TX_COUNT= 0 AND BLOCK_NUMBER >= (SELECT BLOCK_NUMBER - 1000000
FROM avalanche.core.fact_blocks
ORDER BY BLOCK_NUMBER DESC LIMIT 1)GROUP BY TX_COUNT),
Flow_EMPTY_BLOCKS AS (SELECT COUNT(TX_COUNT) AS CNT, TX_COUNT
FROM flow.core.fact_blocks WHERE TX_COUNT= 0 AND BLOCK_HEIGHT >= (SELECT BLOCK_HEIGHT - 1000000
FROM flow.core.fact_blocks
ORDER BY BLOCK_HEIGHT DESC LIMIT 1)GROUP BY TX_COUNT),
Harmony_EMPTY_BLOCKS AS (SELECT COUNT(TX_COUNT) AS CNT, TX_COUNT
FROM flipside_prod_db.mdao_harmony.blocks WHERE TX_COUNT= 0 AND BLOCK_ID >= (SELECT BLOCK_ID - 1000000
FROM flipside_prod_db.mdao_harmony.blocks
ORDER BY BLOCK_ID DESC LIMIT 1)GROUP BY TX_COUNT),
Run a query to Download Data