Hi, guys. I want to say sorry for my english in advance.
I have some experience of creating Dune reports. So I decided to use it to find some of Dex Guru Season Pass NFT abusers.
That’s how I did it:
At first my idea was: Lot of abusers make initial funding of their abusive wallets from a same single wallet.
So I decided to make a query analysing all Guru Season Pass minters, find wallets they was initially funded from, group them by this initial funder and sort by number of nft they mint from this initial funder.
When I did this I found that many of minters of this report was initially funded from CEXes wallets. I expected that. I was trying to filter them out manually. But found a better way lately: using a tabel of CEX wallets labels made by Dune users (one address with more than 250k total transactions was not in it, so I add it to filter manually, cuz it is some service obiously).
This way I got a really nice report. A list of abuser wallets who initially funded other wallets to mint Guru Season Pass NFT with number of NFTs they abusively mint. I joined it with an original NFT mintings datatable to create a list of this abusively minted NFTs
Here it is. (original Dune query): Dune There are about 1550 abusive mints over there.
On top of this list there is a guy who abused 198 Guru NFTs (initially funded them all from a single address 0x271d8e39108990e89de0aef49275a194269b58c5). Other guys abused from 30 to 50 NFTs. But a ton of guys are also abused a lower amount of NFTs as well.
Many of those NFTs was transfered (sold on OpenSea or transfered to hide from DexGuru detectives) lately. So I made a list of current Guru Season Pass owners and joined it with this list of abusive minters I made on previous step.
Here it is Dune
There are about 1275 Guru NFTs are still held by those guys who abusivly mint them.
I was checking this list manually on etherscan. I also checked some addresses who abusively minted less than 10 NFTs per wallet. Then I found that some guys was working with this scheme: they minted from 7 to 10 NFTs from one initial funder wallet, but also used those funded wallets to fund another 7 to 10 wallets.
I was looking for a simple way to find those (wallets funding loop) abusers. And I found that there is an easy way to do this: they all minting a Guru NFT on address they used to fund other abusive wallets.
So I made this request which one is looking for minters who initially funded a banch (5 or more of other abusive funders wallets): Dune
There are about 300 of them.
And 224 of them still holds Guru Season Pass NFT atm: Dune
Most of them was found in my main abusers query I made before. But some other guys, who minted less then 10 NFTs on each funders wallet, and hided from main query cuz of using this funding loop scheme, was founded. Not much. Just about an extra 40 abused NFTs was found this way. I filtered them manually by using google spreadsheet (link will be in the end of this post).
In the end I also made a request to find NFTs that are held by those abusive wallets funders accounts: Dune
There are an extra 76 abused NFTs still being held by them.
I took all this data from Dune queries and put it in Google Spreadsheet (it is much easier to view it there). I filtered out some dublicates from it manually as well. Dexguru abusers - Google Tabellen
What we have in the end:
- 1266 abused NFTs which was minted by addresses initially funded 9+ different Guru NFT minter wallets (Dexguru abusers - Google Tabellen)
- 40 abused NFTs who was funded by using a loop of fundings (each funder sent funds to mint from 5 to 8 NFTs) (Dexguru abusers - Google Tabellen)
- extra 76 abused NFTs are held by initial funders wallets of abusers
Total abused NFTs found: 1382