261163
Chris
@thechriscen #261163
Crypto Data Nerd | Querying Onchain Data
130 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
20965
Calvin 🎩🔥🐹🍖
@50cal-eth·17:11 06/12/2024
ATTN all Habs:
The Hab Dash is now live. Check out how MFing rich we are 🎩
Data includes Total Treasury Balance, Total Balance Over Time, and Transaction History
HUGE thanks to @thechriscen for Developing the code
https://dune.com/50thycal/hab-dash
The Hab Dash is now live. Check out how MFing rich we are 🎩
Data includes Total Treasury Balance, Total Balance Over Time, and Transaction History
HUGE thanks to @thechriscen for Developing the code
https://dune.com/50thycal/hab-dash
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.
261163
Chris
@thechriscen·01:07 15/10/2024
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.

🧠 App Ideas 💡
🧠 App Ideas 💡: "What app should you create?" - built with Atlas by jrf
www.heyjoinatlas.com
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.
288927
SuperchainEco.eth
@superchaineco·12:57 04/09/2024
After four weeks of intensive research, the winners of the SuperchainEco x @primedao Research Initiative have been picked🥁
The Winners are:
🥇 @thechriscen
🥈 @cooki
🥉 Degem2priceless
🎖️ @brandynham.eth
🎖️ @polkadot
Thank you to everyone who submitted their research 🫶
The Winners are:
🥇 @thechriscen
🥈 @cooki
🥉 Degem2priceless
🎖️ @brandynham.eth
🎖️ @polkadot
Thank you to everyone who submitted their research 🫶
Query evt_Transfer table if you're looking to measure the real value of tokens moved between ERC20 contracts.
My world is Onchain & Global 🔮
3632
ChristianØ
@christian·19:16 21/08/2024
Believe it or not, /berachain 🐻⛓️ doesn't like everything raw. Especially blockchain data.
Introducing the Noves Extension for Berachain.
🧵
Introducing the Noves Extension for Berachain.
🧵
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.
261163
Chris
@thechriscen·13:30 30/07/2024
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.

Working with Raw Blockchain Data- Part 1
Understanding how transactions, traces, and logs is the foundation for mastering blockchain data.
thechriscen.substack.com
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!
587890
Nanaonchain
@nancymuorah.eth·13:06 08/07/2024
Some weeks ago, we started building @Maester_xyz a platform where you can discover dApps tailored to your specific needs by searching for any usecases or requirements you want.
-Scenario:
Prompt: A token-gated platform for web3 content publishing.
Response: @paragraph_xyz
@sir-damilare @jessepollak @statuette @serrasari @carlosjmelgar @ted
-Scenario:
Prompt: A token-gated platform for web3 content publishing.
Response: @paragraph_xyz
@sir-damilare @jessepollak @statuette @serrasari @carlosjmelgar @ted
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.
3632
ChristianØ
@christian·19:39 03/07/2024
/noves is now natively integrated on the /rari explorer.
Block explorers shouldn't be so complex. They shouldn't be for the technically savvy only. They should be readable — actually readable.
For blockchain as a whole, we seriously need better data. And that's what we're going to do. One by one, if we have to.
Block explorers shouldn't be so complex. They shouldn't be for the technically savvy only. They should be readable — actually readable.
For blockchain as a whole, we seriously need better data. And that's what we're going to do. One by one, if we have to.
I'm Born to Build and I will keep building Onchain
8446
Filipe Macedo
@macedo·11:30 01/07/2024
We’re all wasting our time
So don’t tell us that
Builders can change the world
Because the truth is
Blockchain is a fantasy
And we don’t trust anyone who says
We need to build a new internet
Because the system is broken
(Now read this bottom up)
https://zora.co/collect/base:0x91ce2a53e54c79845e391ae81dd6c9b669e9164d/3?referrer=0x58A35cF59d5C630c057aF008a78bc67CDc2EC094
So don’t tell us that
Builders can change the world
Because the truth is
Blockchain is a fantasy
And we don’t trust anyone who says
We need to build a new internet
Because the system is broken
(Now read this bottom up)
https://zora.co/collect/base:0x91ce2a53e54c79845e391ae81dd6c9b669e9164d/3?referrer=0x58A35cF59d5C630c057aF008a78bc67CDc2EC094
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...
3632
ChristianØ
@christian·00:23 29/06/2024
Since 2020 we've been building /noves 🔮
50+ blockchains, 500,000,000+ smart contracts, and billions of transactions - Noves is not just addressing a single ecosystem or a limited group of popular protocols.
We are building the universal translation layer for blockchain data, standardized across all chains and all protocols.
Because, honestly, blockchain data sucks.
And we want to make it better, readable, usable, and easy. For consumers, developers, accountants, gamers, degens, and everything in-between.
Hope you enjoy the Noves 🔮 Chrome Extension. My DMs are always open for feedback, ideas, collaboration, or even if you just want to say hi ✌️
50+ blockchains, 500,000,000+ smart contracts, and billions of transactions - Noves is not just addressing a single ecosystem or a limited group of popular protocols.
We are building the universal translation layer for blockchain data, standardized across all chains and all protocols.
Because, honestly, blockchain data sucks.
And we want to make it better, readable, usable, and easy. For consumers, developers, accountants, gamers, degens, and everything in-between.
Hope you enjoy the Noves 🔮 Chrome Extension. My DMs are always open for feedback, ideas, collaboration, or even if you just want to say hi ✌️
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.
A good to work and build Onchain 👏
Onchain Metrics of the Day
Total Value Locked (TVL) on @base has grown above the $1.6 Billion mark, thanks to more developments and awareness happening for the onchain summer.
#crypto #data #onchainsummer
Total Value Locked (TVL) on @base has grown above the $1.6 Billion mark, thanks to more developments and awareness happening for the onchain summer.
#crypto #data #onchainsummer
A good day to learn and build Onchain...
Let's show up today and do the most...
Let's show up today and do the most...
Onchain Metrics of the Day
Since the start of the Onchain summers, Daily Active Users (DAU) on @base have reached 368k, while developers have deployed 292k contracts.
@coinbasewallet, new smart wallets will go a long way toward onboarding more users.
data-src @tokenterminal
Since the start of the Onchain summers, Daily Active Users (DAU) on @base have reached 368k, while developers have deployed 292k contracts.
@coinbasewallet, new smart wallets will go a long way toward onboarding more users.
data-src @tokenterminal
Onchain Metrics of the Day
Since the start of the Onchain summers, Daily Active Users (DAU) on @base have reached 368k, while developers have deployed 292k contracts.
Coinbase's new smart wallets will go a long way in onboarding more users.
data-src @tokenterminal
Since the start of the Onchain summers, Daily Active Users (DAU) on @base have reached 368k, while developers have deployed 292k contracts.
Coinbase's new smart wallets will go a long way in onboarding more users.
data-src @tokenterminal
Over the past three months, @base has earned an average of $12 million in on-chain profit.
At its peak in March, Base's profit was $16.88 million, while it earned $12.90 million and $6.98 million in April and May, respectively.
Data src: https://dune.com/niftytable/rollup-economics by @0xKofi
At its peak in March, Base's profit was $16.88 million, while it earned $12.90 million and $6.98 million in April and May, respectively.
Data src: https://dune.com/niftytable/rollup-economics by @0xKofi
Over 65.5k new users have joined the @Base chain today, thanks to the builders working on Onchain Summer.
I'm building this dashboard to track developments of the Base Onchain Summer.
#base #onchainsummer #day1
https://dune.com/thechriscen/base-analysis
I'm building this dashboard to track developments of the Base Onchain Summer.
#base #onchainsummer #day1
https://dune.com/thechriscen/base-analysis
Today is going to be a Great day. Let's Play to Win...
I found my Ikagai and now it feels pretty cool to get paid to do what I love.
I am building to become a Crypto Quant = Data + Research + Trading
I am building to become a Crypto Quant = Data + Research + Trading
Looking to start out in Crypto Data, here's a comprehensive Roadmap for you...
https://roadmap.sh/r?id=65fee5b66deb533d6e19fb88
https://roadmap.sh/r?id=65fee5b66deb533d6e19fb88
261163
Chris
@thechriscen·14:38 02/04/2024
Starting my Crypto Data Apprenticeship today.
Much thanks to the @ilemi and /bytexplorers community for all the assistance.
Much thanks to the @ilemi and /bytexplorers community for all the assistance.

Roadmaps
Community driven roadmaps, articles and guides for developers to grow in their career.
roadmap.sh
Starting my Crypto Data Apprenticeship today.
Much thanks to the @ilemi and /bytexplorers community for all the assistance.
Much thanks to the @ilemi and /bytexplorers community for all the assistance.
16522
ilemi
@ilemi·15:29 27/03/2024
Ready to become a top crypto data analyst? I've created an interactive roadmap with tips, guides, and reference material for you to follow.
You can leverage this resource to go from using basic explorer tools to becoming a respected expert in a domain.
Video guide: https://www.youtube.com/watch?v=QdcQQKpTBZs
You can leverage this resource to go from using basic explorer tools to becoming a respected expert in a domain.
Video guide: https://www.youtube.com/watch?v=QdcQQKpTBZs
How much profit you make and keep during a crypto bull run depends heavily on your ability to navigate the metagame.
The game is to identify profitable plays early, invest responsibly, and exit when the hype reaches mainstream awareness.
The game is to identify profitable plays early, invest responsibly, and exit when the hype reaches mainstream awareness.

Take positions in assets that align with your convictions and let the market reward you in the long term.
Remember, you are playing against the brightest minds from BlackRock, so don’t expect to win solely based on emotions.
#cryptonotes #crypto
Remember, you are playing against the brightest minds from BlackRock, so don’t expect to win solely based on emotions.
#cryptonotes #crypto
261163
Chris
@thechriscen·17:23 25/03/2024
I like to think of investing in crypto as a game of chess.
Just like in chess, the key to winning is strategy.
✅ Plan your moves: Research coins, understand trends and narratives.
✅ Manage your resources: Your capital is the Pawn. Allocate it wisely.
✅ Play the long game: Don't expect to get rich quick.
Just like in chess, the key to winning is strategy.
✅ Plan your moves: Research coins, understand trends and narratives.
✅ Manage your resources: Your capital is the Pawn. Allocate it wisely.
✅ Play the long game: Don't expect to get rich quick.
I like to think of investing in crypto as a game of chess.
Just like in chess, the key to winning is strategy.
✅ Plan your moves: Research coins, understand trends and narratives.
✅ Manage your resources: Your capital is the Pawn. Allocate it wisely.
✅ Play the long game: Don't expect to get rich quick.
Just like in chess, the key to winning is strategy.
✅ Plan your moves: Research coins, understand trends and narratives.
✅ Manage your resources: Your capital is the Pawn. Allocate it wisely.
✅ Play the long game: Don't expect to get rich quick.
Interestingly, 10 out of these 25 AI coins incorporate "AI" or related abbreviations in their ticker symbols. This trend likely reflects an investor preference for tokens that clearly signal their association with AI.
#crypto #ai
#crypto #ai
261163
Chris
@thechriscen·09:15 20/03/2024
TOP AI CRYPTOCURRENCIES BY MARKET SIZE
This chart by CoinGecko Research shows a breakdown of the top 25 most popular AI crypto tokens by market size.
This chart by CoinGecko Research shows a breakdown of the top 25 most popular AI crypto tokens by market size.
TOP AI CRYPTOCURRENCIES BY MARKET SIZE
This chart by CoinGecko Research shows a breakdown of the top 25 most popular AI crypto tokens by market size.
This chart by CoinGecko Research shows a breakdown of the top 25 most popular AI crypto tokens by market size.

we are Super $SANIC 🚀
Loading...