
Web 3 Data Analyst | Defi Researcher | Onchain Forensics | DM for collabs 📧 [email protected] | B.Eng
Web 3
Joined January 2020
- Tweets11.4K
- Following1.6K
- Followers1.1K
- Likes15.6K
Pinned Tweet
This week, I built 2 things:
1. A full DeFi off-ramp Project analytics dashboard
2. An EVM “Smart Money” overlap tracker
One of them exposed a serious flaw in my own analysis, while the other improved my research and front-run trading game.
Here’s what happened 🧵
I decided to take my skills up a notch by advancing into Data Engineering, and what better academy than @AnalyticSages could bring this need of mine to reality? So I signed up.
It's just week one, and I built a pipeline that pulls the top 100 coins from the CoinGecko API, cleans them with Pandas, and loads them into Postgres, all running in Docker with one command.
This is a basic ETL project, and it's something that I have always wanted to build.
Here were some of the key lessons while doing this first task:
1. Inside a container, "localhost" is not your laptop. It's the container itself. Containers find each other by service name, so my script reads the database host from an environment variable (DB_HOST) instead of hardcoding it.
The same code works on my laptop and inside Docker.
2. Library updates can break working code. A newer SQLAlchemy version changed its default Postgres driver, and my script crashed looking for a module I never installed. Naming the driver explicitly fixed it. I think this is the part I look forward to solidifying my knowledge on as we progress.
3. Two programs can't share one port. DBeaver kept rejecting my password because another Postgres on my machine was already sitting on port 5432. Moving Docker to 5433 solved it.
Week one down and I look forward to what's next.
Data Tribe: @AnalyticSages
Data Extraction source: @coingecko API
Here's a link to the project: github.com/JaybeeMuppet/Anal…
Week three is done, and this one took me to the cloud.
I pulled every ERC-20 token transfer across 4,000 Ethereum blocks over RPC, saved them as Parquet files in Google Cloud Storage split by date, and connected them to BigQuery with an external table. That's 495,060 transfers I can query with SQL without copying a single row into BigQuery.
Here were some of the key lessons from this week:
1. An external table doesn't hold the data. It just points at the files in GCS. When I extracted more blocks, the same query for 14 Jan went from 81,864 to 302,949 rows without me touching the table.
2. Splitting the data by date saves money. When you filter WHERE dt = '...', BigQuery only opens the files for that day. Try to query without the filter and it refuses to run.
3. Free RPCs once again is not sustainable for data Jobs and it will humble you. They kept rate-limiting me, and the pipeline read every error with the word "limit" in it as "too many blocks", so it kept splitting until it crashed. I switched to my own Infura endpoint and smaller checkpointed chunks, so each re-run picked up where it stopped. I think this was the part where I learnt the most this week.
4. Jupyter Notebook outputs get committed too. I printed my API key in a cell and pushed it to GitHub 😂 Deleted the key immediately, but lesson learnt.
With week three down, I look forward to what's next.
Data Tribe: @AnalyticSages
Data Extraction source: Ethereum mainnet via @infura_io
Here's a link to the project: github.com/JaybeeMuppet/Anal…
Week four is done, and this one was all about data modelling with dbt.
Instead of pulling new data, I went back to my own Week 2 Uniswap swap extraction and built a dbt project on top of it in three layers:
Staging cleans the raw data, intermediate holds all the logic, and the final table gives one clean row per swap that an analyst can just query.
The result still remains same: 205 swaps across ETH/USDC, USDC/USDT and WBTC/USDC, over $3M in volume, and 10 whale trades of over $100K each.
Here were some of the key lessons from this week:
1. Raw on-chain data isn't analyst-ready. The amounts have no decimals applied, and the price is hidden inside a number called sqrtPriceX96. The intermediate layer is where I decoded all of that into actual prices, trade direction and dollar volume.
2. Tests passing doesn't mean your numbers are right. All 82 of my dbt tests were green, but I still fed in trades with prices I already knew and checked the output matched exactly. I think this is the habit my onchain forensic work has given me.
3. The provided config was broken. dbt kept rejecting the database port because it was being passed as text. One small fix (as_number) and everything ran.
4. Make it reproducible. I committed a snapshot of the data so anyone can clone the repo and rebuild everything, even if the RPC is down.
With week four down, I look forward to week 5.
Data Tribe: @AnalyticSages
Data Extraction source: @Uniswap V3 pools on Ethereum mainnet
Here's a link to the project: github.com/JaybeeMuppet/Anal…
Jaybeecode retweeted
Week 2 with @AnalyticSages is done.
This one was closer to what I already do every day.
I built a pipeline that pulls Uniswap V3 swaps directly from Ethereum mainnet using an RPC and web3.py, decodes them, and loadsthem into Postgres.
I just give it a block range and it does the rest.
I ran it on 200 blocks across 3 pools (ETH/USDC, WBTC/USDC and USDC/USDT) and it pulled 205 swaps.
Here were some of the key lessons from this week:
1. You can't ask an RPC for too many blocks at once, or it will cap you. So I fetched the swaps in chunks of 10 blocks. 200 blocks became 20 small requests.
2. Raw logs are just hex. I used process_log with the Swap event ABI to turn them into readable data like the sender, amounts, price and tick. I've read this kind of data on Etherscan countless times, but decoding it myself hit different.
3. Running the script twice shouldn't double your data. Every swap can be identified by its tx hash and log index, so I made that the primary key and told Postgres to skip anything already saved. The second run added 0 new rows.
4. Don't just accept a zero. Two of the pools kept returning 0 swaps, and that didn't sit right with me. I checked and there was no contract at either address on Ethereum. One was actually a pool on Arbitrum. We replaced them with working mainnet pools, and I added a check that warns if a pool address is empty. I think this is where my on-chain investigation background really helped.
Week two down and I look forward to what's next.
Data Tribe: @AnalyticSages
Data Extraction source: @Uniswap V3 pools on Ethereum mainnet
Here's a link to the project: github.com/JaybeeMuppet/Anal…
Jaybeecode retweeted
Until you make the subconscious conscious, it will direct your life, and you will call it fate.
Jaybeecode retweeted
K-shaped agency.
most people acknowledge that AGENCY is the key trait that will separate winners and losers in the agentic age.
do you actually get up and do shit at your own initiative? or do you just sit around waiting to be prompted.
that’s agency.
increasingly I’m observing that agency is reflexive.
agency begets agency.
and conversely, if you’re low agency, AI makes it EASIER for you to be low agency.
this is super dangerous!
competent people risk becoming complacent.
if you mostly do THE SAME as before, but at lower effort (due to AI) you’re at risk.
if you aim higher, going for 10x the quality and speed, you’re on the right track.
if you’re reading this, you should feel a deep sense of urgency to develop agency.
we’re all human beings, and it makes sense that you experience some AI fatigue.
but get back on the horse!
spend 1 hour with AI right now and see how much further you can push the boundaries vs 6 months ago.
we have intelligence on tap and it’s DIRT CHEAP.
you have 20 team mates who could be working for you right now.
but they’re idling.
go out there and build what you’ve always dreamed of.
never been a better time to go all-in.
Jaybeecode retweeted
All I’m going to say is you probably want to stay as liquid as possible, for as long as possible.
Be patient.
Take whatever happens in the real world and bring it to web3 then craft your niche.
Insane build here.
2
71
Jaybeecode retweeted
Also, you don't have to be on every chain to win with your trades.
While the market has been on some good state;
Some persons have been on Robinhood only and made banks from CASHCAT, PONS, AI, Microduck, TENDIES, JUGGERNAUT, DELTA, HOOKR etc.
Others have been on Binance winning with MARSCOIN, MEMESTOCK FLORK, BIBI, MAX... all in same timeframe that Robinhood gems 💎 has been running.
Some have been on Eth collecting wins from PRISM, FWA, FOLD (Even if there's little money flow into Eth rn and they can't get those heavy gains for now, but wins are wins regardless)
Some were also on Arbitrum with just ODYS, and maybe NOLA
Some on Base with BASECAT. Ratspeak, BLUECHIP, BSTONK, etc.
Others have been on solana with JIMOTHY, STONK, FONE, ANSEM, USELESS, etc.
The goal is that wherever you find yourself, you are able to truly understand the environment and ecosystem and what it takes, so that you can actually maximize your output with gems and the trades you take.
Let's win chads, rooting for us all
the things i learned from the last cycle:
- never, ever be happy about someone else losing. never, ever be sad about someone else winning.
their win doesn't take money from your pocket. their loss doesn't put money in it.
- shit will happen.
when you think you've seen everything, something even more absurd will happen.
be ready for it.
turn this into a game. don't let every move emotionally affect you.
- there will always be better traders than you.
and that's normal.
accept that. watch them. learn from them.
this is probably the biggest + of social trading.
- the whole system is built around jumping from coin to coin.
you will miss rotations.
sometimes you'll watch a coin run without you.
wait.
there will be another one.
chasing, crying, revenge trading and getting emotionally affected will cost you far more than missing a 5x.
- there will be a lot of wins. there will be a lot of losses.
none of that matters.
look at what you actually have.
not your pnl. not your peak. not your "i could've made $2m."
what you have.
protect it. grow it. stay in the game.
- never ever normalize winning.
enjoy the wins.
actually feel good about them.
because if winning feels normal but losing feels devastating, you're cooked.
you need to be able to handle both.
the goal isn't to feel nothing.
the goal is be winner.
now there are two apps you can't stare at.
pumpfun and fomo are fighting over the callers, so the calls are split across both. the memebubbles bot now tracks the two of them.
pick your callers from either app. every call lands in your group or dms the second it drops. mc, ca, buy buttons, done.
now you can look away. from both.
nobody can stare at the pumpfun app all day.
that's the whole problem, so i solved it. the memebubbles bot drops into any telegram group, you choose which callers to track, and their calls arrive the second they post. mc, ca, buy buttons, done.
the dashboard tells you who's worth tracking. the bot brings them to you. that's the loop.
now you can look away.
Jaybeecode retweeted
I’ve been broke in crypto
I’ve been rich with a job
Personally I recommend being born into a large Trust Fund type of situation and never fooling with any of this shit in the first place
It’s very obvious that since Base, no other newly launched chain has seen this level of motion.
I believe the Robinhood chain would go on to become one of the more active ecosystems, then it’s only right to compare it with Base. Runners and infrastructure alike.
Today I want to look at @ponsdotfamily and compare it with Clanker and Zora on Base.
The graphic below does a solid job visualizing the metrics side by side with its Base counterparts.
Key numbers (ATH basis):
• PONS →
Peak ~$67Mcap
$2.05B volume
$3.22M fees
281k launches
CLANKER →
Peak ~$143M
$8.1B volume
1.4M tokens
• ZORA / Zora Coins →
Peak ~$400M
$1.64B volume
13.2M tokens
On pure multiples, Clanker looks more efficient. That’s worth acknowledging.
But what’s hard to ignore is how impressive PONS’s metrics have been in just a few weeks.
We can clearly see the yardstick for @ponsdotfamily if Robinhood Chain continues to grow in attention and activity:
• Base case: $120–180M range
• Bull case (if Robinhood becomes a major chain and PONS stays dominant): $250–400M+
This is still early.
The asymmetry is tied to whether Robinhood keeps growing.
What do you think?
If there's any blockchain I can use to rate or compare the Robinhood ecosystem
Then it has to be Base
At some point months ago, Base was the chain getting the most attention, where new launches, ponzies, and experiments called their home.
So I'm starting a short series where I take a Robinhood runner and compare it side by side with Base’s.
That way we can gauge how asymmetric those bets can be, l and how early we are.
So today I will start with the most obvious
$CASHCAT
Already has an ATH of 200m compared to $BRETT with an ATH of 2.3B
Cashcast has already established itself as the leading meme on Robinhood (at least in my books)
And being x10 less than Brett at ATH says a lot about how early of a bet this is.
$CASHCAT hitting a billion market cap mid-term
Yes or nah
What are your thoughts?
I wasn't even joking when u said this.
The big whales now joining so it's 100% confirmed that fomo is doing something right.
While the war is ongoing and the debate on X persists with @solana creating a poll for both products, I see at least 5 new sign-ups on fomo every day.
Insane growth when you spread tgat across 30, 60 and 90 day period.
This debate may have just been the biggest marketing stunt that was needed for @fomo
4
156
While the war is ongoing and the debate on X persists with @solana creating a poll for both products, I see at least 5 new sign-ups on fomo every day.
Insane growth when you spread tgat across 30, 60 and 90 day period.
This debate may have just been the biggest marketing stunt that was needed for @fomo































