Day 8 on learning onchain analysis Below shows the daily unique traders on the Flow.com dune.com/reeldata3/uniq…

Day 9 I made a list of projects trading on Base 49 in total

Day 9 learning onchain analysis Back again to the docs. GM

I've not posted for 2 days now, but really I've been doing some research and learning. Not written queries though 😅. I just what to find answers and understand every single detail of something, it's like door after door is opening. But I'll definitely post today👍 GM people

New Student Project Spotlight! ✨ Watch Chinedu Uzorue from Python 1.0 present his "Solana Yield Farming Intelligence Dashboard" - tracking real-time DeFi opportunities across Solana! This is the power of Python + blockchain analytics in action📊 📽️ Watch Here:

Day 11 Here I am relearning, since it feels like nothing wants to stick😣. Jo$h please lend me your big brain sir. It will be an honor to have it in my head even for one day😂.

Why does sickness comes whenever I've made that decision to become better? 😫. Finally made it to day 11 and I fell sick, consistency is so hard for me now. But I'll stand up and finish this race I've started, definitely 😌. Expect a post from me today🙂. GM GM

Day 12 Me stressed and having minor issues on my phone. But we move regardless. Trying to work on Average gas fees

Day 13 I know I was supposed to work on average gas fees, but my query just kept running without producing any result. So I just created this simple dashboard on the total number of transactions on the Ethereum blockchain in the last 30 days

GM GM Day 14 Back to the block explorer and the docs. But this time I thought of comparing my query results on dune to the explorer to see if my work is accurate 😅 WAGMI

Created something using a wallet I got from dex screener to refresh my memory. It shows the incoming, outgoing and total transactions on the wallet. GM GM

You know that feeling when you're analyzing blockchain data and you realize... game developers are flying blind? 😳 Millions of players. Billions in transactions. Zero tools to predict who's about to leave, etc.. That hit me hard while diving into Solana Gaming ecosystem.

"What resources can you recommend for me to start learning?" This and some other questions were what I kept on getting when I started my onchain analytics learning challenge. Now I'll just state the resources I started with. I started with these two SQL lessons that

Damn!, this festive season has really got me so busy IRL😫 but, I'm getting back on my feet and stronger. Posting or creating content has been so difficult, but I'll try my best. I'm still indecisive on which blockchain to build on, while learning onchain analysis.

x.com/i/article/2009…

So, on my previous post I still haven't gotten the reason for decrease in transactions for last week😫. I feel like I'm not looking at the right places. But I'm still working it out. I'm seriously opened to insights and ideas. Thank you.

While sipping my coffee(which was terrible by the way😖) , I created dashboards that compares the DEXes on Base. I focused on Alien Base . According to my findings Alien Base is the top 7 when we are ranking based on volume. This says growth for me. Don't you think so?