J.Hackworth Profile Banner
J.Hackworth Profile
J.Hackworth

@jphackworth42

2,740
Followers
683
Following
234
Media
754
Statuses

Data Wizardry @variantfund

Chicago, IL
Joined November 2021
Don't wanna be here? Send us removal request.
Pinned Tweet
@jphackworth42
J.Hackworth
1 year
I wrote a blog post where I share my journey of falling into the crypto data rabbit hole, adopting the identity of "J Hackworth," and joining @variantfund . Check it out below!
7
10
87
@jphackworth42
J.Hackworth
2 years
@loldefi Part of the reason why I love Lex. He’s not afraid to embarrass himself, he wants to learn during his conversations, and has genuine human connections during his interviews. He may not know everything but the dude is awesome and have learned so much from him.
6
0
220
@jphackworth42
J.Hackworth
1 year
Life Update: I’m thrilled to announce that I have joined @variantfund as a data scientist! I am extremely excited to work with such a high-caliber team and continue diving into all things crypto data!
39
9
223
@jphackworth42
J.Hackworth
6 months
Excited to see the emergence of dataDAOs like @rdatadao which has already had over 137k addresses claim the $rDAT DataDAOs represent a win-win for data collection: -Businesses can collect hard-to-come-by / niche datasets -Users are compensated & incentivized for their data
Tweet media one
40
54
164
@jphackworth42
J.Hackworth
4 months
1/ Hyperlane is emerging as a strong come-from-behind contender in enabling the modular future. Hyperlane’s continued expansion to chains has enabled it to process over $1.5B in volume in the last 3 months. An analysis of Hyperlane is growing into an interoperability leader.
Tweet media one
7
25
125
@jphackworth42
J.Hackworth
3 months
1/ Crypto x AI: Emerging Onchain As more projects work at the intersection of crypto x AI, we are starting to see how these two technologies can work together reflected onchain An exploration of how the combined potential of crypto and AI is showing up in the onchain data
14
28
130
@jphackworth42
J.Hackworth
2 years
1/ Are NFT Marketplace Airdrops generating real, long-term success or are they just hype? My latest research as a guest post for @rabbithole_gg digs deep into the on-chain data to uncover the truth! Check out the report & 🧵below for top insights
12
63
106
@jphackworth42
J.Hackworth
1 year
4/ Base has had over 68 million NFTs minted within its ecosystem. Most of these mints are attributed to the "Bridge to Base" NFT (59.5M). Besides Polygon, Base had the second-highest NFT activity for an Ethereum L2
Tweet media one
Tweet media two
27
7
101
@jphackworth42
J.Hackworth
1 year
Ethereum Address Stats in Past Year -Monthly active addresses ranges from ~4.5M - 7M on Ethereum. -In the past year, more than 26.69 million wallets were created, averaging around 2 million new wallets per month. -The retention rate of new wallets is relatively modest, with
Tweet media one
Tweet media two
Tweet media three
11
9
97
@jphackworth42
J.Hackworth
2 years
The biggest reason I love crypto is the ability to access data I’ve spent over two weeks trying to get access to a “business critical” database. Spent 2 hours trying to trouble shoot the installation. Still no resolution. With crypto anyone can query on chain data in seconds
8
10
87
@jphackworth42
J.Hackworth
9 months
@QwQiao @jerallaire @rajgokal @aeyakovenko I think there is more than meets the eye on this one: Looks like ~90% of the volume is executed by two accounts over the past 7 days. Likely some sort of arbitrage happening here, but need to look into it more and dig further
Tweet media one
6
7
71
@jphackworth42
J.Hackworth
1 year
1/ Since the launch of Base, over 964k addresses have joined the onchain summer party. Base’s daily transactions even flipped both Arbitrum and Optimism last week. So what’s actually driving this growth?
Tweet media one
6
14
70
@jphackworth42
J.Hackworth
10 months
1/ NFT sales may be way down from all-time highs, but there is still a lot of experimentation happening onchain that I believe will help bring in new users & use cases to the NFT world. Check out my new article on my @viamirror & top insights below
10
19
58
@jphackworth42
J.Hackworth
2 years
Kinda surreal moment. Last year I was just a casual listener of @BanklessHQ . This year they posted an article talking about the analysis I did! Shows you how far you can come when your willing to put a little work in crypto
@BanklessHQ
Bankless
2 years
The Next Stage of Airdrops @NathanSnell , Co-Founder and CEO of @RaleonHQ , explains why today’s airdrops need to grow up. Full read 👇👇
2
7
38
7
7
61
@jphackworth42
J.Hackworth
8 months
Want to track what is happening with the Jupiter Airdrop? Then look no further than my latest @DuneAnalytics dashboard! So far over a quarter of the airdrop has already been claimed
Tweet media one
10
11
60
@jphackworth42
J.Hackworth
2 years
1/9 Current airdrops need to change. @HopProtocol had 16% of airdroppers dumped $Hop within 30 days. What if there was a way to prevent dumping via on-chain analysis & ML? Through @flipsidecrypto shroomDK, I built a model to predict if a wallet would dump an airdrop to solve this
8
7
55
@jphackworth42
J.Hackworth
2 years
Interested in Crypto Governance? This tool I created tracks @SnapshotLabs data to identify what protocols are active, who the most prominent voters are, and how engaged communities are the process with data via @flipsidecrypto . Lets check out some of the key features
Tweet media one
5
11
55
@jphackworth42
J.Hackworth
2 years
1. 2022. What a Crazy Year for Ethereum. With over 390M+ Transactions and 2.31M Blocks to look at, I broke down the top trends of the network powered by @flipsidecrypto data Top Insights 👇
4
12
52
@jphackworth42
J.Hackworth
1 year
1/ August saw one of the highest months for NFT minting with 6.25M mint-related transactions across Base, Optimism, Arbitrum, & Ethereum resulting in the creation of 93M NFTs 🤯
Tweet media one
Tweet media two
6
9
53
@jphackworth42
J.Hackworth
9 months
1/ That's a wrap on 2023. So, what did you do onchain? Check out my Ethereum Wrapped post on my new @viamirror blog about onchain metrics for the year, highlighting the top trends I found in the data. Quick dive into the biggest takeaways I found
6
26
49
@jphackworth42
J.Hackworth
1 year
What are some of the biggest pain points in web3 analytics? Some that come to mind off the top of my head: -Lack of identity makes it difficult to discern what users are doing. Onchain data is just one side of the puzzle. One of the biggest issues associated with this is that
16
1
51
@jphackworth42
J.Hackworth
1 year
At EthCC in Paris this week, Uniswap announced UniswapX, a new protocol for trading across AMMs. Our view is that UniswapX will be additive for the Uniswap protocol. Here’s why, based on a deep dive of Uniswap protocol fundamentals we did @variantfund . 🧵 with @Derekmw23
2
16
52
@jphackworth42
J.Hackworth
3 months
2/  AI agents are going to complete the bulk of onchain transactions This trend is evident with Autonolas prediction market agents. The # of agent transactions has grown by 2x since the start of the year, completing over 38k weekly txs & ~63% of Gnosis Safe txs in the past month
Tweet media one
1
10
44
@jphackworth42
J.Hackworth
6 months
This new dune feature for tabs makes my life 10x better when I have 20 dune tabs and 3 different queries ongoing
Tweet media one
3
0
41
@jphackworth42
J.Hackworth
1 year
has seen explosive growth with over $6.8M (3.7k+ ETH) in trading volume Comparing its performance since launch to the ENTIRE Ethereum NFT market it has: ~9x as many txs -1.4x as many buyers - .9x the volume as mainnet We'll see where the platform goes
Tweet media one
Tweet media two
13
9
38
@jphackworth42
J.Hackworth
8 months
Only 185.9M addresses have ever sent a transaction on Ethereum to show small crypto still is. To put it in perspective, Facebook has over 3B+ monthly active users We're still so early Source: @flipsidecrypto
Tweet media one
6
5
33
@jphackworth42
J.Hackworth
5 months
Two trends playing out right now: The number of publically traded companies continues to drop now at ~4300, a decrease of over 40% from its peak The number of tokens traded on DEXs continues to increase with April seeing 65x more tokens than publically traded stocks
Tweet media one
1
3
26
@jphackworth42
J.Hackworth
2 years
Of the ~2M Addresses that have bought an NFT on Ethereum only 3.6% have not used @opensea . Are they the undisputed kings? In my latest @DuneAnalytics dashboard, I investigated the current NFT marketplace ecosystem to see whats really going on
3
6
34
@jphackworth42
J.Hackworth
11 months
Excited to be on this panel at DuneCon!
@DuneAnalytics
Dune
11 months
What's a sustainable way to distribute Tokens? Airdrop farming has become an Industry of its own, airdrops are overfarmed and nobody is happy about the current state anymore. @agaperste is going to host a panel with @subinium , @Flynnjamm and @jphackworth42 to discuss past,
Tweet media one
11
10
75
4
1
35
@jphackworth42
J.Hackworth
1 year
Its been all about Base lately Check out my latest @DuneAnalytics dashboard covering Base Activity. Dashboard covers: -Address Metrics -Project & Category Usage -NFT Activity And More!
3
4
28
@jphackworth42
J.Hackworth
10 months
1/ For the first time since the collapse of UST, we are starting to see strong growth in the stablecoin supply with over a ~$4.25B net increase over the past 30 days. But which chains & stablecoins are driving this growth? A 🧵 on some of my top takeaways
Tweet media one
2
7
31
@jphackworth42
J.Hackworth
2 years
@punk6529 I’ve love how much I have grown my skills in analytics and learning about the data behind blockchains through contributing to DAOs. The best part is that Ive been getting in paid in crypto which further allows me to play around in DeFi and learn.
1
3
31
@jphackworth42
J.Hackworth
1 year
As a counter to the below tweet, I’ve been thinking about what some of the greatest benefits of web3 analytics are: Data Democratization: While most of the worlds is stored inside the walls of tech giants, anyone has the ability to analyze, investigate, or tap into onchain data
@jphackworth42
J.Hackworth
1 year
What are some of the biggest pain points in web3 analytics? Some that come to mind off the top of my head: -Lack of identity makes it difficult to discern what users are doing. Onchain data is just one side of the puzzle. One of the biggest issues associated with this is that
16
1
51
3
2
31
@jphackworth42
J.Hackworth
11 months
In honor of zkSync data being live on @DuneAnalytics , Check out my dashboard covering all things zkSync! Looking forward to exploring this dataset more!
Tweet media one
zkSync Era data is now LIVE on Dune! @zksync Era is a layer 2 protocol that scales Ethereum's security and values through zero-knowledge cryptography. With millions of users and transactions, there is plenty to explore. As of today, all zkSync data is live on Dune! This
Tweet media one
71
204
822
1
1
29
@jphackworth42
J.Hackworth
1 year
1/ Last week, I wrote a post on how DEXs are still thriving in the bear market. Check out the full blog post and see some of the key insights in the thread below!
2
3
29
@jphackworth42
J.Hackworth
5 months
10M weekly active wallets in the Ethereum ecosystem is a bit misleading to say Deduplicating chains results in 8.7M Filtering for wallets active for 1+ days. 6.1M Over 5 days? 4M This doesn’t even count bots/sybils that inflate these numbers True adoption is still far away
@RyanSAdams
RYAN SΞAN ADAMS - rsa.eth 🦄
5 months
10m active wallets per week in the Ethereum economy. I think we get to 100m this bull run. We finally have the bandwidth to 10x our users. Onchain is the new online.
Tweet media one
28
53
457
3
0
30
@jphackworth42
J.Hackworth
2 years
Crazy to see that two of the leading activities for Ethereum users in the past 30 days are bridging to zksync and starkware Over 300k+ (6% of active users ) in the past 30 days bridged to zksync The people are hungry for an airdrop after Arbitrum
Tweet media one
3
6
28
@jphackworth42
J.Hackworth
11 months
Created a new @DuneAnalytics dashboard that tracks all things Zora Network such as: - Network Activity - Mint Metrics - Trending Collections - Protocol Rewards And more! Check it out in the link below.
Tweet media one
1
1
27
@jphackworth42
J.Hackworth
2 years
1/ Dove into some on-chain data around DEXes post-FTX collapse via @DuneAnalytics thanks to the recommendation of @MetricsDAO . One thing that stood out was how much dominance exists (Top 100 traders do ~75% of volume). Check out some of the top insights below 🧵
@jphackworth42
J.Hackworth
2 years
Check out my latest dashboard where I did a deep dive into DEX metrics & Users using some good old on-chain analysis
2
6
20
2
9
27
@jphackworth42
J.Hackworth
2 years
Check out my first article published on @DuneAnalytics on the aftermaths of the @Uniswap airdrop. See some of the highlights in the 🧵 below!
@DuneAnalytics
Dune
2 years
Is the airdrop model broken? In a new article, @jphackworth42 tackles this question through an analysis of Uniswap's 2020 drop..... Short summary🧵
10
73
214
3
3
24
@jphackworth42
J.Hackworth
1 year
NFTs can enhance the way musicians connect with fans: Since launch on Optimism (6/9), 110 editions have earned $200+ on @soundxyz_ with the median # of minters being 36 for this cohort Achieving that on Spotify is estimated to be 50k streams or 1388 plays each for those 36
3
3
25
@jphackworth42
J.Hackworth
8 months
Last week, Zora reached an all-time high in protocol rewards with over 278 ETH earned by creators and minters. This contributes to the overall total of more than 2.6k ETH earned since protocol rewards began.
Tweet media one
3
0
24
@jphackworth42
J.Hackworth
7 months
With frame transactions live, I created a @DuneAnalytics dashboard to track what’s happening with frames onchain. Frames transactions have generated 4K+ transactions and been used by 3.3k+ addresses within the first few hours. Check out the link below 👇
Tweet media one
1
6
25
@jphackworth42
J.Hackworth
10 months
This is the time of year that I question why there isn’t a Spotify Wrapped for Crypto: - A breakdown of what your onchain activity is like & stack it up against friends -Mint an NFT to prove that you are in the top 1% of degens on a DEX -Unlock special gifts / perks from a
6
3
24
@jphackworth42
J.Hackworth
1 year
Spot when a collapse happened in crypto by looking at Ethereum DEX volumes on @DuneAnalytics : - 3/11: SVB Collapse (~19B in volume, Highest day ever for ETH DEXes) - 11/8: FTX Collapse - 6/13: Start of 3AC / Celsius Collapse - 5/9/22: Luna Collapse
Tweet media one
4
5
20
@jphackworth42
J.Hackworth
1 year
Friend Tech has done $75M+ in volume with over 118k+ addresses, but there’s a stark contrast between power & long-tail user behavior: - 500 addresses comprise 44% of ’s total volume - 68.5% of addresses have bought < $5 dollars in keys, with 82% of
Tweet media one
Tweet media two
Tweet media three
2
4
23
@jphackworth42
J.Hackworth
8 months
Are Ethereum NFTs Back? While volume has been increasing week over week, trading has been concentrated in just a few addresses & collections Since 9/18/23: -500 buyers have accounted for 47% of Ethereum’s total NFT volume -100 traders on Blur did 45% of its total volume
Tweet media one
Tweet media two
Tweet media three
1
3
23
@jphackworth42
J.Hackworth
1 year
I want to give a sincere thank you to all who have helped me along the journey, especially the overall crypto data community, @DuneAnalytics , @flipsidecrypto , & @MetricsDAO . Also big shout out to @jpoGMI for red pilling me into the onchain data scene!
1
0
23
@jphackworth42
J.Hackworth
11 months
Going to be attending both Breakpoint and DuneCon next week If you are interesting in talking crypto data hit me up!
4
0
20
@jphackworth42
J.Hackworth
4 months
Today I learned that after close to four years people are still claiming the Uniswap Airdrop. In 2024, 251 addresses have still claimed over 100k of UNI this year (~$929k)
Tweet media one
1
0
21
@jphackworth42
J.Hackworth
7 months
Going to be at ETH Denver next week. If you are interested in talking about onchain data or AI hit me up!
4
0
20
@jphackworth42
J.Hackworth
1 year
Beyond this chart being a work of art worth minting, it would be really cool to integrate minting services to Dune: -Tipping wizards for providing you a bit of alpha -Access to NFT token gated dashboards for a select group of users -Crowdsource funding on a given topic / spell
@sealaunch_
sealaunch.xyz
1 year
A visualisation of NFT protocol volume share since Sep'21 @opensea dominated the market w/ Wyvern V2+V2.3 until @LooksRare and @the_x2y2 were launched Around Jun'22 Seaport launched. Soon after @blur_io entered the market in Sep'22 stealing a big % of volume from the protocol
Tweet media one
4
0
14
3
1
19
@jphackworth42
J.Hackworth
4 months
@BasedShillBH Ser, Im going to have to arrest you for committing a chart crime. Not only is this chart 10+ days not refreshed but its also likely calculating daily actives at some point during the middle of the day. The actual chart looks alot better and has seen steady growth since 6/2
Tweet media one
2
0
18
@jphackworth42
J.Hackworth
7 months
A question I had: What does the current distribution of ETH look like? A quick estimate shows: -The majority of the supply is sitting idly across thousands of wallets. -10% (and likely more) sits on centralized exchanges ~33% is locked in the Beacon Staking Contract - 2.5%
Tweet media one
3
1
18
@jphackworth42
J.Hackworth
6 months
The number of new tokens appearing on DEXs hit an all-time high the week of 3/11. What is even more interesting is the shift in new tokens launching on Ethereum & BNB to Solana & Base indicating a shift in where attention is happening for this current cycle
Tweet media one
Tweet media two
2
2
18
@jphackworth42
J.Hackworth
1 year
1/ You may have seen that some L1//L2s have seen ATH for active/new addresses in the past few months My first response was potential sybilling / farming to blame? In this analysis, I broke down Layer Zero Usage across chains to answer this question
3
3
17
@jphackworth42
J.Hackworth
1 year
6/ Overall, most activity to date has been mainly around onchain summer NFT minting and Friend Tech. As Base’s ecosystem grows, it will be exciting to see what new projects come to build on Base. To learn more, check out my Base dashboard:
3
0
16
@jphackworth42
J.Hackworth
2 years
Take a look at what’s driving Blurs volume below Just an appetizer served before the main course More on the way!
@0xKofi
Kofi
2 years
53% of Blur's volume comes from just 500 wallets (research by Archmage @jphackworth42 🧙✨) The marketplaces are killing their profits, long-term relationships with creators and future growth prospects to compete for ~500 pro traders
43
99
636
1
1
16
@jphackworth42
J.Hackworth
1 year
One of my first bosses said the quote below to me as being one of the most important skills a data scientist can posses What your audience really cares about is a simple interpretation that they can take action on, not the underlying data technicalities
@flipsidecrypto
Flipside 📊
1 year
"Translate the geek to business" - @jphackworth42 on making your analysis easy to understand 🔥🤯
1
0
8
2
1
17
@jphackworth42
J.Hackworth
2 years
88% of Wallets that received @Optimism 's $OP airdrop have decreased their position by 90%. Was this due to how the airdrop was distributed? Through data science powered by @flipsidecrypto , we can assess this and better predict addresses that do not provide value to the protocol
Tweet media one
3
1
17
@jphackworth42
J.Hackworth
2 years
Comparing @Uniswap metrics against other exchanged /brokerages: -Coinbase Monthly Users: 22.5 Uniswap Users -Robinhood Monthly Users: 32x Uniswap Users -Q3 2022 Coinbase Volume (159B): 1.27x Uniswap Q3 Volume -Jan 5th NASDAQ Volume (175B): 323x Uniswap's Volume
Tweet media one
4
2
13
@jphackworth42
J.Hackworth
2 years
MEV. No one knows what it means. But it’s provocative. It gets the people going. Find out more in my latest dashboard for MEV on @Uniswap
@DuneAnalytics
Dune
2 years
"Everyone's heard of MEV before, but how many people actually understand it? For some it's scary, for some it's sexy, and for some it's money" Nice into to @jphackworth42 's impressive new Uniswap MEV dashboard Check it out
3
5
33
3
2
17
@jphackworth42
J.Hackworth
11 months
So far there have been over 6k addresses to use Coinbase Verification and over 9.3k attestations. Most of the attestations occurred before this announcement. Interesting to see that there are almost 2x the number of coinbase account verifications vs the country verifications
Tweet media one
Tweet media two
@CoinbaseDev
Coinbase Developer Platform🛡️
11 months
Introducing Coinbase verifications – Users can attest to account and country credentials onchain, all verified by Coinbase, now live for our 100M+ users at
Tweet media one
68
185
1K
3
3
16
@jphackworth42
J.Hackworth
2 years
Curious about the increased growth on L2s? My latest @DuneAnalytics dashboard breaking down the metrics, users, and protocols that are driving activity on Ethereum, Arbitrum, & Optimism. Top insights in the 🧵below.
4
2
16
@jphackworth42
J.Hackworth
2 years
1/9 Last week, I won the @uniswapgrants bounty to analyze post airdrop activity on @Uniswap . I looked at three of the biggest drops this year to understand the trends of traders after an airdrop. Check out the insights on how to position yourself for the next big airdrop 🧵
@fedeebasta
Fedeebasta.eth
2 years
🎉 @uniswapgrants Community Analytics - Bounty # 13 winners 🎉 Our community analyzed the impact of 💧Airdrops 💧on Uniswap activity. Kudos to our winners: 🥇 @jphackworth42 🥈 @Bat_Wayne7 🥉 @pennypenny624 👇The insightful analytics and beautiful dashboards👇
2
5
19
2
4
14
@jphackworth42
J.Hackworth
6 months
Me explaining to my girlfriend how today is important because of the Bitcoin Halving My girlfriend explaining to me how today is important because of the new Taylor Swift album
Tweet media one
Tweet media two
3
0
15
@jphackworth42
J.Hackworth
1 year
I created this pseudonym over a year ago to explore the onchain world and quickly fell down the crypto rabbit hole After discussions with @ljin18 @jessewldn @Derekmw23 & @gham1lt0n , it became clear that my interests aligned with the mission of Variant
1
0
16
@jphackworth42
J.Hackworth
8 months
I had an all-time high for onchain transactions this week in my public ens. The reason is simple. The increase in activity on Farcaster + Frames has allowed me to discover more fun things to do onchain. I imagine my weekly transactions will keep increasing as more activity
Tweet media one
2
0
13
@jphackworth42
J.Hackworth
8 months
Interesting looking at the top applications by # of addresses over the past 7 days: - 3 of the top 10 applications are on Near with Kai-Ching having 750k - 1M active addresses per day - 4 of the 10 are stablecoins on various chains Great data as always from @artemis__xyz
Tweet media one
0
1
13
@jphackworth42
J.Hackworth
7 months
Tether has finally surpassed over $100B in market cap
Tweet media one
3
0
14
@jphackworth42
J.Hackworth
10 months
Check out this panel I did at DuneCon where we dive into Data Driven Token Distribution discussing topics around Airdrops, Quests, and more!
@DuneAnalytics
Dune
10 months
TGIF! Grab your coffee and learn about Token Distribution with: 🎙️ @Flynnjamm CEO at @rabbithole_gg 🎙️ @subinium Data Lead at @hashed_official 🎙️ @jphackworth42 Data Wizardy at @variantfund Powered by @agaperste from our #DevRel team 🙏 #DuneCon
4
3
29
1
0
14
@jphackworth42
J.Hackworth
1 year
2/ While Friend Tech has been the breakout app, most activity has been around NFTs In the past 14 days, 47% of addresses have received or done something related to NFTs as part of onchain summer. NFT related activity also composes 24% of the Base’s transactions
Tweet media one
2
0
13
@jphackworth42
J.Hackworth
6 months
I’ve had multiple friends call me up in the past few weeks for me to teach them how to buy memecoins. Some lessons learned: -For the majority of them, it’s their first time using a wallet and first time they have heard of Solana -Crypto UX is still way too confusing. While UX
2
2
13
@jphackworth42
J.Hackworth
1 year
3/ Friend Tech has done over $80M in trading volume and onboarded over 124k total addresses On 8/19 it made up over 54.9% of Base’s transaction fees but activity has since decreased now composing <10% of Base’s fees as volume has fallen off
Tweet media one
Tweet media two
1
0
13
@jphackworth42
J.Hackworth
7 months
My mom called me to ask if I heard about “Dog sniffs Hat” that she read about in the news and why I didn’t tell her about it earlier 🙃
4
0
13
@jphackworth42
J.Hackworth
6 months
Is Axie Back? Ronin Chain has seen explosive growth making it one of the top chains by active addresses with over 1.1M active addresses. Curious to hear if there is a game driving this activity or if it is inorganic
Tweet media one
4
0
12
@jphackworth42
J.Hackworth
1 year
One last note: I’ve chosen to use my real name (Jack) at Variant, but J Hackworth will continue to live on throughout the crypto data landscape!
1
0
13
@jphackworth42
J.Hackworth
2 years
@1kbeetlejuice @flipsidecrypto Wow that is one of the nicest sql tools I’ve seen
1
0
13
@jphackworth42
J.Hackworth
7 months
One of the most exciting opportunities where crypto can accelerate the use cases of AI is data marketplaces. Crypto can help AI bootstrap datasets that are hard to collect by: -Leveraging token incentives for data collection (DePin, DeSci, etc) -Using privacy-preserving tech
1
1
10
@jphackworth42
J.Hackworth
2 years
Check out the competitive analysis I did around @sudoswap on @DuneAnalytics . More insights to come!
@DuneAnalytics
Dune
2 years
Dune Digest #50 is LIVE Analysis on 📈 - Dex Aggregators - Sudoswap's competition - BNB hack - Music NFTs - Linagee & More! Wizardry: - @murathanbagdat - @jphackworth42 - @pandajackson42 - @JamesCliffyz - @SliceAnalytics 🧙‍♂️🧙‍♂️🧙‍♂️ Check it 👇
10
2
21
0
3
12
@jphackworth42
J.Hackworth
2 years
2/ Since 2022, OpenSea went from a 99% volume marketshare to ~30% Increased competition from LooksRare, X2Y2, Sudoswap, & Blur had one major advantage: a token. Whether wash trading on LooksRare or Blur’s volume explosion, users looked to manipulate the system
Tweet media one
1
2
11
@jphackworth42
J.Hackworth
11 months
Weirdly just got this notification that its been two years since I've started this account Its crazy to think how much my life has changed since I started this account as an anon to put my ideas out into the world. May have been one of the best decisions I've ever made
Tweet media one
3
0
12
@jphackworth42
J.Hackworth
3 months
Sometimes I wonder why I have to have tabs open for etherscan, optimistic etherscan, arbscan, lineascan, polygonscan, plus other etherscan based explorers instead of just combining them into one EVMscan site.
2
0
11
@jphackworth42
J.Hackworth
3 months
8/ AI’s onchain presence is growing, hinting at the future of: -Agents dominating onchain transactions -New methods to incentivize AI development -Compensation for new data -Onchain inference Curious to hear of anything else interesting in Crypto x AI!
3
0
11
@jphackworth42
J.Hackworth
3 months
7/ AI inference is driving onchain transactions, notably: -Ora’s AI oracle has 1.7k transactions via opML -Io.Net’s BC8 has had over 30k paid inference transactions on Aptos in the past month As AI makes smart contracts even smarter, inference-related transactions will grow.
Tweet media one
Tweet media two
1
2
11
@jphackworth42
J.Hackworth
2 years
8/ One of the main drivers for Blur was its top users 25 users did 20% of its total volume 250 did 45% 500 did 54% Many of these traders received 1000% boosts to their PnL To win the marketplace wars all you need to do is offer a bit of incentivizing to the top traders
Tweet media one
1
2
11
@jphackworth42
J.Hackworth
6 months
Zora Network seeing a huge spike in transactions today 👀
Tweet media one
1
0
11
@jphackworth42
J.Hackworth
4 months
May saw the highest number of monthly active addresses in crypto with over 51.5M active addresses across EVMs & Solana. Both Solana and the Ethereum + Layer 2 ecosystem saw record highs with 10.16M and 41.38M active addresses respectively
Tweet media one
1
0
10
@jphackworth42
J.Hackworth
2 years
9/9 Overall this was a fun experiment I hope to do this for other airdrops ($OP) and build a standardized model. I think this is a potential way going forward to reward community members who will stay faithful to the community. Code here:
2
1
10
@jphackworth42
J.Hackworth
2 years
@spencernoon @VitalikButerin Would love to see the Math that will take them from ~6700 successful transactions per minute to 100,000 transactions per second
Tweet media one
4
0
10
@jphackworth42
J.Hackworth
2 years
It looks like there is an Ethereum Miner that didn't get the memo. There was one new miner for September 2022. Perhaps trying to go down in history as the last of the 5621+ miners on Ethereum Proof of Work?
Tweet media one
3
1
10
@jphackworth42
J.Hackworth
3 months
2/ Autonolas agents demonstrate that even with ~453 agents acting onchain, their activity generates more transactions than human activity in Gnosis Safes. Agents enable a future of higher efficiency & task coordination, with their output likely to surpass human onchain
2
1
10
@jphackworth42
J.Hackworth
1 year
Celebrating One Year of The Merge 🎉 In past year, we've seen some substantial growth: - Total ETH Staked: 25.6M (+43.7%) - Active Validators: 797,143 (+46.41%) - Total ETH Supply: 120.22M (-0.25%) - % of Network Staked: 20.9% Source: @StakingRewards
1
0
8
@jphackworth42
J.Hackworth
4 months
3/ Hyperlane enables teams to permissionlessly connect chains to create new transfer routes. Notably: - Over 8+ chains are transferring $2M+ in assets weekly - +50% of the volume comes from the cosmos ecosystem such as chains such as Injective, InEVM, and Neutron
Tweet media one
1
0
8
@jphackworth42
J.Hackworth
2 years
Wrote my first on-chain query last year on Christmas. May have been the best Christmas gift I’ll ever recieve.
1
0
9
@jphackworth42
J.Hackworth
1 year
Interesting trend I've seen where L2s have lead to an explosion in the # of mints due to low costs For example, the Bridge to Base NFT has seen over 56M+ mints on Base but only 174k unique addresses minting and 0 ETH in volume (free mint) L2s allow anyone to tap into the fun of
Tweet media one
5
0
9
@jphackworth42
J.Hackworth
2 years
One month after the $BLUR airdrop, engagement seems to have worn off -Active traders have decreased by ~30% -17.7% of airdroppers are still holding $BLUR in their wallet -Only 43% of wallets have been active on Blur since Check out more below:
1
1
9
@jphackworth42
J.Hackworth
2 years
AAVE AAVE AAVE. So nice you say it thrice. Check out my latest work for @MetricsDAO where I cover @AaveAave V3 TVL and historical rates for chains and tokens.
Tweet media one
1
1
8
@jphackworth42
J.Hackworth
2 years
1/5 Built out a dashboard for @flipsidecrypto 's fifa tournament that tracks fees and transactions across L1s/L2s such as Ethereum, Polygon, Arbitrum, Near, Solana, and more. Check out some of my top insights below!
3
2
9