GAME_NAME | TOTAL_TRANSACTIONS | USERS | |
|---|---|---|---|
1 | pixels | 22418069 | 1054021 |
2 | axie | 16438910 | 387002 |
3 | the machines arena | 9017058 | 172457 |
4 | apeiron | 4255882 | 169140 |
5 | kalodium | 3964329 | 2466 |
6 | wild forest | 2775004 | 397174 |
7 | axie infinity | 1576000 | 60385 |
8 | tanto kit | 575424 | 85540 |
9 | reward multiplier | 6771 | 1566 |
10 | forkast | 2228 | 1053 |
permaryTop 10 games txn on Ronin
Updated 4 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
dl.label AS game_name,
COUNT(*) AS total_transactions,
count (distinct from_address) as Users
FROM ronin.core.fact_transactions t
LEFT JOIN ronin.core.dim_labels dl
ON t.to_address = dl.address
WHERE t.block_timestamp >= '2025-01-01'
AND t.block_timestamp < '2025-04-01'
AND dl.label_type = 'games' -- Filtering for game contracts
GROUP BY 1
ORDER BY 2 DESC
LIMIT 10;
Last run: 4 days ago
10
289B
7s