Muhammad Auwal Abdulaziz

On-chain data work focused on Solana, mostly around where money actually moves: DEX flow, wallet behaviour, protocol revenue, and holder structure.

What you'll find here

• Solana DEX volume, market share, and liquidity rotation between venues
• Wallet cohorts — new vs returning, retention curves, whale accumulation
• Protocol health: active wallets, fee capture, revenue over time
• Forensic traces following flows between wallets and programs after a notable event

How the queries are built

Every dashboard is written to be forked. Column names say what they mean, CTEs are broken up instead of nested six deep, and anything non-obvious gets a comment. If you disagree with how a metric is defined, you can see the definition and change it.

Background

I'm Muhammad Auwal Abdulaziz, based in Abuja. I write about Solana and Web3 for African audiences, teach data analysis to beginners, and build tooling for on-chain research. The analytics and the writing feed each other and a chart nobody can read is a chart nobody uses.

Work: ghostiemoh.github.io X: @Ghostieemoh