PROJECT | Total Active Addresses | WAA | MAA | |
|---|---|---|---|---|
1 | Wild Forest | 70859 | 70859 | 70859 |
2 | Apeiron | 69 | 69 | 69 |
3 | Lumiterra | 59 | 59 | 59 |
4 | The Machines Arena | 21 | 21 | 21 |
5 | Axie Infinity | 19 | 19 | 19 |
6 | Fableborne | 15 | 15 | 15 |
7 | Pixel | 8 | 8 | 8 |
picasoworking-yellow
Updated 2025-02-17
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 *
FROM VALUES
('0x363c3b97152e161cea85e0e5dc52dfdca01a2db1', 'Wild Forest'),
('0x7328022f57eb7f102e73338abca28bc6d149f020', 'Apeiron'),
('0xd0389555de18b0e7aa2b50a4305fe5c96d7f58aa', 'Lumiterra'),
('0x83bb83f107d5f32210b035ffcfb82b8eb63a5643', 'Apeiron'),
('0x5cd9a31bd6eb78e3edb8682185d52ed0b8f0dd82', 'The Machines Arena'),
('0x04fb5df89cd9880a1b377a5f10cb7dd38032333d', 'Pixel'),
('0x4c93991aaa31f3f6879025e5201cb1945e82117d', 'Lumiterra'),
('0xd8deae5e75750512b50ef20dbf8e0163af3d6acc', 'Fableborne'),
('0x03affae7e23fd11c85d0c90cc40510994d49e175', 'Wild Forest'),
('0x704a083a25167f1be97fb9d8ba8f626789b0cdd0', 'Axie Infinity')
AS t (contract_address, project)
),
transaction_data AS (
SELECT
t.project,
from_address AS address
FROM ronin.core.fact_transactions ft
JOIN game_contracts t ON ft.to_address = t.contract_address
UNION
SELECT
t.project,
to_address AS address
FROM ronin.core.fact_transactions ft
JOIN game_contracts t ON ft.from_address = t.contract_address
),
active_addresses AS (
SELECT
project,
COUNT(DISTINCT address) AS total_active_addresses
FROM transaction_data
GROUP BY project
Last run: 2 months ago
7
178B
6s