5-NFT Legit Trading Activity

bobby_daniel5-NFT Legit Trading Activity

Updated 2025-04-03

SELECT

s.mint,

s.nft_name,

s.nft_collection_name,

COUNT(DISTINCT s.tx_id) as total_sales,

COUNT(DISTINCT CASE WHEN s.buyer_address = s.seller_address THEN s.tx_id END) AS self_trades,

COUNT(DISTINCT s.buyer_address) AS unique_buyers,

COUNT(DISTINCT s.seller_address) AS unique_sellers,

AVG(s.price) AS avg_price_sol,

MAX(s.price) AS max_price_sol,

MIN(s.price) AS min_price_sol,

AVG(s.price_usd) AS avg_price_usd,

COUNT(DISTINCT s.buyer_address || s.seller_address) / NULLIF(COUNT(DISTINCT s.tx_id), 0) as wallet_concentration_ratio

FROM solana.nft.ez_nft_sales s

WHERE s.block_timestamp >= CURRENT_DATE - 30 -- Extended to 30 days

AND s.succeeded = TRUE

GROUP BY 1,2,3

HAVING

total_sales >= 3 -- Reduced from 5

AND unique_buyers + unique_sellers >= 2 -- Removed upper limit

AND max_price_sol > avg_price_sol * 1.5 -- Reduced price variance threshold

ORDER BY total_sales DESC

Last run: about 2 months ago

	MINT	NFT_NAME	NFT_COLLECTION_NAME	TOTAL_SALES	UNIQUE_BUYERS	UNIQUE_SELLERS	AVG_PRICE_SOL	MAX_PRICE_SOL	MIN_PRICE_SOL	AVG_PRICE_USD	WALLET_CONCENTRATION_RATIO
1	AbV1G9iiijgZGpggM4mAFytfwVEtAHMhxrgqxETxYtA9	4192.solmap		72	40	40	3.056728917	8.16	2.7132	434.30962298	0.763889
2	FnKmXihFyDKfVoVAuSVewFmtJBEiFFUjoXGbbXLzVnCy	Froganas #1843	Frogana	55	44	43	1.06034602	2.400218241	0.842193	132.919381529	0.981818
3	DdXDFohqJGsuA4sX4s9UBVR4yuCaCruyBjXtgUqqSdK3	Froganas #4107	Frogana	46	44	44	1.049165813	1.836	0.841995	144.858137498	1
4	AVpi7ERxhpqxfMRoS1T53NNaZVBsUgwUSW7wgaKLRKDn	Froganas #3994	Frogana	38	32	31	1.07625342	1.841	0.899436	135.861585304	0.973684
5	7YUW9wE6N3UuK2JDhgDQ7ReVLRHVhmzHhEPjHvtebqyz	Fox #584	Transdimensional Fox Federation	30	22	23	5.210942109	125.46	0.9899	140.942816685	1
6	9ArniSikHgLReYfYQMY5YciwQCLzwkf9Y6Xqh4nsGDYm	The Heist #5168	The Heist	28	26	6	1.049513722	1.61	0.20265	143.519967012	1
7	AL2P8A8cthCF2oWCMm5BGyofQK3xGVDr5JuByWQC2SZj	Froganas #4954	Frogana	24	21	21	1.155204302	1.734	0.916146	149.743796723	1
8	EvDdq6kDVat4KdUMGrc5jPGBqmYDHPwL8FLHA9JGUKEx	The Heist #3178	The Heist	18	15	7	0.7033099004	1.396000001	0.221572	92.269109207	1
9	2KRJKxh6qVwLE4nTexxCT6TDCEyb7GZZmTKb3nrJQ1AW	PP24		17	2	2	0.002675	0.03317	0.000107	0.33707889	0.117647
10	2asi3S6vDqqHZ6DvtGt45KuYHtquhtXjjE26xWtrEEto	PP53		16	4	3	0.003036125	0.03424	0.000107	0.3826521294	0.25
11	75jyZGZfCqKjYkVmsSPMBsxLcdXa9DCE4YKnhT1rqjLG	PP51		16	2	2	0.00430675	0.03531	0.000107	0.5417604606	0.125
12	3WRZXvydi9JSjNrSMF8FzRJSMrJBJPQgNZEf31Kbh99j	PP13		16	2	2	0.0033705	0.03531	0.000107	0.4249391981	0.125
13	3HUchydoe2LH5Wxj9dXy8wgrQnxghC1wsgeFfSDmuoFk	PP23		16	2	2	0.003169875	0.03424	0.000107	0.3995902294	0.125
14	9WWL2tact3NWbf213GV98Sk4BC99cNqCUz1nqtfChQMP	Truther #736		16	8	7	0.07882565625	0.2299	0.015675	10.283631885	0.75
15	4udXtYJPv8rkdybo8hVs4bajc93CqYJSMHuxr96d9KGQ	PP65		15	2	2	0.001526533333	0.0214	0.000107	0.1920993113	0.133333
16	5vZW8Z8eTasmEtj2TK29if4vyc18KuT4GfhX2VDMQP9x	PP15		15	2	2	0.001954533333	0.02782	0.000107	0.2459288713	0.133333
17	7tGtEFa8WHt4TsUsVsX2a4qA9CAQTZtCtsZJ8KXX2SHc	PP18		15	2	2	0.0025252	0.03638	0.000107	0.317701618	0.133333
18	8keq5nnPepWbVdVrM7NN2TaZC9STEeTwYTCe6Tdob2mw	PP61		15	2	2	0.002810533333	0.04066	0.000107	0.3535879913	0.133333
19	5q6hXbhgDWXXkENbgown82mw5isKosLC9uKyqonPxnJ9	PP19		15	2	2	0.001811866667	0.02568	0.000107	0.2279856847	0.133333
20	57R7VGYLW6JkKmEcgipUAEnGP86MoyzFKLo3bidtEfw9	PP22		15	2	2	0.0016692	0.02354	0.000107	0.210042498	0.133333

...

758

90KB

flipside

flipside