All the answers to the most frequently asked questions about how to query transactions, internal transactions, event logs and topics, and more on Ethereum. — All images in this article are created by the author. if you’re looking for more web3 data content, check out my 30-day free course (with videos)! Make sure to subscribe to my newsletter for more courses and educational tips too. >> I WROTE A BEGINNERS GUIDE HERE <<

Using Graph Data Science to compute a reputation score (betweenness centrality) on Mirror user interactions across Twitter, Governance, and Ethereum transactions — This post was first published on ath.mirror.xyz, be sure to subscribe there and follow me on twitter to get my most up-to-date crypto and data science content. Later on, this methodology was used for the first $WRITE token airdrop which you can read about here.

I leveraged the mempool to get a better proxy of user behaviors and emotions when participating in NFT auctions on the artblocks.io platform — User experience (UX) describes how people feel when they interact with a system or service and encompasses several factors including usability, design, marketing, accessibility, performance, comfort, and utility. Don Norman once said, “Everything has a personality; everything sends an emotional signal. Even where this was not the intention of the…

Buy, sell, and mint fractions of NFTs. — This was first published on substack, make sure to follow 0xkowloon on Twitter and substack for more comprehensive protocol deep dives from us. Top NFTs can cost tens of thousands or even millions of dollars. They are out of reach for most retail investors and different teams are tackling this…

Trade and hedge future income. — This was first published on substack, make sure to follow 0xkowloon on twitter and substack for more comprehensive protocol deep dives. Keep an eye out for Element.fi and another SQL analysis of both protocols coming soon! Pendle is a protocol that enables the trading of tokenized future yield on an…

Let’s look at the contracts and queries for the total value locked and user profits of Barnbridge, a credit tranche protocol. — I’m going to create more bite-sized query breakdowns while explaining basic concepts in Ethereum, this is a continuation of the beginner and intermediate guides I wrote. This article is written in partnership with my friend 0xKowloon, please go and check out his deep dive on the solidity architecture of BarnBridge…

Trade with gas efficiency! — This was first published on substack, make sure to follow 0xkowloon for more protocol deep dives. Balancer protocol is an automated portfolio manager, liquidity provider and price sensor. Liquidity providers who want to earn trading fees and rebalance their portfolios can deposit their assets into a balancer pool. Arbitrageurs help…

Understand the history of Ethereum wallets, what Access Legos are, and the implications of both on the future of dapp development and usability. — I’ve talked about product composability of decentralized applications (dapps) before, but with a fairly simplified diagram of the tech stack: In reality, there are two layers I skipped (wallets and SDKs) and some added complexity with multi-chain (layer) dapps:

Stop trying to approach people on LinkedIn; you need to understand the structure of content, conversation, and community. — Networking is an exciting topic that has changed wildly over the years, especially during Covid-19. It used to mean getting someone’s business card, then in the digital world, that card became represented by a connection or a follow. We’ve distilled networking down so much that having a point or signifier…