VOLUME_SEGMENT | UNIQUE_PARTICIPANTS | SEGMENT_TOTAL_VOLUME | |
|---|---|---|---|
1 | Micro Tier (<$1) | 11748 | 3268.598202191 |
2 | Mini Tier ($1-10) | 14142 | 62268.17503906 |
3 | Small Tier ($10-100) | 13730 | 504700.698169039 |
4 | Medium Tier ($100-1k) | 9921 | 3287647.60697403 |
5 | Large Tier ($1k-10k) | 3089 | 8686805.15528302 |
6 | Whale Tier (>$10k) | 347 | 11139175.123215 |
Kruys-Collinsobnoxious-black
Updated 2025-04-01
999
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
›
⌄
-- Runiverse NFT Trading Analysis with Volume Tiers
WITH runiverse_marketplace_activity AS (
-- Identify Runiverse NFT transactions in the marketplace
SELECT
marketplace_events.tx_hash as transaction_id,
nft_sender.from_address AS nft_provider,
payment_sender.from_address AS nft_acquirer,
payment_sender.amount_usd as usd_value
FROM ronin.core.fact_event_logs marketplace_events
LEFT JOIN (
SELECT
tx_hash,
from_address,
amount_usd
FROM ronin.core.ez_token_transfers
WHERE to_address IN (
'0x3ef234bc2a04d86f6041e419458d9acbd077f2c1', -- Collection Offer Proxy
'0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3', -- Market Gateway Proxy
'0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc' -- Market Gateway Multi Send Proxy
)
UNION ALL
SELECT
tx_hash,
from_address,
amount_usd
FROM ronin.core.ez_native_transfers
WHERE to_address IN (
'0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3', -- Market Gateway Proxy
'0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc' -- Market Gateway Multi Send Proxy
)
AND trace_index = 0
) payment_sender ON marketplace_events.tx_hash = payment_sender.tx_hash
LEFT JOIN (
SELECT
tx_hash,
from_address
Last run: 27 days ago
6
272B
22s