I just stumbled across my origin story of how I started working on
@DuneAnalytics
and I think a lot of you degens can follow in my footsteps...
A thread on starting to work in DeFi and on
@DuneAnalytics
I am looking for 3-5 people who are serious about wanting to learn Dune. DM me if you are interested.
I will personally mentor you and get you to a level at which you can pick up freelancing jobs or try to apply for positions.
I will be available for you in some sync calls and
Built a quick dashboard to track the
@1inchExchange
claim process and monitor token utilization.
Includes token allocations, number of holders, utilization of $1inch as trading pair and a table tracking all holders with their initial claims.
idk if anyone noticed, but I released a cracked guide on how to fix your Skill Issues with DuneSQL the other day in our docs.
TL;DR: Dune uses Parquet files. Understanding how parquet files work and writing efficient queries against them will 100% speed up all of your queries.
I was wondering what is driving all the txs on base and did some quick transaction labeling:
40% of all base transactions are related to trading, if you factor in approvals, it's closer to 50%.
6% are all kinds of NFT mints, 3% are p2p erc20 transfers, and 2% are driven by
I'll host a NFT dashboard workshop on Thursday at 18:00 UTC.
I'll teach you everything related to NFT trading data and how to make a good NFT dashboard on
@DuneAnalytics
.
We are gonna teach 30 people Web 3 Data Analytics in 30 days.
This is literally gonna be education on the level of
@Harvard
and
@MIT
, but instead of rugging yourself while doing so, you will earn money.
🐸 >👔
Super excited to announce
@OurNetwork__
Learn, partnering with
@DuneAnalytics
!
We'll teach you how to the gamut of data analytics in Web3, as well as how to communicate your findings effectively.
To top it off, you'll be earning ETH as you learn 🤑
A rare personal post/reflections:
I took the last couple weeks off to travel in SEA, probably the most disconnected from all of this crypto stuff I have been since I joined the space 3 years ago. I needed that break really badly and am incredibly happy I took that time for
Feels like people are absolutely sleeping on the fact that you can do basic scripting in Dune by invoking other queries with parameters.
Let me explain 📖🧑🏫
In Dune, you can create queries and actually query them like views or even functional ctes within other queries.
This whole thing is absoloutly ridiculous and absurd.
UNI Holders stand to gain nothing, but alienate themselves from all other analytics service providers by basically letting their community analytics being run by
@flipsidecrypto
.
PSA to all $UNI holders 🚨🚨🚨
A
@uniswap
governance proposal that will let
@flipsidecrypto
manage up to $25M in $UNI tokens and use yield to fund their own operations is about to pass in <24 hours with almost zero community attention.
Please help RT.
I am currently hosting "Dune Intro Sessions" in our
@DuneAnalytics
Discord:
The next event will be on 19:00(GMT+2) on Sunday evening.
I'll be introducing you to the basics of Dune in order to get you started on the journey of becoming a DeFi Analyst.
Dune embeds just got a lot better!
Our engineers and legal team finally overcame EU bureaucrats to stop cookie banners from appearing on embeds 🎉🥳
Websites like now load seamlessly and have great UX.
Analytics on your website, powered by
- dune data
🔍3/ Discover More:
- Dashboards & Queries: Choose from trending or popular feeds, customizable by timeframe.
- Topics: Stay current with trending and popular topics organically curated by our community.
- Creators & Teams: Explore the minds behind the data. Support your
Dune Fam eating well tonight thanks to
@optimismFND
retroactive public goods funding 😤
Congrats to all the grant recipients and major kudos to
@MSilb7
and
@chuxin_h
for building a community of engaged and committed wizards for the OP ecosystem 🙌
One query to rule them all 💍
I have built an entire bookkeeping dashboard for
@picklefinance
with a single query on
@DuneAnalytics
.
No more guesstimating of incomes or profitability.
It's all on the chain, someone just needs to surface the data.
@DuneAnalytics
will soon allow anyone to upload some data to our platform via API.
Finally, on and off-chain data can live in one environment 🤝
I am looking for a few beta testers to battle test the feature and help refine it, slide into my DMs if this sounds interesting to
Bags for the
@DuneAnalytics
on-site and DuneCon are packed 🛫
Super excited to get to hang with some of the smartest and nicest people I've ever met for the next week.
LFG, the vibes and data must flow 💾🌊
Has the market turned against you?
No Idea what to do with your life anymore as all ponzi printers have stopped?
Now is the time to put your skills picked up during the last few months to use and contribute to the future of finance!
Is there a support group for folks negatively affected by airdrop farmers?
I want to share my pain and frustration with someone that understands what I'm going through 😢
I FOMOed into going to DevConnect next week, super excited for all the great events and Istanbul!
I'll be at Datapalooza, Eth Infra Day and OpenData GÜNÜ and will hang out at the coworking space inbetween.
If you wanna meet, drop me a DM, would love to talk Dune, Data or Life
OpenSea has already done more Volume this month (11 days in) then in the entire months of may and june combined.
At $580 mio volume so far, they are on track to break 1 billion in trading volume this month. 🤯
A dashboard for tracking the allocation of Pickles.
Current insights: Only 33% of Pickles are not staked in the contract or in the eth/pickle unipool, showing strong commitment from the Community once again.
@picklefinance
$boden and $whoren are incredible expressions of the level of mistrust and hate placed in our governments and institutions.
Where memecoins express love, appreciation and joy, this new generation of coins act like a hatecoin - a giant middle finger to the establishment that
All my usual Dune Freelancers have been hired or are busy at the moment, if anyone is down for some freelancing, slide into my DMs with a link to your Dune profile
In my role as Community Manager for
@DuneAnalytics
I get to talk to a lot of new contributors/ builders, here is what I see and why it makes me happy:
👇🧵
The most boring LLM usecase is probably customer support, but god damn I am excited about it now.
Dune's Discord is filled with knowledge of Wizards helping Wizards, but Discord search really is not meant to surface this.
Luckily,
@awesomeqa_xyz
can help with that!
I will be chatting industry in data with the legends
@hildobby_
and
@sui414
every couple days/weeks on
@indexed_pod
!
We just recorded the first episode and are still trying to find our footing, any feedback is appreciated 🙏
Introducing Indexed Podcast, where we discuss hot crypto topics through data 🧮
Hosted by
@0xBoxer
,
@sui414
&
@hildobby_
Watch episode 1 where we cover Oderflow, Inscriptions, ETFs & $JUP
YouTube 👉
Spotify 👉
Truly feel lucky to be working with this team of gigabrains and really excited for all of our releases and improvements this year.
We will take data accessibility/transparency in this space to the next level 💯😤
gm
We’ve raised $69,420,000 in Series B Funding, led by Coatue 🦄
We’ll use the funds to double down on our mission of making crypto data accessible!
& to educate, reward and empower a new generation of on-chain analysts aka Dune Wizards 🧙♂️
👇
What is this dune thing and why is it worth a billion?
Come find out in our Discord, I'll record a new podcast in 30 minutes from now.
This week will feature
@yulesa
and
@RobertoTalamas
, 2 gigabrains from
@MessariCrypto
's data science team!
Dune V2 is now on par with Dune V1 for eth mainnet!
It‘s 10-100 times faster than Dune V1 for the right queries, this is truly exciting times for data scientist in Crypto.
:feelsgoodman
Dune has experienced a wave of inorganic activity across the Dune App in the last few days
This seems to stem from rumours of a Dune Airdrop 🥴
PSA for all Airdrop Farmers:
There is no Dune Token, there are no plans for a Dune token and there is no Airdrop
A bunch of new Wizard jobs on the
@DuneAnalytics
Wizard job Board today!
@artblocks_io
is looking for a Business Intelligence Engineer
@mseidl_
is looking for working students
@butterymoney
is looking for a Data Analyst
(new additions always welcome)
pretty convinced that every Statistics 1 class in universities/colleges should be taught with a SQL database as the execution environment instead of ..... pen and paper + calculator 🤦♂️
This advice is also applicable to all other ecosystems, you are about 6 months of hard work away from being the hildobby of fantom or the msilb7 of aptos.
There is no easy path, the only way is to put in the reps 🦾
want to get started on Solana and make a name for yourself?
Do this:
- learn sql (pretty easy with chatgpt)
- go to dune and flipside; query the chain, make some dashboards
- get good at writing
- tell stories with data
- iterate based on feedback
- you now have a network
🌟 Hey Wizards! We're unlocking paid features for ALL creators, empowering every analyst to dig deeper into crypto data.
✅ LiveFetch is available to all
✅ Extended query history & no limits on schedules
✅ Up to 100 folders & enhanced profile customization
🤩 And more...
I'll be chatting with
@drakedanner
about all things NFT, DUNE and Crypto Communities on Wednesday 22:00 UTC in the Dune Discord.
danner is gonna give us a rundown about his work on
@DuneAnalytics
and will share his alpha re: evaluating NFT's with on-chain analytics.
🚨🚨THE REVOLUTION WILL NOT BE REPORTED QUARTERLY 🚨🚨
This not only applies to single projects, but also the development of whole sectors.
It's all live on
@DuneAnalytics
.
Thread below 👇
I'll be chatting with
@indexcoop
's
@josephdcook
about how Dune helps the Indexcoop manage their data and how to surface signal in the depth of blockchain data!
Event link:
We'll be in the Dune Discord (link is in description of event)
NXM staking is an integral part of the
@NexusMutual
protocol — it's the primary way members share risk with each other.
With this new DAO
@DuneAnalytics
dashboard, you can explore staking stats & see what covers members are staking against!
📈 Staking:
📣 New feature – auto-export shadow events to
@DuneAnalytics
Share custom contract data with the Dune community in minutes. Set it once, and let the data flow.
Wizards which have contributed to Dune's Abstractions/Spellbook in 2020, 2021 or 2022 can now claim their GitPOAPs for their contributions.
Read about the story
⬇️⬇️⬇️
Coming to a GitPOAP near you: the most useful analytics tooling in all of web3.
Earn the GitPOAP on your journey to becoming a wizard with the
@DuneAnalytics
Spellbook
They have amazing resources if you need help getting started!
This is what Dune Community is all about really:
Curious people trying to help the space advance by surfacing data and helping other people surface data.
Dune fam is full of ambitious, smart and integer people and I feel incredibly lucky and happy to be a part of it.
We'll
Gm all.
With Dunecon arriving soonTM. Want to share my biggest gratitude to some Dune chads, helping wizards alike in the past year!
@0xBoxer
who is a huge advocate for all wizards and working the docs
@crypto_DIPsy
and
@superamscom
who have answered most questions on discord
Dune's wizard of the month for the last ∞ months joining one of Dune's lead investors is the crossover episode nobody knew they wanted but god damn I am here for it😤
Congrats
@hildobby_
🎉
Hey everyone, I'm excited to announce that I'll be joining
@dragonfly_cap
as their first data scientist starting in July!
I look forward to working with
@tomhschmidt
and the rest of this amazing team 🙌
A small step for Dune, a big Step for a workhorse.
Happy and excited to join the team on the journey to make
aggregated blockchain data as open, accessible and transparent as it should be.
The Data must flow.
Many have noticed
@0xBoxer
's relentless dashboard building across DeFi ⚒️📊💯
Today we're excited to welcome the hardworking horse as Community Manager for Dune 🤝
Join our Discord to get free world class support for your query and dashboard building👉
Everyday I am thankful for
@apoorvlathey
's eth-explorer-browser extension 🙏🙏
The extension creates a context menu in your browser that sends you straight to Transaction- or Address-sleuthing pages.
literally saved me hours at this point
Looks like
@ownthedoge
/ $DOG is preparing to launch on
@base
👀👀👀
The ownthedoge.eth multisig recently moved $3.5M $DOG to the base bridge on mainnet and added liquidity on UniV3 over on Base.
Boxer, do you not have better things to do but stalk
Over the last few days I have worked on creating an extensive Dashboard for
@Barn_Bridge
on
@DuneAnalytics
.
If offers a nice look into how BarnBridge's epoch system is working out and shows how centralized stablecoin farming really is:
1/7
I'll be at the Avalanche Summit for the week, slide into my DM's for anything Dune related, would love to meet some wizards and future Wizards.
Avalanche data will be on Dune soontm.
#AVAX
Super excited for DuneCon and
@ETHLisbon
at the start of November.
Gonna be great to meet so many legends that I only know online atm in person for the first time.
DuneCon still has a few open spots - if you want to build a network in Crypto data - that's definitely the spot to
The Wizard Panel at Dunecon with
@chuxin_h
,
@0xKofi
and
@hildobby_
was amazing.
❓ How to work as a Web3 data analyst?
🧑🤝🧑 Where do I start?
🎯 What do I focus on?
Enjoy the recording!
This one goes out to all the hobby analysts and whale watchers🐳:
A
@DuneAnalytics
dashboard to track the allocation of $YFI tokens and to track different staking avenues more in depth.
This first graph gives a broad overview of the different utilization methods of YFI.
1/8
Talking to ethereum staking data nerd
@hildobby_
about staking and restaking was a great convo.
We also talked about the possible eigenlayer ecosystem and the implications of the same.
Word on the streets is
@chuxin_h
will also join
@0xKofi
and
@hildobby_
on the panel of web3 data science career paths.
They have all walked the walk of being a freelancer/hustler in the space and are all in great positions now, this panel is gonna be 100% signal!
hanging out at
#devconnect
coworking for the rest of the day, hmu if you wanna chat Dune, data or life!
Specifically looking for feedback from active dune users 👀
Gonna pass along some ancient Wizard secrets together with
@hildobby_
@sui414
at EthDam 🪄.
Looking forward to meeting some Wizards, hit me up if you are around!
🔮 Happy to have
@0xBoxer
from
@DuneAnalytics
joining
#ETHDam
Speaker Squad!
🧙 Boxer is joining our workshop, along with
@hildobby_
and
@sui414
, are you just as excited as we are?
🐬 Get your dolphin tickets, before they all swim away!
We’ve been hard at work building tools to make Dune more accessible for you and your team 🧑🏽💻 🧑🏼💻 👨🏿💻 .
Today, we’re happy to announce new features designed for better collab and a more seamless experience.
Have a look 👀🧵
Any DAOs or organizations currently looking to get work done on Dune?
I am working on bounty infrastructure and looking for guinea pigs and project's perspectives.
very inspiring story on how
@DuneAnalytics
can kickstart and accelerate your career in just 5 short months!
ggwp
@defi_mochi
looking forward to what you build next 😤
I’m joining
@duneanalytics
to lead education as Headmaster! 🧙♂️
I’m excited to continue creating educational tools and initiatives that empower our wizard communities. No matter who you are - I’d love to help you get more involved in the web3 data ecosystem 👇
If you are an excel monkey, accountant, Wall St. Intern or anyone else who wants to become a DeFi Analyst:
Slide into my DM's and I will personally give you an intro to Dune and help you get started on the journey.
🎙️ We'll record another episode of the Weekly Wizard on Thursday 17:30 UTC.
This weeks guest will be none other than the GOAT 🐐
@MSilb7
.
❓Drop your questions for Michael below this tweet or in the chat during the live stream! 👇
I'll be in Berlin for
@ETHBerlin
,
@dappcon_berlin
and safecon. HMU if you want to meet me there, would love to meet some wizards or future wizards.
Dune product and docs feedback is always welcome, but I also just like having a good time and meeting people.
Do you want you an awesome Dune Dashboard for your project/Protocol and contribute to an awesome learn to earn experience?
We are still auctioning off a "Protocol Sponsor" NFT for the
@DuneAnalytics
X
@OurNetwork__
Data Bootcamp.
My favourite event of the year in one of my favourite cities 🤩
I look forward to meeting all my wizard frens, listening to top tier speakers and just enjoying the immaculate vibes of the Dune Community in Person! ✨✨✨
DuneCon 2023 registrations are open!
We are inviting all Wizards, data enthusiasts and the data community to join us on November, 2nd in Lisbon.
We have an amazing line up of speakers, many of our top Wizards will be there and you'll have the chance to meet the entire Dune
PSA: Etherscans "Token Holders" section is in no way accurate since it picks up dust amounts and you should stop using it to measure holders of a token.
Luckily I have just the solution for you on
@DuneAnalytics
:
It's about all the frens we make along the way.
Happy to see that my months of educating and trying to bring the community together is now bearing fruits.
@drakedanner
has been a prime example of somebody who only started out recently and is now providing big value.
What I can say today, after having worked on surfacing data for 10+ protocols on
@DuneAnalytics
is this:
Data is a really valuable currency in DeFi and people are ready to pay good money for you to surface that data.
Want to learn how to use
@DuneAnalytics
, but don't know where to start?
Check out my guide for complete beginners and build your own
@PoolyNFT
dashboard!
✅ Dune interface
✅ SQL queries
✅ Visualizations
✅ Step-by-step explanations
Get started now!⬇️
Despite popular belief, I don't think
@ethereumJoseph
has won this bet just yet.
My analysis shows that Ethereum has long exceeded >100k unique monthly users, but finding 5 dapps with >10k daily users proves hard.
🚀 New Product Launch 🚀
Introducing Dune Datashare – your gateway to curated crypto data directly on Snowflake.
Access 1.5M+ datasets, including raw data, smart contracts, protocols, and cross-chain data from 15+ chains 😱
Dune Datashare is live today!
If only there was a way of getting accurate data for retroactive airdrops based on participation/usage rather than just obscure datapoints...
If that's a problem you are facing hmu, me and the
@DuneAnalytics
gang will figure it out!
Yesterday I learned what blobs are, how they change ethereum and why Rollup transactions are virtually free now.
Was a really interesting convo with
@MSilb7
and I look forward to seeing how blobs and their fee market evolve.
wtf are EIP4844 and blobs??
@MSilb7
joined us in this week to break those down:
📦 EIP4844 Explained
📈 Blobs Gas Market
⛽️ End User Gas Prices
🤌 Controversies & What's Next
YouTube:
Spotify:
@DuneAnalytics
is looking for a Marketing Manager!
This is a fantastic opportunity: Dune has an active community of thousands of creators, millions of monthly impressions, a strong brand and a great reputation throughout the entire ecosystem.
Key themes of this position:
-
very insightful and exiciting Arcana today, was a pleasure to see
@agaperste
and
@tomwanhh
share their knowledge regarding the FTX situation.
Big ups 🙌 to
@21Shares
for making their research public!