Chris

@thechriscen

58 Following

73 Followers

Chris pfp

Success means different things at different times. For now, all that matters is showing up to do what I love most Playing the Infinite Game of Crypto + Data 😊

0 reply

0 recast

1 reaction

Chris pfp

This Week I built: Superchain DEX Terminal on @dune.eth to track DEX trading activities across all currently supported Superchain networks like @optimism @base @inkonchain @zora @modenetwork https://dune.com/thechriscen/superchain-dex-terminal Full thread 👇 https://x.com/theChriscen/status/1890401477228638478

0 reply

0 recast

3 reactions

Chris pfp

This week, I started building v1 of the Superchain DEX Terminal on @Dune The end goal is to develop a comprehensive dashboard that monitors DEX activities across the Superchain, tracks cross-chain asset transfers, and measures user engagement across all supported chains. It is currently a work in progress, but I anticipate having the full dashboard live next week. One major constraint is that only 6 out of 19 standard networks have their data fully indexed. I hope to resolve this issue with the Dune team. 👨‍💻Let the Superchain data flow...

0 reply

0 recast

0 reaction

Chris pfp

One thing I love about Crypto: Come for the Money Stay for the Tech Grow with the People. Crypto is a self sustaining economy...

0 reply

0 recast

1 reaction

Chris pfp

This Week, I'm building an AI Agent Screener for the Virtuals Ecosystem Dash to show Agents launch, graduation, market performance and developer activities. It's a WIP and will keep shipping to make it better. Let the data flow 👏 https://dune.com/thechriscen/virtuals-protocol-screener

1 reply

0 recast

4 reactions

Chris pfp

Built the Treasury Dash for the love of the Hab. 👏 Nice collaborating with @50cal-eth

0 reply

0 recast

2 reactions

Chris pfp

People who don't understand Crypto, think we are gambling 😂 We are just ahead of the game...

2 replies

0 recast

1 reaction

Chris pfp

My new Growth Advisor @atlas recommends I host a Web3 Data Webinar to help others learn about working with Raw Blockchain Data. Let me know if this is something you're interested in and we can make it work. Many thanks to @jrf for creating this killer app

2 replies

1 recast

18 reactions

Chris pfp

Pretty helpful idea generator. It will be cool to have a feature that allows one specify areas of interest I want an app in. eg. As a Data Analyst, I want to specify and generate app ideas related to building a community or business.

1 reply

0 recast

1 reaction

Chris pfp

Back to my winning streak! 🥳 🥳 I'm so happy to come in first place in the @superchaineco Research Initiative... It was quite insightful exploring how OP Staking can enhance the Superchain Ecosystem.

1 reply

0 recast

1 reaction

Chris pfp

Query evt_Transfer table if you're looking to measure the real value of tokens moved between ERC20 contracts.

0 reply

0 recast

1 reaction

Chris pfp

My world is Onchain & Global 🔮

0 reply

0 recast

1 reaction

Chris pfp

One chain at a time @noves is simplifying onchain data for all.

1 reply

1 recast

3 reactions

Chris pfp

Woohoo! Just minted my Onchain Credential for participating in Onchain Summer Buildathon 🥳✨ I will never stop building... Check it out on OpenSea: https://opensea.io/assets/base/0x59ca61566C03a7Fb8e4280d97bFA2e8e691DA3a6/115 @base @devfolio

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

I love to say the Serenity Prayer everyday of working in crypto. "Lord give me the Serenity to accept the things I cannot change, The Courage to change the things I can and The Wisdom to know the Difference." - While I cannot change the prices, one thing I can control is showing up daily to do my best work in the crypto economy. This too shall pass 😊

0 reply

0 recast

2 reactions

Chris pfp

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.

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

6 reactions

Chris pfp

Blast Chain @blastl2 achieved a total value locked (TVL) of over $1 billion in just 13 days, making it one of the fastest-growing chains of all time. I've created a Blast Chain dashboard to track key metrics driving growth in the ecosystem. https://dune.com/thechriscen/blast-chain-metrics

1 reply

0 recast

3 reactions

Chris pfp

Just created my digital twin with @datalatte. 🤖☕   We are getting ready for the AI revolution... Get your personal AI agent and fight back against the AI monopolies!

1 reply

0 recast

3 reactions