CarlOwOstx success rate
Updated 2022-05-28
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 ETH AS (
SELECT
date(block_timestamp) as eth_date,
count(distinct tx_hash) as eth_tx_count,
count(case when status='SUCCESS' then 1 else null end) as eth_successful_tx_count
FROM flipside_prod_db.ethereum_core.fact_transactions
WHERE block_timestamp >= '2022-05-09' and block_timestamp < '2022-05-28'
GROUP BY 1
ORDER BY 1
),
FLOW AS (
SELECT
date(block_timestamp) as flow_date,
count(distinct tx_id) as flow_tx_count,
count(case when tx_succeeded='TRUE' then 1 else null end) as flow_successful_tx_count
FROM flow.core.fact_transactions
WHERE block_timestamp >= '2022-05-09' and block_timestamp < '2022-05-28'
GROUP BY 1
ORDER BY 1
),
SOL AS (
SELECT
date(block_timestamp) as sol_date,
count(distinct tx_id) as sol_tx_count,
count(case when succeeded='TRUE' then 1 else null end) as sol_successful_tx_count
FROM flipside_prod_db.solana.fact_transactions
WHERE block_timestamp >= '2022-05-09' and block_timestamp < '2022-05-28'
GROUP BY 1
ORDER BY 1
)
-- PUT IT ALL TOGETHER
SELECT
eth_date,
eth_successful_tx_count/eth_tx_count as "Ethereum",
flow_successful_tx_count/flow_tx_count as "Flow",
sol_successful_tx_count/sol_tx_count as "Solana"
Run a query to Download Data