PROJECT_NAME | TOTAL_TRANSACTIONS | UNIQUE_USERS | |
|---|---|---|---|
1 | meowtopia | 1978235 | 1056078 |
2 | elderglade | 1430638 | 1044783 |
3 | line minidapp | 676328 | 576924 |
4 | darkstar | 484507 | 147414 |
5 | yuligo | 161234 | 54627 |
6 | frog defense | 145164 | 61599 |
7 | lair | 107919 | 63980 |
8 | superz | 102581 | 41106 |
9 | keitokun | 62355 | 36135 |
10 | slime miner | 16720 | 2071 |
11 | gimswap | 16604 | 14674 |
12 | ix swap | 11329 | 10353 |
13 | axolts escape | 8002 | 7095 |
14 | wizzwoods | 7231 | 3 |
15 | web3.0 plants vs zombies | 2762 | 1714 |
16 | jumping peng | 2378 | 236 |
17 | tcom arena | 339 | 84 |
18 | bulletstorm | 50 | 20 |
19 | retro.fun | 49 | 24 |
20 | defi kingdoms serendale | 12 | 2 |
datavortexdisciplinary-scarlet
Updated 2025-02-24
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_projects AS (
SELECT
DISTINCT project_name,
address
FROM
kaia.core.dim_labels
WHERE
label_type = 'games'
),
first_seen_addresses AS (
SELECT
to_address,
MIN(block_timestamp) AS first_seen_date
FROM
kaia.core.fact_transactions
GROUP BY
to_address
HAVING
MIN(block_timestamp) >= '2024-08-29'
),
filtered_transactions AS (
SELECT
tx_hash,
to_address,
from_address,
block_timestamp
FROM
kaia.core.fact_transactions
WHERE
block_timestamp >= '2024-08-29'
)
SELECT
gp.project_name,
COUNT(DISTINCT ft.tx_hash) AS total_transactions,
COUNT(DISTINCT ft.from_address) AS unique_users
FROM
Last run: 3 months ago
26
652B
30s