basic-pink

Updated 2025-04-03

select

tt.ORIGIN_FROM_ADDRESS as trader_address,

count(distinct nt.TX_HASH) as number_of_trades,

count(distinct nt.TOKEN_ID) as unique_nfts_traded,

sum(AMOUNT_USD) as total_volume_usd,

avg(AMOUNT_USD) as avg_trade_value_usd,

median(AMOUNT_USD) as median_trade_value_usd,

max(AMOUNT_USD) as largest_trade_usd

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 >= CURRENT_DATE - 30 -- آخرین 30 روز به جای تاریخ آینده

group by 1

order by total_volume_usd desc

limit 20 -- نمایش 20 تریدر برتر

Last run: 23 days ago

	TRADER_ADDRESS	NUMBER_OF_TRADES	UNIQUE_NFTS_TRADED
1	0xf45a1f9370e1aa21f9ecc00c97246828f4b334a7	1	1
2	0x928637b13cf0d1c62c9122becdce825022cb1e2a	2	2
3	0xf9fe477602caa71e30feefad1efbc6086c7bba5b	2	2
4	0xec62196bc252aab1a1bb10e38f5924cb43459eca	1	1
5	0xb0c7969cc28c89f80fb3979cc90b2ff17bebab2b	1	1
6	0xeaee60e5bb88ccdb1247dbeab7d9c0619ce25f73	1	1
7	0xe877a3d1783b4c593d450cf63a1487e5292f5ff1	1	2
8	0x9edbe69fe941342ae6ce5688cec12ee3f309009b	1	3
9	0x1e8c87ca7180d33373962262d9d4f6e691571ce2	1	1
10	0xf4e482658493e4fc241cfa24a3ef54ead4a5eb72	1	1
11	0xae85ec94ec654fc491e0c65f426e60e455160f6c	5	5
12	0xf0054d021bb0a716aff2529f6a069087363b754b	1	1
13	0x686ff3ff38c974cb36b82dce3fedad91461ddfa3	2	2
14	0x1c2baa29844086af6b4893f7df42d2fc98a664fe	1	1
15	0x985affa50d29aa32fdf0cad4f4177ff0b0214f70	1	1
16	0xcaf6751e19cf982e08d6b1548ca7274587a0d230	2	2
17	0x84a5fde43f2be72314c21a2233787567cbb9e9cb	1	1
18	0xf803d29822f05ad37063c6745c3ec11ca200e106	4	4
19	0x4cb9b0449cae7a54a3ef0cc9b8ff8c730be689ca	1	1
20	0xef7caaeeeaf9dd6d878181278bce5734a9e6dafb	1	1

1KB

flipside