Content
@
0 reply
0 recast
0 reaction
jesse.base.eth 🔵
@jessepollak
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
9 replies
3 recasts
110 reactions
ilemi
@ilemi
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...
3 replies
1 recast
3 reactions
ilemi
@ilemi
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
2 replies
0 recast
3 reactions
ilemi
@ilemi
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
1 reply
0 recast
5 reactions
ilemi
@ilemi
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
3 replies
0 recast
4 reactions
