building spellbook @dune ~ probably in a draft lobby ~ ud: noticemesenpai
OH
Joined March 2022
- Tweets130
- Following253
- Followers199
- Likes1.2K
jeff retweeted
We are on a mission to make #DuneCon25 the best event during the entire DevConnect week, and the speaker list speaks for itself.
Check out the newest addition to our packed agenda on November 19th.
@0x_eunice @monad
@PaulFrambot @MorphoLabs
@debsoon @privy_io
@TrustlessState @Bankless
@mewwts @Dune
@maggielove_ @shefiorg
@OctavioNotPunk @jumperapp
@hagaetc @Dune
@camiinthisthang
@0xkubush @twynexyz
@beccy_ingram @dune
@ZoeCatherineF @joinwebzero
@zGuz @coinage_x_daic @coinage_media
@nickilsanders @Anchorage
@AlsieLC @Dune
@jacqmelinek @tokenrelations
@sui414 @PanteraCapital
We're not done yet, more speakers coming to #DuneCon25!
📍 Nov 19th, Buenos Aires, meet:
@clairekart @aztecnetwork
@emilylai @hypepartners
@HorinekPM @serotonin_hq
@danimimm @MoonwellDeFi
@k06a @1inch
@AriEiberman @gnosispay
@0xcush @odisealabs
@mendesfabio @Balancer
@facuspagnuolo @mimicfi
@GabrielGruber @Exa_App
@Mausefalle25 @1kxnetwork
@0xKofi @base
@LucaProsperi @m0
@nlevine19 @Visa
@pato__23 @OpenZeppelin
@richardchen39 @VarrockVC
@arlequin_eth @mywebacy
fellow wizard friends, come work with me 🪄
🚨 On-chain sleuths wanted 🚨
Join us at @Dune and work on the largest open-source dbt deployment in the world.
If you love turning blockchain data into insights and wrangling data pipelines, this is your playground !
dune.com/careers?ashby_jid=f…
2
117
jeff retweeted
Data nerds, rejoice! 🧙♂️✨
@Uniswap v4 swap volume is now fully captured in the `dex.trades` model on @Dune! And soon on dexanalytics via @AlliumLabs!
We've known for a while that custom curve hooks (eg. @bunni_xyz and @flaunchgg) make standard volume tracking in v4 tricky. But now, we've closed that gap and are tracking v4 volume holistically, including for custom curve hooked pools.
(For context: among other custom curve hooks, we are now tracking $13M+ from Bunni and $85M+ from Flaunch, which were missing before...)
Why was volume missing?
Custom curve hooks in v4 don't emit correct swap event, which most volume calculations rely on. Instead of relying on the swap events, we’re now tracking successful swap calls and using the swapDelta field to accurately capture real amounts swapped—even under custom curves.
Why this matters:
1️⃣ Hooks can break DeFi metrics if we rely only on v4 core contract events.
2️⃣ Collaboration is key—when the community works together, we address data issues together, for everyone.
3️⃣ Standardization rules—shared data models = cleaner analytics & better research.
Huge shout-outs to:
- @j__dude for tirelessly supporting open-source data modeling, including this one on Uni v4
- @Dune for providing an open, public repo where the community can rally & standardize data
- Soon & Soo & @AlliumLabs for pushing forward standardized data practices in AMMs and DeFi
- @saucepoint for answering my 1000+1 questions about v4 code and hook logic with endless patience and brilliance
calling all wizards 🧙 come join my team (yes, i'm biased) or check out the other open roles. feel free to dm me any questions on the process!
meeting countless top wizards IRL was the highlight 🧙
DuneCon was unforgettable 🌠
1,000+ builders, analysts, and innovators came together in Bangkok to shape the future of onchain data.
Which moment from the day will stick with you forever? #DuneCon2024
come hang with us, we can nerd out irl
DevCon roll call 🇹🇭
Something big is happening on Nov. 11, and you don’t want to miss it #DuneCon2024
Drop a comment for an exclusive invite 👀
3
116
jeff retweeted
Recruiters love this one skill for crypto data roles😍:
@hildobby_ is the master of this craft
@tomfutago picked this up recently and instantly got hired
@HenryBitmodeth cannot save himself from freelance contract demand
@andrewhong5297 is the only person that can tell you what's going in solana thanks to this skill
of course, I am talking about my favorite data pipeline in the world, Dune's Spellbook.
This is where the crypto data masterminds of the industry come together and model out complex crypto data into reliable and maintainable data pipelines.
You know how Dune's dex.trades comes together?
Stakeholders from the entire industry build data models for all the different decentralized exchanges and we combine all of those into one table. the logic is open, anyone can contribute models and many do.
ser, how does this work?
Spellbook is a tool built on top of dbt, which is a data orchestration tool. dbt allows us to transform data by writing SQL queries and managing them as code. It enables us to build data pipelines, automate transformations, and create models that are easy to test, version, and deploy.
You can kind of think of these models as an even more advanced version of our "query a query" and "mat view" functionalities.
The code is all public and open, which allows for cooperation between all data analysts.
how do I start?
- Andrew release a great guide on our youtube channel just recently.
- The spellbook repo has elaborate readme's and examples of how to contribute.
- Go through the gh issues of the repo and you can find something to work on!
I was promised recruiters love me?
contributing to Spellbook in a meaningful manner is probably the best thing you can do to elevate your resume and expand your network:
- other Wizards will love you because everyone profits from spellbook contributions.
- employers see that you can work in a structured manner, can make a plan and execute on it beyond spitting out quick dashboards.
- spellbook contributions are a reasonably hard proof of skill that should get you past the first screening.
Imagine your resume like this:
"Contributed 7 models to dex.trades, indexing over 500k trades across 15 networks. dex.trades is a critical component used by analysts and developers to derive actionable insights from decentralized exchange data."