DataOnChain

Simplifying on-chain data ⛓️
Memes + Metrics 📈
Wallet tracking | Defi | Web3
#OnChainGiant 💪🏾🚀

[DataOnChain @OnChainGiant]

Fantom (Pre-sonic) Network Deep Dive: A Data-Driven Analysis 🧵

Why was Sonic Labs built? My @DuneAnalytics thread breaks down the key strengths and weaknesses in Fantom's ($FTM) network performance.

Thread below 👇

[DataOnChain @OnChainGiant]

@onreeel @DuneAnalytics Thank you bro 💪🏾🫡

[DataOnChain @OnChainGiant]

Fantom (Pre-sonic) Network Deep Dive: A Data-Driven Analysis 🧵

Why was Sonic Labs built? My @DuneAnalytics thread breaks down the key strengths and weaknesses in Fantom's ($FTM) network performance.

Thread below 👇

[DataOnChain @OnChainGiant]

here is the link to the full dashboard; https://t.co/CBgEVT08L8

[DataOnChain @OnChainGiant]

14/14 📝 Conclusion
@FantomFDN data tells a story of early promise followed by significant challenges. While the network achieved scale, it struggled with retention and sustainable growth.
@SonicLabs is the pivot for sustainable growth.
#Fantom #SonicLabs #DeFi #Blockchain

[DataOnChain @OnChainGiant]

4) Pro Tip for On-Chain Analysts
Always:
✔️ Check for negative values in amount_usd.
✔️ Use NULLIF() to avoid division by zero.

[DataOnChain @OnChainGiant]

Dealing with data errors in @Dune: here’s how I uncovered (and corrected) a 5,073% Aave lending outlier. 👇👇👇

[DataOnChain @OnChainGiant]

2) How I Debugged It

I found the bug: using ABS(x_usd) turned withdrawals into deposits (since it removed the negative sign).

Fixed it by summing the net values (SUM(x_usd)) and capping unrealistic percentages at 100%.

Key lesson: Always validate against protocol logic! 📌