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.

I really appreciate your feedback. Thank you so much 👏