sarathpolygon block 5
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 AS
(SELECT (S_TXs/blocks) / ((S_TXs + F_TXs)/blocks) * 100 AS "percentage of successsful TXs", (F_TXs/blocks) / ((S_TXs + F_TXs)/blocks) * 100 AS "percentage of Failed TXs"
FROM (
SELECT COUNT(DISTINCT CASE WHEN STATUS = 'SUCCESS' THEN TX_HASH ELSE null END) AS S_TXs, COUNT(DISTINCT BLOCK_NUMBER) AS blocks,
COUNT(DISTINCT CASE WHEN STATUS <> 'SUCCESS' THEN TX_HASH ELSE null END) AS F_TXs
FROM polygon.core.fact_transactions
)),
ETH AS (
SELECT (S_TXs/blocks) / ((S_TXs + F_TXs)/blocks) * 100 AS "percentage of successsful TXs", (F_TXs/blocks) / ((S_TXs + F_TXs)/blocks) * 100 AS "percentage of Failed TXs"
FROM (
SELECT COUNT(DISTINCT CASE WHEN STATUS = 'SUCCESS' THEN TX_HASH ELSE null END) AS S_TXs, COUNT(DISTINCT BLOCK_NUMBER) AS blocks,
COUNT(DISTINCT CASE WHEN STATUS <> 'SUCCESS' THEN TX_HASH ELSE null END) AS F_TXs
FROM ethereum.core.fact_transactions
WHERE BLOCK_TIMESTAMP::DATE >= '2022-06-01'
)),
AVALANCHE AS(
SELECT (S_TXs/blocks) / ((S_TXs + F_TXs)/blocks) * 100 AS "percentage of successsful TXs", (F_TXs/blocks) / ((S_TXs + F_TXs)/blocks) * 100 AS "percentage of Failed TXs"
FROM (
SELECT COUNT(DISTINCT CASE WHEN STATUS = 'SUCCESS' THEN TX_HASH ELSE null END) AS S_TXs, COUNT(DISTINCT BLOCK_NUMBER) AS blocks,
COUNT(DISTINCT CASE WHEN STATUS <> 'SUCCESS' THEN TX_HASH ELSE null END) AS F_TXs
FROM avalanche.core.fact_transactions
WHERE BLOCK_TIMESTAMP::DATE >= '2022-06-01'
)),
ARBITRUM AS(
SELECT (S_TXs/blocks) / ((S_TXs + F_TXs)/blocks) * 100 AS "percentage of successsful TXs", (F_TXs/blocks) / ((S_TXs + F_TXs)/blocks) * 100 AS "percentage of Failed TXs"
FROM (
SELECT COUNT(DISTINCT CASE WHEN STATUS = 'SUCCESS' THEN TX_HASH ELSE null END) AS S_TXs, COUNT(DISTINCT BLOCK_NUMBER) AS blocks,
COUNT(DISTINCT CASE WHEN STATUS <> 'SUCCESS' THEN TX_HASH ELSE null END) AS F_TXs
FROM arbitrum.core.fact_transactions
)),
OPTIMISM AS (
SELECT (S_TXs/blocks) / ((S_TXs + F_TXs)/blocks) * 100 AS "percentage of successsful TXs", (F_TXs/blocks) / ((S_TXs + F_TXs)/blocks) * 100 AS "percentage of Failed TXs"
FROM (
SELECT COUNT(DISTINCT CASE WHEN STATUS = 'SUCCESS' THEN TX_HASH ELSE null END) AS S_TXs, COUNT(DISTINCT BLOCK_NUMBER) AS blocks,
COUNT(DISTINCT CASE WHEN STATUS <> 'SUCCESS' THEN TX_HASH ELSE null END) AS F_TXs
FROM optimism.core.fact_transactions
Run a query to Download Data