Smart contracts are hard to find and understand. Everyone knows the experience of having ten tabs open just trying to find the right function or contract.

I've built an LLM that abstracts away all of that - say hello to Sage. This is for everyone from BD to analyst to dev. You start off by picking your response level. This can be changed anytime, and I often find myself switching based on the type of question I'm asking.

The response above is at the "user" level.

You've learned how to use a block explorer and basic SQL on Dune. But when it comes to navigating complex protocols, you're stuck because you can't figure out the solidity code or flows between contracts!

This is part of the learning curve of every analyst - let me teach you 😁 The full guide will be linked at the end. We're going to walk through the new Zora x Uniswap extension as an example, trying to answer three questions:

- How is the uniswap pool initiated?
- Who controls the first LP position?
- Who do the pool fees go to?

Many data analysts start out by querying on Dune right away. Instead, they should first learn to break down transactions, traces, and logs on any block explorer.

I've put together a new comprehensive guide for that!

Let's start by understanding the transaction tab: You'll first need to learn to distinguish contract addresses from EOA addresses, which is normally obvious based on if there is a long hex string in the input data or not.

The memecoin craze is back, led in part by the Farcaster with coins like DEGEN, ENJOY, and HIGHER.

I created a dashboard that gives coins financial and social scores, so communities can understand how they stack up against one other and investors can better understand risks.
Generally, memecoins go through five or so life stages as they fight to be at the top.

Farcaster is taking crypto by storm, recently crossing 10k in DAUs. But how does it all work, and how can you work with the data?

I'll walk through the whole protocol and all data structures, and teach you how to query it using Dune and Neynar

📚Link to guide at the end First, you need to understand what's onchain and what's offchain.

The onchain part is split into three contracts to purely handle user registration. When a user registers, they are given an fid and custody address, as well as some storage units.

🚨 New Bytexplorers Quest 🔍

Our first weekly quest is live! Submit your best data work on @jokerace_xyz. This will open each week at noon on Wednesdays and close at midnight on Sundays.

You'll get to earn tokens, and get direct feedback from me and the community. Having a Bytepass is required to participate - a snapshot is taken right before each quest.

Don't know what that is? Check out this thread explaining the Bytexplorers and how to join us.

We're already a group of 80 active members!

https://twitter.com/andrewhong5297/status/1744773100611252650

I'm launching the Bytexplorers, an onchain community for crypto data people to learn and earn together.

Anyone can join by minting a bytepass, and then participating in weekly quests.

🔍 link to learn more and join is in my bio 👈 The first quest will be a set of weekly questions on
jokerace, where you can submit anything you've created. I want to see the work you are most proud of - it can be queries, charts, reports, etc.

Quests start each Thursday. You must mint a bytepass beforehand to participate.

Ready to become part of the top 1% of data wizards in the Ethereum space? 🧙🏆

I've put together my most comprehensive guide on getting the most out of @DuneAnalytics , covering advanced topics and many of my own little tips and tricks.

(link to guide at the end) If you don't already know basic SQL and how to navigate Dune tables - start with the beginners guide.

If you understand one protocol like @Uniswap v2, but cannot easily break down other protocols by yourself - you are at the right level for this guide.

https://twitter.com/andrewhong5297/status/1605237380679892992?s=20

📚 Want to learn about the ERC standards, deployment trends, and example contracts?

Then this new @DuneAnalytics dashboard is for you! It covers all the topics that hit your timeline including token vaults, account abstraction, proxies, and more.

📊 https://t.co/ti0nSZtOWX https://t.co/JoXxelbd1Wtinyurl.com/erc-kit
twitter.com/i/web/status/1…
Today I'll cover token standards on Ethereum mainnet - starting with ERC20. This is the basic fungible token that copies the features of the network token (ETH).

Monthly deploys have consistently increased, up to 30k+ new ERC20s deployed each month in 2023.

Bitcoin ordinals minting today has already surpassed yesterday's mint total (8k and counting)🤯

Trading data incoming... Query if you want to take a look dune.com/queries/198160…

Will have an explainer on this soon, so follow if you don't want to miss that

go follow @Data_Always too as we've been tag-teaming this 🤝

Want to understand how Bitcoin works, and how to analyze its data?

I'll walk you through everything you need to know, with a full written guide and dashboard 🪄 You need to know four tables: blocks, transactions, inputs, and outputs.

The first complex part is understanding how unspent transaction outputs (UTXOs) flow across different transactions.

Here's a chart to help you understand how tokens are tracked and spent:

My 2023 guide to web3 data tools is here! 🪄

These are the most useful tools that data wizards leverage across the analyst journey (discover, explore, dig, and define).

I've written up my thoughts and takes on top features from each product 👇 Just a quick list of the most interesting products to me:
- @MessariCrypto governance board
- @TenderlyApp best multi-chain transaction explorer
- @onceupongg first human-readable block explorer
- @ArkhamIntel balances, counterparties, and flows explorer

You can start analyzing ANY web3 protocol/product in five minutes by understanding how to use this new @DuneAnalytics dashboard.

No solidity knowledge or protocol context needed! 📔I used @opensea for this thread. First, put in any contract address on any chain and run the dashboard. If a protocol has many contracts, try and find the one with the most transactions on Etherscan - that’s likely the main entry point for users.

1/ @compoundfinance is paying me a data bug bounty for finding a missing event in their v3 protocol (first bounty of its kind?). 🤖💸

I’ll dive into some fun intricacies of ERC20s and their protocol below! Shoutout to the team and @rleshner for their fast response and deployment 2/ First off, the governance proposal with all the details is live here - go vote on it if you hold COMP (closes in 2 days) compound.finance/governance/pro…

If you've been in defi for any amount of time, you should be familiar with two types of price oracles:
> off-chain aggregators like @chainlink
> on-chain like @Uniswap TWAP

It's time to compare them! 🧐

The repo and article on working with storage data are linked at the end. On the surface level, ETH/USDC prices from storage look about the same across Chainlink, Uniswap V2, and Uniswap V3.

✨📊My inaugural guide to web3 data is here!

In it, I'll walk you through:
> how and why web3 vs web2 data thinking is different
> layers and players of the data landscape, and key communities
> 3 types of data roles with skills mapped out

ath.mirror.xyz/w2cxg5OP1OEcqv… On thinking, you'll need to understand that open data now means "open data pipeline" rather than "here's some CSVs for u". This changes the flow of work and roles.

I walk through some technical examples of this flow, including a Uniswap proposal @alex_kroeger made last year!

1/17 You can learn a LOT about a community from just on-chain token data. I've split the data into three themes:

- trending user actions
- liquidity and inflation
- membership and inequality

Let's look at tokens from @blvkhvnd , @banklessDAO , @AxieInfinity , and @FWBtweets 2/17 Trending user actions: this tells us high-level how many people are entering/exiting a community, and how existing members act (accumulate or rotate/sell). Communities naturally go through cycles and turnover, below we'll see how each community has evolved.

🚨 DAO research op!

Question: How do we provide more context around tokens and their communities? Can this be represented by a "pulse"?

I dive into a framework for thinking about it and some research goals in the article, but here's a summary...

ath.mirror.xyz/Hiijmt_gzv5_Hf… Right now, when I joined a community like @FWBtweets one of the main screens I see is this:

it tells me nothing about the token really, or the community around it. To really think deeply about this and what we should show, we need to examine web2 vs web3 communities again.

Super excited to announce @OurNetwork__ Learn, partnering with @DuneAnalytics !

We'll teach you how to the gamut of data analytics in Web3, as well as how to communicate your findings effectively.

To top it off, you'll be earning ETH as you learn 🤑

ournetwork.mirror.xyz/7kL5D5wq4tNUza… You'll be learning from some of the best analysts in the space:

@sui414
@josephdcook
@Nifty_Table
@MSilb7
@RantumBits
@0xBoxer
and me of course!