EL DIPsy (@crypto_DIPsy) header
EL DIPsy (@crypto_DIPsy) profile picture

when in doubt just buy the dip and see will always be your EL @Dune 🧙‍♂️creating insightful Dune dashboard Pm if your protocol need dashboards

Underwater
Joined November 2017
Photo by EL DIPsy (@crypto_DIPsy)Photo by EL DIPsy (@crypto_DIPsy)Photo by EL DIPsy (@crypto_DIPsy)Photo by EL DIPsy (@crypto_DIPsy)Photo by EL DIPsy (@crypto_DIPsy)Photo by EL DIPsy (@crypto_DIPsy)Photo by EL DIPsy (@crypto_DIPsy)Photo by EL DIPsy (@crypto_DIPsy)Photo by EL DIPsy (@crypto_DIPsy)Photo by EL DIPsy (@crypto_DIPsy)
Replying to @Dune
@Dune's free tier is gone, @flipsidecrypto is gone. The next generation of blockchain analysts has nowhere to go to learn and practice So i built WizardCamp: write real sql on real chain data in the browser, graded the second you hit run. 85 exercises, 9 of them free right now the 9 is the part that bugs me. I want that number much higher Where i want this to go: protocols and chains sponsor a track on their own data so that learners get that track free with certificates whoever sponsors decides what the next wave of analysts is fluent in dms open unchaindata.xyz/wizard-camp
4
9
227
Tomorrow I launch WizardCamp. I ran data at @binance and at @Morpho and the hardest part was never SQL. It was that nobody teaches you what is inside a transactions table, why a transfer means nothing until you scale decimals, or how a sandwich looks in raw data. You learn it by breaking prod, or not at all. So I built the thing I wanted: 80+ exercises on real Ethereum mainnet data. Write SQL, hit run, find out instantly if you were right. 14 tracks, SQL Foundations through MEV, bridges, L2s, oracles, stablecoins, @Uniswap and @aave packs. Generous free plan. Opens tomorrow: unchaindata.xyz/wizard-camp
1
4
1
16
656
hey, just built something that might be useful for the dune wizards here. a job aggregator specifically for data roles in crypto. 275+ roles across data analytics, data eng, data science, research, crypto compliance etc. filters by company type (CEX, DeFi, infra). free to use :) quick walkthrough in video + link: unchaindata.xyz/jobs
2
2
21
2,474
EL DIPsy retweeted
You've been asking for @SuiNetwork analytics, and now Sui is officially LIVE on Dune! Query txs, tokens, NFTs & DeFi with decoded tables, build dashboards, and track the ecosystem end-to-end. Hello Sui 👋 dune.com/blog/sui-is-now-liv…
39
41
34
287
76,824
EL DIPsy retweeted
You asked for @HyperliquidX ❓ You got @HyperliquidX ‼️ HyperEVM is now live on Dune! Explore: ✅ token transfers ✅ dex trades ✅ bridged volume ✅ standard network analytics And more...
108
124
56
1,069
99,601
Happy Friday! 🎉 I’m hiring a Data Analyst and an Analytics Engineer at @UniswapFND! If you’re interested (or know someone great), drop your profile or past work in the replies — would love to connect! 📊 Analyst: job-boards.greenhouse.io/uni… 🛠️ Engineer: job-boards.greenhouse.io/uni…
17
9
1
87
5,339
EL DIPsy retweeted
gm @HyperliquidX perps orderbook data is now live on @Dune! 🔥 select * from hyperliquid.market_data
26
42
9
366
31,001
Introducing the @Dune Wizard Program 📊 We’re matching elite on-chain data experts with projects hungry for dashboards & analytics. Flex your SQL skills, prove you’re top-tier, and secure paid gigs with the best protocols in the game. Apply now 💰 jobs.ashbyhq.com/dune/210a28…
24
30
4
201
14,686
Many data analysts start out by querying on Dune right away. Instead, they should first learn to break down transactions, traces, and logs on any block explorer. I've put together a new comprehensive guide for that! Let's start by understanding the transaction tab:
22
92
10
506
63,156
Did you know you can call contract read/view functions in Dune SQL queries using livefetch? In this query I pulled the reserves, utilization, borrow, and supply rate of compound v3 USDC pools using quicknode rpcs.
6
3
1
54
4,841
EL DIPsy retweeted
you know that 1% gas fee saving you get from removing events? it's also saving you from having your protocol analysed in any way
10
10
1
125
19,443
EL DIPsy retweeted
Big news and announcements!!! 1) We are launching DuneAI 😱 Ask questions in any language using our natural language engine and get crypto data insights without the need to know #SQL. Millions of blockhain enthusiasts are now able to use #Dune 🔥
69
205
114
1,159
214,416
EL DIPsy retweeted
People keep losing money to scams on google ads DefiLlama was impersonated, even alameda lost 100M... We have to stop this. So I built an extension that replaces the new tab page with a custom search that prioritizes safe domains chrome.google.com/webstore/d…
156
435
109
1,725
258,942
EL DIPsy retweeted
Announcement time! 🚀Today, we’re excited to roll out 3 new features that make it even easier to use Dune! 1️⃣ ‘Create with Wand' - with Dune Wand 🪄input your question, and the Create Wand will translate your query into SQL for you. ✨ 1/6
11
38
16
226
54,683
With ETH Shanghai coming soon, i have created a @DuneAnalytics dashboard for @unsheth_xyz ! The dashboard covers: - TVL Overview - $USH holders + marketcap - LSD Distribution - USH Staking - LP Pools -Bridge Data Take a look at the dashboard here: dune.com/unsheth/unshethxyz
1
7
3
31
6,598
#there-is-no-token
🚨🚨🚨 We are being impersonated by scammers Please report 😑
1
1
2
459
EL DIPsy retweeted
LLMs are going to transform countless careers, including those of Dune Wizards 🧙‍♂️ We're excited to announce our first GPT4 powered feature - Query Explanations - and to share our LLM roadmap for the future 🧵 dune.com/blog/llm-roadmap
23
98
57
574
281,689
Around 79% addresses have claimed the $ARB airdrop, what about the remaining addresses? Have added another segment to check these wallets' last outgoing transaction. Check out the full @DuneAnalytics dashboard here: dune.com/0xroll/arbitrum-air…
1
4
361