Archive - Crypto Data Bytes

New

Top

Discussion

A Guide to Solana for Ethereum Analysts

Translating EVM concepts to their Solana counterparts

Nov 22 •

Solana Analytics Starter Guide (Part 4): Solana Events (Logs, Anchor Logs, Event CPI)

Learn how logs work, with Lifinty, Tensorswap, and Jupiter as examples.

Nov 13 •

October 2023

Solana Analytics Starter Guide (Part 3): NFT, pNFT, xNFT, cNFT

Covering the structure of the NFT, programmable NFT (pNFT), executable NFT (xNFT), and compressed NFT (cNFT) - with example queries along the way.

Oct 30 •

Web3 SQL Weekly #9: Sleuthing a Sudoswap Trade

A walkthrough of my flow to put together a view of sudoswap v2 trades

Oct 10 •

Navigating the Structure of Seaport (Opensea)

There are over 60 types of trades possible - let me make them simpler for you to understand.

Oct 5 •

September 2023

Solana Staking and MEV Explained

Covering how Jito stake pools and MEV work (no SQL in this guide)

Sep 22 •

Every ERC Explained (Part 2): Contract Design Patterns

Covering contract deployments, factories, proxies, and upgrades.

Sep 5 •

August 2023

(8) Composability Series: The "Modular Stack" for Dummies

How the "modular stack" unlocks new design space for applications. Written for the non-technical reader.

Aug 25 •

Advanced Wizard Guide to Dune SQL and Ethereum Data Analytics

Giving you the frameworks and functions you need to become an archwizard

Aug 16 •

July 2023

Every ERC Explained (Part 1): All the Tokens

Simplifying and showcasing ERCs across all EVM chains - starting with tokens.

Jul 19 •

Refer readers to Web3 Data Degens and get rewards

Access the data degens, get a project review, and get 1:1 career advice with me - all from referral rewards!

Jul 6 •

June 2023

Web3 SQL Weekly #8: Analyzing Account Abstraction (ERC4337)

Let's look at the top contracts and interactions from smart accounts on Polygon (and other EVM chains)!

Jun 30 •

#nojs-banner { position: fixed; bottom: 0; left: 0; padding: 16px 16px 16px 32px; width: 100%; box-sizing: border-box; background: red; color: white; font-family: -apple-system, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 13px; line-height: 13px; } #nojs-banner a { color: inherit; text-decoration: underline; } This site requires JavaScript to run correctly. Please turn on JavaScript or unblock scripts