DATE | LABEL_TYPE | ADDRESS_NAME | LABEL_SUBTYPE | DAILY_USERS | TOTAL_INTERACTIONS | AVG_INTERACTIONS_PER_USER | TOTAL_VALUE | AVG_TRANSACTION_VALUE | AVG_INTERACTIONS_PER_ACTIVE_USER | AVG_CONTRACTS_PER_USER | MULTI_GAME_USERS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-04-01 00:00:00.000 | games | pixels: game tracker | general_contract | 185478 | 185478 | 1 | 0 | 0 | 1 | 1 | 0 |
2 | 2025-04-01 00:00:00.000 | games | atias blessing | general_contract | 98420 | 119382 | 1.212985 | 0 | 0 | 1.212985 | 1 | 8432 |
3 | 2025-04-01 00:00:00.000 | games | raffle proxy | rewards | 68369 | 68397 | 1.00041 | 0 | 0 | 1.00041 | 1 | 109 |
4 | 2025-04-01 00:00:00.000 | games | daily checkin proxy | general_contract | 35902 | 35902 | 1 | 0 | 0 | 1 | 1 | 235 |
5 | 2025-04-01 00:00:00.000 | games | check in upgradable proxy | general_contract | 6400 | 6400 | 1 | 0 | 0 | 1 | 1 | 2018 |
6 | 2025-04-01 00:00:00.000 | games | axie | nf_token_contract | 5025 | 11474 | 2.283383 | 0 | 0 | 2.283383 | 1 | 2224 |
7 | 2025-04-01 00:00:00.000 | games | pixels: pixel token | token_contract | 4454 | 7742 | 1.738213 | 0 | 0 | 1.738213 | 1 | 123 |
8 | 2025-04-01 00:00:00.000 | games | axie: axieconsumableconsumerproxy | general_contract | 3865 | 4429 | 1.145925 | 0 | 0 | 1.145925 | 1 | 3696 |
9 | 2025-04-01 00:00:00.000 | games | axie infinity | general_contract | 3795 | 15886 | 4.186034 | 15371.446770812 | 0.9676096419 | 4.186034 | 1 | 3101 |
10 | 2025-04-01 00:00:00.000 | games | axie: axs staking pool | pool | 2390 | 3204 | 1.340586 | 0 | 0 | 1.340586 | 1 | 933 |
11 | 2025-04-01 00:00:00.000 | games | axie: portal | general_contract | 1826 | 2210 | 1.210296 | 0 | 0 | 1.210296 | 1 | 1410 |
12 | 2025-04-01 00:00:00.000 | nft | mavis market | marketplace | 1555 | 4670 | 3.003215 | 72430.401532695 | 15.509721956 | 3.003215 | 1 | 519 |
13 | 2025-04-01 00:00:00.000 | games | axieascendproxy | general_contract | 1075 | 1466 | 1.363721 | 0 | 0 | 1.363721 | 1 | 868 |
14 | 2025-04-01 00:00:00.000 | nft | axie rune | nf_token_contract | 971 | 1061 | 1.092688 | 0 | 0 | 1.092688 | 1 | 545 |
15 | 2025-04-01 00:00:00.000 | nft | axie material | nf_token_contract | 944 | 995 | 1.054025 | 0 | 0 | 1.054025 | 1 | 610 |
16 | 2025-04-01 00:00:00.000 | games | reward distributor proxy for axie quest | rewards | 906 | 906 | 1 | 0 | 0 | 1 | 1 | 664 |
17 | 2025-04-01 00:00:00.000 | nft | ragnarok monsters | nf_token_contract | 772 | 988 | 1.279793 | 0 | 0 | 1.279793 | 1 | 324 |
18 | 2025-04-01 00:00:00.000 | nft | runiverseitem | nf_token_contract | 671 | 732 | 1.090909 | 0 | 0 | 1.090909 | 1 | 431 |
19 | 2025-04-01 00:00:00.000 | nft | wild forest units | nf_token_contract | 660 | 1059 | 1.604545 | 0 | 0 | 1.604545 | 1 | 422 |
20 | 2025-04-01 00:00:00.000 | nft | phzm | nf_token_contract | 627 | 1364 | 2.175439 | 0 | 0 | 2.175439 | 1 | 209 |
m3jieldest-aqua
Updated 2025-04-01
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
›
⌄
-- Gaming and NFT Activity
WITH game_nft_labels AS (
SELECT
address,
address_name,
label_type,
label_subtype,
label
FROM ronin.core.dim_labels
WHERE label_type IN ('games', 'nft')
),
daily_gaming_stats AS (
SELECT
tx.block_timestamp::DATE AS date,
l.label_type,
l.address_name,
l.label_subtype,
COUNT(DISTINCT tx.from_address) AS daily_users,
COUNT(*) AS total_interactions,
SUM(tx.value) AS total_value,
AVG(tx.value) AS avg_transaction_value
FROM ronin.core.fact_transactions tx
JOIN game_nft_labels l ON tx.to_address = l.address
WHERE tx.block_timestamp >= CURRENT_DATE - 90
AND tx.tx_succeeded = TRUE
GROUP BY date, l.label_type, l.address_name, l.label_subtype
),
user_interactions AS (
SELECT
tx.from_address AS user,
l.label_type,
l.address_name,
tx.block_timestamp::DATE AS date,
COUNT(*) AS interaction_count,
Last run: 16 days ago
...
7127
712KB
20s