COLLECTION_NAME | TOTAL_TRADES | UNIQUE_SELLERS | UNIQUE_BUYERS | UNIQUE_TOKENS_TRADED | TOTAL_VOLUME_USD | AVERAGE_PRICE_USD | MEDIAN_PRICE_USD | HIGHEST_SALE_USD | |
|---|---|---|---|---|---|---|---|---|---|
1 | Axie | 107983 | 17711 | 19198 | 95021 | 7608903.8 | 3.020456238 | 2.87 | 46235.81 |
2 | Axie Material | 40665 | 2080 | 8823 | 10 | 1238914.59 | 1.858733409 | 0.23 | 335.35 |
3 | Axie Land | 359 | 182 | 247 | 307 | 763432.65 | 462.406208359 | 324.98 | 4170.86 |
4 | Axie Rune | 17262 | 2437 | 3626 | 259 | 628749.31 | 3.126270697 | 2.21 | 84.33 |
5 | Axie Consumable Item | 47718 | 962 | 8441 | 4 | 539599.52 | 1.603669542 | 0.08 | 1091.38 |
6 | Axie Charm | 5659 | 1161 | 2095 | 100 | 85704.06 | 2.057769934 | 1.1 | 84.33 |
7 | Axie Land Item | 924 | 125 | 93 | 943 | 25098.05 | 6.596070959 | 0.22 | 485.52 |
8 | Axie Accessory | 1430 | 273 | 478 | 967 | 10448.72 | 1.711502048 | 1.16 | 109.31 |
ellerydurwinfatal-copper
Updated 2025-04-03
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 token_transfers AS (
SELECT
TX_HASH,
ORIGIN_FROM_ADDRESS,
FROM_ADDRESS,
AMOUNT_USD -- افزودن فیلد ضروری
FROM ronin.core.ez_token_transfers
)
SELECT
nt.NAME as collection_name,
COUNT(DISTINCT nt.TX_HASH) as total_trades,
COUNT(DISTINCT nt.FROM_ADDRESS) as unique_sellers,
COUNT(DISTINCT nt.ORIGIN_FROM_ADDRESS) as unique_buyers,
COUNT(DISTINCT nt.TOKEN_ID) as unique_tokens_traded,
SUM(tt.AMOUNT_USD) as total_volume_usd, -- تغییر به tt.AMOUNT_USD
AVG(tt.AMOUNT_USD) as average_price_usd, -- تغییر به tt.AMOUNT_USD
MEDIAN(tt.AMOUNT_USD) as median_price_usd, -- تغییر به tt.AMOUNT_USD
MAX(tt.AMOUNT_USD) as highest_sale_usd -- تغییر به tt.AMOUNT_USD
FROM ronin.nft.ez_nft_transfers nt
JOIN token_transfers tt
ON nt.TX_HASH = tt.TX_HASH
AND nt.TO_ADDRESS = tt.ORIGIN_FROM_ADDRESS
WHERE
nt.NAME ILIKE 'Axie%'
AND nt.BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_DATE())
GROUP BY 1
ORDER BY total_volume_usd DESC;
Last run: 24 days ago
8
557B
154s