Pinned
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
Boxer
1,531 posts
Boxer
@0xBoxer
- 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
- Everybody looks at @Polymarket data wrong: Volume is not a great metric. Open Interest aka the positions traders are in is what really matters. Open Interest dictates liquidity conditions and ultimately makes the network effects within polymarket work. So let's actually look
- Some raw impressions from EthCC on - Panels - Hard truths - Industry structure - tech progress - class of 21/22 - deeply unserious people - are we back? - job market - brussels - sideevent meta Panels The Panels meta sucks, 5 people and only 20 minutes time does not bode well
- idk man apeing shit in eth eco is just not fun. uniswap v4 launches, @flaunchgg builds quite a sophisticated memecoin platform on top of it and the top shitter $FLNCHY can't even break a $15 mio mcap. the memecoin casino has entirely moved to solana, all other memecoin arenas
- 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. duneanalytics.com/0xBoxer/1inch-โฆ
- 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
- to all the fledgling, struggling wizards out there who are trying to join the big leagues: find your niche 30+ analysts are reporting on avg tx per second on base and transaction count going up. there are exactly zero good analysts looking into what is happening on aptos, fantom
- 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
- I have built a dashboard covering the latest and greatest developments in the "decentralized Indices" sector of DeFi : Thread below: duneanalytics.com/0xBoxer/indiceโฆ
- Replying to @JasonYanowitz@Rabby_io has completely solved this problem with gas top ups. You send them money on chain X, they give you money on Chain Y. Works 100% of the time, with super quick turnaround times. truly elevating my EVM UX one gas top up at a time
- The incoming 47th president of the United States of America just onboarded 115k people to crypto
