Top NFT by Traders

feyikemiTop NFT by Traders

Updated 2025-04-07

WITH NFT_TXNS AS (

SELECT

block_timestamp,

tx_hash,

from_address AS seller,

to_address AS buyer,

name AS collection

FROM ronin.nft.ez_nft_transfers tr

JOIN ronin.core.ez_decoded_event_logs log

USING (tx_hash, block_timestamp)

WHERE event_name = 'OrderMatched'

AND decoded_log:order[0]:extraData[0][2] = token_id

AND tx_succeeded

AND name IS NOT NULL

-- AND block_timestamp >= CURRENT_DATE - INTERVAL '30 days'

All_Traders AS (

SELECT collection, buyer AS wallet FROM NFT_TXNS

UNION

SELECT collection, seller AS wallet FROM NFT_TXNS

)

SELECT

collection,

COUNT(DISTINCT wallet) AS total_traders

FROM All_Traders

GROUP BY collection

ORDER BY total_traders DESC

LIMIT 10

Last run: about 2 months ago

233B

flipside