COLLECTION | N_SALES | BUYERS | SELLERS | SALES_VOLUME_USD | AVG_PRICE_USD | MEDIAN_PRICE_USD | MAX_PRICE_USD | FLOOR_PRICE_USD | |
|---|---|---|---|---|---|---|---|---|---|
1 | Wild Forest Units | 25817 | 2101 | 2664 | 124720.737614113 | 1.690715996 | 0.1295 | 1495.9813 | 3.322494e-20 |
2 | Axie | 16670 | 5574 | 5173 | 1618041.31254484 | 96.077508019 | 34.848430813 | 92475.24 | 1.71763758e-17 |
3 | Ragnarok Monsters | 14970 | 1722 | 2341 | 184075.997866944 | 4.835071258 | 1.1517 | 1380.581894489 | 7.82202e-19 |
4 | Primal HeroZ | 14387 | 1670 | 2816 | 325189.610432888 | 16.2100399 | 6.208413 | 2678.617470642 | 1.591185964e-12 |
5 | RuniverseItem | 7165 | 1481 | 1681 | 54313.315077881 | 2.753805967 | 0.15824376 | 212.1 | 3.1118334e-19 |
6 | PHZM | 5023 | 794 | 3467 | 335535.650647187 | 8.327806474 | 4.0704 | 1085.4 | 2.92283987e-12 |
7 | Sunflower Land Pass | 4974 | 3399 | 2428 | 22176.423960733 | 3.916020477 | 0.7896016 | 36.98611116 | 2.0871378e-19 |
8 | 3881 | 872 | 992 | 69045.510113227 | 11.655217777 | 0.4312129634 | 7301.12 | 1.8150644e-19 | |
9 | Fishing Frenzy Rods | 3460 | 1517 | 837 | 12592.867460668 | 2.810280621 | 1.0846494 | 191.18701113 | 2.117537275e-12 |
10 | Nyang Kit | 3339 | 613 | 1468 | 92056.74930469 | 3.586719758 | 0.6036 | 1820.85 | 1.436197191e-18 |
0xHaM-dTop Collection by Sales
Updated 2025-04-08
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 eventTb as (
select
block_timestamp,
tx_hash,
tr.from_address as seller_add,
tr.to_address as buyer_add,
tr.contract_address as contract_address,
tr.name as collection,
p.symbol,
token_id,
log.decoded_log:acceptedSettlePrice / 1e18 as nft_price,
(log.decoded_log:acceptedSettlePrice / 1e18)*price as amount_usd,
((log.decoded_log:acceptedSettlePrice / 1e18)*price)/quantity as price_usd,
log.decoded_log:settleToken as token_add
from ronin.nft.ez_nft_transfers tr
join ronin.core.ez_decoded_event_logs log using (tx_hash, block_timestamp)
left join ronin.price.ez_prices_hourly p on date_trunc('hour', block_timestamp) = hour and log.decoded_log:settleToken = token_address
where event_name = 'OrderMatched'
and decoded_log:order[0]:extraData[0][2] = token_id
and tx_succeeded
)
select
collection,
count(distinct tx_hash) as n_sales,
count(distinct buyer_add) as buyers,
count(distinct seller_add) as sellers,
sum(price_usd) as sales_volume_usd,
avg(price_usd) as avg_price_usd,
median(price_usd) as median_price_usd,
max(price_usd) as max_price_usd,
min(price_usd) as floor_price_usd,
from eventTb
where year(block_timestamp::date) = '2025'
and collection is not null
group by 1
order by 2 desc
Last run: 15 days ago
10
941B
21s