Royalties by project

takamoriRoyalties by project

Updated 2024-02-21

select project_name as project, nft_address as address, sum(creator_fee) as royalties, sum(creator_fee_usd),

sum(price) as volume, sum(creator_fee)/sum(price) as ratio

FROM

ethereum.nft.ez_nft_sales

where currency_symbol in ('WETH', 'ETH') and block_timestamp >= '2024-01-01' and creator_fee/(price+.00000000001) < .11

group by 1, 2 having volume > 1-- and ratio <= .11

order by 4 desc

Last run: over 1 year ago

	PROJECT	ADDRESS	ROYALTIES	SUM(CREATOR_FEE_USD)	VOLUME	RATIO
1	PudgyPenguins	0xbd3531da5cf5857e7cfaa92426877b022e612cf8	119.645134849	296900.570851677	73702.11675914	0.001623360903
2	LilPudgys	0x524cab2ec69124574082676e6f654a18df49a048	100.128506212	248366.502347638	25199.886229058	0.00397337136
3	Nobody	0xa28d6a8eb65a41f3958f1de62cbfca20b817e66a	94.913449965	229976.837954558	14213.289661119	0.006677796079
4	Mocaverse	0x59325733eb952a92e069c87f0a6168b29e80627f	94.4761583	224879.69991064	1985.799566	0.04757587821
5	BoredApeYachtClub	0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d	79.169065845	200106.985618986	54414.86414361	0.001454916172
6	OpenSea Shared Storefront	0x495f947276749ce646f68ac8c248420045cb7b5e	82.037129454	198248.783297201	1019.365072481	0.08047865448
7	Captainz	0x769272677fab02575e84945f03eca517acc544cc	75.328798643	181933.042068365	3134.48622099	0.02403226345
8	Azuki	0xed5af388653567af2f388e6224dc7c4b3241c544	72.905653305	173718.484600754	76674.238123023	0.0009508493999
9	TinFun	0xc274a97f1691ef390f662067e95a6eff1f99b504	67.909834781	172652.158114681	8122.628565028	0.008360573703
10	Art Blocks	0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270	68.271780778	169909.729195022	2939.136771065	0.02322851439
11	OVERWORLD INCARNA	0xfdf5acd92840e796955736b1bb9cc832740744ba	70.294851575	167595.636898385	3529.22604042	0.01991792273
12	TOPIA Worlds	0x8d9710f0e193d3f95c0723eaaf1a81030dc9116d	68.88124929	167190.828174359	854.213919393	0.08063700172
13	Koda	0xe012baf811cf9c05c408e879c399960d1f305903	67.191961665	164340.898790298	2017.0605333	0.03331182211
14	MutantApeYachtClub	0x60e4d786628fea6478f785a6d7e704777c86a7c6	65.208393119	161689.803470098	67597.97045074	0.0009646501616
15	Elemental	0xb6a37b5d14d502c3ab0ae6f3a0e058bc9517786e	64.849213779	158783.75596927	9079.524987596	0.007142357543
16	Quirkies	0xd4b7d9bb20fa20ddada9ecef8a7355ca983cccb1	61.438549179	150022.058096872	966.78329099	0.06354945286
17	Mittaria Genesis	0x8ff2e72f8faf05384aeb501ba9644c9759d2fd5f	54.484125225	131552.062227543	753.228502999	0.07233412571
18	MATR1X KUKU	0x596a5cd859ad53fec23cd3fcd77522f0b407920d	53.138544454	130087.696711778	9446.241190824	0.005625363928
19	Moonbirds	0x23581767a106ae21c074b2276d25e5c3e136a68b	47.344863528	126273.647735129	12415.494193447	0.00381336923
20	Creepz by OVERLORD	0x5946aeaab44e65eb370ffaa6a7ef2218cff9b47d	49.387803741	125283.68971548	2679.200556402	0.01843378377

...

2286

241KB

flipside

flipside