Data

bytexplorers

data @ op labs, building @optimism 🔴✨ | go /gators 🐊  | casts are my own things | msilb7.com

I just bought a /bytexplorers token that I hope to redeem!

I'd love to explorers to investigate: how many "quality builders" are there are on @base (and how is it growing)? 

define quality however you choose, but find a predictive metric that tracks the number of great builders.

@msilb7 has explored this previously

alright, I'm going to start querying this and replying in this thread with my thinking/work until I finish :)

here is what I'm starting with...

@base builder #001; onchain cities w/ OAK & city3

took a look at some of @msilb7 's queries on developers/contracts, iterating a bit. Working with the features: factory, token category, decoded, usd_value received, times called, unique wallets, unique contract-to-contract callers.

now to get some food while the query runs

headmaster @duneanalytics, previously mirror and consensys

took a look at some of @msilb7 's queries on developers/contracts, iterating a bit. Working with the features: factory, token category, decoded, usd_value received, times called, unique wallets, unique contract-to-contract callers.

now to get some food while the query runs

https://dune.com/queries/3555390

alright, I incorporated more of @msilb7 table (new favorite table) and decided to take a "complexity" measurement approach. Will share some charts soon.

5 - well known project/serious team
4 - fairly technical team (create2 or gnosis deploy
3 - non-factory contract
2 - non-token contract
1 - token contract

Alright, and after adding another layering of quality based on usage I end up with this query/chart. 

Tldr; there are about 1,400 high quality developers on base. medium quality developers have seen more of an uptick recently.

https://dune.com/queries/3555382/5984629

What's interesting to me is that the pure number of contracts of various qualities are all ticking up healthily across the board. The lag in high quality developers means to me that most of the high quality contract growth is coming from a small number of high quality devs.

I left some follow up bounties that would be great for people who want to dive into this further (could test them out as follow up bytelight questions 😉)

@jessepollak if this thread answered your question, then reply with @bytecast answered :)

one last note, comparing @msilb7 's revgen deployers chart to my chart the numbers are fairly similar (1400 revgen devs versus 1600 high quality devs). 

The interesting thing to note is that in my methodology, this is the second peak versus the first peak. Probably some gold insights if we dug a few layers deeper.

Pro tip, when you have a long running query you're building off of, materialize it so you can quickly iterate your other queries. You can then delete the matview when you're done and replace it with a query view again to save the costs/credits. 

I do this a lot when querying complex data

Haha yes I use that for a few columns! Stuff like value transfers and interactions aren’t in there though

You can use contracts.contract_mapping :)