Blockchain Data Engineer | github.com/freemandaily | dune.com/freeman27 | substack.com/@freemandaily?r…
Joined July 2020
- Tweets 8,507
- Following 301
- Followers 271
- Likes 5,691
309 Photos and videos
Pinned Tweet
May 29
Decoding blockchain data for money-market protocols.
In my new Blockchain Decoding Series, I walk through exactly how to take raw, unreadable Ethereum event logs from AWS public datasets and transform them into clean, structured data for Aave V1/V2/V3 using Apache Spark!
3
4
162
Currently diving into the @Dune Spellbook repo! This is the underlying foundation for the tables you query on the Dune web UI.
Every table is meticulously designed with one goal in mind: providing users with clean, easy-to-integrate datasets. #DataEngineering
1
4
Jun 11
check out this article for complete process of decoding Evm data
May 29
Check out the full write-up on Substack:
open.substack.com/pub/freema…
Get the complete production-ready code on GitHub:
github.com/Freemandaily/Bloc…
#Web3 #DataEngineering #ApacheSpark #Ethereum #DeFi
20
Jun 9
It’s amazing what you can build when you have access to clean, structured, in-house data.
I’m building a blockchain forensics tool to explore token distribution, analyze holder clustering, and visually trace wallet connections. This is the power of proper data modeling
2
1
6
68
Jun 2
Just updated my EVM blockchain log decoder pipeline!
Added unified support for @compoundfinance (V1, V2, V3) alongside @Aave.
Refactored the core logic to be completely protocol-agnostic. Ready to scale and easily onboard more money markets!
#DeFi #PySpark #DataEngineering
May 29
Decoding blockchain data for money-market protocols.
In my new Blockchain Decoding Series, I walk through exactly how to take raw, unreadable Ethereum event logs from AWS public datasets and transform them into clean, structured data for Aave V1/V2/V3 using Apache Spark!
2
61
May 29
Decoding blockchain data for money-market protocols.
In my new Blockchain Decoding Series, I walk through exactly how to take raw, unreadable Ethereum event logs from AWS public datasets and transform them into clean, structured data for Aave V1/V2/V3 using Apache Spark!
3
4
162
May 29
what i covered:
🔹 Modular ABI mapping for Aave protocols (Borrow, Repay, Liquidations)
🔹 Low-level log decoding via eth-abi inside PySpark UDFs
🔹 High-performance batch processing pipelines on S3
1
42
May 29
Check out the full write-up on Substack:
open.substack.com/pub/freema…
Get the complete production-ready code on GitHub:
github.com/Freemandaily/Bloc…
#Web3 #DataEngineering #ApacheSpark #Ethereum #DeFi
66
Freeman🌼 retweeted
May 12
Data engineering is the backbone of every data-driven application, and the modeling approach is central to how the product performs.
At Tradeslens, I used dbt for data modeling, which enables efficient and reliable querying.
product live at intel-tradeslens.onrender.co….
2
2
7
173
Freeman🌼 retweeted
May 15
Kelp DAO exploit
I built ChainTrace Forensic, a reproducible forensic pipeline that
• Extracts the attacker's complete fund flow on-chain
• Visualizes the trace of every transfer
• Simulates fund movement step-by-step
Live here chaintrace-forensic.onrender…
3
2
8
214
May 15
Kelp DAO exploit
I built ChainTrace Forensic, a reproducible forensic pipeline that
• Extracts the attacker's complete fund flow on-chain
• Visualizes the trace of every transfer
• Simulates fund movement step-by-step
Live here chaintrace-forensic.onrender…
3
2
8
214
May 15
The entire project is reproducible locally.
Just run:
docker compose up --build
And you're in.
Full source on GitHub:
github.com/Freemandaily/Chai…
1
42
May 15
Big thanks to @SpecterAnalyst for providing the attacker addresses.
please consider supporting his project on @Giveth
x.com/SpecterAnalyst/status/…
Apr 24
I am participating in the @thedaofund x @Giveth 500 ETH matching round for Ethereum Security.
If you have found my work valuable, kindly support by donating any amount.
It is a quadratic funding round, meaning small contributions matter more; $10 from 100 contributors is worth more than $200 from 5.
The round ends May 14, 2026.
qf.giveth.io/project/specter…
Thank you 🙏
1
39
A young and smart Nigerian guy messaged me last night. Hopped on a call. He was like "Pashov Audit Group is one of a kind and all other security companies suck, I want to work with you"
There definitely are other good security companies. Already working with the guy though🫡
16
19
169
7,836
May 12
Data engineering is the backbone of every data-driven application, and the modeling approach is central to how the product performs.
At Tradeslens, I used dbt for data modeling, which enables efficient and reliable querying.
product live at intel-tradeslens.onrender.co….
2
2
7
173
May 12
Real-time blockchain data is sourced via Envio Indexer @envio_indexer , serving as the ingestion layer for the pipeline.
2
3
7
210
Freeman🌼 retweeted
May 10
I started blockchain investigation to provide assistance to the community and help victims of hacks and exploits.
Since then, I’ve offered pro bono support on several cases involving stolen funds and on-chain investigations.
If you’ve found any of my work valuable, I’d appreciate your support in the giveth ongoing quadratic funding round.
Even a $1 donation can make a difference 🤝
qf.giveth.io/project/specter…
9
66
3,842
May 9
I've been exploring Cryo, a blazing-fast tool that pulls raw on-chain data straight into Parquet files with zero friction.
Pair it with Apache Spark for transformation, and you've got a lean, modern pipeline that takes you from raw blockchain chaos to clean, query-ready data.
1
5
75