Data

At the heart of blockchain data are three fundamental data tables: transactions, traces, and logs. 

These tables capture the lifecycle of a transaction, from its inception to its final state.

Let’s take the example of you transferring USDT to a friend on the Ethereum chain. 

Once you sign the transaction to transfer the ERC-20 token from your wallet, a Transfer Function is triggered, which specifies the recipient and amount.

Behind the scenes, Ethereum creates two key tables: transactions and traces. These tables record details like transaction hash, sender, recipient, transaction status, gas fees, block number, and timestamp.

The transaction's final stage is marked by the emitTransfer function, which generates the logs table. This table includes contract address, event topics, call data, and block information.

By understanding these core components, you will find it easier to query onchain data, and derive actionable insights.

In this first guide on Working with Raw Blockchain Data, I share tips to help you read transaction data on Etherscan and provide some explanations about decoding input data. 

https://thechriscen.substack.com/p/working-with-raw-blockchain-data

Many thanks to @ilemi  for creating the roadmap and guides for me to learn from... 

I hope someone finds this valuable... 
My next guide will focus on understanding Event Logs. Be sure to follow along as we master Web3 data together.

headmaster @duneanalytics, previously mirror and consensys