Number of Unique Gamers on Ronin | Number of Gaming Transactions | Number of Unique Non-Gamers on Ronin | Number of Non-Gaming Transactions | |
|---|---|---|---|---|
1 | 5906646 | 176733490 | 3843817 | 71072916 |
defi__joshGamers and Non-gamers stats
Updated 14 hours 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
36
›
⌄
WITH game_contracts AS (
SELECT DISTINCT address
FROM ronin.core.dim_labels
WHERE label_type = 'games'
),
gaming_metrics AS (
SELECT
COUNT(DISTINCT tx.from_address) as gaming_users,
COUNT(*) as gaming_txns
FROM ronin.core.fact_transactions tx
INNER JOIN game_contracts g
ON tx.to_address = g.address
WHERE tx.tx_succeeded = TRUE
),
non_gaming_metrics AS (
SELECT
COUNT(DISTINCT tx.from_address) as non_gaming_users,
COUNT(*) as non_gaming_txns
FROM ronin.core.fact_transactions tx
LEFT JOIN game_contracts g
ON tx.to_address = g.address
WHERE tx.tx_succeeded = TRUE
AND g.address IS NULL
)
SELECT
gaming_metrics.gaming_users as "Number of Unique Gamers on Ronin",
gaming_metrics.gaming_txns as "Number of Gaming Transactions",
non_gaming_metrics.non_gaming_users as "Number of Unique Non-Gamers on Ronin",
non_gaming_metrics.non_gaming_txns as "Number of Non-Gaming Transactions"
FROM gaming_metrics
CROSS JOIN non_gaming_metrics;
Last run: about 14 hours agoAuto-refreshes every 12 hours
1
38B
219s