261163
Chris
@thechriscen #261163
Crypto Data Nerd | Querying Onchain Data
97 Follower 58 Following
I just came to know about Purple DAO. It’s fascinating. You can also take the quiz, learn about Purple DAO, and earn some ETH
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.
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
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...
Onchain Metrics of the Day
An analysis of active wallets on @base over the past 30 days reveals USDC, WETH, DOG, Toby, and DEGEN as the top tokens by user activity.
This suggests a strong presence of memes, as retail investors seek to find the next 100x gem tokens.
#cryptodata
An analysis of active wallets on @base over the past 30 days reveals USDC, WETH, DOG, Toby, and DEGEN as the top tokens by user activity.
This suggests a strong presence of memes, as retail investors seek to find the next 100x gem tokens.
#cryptodata
On-Chain Metrics of the Day (on Base)
Daily active addresses on @base in the last 24 hours stand at 478,550, with 40.9% (approximately 195k) being new addresses added since the start of the week.
#crypto #data #base
Daily active addresses on @base in the last 24 hours stand at 478,550, with 40.9% (approximately 195k) being new addresses added since the start of the week.
#crypto #data #base
Onchain Metrics of the Day
Since the Duncan Upgrade, daily transactions on @base have surged from an average of 440k to reach new highs of 3 million in June.
Daily transactions in the last 24 hours hover around 3.35M, indicating sustained interest and activity on the Base.
Since the Duncan Upgrade, daily transactions on @base have surged from an average of 440k to reach new highs of 3 million in June.
Daily transactions in the last 24 hours hover around 3.35M, indicating sustained interest and activity on the Base.