Top 5000 LINK Wallets DeFi coins

[Anonymous No.20555570]

Hey anons, I generated a graph that displays the USD values of other DeFi coins held by the top 5000 LINK wallets

I manually excluded every single known address wallet that I could find on etherscan
And I fucked my script up and couldn't pull data for AAVE, which is fucking lame because im 99% sure it would be the most held coin by far. Will probably re-run the data with AAVE included because its in a shit ton of LINK wallets.

Anyways, just wanted to share my findings. Enjoy.

[Anonymous No.20555741]

>>20555570
I also scanned for AAVE (which i 100% fucked up), RLC, BZRX, DMG, and Ampleforth

All of these coins pulled up 0 results, except Ampleforth which had a really fucking small amount
I'm 100% positive there are wallets with aave in them, so im not sure if i also fucked up scanning for RLC, BZRX, and DMG.

[Anonymous No.20555745]

Delet this

[Anonymous No.20555815]

As for how I fucked up scanning for AAVE, I honestly don't know. I pulled this data using each coins contract address that I got from etherscan.
It works perfectly fine with all the coins in the OP pic, but for some reason it didn't pull AAVE, and so I can't be sure why. Considering I just used the contract address, same with all the other coins.

[Anonymous No.20555903]

>>20555570
>usd value
duh you will get coins that already mooned
redo with mcap %

[Anonymous No.20555956]

>>20555903
That's a really good point anon, I will post an additional graph with USD value vs marketcap, aka marketcap %.

Im in a meeting right now, but anyone should be able to do this with the data in OP pic. If its not done in like 10 mins, ill post it

[Anonymous No.20555973]

>>20555741
As a top 2k link holder that also has DMG and bzrx you done goofed

[Anonymous No.20555985]

monitoring

[Anonymous No.20555996]

>>20555570
Surprised to see Maker so low and Compound so high.

Unsurprised to see Kyber so high it's going to $25.

[Anonymous No.20556022]

Top 3k LINK holder here. Just came in to say it feels good to know anons care about what else I hold in addition to my LINK stack.

[Anonymous No.20556049]

>>20555570
there is something that this analysis misses (because, we, link marines, can be a bit crazy)

For instance you don't find my defi coins there because I play with them in another wallet and my linkies are in my ledger and I never ever touch that. A lot of link holders simply don't touch their link wallets. The never selling isn't a meme kek

[Anonymous No.20556097]

>>20555973
Yeah, thanks for confirming this. I suspected i somehow fucked up the other coins that pulled up no results. Weird cause I just used contract address, same as all the ones that worked. Will troubleshoot.

>>20556049
Yes this of course is a major flaw, but its interesting data nonetheless.
I for example have all my LINK on a separate wallet, as well.

[Anonymous No.20556433]

>>20555903
As requested. The same data but instead displayed as % of marketcap held.

RSR coming out clear in 1st place

[Anonymous No.20556944]

>>20555815
did you try aLEND? this is the token you get when you deposit LEND in AAVE.

https://etherscan.io/token/0x7D2D3688Df45Ce7C552E19c27e007673da9204B8?a=0xf7d8450962824b752c30549f66a23e3daad69bca

[Anonymous No.20557769]

>>20556433
Interesting, thank you for that. Might be too complicated to implement, but I think it would be enlightening to see the results excluding nulinker wallets (miscellaneous whales) from these top 5000. There's no way OG linkies are significantly into Compound when they are an unsafe, linkless platform with a direct link competitor. Reserve is also an odd choice for the top, I wonder what's the story behind that.

[Anonymous No.20557898]

>>20557769
Don't think too much about Reserve, it's currently dumping hard haha, just a coordinated PnD by those link holders.

[Anonymous No.20558517]

>>20555570
you fucked this whole thing up dude, these amounts and coins aren't even correct. a cursory glance at the top 1000 wallets shows how much you fucked up

[Anonymous No.20558563]

>>20558517
No I didnt anon, this data is 100% accurate for the coins in the OP pic. The only thing I messed up was not getting any values for AAVE, RLC, DMG, or BZRX

If you're looking at exchange wallets, as I said I excluded all labelled exchange wallets.

[Anonymous No.20558596]

code for reference.
it is sound code, albeit really shitty code.

This pic is missing the if statement i threw in today where I specified to search for specific DeFi coins, but this is the main framework of it

[Anonymous No.20558598]

>>20555570
pretty sure the #1 defi coin that LINK holders also have is REQ lol

[Anonymous No.20558876]

>>20555570
Absolutely based

[Anonymous No.20559014]

>>20557898
Y-yeah, haha. Don't fall for it, sirs. Thiel is dumping his bags as we speak.

[Anonymous No.20559976]

Had a manual look through the top 1kish wallets. Saw a bunch of BAT, PNK, DMG, and AAVE aTokens which are missing here.

e.g. check out finrekt.eth

[Anonymous No.20560178]

>>20555570
>>20555741
Bullish even if the analysis isn't complete for a few of these defi coins

[Anonymous No.20560207]

>>20557769
rsr makes sense because it was the 2nd coun behind link that was shilled hard on biz. look at all the greyscale memes and the tie in with the uberchad photoshoot.

[Anonymous No.20560292]

>>20558596
Could you put it on paste in? Would appreciate thanks

[Anonymous No.20560339]

>>20556433
Nice work. Would love to see this with PNK and BZRX

t. ico linky

[Anonymous No.20560653]

>>20560339
I’ll do a bzrx analysis if OP doesn’t... btw good thread fellas this is some tasty data

[Anonymous No.20561053]

Absolute kek anons, apparently copy pasting the contract address for certain tokens from etherscan directly isnt the EXACT capitalization of the contract address, and thats where the issue with my script was.
Fixing the capitalization of a few of the contracts and will re-run the script

[Anonymous No.20561118]

>>20561053
Thanks for this. Really curious about LEND though

Also really interesting find on RSR holding

[Anonymous No.20561163]

>>20558596
You have to scrape the web page? Surely there is a nice API?

[Anonymous No.20561235]

>>20561163
API max is 1000 for top token holders. To get more than 1000 of the top wallets, i have to scrape the webpage.
Unless I pay for a premium API key, and i aint doin that shit

[Anonymous No.20561506]

Bump, appreciate you sharing this.

[Anonymous No.20561541]

Running the script again and can confirms it is working for all coins i originally messed up, due to contract address capitalization issues.
Will have results for Aave, RLC, DMG, and BZRX once its done running.

[Anonymous No.20561690]

>>20561541
please include PNK bro

[Anonymous No.20561744]

>>20561690
just for you anon i killed the script 900 addresses in and i will restart it with PNK included

[Anonymous No.20561771]

>>20561541
Bumping for more data.

[Anonymous No.20562040]

>>20561744
you are a kind fellow

[Anonymous No.20562591]

>>20561744
post a wallet address i'll tip you

[Anonymous No.20562726]

>>20562591
dont feel at all obligated to tip me anon. /biz/ getting me into LINK in 2017 was arguably the single greatest moment of my entire life. to be determined over the next few years, if it succeeds. either way im never fucking selling.
one of my wallets is:
0x1B77d61547eDD05dE1498Ec3d526B6B446ce4B2e

currently at 1400 addresses, takes a while because i dont want to get timed out on ethplorers API

[Anonymous No.20562813]

>>20562726
cool, give it a minute.

I can't believe it totally slipped everyone's mind here to analyze TRB as well. Don't reset the current one though kek

[Anonymous No.20562965]

>>20562813
absolutely based, thanks anon. will include TRB in future analysis, as im sure many anons have coins they would like put into the bunch as well.

[Anonymous No.20563039]

>>20562965
Why not create a github so people can clone the repo and do their own analysis?

[Anonymous No.20563295]

>>20563039
I could, but desu i am a complete amateur with python and this code is really not impressive at all. I've posted the almost full code earlier in the thread, its just missing my if statement to check for specific predetermined coins as well as a handler i threw in to only print a new address once and then print all the coins in that address

its less than 100 lines total, but if anons want i can repost the code after this scan - with all my changes.
its really shitty code, but it works. would take like 20 mins max to hand copy paste it from the image i posted earlier. plus it runs into errors if wallets dont hold any ERC-20 tokens and i havent added exception handling
never used github before

[Anonymous No.20563391]

>>20563295
ok, maybe I'll do it tomorrow morning but I also don't want to dox myself lol might want to create a new git

[Anonymous No.20563617]

>>20563295
I second, I’ll put it on github. I’ve been meaning to watch a few tutorials about github but I always get lost in biz shitposting

[Anonymous No.20563872]

1500 wallets to go until its done, then ill make pretty graphs and post results.

[Anonymous No.20563928]

This thread is bullish. This that ish i liv4

[Anonymous No.20563955]

>>20555570
thank you datanon

[Anonymous No.20564332]

>>20563872
an actual good thread on biz. thank you.

[Anonymous No.20564504]

Like the other anons said: thank you for quality

[Anonymous No.20564695]

scans finally done, apologies for the delays my friends. i am now going to run my excel formulas to get totals and make pretty graphs.

[Anonymous No.20564850]

>>20558596
Yeah that's incredibly inefficient, can you not find a library that implements something more efficient?

[Anonymous No.20565010]

>>20564850
why dont you do it bitch

[Anonymous No.20565205]

>>20555570
Was in the thread with you yesterday, thanks for following through anon.
>today op was not a fag

[Anonymous No.20565237]

>>20565010
Kek

[Anonymous No.20565443]

>>20564850
I probably could, but I am an amateur and i know the code is shit lol. as this anon put it so perfectly
>why dont you do it bitch
i just haven't seen anyone do something like this on /biz/, and even though im an amateur i thought id go ahead and do it

>>20565205
based, glad you were there anon

>>20560339
>>20561690
>>20562040
>>20562591
>>20562813
I'm still putting together the pretty pictures, but since you are a nice guy and tipped me, the results for BZRX and PNK are as follows:
Total PNK held: 24,970,012
Total USD value: 1,556,231
% of PNK marketcap: 5.135%

Total BZRX held: 6,538,419
Total USD value: 1,875,147
% of BZRX marketcap: 4.656%

Which puts PNK in 2nd just behind RSR from my first scan, and BZRX a close 3rd just behind Kyber. Just wanted to post this for ya real quick, but working through the rest now

[Anonymous No.20565478]

>>20565443
based anon, gracias

[Anonymous No.20565491]

>>20565443
I of course excluded all known exchange wallets with this scan. (Labelled via etherscan, and also i manually checked the top 30 or so left over that weren't labelled in etherscan, and if they had hundreds of tx's in and out daily i excluded them as obvious exchanges)

[Anonymous No.20565493]

>>20565443
This amuses me as I'm a top 200 link wallet that also has RSR and PNK as 3rd and 4th biggest holdings (ETH 2nd). Always wondered how many people here followed my lead.

[Anonymous No.20565758]

Man some absolutely astounding results here, I really dropped the ball in the OP by not including RLC and DMG
RLC sitting at 5.95% of the mcap owned by top 5k LINK wallets
and DMG sitting at a hefty 9.08% of the mcap owned by top 5k LINK wallets, taking clear 1st place

making pics now

[Anonymous No.20565862]

>>20565493
>top 200 linky
Shouldn't you be retired

[Anonymous No.20565894]

>>20565758
Also RLC and AMPL have this weird quirk where, when querying ethplorers API it shows the /actual/ balance and doesn't need the part in my script where i divide by like 10000000000 to normalize the value

So earlier in the thread when i said nobody owns a lot of AMPL, that was wrong. I am normalizing AMPL values and they seem interesting as well

[Anonymous No.20565929]

>>20565894
trb next sir

[Anonymous No.20566043]

>>20565758
Thank you based dataanon

[Anonymous No.20566053]

% of marketcap held cause it holds the most meaning imo, USD graph next

[Anonymous No.20566090]

>>20566053
Could you share the code?

[Anonymous No.20566146]

>>20565862
I could. But I love what I do. Figuring out what the next step is, now that I can up the ante in my life.

[Anonymous No.20566149]

>>20566053
USD value of alts held

[Anonymous No.20566162]

>>20558598
this
please run req

[Anonymous No.20566164]

>>20565894
Can probably use the decimals value for ERC-20s. I'm guessing they don't use the standard 18 so you need that value to get the real figure.

[Anonymous No.20566201]

>>20555570
I will send you eth if you extract all link holders that hold pnk too.

[Anonymous No.20566205]

>>20566053
So what do we buy here? First place doesn't have to be the best option for a small investment right?

[Anonymous No.20566251]

>>20566201
No need to my friend, another anon actually already did that for PNK. Results are here >>20566053
and here>>20566149

Though if you feel generous today one of my addresses is:
0x1B77d61547eDD05dE1498Ec3d526B6B446ce4B2e

I dont want to turn this into a begging thread, so please do not feel at all obligated to tip me anon. I have made more money from /biz/ friends than I ever could have dreamed of, by buying LINK. And im never fucking selling.

[Anonymous No.20566259]

>>20566149
If you guys can’t see kleros being an obvious buy then you’re fucking dumb as shit. Look at all the marketcaps too. Buy pnk if you want to make it.

[Anonymous No.20566295]

>>20565929
>>20566162
Will run more of these in the future for sure, I'm glad my fellow anons are interested in the results.
Hoping I can clean up my mess of code and speed this process up so it doesnt take an hour or more to get results for a set of coins.

>>20566090
I posted pics of the code earlier in the thread

>>20566205
Idk anon, I honestly almost shilled myself into RSR and iExec from these results. But as always DYOR and I am unbiased in presenting this data.

[Anonymous No.20566478]

>>20565493
Why pnk

t. Large holder

[Anonymous No.20566891]

how is RLC 3rd place for % MC but not even on the list for USD?
Small market cap compared to everything else?

[Anonymous No.20566903]

>>20566478
It's already being adopted and it's not only about court cases. Aave uses it for all of their tokens for example.

[Anonymous No.20566924]

>>20566891
My friend iExec is 4th place on the USD chart

[Anonymous No.20566941]

>>20555570
This is kind of why i hate eth. Every transaction ever is linked to your previous accounts. The utxo way in bitcoin is so much better

[Anonymous No.20566990]

>>20566251
>0x1B77d61547eDD05dE1498Ec3d526B6B446ce4B2e
why arent you staking that lit?

[Anonymous No.20567001]

>>20566941
>The utxo way in bitcoin is so much better
I'm not sure I understand what you mean, Bitcoin is just as easily traceable as ETH is

And both can be tumbled through coin tumblers or exchanges to basically wipe yourself clean and untraceable
Except from government entities that can forcibly extract the logs from tumblers/exchanges

The only true privacy is Monero or something else without opt-in privacy

[Anonymous No.20567026]

>>20566990
its like $80 anon.. i cant be fucked to set up staking for like 5 cents a year. if i was heavier in LIT i would do it, but im honestly pretty bearish on LIT, just dont feel like swapping it to something else just in case

[Anonymous No.20567135]

>>20567026
>but im honestly pretty bearish on LIT, just dont feel like swapping it to something else just in case
that's 100% me right now lol

[Anonymous No.20567425]

Do anyone know how much % of mc the 5000 wallets own of link?

[Anonymous No.20567510]

>>20567026
yeah I know, but theres no setup, if you have metamask just go to staking.lition.io and click some buttons. Pretty bearish on it myself but since IDEX banned burgers it wasn't gonna be easy to sell so I used the staking app as like an interest bearing trashcan

[Anonymous No.20567547]

I'm all in link. Should I diversity linkbros?

[Anonymous No.20567715]

>>20567547
grab some LEND, its the most established of all the defi tokens