261163
Chris
@thechriscen #261163
Crypto Data Nerd | Querying Onchain Data
129 Follower 60 Following
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 😊
For now, all that matters is showing up to do what I love most
Playing the Infinite Game of Crypto + Data 😊
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
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
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...
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...
One thing I love about Crypto:
Come for the Money
Stay for the Tech
Grow with the People.
Crypto is a self sustaining economy...
Come for the Money
Stay for the Tech
Grow with the People.
Crypto is a self sustaining economy...
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
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
People who don't understand Crypto, think we are gambling 😂
We are just ahead of the game...
We are just ahead of the game...
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.
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.
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.
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.
Loading...
Query evt_Transfer table if you're looking to measure the real value of tokens moved between ERC20 contracts.
My world is Onchain & Global 🔮
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
I will never stop building...
Check it out on OpenSea: https://opensea.io/assets/base/0x59ca61566C03a7Fb8e4280d97bFA2e8e691DA3a6/115 @base @devfolio
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...
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...
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 😊
"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 😊
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.
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.
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.
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.
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
I've created a Blast Chain dashboard to track key metrics driving growth in the ecosystem.
https://dune.com/thechriscen/blast-chain-metrics
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!
We are getting ready for the AI revolution...
Get your personal AI agent and fight back against the AI monopolies!
Base' low-cost transaction and affiliation with Coinbase make it a great choice for developers building consumer-focused products.
I've analyzed onchain data with @dune to high key metrics driving growth on @base
...
1. Base TVL has surpassed $1.5 billion.
With growing interest and adoption on Base, approximately $1.503 billion worth of assets are locked across 50 protocols.
The growth in TVL can be attributed to major events like Uniswap V2 deployment, and ongoing "on-chain summer.
I've analyzed onchain data with @dune to high key metrics driving growth on @base
...
1. Base TVL has surpassed $1.5 billion.
With growing interest and adoption on Base, approximately $1.503 billion worth of assets are locked across 50 protocols.
The growth in TVL can be attributed to major events like Uniswap V2 deployment, and ongoing "on-chain summer.
I'm Born to Build and I will keep building Onchain
Loading...
Since discovering @noves its become a lot easier for me to understand chain explorers.
Keep building, you're fulfilling a good mission...
Keep building, you're fulfilling a good mission...
Loading...