EVENT_CATEGORY | N_USERS | N_TXNS | |
|---|---|---|---|
1 | Gaming Activity | 4764720 | 114138261 |
2 | Asset Transfer | 1136910 | 34838294 |
3 | Other | 610120 | 28496011 |
4 | Item Trading | 579965 | 9049329 |
5 | Token (Staking, Rewards) | 360667 | 3698355 |
6 | Marketplace Activity | 117802 | 3166782 |
7 | Social & Guild Interactions | 5543 | 5837 |
8 | Burn & Sync Mechanics | 3909 | 8103924 |
RamaharCategory Analysis
Updated 2025-02-20
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
›
⌄
-- Web3 Gaming Event Categorization
-- This SQL CASE statement categorizes different event types within a Web3 gaming ecosystem.
-- The categorization is based on the event_name field, which represents various activities in the blockchain-based gaming environment.
-- Each category is supported by observed transaction (`N_TXNS`) and user (`N_USERS`) data to justify its significance.
With filtered_events as (select value:"EVENT_NAME" AS event_name
FROM (
SELECT
livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/a3eb6aac-7e30-4826-aa2a-155e95b897dd/data/latest') as response
), lateral FLATTEN (input => response:data))
select
CASE
-- Gaming Activity
WHEN a.event_name IN ('DailyLogDone', 'Fire', 'RaffleCheckin', 'DailyCheckin', 'StreakUpdated', 'BoughtEnergy', 'AxieEvolved', 'playedGacha', 'batchPlayedGacha') THEN 'Gaming Activity'
-- Item Trading
WHEN a.event_name IN ('Mint', 'Trade', 'Burn', 'Purchase', 'Sell', 'Swap', 'TokenCreated', 'Burned') THEN 'Item Trading'
-- Token (Staking, Rewards)
WHEN a.event_name IN ('Staking', 'Unstaking', 'RewardsClaimed', 'Claim', 'RewardClaimed', 'Farming', 'Liquidity Provision', 'CoreStaked', 'CoreUnstaked', 'Delegated', 'Staked', 'Unstaked') THEN 'Token (Staking, Rewards)'
-- Asset Transfer
WHEN a.event_name IN ('Transfer', 'Deposit', 'Withdraw', 'CCIPSendRequested', 'Withdrawal', 'SafeReceived') THEN 'Asset Transfer'
-- Social & Guild Interactions
WHEN a.event_name IN ('GuildJoin', 'GuildCreate', 'FriendRequest', 'LeaderboardUpdate',
'ReferralUpdated', 'ReferralAdded', 'ReferralRemoved', 'ProfileAdded',
'ProfileAddressChanged', 'VotedToBless', 'VotedToCurse', 'UnvotedToCurse') THEN 'Social & Guild Interactions'
-- Quest & Battle Participation
WHEN a.event_name IN ('BattleStart', 'BattleEnd', 'BattleJoined', 'BattleWon', 'BattleCanceled',
'BattleNullified', 'BattleInitialized', 'CustomBetJoined', 'CustomPrizeTaken',
'CustomBetCreated', 'CustomBetCancelled', 'CustomBetClosed', 'CustomBetRefunded',
'HandleGameResult', 'QuestComplete', 'ArenaEnter') THEN 'Quest & Battle Participation'
Last run: 28 days ago
8
298B
31s