Total Transactions | Unique Users | Transaction Success Rate | Succeeded Transactions | Failed Transactions | Total Gas Fees ($RON) | Average Gas Fees Per User | Average Transactions Per User | Transaction To User Ratio (%) | |
|---|---|---|---|---|---|---|---|---|---|
1 | 57941690 | 3816786 | 99.984793 | 57932879 | 8811 | 76658.307737062 | 0.02008451816 | 15.180754 | 6.587288 |
i_danPixel: Total Metrics
Updated 8 days ago
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
›
⌄
-- Daily Pixel Metrics on Ronin
WITH base_data AS (
SELECT
to_address AS game_contract
, from_address AS user
, tx_succeeded
, tx_hash
, tx_fee
FROM ronin.core.fact_transactions
WHERE to_address IN (
'0x02790f32ad7e7eaaecfb0ad21950829932f1a2ee',
'0x7eae20d11ef8c779433eb24503def900b9d28ad7'
)
)
-- Final query combining all metrics
SELECT
COUNT(DISTINCT tx_hash) AS "Total Transactions"
, COUNT(DISTINCT user) AS "Unique Users"
, SUM(CASE WHEN tx_succeeded THEN 1 ELSE 0 END) * 100.0 / NULLIF(COUNT(tx_hash), 0) AS "Transaction Success Rate"
, COUNT(CASE WHEN tx_succeeded = 'TRUE'THEN tx_hash END) AS "Succeeded Transactions"
, COUNT(CASE WHEN tx_succeeded = 'FALSE'THEN tx_hash END) AS "Failed Transactions"
, SUM(tx_fee) AS "Total Gas Fees ($RON)"
, SUM(tx_fee) / NULLIF(COUNT(DISTINCT user), 0) AS "Average Gas Fees Per User"
, COUNT(tx_hash) * 1.0 / NULLIF(COUNT(DISTINCT user), 0) AS "Average Transactions Per User"
, COUNT(DISTINCT user) * 100.0 / NULLIF(COUNT(tx_hash), 0) AS "Transaction To User Ratio (%)"
FROM base_data
--ORDER BY total_transactions DESC;
Last run: 8 days ago
1
93B
1s