IBC_insiderSUCCESS_RATE
Updated 2024-10-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
COUNT(*) AS TX_number ,
DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS Date ,
COUNT(DISTINCT TX_FROM) AS "active_users" ,
COUNT(CASE WHEN TX_SUCCEEDED='TRUE' THEN 1 ELSE NULL END) * 100 / COUNT(*) AS Success_rate,
SUM(count(*)) OVER (ORDER BY DATE) AS "cumulative_tx"
FROM
lava.core.fact_transactions
where Date > current_date - 400
GROUP BY 2
ORDER BY DATE DESC
QueryRunArchived: QueryRun has been archived