Top 10 Collections Minted By Same Minters In Seiyans

bobby_danielTop 10 Collections Minted By Same Minters In Seiyans

Updated 2025-04-02

with nft_minters as (

SELECT

distinct BUYER_ADDRESS as nft_to_address

FROM sei.nft.ez_nft_sales

WHERE

NFT_ADDRESS = lower('{{NFT_1}}')

AND event_type = 'sale'

)

Select

PROJECT_NAME,

count (1) as mints

From sei.nft.ez_nft_sales

Where BUYER_ADDRESS in (select nft_to_address from nft_minters)

AND NFT_ADDRESS != lower('{{NFT_1}}')

AND block_timestamp >= '2025-01-01'

Group by 1

qualify row_number() over (order by mints desc) <= 10

---------------------- CORERCT CODE --------------------------------------------

-- SELECT

-- PROJECT_NAME,

-- count(1) as mints,

-- SUM(amount) AS "total volume $sei"

-- FROM sei.nft.ez_nft_sales

-- WHERE nft_address in ( 'sei1g2a0q3tddzs7vf7lk45c2tgufsaqerxmsdr2cprth3mjtuqxm60qdmravc', 'sei1n0fxy0lshvw48cnvwzy5tmcutcm6l98mha5u6av4k7nwwt7wkd7suhggey')

-- AND event_type = 'sale'

-- AND block_timestamp >= '2025-01-01'

-- GROUP BY 1

-- qualify row_number() over (order by mints desc) <= 10

-------------------------------------------------------------------------------------

Last run: about 2 months ago

	PROJECT_NAME	MINTS
1	Outlines Digital Trading Cards	32
2	dob	30
3	WeBump	29
4	Outlines	23
5	Yaka Voyager	23
6	CAPPYS	22
7	Plunk	21
8	RED PEPE	16
9	The Farmors	16
10	Fuckers	16

177B

flipside

flipside