Project Name | Txs Count | Users Count | Total Tx Value in $Kaia | Txs Per Users | Average Tx Value in $Kaia | Active Users Growth % | |
|---|---|---|---|---|---|---|---|
1 | DarkStar | 33586326 | 2967294 | 0 | 11.32 | 0 | 32969833.33 |
2 | Frog Defense | 28399833 | 10523094 | 24021 | 2.7 | 0 | 8993997.44 |
3 | Wonton | 40325 | 16952 | 407298 | 2.38 | 24.03 | 1695100 |
4 | MyStarPick | 428731 | 15037 | 0 | 28.51 | 0 | 1503600 |
5 | Web3.0 PvZ | 676197 | 155140 | 956358 | 4.36 | 6.16 | 1292733.33 |
6 | GimSwap | 198304 | 62224 | 116114261 | 3.19 | 1866.07 | 777700 |
7 | IXS Academy (IxSwap) | 13248 | 11209 | 0 | 1.18 | 0 | 55945 |
8 | Slime Miner | 65969 | 5448 | 77457 | 12.11 | 14.22 | 12006.67 |
9 | Banana | 483618 | 247005 | 318475 | 1.96 | 1.29 | 3307.44 |
10 | Retro.fun | 211 | 45 | 72162 | 4.69 | 1603.6 | 2150 |
11 | Jumping Peng | 163652 | 153663 | 2624 | 1.07 | 0.02 | 1270.89 |
12 | Kyuzos Friends | 28281008 | 2575127 | 0 | 10.98 | 0 | 1137.63 |
13 | SuperZ | 107079 | 42190 | 1111792 | 2.54 | 26.35 | 674.41 |
14 | YuliGO | 236030 | 81036 | 635106 | 2.91 | 7.84 | 378.03 |
15 | Meowtopia | 3587790 | 2665566 | 13000 | 1.35 | 0 | 146.79 |
16 | RaceMaster: Solo Leveling | 3 | 2 | 0 | 1.5 | 0 | 100 |
17 | Goblin Master | 445339 | 118518 | 0 | 3.76 | 0 | 90.47 |
18 | Boxing Star X | 847442 | 204789 | 0 | 4.14 | 0 | 72.93 |
19 | KeitoKun | 2776740 | 208069 | 2 | 13.35 | 0 | 35.41 |
20 | Axolts Escape | 8672 | 7408 | 0 | 1.17 | 0 | 0 |
Sajjadiiiresidential-coral
Updated 2025-04-10
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 dim_label AS (
SELECT
lower(log.value:ADDRESS) AS address,
log.value:CATEGORY AS category,
log.value:PROJECT_NAME AS project_name,
log.value:LABEL_1 AS label
FROM
(SELECT LiveQuery.live.udf_api(
'https://flipsidecrypto.xyz/api/v1/queries/fbe49238-ba79-4d5c-820f-bac6b8b5b215/data/latest'
) AS resp) re
INNER JOIN LATERAL FLATTEN (input => re.resp:data) log
),
app_transactions AS (
SELECT
a.block_timestamp,
a.tx_hash,
a.origin_from_address,
b.tx_fee,
b.value,
c.project_name
FROM kaia.core.fact_event_logs a
INNER JOIN kaia.core.fact_transactions b ON a.tx_hash = b.tx_hash
INNER JOIN dim_label c ON a.contract_address = c.address
WHERE a.tx_succeeded
),
all_data_tab AS (
SELECT
block_timestamp,
tx_hash,
origin_from_address AS user,
value::int AS Tx_value_kaia,
tx_fee,
project_name::string AS project_name,
'In App Transaction' AS category
Last run: 18 days ago
35
2KB
201s