COLLECTION_NAME | TRANSACTION_COUNT | VOLUME_USD | FEES_USD | |
|---|---|---|---|---|
1 | Fableborne Kingdoms | 3129 | 898939.469473737 | 4277.958080879 |
2 | Moki Collection | 2418 | 709303.121544879 | 3464.019692624 |
3 | Sabong Saga Genesis | 1365 | 679876.115609497 | 3363.210236797 |
4 | Original Kanstar | 2871 | 601714.483402006 | 3001.92091264 |
5 | Ronkeverse | 4524 | 481562.783509662 | 2114.12842817 |
6 | Farm Land | 280 | 420219.838983634 | 2070.027594918 |
7 | Adventure LandZ | 2037 | 388788.229570053 | 1831.02471917 |
8 | Primal HeroZ | 15737 | 336032.288701331 | 1631.851024924 |
9 | Fishing Frenzy Founders Pass | 593 | 321423.056379658 | 1597.301603898 |
10 | RuniverseLand | 1326 | 309559.562873649 | 1545.448669994 |
permarycorrect
Updated 2025-04-02
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
›
⌄
WITH order_fulfilled_raw AS (
SELECT
decoded_log,
decoded_log:offer:buyer::string AS buyer_address,
decoded_log:offer:collection::string AS nft_address,
decoded_log:offer:paymentToken::string AS payment_token,
decoded_log:offer:isERC721::boolean AS is_721,
decoded_log:order:seller::string AS seller_address,
decoded_log:order:value::int AS total_price_per_order,
decoded_log:newFulfilledAmount::int AS count_per_order,
event_name,
event_index,
block_timestamp,
tx_hash,
topic_0
FROM ronin.core.ez_decoded_event_logs
WHERE block_timestamp::date >= '2025-01-01'
AND block_timestamp::date < '2025-04-01'
AND contract_address = '0x3ef234bc2a04d86f6041e419458d9acbd077f2c1'
AND event_name = 'OrderFulfilled'
),
order_fulfilled_nfts AS (
SELECT
tx_hash,
event_index,
index AS intra_event_index,
value::string AS token_id
FROM order_fulfilled_raw, LATERAL FLATTEN (input => decoded_log:order:ids)
),
order_fulfilled_nft_count AS (
SELECT
tx_hash,
event_index,
COUNT(1) AS nft_count
Last run: 25 days ago
10
573B
78s