A couple of days ago, U.S. Senator Elizabeth Warren expressed that "Crypto Puts Financial System in the Hands of 'Shadowy Super-Coders'". Check out the full story here. This quickly turned into a trending meme on CT:
While crypto skeptics make criticisms, we want to give tributes to all Shadowy Super-Coder out there who contributed to the blockchain ecosystem!
This repo contains queries run on ethereum public dataset on google bigquery which are used for the NFT and perks drop. Here are the rules and result:
110,294 Ethereum addresses who:
- Deployed at least 1 contract on Ethereum mainnet before August 1st, 2021.
- Deployed contracts that had at least 2 different non-deployer addresses interacted.
These addresses are ranked in two tiers:
- Tier 1 7,466 Shadowy Super-Coders: those that served >=500 unique addresses & contracts had at least 1 transaction in 2021.
- Tier 2 102,828 Shadowy Coders: those that served less <500 unique addresses or those that served >=500 but have no active transaction since 2021.
Special shout out to our Super-Coder friend @banteg who helped curate data.
As we run the queries on Google big query, we export the results to a public google folder here. You can also find it under this repo, it's under:
results/eligible.csv
results/tier-1.csv
results/tier-2.csv
Check below scripts in this repo for details:
scripts/create_views.sql
scripts/queries.sql