Chris pfp

Chris

@thechriscen

62 Following
73 Followers
Chris pfp
0 reply
0 recast
0 reaction
Chris pfp
0 reply
0 recast
1 reaction
Chris pfp
0 reply
0 recast
3 reactions
Chris pfp
0 reply
0 recast
0 reaction
Chris pfp
0 reply
0 recast
1 reaction
Chris pfp
1 reply
0 recast
4 reactions
Chris pfp
0 reply
0 recast
2 reactions
Chris pfp
2 replies
0 recast
1 reaction
Chris pfp
2 replies
0 recast
11 reactions
Chris pfp
1 reply
0 recast
0 reaction
Chris pfp
1 reply
0 recast
1 reaction
Chris pfp
0 reply
0 recast
1 reaction
Chris pfp
0 reply
0 recast
1 reaction
Chris pfp
1 reply
1 recast
3 reactions
Chris pfp
0 reply
0 recast
0 reaction
Chris pfp
As a Web3 Data Analyst, learning to manually decode event logs is crucial for assessing data accuracy, completeness, and consistency before diving into any analysis. I've published this step-by-step guide to show you "How to Manually Decode Event Logs. thechriscen.substack.com/p/how-to-man... Using a simple Transfer event log, I explain learn how to: - Use the keccak function to find the hash of topic0. - Apply substring functions to extract the addresses of topic1 and topic2. - Use the bytearray function to find the value in the data field. The end result will be a well-decoded event log table that aligns with the Pickle table on @dune.eth A huge thank you to @ilemi for helping me figure out how to execute this query on Dune. dune.com/queries/3968... Feel free to share your feedback and suggestions on future guides I can create to make our Web3 Data journey better. Stay tuned for my next guide on Decoding Ethereum Traces...
0 reply
0 recast
3 reactions
Chris pfp
0 reply
0 recast
2 reactions
Chris pfp
0 reply
1 recast
3 reactions
Chris pfp
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.
1 reply
1 recast
5 reactions
Chris pfp
1 reply
0 recast
3 reactions