NAME | TRADES | N_SELLERS | N_BUYERS | N_TOKENS | VOLUME | AVG_VOLUME | MEDIAN_VOLUME | MAX_VOLUME | |
|---|---|---|---|---|---|---|---|---|---|
1 | Axie | 250638 | 27856 | 33449 | 211526 | 4923928.62 | 4.69192691 | 3.22 | 92475.24 |
2 | Axie Land | 651 | 325 | 447 | 585 | 1079835.94 | 1602.130474777 | 592.1 | 116586.02 |
3 | Axie Material | 100676 | 4213 | 14844 | 10 | 862969.36 | 3.397316536 | 1.14 | 335.35 |
4 | Axie Consumable Item | 114173 | 1716 | 13240 | 4 | 227779.65 | 1.761868536 | 0.46 | 607.48 |
5 | Axie Rune | 12526 | 1863 | 3303 | 216 | 123485.6 | 4.045789922 | 3.01 | 62.82 |
6 | Axie Charm | 4222 | 908 | 1821 | 189 | 22792.73 | 3.15601357 | 1.74 | 62.82 |
7 | Axie Land Item | 729 | 186 | 127 | 826 | 12861.27 | 15.060035129 | 3.61 | 1654.42 |
8 | Axie Accessory | 1844 | 533 | 771 | 1123 | 6448.46 | 3.496995662 | 2.83 | 67.59 |
0xHaM-dAxie NFT Sales by Collection - 2025
Updated 2025-03-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
›
⌄
select
nt.NAME,
count(distinct nt.TX_HASH) as trades,
count(distinct nt.FROM_ADDRESS) as n_sellers,
count(distinct tt.ORIGIN_FROM_ADDRESS) as n_buyers,
count(distinct TOKEN_ID) as n_tokens,
sum(AMOUNT_USD)as volume,
avg(AMOUNT_USD)as avg_volume,
median(AMOUNT_USD)as median_volume,
max(AMOUNT_USD)as max_volume,
from ronin.nft.ez_nft_transfers nt
join ronin.core.ez_token_transfers tt on nt.TX_HASH = tt.TX_HASH and nt.TO_ADDRESS = tt.ORIGIN_FROM_ADDRESS
where nt.NAME ilike 'Axie%'
and tt.ORIGIN_FROM_ADDRESS = tt.FROM_ADDRESS
and nt.BLOCK_TIMESTAMP::date>='2025-01-01'
group by 1
order by 6 desc
Last run: 15 days ago
8
564B
10s