Ruthie (@Ruthycrypt) profile picture

Onchain Research Analyst

Joined May 2023
Photo by Ruthie (@Ruthycrypt)Photo by Ruthie (@Ruthycrypt)Photo by Ruthie (@Ruthycrypt)Photo by Ruthie (@Ruthycrypt)Photo by Ruthie (@Ruthycrypt)Photo by Ruthie (@Ruthycrypt)Photo by Ruthie (@Ruthycrypt)Photo by Ruthie (@Ruthycrypt)Photo by Ruthie (@Ruthycrypt)Photo by Ruthie (@Ruthycrypt)
I’m back and I brought data. Just published a new Solana dashboard on @Dune I analyzed the Top 20 traders on @orca_so Whirlpool over the last 30 days, including; - Trade counts - Total volume (USD) Over $4B traded and 1.5M+ trades made. dune.com/ruthycrypt/evolutio…
18
9
59
1,517
Here’s a 30 second recap of what went down in Solana DeFi Last week. I built a dashboard to help you track • Weekly Volume • Unique Traders • DEX market share • Daily volume flow • Token transfer • Whale trades Let’s get into it 👇 0/7🧵
10
7
46
1,126
Here’s a 30 second recap of what went down in Solana DeFi last week. I created a a dashboard to help you track unique users, transactions, volume, and protocol growth. Let's get into it 👇 0/6 🧵
13
14
2
76
23,962
Solana DEXs just processed $7.49B in trading volume over the past 24 hours. Even in a choppy market, Solana’s liquidity remains unmatched, showing how deep its DeFi rails have become.
31
25
3
178
57,988
Here’s a 30 second recap of what went down in Solana DeFi last week. I tracked unique users, transactions, volume, and protocol growth. Plus, I built a dashboard so you can explore the data yourself. Let's get into it 👇 0/6 🧵
13
6
2
57
22,473
Bringing you a breakdown on what went down on @DriftProtocol over the last 7 days. I tracked key metrics like; • Protocol growth • Active traders • User behavior • Deposit activity • Liquidation health Here’s what the data reveals 🧵👇
9
10
66
3,166
Built this dashboard to track weekly activity on @DriftProtocol Here’s what stood out: • 781 active perp traders • 1,211 new users onboarded • 537,757 perp trades executed Is Drift entering its growth phase? The data says yes. 🔗 dune.com/ruthycrypt/drift-pr…
8
10
1
69
2,286
Ruthie retweeted
we just had the biggest week in the trenches since trump week $6.35b traded through onchain terminals
118
158
101
1,355
475,467
Ruthie retweeted
AI won’t solve crypto data. At least not yet. AI tools can help, but they cannot replace judgment. You still have to know what you’re looking at.
Replying to @FoxyhitsW
who's writing these horrible dune queries lol most fomo trades route through intermediate hops and this query books every hop as a loss, pnl's will be obliterated
5
3
32
1,682
JUST IN: The @SolanaFndn has officially open-sourced @tokens, the official directory and API for verified assets on Solana, and is urging developers to clone the repo, build with it, or contribute directly on GitHub.
18
12
2
165
20,230
Ruthie retweeted
TL;DR - Solana is positioned to take over and become the internet's capital market - We are making progress on our weaknesses in monetary policy and derivatives - Zcash remains the most asymmetric and important opportunity in crypto - I love crypto
E179: Mert Mumtaz - $SOL at $8. zcash:native at $18. The framework that caught both, and the next potential gem I sat down for the 3rd time with @mert the CoFounder of @solana and the CEO of @Zcash for a banger episode where we cut through the noise, understand the thesis for Solana and $SOL in 2026, why zcash:native is the last 100x in the large caps and why $NEAR might be the next $SOL at $8 and zcash:native at $18 Timestamps 0:00 Introduction 4:05 Dating On Zero Sleep: Mert's Relationship Secret 7:30 The X Growth Hack That 6x'd His Following 8:51 Partnerships: @Variational @BitwiseInvest 9:44 $SOL Crashed To $8... Then Everything Changed 15:48 Solana's Secret Leadership Shakeup 18:22 The Two Laws That Future-Proof Solana 25:47 Why Solana Wins By Default 28:05 Why Traders Are Blind To Solana 30:38 Partnerships: @KASTxyz @Trezor 31:43 One of Mert's Big Bets: Solana In 2026 36:42 How Solana Becomes The New Wall Street 42:45 The Countdown To Solana's Big Upgrade 44:23 Is Solana Actually Back? 47:31 Partnerships: @JupiterExchange @Ethena 48:14 The Zcash "Scandal" That Wasn't 55:39 AI Is Coming For DeFi's Bugs 59:24 zcash:native 's 20X Case or more, Explained 1:04:40 @NEARProtocol : The Dark Horse Mert Is Watching 1:09:32 Closing Thoughts
79
28
4
376
41,419
"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 @Ruthycrypt suggested when I DM'ed her for guidance. app.datacamp.com/learn/cours… app.datacamp.com/learn/cours… I also practiced with w3schools.com/sql/ which made my journey kind of easy. I watched some YouTube videos especially from the @Dune channel where I started from Dune 101 and watched some other videos on that channel too. From there I started practicing by getting codes from ChatGPT. (This can be so stressful because I spent more time debugging that I get frustrated sometimes 😂). But it's kind of fun, I just made sure I know how to write that particular code I got from ChatGPT so I won't go back to it again. You can read this guide by @defi__josh, nitter.cf/i/status/1955893396519… I found it super helpful. Also try to connect with top analysts like @onreeel @reelanalyst3 @GidiRphotos @0xTobey and many others out there so you can leverage their guidance to avoid being burned out. While you're practicing you can also try going through dashboards and queries written by other analysts. It helps too. The bottom line is just to ➜ Understand the basics of SQL ➜ Understand the @Dune interface or any tool you want to use and how to navigate. ➜ Practice as you learn ➜ Connect with top analysts While all these might be helpful, there's still nothing that'll equate getting it directly from the source where majority of analysts learnt from. So the community is @AnalyticSages and they're hosting a class by February, registration is ending by January. I'll be joining the cohort even If I don't have the access fee yet because it's the fastest way to achieve what I want to be as an analyst. Leveraging on others knowledge. I hope I'm able to help with this, kindly drop HI in the comments if you're an analyst or learning. I want to create an X list to connect with you personally. You can also reach out to me if you're just starting out, my DM is open and I'm willing to help too. Kindly like and retweet so others won't miss it too.
📍 How to go from beginner to pro Web3 Data analyst building on Dune in 30 days 📍 . A few weeks ago, someone DMed me: ==> “Josh, I want to build dashboards like yours… but Dune looks intimidating. Where do I even start?” . I get it. When I first opened Dune, I stared at the blank query editor like it was a wall of hieroglyphics. I didn't even take using Dune seriously till about 8 weeks ago..bcos it seemed really difficult to use. . For example: (Trino SQL syntax looked really complicated...and how Dune stores tables, e.g, erc721_{{chain}}.evt_transfer table for NFT mints, solana_utils.daily_balances table for token holders for sol token current holders or dune.ton_foundation.result_ton_jettons_metadata_latest_values table for validator stake amounts and performance metrics on TON, etc...). . Like fr, even before you begin building, you'll be so scared and even have a headache, even if you're an OG analyst in Web2...lol ••——•• 📝 But here’s the thing — you don’t need to know everything to start building. You just need a focused plan. Here’s the 30-day path I recommend to anyone starting: 💎 Week 1: Learn basic SQL (SELECT, WHERE, GROUP BY, JOIN) Pick one blockchain to focus on (Ethereum, Ronin, Solana, etc.) 💎 Week 2: Explore Dune’s public queries for that chain. Know how to search for other people's queries/dashboards and learn their thought process, SQL syntaxes/dune tables they used, and how they solved a major business problem with it. Try editing small parts to see how the output changes. 💎 Week 3: Build your first mini dashboard answering 1–2 simple questions (Example: My early retention analysis on Ronin Games – dune.com/defi__josh/ronin-ga… ) 💎 Week 4: Tackle a bigger question that needs multiple tables and transformations (Example: My $KTTY World analysis – dune.com/defi__josh/ktty-wor… or TVL calculation of Conduit hub bridge contracts - dune.com/defi__josh/conduit-… ) . By Day 30, you might not be an expert… but you’ll have something to show — and that’s worth more than perfect theory. Don’t overthink it. Start small, stay consistent, and build as you learn. You'll be surprised how far you've gone 1-2 months after. 💯 . Your first dashboard won’t be perfect. Neither was mine. 😉 ...but within 8 weeks of using Dune consistently, I've gotten some big wins including being featured on Dune Digest 17 - nitter.cf/Dune/status/1941542667… , given a shout out on Dune's ALL HANDS, received a wonderful recognition gift from Dune nitter.cf/defi__josh/status/1950… and many more big Wins 💯. It all began with me taking the bold step to grind relentlessly... You, too, can do much more 💯 Just get started and 100% locked in. 🔥 Gm Gm Gm 😉
29
9
2
64
2,643
Ruthie retweeted
We asked the Solana community what they're excited about in 2026. Here's what they said: @sagewilyam: "Bringing every asset in the world and trading them at the speed of light" @laBananeCrypto: "Day-one listings on Solana" @swen_sjn: "Solana being cheaper than L2s for launching new coins and markets" @visual0x: "Bringing perpetuals traders back home to Solana" @ted_livingston: "Alpenglow!" @spacemandev: "Privacy redefining what is possible" @schniib: "Ownership coins & Futarchy" @janbtc: "Startup IPOs on Solana" @centrifuge: "Tokenization shifting from pilots to repeatable infrastructure" @joinearlybird: "Internet capital markets" @yashhsm: "Novel DeFi to enable Store of Value" @doublezero: "A new internet" @iirfan: "New mobile experiences" @celstialbody: "It will always be art" @pipenetwork: "Validators becoming more profitable with async execution" @JatevoId: "x402 on Solana: pay per inference" @huntonraptor: "Prediction markets can expand from event betting into high-frequency hedging instruments" @Ayyanrahman: "Crypto leading TradFi" @adhcrypto: "Shipping hardware on Solana" @techsavvyy02: "DePINs on Solana" @block_murthy: "Real consumer dApps" @Dvymtar: "Invisible adoption by companies that dont want to build their own tech stacks" @martinvmorales: "Breakpoint 26: getting to meet people irl is beautiful" What are you excited about?
270
179
31
934
87,878
Decentralization matters in the long term.
Replying to @QwQiao
Over the long term they could be the only great investment. If they become ubiquitous and essential and cannot die because of decentralization, then sum of all future cash flows goes to ♾️
5
22
5
193
33,294
What is happening on Tron Chain? Why is there a huge bridge out of solana to Tron this week? ($13m so far) source: @debridge
3
3
19
622
Ruthie retweeted
A Dune account and a dream
23
8
5
114
8,683
Another banger from Ruthie
1
3
176
Is everything milkshake?
Solana DEXs just processed $7.49B in trading volume over the past 24 hours. Even in a choppy market, Solana’s liquidity remains unmatched, showing how deep its DeFi rails have become.
2
69
20,854
Ruthie retweeted
Interesting
1
3
729