IacomusPoly Block EDA
Updated 2022-07-24
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 when_prior AS
(SELECT *,
CASE WHEN BLOCK_ID - 1 = LAG(BLOCK_ID, 1) OVER(ORDER BY BLOCK_ID) THEN
DATEDIFF (seconds, BLOCK_TIMESTAMP, LAG(BLOCK_TIMESTAMP, 1) OVER(ORDER BY BLOCK_ID))*-1
END AS TIME_DIFF
FROM
(SELECT BLOCK_ID, BLOCK_TIMESTAMP
FROM flipside_prod_db.polygon.transactions
GROUP BY 1,2)
)
-- SELECT MIN(TIME_DIFF), MAX(TIME_DIFF), AVG(TIME_DIFF)
-- FROM when_prior
SELECT *
FROM when_prior
-- WHERE TIME_DIFF <= 217
WHERE TIME_DIFF = 1
LIMIT 50
-- SELECT MIN(BLOCK_ID) MIN, MAX(BLOCK_ID) MAX, MAX-MIN, COUNT(DISTINCT BLOCK_ID)
-- FROM flipside_prod_db.polygon.transactions
-- WHERE BLOCK_ID > 29240000
-- ORDER BY BLOCK_ID
-- SELECT MIN(BLOCK_NUMBER) MIN, MAX(BLOCK_NUMBER) MAX, MAX-MIN, COUNT(DISTINCT BLOCK_NUMBER)
-- FROM polygon.core.fact_blocks
-- WHERE BLOCK_NUMBER > 31000000
-- 29240000
-- 2233584
Run a query to Download Data