Freelance Dune Wizard, data @blocklyticsHQ in my free time.
Lagos, Nigeria
Joined February 2020
- Tweets2.2K
- Following1.8K
- Followers1.7K
- Likes2.5K
henrystats 🦇🔊 retweeted
This could have been a tweet but I like to yap about culture and community in web3.
Enjoy this video series “culture x tech”
Drop a ❤️ if you enjoyed this.
henrystats 🦇🔊 retweeted
Some silver linings.
Didn’t expect this chapter to close just yet, but I’m walking away with kind words and sharper skills!
Change is constant and I believe it’s for my good.✨
So yes, I’m open to new opportunities.
If you need someone with solid people skills, conflict resolution experience, and a good head for your community/team management, I’m your person.
Currently accepting meaningful work and good vibes because my calendar is awkwardly clear 🤭
henrystats 🦇🔊 retweeted
Battle of Bridges: Across vs Stargate
It is easier to start wars, but harder to end them. I'd like to be known as the peacemaker who ended this battle early, the sandbag that prevented the flood.
Building Dune dashboards isn't my main thing, but I'd happily build a 1000 dashboards if I can save @PrimordialAA and @hal2001's precious time and resources that could be spent better, saving Ethereum.
In this post we compare Across, Stargate Taxi (fast option) and Stargate Bus (slow option) head to head. And we compare them for various transfer sizes:
$50 (+/-5%)
$100 (+/-5%)
$1000 (+/-5%)
and >$10k transfers
We compare them for Base -> Arbitrum and Arbitrum -> Ethereum routes.
TLDR:
Base -> Arbitrum: Use Across for small transfers and Stargate Bus for larger transfers.
Arbitrum -> Ethereum: Use Across
Here is the full analysis:
1. Base -> Arbitrum ETH Transfers
a. Bridge Fees
In the median transfer range of $50-100, they all seem to be quite close. Typically Stargate Bus should have been cheaper than Taxi but LayerZero airdrop caused Arbitrum Gas spike which resulted in high fees for Bus transfers.
I wouldn't say the metrics are skewed, it's natural to have an airdrop cause gas spikes in L2s. Atleast now you will know which bridge to use during gas spikes.
Stargate seems to be much cheaper for larger transfers of around $1k. Taxi and Bus are 2x and 3x cheaper than Across.
For >$10k transfer sizes, Stargate Taxi and Bus are 5x and 10x cheaper than Across.
b. Bridge Speed
It should come as no surprise that Across is faster than Stargate, in all scenarios and transfer sizes except when it comes to big transfers (>$10k).
Across relayers probably don't want to take risks when big money is at risk, hence the delay.
Conclusion (for Base -> Arbitrum)
Our options are clear as day. I don't think there is much debate here.
For small transfer sizes ($50-100), @AcrossProtocol is clearly the better option because it is near instant. It is around 50x faster. Nobody wants to wait 3-5 mins for a bridge transfer.
For larger transfer sizes ($1000, >$10k), @StargateFinance Bus is clearly the better option. When big money is involved, you would wait a few mins.
Here is some more information about the data we sampled for this analysis.
2. Arbitrum -> Ethereum ETH Transfers
It is interesting to see that Across pulls through for the Arbitrum -> Ethereum route and is overall the better bridge. This is unsurprising because Across has been known for L2 -> L1 bridging since the beginning.
Although Across is more expensive than Stargate Bus, I'd say people don't mind spending more for faster bridging especially for smaller amounts. With Across, I pay $5 to bridge $50 in 9 secs whereas with Stargate Bus I pay $2.5 to bridge in 5 mins. My hourly wage is higher than the amount I save.
For larger amounts, Across seems to be quite competitive, it is even cheaper for very large amounts. Kudos to their L1 liquidity pool, I guess.
Thank you for being a witness in the Battle of Bridges. Please like, retweet, and follow for more cross-chain related posts.
For other routes and assets (USDC Transfers), please check out the Dune Dashboard linked in the reply below.
Perfect.
A Dune dashboard that compares Across vs Stargate on these routes:
1. Base -> Arbitrum
2. Arbitrum -> Ethereum
Any more routes?
Sizes:
$50 (Median)
$100 (Mean)
$1000
$10000+
We will have two things:
1. Comparing costs using BPS
2. 31st will be used as the reference date
3. Not sure if I can compare speed, but if I can I will add that as well.
henrystats 🦇🔊 retweeted
One of the requirements for the recent $ZK airdrop from the @zksync L2 was to be a Milady or Pudgy Penguins NFT holders.
I've spent 2 days gathering a lot of data to highlight some differences in behaviors between these two communities so you don't have to.
The last airdrop Miladys got was the $OMNI airdrop. At that time, the amount being held (in terms of %) was good and it was super surprising given the market conditions. The point was made that Milady holders were not jeeters, but rather diamond hands.
However, market condition can shift really fast. What about now ? What does the data tell us ?
To make this happen, we'll be using @DuneAnalytics and also gather data into Excel to figure out the amount of $ZK being retained by both collections.
Let's dive in, follow me now🧵
henrystats 🦇🔊 retweeted
. @Blast_L2 is now LIVE on Dune! 📊
Are you ready for a deep dive into your yield analysis?
Read more 👇
dune.com/blog/blast-is-now-l…
henrystats 🦇🔊 retweeted
Okay, so here are some observations about today's @DuneAnalytics update from the perspective of a novice SQL learner (for now). I believe novices opinions are by far the most importants for projects to take care of for few obvious reasons :
-Feedback on ease of use of your interface
-Can improve documentation
-Unbiased perspective
Anyway briefly :
It's just incredible. These updates are amazing. I have no doubts now that Dune is actually going on the right path for mass adoption. I wouldn't be surprised to see Dune Analysis courses in some univerisities in the future.
Now, few screenshots below :
1) Informative and straight detail on what roles the column occupy in the table :
First here you can see that now Dune added these new "i" circle logos (for "information") at the right of each columns. If you just get your mouse on them, it gives you a quick idea of what this column contains or what it can be used for :
That was super needed for newbies and please thunderous applause to the team and specially to @__scalar__ which is a super smart guy who knows where to listen to the powerful feedbacks.
He told me the team had some plays in mind and it's crazy how this one just impressed me. However if I am correct, that option is not included in every table rn. I am just not sure if that's because some other tables, that might also have these columns, already got these informative logos on their right so they are prolly not doing that again and again for every data table, idk.
Anyway, I'll just give another feedback on this one later.
2)Columns to use to boost query speed with filtering :
Honestly, as I said I am just getting started and not an expert at all. I won't be able to give a proper feedback on this one tho I believe it's super useful too rn.
So this might now allow people to write more efficient queries. Doc here if you guys wanna get a deeper understanding : docs.dune.com/query-engine/w… (doc will be updated soon with more info, team says)
3)Direct links to github sql repos with every spellbooks:
Again so sorry but I am not an expert. However, if I have to guess that's super powerful because :
-Now everyone is able to identify any potential bugs or errors regarding the tables and can just pull request to fix it asap (super nice).
-Better comprehension of how the data is stored, structured.
-Maybe better integration for people building apps ?
I hope I didn't miss anything but I am so proud of how the team is smartly filling the gaps. There is no doubt that Dune will be by far one of the most used platform for analysing crypto data. They are focusing on the right things to make this happen so it's pretty cool to see these improvements merging to make User Discovery, UX better every months..
But if I may offer one critique in relation to the first thing I talked about, it is that occasionally the information provided isn't sufficiently clear. Taking the data column tx_hash as an example here :
It returns "Transaction hash" as an information but I would've preferred something like :
"unique immutable identifier for each transaction on the blockchain that allows verification of transaction details"
Unfortunately, it's not always clear (I've only used one example here), but yeah might happen more idk. However, the Dune crew will undoubtedly handle this better than I will (as they showed us today LOL), so it's not even that big of a problem for them😂
Anyway massive congrats to @andrewhong5297, @__scalar__ , @hagaetc and the rest of the team.
Too smart to fail I'd say 👏
henrystats 🦇🔊 retweeted
1/ Analysis on @taikoxyz Bridge Activity Using @DuneAnalytics
🔹A total of 6835 Bridgers with 7530 transactions
🔹 Majority of bridgers (94.3%) have only interacted with the bridge once
🔹 A smaller group (5.4%) interact 2-5 times, suggesting they're exploring further.👇
henrystats 🦇🔊 retweeted
GM @justinsuntron 🫡
Pretty busy morning for His Excellency:
◎ 10,000 ETH for 10,111.937 @ether_fi PT-weETH
◎ 5,000 ETH for 5,082.9 @puffer_finance PT-pufETH
◎ 5,000 ETH for 3,025.9 @KelpDAO PT-rsETH
All in all, looking at +220.737 ETH profit in 22 days (27 June 2024)
孙哥 Justin Sun 在 7 小时前，使用 0x7a9...095 地址花费 18,000 ETH ($67.86M) 买入了 3 家 LRT 6/27 到期的 PT。
来赚取约 17%~21% APY 的币本位固定收益。
◎10,000 ETH 买入 10111.937 PT-weETH (6/27 到期 1:1 换得 weETH)；
◎5,000 ETH 买入 5,082.9 PT-pufETH (6/27 到期 1:1 换得 pufETH)；
◎3,000 ETH 买入 3,025.9 PT-rsETH (6/27 到期 1:1 换得 rsETH)。
22 天到期后可以获得约 220.7 ETH ($0.83M) 的收益。
debank.com/profile/0x7a95f15…
本文由 #Bitget｜@Bitget_zh 赞助
henrystats 🦇🔊 retweeted
reducing everything to memes in a space that already lacks substance is very dangerous
it's a way of coping with the fact that there just simply haven't been too many things that meaningfully create value in crypto
especially when compared to the amount of money that's been put into the system
the answer isn't to give up and say "ah well, everything is a meme anyway"
it's to do the hard work of creating value
henrystats 🦇🔊 retweeted
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 or polkadot parachains.
-> think about what can set you apart
know your shit
your readers can tell if your analysis is a work of art and love or just you producing content to produce content. I don't need an analysis in the style of a weather report. Go from: here is metric X -> event Y is happening, here is how it shapes metric X
-> you have this tweet to present to your boss's boss, it better be meaningful stuff
become a character
you are competing for tiny amounts of attention in the global arena of attention seekers, you better be interesting, unique or funny. nothing worse than midcurving your character arc.
-> lean into ct, stop trying to be a faceless corpo analyst
build connections
help others, collaborate, produce educational content, dm someone if you see a way to improve their work or if you find a mistake.
be the data reply guy (try to not be annoying though)
-> it's easier not to walk this path alone, find your people
be in the arena, trying stuff
nobody cares about whack tweets you put out, but everyone cares when you finally hit a banger.
-> shooters shoot your shot, don't care about the outcome
study the algo
your reach/influence on twitter is your network capital, study what does well, iterate, adapt, overcome.
too many ppl on my timeline who do good stuff, but tank their reach by making easily avoidable mistakes like including links or still doing threads. (also twitter blue really helps unfortunately)
henrystats 🦇🔊 retweeted
After months of work, @LehmannLorenz and @rob_0x have published a powerful new EIP-4844 blobs dataset to @DuneAnalytics. It's going to unlock a ton of new and exciting research!
Here's how to use it:
henrystats 🦇🔊 retweeted
1/ 🌐 You always ask for more blockchains on Dune. Today we are making it happen 🤌
Introducing Dune Catalyst: Our latest enterprise solution to streamline blockchain data integrations via the Catalyst’s standardized APIs docs.dune.com/api-reference/…! 💡
#DuneCatalyst
henrystats 🦇🔊 retweeted
1/ Over the past week, @base has averaged ~1.8M daily transactions, exceeding Ethereum's average by nearly 40%.
Check out my "BASE BLOCKCHAIN OVERVIEW" Dashboard that i built on @DuneAnalytics
LINK📊: dune.com/sofiat/base-overvie…
henrystats 🦇🔊 retweeted
Episode 7 is live, come watch us dive into staking and restaking data 🥩
YouTube: youtu.be/ZbLXU4YpN28
Spotify: sptfy.com/QKrD
henrystats 🦇🔊 retweeted
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.
Episode 7 is live, come watch us dive into staking and restaking data 🥩
YouTube: youtu.be/ZbLXU4YpN28
Spotify: sptfy.com/QKrD
henrystats 🦇🔊 retweeted
54% of @eigencloud TVL ($8.2bn) is being productively utilized in DeFi
Must read research report to understand the current landscape of the “points farming” meta
